Trevor Grubb | Data analysis and operations

Selected results

Benefit plans in one report: 1,946; Coverage elections across 45 categories.
Projects managed: 100+; A manufacturing portfolio spanning three sites.
Inspection hours saved annually: 1,672; A maintenance work center overhaul.

Nov 2025 – Present

Healthcare finance

Repriced actual pharmacy claims under proposed contract rates. The account team used the claim detail and cost summary to develop a counteroffer.
Built a monthly SQL and Excel report comparing contract pricing with actual cost for roughly 14,000 to 15,500 claims per month.
Measured the impact of a new reimbursement minimum from its implementation date and estimated the annual effect. Client, claim, and drug summaries supported account teams in their client communications.

Jan 2024 – Nov 2025

Manufacturing operations

Set up a common process for submitting and prioritizing projects. Site teams used the same project plans and status reports to track delivery.
Worked with accounting and finance teams to explain differences between budgeted and actual costs for labor, materials, maintenance, and overhead.

Mar 2018 – Mar 2024

Aviation maintenance

Led an 18-person team through a work center overhaul while maintaining accountability for $17.5 million in tools and equipment.
Trained 120 people across four squadrons and developed reusable templates for safety and environmental compliance.

SQL, Excel, claims repricing, cost variance analysis, data validation, and KPI scorecards.

Bachelor of Science in Business Administration, magna cum laude.

Project Management Professional (PMP)
Lean Six Sigma Black Belt

Have a role or project in mind? Send me a message.