Portfolio / Rev 2026 Mahe Mishra, home

Case studies / CS-03

Workforce data automation and £280k of validated savings

Routine HealthRoster reporting was eating time and introducing rekeying errors. Python automation cut 25 to 30 percent of the workload, and workforce analysis for the Trust's Cost Improvement Programme delivered £280k of validated savings.

PMO Coordinator · 2024 to 2025

  • £280k validated workforce savings for the Cost Improvement Programme
  • 25 to 30% workflow efficiency gain on routine reporting
  • 200 to 250 staff covered by the HealthRoster data

Context

Early in my time at North West Anglia NHS Foundation Trust I worked on workforce information, with HealthRoster data covering 200 to 250 staff and producing management information for service leads and senior managers.

Problem

The reporting cycle was mostly manual. The same extracts were reshaped by hand each time, checked by hand, and rekeyed into reports. It was slow, and every rekeyed figure was an opportunity for an error that someone would then plan a rota around.

Approach

  • Automate the boring half. Python scripts replaced the manual extract and reshape steps across HealthRoster data operations.
  • Fix data at source. Root cause analysis on anomalies, working with the teams that owned the data rather than correcting the same error every cycle.
  • Point the analysis at money. Trend analysis on rostering, capacity and leave patterns, aimed at the Trust’s Cost Improvement Programme.

Outcome

A 25 to 30 percent workflow efficiency gain on routine reporting, more consistent data with the manual processing errors gone, and £280k of validated workforce savings delivered through the Cost Improvement Programme.

Lesson

Automation pays twice. Once in the hours it gives back, and again in the errors it removes from data that people make real decisions on.

The build PRJ-05 Shipped Workforce data automation in Python

All case studies