Overview
AdvancedMD became the system of record: appointments, billing, and clinical documentation lived in one ecosystem. SQL automations handled reconciliations, alerts, and compliance checks, while dashboards surfaced productivity metrics and exceptions. Staff had tailored training kits and ongoing coaching.
Executives saw revenue cycle metrics in real time. Clinicians spent less time chasing paperwork, thanks to automated handoffs and standardized workflows. The project turned a paper-heavy operation into a connected, measurable, and compliant program.
Impact
$100K in outstanding claims cleared
Backlog resolution
Within six months
60% reduction in manual reconciliation
Operational efficiency
Through consolidated workflows
75% faster monthly reporting
Reporting turnaround
Powered by SQL + Power BI toolkit
Reduced ramp from four weeks to one
Team onboarding
Knowledge base and live workshops
25% faster claims turnaround
Consolidated reporting reduced manual reconciliations by 40+ hours per month.
Automated exception monitoring kept denials below 3%.
Onboarding cycle time dropped from four weeks to one through shared playbooks.
What shipped
Orchestrated multi-day workshops with clinicians, PT therapists, and ABA staff to define critical requirements and select AdvancedMD for its modularity and payer integrations.
Designed and deployed interim billing workflows in under 72 hours, training contract billers to keep revenue moving while the platform went live.
Mapped end-to-end flows for medical, PT, and ABA services, uncovering handoff failures and standardizing documentation.
Collaborated with Blue Cross Blue Shield EDI specialists to resolve taxonomy issues that blocked claim submissions.
Built SQL automations that synchronized scheduling, billing, and compliance reporting, surfacing KPIs in Power BI dashboards.
Established quarterly governance reviews so platform updates, schema migrations, and user roles stayed aligned with regulatory changes.
Journey
Immersive learning
Lived in healthcare IT playbooks—BPMN, FHIR, revenue cycle texts—and cold-emailed implementers for guidance.
Owning mistakes
Early gaps in PT multi-code billing and ABA documentation fed the sprint backlog and sharpened rollout patterns.
Agile iteration
Bi-weekly configuration sprints delivered workflow tweaks and SQL refinements based on real-time feedback.
SME development
Became the AdvancedMD subject-matter expert, leading integrations, schema upgrades, and bespoke extensions.
Knowledge sharing
Authored a 50+ article knowledge base and coaching sessions that kept the team self-sufficient.
Lessons
Deep curiosity wins
When you lack expertise, immerse yourself in the domain until pattern recognition starts working for you.
Process comes first
Skipping detailed workflow mapping guarantees rework; map the handoffs before automation starts.
Iterate fearlessly
Treat every failure as data. Rapid sprints build trust and expose the next best improvement.
Document relentlessly
Shared playbooks and office hours create resilience long after the core team moves on.
Reflection
This project became the crucible for my operating philosophy—turn chaos into structured systems, never accept limits as given, and keep the improvement loop running.
Next steps
From this work to enterprise AI
Modernizing a sensitive operational workflow brings data access, review, and ownership into focus. These are also essential questions when moving AI into everyday enterprise use.
Discuss your bottleneck