Portfolio

Case Studies

Systems built, documented, and reflected upon.

AA-008 Production

Business Intelligence

Program Viability Engine

Interactive financial modeling engine for workforce education programs — computes break-even, sensitivity curves, and revenue waterfalls from configurable inputs, replacing gut-feel program decisions with visible assumptions and stress-tested scenarios.

Pandas Plotly Python Streamlit
AA-007 Production

AI Engineering

NightShiftCrew v2 — Autonomous AI Agent Pipeline

A 3-agent CrewAI pipeline running on local LLM inference (Qwen 2.5 Coder 14B via Ollama) that reads real filesystem data, writes and executes Python code with binary validation, and produces portfolio-ready HTML dashboards — orchestrated through a Streamlit Mission Control GUI at zero API cost.

CrewAI LangChain Ollama Python Streamlit
AA-006 Production

Data Engineering

Schema Evolution Engine

Automated schema migration system that validates every change against a registry of known queries before execution — catching breaking changes that schema-level analysis misses, with zero-downtime deployment via shadow-table swaps and concurrent index operations across a 47-table PostgreSQL database.

Avro PostgreSQL Python
AA-005 Production

AI Engineering

Semantic Document Processor

RAG pipeline that transforms 2,000+ workforce education documents into a semantic knowledge base — with structure-aware chunking, hybrid retrieval (BM25 + cosine similarity), and LLM-verified answer synthesis achieving 89% retrieval relevance on domain-specific queries.

FastAPI LangChain Pinecone
AA-004 Production

Infrastructure

Observability Platform

Unified observability stack combining Prometheus metrics, Loki log aggregation, and Grafana dashboards — replacing SSH-and-tail debugging with correlated telemetry, domain-specific alerting, and 91% faster root cause identification across 4 microservices.

Grafana Loki Prometheus
AA-003 Production

Systems Architecture

Workflow Automation Framework

A modular workflow engine that models operational processes as dependency graphs — with typed task contracts, container-isolated execution, automatic rollback, and structured audit logging that eliminates stale documentation by making the code the process definition.

Celery Docker Python
AA-002 Production

Data Engineering

Real-Time Analytics Pipeline

Event-driven ingestion pipeline that unifies 4 source platforms through Kafka, processes streams with Go microservices, and delivers sub-second analytical queries via ClickHouse — replacing 12-hour batch delays with real-time operational visibility.

ClickHouse Go Kafka
AA-001 Production

AI Engineering

Multi-Agent Orchestration System

A 3-agent CrewAI pipeline coordinated by a state machine that reads real data, generates validated Python code, and produces portfolio-ready HTML dashboards — with structured retry logic and output schemas enforced at every handoff.

CrewAI Python Redis
1 2