Justin De Guia

Partner with leadership to define growth metrics, build retention analyses, and deliver performance reports. Diagnose data pipeline issues and conduct cohort analysis using BigQuery.

Supported data governance and integrity in Snowflake data models, resolving foreign key inconsistencies and aligning business requirements with data models.

Analyzed A/B test results, monitored Airflow DAGs, refactored dbt models, and built LookML dashboards to empower stakeholders with self-serve analytics.

Conducted portfolio contribution analysis and built SQL and Power BI reporting to track performance drivers, identifying a ~2% variance in return attribution.

Built fraud detection analysis, tracked shipment performance, and optimized SQL dashboards to improve delivery performance and resolve bottlenecks.

Developed ML forecasting models for solar irradiance, built an IoT weather station, and co-authored three IEEE-published papers on ML-based solar forecasting.

Lectured on data analysis methodologies and supervised thesis projects, improving students' research quality and academic rigor.

Grade: CGPA: 3.9

Completed academic coursework for a Master's in Electronics Engineering with a major in Artificial Intelligence; thesis in progress. Achieved a CGPA of 3.9.

Completed the Introduction to Data Science Track, a DOST-PCIEERD sponsored Data Science course via Coursera, focusing on R Programming.

Grade: CGPA: 2.25

Earned a Bachelor of Science in Electronics and Communications Engineering with a CGPA of 2.25.