Data Analytics · SQL projects

Data Analytics

Explore FEC campaign finance, BudgetDB, and every portfolio project using SQL—from data quality and financial modeling to applications built on a database.

10 projects · SQL, PostgreSQL, and BigQuery

fec-campaign-finance.working-project

Business intelligence · Public data

FEC Campaign Finance Analysis

Live

BigQuery analysis of the 2018 and 2020 election cycles, with 29 SQL queries, data-quality checks, reporting models and a stakeholder report.

Business question

How much came from individuals and committees, who received committee contributions, and how does intermediary reporting affect the answers?

Investigates repeated IDs and fundraising-platform overlap, reconciles reporting totals, and makes the effect of alternative contribution definitions visible.

BigQuerySQLData ModelingData QualityBusiness Intelligence

Read report GitHub source PDF

View working project

code-proof.workspace

FEC Campaign Finance Analysis · source preview

1-- 21_monthly_chart_data2-- I use the saved monthly summary to compare the two sources3-- over time without scanning the original contribution tables again.45WITH monthly AS (6  SELECT7    contribution_month,8    SUM(9      IF(source_type = 'individual', gross_amount, 0)10    ) AS individual_amount,11    SUM(12      IF(source_type = 'committee', gross_amount, 0)13    ) AS committee_amount,14    SUM(gross_amount) AS total_amount15  FROM16    `fec-contributions-analysis.fec_analysis.agg_contributions_monthly`17  GROUP BY contribution_month18)1920SELECT21  contribution_month,22  individual_amount,23  committee_amount,24  total_amount,25  100 * SAFE_DIVIDE(26    total_amount - LAG(total_amount) OVER (27      ORDER BY contribution_month28    ),29    LAG(total_amount) OVER (30      ORDER BY contribution_month31    )32  ) AS month_over_month_growth_pct33FROM monthly34ORDER BY contribution_month;

ghost-ai.working-project

AI-native systems platform

Ghost AI — Collaborative AI Architecture Workspace

Under Active Development

Production-grade AI-powered architecture and workflow builder with realtime collaboration, AI-assisted systems design, and interactive canvas orchestration.

Business question

How can product, analytics, and engineering teams design AI systems collaboratively while keeping architecture, workflow orchestration, and implementation context in one place?

Positions Ghost AI as an AI-native product, analytics, and systems orchestration platform for collaborative system design, product/spec generation, background AI workflows, and production debugging.

Next.jsTypeScriptLiveblocksTrigger.devPrismaPostgreSQLOpenRouterReact Flow

GitHub repo Project profile

View working project

Ghost AI — Collaborative AI Architecture Workspace preview

budgetdb.working-project

Flagship system

BudgetDB Operations Analytics Warehouse

Flagship

A Postgres-backed operations analytics system that turns budget, vendor, software spend, and headcount data into trusted executive views.

Business question

Where is operational spend concentrated, and how should leadership prioritize the next planning cycle?

Creates a reusable decision layer: cleaned tables, composable views, spend allocation, QA checks, and executive-ready outputs.

PostgreSQLBudget AnalysisOperations AnalyticsExecutive Reporting

GitHub repo Full warehouse SQL Software cost SQL Full case study (PDF)G&A Budget Workbook Financial Model

View working project

BudgetDB Operations Analytics Warehouse preview

woo-identity-resolution.working-project

Data / systems usability research

Diagnosing and Fixing a Broken Employee-Commission Match

Live

A WOO warehouse case study diagnosing why commission rows failed to match payroll employees, then fixing the workflow with deterministic SQL keys, governed overrides, and visible match confidence.

Business question

Can the commission-to-employee join be trusted for executive reporting without a human manually double-checking free-text names every cycle?

Turns an error-prone reconciliation workflow into auditable data infrastructure: normalized name keys, MAP_OVERRIDE governance, NAME_KEY_EXACT and NAME_KEY_FIRSTLAST matching, explicit UNMATCHED flags, and queryable match_method diagnostics.

PostgreSQLData QAIdentity ResolutionREGEXPReconciliationWOO

Case study Employee normalization SQL

View working project

woo-scenario-ab-testing.working-project

Scenario / what-if experimentation

Scenario A/B Testing: Isolating Which Cost Lever Actually Moves the Budget

