Hospital Appointment & Patient Management System

Project Description

This hospital management platform was built to digitise and streamline the end-to-end patient journey — from initial appointment booking through to billing and follow-up. Designed to operate across multiple branches simultaneously, the system centralises scheduling, patient records, and reporting into one secure, role-controlled platform.

The appointment engine was the core technical challenge: detecting scheduling conflicts in real time across doctors, rooms, and branches, while keeping the booking flow fast enough to handle high-traffic clinic hours. Dapper was chosen over a full ORM specifically to squeeze maximum query performance out of the 10M+ record patient database — ensuring even complex cross-branch reports return in under 3 seconds.

Key Highlights

• Appointment scheduling engine with conflict detection — Built a booking engine that checks doctor availability, room occupancy, and branch capacity in real time before confirming any appointment — preventing double-bookings and scheduling collisions across all 3 branches handling 500+ daily bookings.
• Twilio SMS API — automated appointment reminders — Integrated Twilio to send automated SMS reminders 24 hours and 1 hour before appointments, plus instant booking confirmations and cancellation alerts — reducing patient no-shows by 28% within the first 3 months of deployment.
• Dynamic report generator — Excel & PDF export — Developed an admin-facing report module allowing staff to generate patient history reports, billing summaries, and doctor-wise appointment stats filtered by date range, branch, or department — exportable to both Excel and PDF with one click.
• Dapper-optimised queries on 10M+ record database — Replaced slow EF Core queries on heavily joined patient tables with hand-tuned Dapper SQL with indexed stored procedures — reducing complex multi-branch report query times from 18+ seconds down to under 3 seconds.
• OTP-based patient self-service portal — Implemented a secure patient login using OTP delivered via both email and SMS — eliminating password management for patients while keeping the booking portal secure. Patients can book, reschedule, and cancel appointments without staff involvement.
• Multi-branch architecture — Designed the data model with branch-level isolation allowing each of the 3 clinic branches to maintain independent doctor schedules, room allocations, and billing records — while giving admin users a unified cross-branch dashboard view.
• Billing & payment tracking module — Built a billing module that calculates consultation fees, tracks payment status (Paid / Pending / Waived), and generates itemised invoices — linked directly to patient appointment records for a full financial audit trail.
• Role-based access for clinic staff — Implemented RBAC with distinct access levels for Receptionist, Doctor, Branch Manager, and Super Admin — each seeing only the data and actions relevant to their role, enforced at both UI and API level.