Leonardo M.

Leonardo M.

Senior Data Engineer

Vargem Grande Paulista, Brazil
Hire Leonardo M. Hire Leonardo M. Hire Leonardo M.

About Me

Leonardo is a Senior IT Professional with 15+ years of expertise in building products and services to improve BI and analytics on projects. He architects Big Data platforms to store and process data - delivering ETL pipelines to collect data from various sources, transform and store them, enable stakeholders to consume them through BI and analytics tools, and provide support for multiple cloud solutions.

Work history

UpStack
UpStack
Senior Data Engineer
2023 - Present (1 year)
Remote
  • Build and improve databases, acquire data, ETL/ELT, big data pipelines and deploy cloud services on projects.

  • Administer infrastructure solutions to improve data models, increase data accessibility and foster data-driven solutions for clients.

  • Implement monitoring solutions to ensure data integrity - working closely with engineers, product managers and other stakeholders.

Health IQ
Health IQ
Senior Cloud Data Engineer
2021 - Present (3 years)
United States of America
  • Collect and process data from patented online assessments with varying metrics on the Health IQ platform.

  • Design, build, and test data pipelines with Singer-IO Tap/Target in a mono repo architecture and handle data ingestion processes.

  • Implemented a CDP using a next-gen open-source storage layer and maintained ELT pipelines for sourcing data from multiple sources in a data warehouse.

Cognitivo.ai
Cognitivo.ai
Big Data Expert
2020 - Present (4 years)
São Paulo, Brazil
  • Design and develop pipelines to collect and transform data from multiple sources and consolidate them into data lake layers.

  • Assist customers in building high-quality cloud solutions, migrating on-prem data solutions, processing data, and delivering data warehouses.

  • Built and deployed a PySpark data ingestion pipeline to the Dexco Delta Lakehouse - maintaining production pipelines and feature enhancements.

RocketPower
RocketPower
Lead Data Engineer
2020 - 2022 (2 years)
United States of America
  • Parsed PDF files scrapped from LinkedIn to a trusted bucket in Parquet format on Rocket Power's Data Lake Architecture.

  • Delivered a Python script to tokenize words from resumes into a refined bucket and built a user dashboard.

  • Evangelized and implemented a new DataOps tool to maximize raw data ingestion from multiple ATS platforms - parsing, cleaning, and merging data.

Cargill
Cargill
Lead Big Data Engineer
2019 - 2021 (2 years)
São Paulo, Brazil
  • Provided technical best practices to enhance Cargill's data/analytics team within Brazil and drive quality outcomes on solutions.

  • Maintained the Cargill Big Data environment and mentored dev teams on modern data standards, methods, and techniques.

  • Defined and managed source system files for different BI reports curated from SAP tables and ingested in near real-time to a Cargill Global data lake.

Semantix Brasil
Semantix Brasil
Senior Big Data Engineer / Solution Architect
2018 - 2019 (1 year)
São Paulo, Brazil
  • Designed and defined Lambda architecture within a Big Data ecosystem for clients - providing support and delivering data-driven solutions.

  • Liaised with engineering teams to develop solutions following Big Data and DataOps best practices - handling PoCs and configurations.

  • Worked with the commercial team to design an analytics data lake with data from a recent acquisition and ingested them into the client's data lake.

IBM
IBM
Data Engineer / ETL Specialist
2013 - 2018 (5 years)
São Paulo, Brazil
  • Worked on data collection, migration, and integration solutions from several sources within IBM's Enterprise Data Warehouse.

  • Handled data extraction and manipulation processes to enhance management reporting using multiple IBM-based technologies.

  • Designed and deployed new solutions to migrate existing ETL processes from latitude data integration to IBM DataStage on the project.

Itaú Unibanco
Itaú Unibanco
Senior BI Analyst
2012 - 2013 (1 year)
São Paulo, Brazil
  • Analyzed and reviewed end-user needs to meet the time, scope, and technical requirements of projects.

  • Worked on developing ETL jobs within the bank using DataStage and reports on Cognos.

  • Served as a link between business users and the tech team - managing requirements and resolving issues for the team.

Mondial Assistance Brasil
Mondial Assistance Brasil
Senior BI Analyst
2011 - 2012 (1 year)
São Paulo, Brazil
  • Restructured the underlying architecture for an SAP BO - reviewing and updating reports for enhanced performance.

  • Redesigned the security metrics and built a corporate Data Warehouse to handle monthly performance reports within the company.

  • Provided support for SAP BO and created a new Data Mart to maximize the operations of the Finance/Planning department.

Rhodia
Rhodia
SAP BO Consultant
2011 - 2011
São Paulo, Brazil
  • Utilized the latest SAP-BO Enterprise XI 3.1 to access and manipulate data for EMC² E-Room and Documentum software.

  • Designed and developed reports and provided 3rd-level support for users on different BO applications.

  • Implemented cross-functional business processes, enterprise-wide data warehouses, and other databases.

Crystalis Consulting
Crystalis Consulting
Senior SAP BI Consultant
2010 - 2011 (1 year)
São Paulo, Brazil
  • Contributed solutions to deliver a standard reporting package using Crystal Reports and Xcelsius dashboards that met SAP best practices.

  • Worked on processes to deliver an SAP BPC 7.5 for NetWeaver - configuring multiple modules and solutions.

  • Defined configuration specifications and business analysis requirements to resolve complex issues and provide answers to questions.

