Business Intelligence Developer at P.L. Marketing — cloud data infrastructure, ETL pipelines, and analytics products supporting Kroger retail brands.
BS in Informatics from Indiana University, with minors in Psychology and Neuroscience.
three sixty Insights — a multi-tenant client analytics portal. An SPFx/React web part on a FastAPI service reading a Microsoft Fabric Warehouse: retail brands sign in with their existing Microsoft identity and see their own performance inside Kroger alongside competitive category context.
I'm one of two developers on it, and I lead the QA team of 3.
Building it — backend API and query layer, commodity-scoped row-level security enforced at SQL-build time, an injection-safe drag-compose report builder, a validated calculated-field DSL, scorecard generation with .pptx export, and an RLS-bound AI Q&A agent whose tools receive the caller's identity rather than a model-supplied scope. 115 merged PRs across 22 tagged releases.
Testing it — three release-gated rounds so far: 372 checklist lines executed, 69 defects filed and triaged, across owned lanes for functionality and SQL verification, security and AI red-teaming, and platform/access. Each round's results also document what was left unverified — vacuous passes, blocked test accounts, regressions that fell through — and every one becomes a numbered line in the next round.
Data Engineering — Python ETL loading retail POS, velocity, and distribution data into Azure SQL and Microsoft Fabric. Automated scorecard generation serving 50+ clients supporting $500M in revenue, plus the desktop Pipeline Console the team runs the weekly load from.
Analytics & Visualization — SQL views, Power BI reports and semantic models, and executive reporting for senior leadership. Four custom Power BI visuals in TypeScript/D3 for cases stock visuals couldn't cover.
AI & Automation — Claude Vision brand matching, MCP-backed executive summary generation, product image and PDF automation. Plus a Power BI skill suite for Claude Code that builds reports from TMDL/PBIR source and self-verifies them against a live render before calling the work done.
| Workstream | Org | Contributions | Scope |
|---|---|---|---|
| Retail analytics warehouse & ETL | three sixty Merchandising Solutions | 153 commits · 85 PRs | Weekly Kroger ingestion into Azure SQL, the analytical view layer, scorecards, AI insight reports |
| Client analytics portal | three sixty Merchandising Solutions | 115 commits · 118 PRs | SPFx + FastAPI + Fabric Warehouse; row-level security, report builder, AI agent; QA lead and developer |
| Power BI reporting | three sixty Merchandising Solutions | 92 commits · 26 PRs | Reports, semantic models, executive reporting infrastructure |
| Power BI tooling & custom visuals | P.L. Marketing | 49 commits · 19 PRs | Claude Code skill suite for programmatic authoring; four TypeScript/D3 visuals |
| Pipeline Console | three sixty Merchandising Solutions | 36 commits · 26 PRs | Python desktop control room wrapping the weekly ETL |
| Business intelligence (ad hoc) | P.L. Marketing | 30 commits · 12 PRs | Python automation, product image generation, internal tooling |
| Cloud infrastructure & IaC | Kroger | ~91 contributions | Terraform IaC CI/CD with staged validation, nonprod SQL Server deployment, RBAC across nonprod and prod, Key Vault, networking, geo-redundant backups |
Ralph Wiggum Manager (archived) — full-stack dashboard for managing autonomous Claude Code loops. 127-endpoint Python API, 17-table SQLite backend, 25-command CLI bridge, 9-page vanilla JS frontend. In production: 908 tasks completed, 98.8% iteration success across 54+ hours unattended.
RuneLite — forked the Flipping Utilities plugin to add SQLite crash-proof storage and GE history import, with upstream PRs to Flipping-Utilities/rl-plugin. Forensic recovery of ~1,400 lost trade entries from a corrupted NVMe SSD.
