At Great Deals E-Commerce Corporation, I built Snowflake and dbt Silver and Gold models for platform-fee data, standardizing Lazada, Shopee, and TikTok records into an effective-dated SCD Type 2 dimension.
I also built a Python and pandas reconciliation tool that compared 107,160 Shopee Seller Center export rows with API-sourced Snowflake data, classifying exceptions for review. I corrected a QuickSight KPI overstated by 58% by rebuilding its Snowflake reporting view and allocating monthly account targets across assigned employees.
For CPAI sales-conversion analytics, I built 13 Bronze, Silver, and Gold dbt models with incremental processing and Airflow orchestration, supplying Gold data to QuickSight and Streamlit. I also manage Snowflake access and automated EMS mailbox creation, reducing an estimated 30-account batch from 150 minutes to about two minutes.
Before this, I worked as a Surveillance Operator at Solaire Resort North, monitoring gaming and cash-handling operations and documenting compliance and incident records while handling 30–80 inbound calls per shift. I hold a Bachelor of Science in Computer Engineering from STI College Ortigas – Cainta.
