Project 01
↗
Apollo
AI orchestrator for a data ecosystem
An MCP server letting Claude reason across a Snowflake warehouse, an ad-management system, and a CMS. Built on Anthropic's Model Context Protocol, designed so the data layer, the tool surface, and the model are all first-class. Extended with retrieval-augmented context over a document corpus.
MCPClaudeAnthropicPythonSnowflake
Project 02
↗
CI Data Platform
Snowflake medallion warehouse, zero to production
Designed and built Community Impact's first data warehouse: a Bronze/Silver/Gold medallion architecture ingesting ad-management, ad-server, email, and CMS data into one unified, governed source of truth. The substrate every other CI data product runs on.
SnowflakedbtPythonMedallionData Engineering
Project 03
↗
AI Citation Tracking
Do AI assistants cite your content?
A data product measuring whether ChatGPT, Claude, Perplexity, Gemini, and Copilot cite a publisher's sponsored content. Stood up ingestion of a new AI-crawler log source, lifted citation attribution from 21% to 91.4%, and shipped it as a customer-facing surface with a ~25x to 60x query speedup. A new analytics category for the business.
SnowflakeCloudflareAEO/GEOPythonData Product
Project 04
↗
Revenue Reconciliation
Finance-grade variance analysis on Snowflake
A company-wide executive dashboard that decomposes pricing and discount variance into reason-coded categories and reconciles charged revenue to finance, separating genuine discounting from earned terms and contractual comp. Built on a per-order-line Snowflake fact; surfaced and root-caused a seven-figure reporting discrepancy and traced it to source.
SnowflakeSQLPythonReconciliationExec dashboards
Project 05
↗
CI Attribution
First attributed-revenue product
A Streamlit application matching subscriber identity to ad exposures and transactions. Built at Community Impact and the technical foundation the company's first signed data partnership was built on.
StreamlitSnowflakeIdentity ResolutionAttribution
Project 06
↗
Customer Data Platform
Identity resolution at scale
CI's CDP layer with custom Snowflake UDFs (NAME_HASH, PHONE_HASH) consolidating subscriber identity across CRM, newsletter, and CMS systems, the substrate that makes attribution possible.
Snowflake UDFsSQLIdentityCDP
Project 07
↗
Data & Insights Hub
Self-service analytics for non-engineers
An internal portal that lets non-engineers (sales, operations, leadership) query governed metrics directly instead of waiting on a data team. Built in Next.js over a Snowflake Gold layer that serves as the single source of truth across every downstream app.
Next.jsSnowflakeTypeScriptSelf-service BI
Project 08
↗
Personal AI OS
An agentic operating layer built with Claude Code
A personal operating layer built with Claude Code: an agentic system running ~9 production automations (deploy and data-pipeline watchers, alerting, changelog and digest generation) wired through MCP servers, scheduled jobs, and hooks. Daily, hands-on proof that AI-native tooling can be built, trusted, and run in production.
Claude CodeMCPAutomationPythonlaunchd
Project 09
↗
Applied Materials
$30M+ in operational impact over four years
Four years as BI Analyst and Data Scientist at Applied Materials. ML forecasting models, 20+ Tableau dashboards, and 10+ Python automations across supply chain, finance, and engineering. Cut manual review time by 80%+; recovered hundreds of operating hours per year.
PythonSQLTableauMachine LearningSAP