Project Showcase
Real-world projects that demonstrate how I turn complex data problems into measurable business outcomes — from enterprise BI migrations to fraud analytics.
Featured
Executive Infrastructure Dashboard
Designed and built a comprehensive, real-time executive dashboard consolidating financial and operational performance across all business units. Revenue, gross profit, margin, utilization, capacity, and throughput — unified in one interactive platform with drill-through from portfolio level to individual facilities.
Impact: Real-time executive visibility · Self-service drill-through · Adopted for weekly decisions
Multi-Region Data Reconciliation Framework
Reconciled site inventory data across 40+ Postgres tables spanning four major regions (NE, Rockies, Permian, MidCon). Built a reusable troubleshooting framework that standardized how the organization identifies and resolves data discrepancies.
Impact: 100% query accuracy · 4-region coverage · Reusable framework
Medicare Fraud Case Analytics
Built analytical datasets supporting Medicare Fraud prosecution at the Tennessee Attorney General’s Office. Gained direct TennCare database access, redesigned data workflows, and transitioned the team from Excel to Power BI — cutting case preparation from 3 weeks to 2–3 days.
Impact: 3 weeks → 2 days turnaround · Directly supported prosecutions
BI Forge — Enterprise AI Analytics Platform
Designed and built an enterprise-wide BI platform giving every employee access to role-filtered dashboards or plain-English data queries backed by live SQL. Role-based access via Azure AD, an AI Prompt Studio for natural language → SQL → visual, and a pipeline health panel powered by Dagster.
Impact: Democratized data access across 8 dashboard domains · Eliminated ad-hoc request backlog
Streamline — BI Visual Development Pipeline
Built a 7-stage AI-assisted pipeline that takes a dashboard visual from stakeholder requirements to a production Power BI artifact — with live data validation, automated quality checks, and a formal sign-off gate built into every stage.
Impact: Eliminated ad-hoc visual dev · Structured sign-off gate · Auto-generates DAX + TOM scripts
Data Detective — AI Data Quality Diagnostic Tool
Built a chat interface that autonomously traces dbt lineage, runs live SQL, and diagnoses data quality issues in minutes — naming the root cause and fix owner so analysts don’t have to manually navigate the DAG. Covers both active dbt repositories.
Impact: Hours → minutes diagnosis · Self-serve for junior analysts · Full team deployment ready
AFE Portfolio Executive Dashboard
Built a fully self-contained Power BI HTML Content visual giving executive leadership real-time visibility into AFE capital project budgets, committed spend, CIP balances, and schedule slippage — with 8 KPI cards, 5 collapsible detail tables, and responsive layouts across all viewport sizes.
Impact: Executive portfolio visibility · Schedule slippage quantified · 3,000+ lines of DAX
SCADA Disposal Facility Volumes Dashboard
Designed and built a self-contained HTML dashboard for monitoring disposal facility volumes, utilization, and skim oil recovery across all regions. Includes reactive filters, color-coded utilization thresholds, and a 6-month forward forecast — refreshed daily via a Python script.
Impact: Real-time facility visibility · 6-month forecast · 18-column dbt model documented
Labour & Chemical Cost Dashboards — TRE Chem
Built two linked Power BI HTML visuals for monitoring labour and chemical treatment costs at TRE Chem facilities. Features 16 KPI cards, automated anomaly alerting, employee-level drill-down, cost-per-barrel efficiency tracking, and a light/dark theme toggle.
Impact: Cost/bbl surfaced · Proactive anomaly alerts · Employee-level visibility
Global Dashboard Initiative — HP Inc
Developed high-level dashboards with drill-through capabilities for global teams at HP. Promoted to lead senior management’s highest-priority dashboard initiative based on performance. Collaborated with data engineering to deploy new pipelines.
Impact: Promoted to lead highest-priority initiative · Global adoption
Opioid Audit & Revenue Recovery — Covenant Health
Identified $4K/month in uncharged medication revenue through a government-required opioid audit. Automated backend nursing documentation forms and implemented new radiology procedures to improve operational efficiency across clinical departments.
Impact: $4K/month revenue recovered · Automated clinical workflows
Fleet Optimization — Knight Transportation
Managed 60+ drivers across scheduling, contracts, and compliance. Applied data-driven fuel and speed management strategies that boosted gross revenue by 12% and slashed fleet idle time from 55% to 20%. This operational foundation informs every analytical decision I make today.
Impact: 12% revenue increase · 55% → 20% idle time · ‘Best Dispatcher’ award
Skills Demonstrated Across Projects
| Skill Area | Infra Dashboard | Data Recon | Fraud Analytics | BI Forge | Streamline | Data Detective | AFE Dashboard | SCADA | TRE Chem |
|---|---|---|---|---|---|---|---|---|---|
| SQL & Query Development | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ◻️ | ✅ | ◻️ |
| Power BI & Dashboard Design | ✅ | ✅ | ✅ | ◻️ | ✅ | ◻️ | ✅ | ◻️ | ✅ |
| Data Modeling & DAX | ✅ | ◻️ | ◻️ | ◻️ | ◻️ | ◻️ | ✅ | ◻️ | ✅ |
| AI / Claude API Integration | ◻️ | ◻️ | ◻️ | ✅ | ✅ | ✅ | ◻️ | ◻️ | ◻️ |
| Full-Stack Development | ◻️ | ◻️ | ◻️ | ✅ | ✅ | ✅ | ◻️ | ✅ | ◻️ |
| Data Governance & Quality | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ◻️ | ✅ | ◻️ |
| dbt & Pipeline Engineering | ◻️ | ◻️ | ◻️ | ✅ | ✅ | ✅ | ◻️ | ✅ | ◻️ |
| Stakeholder Communication | ✅ | ✅ | ✅ | ✅ | ✅ | ◻️ | ✅ | ◻️ | ✅ |
| Process Optimization | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ◻️ | ✅ | ✅ |
| Operations & Logistics | ✅ | ✅ | ◻️ | ◻️ | ◻️ | ◻️ | ✅ | ✅ | ✅ |
The Thread That Connects It All
Every role in my career shares a common thread: finding what’s broken and making it work better. At Knight Transportation, that meant cutting idle time and boosting revenue. At the Attorney General’s Office, it meant turning a 3-week legal data process into a 2-day turnaround. At Select Water, it means reconciling millions of records across regions so leadership can trust the numbers.
I’m not a data analyst who learned operations — I’m an operations professional who mastered data. That distinction matters when the dashboard needs to reflect what’s actually happening on the ground.