Learn Data Skills

Beta

Ivan John Lloyd Mabao

Ivan John Lloyd Mabao

Data Engineer

Pamantasan ng Lungsod ng Maynila | Silang, Cavite

Technologies

Data guru, harnessing the power of information for actionable insights.

My Work

Take a look at my latest work.

GitHub - FAIengineer/Patient-Waitlist-Power-BI-Dashboard: End-to-end Power BI dashboard featuring a dynamic Folder-based ETL pipeline, advanced DAX for metric switching (Avg/Median), and custom UI design for analyzing patient waitlist trends.

GitHub - FAIengineer/Yelp-Data-Analysis-Python-SQL: Implementation of an ELT data workflow based on a public tutorial, demonstrating expertise in optimized Python data splitting, cloud staging via S3, JSON data flattening in Snowflake, and feature engineering (sentiment analysis) via SQL.

PythonSQLSnowflake

GitHub - FAIengineer/shipment-order-analytics: ETL pipeline using Python + PostgreSQL for the Shipment Orders dataset. Includes automated dataset retrieval (Kaggle API), data cleaning with pandas, and SQL-based analytics using PostgreSQL + pgAdmin4.

GitHub - FAIengineer/Rice-Image-Classification-with-PyTorch-EfficientNet: End-to-end Rice Image Classification pipeline using PyTorch and Transfer Learning (EfficientNet-B0). Achieved 99.91% test accuracy with custom data loading and visualization.

GitHub - FAIengineer/Patient-Waitlist-Power-BI-Dashboard: End-to-end Power BI dashboard featuring a dynamic Folder-based ETL pipeline, advanced DAX for metric switching (Avg/Median), and custom UI design for analyzing patient waitlist trends.

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python for Developers

Understanding Cloud Computing

Understanding Data Engineering

Introduction to Git

Courses

Introduction to Python for Developers

Understanding Cloud Computing

Understanding Data Engineering

Introduction to Git

My Work Experience

Where I've interned and worked during my career.

MBC Media Group | Jul 2024 - Sep 2024

Engineering Intern

• Monitored and maintained real-time broadcast quality and transmission stability across two live channels during daily peak-hour shifts, ensuring zero critical downtime for essential programming. • Executed preventative maintenance and troubleshooting on studio equipment, audio signal paths and antennae systems to ensure continuous operational readiness and minimize technical faults. • Managed and configured the ingress and egress of daily broadcast media materials, streamlining the program setup process

Shinkozan Corporation | Jan 2020 - Mar 2020

Engineering Intern

• Leveraged SolidWorks software to generate 10+ technical 3D models per month, ensuring accurate product specifications for the manufacturing team. • Oversaw and validated the integrity of over 50 technical and regulatory documents per week, ensuring 100% compliance with internal quality control standards. • Executed and maintained critical daily process workflows within Shinkozan's internal database system, resulting in zero data integrity errors over the three-month period. • Managed and analyzed data for over 15 active engineering projects within Excel files to track project milestones and identify key performance indicators (KPIs) for management review.

My Education

Take a look at my formal education

Bachelor of Science in Electronics EngineeringPamantasan ng Lungsod ng Maynila | 2025

About Me

Ivan John Lloyd Mabao

Electronics Engineering graduate aspiring Data Engineer with hands-on experience in Python, SQL, PostgreSQL, Power BI, AWS S3, and Snowflake. Built end-to-end data pipelines, analytics projects, and dashboards with a strong engineering mindset.

Powered by

Create Your Data Portfolio for Free