Portfolio / Rev 2026 Mahe Mishra, home

Projects / PRJ-05

Shipped

Workforce data automation in Python

Automated recurring HealthRoster workforce data workflows and management information reporting for an NHS trust, cutting 25 to 30 percent of the time spent on routine reporting.

Ref
PRJ-05
Status
Shipped
Data
Built inside the Trust. Shown as method and outcome only.
Stack
Python · HealthRoster · Excel
Last updated
02 Nov 2026

What changed

Workforce information work runs on cycles. The same extracts come out of HealthRoster, get reshaped by hand, get checked, and get turned into the same reports for service leads and senior managers. Every manual step is time, and every rekeyed number is a chance for an error that someone downstream will make a decision on.

I replaced the manual extract and reshape steps with Python scripts across HealthRoster data operations covering 200 to 250 staff. The result was a 25 to 30 percent workflow efficiency gain on routine reporting, more consistent data, and an end to the manual processing errors that came with rekeying.

Around the automation

  • KPI dashboards and management information reports for service leads and senior management.
  • Trend analysis on rostering, capacity and leave patterns to inform workforce planning.
  • Root cause analysis on data anomalies, working across teams to fix integrity problems at source.
  • Workforce data analysis for the Trust’s Cost Improvement Programme, delivering £280k of validated savings. The full story is in CS-03.
CS-03 Case study Workforce data automation and £280k of validated savings £280k validated workforce savings for the Cost Improvement Programme