Case studies
What was broken, what I built, and the numbers behind it — written in enough detail to be checked rather than taken on trust.
Healthcare — provider data
Retiring a Paid Data Vendor
A provenance and confidence layer over 7.4M healthcare providers — re-sourced onto authoritative registries, with every field carrying where it came from and how much to trust it
- 7.4M
- Providers in the enriched spine
- 94.9%
- License records from authoritative sources
- 34
- State licensing boards onboarded
- 14
- States with paid verification fully retired
Healthcare — data governance
Documentation That Cannot Go Stale
A governance platform that reverse-engineers a 322-table healthcare data model into published, business-readable documentation — regenerated from live sources every morning
- 2,451
- Fields documented and curated
- 322
- Tables covered
- 213
- Invisible data gaps surfaced
- 65+
- Consecutive unattended daily runs
Healthcare — data governance tooling
Governance Out of Spreadsheets
A spec-driven admin application that let business analysts own a healthcare provider data model directly — versioned, auditable, and with no engineer in the loop
- ~4 weeks
- Build time, solo
- ~2,100 lines
- First-party source
- ~10 lines
- Cost of adding a governed table
- 0
- Engineers needed for a mapping change
Higher education — technical curricula
Building Courses That Don't Go Stale
Systems-driven online course development: interactive lessons, AI-generated video, and an authoring pipeline that makes updates cheap
- 44
- Interactive lesson pages
- 67
- AI-generated explainer videos
- 120 / 120
- Quiz questions traced to instruction
- 36
- Rubrics under version control
Enterprise data platform — Azure Databricks
Moving a Catalog That Cannot Be Moved
A recreate → deep clone → cutover playbook for migrating Unity Catalog storage roots, with a mandatory human gate in front of the one irreversible step
- None exists
- SQL command that moves a catalog
- 5 of 6
- Reversible steps in the playbook
- 1
- Mandatory human sign-off gates
- Yes
- Delta history preserved
Higher education — instructional technology
AI in the Workflow, Not on the Podium
A production course-assistant platform that drafts rubric-aligned grading and in-context feedback — and never sends anything to a student without the instructor approving it first
- 0
- AI outputs reaching students unreviewed
- ~50
- Submission file types handled natively
- ~50
- Production API routes
- The LMS
- System of record
Healthcare — national data utility
Owning the Risk, Not the System
Setting target-state architecture and holding approval authority on the client side, as a national healthcare registry moved off a vendor-controlled stack it could not see into
- 250M
- Member records ingested weekly
- 1.2 TB/wk
- Compressed volume at the raw layer
- 12 weeks
- Architecture & initiation phase
- 6
- Medallion layers designed