- ● Live demo unavailable (Private)
- ● Screenshots Gallery
- ● Architecture details
CogniBill — AI Medical Billing Dashboard
An AI-driven medical billing and collections dashboard — engineered to automate SLA tracking and drastically reduce Days Sales Outstanding (DSO) for DSO networks.
Problem
A major multi-site Dental Service Organization (DSO) struggled with a bloated 81-day Days Sales Outstanding (DSO) metric. The challenge: the executive team had zero real-time visibility into claim aging, denial patterns, or payer performance. Their existing Power BI reports were often 5 days stale, and manual workflow routing caused millions of dollars in claims to fall through the cracks.
Architecture & Solution
The solution relies on a highly resilient, event-driven architecture. Nightly cron jobs sync raw EMR data via REST APIs into a secure PostgreSQL database. Make.com orchestrates SLA tracking and routes critical exceptions, while a high-performance FastAPI backend serves real-time, materialized views directly to a React frontend dashboard.
Data Model
Relational schema mapping patient ledgers to active claims, status events, and assigned billing agents. Uses materialized views for fast performance on complex aging calculations.
Failure Handling & Resilience
Dead-letter queues in Make.com catch API timeouts. Failing sync operations trigger automatic alerts to ensure the dashboard reflects ground truth.
Permissions & Security
Fully HIPAA-aligned workflow. PII/PHI is scrubbed before leaving the secure EMR boundary, and all dashboard access is governed by strict Role-Based Access Control (RBAC).
Implementation Decisions
- Real-time event processing — Replacing stale Power BI reports with a FastAPI + React dashboard guarantees executives and billers are acting on real-time claim states.
- Compliance-driven workflow — Implementing strict Role-Based Access Control (RBAC) and minimum-necessary data exposure ensures the entire pipeline remains fully HIPAA-aligned.
- Automated prioritization — Deploying algorithm-driven claim routing slashed DSO from 81 days down to 22, successfully recovering over $2M in aging revenue.
- Resilient dead-letter queues — Capturing API timeouts in Make.com and triggering automatic retry alerts ensures the dashboard always reflects ground truth.