CI&T
CI&T
SAP BO Consultant
2010 - 2010
São Paulo, Brazil
  • Designed and implemented solutions to integrate CI&T's SAP BW with new SAP business objects to deliver dashboards and reports.

  • Trained users and consultants within CI&T on SAP BOBJ solutions and how to integrate them with SAP BW systems.

  • Collaborated with business and IT teams to design, build and deploy BI solutions for Bunge Fertilizantes, Embraer, Porto Seguro, and Roche Pharmaceutics.

CSG
CSG
SAP BO Architect
2010 - 2010
São Paulo, Brazil
  • Designed, developed, and integrated Business Objects XI 3.1 with CSG's WBMS platform.

  • Contributed to the definition of multi-dimensional data marts for the CSG Cape Town team - working on ETL processes, documentation, and installation scripts.

  • Implemented the new Business Objects environment for AMX-LDI/Telmex.

BNP Paribas
BNP Paribas
Senior BO Consultant
2009 - 2010 (1 year)
São Paulo, Brazil
  • Served as the subject-matter expert for a 5-member team to create and update BO universes and desktop intelligence reports.

  • Designed and implemented solutions to migrate the client's BO universes and reports to the modern BO XI.

  • Developed new BO XI WebI reports, handled scheduled maintenance of reports, and handled documents on the Version Manager.

Câmara de Comercialização de Energia Elétric
Câmara de Comercialização de Energia Elétric
BO Analyst
2007 - 2009 (2 years)
São Paulo, Brazil
  • Provides solutions to create, update, and maintain Universes on BO Designer 6.5.

  • Designed, deployed, and maintained Desktop Intelligence reports and worked on PL/SQL procedures on Oracle DB.

  • Collaborated on enhancing dimensional modeling processes on the project using Erwin software for CCEE.

Mondial Assistance Brazil
Mondial Assistance Brazil
BO Analyst
2006 - 2007 (1 year)
São Paulo, Brazil
  • Worked with directors and managers to collect, analyze, and define requirements for different BI solutions.

  • Mapped and maintained KPIs and performance metrics within the company.

  • Managed the Sybase database on the project for Mondial through data analysis and identification of implementation barriers.

gA
gA
SAP BI/BO Consultant / Helpdesk Support Consultant
2002 - 2006 (4 years)
São Paulo, Brazil
  • Led tasks to identify and analyze user requirements, procedures, and problems to improve existing BO and SAP BW processes.

  • Resolved issues and identified opportunities for process redesign and improvements on projects.

  • Provided English and Spanish on-call support for the offshore helpdesk at Grupo ASSA.

Portfolio

Data Engineer - Cognitivo AI
Data Engineer - Cognitivo AI

Designed, built, and deployed new solutions to migrate Cognitivo's existing Airflow Python workflows to ingest data properly from Redshift to a Jobs/Workflow in PySpark within a Delta Lakehouse platform in Databricks on AWS.

Data Engineer - Cognitivo AI
Data Engineer - Cognitivo AI

Devised strategies and implemented solutions to move Cognitivo's on-premise Postgres databases to the cloud in RDS using AWS DMS service with S3 and Glue jobs to dedup parquet files and store data in Redshift.

Lead Data Engineer - Cargill Agriculture
Lead Data Engineer - Cargill Agriculture

Led Cargill's data team to design, deploy and maintain a SingleStore in-memory database cluster using AWS EC2 and handled migration in Batch Spark jobs data from a Hive/Impala storage to the SingleStore database. Utilized Kafka topic to collect data using Spark Streaming to collect and store data on the project.

Education

 IBM DataStage on Cloud Infrastructure - 2017; IBM DataStage Batch Processing - 2017; IBM DataStage Developer - 2017
IBM DataStage on Cloud Infrastructure - 2017; IBM DataStage Batch Processing - 2017; IBM DataStage Developer - 2017
IBM
2018 - 2018
Watson Analytics - Level 1; Cognitive Practitioner; Big Data Foundation - Level 1; NoSQL and DBaaS 101; IBM DataStage Data Transformation - 2017; IBM DataStage Combining Data - 2017; IBM Cloudant Developer Essentials; IBM Blockchain Essentials; Bluemix Essentials; IBM DataStage Group Processing - 2017; IBM DataStage Database Transaction Processing - 2017
Watson Analytics - Level 1; Cognitive Practitioner; Big Data Foundation - Level 1; NoSQL and DBaaS 101; IBM DataStage Data Transformation - 2017; IBM DataStage Combining Data - 2017; IBM Cloudant Developer Essentials; IBM Blockchain Essentials; Bluemix Essentials; IBM DataStage Group Processing - 2017; IBM DataStage Database Transaction Processing - 2017
IBM
2017 - 2018 (1 year)
IBM Design Thinking Practitioner; Big Data Foundations
IBM Design Thinking Practitioner; Big Data Foundations
IBM
2016 - 2016
Master's Degree in Business Administration
Master's Degree in Business Administration
Universidade Metodista de São Paulo
2014 - 2015 (1 year)
MBA of Competitive Intelligence (BI/CPM), Data Mining using the CRISP-DM methodology
MBA of Competitive Intelligence (BI/CPM), Data Mining using the CRISP-DM methodology
Faculdade de Informática e Administração Paulista
2007 - 2008 (1 year)
BSc. Computer Science, Business Intelligence, Data Marts, ETL, & Dimensional Modeling
BSc. Computer Science, Business Intelligence, Data Marts, ETL, & Dimensional Modeling
Universidade Metodista de São Paulo
2002 - 2005 (3 years)