At MediaSense, I migrated 50+ Airflow DAGs across 13 digital media platforms into Snowflake and dbt, helping retire Airflow and reduce technical debt and compute costs. I also architected a self-service commercial data warehouse with a Streamlit front end and dbt models using SCD Type 2 and snapshots.
I built an Azure and Snowflake SMS alerting system that flags pipeline failures as they happen, cutting manual monitoring by 28 hours a week. My SQL and Power BI models supported a 6% reduction in wasted spend and enabled 18% of client media budget to be reallocated to better-performing campaigns.
At PwC, I built an Azure Databricks warehouse consolidating five source systems and automated 12 Azure data workflows, reducing manual processing by 48 hours a week. Across my other roles, I migrated data to BigQuery, developed reporting and analytics, and worked on SQL Server performance tuning and GDPR data remediation.
