Health Data Vitals

Full-stack BI platform with daily Python ETL, three operational dashboards (Quality, Cost, Service Delivery), and Stripe subscriptions—aggregated data only, no patient clinical information.

Healthcare organizations struggle with siloed administrative data across claims, staffing, and service systems. Manual financial and quality reporting consumes 40 hours weekly, with no mechanism to monetize analytics dashboards.

The platform connects to organizational databases via daily Python ETL scripts. Three dashboards deliver insights: Quality (HEDIS/STAR benchmarks), Cost (per-service-line expenses, staffing efficiency), and Service Delivery (appointment availability, length of stay). Only aggregated operational data is stored — no patient clinical information.

Frontend: React 18 with Next.js 14 App Router provides server-side rendering and API routes. Tailwind CSS and Shadcn/ui deliver consistent component design. React Query handles server state caching. Axios manages authenticated API calls to the backend. Backend: FastAPI (Python 3.11) runs asynchronous endpoints for dashboards, authentication, and subscriptions. Pydantic validates request schemas. Firebase JWT tokens authenticate users. Role-based access controls restrict data by organization. Database: PostgreSQL 15 stores organizations, users, cached metrics, audit logs, and subscriptions. Prisma ORM provides type-safe queries. Redis 7 caches dashboard results (5-minute TTL) and manages rate limiting. Infrastructure: Docker containers run the application. Frontend deploys to Firebase Hosting (CDN). Backend runs on AWS EC2 with auto-scaling. PostgreSQL uses AWS RDS (automated backups). S3 stores report exports with CloudFront CDN. GitHub Actions automates CI/CD.

Subscription Tiers: Three tiers defined in Stripe Products API — Essentials (small clinics), Professional (mid-size practices), Enterprise (health systems). Each tier includes specific dashboard modules, user seats, and rate limits. Checkout Flow: Frontend calls backend /create-checkout-session endpoint. Backend creates Stripe Checkout Session with price ID, success/cancel URLs, and organization metadata. Stripe hosts the payment page. Webhook Processing: Stripe sends async events to /stripe-webhook endpoint. Signature verification confirms event authenticity. Key events handled: checkout.session.completed (provisions Firebase accounts, sends welcome email), invoice.payment_succeeded (updates subscription status), invoice.payment_failed (notifies organization, schedules retry), customer.subscription.deleted (revokes access after 7-day grace). Access Provisioning: On successful payment, webhook triggers Firebase Authentication to create organization admin accounts. Stripe Customer Portal allows organizations to update payment methods, download invoices, and manage billing independently.

Deployed across multiple hospital authorities. Achieved 70% reduction in manual reporting (40 to 12 hours weekly). Achieved 33% improvement in payment collection. ROI report generation reduced from two weeks to under one day. System maintains 99.95% API uptime.