Work
Portfolio projects, consulting case studies, and the analytical work behind the scenes.
Every project here asks a version of the same question — and connects to the same throughline from a different angle. The analytical work draws on three schools of political economy: Hayek on the knowledge problem, Ostrom on institutional governance, Buchanan on constitutional constraints. Not decorative concepts. Diagnostic lenses.
Analytical Portfolio
ABC Inventory Segmentation Dashboard
2026 · DataCo Smart Supply Chain Dataset · Google Sheets + Looker Studio
ABC segmentation of 118 SKUs across a 180,000+ record supply chain dataset. Found that 6% of SKUs account for 77% of total spend — a sharper concentration than the classic 80/20 rule. Assigned differentiated replenishment and review policies by tier. Pareto curve, tier distribution donut, and policy recommendation table built in Looker Studio.
The argument: Treating unequal assets equally is not neutral — it is a policy choice with real costs. Ostrom's institutional analysis applied to the warehouse floor.
Safety Stock & Reorder Point Calculator
2026 · DataCo Smart Supply Chain Dataset · Google Sheets
Configurable safety stock model using demand variability, lead time variance, and service level inputs. Z-score driven. Shows the buffer required to maintain fill rate targets when demand cannot be predicted with certainty.
The argument: Safety stock is an epistemological problem, not a math problem. Hayek's knowledge problem, buffered.
Vendor Performance Scorecard
2026 · In Progress
Multi-vendor scorecard tracking on-time delivery, fill rate, and lead time variance. Composite scoring model with exception flagging for vendors crossing reliability thresholds.
The argument: A vendor scorecard is a constitutional rule system for supplier relationships. Buchanan on accountability made visible.
Consulting Work
A decade of systems implementation for mission-driven organizations. Every engagement: replace what broke with something maintainable. Hand it off to non-technical operators. Leave documentation that outlasts the project.
-
TrainingComplete
Central Texas Food Bank - Warehouse Operations
Six-week warehouse operations training program at the Central Texas Food Bank — full lifecycle from receiving through shipping, forklift certification across three equipment types, and the gap between what the warehouse management system records and what the floor actually knows.
Nonprofit · Austin, Texas -
consultingComplete
SWPS Experience Recording
Live event production at Austin Public Studio 1 — seven cameras mapped, three recording decks running simultaneously in 4K, one robotic camera operated by hand in real time. First time on Blackmagic hardware. The footage came out clean.
Public Media · Austin, Texas -
consultingComplete
The Congressional Hunger Center - Digital Platform Redesign
Full-service website redesign engagement for a federal hunger policy nonprofit — from discovery interviews through launch. Delivered information architecture, Figma design system, WordPress CMS with custom content types, 4-dimensional publication library, interactive global partner map, and full content migration with 301 redirects and CDN configuration.
Nonprofit · Washington, D.C. -
consultingComplete
LBJ Liberty & Justice For All Award
Standalone archival website consolidating 8 years of the LBJ Foundation's annual award into a permanent historical record — migrating scattered blog posts, press releases, event details, and photography into a unified archive organized by ceremony year. Still live. Client called back the following year to extend it for a new honoree cycle.
Nonprofit · Austin, Texas -
consultingComplete
LBJ Summit on Race in America
Post-event redesign transforming a pre-event logistics site into a permanent public archive — 18 recorded panels, 46 cross-linked participants, and a focal hierarchy rebuilt around video as the primary entry point for a historical audience arriving months or years after the fact.
Nonprofit · Austin, Texas -
consultingComplete
Parelli Natural Horsemanship — Audition System
Digitized Parelli Natural Horsemanship's paper-based assessment credentialing system — replacing emailed Access database with 7-platform automation; migrated 6,000+ records and 13,500+ assessments into Airtable; designed assessor operations base and purchase-to-credential automation.
Education · Pagosa Springs, Colorado -
consultingComplete
Clear CGI Room Configurator
Built a multi-tenant product visualization platform using layered CGI compositing and Airtable as client-managed CMS backend — 4 active product line configurations with real-time image rendering across 3 viewing angles and composite image export with parts list for sales handoff.
Interior Design · West Yorkshire, United Kingdom -
consultingComplete
MIT Innovation ONE
Designed and delivered front-end UI for a three-role MIT student placement platform — connecting students, departments, and alumni startups through Airtable-backed portals with MIT Kerberos SSO integration and a custom bidirectional WordPress↔Airtable sync plugin; served as user flow architect and QA across a 4-week build.
Higher Education · Cambridge, Massachusetts -
consultingComplete
The Ministry of Architecture (formerly Archinia)
Recovered a Drupal site from the Wayback Machine after it went offline, then used the rebuild as a forcing function to consolidate seven fragmented architecture properties into one static, accessible platform — WCAG AA compliant, no database dependencies, with earthship research and Acoma education materials preserved and publicly available.
Architecture · Santa Fe, New Mexico