01/04/2024 updated

**** ******** ****
100 % available

Data Achtect, Data Enginner, Business Intelligence, Data Warehouse

Sao Pedro da Aldeia, Brazil Master of Business Administration - MBA
Sao Pedro da Aldeia, Brazil Master of Business Administration - MBA

Profile attachments

CV_Carlos Renato Soares.docx

Microsoft AzureBusiness IntelligenceBig DataC Sharp (Programming Language)Extract Transform Load (ETL)Data WarehousingApache HadoopMapReduceIBM Cognos Business IntelligencePython (Programming Language)Microsoft SQL ServersSQL AzureVisual Basic .NET (Programming Language)MySQLOracle ApplicationsService-Oriented ArchitecturePL-SQLSQL DatabasesSQL Server Integration ServicesMaster of Business Administration (MBA)Data ScienceSnowflakeApache SparkData LakePysparkStar SchemaDatabricks
Sou um arquiteto de dados sênior experiente, com sólida formação em arquitetura de dados, big data, ciência de dados e liderança. Minha experiência inclui projetar arquiteturas de data lake AWS e Azure, arquiteturas de data warehouse (Top Down, Bottom Up, Intermediate), modelagem multidimensional (Star Schema e Snowflake Schema) e sólidos conhecimentos em Administração de Dados e Integração de Sistemas. Tenho conhecimento em diversas tecnologias, incluindo Hadoop, MapReduce, Spark, PySpark e arquitetura de soluções SOA. Além disso, possuo ampla experiência com serviços de integração REST e SOAP, bem como serviços Azure Cloud como Data Factory, Synapse, Databricks, Gen2, Cosmos DB e Azure SQL Server.

Minha carreira inclui funções como arquiteto e engenheiro de dados na Globant, onde trabalhei na criação de data lakes e visualizações de negócios na nuvem Azure. Também atuei como líder de equipe de ingestão e transformação de dados no AWS Data Lake da Johnson & Johnson. Na WestRock Brasil, implementei um Data Lake em Nuvem AWS e desenvolvi processos ETL utilizando SSIS. Tenho experiência com ferramentas de Business Intelligence, incluindo IBM Cognos, e uma sólida base em programação com linguagens como VB, VB.NET e C# .NET. Além disso, possuo experiência em sistemas SGDB, PL/SQL e T-SQL.

Minha formação educacional inclui Master of Business Administration (MBA) com foco em Big Data e Data Science. Estou continuamente aprimorando minhas habilidades com certificações em aprendizado de máquina, sistemas distribuídos e liderança. Estou empenhado em fornecer soluções de dados de alta qualidade e impulsionar a inovação no campo da arquitetura de dados.

Languages

EnglishFluentPortugueseNative speaker

Project history

Senior Data Architect

Globant

Internet & IT

>10.000 team member

ontractor at: JM Family
Project Description: Create a Data Lake and Business Views in Azure Cloud
Responsibilities: Data Architect and Data Engineer
Tech stack: Working as Data Engineer in Microsoft Azure using the following technologies: Synapses, gathering business rules with the client, defining data ingestion strategies with Azure Data Factory, Cosmos DB, Gen2, Synapses, building solutions for Multidimensional Modeling

Contractor at: Bradesco Bank
Project Description: Create a Lake House in Azure Cloud
Responsibilities: Data Architect and Data Engineer
Tech stack: Work as Data Architect/Data Engineer in Microsoft Azure using the following technologies: Azure SQL Server, Python, Data Factory, PySpark, requirements gathering, create strategies to ingestion and transformation data.

Contractor at Johnson & Jonhson
Client name: Johnson & Johnson
Project Description: Ingest data from Nielsen in J&J Data Lake in AWS Cloud,
Multidimensional Modeling
Responsibilities: Team Leader and Data Architect
Tech stack: Work as Data Architect/Data Engineer in AWS Cloud, using the following technologies: S3, Athena, Data Ingestion with Python and Glue, definition of data load strategies in all layers in AWS. multidimensional modeling in Redshift, Microsoft SQL Server (MDS), Multidimensional Modeling

Senior Integration Architect

Icatu Seguros

Insurance

1000-5000 team member

Main activities:

Main Activities: Documentation and Design of RestFull APIs in the Microsoft Azure platform, definition of the journey of the APIs along the business areas, survey and understanding the scope of the APIs.

