At Fundación Semillas de Amor SEMDA, I designed and implemented a PostgreSQL database for donations, donors, and donation types. I also centralized donation information in a system that generated reports of donations received and delivered.
For my executive commercial profitability dashboard project, I analyzed more than 22,400 sales records across 36 countries using Python and Pandas, then transformed the data in Power Query and built a Power BI dashboard with DAX metrics. I identified that the year-over-year margin fell from 60.1% to 55.8% between 2020 and 2022 despite revenue growth.
In a renewable energy project, I developed a Python process to extract, clean, transform, and load data, validated its quality, and modeled it in PostgreSQL with SQL. I also built an interactive dashboard to analyze renewable electricity generation over time.
For a global production reporting project for Vantek Manufacturing, I used Power Query and DAX to analyze 31,616 production orders from eight plants. My dashboard highlighted quality and productivity indicators, including the lowest productivity rate in France and a seasonal production decline.
