Moving a 14-Site Medical Waste Network From Excel to a Live Platform
We designed a worker app and a management portal that replace end-of-day Excel sheets with live operations data across 14 incineration sites, built so the client can add new sites without new development.
- Medical waste management company
- Client
- Healthcare waste management
- Industry
- 14 sites, 2 shifts per site, unlimited sites supported
- Scale
- Discovery, UX/UI design, interactive prototype, architecture, development
- Our role
- Worker app (9 screens), admin portal (5 dashboards), backend & reporting
- Deliverables
- Design complete · Pilot in development
- Status
What Needed to Change
The client operates medical waste incinerators at 14 sites. Every site recorded its daily operations (pre-heating and incineration time, bags processed, weight, kg per hour, operator shifts and remarks) in Excel, and head office merged those sheets into daily and monthly reports by hand.
No live view
Head office only saw a site's numbers after the day was over and the sheet had been sent in.
Downtime surfaced too late
On a single day, 6 of the 14 sites were not operating, mostly due to LPG shortages or power failures, and the causes were buried in a free-text remarks column.
Reporting was manual
Weekly totals, downtime breakdowns and charts were assembled by hand from separate spreadsheets.
What the client needed
- Workers log operations from their phones at the source
- One dashboard for the whole network, with a click-through to any site
- Unlimited sites, added by the client without new development
- Simple screens for non-technical staff, in Urdu and English
- A clean, light, CRM-style interface for management
How We Tackled It
- 01
Start from real data
We broke the client's own consolidated report into its parts, so every field in the new system maps to a column they already track.
- 02
Dashboards first
We designed five management dashboards and published a clickable prototype so the client could try them before any code was written.
- 03
Worker app second
We designed nine phone screens around the worker's day: start a shift, log waste, add photos, report a problem.
- 04
Scalable by design
When the client asked for unlimited sites, we revised the architecture so sites, regions and workers are managed from the portal, not code.
What We Built
Two connected apps on a single API: a worker app that captures operations as they happen, and an admin portal that turns those entries into live dashboards and reports.
Worker App (9 screens)
Shift timer, quick data entry with live kg per bag and kg per hour, time-stamped photos, location-checked clock-in, personal performance and Urdu/English switching.
One-Tap Issue Reporting
Workers flag LPG, electricity, machine or safety problems with a priority and photo, and management is alerted immediately.
Executive Dashboard
Active sites, today's output against yesterday, operating hours, critical alerts and a live status for every site.
Site Analytics
Top and bottom performing sites, a weekly heatmap and downtime split by cause, with a detailed timeline for any single site.
Resource Management
LPG and electricity status across all sites, plus a maintenance tracker with owners and deadlines.
Reports Center
Daily, weekly, monthly and custom reports, exported to PDF or Excel and scheduled by email.
Technical Highlights
Built to scale without code changes
Sites, regions and workers are records managed from the portal. Management can add a site, group sites by region and give regional managers access to their region only.
One API for both apps
The worker app and admin portal share a single .NET API, so every rule, permission and report is defined once.
Role-based access & audit log
Separate permissions for admins, regional managers, supervisors and workers, with every change recorded in an audit log.
Installable, no app store needed
The worker app is a progressive web app that installs on the phone's home screen, with camera and location access.
Technology stack
Services used
- sites brought into one live view
- 14
- worker screens & management dashboards
- 9 + 5
- sites supported without new development
- Unlimited
What It Changes
Live network status
Management sees which sites are running, which are down and why, without waiting for the evening sheet.
Downtime becomes data
LPG, electricity, cooling and de-ashing time are recorded as categories that can be counted and compared.
Problems reach the right person
A worker flags an LPG shortage on site and management gets the alert at once.
Reports build themselves
The daily, weekly and monthly reports the client already uses come straight from the entries.
Planning a similar project?
Tell us what you want to build. We'll show you how we would approach it, with a clear timeline and estimate.
More Case Studies
View all case studies
Travel & Tourism
An Online Parking Booking Platform for 5+ UK Airports, Including Heathrow
Read case study
Food & Beverage
A Multi-Restaurant Food Ordering Platform for a German Delivery Startup
Read case studyMore work under NDA
This Is Only a Small Part of Our Portfolio
Most of the projects we deliver are covered by confidentiality agreements, so we share them privately. Book a short call and we'll walk you through work that's relevant to your industry, live demos included.
