All Projects
A deep dive into my technical implementations, data architectures, and automation workflows. Click on any project to read the full case study.
Fragmented data across GA4 and Shopify made it impossible to see true drop-off points or attribute revenue correctly. Implemented GA4 raw data export to BigQuery, modeled data into a reporting mart, and visualized in Looker Studio.
- ✓ Unified view of Sessions → Add to Cart → Checkout → Purchase
- ✓ Identified 15% drop-off at shipping step, leading to UX fix
- ✓ Automated weekly revenue reporting saving 5 hours/week
Generic 'batch and blast' emails were resulting in high churn and low engagement (12% Open Rate). Segmented audience based on RFM analysis and built triggered flows for Abandoned Cart, Welcome Series, and Win-back.
- ✓ 35% increase in Open Rate via personalization
- ✓ 22% recovery rate on abandoned carts
- ✓ Generated $50k incremental revenue in Q1
Ad blockers and ITP were causing 20-30% signal loss in conversion data. Deployed GTM Server-Side container on GCP Cloud Run with custom domain and Consent Mode v2 logic.
- ✓ Restored ~15% of lost conversion data
- ✓ Fully GDPR/CCPA compliant architecture
- ✓ Improved site speed by offloading client-side scripts
Raw CSV exports with no automated analysis — 12+ hours/week of manual reporting, frequent stockouts during peak demand. Designed a Python ETL pipeline and React dashboard with filterable KPIs, time-series analysis, seasonality detection, and hourly heatmaps.
- ✓ 12 hrs/week saved in automated reporting
- ✓ 35% reduction in stockouts via seasonal forecasting
- ✓ $120K annual savings from inventory optimization
Merchandising team lacked visibility into which products had high views but low conversion. Created a 'Product Performance Matrix' dashboard correlating view content_ids with purchase events.
- ✓ Identified underperforming hero products
- ✓ Optimized cross-sell recommendations
- ✓ Data-driven inventory planning for seasonal sales