Case Study - Replacing a broken Excel system with a constraint-based oncology scheduler
SGFar is a donated platform built to digitize anti-blastic drug preparation workflows across 4 hospitals and a central pharmacy in Tuscany — eliminating systematic patient overbooking and manual rescheduling.
- Client
- SGFar
- Year
- Service
- Full-stack development, Healthcare digitization
Overview
Chemo drug preparation runs on tight constraints. Some drugs have stability windows of only a few hours. Shipments arrive on fixed schedules. The lab is closed Sundays, compressing Monday capacity. Different cancer types mean different doctors, different patient volumes, different scheduling patterns across the week.
Four hospitals in Tuscany were sharing a single central pharmacy and coordinating all of this through a shared Excel file. Each hospital overbooked independently, and pharmacy staff spent their mornings calling patients to reschedule — daily.
SGFar replaced that system. It's a constraint-based scheduler that models physical capacity, chemical stability, time windows, and clinical load simultaneously. Hospitals request slots through a structured ticketing system; the central pharmacist approves, rejects, or requests clarification — all tracked in near real-time with full audit trails and role-based access control.
Built from scratch as a first solo project, on zero budget, and donated to the USL Toscana Centro Oncology Department.
What we did
- Constraint-based Scheduling
- Full-stack (Next.js)
- RBAC & Audit Logging
- Real-time Dashboard
- Ticketing System
A colleague described the problem to me during a shift — hospitals overbooking daily, staff calling patients every morning to reschedule. I knew it was solvable, so I built it and donated it.
Founder of Blackie Studio
- Reduction in processing time
- 80%
- Annual preparations tracked
- 20,000+
- Hospitals integrated
- 4
- Preparation traceability
- 100%