Built foundational data infrastructure and analytics capabilities, establishing KPI frameworks and predictive models that informed strategic product decisions.
Infrastructure:
- • Established Amazon Redshift data warehouse
- • Replaced legacy reports with Tableau dashboards
- • Optimized complex SQL queries for Redshift performance
Custom YoY Visualization:
- • Developed novel YoY alignment strategy to align years on seasonality (Black Friday) for representative comparison
- • Built trailing 52-week reports with multi-level aggregation via Tableau axis granularity
- • Worked around Tableau's lack of GA/Search Console-style YoY support
Tools: Python (NumPy, Pandas, Matplotlib), SQL, Tableau