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.
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.
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.
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.
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.
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.
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.
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.
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.
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.