2025 – Present
Professional Development
Google Data Analytics Professional Certificate (in progress), plus courses in big data, BI tools and cloud data platforms.
Data Analyst | BI & Reporting
Leonardo Guzmán
I turn messy data into dashboards, pipelines and reports that teams can trust, across finance, energy, education and the public sector.
5+ yearsin BI, reporting and data warehousing
16 h → 20 mincredit-scoring processing time after a SQL-to-C# migration
Millionsof records validated in a SQL-to-Snowflake migration
+11% / +12%better risk identification and prediction accuracy in credit models
About
Data Analyst with 5+ years of experience in BI, reporting and data warehousing across finance, energy, education and the public sector. My background in machine learning and credit risk (M.Sc. in Computer Science) gives me a strong foundation in modeling and data quality.
I work mainly with SQL, Python, Snowflake, Power BI and Tableau. Highlights include validating a Snowflake migration of millions of records and replacing manual Excel workflows with automated pipelines and dashboards. Based in Peru, I’m available on US Eastern hours for remote contract roles.
Outside work, I train MMA and grow carnivorous and aquatic plants. My interest in MMA led to the UFC project below.
Skills
BI & Reporting
Power BI, Tableau, Microsoft Report Builder, Excel (DAX)
Databases & Warehousing
SQL, T-SQL, Snowflake, data modeling
Big Data
Apache Spark, PySpark, Spark SQL
Programming & ML
Python (pandas, scikit-learn), C#, C++, Git
Data Work
ETL pipelines, data validation, data wrangling, workflow automation, predictive modeling
Cloud & Methods
AWS and Azure (foundational), Agile, Scrum
Projects
Tap or Knockout? How UFC fights end, by weight class
An analysis of UFC fights (2011 to 2025) on how fights end, which submissions dominate, and how weight class shapes the finish, with a written case study and an interactive dashboard.
- Submissions end about 18% of fights, and the rear-naked choke alone is over 40% of them.
- Heavyweights finish by KO/TKO almost twice as often as flyweights (49.2% vs 23.5%).
- The submission rate has stayed between roughly 15% and 20% every year since 2011.
Experience
Oct 2024 – Feb 2025
Data Analyst · InnovarITP
Built about 20 dashboards and reports in Power BI and Report Builder on platform usage, student performance and learning trends for thousands of students.
Used SQL on large datasets to deliver insights to educators and stakeholders.
May 2024 – Sep 2024
Data Analyst · Pockit
Developed about 30 Report Builder reports for finance and management to monitor transactions and fund usage, enabling immediate detection of errors.
Designed and optimized SQL queries; supported data warehouse reporting through modeling and integration.
May 2023 – Apr 2024
Data Analyst · Provista Software Corporation
Led data validation and quality checks for a migration of millions of voter, petition and location records for a US state from SQL systems to Snowflake.
Organized warehouse tables so reports could access data faster; built Tableau and Report Builder dashboards.
Mar 2023 – Dec 2024
Lecturer (part-time) · Universidad La Salle
Taught Programming Languages and Data Structures; designed course materials, assignments and evaluations.
Jun 2022 – Apr 2023
Data Analyst · Conexiona
Replaced Excel-based analysis with an automated workflow for two years of hourly, per-device electricity data from about 100 households.
Built about 10 Power BI dashboards and static charts for the yearly report.
Mar 2021 – May 2022
C# Developer · CreditoReal
Migrated SQL processes into C# for credit scoring, cutting processing time from 16 hours to 20 minutes.
Mar 2020 – Feb 2021
Data Scientist · InnovarITP
Cleaned and analyzed large datasets for credit scoring; built ML models that improved identification of high-risk borrowers by 11%.
Oct 2019 – Feb 2020
Data Scientist · Tecno Creditos S.A.C. (Apurata)
Detected outliers and improved data quality for credit scoring; led modeling end to end, increasing risk prediction accuracy by 12%.
Education
2018
M.Sc. in Computer Science
Universidad Católica San Pablo (full scholarship)
Jan – Apr 2018
Research Internship, Machine Learning & Data Mining
Polytech Nice Sophia, France (scholarship)
2016
B.Sc. in Computer Science
Universidad Nacional de San Agustín
Languages
Spanish (native), English (C1)
Certificate of Proficiency
Contact
Open to remote contract roles on US Eastern hours. The quickest way to reach me is email.