Key facts
| Organisation | Enserve Group, utility services across nine autonomous divisions |
|---|---|
| Role | Business Intelligence Consultant |
| Dates | July 2011 to December 2017 (6 years 6 months) |
| Type | Contract; 20 renewals (old CV says 22) |
| Location | Greater Leeds Area |
| Relationship | Enserve Group is Spice PLC renamed, so this contract continued directly from a decade as a Spice employee (1999 to 2011) with the same organisation. Metro Rod was a division of it, and NG Bailey later bought the Freedom Group from the same family. One corporate relationship spanning roughly 27 years. The engagement ended with a change of ownership and contractor policy, not delivery. |
| Status | To confirm — using 20 renewals (matches LinkedIn); old CV says 22. Start month differs: old CV Aug 2011, LinkedIn Jul 2011. |
| Knowledge base | Personal\CV\kb\employment\2011-07-enserve.yaml |
Summary
Lead business analyst and solution architect for an enterprise data warehouse and SharePoint business intelligence platform across the Enserve Group's nine autonomous divisions, over six and a half continuously renewed years.
Achievements
- Renewed 20 consecutive times over six and a half years as the Enserve Group's business intelligence consultant.
- Designed and delivered an end to end business process reengineering project on meter reading contracts in the Utilities division, streamlining the process while capturing detailed costing information. The work was key in increasing profit on a single contract by £50,000 per month.
- Lead business analyst and solution architect on a project delivering an enterprise data warehouse and SharePoint business intelligence platform to the Enserve Group.
- Developed a business intelligence strategy meeting the needs of the organisation.
- Designed and implemented an enterprise data warehouse following Kimball methodology.
- Mapped and analysed financial processes in nine autonomous Enserve divisions.
- Introduced group wide master data management consolidating divisional charts of accounts into an agreed enterprise structure using conforming attributes in the nominal accounts dimension.
- Designed and delivered an SSIS ETL process extracting data from nine discrete divisional ERP systems into the enterprise data warehouse.
- Developed a bus matrix mapping key Enserve financial processes to the conformed dimensions enabling their analysis.
- Designed star schema data marts with transactional fact tables enabling analysis of sales, purchasing, expense, project costing and financial accounting processes.
- Designed star schemas with snapshot fact tables enabling analysis of accounts receivable and accounts payable.
- Designed and delivered multidimensional SSAS cubes with measure groups for each data mart.
- Designed and built a three tier SharePoint 2010 farm running Power Pivot Services, Excel Services, Performance Point Services and SSRS Reporting Services.
- Created a SharePoint 2010 web application using Kerberos authentication.
- Created a business intelligence site collection with sites for each Enserve division and sub sites for their contracts.
- Developed Power View board reports for the purchasing and health and safety divisions over a Power Pivot model published to SharePoint, augmenting warehouse facts with facts not yet captured in the warehouse.
- Developed a proof of concept moving on premise SharePoint and BI solutions to Office 365 and Power BI.
Technologies
SQL Server, SSIS, SSAS, SSRS, SharePoint 2010, Power Pivot, Power View.
Sources
The old CV (CV-MD-02.docx) and the LinkedIn experience capture of 5 October 2026. Relationship context and relevance ratings agreed with Matthew, 8 October 2026.