Loading profile…
Leonardo Guzman
Looking for a jobData Analyst
Data Analyst in BI and reporting who validated a Snowflake migration of millions of records and built dashboards across finance, energy, and education.
PeruData Analyst at InnovarITP
About
At Provista Software Corporation, I led data validation and quality checks for a Snowflake migration of millions of voter, petition, and location records. I also organized warehouse tables and built Tableau and Report Builder dashboards for stakeholders.
At Conexiona, I replaced Excel-based analysis with automated workflows for hourly electricity data from about 100 households, then built Power BI dashboards to show usage trends and operational insights. At InnovarITP, I built about 20 dashboards and reports tracking platform usage, student performance, and learning trends.
My work has also covered financial reporting and credit risk. I’ve developed SQL-based reports and data workflows, and built machine-learning models for credit scoring and loan repayment prediction.
Experience
Data Analyst
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.
Power BIMicrosoft Report Builder (Paginated Reports)SQLData AnalysisDashboarding
Lecturer, Programming & Data Structures
Taught Programming Languages and Data Structures; designed course materials, assignments and evaluations.
TeachingProgrammingData Structures
Data Analyst
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.
Microsoft Report Builder (Paginated Reports)
Education
Google
Google Data Analytics Professional Certificate in progress.
Polytech Nice Sophia
Research internship in Machine Learning and Data Mining with scholarship.
Universidad Católica San Pablo
M.Sc. in Computer Science with full scholarship.
Universidad Nacional de San Agustín
B.Sc. in Computer Science.