esigning & Delivering a Scalable Hospital Management System

end-to-end healthcare platform engineered using React, Node.js, and MySQL.

This system was designed to closely mirror real hospital operations while maintaining strong academic rigor and engineering best practices.

Core Capabilities

? Multi-Role Access Control

Secure, role-aware portals for Doctors, Nurses, Lab Staff, Pharmacists, Finance Teams, and Administrators, ensuring data integrity, privacy, and clear operational boundaries.

? Integrated Clinical Workflows

From patient registration to diagnosis and treatment, the system supports seamless clinical processes, including automated nurse assignments and real-time patient status updates.

? Billing, Payments & Insurance Handling

A comprehensive financial module supporting:

• Itemized billing

• Partial and multi-mode payments

• Invoice history tracking

• End-to-end insurance claim lifecycle management

? Data-Driven Insights & Reports

Designed and implemented 15+ advanced SQL reports, each optimized for performance and formally validated using relational algebra, effectively bridging database theory with real-world application.

? Architecture & Module Breakdown

To ensure scalability, maintainability, and clean separation of concerns, the HMS was structured into six independent yet fully integrated modules:

1️⃣ Authentication & Role Management

2️⃣ Patient & Clinical Records

3️⃣ Nursing Operations & Task Scheduling

4️⃣ Laboratory & Pharmacy Services

5️⃣ Billing, Payments & Insurance

6️⃣ System Administration & Reporting