SOA: design of integration solutions through architecture.

Senior Data Architect

WestRock

Other

>10.000 team member

Main Activities: Implementation of Data Lake in the AWS Cloud using tools such as S3, Redshift, Glue, ingestion of data in S3 through Apache HIVE and Sqoop, creation of ETL processes with SSIS for API queries to insert data into a Data Warehouse. Dashboard development in Power BI.

Senior Business Intelligence Architect

Triscal Consult

Internet & IT

500-1000 team member

Working at Prudential do Brasil
Main Activities: Maintenance and evolution of the existing Data Warehouse, remodeling to transform the existing Data Warehouse into an Enterprise Data Warehouse. Development of Stored Procedures in T-SQL, transformation of ETL data into SSIS (Integraton Services).

Senior Business Intelligence Analyst

Provider IT & Business Solutions

Internet & IT

500-1000 team member

Contractor Senior Business Intelligence Analyst  at Estácio de Sá. Work with Power Center.

Business Intelligence Analyst

Icatu Seguros

Insurance

Main activities: Data Warehouse architecture definition, multidimensional modeling, report development, dashboard and cubes in IBM Cognos 11, Administration of IBM Congos 11. Training for users and developers.

Senior Business Intelligence Consultant

Accenture Brazil

Internet & IT

1000-5000 team member

Business Intelligence Consultant at Vale. Maintenance of post-production reports in Cognos Report Studio (Report Studio and Activity Report).

Expert Business Intelligence Consulting

Elumini

Internet & IT

250-500 team member

Contractor in (Ipiranga Oil)
Main activities building and maintaining ETL Maps in PowerCenter 9.1.

Business Intelligence Consultant at RioCard / Fetranspor
Key activities included enterprise business intelligence deployment, architecture definition, multidimensional modeling, installation and configuration of IBM Cognos 10, reporting, dashboards, and cubes in IBM Cognos 10.

Expert Business Intelligence Analyst

NetPartners

Internet & IT

500-1000 team member

Business Intelligence Consultant (Vale)
Key activities included IBM Cognos development using Report Studio, Analysis Studio and Transformer, feasibility study, capability and deployment, project documentation, data warehouse modeling, process design for a PoC integrating Microsoft Sharepoint and SAP MDM.

Data warehouse Architect

MJV Consult

Internet & IT

250-500 team member

Contractor at Bradesco Seguros (Insurance and Pension Company)

Main activities: multidimensional modeling (Data Marts and Data Warehouses), project documentation and requirements surveys.

Senior Consultant

Twice Software

Internet & IT

50-250 team member

Cognos BI consultant (Vale)
Main activities include developing Reports, Cubes in Cognos BI 8.1 and acting as team coordinator in a team composed of 6 analysts.

Business Object XI Consultant (Oi)
Main activities included team coordination for the project of migrating Business Objects 6.5 to Business Objects XIr2. The migration included the inclusion of all objects in B.O. 6.5 for the new version, and in some cases there was a need to correct the reports that were converted to Web Intelligence and Crystal Reports.


Business Object XI Consultant (Petrobrás)
Main activities included team coordination in the project to deploy Business Object XI and rebuild all existing objects in the previous version (BO 6.5). Development of a tool using VB.NET and the Business Object SDK to create a book of reports whose execution could be scheduled with a specific date and time, this tool runs Crystal Reports reports and Web Intelligence reports and after execution generates a single document PDF.

Business Intelligence Consultant (Dannemann)
The project was to implement Business Intelligence using a Microsoft solution. Main activities installation and configuration of SQL Server 2005, installation and configuration of the Proclarity server, creating reports in Report Proclarity, ETL in Integration Services and creating Cubes in Analysis Services.

Systems Analyst

TV Cultura

Other

500-1000 team member

Worked as analyst/developer, developing systems using VB, VB.NET, T-SQL and performing systems analysis and design using UML

Systems Analyst

Atos

Internet & IT

5000-10.000 team member

Analyst/Developer at a software factory for Embratel (telecommunications company), developing using VB and PL/SQL and performing systems designing and specification using UML. Software Factory at Shell developing using .NET C# and VB.NET.

Contact form

Log in to get in touch

You need to be logged in to use the contact form.

Sign upLog in