Leonardo Guzman

Built ~20 dashboards and reports in Power BI and Microsoft Report Builder tracking platform usage, student performance and learning trends for thousands of students. Extracted, transformed and analyzed large datasets with SQL to deliver actionable insights to educators and stakeholders.

Taught Programming Languages and Data Structures; designed course materials, assignments and evaluations.

Developed ~30 reports in Microsoft Report Builder for finance and management teams to monitor financial transactions and fund usage, enabling immediate detection of errors. Designed and optimized SQL queries to extract and validate financial and user activity data, and supported data warehouse reporting through data modeling and integration.

Led data validation and quality checks for the migration of millions of voter, petition and location records for a US state from SQL systems to Snowflake. Ensured historical data was stored correctly and kept distinct from current data; fixed extraction and transformation errors, organized warehouse tables for faster report access, and built Tableau and Report Builder dashboards for stakeholders.

Replaced Excel-based analysis with an automated workflow for two years of hourly, per-device electricity data from ~100 households. Automated data integration pipelines, improving data quality, reporting reliability and efficiency while reducing manual processing, and built ~10 Power BI dashboards plus static charts for the yearly report.

Migrated and optimized SQL processes into C# for credit scoring and financial analysis, cutting processing time from 16 hours to 20 minutes. Automated data extraction and transformation workflows to improve operational efficiency.

Cleaned and analyzed large datasets for credit scoring and loan repayment prediction; built ML models that improved identification of high-risk borrowers by 11%.

Detected outliers and improved data quality for credit scoring models; led modeling end to end, increasing risk prediction accuracy by 12%.

Google Data Analytics Professional Certificate in progress.

Research internship in Machine Learning and Data Mining with scholarship.

M.Sc. in Computer Science with full scholarship.

B.Sc. in Computer Science.