Summary

Deecon partnered with CityFibre to deliver a targeted commercial support programme, driving enhanced cost recovery, robust governance, and streamlined reconciliation processes. The engagement resulted in improved data integrity, stakeholder accountability, and operational efficiency across CityFibre’s cost recovery and measure reconciliation of the delta.

The Requirement

CityFibre engaged Deecon to provide expert support across two distinct phases:

Phase One: To increase cost recovery and strengthen governance around existing processes
Phase Two: To reconcile the delta between As-Built and Certified values, ensuring accurate financial reporting and compliance

The programme required Deecon to evaluate and optimise CityFibre’s ERS Strike Claims and Blockages on Install trackers, as well as to address challenges in Primary Node (PN) close-out and reconciliation of over £25 million in value differences.

The Solution

Deecon adopted a collaborative and stakeholder-focused approach, delivering the following solutions:

Process Evaluation & Stakeholder Engagement: Conducted workshops to identify strengths, pain points, and dependencies within existing trackers and reconciliation processes
Tracker & Dashboard Redesign: Developed two MS Lists trackers with tailored views for user groups, and an interactive Excel dashboard powered by Power Query for live data flow
Training & User Support: Delivered 10+ training sessions to more than 30 stakeholders, supported by comprehensive user guides and recorded training manuals
Reconciliation Tools: Designed four Excel dashboard templates, regional slicer dashboards, and dataset templates to enable focused analysis and insight generation for each region

Throughout both phases, Deecon ensured that solutions were aligned with stakeholder needs, provided ongoing training and collected feedback to guarantee user satisfaction and system functionality.

The Results

Phase One:

Improved data integrity and accountability from the MS Lists trackers developed
Automated information management, driving efficiency, via the reporting dashboard

Phase Two:

Manual input minimised and regional analysis provided through the four Excel dashboard templates
Accurate data flow and governance from the use of the established dataset templates

Across Both Phases:

Delivered comprehensive stakeholder training and user manuals, ensuring accessibility and satisfaction with new systems
Measurable improvements in cost recovery, process governance, and operational transparency, equipping CityFibre with robust tools and best-practice methodologies for ongoing commercial success