Leonardo A.

Data Engineer

Senior Business Intelligence Analyst
1/1/2022 - Present

Developed proficiency in performing queries on structured databases using SQL for generating data reports. Utilized ETL tools and Data Pipeline within Azure Synapse for creating data ingestion and transformation flows. Conducted analysis and requirements gathering for new BI projects and KPIs, handling SQL queries and data from various sources via M language and Power BI dataflows. Developed metrics, columns, and calculated tables using DAX language, and created visuals with Power BI in line with defined business rules, adhering to best practices in storytelling. Migrated data from multidimensional cubes to tabular cubes via SSAS and maintained both models. Managed and tracked projects with clients using agile methodology.

Quality Assistant
10/1/2014 - Present

Developed proficiency in data processing and dashboard creation using Power BI to deliver critical business information for decision-making. Created comprehensive dashboards including Customer Complaints, highlighting units complained about by product, country, number of sales, PPM of complaints, evaluation results of the returned products, and TOP 5 complaint reasons. Produced detailed metrics dashboards for the main customer relationship, covering the number of products manufactured, inspected, rejected, and reasons for rejections, including associated costs and inventory details. Designed dashboards for managing internal rejection controls viewable by product, process, and type, among others, alongside bespoke dashboards tailored to organizational requirements for data visualization.

Executed the validation of computerized systems with a significant impact on BPx by conducting risk analyses to identify potential risks of new software implementations. Developed and performed manual test scripts to challenge system functionalities and prepared validation closure reports. Implemented and managed systems in compliance with data integrity requirements as per 21 CFR Part 11.

Production Engineering at Ritter dos Reis University Center
2019 - 2022

Data Science at Ritter dos Reis University Center
2023 - 2023

Microsoft Certified: Power BI Data Analyst Associate at Microsoft
12/1/2022

Data Integrity - ISPE Records and Data Integrity, fully aligned with the requirements of RDC 301/2019 and PIC/S PI-041-1 guide at ISPE
9/1/2021

Lean Six Sigma Yellow Belt at Yokoten Desenvolvimento Pessoal e Empresarial
5/1/2021

Electronic Spreadsheet Validation at ISPE
11/1/2020

Validation of Computerized Systems following GAMP 5® at ISPE
10/1/2020