Leonardo A.
Data Analyst

Skills

Airflow

Sql

Microsoft Excel (Advanced Analytics Add-ons)

Microsoft Sql Server

Python

Postgresql

Leonardo is available for hire

Hire Leonardo A.

All Howdy Candidates are vetted for skills and english proficiency.

Bio

Specialist in data analysis and visualization with notable expertise in Microsoft Power BI for dashboard creation. Proficient in developing data pipelines with a strong foundation in Airflow for orchestration, SQL database management, ETL processes, and report design to enhance analytics outcomes. Skilled in automating data extraction and adept in utilizing project management tools such as Jira. Expertise in data manipulation is demonstrated with Python, Pandas, PySpark, PostgreSQL, and Google Big Query. Experienced with Power Query, DAX, API integration, web scraping, data visualization tools including Power BI, Looker, and Tableau, as well as SQL and No-SQL databases such as PostgreSQL, SQL Server, MySQL, and MongoDB. Familiarity with Agile methodologies, specifically Scrum and Jira, is complemented by formal education comprising a Bachelor's degree in Mechanical Engineering and an MBA in Finance. Additional technical capabilities encompass Terraform, Docker, Kubernetes, dbt, Azure Databricks, and Azure Data Factory.

Data Analyst
7/1/2022 - Present

Transformed complex data into appealing visualizations and interactive Power BI reports, effectively communicating key insights to stakeholders and increasing the bid success rate by 25%. Deployed robust security measures, including Row-Level Security (RLS), to protect sensitive data within Power BI dashboards, ensuring compliance with data privacy regulations and safeguarding against unauthorized access. Simplified data acquisition by building automated data extraction pipelines using Python and Airflow, extracting over 25 million lines from various sources, enabling informed decision-making. Utilized advanced SQL techniques for data cleaning, transformation, and aggregation tasks, ensuring data accuracy and preparing data sets for effective analysis. Developed automated data extraction scripts from PDFs using Python, significantly reducing manual effort and speeding up data retrieval from PDF files, enabling faster data analysis and decision-making. Leveraged Jira collaboration tools to facilitate communication and task delegation among team members, fostering a structured and collaborative workflow.
Data Analyst
10/1/2021 - 4/1/2023

Applied expertise in web scraping with Python, APIs, and JSON to efficiently collect data from various sources, resulting in a 15% reduction in product losses. Demonstrated proficiency in importing and manipulating data using Python and Pandas, which ensured the maintenance of high data quality and integrity during analysis. Facilitated effective data storage and retrieval for analytical purposes through the use of PostgreSQL and Google BigQuery. Designed and managed visually engaging reports for data visualization using Google Data Studio and Power BI, significantly enhancing stakeholders' understanding of the data.