Case Studies

Deep dives into projects I've built — problems, approaches, and outcomes.


All Case Studies

Building an Evidence-First Knowledge Assistant

How a basic internal search interface evolved into a conversational assistant with source authority, evidence-level citations, durable history, and bounded live retrieval.

TypeScriptReactNode.jsLLM APIsFull-Text Search

Generating UI Prototypes from a Living Design System

A UI-first workflow that snapshots the real application, converts screens into compact semantic templates, and lets an LLM make bounded changes instead of inventing the product from scratch.

PythonPlaywrightReactTypeScriptHTMLGitHub Actions

Designing Safe MCP Servers for Enterprise Tools

How I exposed issue tracking, documentation, and messaging systems to coding agents without turning natural-language instructions into unrestricted write access.

PythonFastMCPModel Context ProtocolREST APIsOAuth

From Git Push to Approved Worklog

A local-first assistant that observes pushed commits, matches them to active work, drafts progress updates, and waits for explicit human approval before posting anything.

GoGit HooksDesktop UIREST APIsLLM CLIs

A Conversational Ticket Assistant: From Plans to Tool Chaining

A chat assistant for a ticket system that started with explicit approvable plans and evolved into a bounded tool loop with deterministic shortcuts, independent criticism, and UI-first prototyping.

PythonFastAPIReactTypeScriptPydanticLLM CLIs

Agentic SDLC Platform: From Ticket to PR

A multi-agent platform that carries a ticket from intent to merged PR: conversational story authoring, planning, code execution in the right repo, and a separate critic quality gate, with a human approving plans and handling escalations at the moments that matter.

PythonFastAPIReactTypeScriptPydanticLLM CLIsGitHub API

Retail Analytics for an Imported Candy Store

Built inventory, demand forecasting, and basket analysis systems for an imported candy store to guide purchasing, anticipate short-term demand, and improve cross-sell decisions.

PythonBigQuerySQLPandasLooker Studio

Agentic RAG with Iterative Refinement

A hybrid retrieval service for code, tickets, and docs — with an LLM that critiques its own results, auto-fetches parent classes or config files when a chunk is incomplete, and refines the query when results miss.

PythonFastAPIPostgreSQLpgvectorSentenceTransformers

Automated Data Pipeline with Quality Monitoring

How I replaced a manual weekly reporting workflow with an automated ETL pipeline and live dashboards, then added a data quality monitoring layer that validates and alerts on the data flowing through it.

PythonPostgreSQLPandasSQLCron

From Minutes to Seconds: Optimizing SQL & BigQuery Performance at Scale

How I cut query time and cloud costs by fixing inefficient SQL and improving data warehouse performance.

SQLBigQueryPythonData Modeling