Data Analysis · 1 November 2022
Mapped 1,400+ customer environments and built real-time reporting architecture, enabling £1.2M in cost savings.
Program Lead and Reporting Architect, I led a large-scale project to map and report on the technical estates of over 1,400 customers across the EMEA region. The project delivered real-time visibility through Power BI dashboards, improved resource allocation, and directly supported cost-saving initiatives amounting to £1.2 million.
This EMEA-wide programme was designed to consolidate and report on technical estate data from over 1,400 customers. The goal was to provide clear, centralised visibility into infrastructure health, resourcing needs, and opportunities for optimisation—achieved through data integration, reporting automation, and executive dashboard delivery.
Program Leadership: Managed a team of 12 technical leads across multiple regions to coordinate data collection and ensure consistent quality and completeness.
Estate Mapping: Oversaw the capture of critical infrastructure, systems, and licensing information across customer environments, standardising formats and classifications.
Power BI Integration: Built and deployed Power BI dashboards to deliver real-time insights into infrastructure status, resource allocation, and project progress.
Automated Reporting Workflows: Developed automation flows to extract, clean, and present data at regular intervals. Ensured that senior executives received consistent, accurate reporting every week.
Impact Reporting: Designed dashboards to track cost savings, technical consolidation progress, and system optimisation metrics—contributing to £1.2M in cost reductions.
Challenges & how I solved them
Coordinating data collection across a wide, multi-country technical team.
Standardising estate data from diverse environments and legacy systems.
Ensuring data security and compliance during centralised reporting.
Balancing real-time reporting needs with data integrity and automation.
Related
Designed a comprehensive HR app to manage the full recruitment lifecycle. Enhanced the recruitment process with automated workflows, leading to quicker decision-making, reduced administrative delays, and more informed recruitment across all 7 businesses.
Lead Developer and Business Analyst I designed and implemented a custom IT Procurement app using Microsoft Power Apps. The project automated procurement workflows, from request to approval, and was built collaboratively with business stakeholders to ensure functional alignment, seamless integration, and user adoption.
Dynamics 365 system, initially implemented to manage work orders from BAE Systems, had failed to meet Denholm’s business requirements. After the project ran £30,000 over budget, you were brought in to assess and rectify the system. You collaborated with Denholm's stakeholders and BAE customers, gathering a backlog of 90+ requirements and user stories to guide the upgrade. You applied Agile methodologies to partition requirements into manageable sprints, overseeing each sprint from planning through User Acceptance Testing (UAT) to deployment. By managing the backlog, environment permissions, and all stakeholder communication, you ensured the system was finally functional and tailored to Denholm’s needs.