20+ years building the reporting, forecasting, and decision tools that help businesses grow
Bridging leadership, business strategy, and hands-on engineering — demonstrated here through the Soapy project suite, an end-to-end exploration of data engineering and applied LLM systems.
|
Vinyl-collection visualization platform. End-to-end ELT: Python ingestion from the Discogs API → Parquet landing zone → dbt-core transformations on DuckDB (staging → intermediate → fact/dim marts), productionized with Prefect orchestration, PostgreSQL materialization, and containerized Metabase dashboards. Python · dbt · DuckDB · Prefect · PostgreSQL · Metabase AI music-discovery tool over a ~10,000-track personal library. Dual-retrieval architecture pairing Essentia audio-feature vectors in Qdrant for acoustic similarity with natural-language RAG, served on Ollama (Gemma 27b) + Nomic embeddings, with a Streamlit interface for query, similarity search, and feature inspection. Qdrant · Essentia · Ollama · RAG · Streamlit RAG research lab benchmarking four retrieval patterns — naïve vector, hybrid + reranking, GraphRAG, and an agent-maintained LLM wiki — against a curated 480+ article corpus with a rubric-scored evaluation harness. Pure Python with Qdrant, Neo4j, BM25, and cross-encoder reranking, governed by a Claude Code harness layer. GraphRAG · Neo4j · BM25 · Evals · Claude Code Harness A 400+ page applied AI/LLM engineering reference for building production systems end to end — six parts spanning transformer mechanics, baseline & deployment decisions, RAG architecture, prompt & context engineering, harness design, agent memory & architectures, and evaluation / security / deployment ops. LLM Engineering · RAG · Agents · Evals · Production |
Data Engineering & Analytics: Python · SQL · dbt · Jupyter · Prefect · DuckDB · PostgreSQL · Snowflake · Databricks · AWS · SAS · Git BI & Visualization: MicroStrategy · Tableau · Metabase · BusinessObjects · Power BI · Alteryx AI / LLM Systems: RAG · Hybrid RAG · GraphRAG · Agents · Multi-Agent Workflows · Prompt & Context Engineering · Rubric-Scored Evals Retrieval, Vectors & Models: Qdrant · Pinecone · Chroma · Neo4j · BM25 · Cross-Encoder Reranking · Ollama · Nomic embeddings · Essentia audio features Frameworks & Tooling: LangChain · LangGraph · LangSmith · Streamlit · Claude Code · Docker · Pandoc |