// Operations & Data Analytics
I automate the work everyone complains about but nobody fixes.
A decade in surgical operations — scheduling, charge capture, vendor coordination — taught me exactly where workflows break. So I build the fixes: automated mailers, a scheduling database that replaced a broken workbook, dashboards that make supply spend legible.
Selected Work
What I've Built
A few of the tools and reporting visuals I've shipped in surgical-operations work — screenshots of production systems alongside live sample dashboards.
RepMailer Pro
assets/emailer.png
Surgical schedulers were manually emailing device reps to confirm implant deliveries for upcoming cases — slow, repetitive, and easy to miss one. RepMailer reads the case tracking log, works out which reps need which notification, and sends them automatically through Outlook. Confirmations stopped slipping through the cracks.
Supply Expense
assets/expense-chart.webp
Raw supply and implant sheets turned into cost visibility leadership can act on — where the money goes each month, which categories drive it, and where spend is heading. Built with the same Power Query and Excel stack I ran in production, reproduced here in the browser.
VNA Scheduling Engine
images/vna-db.webp
VNA schedulers were running patient visits out of a slow, messy Excel workbook — just finding a patient took real time. I built an Access application to replace it: a proper intake form, scheduling and rescheduling tied to actual clinical staff availability, and distribution rules that spread patient loads evenly so no one gets buried. A daily schedule report goes out to clinical staff and management automatically.
Technical Competency
Software Stack
Data tools ranked by direct production application and engineering depth.
Got a process everyone complains about?
If your reporting lives in files that take hours to update by hand, I can probably automate it. Tell me what the process looks like — I'll tell you what I'd build.
Start A Conversation