ANTHONY.javascriptSurgical & Clinical Ops Get In Touch →
Clinical Operations & Analytics Lead

I automate the bottlenecks everyone complains about but nobody fixes.

Over a decade in surgical and clinical operations — OR scheduling, charge capture, vendor implants, and procurement — taught me exactly where workflows fracture. I engineer production-grade fixes: automated communication pipelines, multi-criteria scheduling engines, and high-visibility supply cost modeling.

10+ Years Surgical & Clinical Operations
SQL & Power BI Production Analytics
Deployed VBA / Access Automated Engines
Portfolio Catalog

What I've Built

Production tools, clinical databases, and executive reporting shipped across surgical operations — real-world systems alongside browser-reproduced dashboards.

Production Software // Communications Automation

RepMailer Pro

Deployed Tooling
Add screenshot →
assets/emailer.png
RepMailer Pro Click to inspect

Surgical schedulers and coordinators were manually emailing vendor reps to confirm implant deliveries for upcoming cases — slow, repetitive, and vulnerable to missed deliveries. RepMailer reads the case tracking log, maps required rep notifications dynamically, and dispatches them automatically via Outlook with zero manual friction.

Environment
Excel / VBA / Outlook
Core Function
Automated Vendor Notifications
Replaced
Manual Confirmation Chains
Operational Impact
Zero Missed Implant Deliveries
Cost Visibility // Forecasting

Supply Expense

Executive Analytics
Add screenshot →
assets/expense-chart.webp
Supply Expense Click to inspect

Raw supply sheets and implant invoices converted into actionable financial intelligence — tracking monthly run-rates, identifying cost drivers across surgical specialties, and forecasting budget trajectories. Built with the same Power Query and Excel pipeline deployed in hospital operations.

Environment
Power Query / Excel / DAX
Core Mechanics
Specialty Spend Modeling
Target Problem
Opaque Surgical Supply Spend
Operational Impact
Forecast-Ready Executive Clarity
Production Software // Clinical Scheduling Logic

VNA Scheduling Engine

Deployed Tooling
Add screenshot →
images/vna-db.webp
VNA scheduling engine Click to inspect

Visiting Nurse schedulers were managing hundreds of patient appointments in a brittle spreadsheet. I built a comprehensive relational Access application to replace it: instant patient intake, staff availability constraint validation, and automated load-balancing algorithms. Schedules and management reports are compiled and distributed automatically every morning.

Environment
MS Access / VBA / SQL
Core Mechanics
Multi-Resource Availability Logic
Replaced
Manual Workbook / Uneven Patient Loads
Operational Impact
Balanced Caseloads, Instant Routing
The Operational Advantage

Why Clinical Ops Expertise Matters

Generic data analysts build charts. I build tools that integrate directly into frontline clinical realities.

01 // Frontline Context

Surgical Domain Fluency

I know the operational difference between block time, turnover delays, and implant consignment logistics. Zero learning curve on clinical vocabulary.

02 // Pragmatic Engineering

Zero-Friction Tooling

I build tools in environments staff already use (Excel, Access, Outlook, Power BI). No multi-month IT procurement delays to see measurable time savings.

03 // Bottom-Line Focus

Executive Cost Visibility

Turning messy invoices and charge logs into transparent, forecast-ready models that surgical directors and CFOs can actually make decisions with.

Technical Mastery

Software & Systems Architecture

Data tools and clinical infrastructure ranked by direct production application and scale.

Data Analytics & BI CORE ENGINE
High-volume modeling, executive dashboarding, and relational data extraction.
SQL Power BI Power Query Excel (Expert-Cert) DAX
Process Automation TOOLING
Custom applications, scheduling logic engines, and scripted pipeline automation.
VBA Engines Microsoft Access Outlook API Python / pandas Data Pipelines
Clinical EMR Systems HEALTHCARE
Deep familiarity with clinical charge capture, scheduling interfaces, and patient data.
Epic Systems Surginet (Cerner) CPSI Medent OR Scheduling
Open to Senior / Strategic Roles & Contracts

Got a broken process costing your organization hours?

If your surgical or clinical reporting relies on manual spreadsheets that take hours to compile, I can automate it end-to-end. Tell me what the workflow looks like — I'll outline the exact architecture I'd build.

Start A Conversation →