Profileimage by Carlos Soares Data Achtect, Data Enginner, Business Intelligence, Data Warehouse from SaoPedrodaAldeia

Carlos Soares

available

Last update: 04.01.2024

Data Achtect, Data Enginner, Business Intelligence, Data Warehouse

Graduation: Master of Business Administration - MBA
Hourly-/Daily rates: show
Languages: English (Full Professional) | Portuguese (Native or Bilingual)

Attachments

CV-Carlos-Renato-Soares_040124.docx

Skills

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.

Project history

01/2022 - Present
Senior Data Architect
Globant (Internet and Information Technology, >10.000 employees)

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

10/2015 - 01/2024
Senior Integration Architect
Icatu Seguros (Insurance, 1000-5000 employees)

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.

08/2021 - 01/2022
Senior Data Architect
WestRock (Other, >10.000 employees)

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.

09/2019 - 08/2021
Senior Business Intelligence Architect
Triscal Consult (Internet and Information Technology, 500-1000 employees)

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).

05/2019 - 09/2019
Senior Business Intelligence Analyst
Provider IT & Business Solutions (Internet and Information Technology, 500-1000 employees)

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

03/2014 - 10/2015
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.

10/2013 - 03/2014
Senior Business Intelligence Consultant
Accenture Brazil (Internet and Information Technology, 1000-5000 employees)

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

11/2011 - 10/2013
Expert Business Intelligence Consulting
Elumini (Internet and Information Technology, 250-500 employees)

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.

04/2009 - 11/2011
Expert Business Intelligence Analyst
NetPartners (Internet and Information Technology, 500-1000 employees)

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.

06/2008 - 05/2009
Data warehouse Architect
MJV Consult (Internet and Information Technology, 250-500 employees)

Contractor at Bradesco Seguros (Insurance and Pension Company)

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

04/2006 - 06/2008
Senior Consultant
Twice Software (Internet and Information Technology, 50-250 employees)

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.

06/2005 - 04/2006
Systems Analyst
TV Cultura (Other, 500-1000 employees)

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

05/2004 - 01/2005
Systems Analyst
Atos (Internet and Information Technology, 5000-10.000 employees)

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.

Local Availability

Only available for remote work
I believe that in 2 week I'm available.
Profileimage by Carlos Soares Data Achtect, Data Enginner, Business Intelligence, Data Warehouse from SaoPedrodaAldeia Data Achtect, Data Enginner, Business Intelligence, Data Warehouse
Register