Selected work
Complex systems. Clear outcomes.
Eighteen case studies across data platforms, applications, AI, analytics, and reliability. Each one is a sanitized
reconstruction: no organization names, proprietary code, client data, or confidential architecture.
01
Retail data platform · Integration
Backend architecture for a multi-retailer shelf-intelligence ecosystem: inventory, planogram, product, and image feeds out to an AI vendor, availability metrics back into reporting.
- ADF
- Databricks
- ADLS
- Delta Sharing
- SQL
Read case study →
02
Data product · Self-service analytics
End-to-end data product, from on-prem extraction to governed Gold models, plus a self-service app that replaced legacy reports for about 100 daily users.
- ADF
- Databricks
- Delta Lake
- Streamlit
- CI/CD
Read case study →
03
AI / ML · Vector search
Hybrid rules-plus-vector-search system that returns ranked, explainable comparable titles on demand instead of overnight.
- Databricks
- Vector Search
- Unity Catalog
- Python
- SQL
Read case study →
04
Incident response · Production data
Restored a floor-facing warehouse dashboard after a failed integration: traced the cascade, cleaned duplicate data, and recovered 14,033 of 14,033 valid records.
- Azure Functions
- Synapse
- Azure SQL
- Logic Apps
- Key Vault
Read case study →
05
Forecasting · Data app
Automated 26- and 52-week launch curves with a governed curve editor, replacing a manual hours-to-days process.
- PySpark
- Delta Lake
- Streamlit
- Plotly
- Asset Bundles
Read case study →
06
Enterprise application · APIs
Custom API-driven web app replacing a low-code planning portal, with faster grids, optimistic locking, auditable snapshots, and no vendor lock-in.
- FastAPI
- HTMX
- AG Grid
- Dataverse
- Entra ID
Read case study →
07
AI adoption · Learning platform
Internal AI learning platform driving Copilot adoption from the C-suite to every license holder, with courses, a readiness assessment, and progress tracking.
- Streamlit
- Databricks Apps
- Unity Catalog
- OAuth
- Asset Bundles
Read case study →
08
Analytics · Methodology
A lift-weighted allocation method that stopped overlapping retail events from inflating POS units, where 9 real units had been showing up as 63.
- PySpark
- Spark SQL
- Statistics
- Matplotlib
Read case study →
09
Reliability · Production engineering
Diagnosed slow pages and intermittent outages in a production demand-planning app, from autovacuum lag and index bloat to the reads that hit them.
- PostgreSQL
- Supabase
- Vercel
- Sentry
- Databricks
Read case study →
10
Data architecture · Master data
Bringing operational and analytical systems into line around consistent business entities, with canonical IDs, mapping rules, and visible exceptions.
- Dynamics 365
- ADF
- Databricks
- Delta Lake
- Azure SQL
Read case study →
11
Integration · Reusable framework
A bidirectional pattern for syncing business-app data with the lakehouse, so new datasets connect without rebuilding one-off interfaces.
- Dataverse APIs
- Databricks
- Python
- SQL
- OAuth
Read case study →
12
Platform · Security & DevOps
Moving data-platform automation off personal credentials and onto service principals and federated identity, so jobs belong to the team.
- Entra ID
- Service principals
- Databricks SDK
- Terraform
- OIDC
Read case study →
13
Data quality · ERP migration
Found and sized the store account-number conflicts behind pipeline failures after an ERP migration, so fixes could be prioritized.
- Databricks SQL
- PySpark
- Delta Lake
- Data quality
Read case study →
14
Data engineering · Pipelines
Store-level inventory for a major retailer’s live items, after solving an identifier mismatch that had queries running for minutes with no results.
- SQL Server
- Databricks
- JDBC
- Workflows
- Asset Bundles
Read case study →
15
Orchestration · Idempotency
A Logic Apps workflow with a date-specific control marker that stops repeated source notifications from triggering duplicate loads.
- Logic Apps
- ADF
- Blob Storage
- JSON
Read case study →
16
Data product · SQL
Weekly store-level service hours with reliable Sunday–Saturday boundaries, one row per store-week, and a six-month backfill.
- T-SQL
- SQL Server
- Azure pipelines
Read case study →
17
MLOps · Security
Human-in-the-loop app for approving ML-predicted inventory decisions, plus the least-privilege access pattern that made it secure.
- Streamlit
- Databricks Apps
- Unity Catalog
- Key Vault
- RBAC
Read case study →
18
Production support · Low-code
Owned and stabilized a low-code forecasting portal: fixed UX bugs, root-caused forecast errors, and laid the groundwork for its replacement.
- Power Pages
- Dataverse
- JavaScript
- Power Platform CLI
Read case study →