Problem
A Colombian healthcare operator was running its home-care service on spreadsheets and ad-hoc messaging: a schedule of visits to the patient's home that means coordinating doctors, therapists, nursing assistants and caregivers, checking availability, and keeping a clinical record of every service. Without a central system there was no reliable way to approve bookings, avoid overlaps, log the clinical history, or capture the patient's signature as proof the visit took place.
Solution
I built a web platform in PHP and MySQL on 33 tables, with two distinct portals: an admin side to schedule and approve visits, and a professional side where each provider reviews their agenda and documents care. I implemented the full booking flow (reservation, availability checks, individual and bulk approval), management of five professional roles, clinical records, consent forms and digital signature capture. I integrated FullCalendar for scheduling, Google Maps for visit addresses, DataTables and Chart.js for listings and dashboards, PHPMailer for notifications, and six CSV exports plus consolidated reports and PDF generation. The timezone was pinned to America/Bogota.
Result
The operator moved its entire home-care operation into a single tool: scheduling, assigning and tracking each visit, with the patient signature and clinical history as supporting documentation. The platform centralises field-team coordination and enables exportable operational reporting. It is a legacy system, fully functional and used in real production, that I would today treat as a solid base for a gradual modernisation.