Alex Sandro Martins de Paula Arão
São Paulo
Summary
Detail-oriented Data Engineer with over 9 years of experience in designing, developing data project and maintaining scalable data pipelines and ETL processes. Proficient in SQL, Power BI and big data technologies such as Databricks, Snowflake and Spark. Demonstrated expertise in data warehousing, data modeling, and cloud-based data solutions. Strong problem-solving skills and a passion for optimizing data workflows to support business analytics and decision-making.
Overview
9
9
years of professional experience
Work History
Data Engineer
Foursys
11.2023 - Current
- Participate in construction of new data engineering platform, performing data migration on-premises, extracting information from various sources via NiFi
- Develop ingestion pipelines with DBT, design ETL and ELT processes, and create queries and stored procedures with SQL Server, including tuning and process optimization
- Orchestrate data loads using Airflow, and design project architectures for data lakes and data warehouses
- Gather technical and business requirements and develop detailed dashboards for continuous monitoring of data loads and system performance
- Technologies: DBT, NiFi, SQL Server, Airflow, Power BI, Linux, GitLab
Data Engineer
Unimed University
01.2023 - 11.2023
- Worked as consultant with objective of building robust data platform for classification of management information
- Responsibilities included designing architecture for data ingestion, building data ingestion pipelines and ETL/ELT processes, creating queries, stored procedures, and views using SQL
- Additionally, performed data transformations with Python and Snowpark and implemented cloud solutions using Snowflake and Azure Data Factory
- Technologies: Snowflake, SQL, Python, Snowpark, Azure Data Factory
Data Engineer
Via Varejo
10.2018 - 01.2023
- Be part of Big Data & Analytics team, performing the tasks about support of Business Intelligence routines in the production environment
- Development ETL routines with Integration Services (SSIS), tuning queries in SQL Server and Oracle, creation of views and stored procedures, data extraction, manipulation of multidimensional cubes, construction of reports and dashboards, design Data Warehouse and Data Lakes, migration of on premise data resources to cloud, developing data ingestion, ETL routines with python and pyspark using databricks, creation of data pipelines for process automation
- Technologies: Databricks, Pyspark, Azure data Factory (ADF), SQL Server, Integration Services (SSIS), Analysis Services(SSAS), Reporting services(SSRS), Oracle.
Data Engineer
Grupo Recovery
10.2021 - 05.2022
- Act as a consultant to compose the data engineering area, assisting in the data migration strategy from the on premise environment to cloud, the activities performed were construction of processes and improvement of daily loads for ingestion of tables, scripts development with Databricks, creation of pipelines using azure, sustaining in production environment, creation ETL routines, tuning queries in SQL Server and stored procedures, report extraction and assistance in the architecture design for the construction of a Data Lake
- Technologies: Azure Databricks, Azure Data Factory (ADF), Pyspark, SQL Server, SQL Server Integration Services (SSIS) and Git.
Business Intelligence Analyst
Chevrolet
04.2021 - 08.2021
- Act as a consultant participating in the complete cycle of the Business Intelligence project, focusing on the data visualization layer, conducting the ETL steps, creating Dashboards and queries in SQL Server, sustaining projects and visualization process about data existing in production environment
- Technologies: Power BI, SQL Server, Integration Services (SSIS) and SharePoint.
- Developed intelligence-sharing dashboards, providing company-wide access to collected data.
Business Intelligence Analyst
Amil international Medical Assistance
02.2017 - 10.2018
- Act in business Intelligence projects participating in a complete cycle of projects from user interview to data visualization, Design data warehouse, creation ETL routines for data loading, development querys SQL, views and stored procedures, creation of jobs for process automation, perform queries on multidimensional cubes, creation of analytical reports and dashboards, data integration with sharepoint doing creation of sites and lists
- Technologies: Integration Services (SSIS), Analysis Services(SSAS), Reporting Services(SSRS), SQL Server, Oracle, Sharepoint e Parallel Data Warehouse(PDW).
SQL Developer
Interplayers Soluções integradas
07.2016 - 01.2017
- Participate in projects for companies in pharmaceutical industry working in development of business rules for database, developing stored procedures, creating queries, triggers, views, functions, tuning, XML manipulation, log analysis and data integration with application systems
- Technologies: SQL Server, dbForge Decryptor and SQL Server Profiler.
Business Intelligence Analyst
Seven Pdv
12.2015 - 07.2016
- Work in Business intelligence team performing development of sql queries, creation of dashboards and management reports, data analysis and communication with users
- Technologies: SQL Server, Excel, Power Point.
Education
Bachelor of Systems Analysis and Development -
Federal Institute of São Paulo
São Paulo - Brazil12.2019
Skills
- Big Data Tools: Databricks, Snowflake, Spark
- ETL Tools: Apache Nifi, DBT, SQL Server Integration Services(SSIS), Azure Data Factory
- OLAP Tools: SQL Server Analysys Services(SSAS)
- Data Visualization : Power BI, SQL Server Reporting Services(SSRS)
- Cloud Platform: Azure
- Programming Languages: SQL, Java, Python, Pyspark
- Database: SQL Server, Oracle, PostgreSQL
Accomplishments
➢ Certification course of Programming with Python
➢ Certification course Implementing an Azure Data Solution (DP-200)
➢ Certification course Designing an Azure Data Solution (DP-201)
➢ Immersion Power BI
➢ Big Data Fundamentals
➢ Business Intelligence SQL - ETL Integration Services 2016
➢ Business Intelligence - SQL Server e Analysis Services 2016
➢ Java for web development
➢ Java and Object Oriented
➢ Logic Programming with Java Script
Languages
Portuguese
Bilingual or Proficient (C2)
English
Advanced (C1)
Spanish
Advanced (C1)
Timeline
Data Engineer
Foursys
11.2023 - Current
Data Engineer
Unimed University
01.2023 - 11.2023
Data Engineer
Grupo Recovery
10.2021 - 05.2022
Business Intelligence Analyst
Chevrolet
04.2021 - 08.2021
Data Engineer
Via Varejo
10.2018 - 01.2023
Business Intelligence Analyst
Amil international Medical Assistance
02.2017 - 10.2018
SQL Developer
Interplayers Soluções integradas
07.2016 - 01.2017
Business Intelligence Analyst
Seven Pdv
12.2015 - 07.2016
Bachelor of Systems Analysis and Development -
Federal Institute of São Paulo
Similar Profiles
Paula Miranda AlbuquerquePaula Miranda Albuquerque
Attending Pediatric and Neonatal Anesthesiologist at Hospital das Clínicas and Instituto da Criança e do Adolescente of University of São PauloAttending Pediatric and Neonatal Anesthesiologist at Hospital das Clínicas and Instituto da Criança e do Adolescente of University of São Paulo
Diogo Fernando MariaDiogo Fernando Maria
Analista de logística at Lumiar HealthCareAnalista de logística at Lumiar HealthCare
Josiane Rodrigues Da SilvaJosiane Rodrigues Da Silva
Lider at Higiênico Higienização E serviço LTDALider at Higiênico Higienização E serviço LTDA