PMO Analyst
North West Anglia NHS Foundation Trust
- Designed, built and own the HHRP portfolio RAID dashboard in Power BI with 19 custom DAX and Power Query KPIs, consolidating 230+ risks, issues and dependencies across 8+ workstreams, replacing manual Excel consolidation and cutting the PMO reporting cycle from 2 to 3 days to under 30 minutes.
- Own the fortnightly PMO reporting cycle feeding the Deputy Programme Director and external governance chairs, producing the portfolio pack covering milestone slippage, benefits realisation, interdependencies and critical path variance across 30+ active programme activities on a £1B+ capital programme.
- Redesigned enabling works project reporting with the workstream chair, replacing narrative two-slide updates across 11 projects with a metrics-led template covering health and safety, finance, contingency, programme movement, change control and decision logging, plus a risk page per project.
- Lead PMO support for the Enabling Works Development Group (EWDG), owning fortnightly action tracker production, external chair review cycles and senior stakeholder circulation across the Trust and external partners.
- Operate PMO financial controls across 150+ purchase orders ranging £1k to £4.2m in Oracle Cloud ERP, tracking cost variance, flagging anomalies and producing forecast exposure reporting that surfaced reforecast risk to Finance ahead of month-end.
- Shape PMO reporting standards and data governance across the programme, consolidating 5+ workstream data sources into a single reporting layer, removing 10+ hours of manual reconciliation per cycle and improving portfolio data quality for Programme Board decision-making.
- Act as PMO point of contact for assurance queries from workstream leads, external chairs and Finance, translating programme data into decision-ready insight for senior stakeholders.