Hospital Management System (HMS)

Enterprise-grade multi-branch Hospital Management System (HMS) web portal unifying 16 clinical and administrative modules—including OPD consultations, lab diagnostics, radiology, pharmacy, OT scheduling, and consolidated billing. Engineered with strict role-based access control (RBAC), real-time patient queue boards, and comprehensive audit logging.

Project Overview

Enterprise-grade multi-branch Hospital Management System (HMS) web portal unifying 16 clinical and administrative modules—including OPD consultations, lab diagnostics, radiology, pharmacy, OT scheduling, and consolidated billing. Engineered with strict role-based access control (RBAC), real-time patient queue boards, and comprehensive audit logging. Streamlines hospital operations, connects branch networks, and eliminates departmental silos for modern healthcare providers.

The platform bridges departmental silos across OPD consultations, lab diagnostics, radiology, in-house pharmacy, operation theater (OT) scheduling, inpatient admissions (IPD), and consolidated multi-payer billing. Built for multi-branch hospital networks, it enables central administration while providing each clinic branch with real-time patient queue boards, live room status, and branch-isolated clinical records.

My Engineering Role

Full-stack and cross-platform architecture lead responsible for database modeling, Supabase PostgreSQL RLS policies, TanStack Query state orchestration, role-based access control (RBAC), REST API integration, and cross-platform mobile/web delivery with Next.js, React, and Flutter.

The Challenge

Healthcare institutions operate across disparate departments with strict regulatory compliance, low-latency requirements, and zero tolerance for medical record errors. Synchronizing live patient queues across waiting rooms, securing patient EHR across branches, and orchestrating complex 16-module billing workflows required rock-solid data integrity and access control.

The Solution

Engineered a high-throughput Next.js and React web portal paired with Flutter mobile clients, powered by Supabase and PostgreSQL. Implemented strict database-level Row-Level Security (RLS) for multi-branch isolation, TanStack Query for optimistic updates and caching, and real-time event listeners for live patient queue boards.

High-Level Architecture

  • Multi-branch Next.js and React web portal backed by TanStack Query for optimistic caching and instant clinical data retrieval.
  • Cross-platform Flutter mobile clients for attending physicians and clinical staff on Android and iOS.
  • Supabase and PostgreSQL architecture with Row-Level Security (RLS) enforcing branch isolation and strict Role-Based Access Control (RBAC).
  • Real-time event streaming for waiting-room patient queue boards, OT schedule changes, and emergency alerts.
  • Comprehensive immutable audit logging tracking every EHR access, prescription modification, and billing transaction.

Key Features & Workflows

  • 16 Unified Clinical Modules: OPD consultations, lab diagnostics, radiology, pharmacy, OT scheduling, and consolidated billing
  • Multi-Branch Network Management: Central hospital governance with isolated branch data and consolidated reporting
  • Role-Based Access Control (RBAC): Fine-grained clinician, nurse, pharmacist, lab technician, and administrator permissions
  • Real-Time Patient Queue Boards: Sub-second live displays for waiting areas and consultation chambers
  • Consolidated Clinical Billing: Multi-payer invoicing, insurance claims, and automated pharmacy/lab reconciliation
  • EHR & Digital Prescriptions: Tamper-resistant clinical timelines with fast ICD-10 diagnostic coding

Technical Challenges Overcome

  • Designing high-performance PostgreSQL RLS policies that scale across multi-branch tenancy without query latency
  • Orchestrating complex multi-stage billing across pharmacy, lab, and consultation without race conditions
  • Ensuring zero data loss and sub-second queue state broadcasts during high OPD rush hours

Production Results & Impact

  • Successfully unified 16 previously disconnected hospital departments into one responsive platform.
  • Streamlines hospital operations, connects branch networks, and eliminates departmental silos for modern healthcare providers.
  • Achieved 100% auditable record compliance with zero unauthorized EHR access across web and mobile surfaces.

Need a similar architecture shipped?

Let's translate your product workflows, real-time requirements, and cloud infrastructure into a dependable production app.