About Me
Informatics Data Analyst · Los Angeles, CA
Currently at LA County DHS — building and owning a 100M+ encounter-record Azure Synapse medallion lakehouse, T-SQL stored procedures, ADF + PySpark pipelines, and Tableau dashboards for clinical operations and executive leadership. Daily batch processing 1M+ records across 10+ QIP pay-for-performance quality measures.
Prior at Warner Bros. Discovery (HBO Max) — SQL and ETL on Snowflake and Databricks for a 2M+ subscriber CRM operation across EMEA, North America, and Asia. Built campaign dashboards in Looker and Tableau; ran A/B test analysis; supported the Asia-market launch pipeline.
BA Economics cum laude, CSULB. 2x data hackathon winner. Mentoring others in SQL, Python, and Tableau.
Experience
Informatics Data Analyst
LA County Department of Health Services (Contract)
- Built Oracle → Azure Synapse medallion lakehouse (ADF + PySpark); 100M+ encounter records in bronze, 1M+ landing monthly on a daily 6 AM batch
- Automated QIP Achievement Value scoring (manual Excel → T-SQL stored proc → gold-layer Tableau dashboard): ~40% reduction in manual analyst effort
- CMS147 flu outreach: 1-day manual extract converted to an automated daily job returning 1M+ member rows
- AV dataset query: 2 min → <1 min via execution-plan review, predicate pushdown, and join restructuring
- 10+ ad-hoc SQL reports and star-schema gold models for clinical outreach; requirements in JIRA and Azure Wiki
Data Analyst (CRM)
Warner Bros. Discovery — HBO Max
- SQL + ETL on Snowflake and Databricks for 2M+ subscriber CRM (email, push, in-app, SMS) across EMEA, NA, and Asia
- 15% data reliability improvement and 20% manual reconciliation reduction through pipeline validation and defect resolution
- Contributed to 12% campaign engagement lift across EMEA and North America
- Looker + Tableau dashboards; A/B test analysis (multivariate, defined success metrics); UAT for Asia-market launch
Marketing Data Analyst (Student Worker)
Financial Management Association, CSULB
- SQL + Python audience segmentation and A/B testing — 20% conversion lift, 25% engagement lift
- Tableau KPI dashboards for sponsorship pitches — $8,000 in funding secured, 50% event attendance lift
- 25% membership growth from data-driven targeting of outreach campaigns
Projects
BrightFutures Dashboard
Scraped and modeled school data across Southern California using Python and Snowflake; built an interactive Tableau dashboard to help parents compare schools on cost, performance, and proximity.
Helldivers 2 — Player Feedback NLP
Built an Apache Airflow pipeline to pull Steam reviews via the Steamworks API, applied BERTopic NLP topic modeling to 50K+ reviews, and visualized server performance and content gaps in Tableau.
Montreal Crime Analysis
Cleaned and modeled Montreal open crime data; built interactive Tableau dashboards identifying seasonal crime patterns and neighborhood trends for city planning and law enforcement use.
Yelp Reviews Ranking Algorithm
Combined sentiment analysis and linear regression on Yelp review data to build a composite business ranking score; surfaced top performers beyond raw star ratings in an interactive Tableau dashboard.
Strava Run Analytics
Pulled personal Strava activity data via the API and built second-by-second elevation, pace, and location dashboards in Tableau to track marathon preparation progress.
FMA Marketing Dashboard
Analyzed FMA's Instagram engagement data using Python; identified optimal posting times and content types; presented findings in a Tableau dashboard that informed the org's social strategy.
Google Analytics — BigQuery SQL
End-to-end SQL analysis of Google Analytics session data in BigQuery: device-level transactions, bounce rates, product pageviews, and revenue per session — structured as business question → query → insight → action.
Get in Touch
Open to new roles in healthcare analytics, data engineering, and BI. Based in Los Angeles — available for hybrid or remote.