Portfolio

Case Studies

Systems built, documented, and reflected upon.

AA-014 In Development

Automation

Job Apply Assistant

Semi-automated job application pipeline with 5 stages and 3 human decision gates — Playwright scrapes postings across ATS platforms, analyzes requirements against a master profile, tailors resumes and cover letters, exports to 4 formats, and navigates application forms without auto-submitting.

Playwright Python python-docx reportlab
AA-013 In Development

Full-Stack

Excel Dashboard Converter

Drag-and-drop web app that transforms Excel files into interactive KPI dashboards entirely client-side — with auto-KPI detection, chart type auto-suggestion, and zero server-side data processing for privacy-sensitive workforce education data.

Next.js React Recharts Supabase Tailwind CSS
AA-012 Production

Automation

Keep Sync — Google Keep to Obsidian Converter

Automated converter that transforms 847 Google Keep exports into structured Obsidian markdown with YAML frontmatter, 5-category auto-classification, MD5 deduplication (18.4% duplicate rate), and bidirectional wikilink generation — packaged as a standalone .exe for zero-dependency distribution.

hashlib PyInstaller Python regex
AA-011 Production

Automation

Email Template Engine

CLI-driven HTML email generator that separates content (YAML) from formatting (Jinja2 templates) with automated CSS inlining via Premailer and minification — reducing campaign email production from 25 minutes to under 2 minutes with guaranteed cross-client rendering.

Jinja2 premailer Python PyYAML
AA-010 Production

Data Engineering

SEC §127 Education Benefits Intelligence Suite

End-to-end intelligence suite that scans 36,791 SEC EDGAR filings to identify companies offering §127 education benefits — with XBRL validation that reduced a 58.2% false positive rate by 90.3%, geographic enrichment at 90.1% coverage, and per-company deal value computation across the public company universe.

BeautifulSoup NumPy Pandas Python Regex NLP
AA-009 In Development

AI Engineering

KalmSkills — Career Intelligence Platform

Full-stack career intelligence platform integrating O*NET occupational data (1,016 occupations, 35K+ skill descriptors), SEC EDGAR employer signals, and BLS wage statistics — with cosine-similarity skill matching, ATS resume simulation, and sub-100ms multi-dimensional queries.

FastAPI PostgreSQL Pydantic Python React
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
1 2 3 4 5