Projects using Microsoft Excel in United KingdomProjects using Microsoft Excel in United KingdomBusiness Analyst for a Government client on behalf of Accenture. Supported the delivery of a data warehouse programme aimed at centralising data, improving reporting capabilities and enabling data-driven decision-making across multiple departments. Worked closely with business and technical stakeholders to define data requirements and ensure alignment with strategic objectives.
My duties included the following:
▪ Led requirement gathering activities to capture data, reporting, and analytics needs through stakeholder interviews, workshops, and process analysis.
▪ Facilitated workshops with business users, data engineers and architects to define data sources, data flows and reporting requirements.
▪ Produced detailed documentation including business requirements documents (BRDs), data requirements, data mapping specifications, and user stories.
▪ Collaborated with technical teams to translate business needs into data models, ensuring clarity on data definitions, transformations, and quality rules.
▪ Translated business needs into structured user stories and acceptance criteria, supporting agile delivery and ensuring traceability from requirements through to implementation.
▪ Managed RAID logs and supported programme governance by tracking risks, dependencies, and data-related issues.
▪ Supported UAT by defining acceptance criteria, validating outputs, and ensuring delivered data aligned with business expectations.
Key outcomes included:
Key outcomes included:
▪ Delivered clearly defined data and reporting requirements, enabling the successful design and implementation of the data warehouse.
▪ Improved data consistency and trust by standardising data definitions and aligning stakeholders on a single source of truth.
▪ Strengthened delivery alignment by linking use cases and user stories directly to technical outputs, reducing ambiguity and rework. Cloud EHR Modernisation Programme Business Case & Financial Model
Verified
• 🔗 IT Project Manager NHS
• 23/08/2026
Overview
Innovate Health IT, a 500-bed acute NHS Trust, faced significant challenges with its aging on-premises EHR system, including rising costs, frequent outages, limited scalability, and poor interoperability, which hindered operational resilience and clinical safety. The candidate was tasked with evaluating a strategic transition to a modern cloud-based EHR platform to address these critical issues and align with national digital transformation mandates.
What I did
Developed a detailed 5-year financial model, including cash flow projections, Net Present Value (NPV), and Return on Investment (ROI), explicitly adhering to HM Treasury Green Book guidance for public sector projects.
Conducted a comprehensive options appraisal comparing current on-premises, cloud-based, and hybrid EHR solutions, detailing their respective pros and cons.
Performed a sensitivity analysis on key financial variables (subscription cost, migration cost, productivity gains) to assess financial viability under different scenarios.
Identified and mitigated key risks associated with cloud EHR transition through a structured RAID log, proposing specific mitigation strategies.
Designed a benefits realization plan, outlining KPIs, ownership, governance, and reporting cadences for tracking both cashable and non-cashable benefits.
Authored a strategic business case highlighting national NHS mandates (EPR 2025, Shared Care Record, DSPT, Cyber Strategy) and their influence on the recommendation.
Outcomes & deliverables
Produced a comprehensive business case document recommending a cloud-based EHR transition for Innovate Health IT.
Developed a detailed 5-year financial model demonstrating a negative NPV of –£2.90M and an ROI of –64%, typical for strategic NHS EPR programs.
Identified 5 key risks and their mitigation strategies within a structured RAID log.
Outlined a benefits realization plan with clear KPIs for tracking both cashable and non-cashable benefits like improved clinical safety and cybersecurity.
Provided a clear, data-backed recommendation for the cloud EHR, emphasizing strategic alignment over purely financial returns.
Impact
I developed a detailed business case for a major NHS Trust, justifying a strategic shift to a cloud-based Electronic Health Record (EHR) system through rigorous financial analysis and strategic alignment, securing buy-in for a critical digital transformation.
Tools & methods
Excel/Google Sheets (financial modeling), NHS Green Book (discount rate guidance), Risk Assessment Frameworks, Benefits Realization Frameworks
Reflection
I learned that while traditional financial metrics (NPV, ROI) may appear negative for NHS EPR modernization due to the nature of non-cashable benefits, the strategic imperative for improved resilience, cybersecurity, and interoperability often outweighs these financial limitations, necessitating a nuanced approach to business case development. 
