I design analytics-ready data systems that transform raw operational data into structured, scalable warehouse models.
With a background in customer support program management, I understand business processes deeply — and now specialize in translating those processes into dimensional models, ELT workflows, and cloud-based analytical architectures.
My work focuses on SQL-driven ELT transformations, layered warehouse design (RAW → STAGING → CURATED), fact-grain control, cohort modeling, and semantic BI validation.
- Dimensional Modeling (Star Schema)
- Fact Table Grain Design
- Surrogate Keys & Referential Integrity
- Cohort & Retention Modeling
- SQL-Based Transformation Pipelines
- Time-Series & Segmentation Modeling
- Warehouse Layering (RAW → STAGING → CURATED)
- Azure SQL
- Snowflake
- Google BigQuery
- AWS S3
- T-SQL
- Standard SQL
- CTE-Based Query Layering
- Window Functions
- Index Optimization
- Power BI (DAX, Time Intelligence)
- Tableau (LOD Expressions)
- Python (Pandas, Modular Pipelines)
- Designed and implemented a dimensional star schema warehouse in Azure SQL, including surrogate key modeling, fact grain control, referential integrity enforcement, and cohort retention logic.
- Built a multi-layer Snowflake architecture (AWS S3 → RAW → STAGING → CURATED) with structured ELT transformations and scenario-based revenue impact modeling.
- Developed a BigQuery analytical warehouse with separated transformation and reporting layers, implementing curated analytical views optimized for BI consumption.
- Applied advanced SQL window functions (LAG, ROW_NUMBER, PERCENTILE_CONT) for time-series analysis, percentile modeling, and market segmentation in large transactional datasets.
- Engineered a modular Python analytics pipeline with structured preprocessing, feature engineering, and validation logic to analyze and model airline pricing intelligence.
- Implemented large-scale loan risk analytics modeling (255K+ records) using SQL transformations and time-intelligence logic to support portfolio-level decision analysis.
Explore my repositories below 👇
Former Program Manager in Customer Support, where I led operational reporting, KPI tracking, and performance optimization initiatives.
My exposure to business metrics and process analytics motivated a deeper technical shift into Analytics Engineering — formalizing SQL-based data modeling, warehouse architecture, and structured ELT workflows across cloud platforms.
Today, I focus on building scalable, analytics-ready data systems that bridge operational data with strategic decision-making.