Case Studies
Deep dives into projects I've built — problems, approaches, and outcomes.
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.
Evolving a Ticket Assistant from Plans to Tool Chaining
How a conversational work assistant moved from explicit multi-step plans to a bounded tool loop, while adding deterministic shortcuts, design decisions, independent criticism, and UI-first prototyping.
Autonomous Dev Agent with a Separate Critic
A headless poller that picks tickets up, plans them, executes code in the right repo, runs a separate quality gate, and opens the PR — with humans approving plans and reviewing escalations.
Agentic SDLC Platform: From Ticket to PR
A multi-agent platform that takes a ticket from intent to merged PR — story authoring, planning, code execution, and quality review, with a human in the loop only at the moments that matter.
Understanding What Sells Together: Customer Basket Analysis for Imported Retail
Built a basket analysis system to uncover product associations and improve cross-sell strategies in an imported candy store.
Predicting What Sells Next: A Practical Demand Forecasting System for Imported Retail
Built a lightweight demand forecasting system to improve purchasing decisions for an imported candy store with highly unpredictable demand.
Inventory Intelligence for Imported Retail: From Reactive Stocking to Data-Driven Decisions
Built an inventory optimization system for an imported candy store to reduce stockouts, eliminate dead inventory, and improve purchasing 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.
A Conversational Ticket Assistant That Plans Before It Acts
A chat interface that doesn't just call tools — it decomposes complex goals into approvable plans, references prior step outputs, recovers from failures, and verifies the goal after completion.
Multi-Agent Supply Chain Q&A System
A LangGraph-based multi-agent system that intelligently routes supply chain queries to specialized agents for structured data, documents, and synthesis.
Hybrid RAG Retrieval Pipeline
A production-grade RAG pipeline combining vector search, BM25, and knowledge graph traversal for superior retrieval accuracy.
From Manual Chaos to Automated Clarity: Building a Data Pipeline & Reporting System
How I transformed a messy, manual reporting workflow into a fully automated data pipeline with real-time dashboards.
Catching Silent Failures: Building a Data Quality Monitoring & Alerting System
How I built a system to detect, monitor, and alert data issues before they impact business decisions.
From Minutes to Seconds: Optimizing SQL & BigQuery Performance at Scale
How I reduced query time and cloud costs by optimizing inefficient SQL and improving data warehouse performance.
Snowflake dbt Analytics Platform
An end-to-end dbt project implementing star schema models with comprehensive testing and documentation for supply chain analytics on Snowflake.