Jason Willcox Email and Phone Number

Lead the development & roll out of new generation Data Visualisation & MI reporting tools supporting direct & virtual teams using Power BI. Collaborating widely across Centrica to establish, share & learn best practice. Identified & exploited opportunities presented by Microsoft Office 365 integrated technologies such as Power BI, PowerApps, SharePoint and Power Automate (Flow). Transformed MI & Reporting capability, embedding analytics & self-serve insight capability into the business decision process. Established & developed quality standards for future MI & Reporting output.Built the case for change plan funding to deliver further transformational MI & Reporting capability.Championed the augmentation of operational data with customer & product segmentation data along with the use of AI analysis tools to provide richer more meaningful performance reports & actionable insights.

Delivered integrated in-memory analytics, data discovery, visualisation & self-serve capability utilising Hadoop Big Data Platform & QlikView technologies. Developed the UK’s first suite of Energy Consumption analysis\visualisation applications integrating Smart Meter Daily & Half Hourly consumption data with Customer Operational, CRM & Customer Segmentation data. Provided capability to analyse & understand customer energy usage at a scale & depth greater than any other UK business with fast access to over 11 Trillion potential data points. Key role in the development UK’s first Smart Meter Time of Use energy tariffs through the analysis of customer behaviours pre and post tariff, evaluating customer benefits & commercial impacts.Development of Smart energy consumption impact statistical reporting for external use by UK Government departments such as Department of Energy & Climate Change (DECC), OFGEM & the UK Parliament Science & Technology Select Committee. Gaining approval for our statistical Smart energy consumption testing methodology as the recommended approach for all UK residential Energy businesses.Development of dozens of super-fast data discovery, insight & visualisation applications, increasing capacity and capability of insight function at low cost. Examples; • UK Customer Value: provided capability to explore associations between modelled Customer Value & each customers Operational, CRM & location attributes. Enabled fast, effective, short term & strategic value based decisions. • UK Customer Losses: provided capability to visualise & explore detailed attributes of customers moving to another energy supplier. Enabled fast, effective, short term & strategic value based decisions on retention activity. • UK Smart Portfolio app: provided capability to visualise & explore the financial opportunities & threats associated with the UK Smart Meter rollout programme. Value at stake: £4billion.

Used data & insight to support delivery of differentiated & first to market Smart Homes offerings driving brand re-appraisal, customer value & establishing brand credentials as modern, forward thinking, 'thought leaders’. Lead the development of new generation of Insight Analytics arising from opportunities presented by BIG Data available from Smart Meters & Connected homes technologies.Built the case for/ raised change plan funding / delivered transformational analytics capability across BG Smart homes. Transformed Smart Metering analytics capability & embeded analytics & self-serve insight capability into the business decision process. Drove Customer value through meaningful performance reports & actionable insights.Integrate customer learnings across a broad range of business critical areas. Supported ongoing appraisal of the Business Case for the Smart Programme both internally and externally (OFGEM, DECC, SEGB).

• Working as a business CPO under the AGILE Project Framework with responsibility to deliver Finance Business Intelligence capability for British Gas Service Contract product holdings as part of a wider SAP CRM\Finance implementation programme for Centrica.• Includes 4 x Financial MI work streams of Payments, Billing, Finance and Insurance Reporting to provide MI capability for the British Gas Service Contract Financial Processes including Balance Sheets, Reconciliation, Revenue Recognition, and Regulatory (FSA) Focussed Reporting such as Solvency II.• Involves replacement of over 250 legacy MI reports with 40 integrated dynamic dashboards, scorecards & MI reports utilising SAP BW, SAP Business Objects, SAP Business Objects Advanced Analytics & SAP Business Objects Dashboards as a reporting solution to report on data sourced from SAP ECC (IS-U, FILA, FICA, ACE) and SAP CRM. Capability caters for in excess of 4m product holdings.

