~/sajjad $ cat projects/hospital-system
← cd ../projects
Client work
Hospital management system, three sites
Freelance3 hospital sites
A freelance build for a private hospital group with three sites: an iPhone app and database covering staff clock-in with location checks, patient registration, a doctor directory, appointments, reminder calls and an owner dashboard across all three hospitals — in English and Urdu throughout.
What it covers
- Staff attendance: clock in and out on the phone, checked against each hospital’s boundary, with alerts when someone leaves site mid-shift.
- Reception: patients found by phone number, with Pakistani number formats normalised so the same person isn’t registered twice; visit records and documents attached.
- Doctor directory: specialisations, outpatient schedules per site, clinic timings and one-tap calling.
- Appointments: bookable slots generated from the real clinic timings, so a double booking or an impossible slot can’t be made.
- Reminder calls: a daily list that opens WhatsApp with the message pre-written in English or Urdu, and logs that the contact was made.
- Owner dashboard: today’s figures across all three hospitals, comparisons with the previous period, a visits trend, live staff on shift and the busiest doctors.
- A bilingual public website for the group, with right-to-left layout for Urdu.
Patient data handled properly
A hospital system holds the most sensitive data there is, so access was designed in from the first table rather than added later.
- Row-level security on every table, with access decided by role.
- Documents in a private store, opened only through short-lived signed links.
- Every patient record viewed is written to an audit log — who opened it and when.
- Doctors’ personal numbers visible only to reception and management.
- Admin tools to find and flag duplicate patients rather than deleting records.
Built for how it’s actually used
Every label is stored in both English and Urdu, so staff use the system in whichever language they work in. Clock-ins queue on the phone when the signal drops and send when it’s back.
A scheduled job in the database raises exit alerts and closes sessions people forgot to end — so attendance stays accurate without anyone checking it by hand.