Live

A WOO warehouse case study applying control/treatment/delta discipline to financial planning scenarios, using a reconciled monthly cost baseline and an isolated vendor-spend treatment.

Business question

Can leadership see exactly which cost lever caused a budget change, without relying on fragile spreadsheet scenarios or mixed assumptions?

Productizes what-if analysis: the reconciled fact_cost_monthly_2025 baseline is the control, each analytics.scenario row is a named treatment, and delta_monthly gives a queryable effect for budget decisions.

PostgreSQLScenario ModelingA/B Testing LogicFinancial PlanningData ModelingWOO

Case study Scenario engine SQL

View working project

chat-with-data.working-project

AI + warehouse interface

Chat With Your Data

Under Active Development

A natural-language interface to the BudgetDB warehouse: ask a plain-English question, Claude runs read-only SQL through tool calling, and the answer is grounded in queried rows.

Business question

How can non-technical leaders ask trusted warehouse questions without opening SQL, while keeping the AI read-only and auditable?

Extends BudgetDB from warehouse to conversational decision layer: schema-grounded tool use, read-only execution, strict query allowlisting, and visible SQL audit trails.

PythonAnthropic APITool CallingSQLite DemoPostgres PathRead-only Safety

GitHub repo Project README Agent script Safety tests Case study

View working project

code-proof.workspace

Chat With Your Data · source preview

1import re23_FORBIDDEN = re.compile(r"\b(INSERT|UPDATE|DELETE|DROP|ALTER|CREATE|TRUNCATE|GRANT|REVOKE|ATTACH|PRAGMA)\b", re.I)456def is_safe_select(sql: str) -> bool:7    """Defense-in-depth check: only SELECT/WITH, no mutating keywords anywhere in the string.8    This runs in addition to (not instead of) opening the DB connection read-only - either9    layer alone should already stop a write, both together is the point.10    """11    stripped = sql.strip().rstrip(";")12    if not re.match(r"^\s*(SELECT|WITH)\b", stripped, re.I):13        return False14    if _FORBIDDEN.search(stripped):15        return False16    if ";" in stripped:  # no stacked statements17        return False18    return True

vendor-roi.working-project

Operations analytics

Vendor Spend & Ops ROI Analytics

Live

A vendor spend and ROI analytics model: staffing-weighted budget rollup, vendor cost-per-active-employee ranking, and renewal review flags for low-adoption, high-cost tools.

Business question

Which vendor costs should operations review before renewal, especially when spend is high and adoption is narrow?

Connects budget rollups, staffing assumptions, vendor utilization, and renewal review logic into an auditable operations decision model.

PostgreSQLSQLWindow FunctionsSUMPRODUCTExcel

Workbook SQL model

View working project

remittance-revenue.working-project

Payments model

Revenue Modeling - Remittances

Live

A payments/remittance fee-schedule and tiered revenue-projection model: NRC/MRC fee structures, transaction-tier volume assumptions, and projected monthly fee revenue by tier.

Business question

How do transaction tiers, fee schedules, and volume assumptions translate into projected monthly revenue?

Turns remittance pricing assumptions into a repeatable revenue model with SQL rollups and Excel financial modeling artifacts.

SQLPostgreSQLExcel Financial ModelingPaymentsRevenue Projection

Workbook SQL model

View working project

sql-qa.working-project

Analytics engineering

Cost Model QA Checks

Live

SQL validation checks comparing source totals to modeled fact totals by cost category, with variance and pass/fail status.

Business question

How can messy operational data become reliable product and business reporting we can trust?

Adds confidence gates before dashboards and executive summaries are used for decisions.

SQLPostgreSQLData QAReconciliation

SQL demo file

View working project

chorus.working-project

Prototype in development

Chorus Agent Learning App

Live

An iPhone app and web landing-page concept for learning AI agent fundamentals, comparing platforms, and saving reusable skills.

Business question

How can people learn agent workflows, compare the right platforms, and reuse practical skills in one place?

Shows product thinking beyond portfolio work: mobile UX, content model, Supabase schema, launch plan, web page, and launch video assets.

AI ProductiPhone PrototypeAgent EducationSupabase

Chorus page Launch plan Supabase schema Launch video

View working project