Arthur Luz

The project consisted in the development of a Data Warehouse environment to analyze the consumption of software licenses used in the entire Caixa Econômica Federal corporate environment. This was developed using the Microsoft SQL Server 2016 suite of tools (SQL Server, SSIS, SSAS Tabular Mode, and SSRS Paginated Report).

Responsible for restructuring ANEEL's Data Warehouse architecture using the tools of the Microsoft SQL Server 2016 suite (SQL Server, Integration Services, Analysis Services - Tabular Mode, Data Quality Services and Reporting Services Mobile and Paginated report) and, for Data Discovery and Data Exploration the SAS suite.

The project consisted of the creation of the logical and physical relational model of the task control system, progress and processes of the law firm Lima Jr. The model was created observing the best practices of relational modeling, which is also prepared for the future implementation of the system Business Intelligence team.

O Data Warehouse tem como intuito fornecer para o cliente a análise de propostas de seguro vendidas em todo o Brasil. O projeto foi desenvolvido com base nas melhores práticas de construção de Data Warehouse (Kimball e Inmon) usando as ferramentas da microsoft. Para atender a demanda de consumo de mais de 7000 usuários, os paineis de análise Web e Mobile foram construídos na nova ferramenta de Análise de Dados da Microsoft, O Datazen.

O Projeto consistiu em implementar ao ETL do Sistema de Business Intelligence do Sebrae Nacional o processo de carga das metas de Atendimento referentes ao ano de 2015.

Nesse projeto foi realizada a análise e adequação de recursos de hardware e software, a definição de arquitetura de integração de dados e governança de dados - Gerenciamento de metadados.

Construção da camada semântica para os Data Marts relacionados ao Data Warehouse do SIAFI (Sistema Integrado de istração Financeira do Governo Federal) e elaboração de relatórios e dashboars (web e mobile) utilizando a ferramenta OLAP MicroStrategy.

O projeto envolveu todas as fases do processo de criação de um Data Warehouse. Fora feito a
análises de requisitos, a modelagem dimensional - Star Schema, o MEX, a construção do ETL usando SSIS, a criação de Jobs para automatização dos processos de carga de ETL, a validação dos dados, a criação de cubos para análises, os relatórios e dashboards com as ferramentas Tableau Desktop e Power BI, a documentação do projeto e criação do Metadado.

With the intention of modernizing the processes and infrastructure with respect to the BI and Advanced Analytics universe, Icatu Seguros, in partnership with Dadoteca, created the Data and Analytics Intelligence team.

I currently work as a data architect and data engineer on the Big Data project. The entire Big Data project is being developed on Microsoft Azure with the tools: Attunity, Azure Data Lake Storage Gen 2, Azure Data Factory, Azure Databricks, Azure SQL Database, Azure… Mostrar más

With the intention of modernizing the processes and infrastructure with respect to the BI and Advanced Analytics universe, Icatu Seguros, in partnership with Dadoteca, created the Data and Analytics Intelligence team.

I currently work as a data architect and data engineer on the Big Data project. The entire Big Data project is being developed on Microsoft Azure with the tools: Attunity, Azure Data Lake Storage Gen 2, Azure Data Factory, Azure Databricks, Azure SQL Database, Azure Analysis Services and Power BI. The entire project is automated using the concepts of Continuous Integration and Continuous Delivery (CI / CD) using Azure DevOps. Mostrar menos

In order to improve the data load related to data from Serpro for a project to analyze the Federal Government's purchasing data, MPOG generated a demand for Data's Light. The project's final solution consumes information from the Serpro database and inserts it into an internal Data Lake of the Ministry of Planning to provide input to the open purchasing API data.

With the objective of better managing the use of its server park in Brazil as well as being able to check the evolution of its physical resources over time, taking into the control of spending on these assets, Bunge's infrastructure area generated a demand for a project for Server Environment Management.

The project's final solution consumes information from the System Center Configuration Manager (SCCM) and validates it using data from the System Center Operation Manager. The… Mostrar más

With the objective of better managing the use of its server park in Brazil as well as being able to check the evolution of its physical resources over time, taking into the control of spending on these assets, Bunge's infrastructure area generated a demand for a project for Server Environment Management.

The project's final solution consumes information from the System Center Configuration Manager (SCCM) and validates it using data from the System Center Operation Manager. The loading process was automated and currently all reports extract data from a Data Warehouse that is processed through data integration, cleaning, transformation and loading. Mostrar menos

I participated in the team responsible for the construction of the BI project of Mercedes Benz - Brazil where I was technically responsible for the construction since the beginning of one of the stages of the project. In this stage, the entire financial analysis environment of Mercedes was developed (Balance Sheet Reports and Management Results Demonstration - for example)

Project description- Understanding OLTP Environment
- OLAP Database Server Configuration
- Creating Data Warehouse Model
- Creation of the ETL Process
- Process Validation and Optimization
- Development Reports on PoweBI, DataZen, and SSRS

Creating an end-to-end BI Project

- Understanding business rules
- Interview and identification of the areas about the needs
- Understanding of the OLTP environment
- Configuration of the OLTP environment and SQL Server
- Data Warehousing and Data Marts creation
- ETL process in 3 Stages with Stage, ODS and DW
- Added DataZen reports for visualization