• Change Management Product Owner role using 'Agile' methodology. • Responsibility for the development of Business Intelligence capability for a new “ground up” business unit called British Gas Smart Metering. • Involved creation of over 50 integrated dynamic dashboards, scorecards & MI reports utilising SAP BW, SAP Business Objects, SAP Business Objects Xcelsius as a reporting solution to report on data sourced from SAP MRS, PM-CS, I-SU, MM, DM, and Aspect Telephony. Capability catered for in excess of 26m assets\location.• Delivered BI capability at executive, summary & detailed levels for the BGSM functions of Job Planning, Work Scheduling, Logistics, Field Operations, Customer Contact, Sales, Finance and Regulatory.

• Management of Metering MI team developing & producing reports detailing the commercial & regulatory effectiveness of the company's gas & electricity meter reading & meter operator commercial contracts worth in excess of £100m p.a. • Management & maintenance the meter reading call off process covering over 45m work requests p.a.• Provision of accurate & timely monthly accruals to Finance to forecast expenditure committed but not invoiced for in any given month.• Management of Debt MI team developing & producing MI reports detailing the commercial & regulatory effectiveness of internal and external Debt Management activities & commercial contracts.

• Management of Credit Operations MI team developing & producing reports detailing the commercial & regulatory effectiveness of the company's gas & electricity energy account management systems & processes covering UK and Offshore.• Management of Debt MI team developing & producing MI reports detailing the commercial & regulatory effectiveness of internal and external Debt Management activities & commercial contracts. • Design, development & implementation of integrated automated Business Scorecards & Dashboards.

• Management of Metering MI team developing & producing reports detailing the commercial & regulatory effectiveness of the company's gas & electricity meter reading & meter operator commercial contracts worth in excess of £100m p.a. • Management & maintenance the meter reading call off process covering over 45m work requests p.a.• Provision of accurate & timely monthly accruals to Finance to forecast expenditure committed but not invoiced for in any given month.• Management of Metering invoice processing & validation team & associated Financial processes.• Undertaking analysis to identify potential commercial opportunities & work with Contract Management & IS teams to deploy associated changes.

• Developed & produced accurate & timely MI to extract the maximum value from 68 gas & electricity meter reading & meter operator commercial contracts work more than £200m p.a. • Provision of ad-hoc data extraction, MI & performance analysis service to meter reading & meter operator contract management teams, special projects, finance, regulatory, marketing etc. as required. • Creation and migration from legacy to SAP of 18m new meter reading walk orders.• Provision of robust financial control framework for the receipt, reconciliation & payment of company expenditure to standards that meet or exceed external audit best practice & contractual SLAs. • Supported Finance with the development of the annual & 5 year operational expenditure plans for metering.• Provision of accurate & timely monthly accruals to Finance to forecast expenditure committed but not invoiced for in any given month. • Responsible for the identification of new opportunities to reduce costs with Metering . • Leading metering related projects or working closely with project teams that are impacting metering to ensure that business benefits were being delivered & tracked accurately.

• Business Project Manager for all systems & process changes relating to meter reading and meter reading contracts. • Full life cycle management of changes, liaison with internal & external IS Service providers, representing the business at industry change forums & Business Investment Appraisals. • The key projects underway at the time included the development of Joint Meter Reading methodologies, the development & implementation of Release 2 of the Meter Control System (MCS) and the initial conception work for Meter Unbundling.• Day to day management of National Metering budget covering expenditure of c.£150m p.a. • Metering Risk Analysis and Risk Management.

• Lead a team of 8 Business Analysts in COSMO (Customer Operations Systems Management) responsible for the project management of changes to IS systems on behalf of business stakeholders. • Utilising CPPOLDAT to manage change lifecycle from the capturing of business requirements, building compelling business cases, commissioning suppliers (via IS), through to business acceptance testing & implementation. • The role also involved representing the company at industry forums to ensure that the implications of any proposed industry changes were understood and mitigated.

• Responsible for a work planning & work dispatch team covering c.250 service engineers across the Southern Area of the UK. • Accountable for engineers having appropriate volume of pre-planned annual service work and variable unplanned breakdown work in tight geographical locations to ensure maximum productivity. • Responsible for forecasting variable breakdown work and delivering the correct mix with planned work whilst maintaining high levels of customer service.