Portfolio / Rev 2026 Mahe Mishra, home

Register / Mahe Mishra / South Yorkshire, UK

PMO and
Data Analyst.

Power BI, DAX, Python and SQL, running the reporting on a £1B+ NHS capital programme.

I am Mahe Mishra, at North West Anglia NHS Foundation Trust on the Hinchingbrooke Hospital Redevelopment Programme, a £1B+ NEC scheme. I build the dashboards, trackers and automation that tell a programme board the truth.

Status In post, North West Anglia NHS Foundation Trust Current role   NHS delivery   Programme £1B+ NEC
01

Selected work

PRJ-01 Shipped

RAID dashboard in Power BI

Interactive risk and issue reporting for a £1B+ NHS redevelopment programme, replacing static spreadsheet tracking. Version 3 is built, three pages around the RAID review.

Power BIDAXPMO
PRJ-02 In progress

PMO central portfolio dashboard

One view of every project, risk, action and pound across a PMO. Built in the open on a synthetic programme that moves forward every Monday.

Power BIDAXPMOPython
PRJ-03 Live

Governance action tracker and dashboard

The fortnightly action tracker for an enabling works governance group, built so every row carries its own audit trail and the chair sees what lands before the next meeting.

ExcelPower QueryPower BIPMO
PRJ-04 Awaiting data

TPMA explorer

An explorer for types of potentially mitigable activity, the hospital activity that could be avoided, redirected or delivered more efficiently, to inform how a new hospital is sized.

Power BINHSCapacity planning
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.

PythonAutomationNHS
PRJ-06 Live

Synthetic programme data engine

A Python engine that runs a fictional £490m hospital programme forward one week every Monday, so every dashboard on this site has moving data and none of it is real.

PythonAutomationGitHub Actions

All projects

02

Live programme

A fictional £490m hospital programme that moves forward every Monday on its own. Every risk, action and figure below is synthetic, rebuilt by a scheduled job, and published as open CSVs that the dashboards read from.

Synthetic data, regenerated every Monday

Halden Vale Health Campus Programme

As at Mon 16 Nov 2026 · Week 28 · 9 projects

How this is generated

Open risks

45

+1 vs last week w/c 31 Aug: 38 open risks w/c 7 Sept: 40 open risks w/c 14 Sept: 41 open risks w/c 21 Sept: 40 open risks w/c 28 Sept: 39 open risks w/c 5 Oct: 40 open risks w/c 12 Oct: 40 open risks w/c 19 Oct: 40 open risks w/c 26 Oct: 42 open risks w/c 2 Nov: 43 open risks w/c 9 Nov: 44 open risks w/c 16 Nov: 45 open risks

High exposure

11

No change vs last week w/c 31 Aug: 7 high exposure risks w/c 7 Sept: 10 high exposure risks w/c 14 Sept: 12 high exposure risks w/c 21 Sept: 12 high exposure risks w/c 28 Sept: 10 high exposure risks w/c 5 Oct: 10 high exposure risks w/c 12 Oct: 9 high exposure risks w/c 19 Oct: 9 high exposure risks w/c 26 Oct: 9 high exposure risks w/c 2 Nov: 10 high exposure risks w/c 9 Nov: 11 high exposure risks w/c 16 Nov: 11 high exposure risks

Overdue actions

7

+1 vs last week w/c 31 Aug: 4 overdue actions w/c 7 Sept: 4 overdue actions w/c 14 Sept: 7 overdue actions w/c 21 Sept: 9 overdue actions w/c 28 Sept: 2 overdue actions w/c 5 Oct: 5 overdue actions w/c 12 Oct: 7 overdue actions w/c 19 Oct: 7 overdue actions w/c 26 Oct: 6 overdue actions w/c 2 Nov: 7 overdue actions w/c 9 Nov: 6 overdue actions w/c 16 Nov: 7 overdue actions

Forecast against budget

+£5.4m

1.11% on £490m

Full snapshot and the dashboard behind it

04

Working stack

Analysis

  • Python (Pandas, NumPy, Scikit-learn)
  • SQL
  • R

Reporting

  • Power BI with DAX and Power Query
  • Excel
  • SharePoint

PMO

  • RAID and risk management
  • Programme governance and action tracking
  • NEC contract environment
  • NHS SBS on Oracle Cloud ERP

Build

  • Astro and TypeScript
  • GitHub Actions
  • Cloudflare Pages
  • TrueNAS
05

Get in touch

Open to conversations about PMO data, BI and analyst roles. The fastest route is email.

mahaswar.mishra@gmail.com