Work Marketing Analytics Pipeline Saved ~50 hrs/month and replaced manual reporting with a real-time Looker Studio dashboard — tracking 20+ campaigns across 20 US cities via a BigQuery + dbt ELT pipeline. Digital Ads Data Pipeline & Dashboard Saved ~40 hrs/month and eliminated manual reporting for a US senior living client — automated Google & Meta Ads data pipeline into BigQuery with a live Looker Studio dashboard. BigQuery & Sheets Live Dashboard Replaced weekly manual reports with a live Google Sheets dashboard — automated CRM ingestion via SQL and Google Ads sync via Coefficient, giving the team real-time campaign direction AI & Automation Keyword-Based Influencer Discovery keyword-driven influencer discovery application using Python & Streamlit OCR & AI-Powered Note Processing Pipeline Processed 20,000+ pages of handwritten care notes in minutes — automated extraction, GPT-4o (API) rephrasing, and PDF generation pipeline built in 3 days for a US NGO.
