ANTHONY.javascriptSurgical & Clinical Ops
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
Executive Briefing Available · York, PA / Remote
10+
Years Frontline OR & Clinical Ops
350+
Monthly Cases Automated
$0
Missed Implant Deliveries
100%
Relational Access & SQL Upgrades
Verified Core Platforms
Epic Optime Cerner Surginet Power BI Power Query SQL Python Excel Expert
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
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.

Operational Breakthrough: Replaced slow, manual phone/email confirmations with an automated dispatch engine triggered on case booking — achieving zero missed implant deliveries.
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
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.

Operational Breakthrough: Converted opaque raw vendor sheets into monthly specialty run-rates, giving surgical directors and CFOs clear, forecast-ready cost modeling.
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
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.

Operational Breakthrough: Replaced a brittle shared workbook with an automated relational engine enforcing staff availability constraints and balancing patient routing daily.
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 · York, PA & Remote

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 →