Data Analyst → Analytics Engineer based in Redlands, CA
I build data products end-to-end — from production reporting pipelines to NL-to-SQL chat apps powered by LLMs. Former Principal Technical Product Manager who delivered enterprise platforms at Zelle, First American, ADP, and Kaseya before pivoting fully into data. Strong SQL across dialects — MySQL, PostgreSQL, SQL Server, and Databricks SQL — with enough depth to build a curriculum around it.
Ask questions about marketing data in plain English. Get SQL, results, and charts instantly.
→ Try the Live Demo | → View the Code
- Natural language → SQL powered by Claude (Anthropic)
- Queries a 23-table marketing analytics schema on Databricks
- Multi-turn conversation memory with full context
- Three analyst persona question banks: CMO · Digital Marketing Manager · Analytics Engineer
- Deployed to Streamlit Community Cloud with SQLite demo mode
12 modules · 11 hours · every query tied to a real CMO business question
Built a complete self-paced SQL training course on top of a production-grade 25-table marketing analytics database. Each module covers one digital marketing discipline, teaches the SQL techniques needed to analyze it, and connects every query to the kind of question a senior marketing leader asks in a real meeting.
Every module includes:
- 🔧 Engineering Lens — EXPLAIN-driven thinking and data profiling before writing a query
- 📊 Marketing Nuggets — business context explaining why each metric matters to a CMO
- 🎯 CMO Questions — the actual executive question your SQL answers
- 💡 Tips & Tricks — patterns, shortcuts, and gotchas
- ✅ Test Yourself — graded exercises with full worked answers
| Module | Topic | Key SQL Skills |
|---|---|---|
| 00B | Engineering Workflow | EXPLAIN, data profiling, index strategy |
| 01 | SEO Analytics | LAG(), LEAD(), RANK(), NTILE(), multi-step CTEs |
| 02 | PPC & Paid Ads | Running totals, composite indexes, EXPLAIN |
| 03 | Email Marketing | Views, conditional aggregation, moving averages |
| 04–10 | GTM · Content · Audiences · Attribution · A/B Testing · CRO | Stored procs · UDFs · Triggers · Funnel CTEs |
Languages
Databases
Data Platforms
BI & Visualization
AI & LLMs
| Project | Description | Stack |
|---|---|---|
| Marketing Analytics Assistant | NL-to-SQL chat app · Live demo | Streamlit · Claude · Databricks |
| Marketing Analytics SQL Training | 12-module SQL curriculum · 25-table production schema · CMO question bank | MySQL 8.0 |
| SQL Query Optimization Lab (coming soon) | Execution plan analysis, index strategy, normalization case studies | MySQL · PostgreSQL · Databricks SQL |
| Medallion Architecture Build (coming soon) | Bronze/Silver/Gold data layers on Databricks | Databricks · dbt · Unity Catalog |
| Marketing Data Marts (coming soon) | Reporting views, stored procs, materialized views | Databricks SQL · dbt |
Advanced SQL across multiple dialects and platforms:
- MySQL 8.0 — window functions, stored procedures, triggers, scalar UDFs, EXPLAIN execution plans, covering indexes, normalization
- PostgreSQL — EXPLAIN ANALYZE, CTEs, lateral joins, generate_series date spines
- Databricks SQL — Delta Lake, Unity Catalog, QUALIFY clause, Spark UI profiling
- SQL Server — T-SQL, execution plans, query tuning
- dbt Core — SQL models, tests, lineage, incremental strategies
- Azure Data Engineer Associate certification
- General Assembly — Data Engineering · Database Management · Digital Marketing (May 2025)
- dbt Core — building production SQL models on Databricks
