June 2021 Update

Report Date
June 2021

EOO Programme Update 

Section One: Programme Commentary, RAG and Resources Update

Estates Systems Optimisation Programme seeks to improve Estates business functions through Business Transformation of Systems, Processes and Roles.

- Systems will be reviewed and refreshed, moving from a large number of small-scale, single-use systems, to an integrated, designed model of multi-use systems, consolidating the numbers of applications and partners used.

- Current and Future processes will be analysed and documented to enable functional design and technical workflows 

- Business-as-Usual models including Target Operating Models and role profiles will be defined

Full 'whole-life' Total cost of Ownership solutions will be defined based on IT best-practise, such as Information Technology Infrastructure Library (ITILv3) to ensure end state solutions are reliable, supportable and maintainable as ‘Business-as-Usual’ services.

The Systems Optimisation programme will have a small number of large-scale multi-year projects.  Projects will consider improvements to systems, processes and team capabilities where necessary and agreed.

The programme currently consists of the following live projects:

No further projects been identified by Estates.

No projects have been closed this month.

Project Updates

  1. EST131 Estates  Compliance Management now reports a GREEN status despite requiring additional budget for resourcing which has now been approved the project continues to make good progress with UAT being signed off with the exception of emergency lighting assets which requires further development work subject to approval

   2. EST123  Estates CAFM Stabilisation now reports a GREEN status. Whilst work has taken longer on the functionality review for Archibus and the Business Continuity Plan and DR Plan deliverables the milestones have been extended to take this into account. Good progress has been made on the disaster recovery and continuity plans but further work is required on the functionality review.  The project is now due to be suspended by the end of July to allow the P&M Phase 3 work to continue. Once this is completed then the Archibus upgrade can be started.

   3. EST129  Estates Business Readiness and Adoption of SEP P&M  Continues to report a RED status based on dependent partner SEP P&M projects are reviewing scope and re-planning.  EST129 has no visibility of the proposed scope change and re-plans.  There are twelve workstream defined within EST129.  The overall workstreams progress status is Green, reflecting good progress.  The Brief, Budgets and IS effort have been resubmitted and approved by EST129 Stakeholders and WIS during June for 20/21 and 20/22. 

4. EST133 Estates Power Monitoring Expert Server   Reports a GREEN Status as work has been completed. Project will be closed once the deployment checklist has been completed as there is one item that are outstanding plus a query about whether the project should move from a pilot to live or be decommissioned.

5EST134 Estates Building Energy Management System (BEMS) Server Upgrade - Reports a GREEN status as project as now been initiated with the PID approved and commissioning of 2 new virtual servers underway

Therefore, the overall status of the EOO programme is set to GREEN.

Section 2 -Programme RAG Overview & Forward Look -

Section Three: Projects in Progress

Project Info

Project Managers Commentary

 Estates  Compliance Management  

EST 131

Milestones 

Target Date

Title

20/11/2020

Planning - completed

26/08/2021 Go Live
06/09/2021 Close

 

RAG Status

GREEN

Achievements Last Period

  • UAT testing commenced
  • UAT testing completed and signed off 
  • Emergency Lighting asset data is not suitable for Estates in current configuration in Zetasafe- 
  • Remedial tasks cannot be closed via Zetasafe mobile app so business process needs to be agreed

 Next Steps

  • Emergency lighting API development work
  • Data cleansing work for Live
  • Creating inhouse training material

Risks

Risks are detailed at the following link  

Issue, changes, Assumptions & Decisions

  • Emergency Lighting asset data is not suitable for Estates in current configuration in Zetasafe- 
  • Remedial tasks cannot be closed via Zetasafe mobile app so business process needs to be agreed

  • Additional resourcing required due to data cleansing work - Approved by WIS on the 25/06/21

  • Decision required on additional development costs for emergency lighting

Milestones

Stage Milestone Original Date Previous Date Current Date End of Stage Complete Date Completed
Initiate Initiate (Major) 28-Aug-2020   28-Aug-2020 Yes Yes  
Plan Planning (Major) 23-Oct-2020   23-Oct-2020 Yes Yes 20-Nov-2020
Analyse Requirements Agreed 04-Dec-2020   04-Dec-2020 No Yes 18-Dec-2020
Procure Procurement completed 26-Feb-2021 26-Feb-2021 07-May-2021 No Yes 07-May-2021
Build System Build 31-May-2021   31-May-2021 No Yes 04-Jun-2021
Accept UAT signed off 17-May-2002 17-May-2002 21-Jun-2021 No Yes 25-Jun-2021
Accept Pilot Complete (Phase 1) 28-Jun-2021   28-Jun-2021 No No  
Deliver Training Complete (Phase 1) 16-Jul-2021   16-Jul-2021 No No  
Deliver Phase 1 - In house go-live (Major) 22-Jul-2021   22-Jul-2021 Yes No  
Deliver Phase 2 - External contractor go-live (Major) 26-Aug-2021   26-Aug-2021 Yes No  
Close Project Close (Major) 25-Jun-2021 25-Jun-2021 06-Sep-2021 Yes No  
Accept Deployment sign off review 21-Jun-2021 21-Jun-2021 06-Sep-2021 No No

 

Estates CAFM Stabilisation

EST123

 

 

Milestones  

Target Date

Title

Feb 2021

Scoping 

Aug 2022 Delivery
Sept 2022 Close

 

RAG Status

GREEN

Achievements Last Period

  • Archibus functionality review paper has been reviewed and a series of actions have been passed to Mass
  • Disaster Recovery review has been completed pending review

Next Steps

  • Complete Archibus functionality review following discussions with Mass 
  • Complete Disaster Recovery and Business Continuity planning
  • Place project on hold once the above has been completed

 Risks - Link to risks here

Issue, changes, Assumptions & Decisions

No changes

Milestones

 

Stage Milestone Original Date Previous Date Current Date End of Stage Complete Date Completed
Analyse WP2- Analysis of functionality completed 05-Mar-2021   05-Mar-2021 No Yes 24-May-2021
Procure WP1 - Purchase Harman 15-Mar-2021   15-Mar-2021 No Yes 11-Mar-2021
Accept WP1 - Harman UAT acceptance for software and solution 15-Mar-2021   15-Mar-2021 No Yes 05-Mar-2021
Analyse WP3 - Review of current BCP and DR Plan documents 15-Mar-2021   15-Mar-2021 No Yes 28-Apr-2021
Deliver WP1 - Harman Flash Go Live - Major 31-Mar-2021   31-Mar-2021 Yes Yes 25-Mar-2021
Deliver WP3- Archibus Business Continuity and Disaster Recovery Plan (Major) 30-Apr-2021 25-Jun-2021 30-Jun-2021 Yes No  
Deliver WP2- Archibus version comparison options paper with- review and approval for next steps  (Major) 31-Mar-2021 14-May-2021 02-Jul-2021 Yes No  
Plan Suspend project (Major) 01-May-2021 01-Jun-2021 16-Jul-2021 Yes No  
Initiate WP4- Estates approval to commence upgrade  work 25-Oct-2021   25-Oct-2021 Yes No  
Execute WP4- Start Archibus upgrade 25-Oct-2021 25-Oct-2021 01-Dec-2021 Yes No  
Initiate Unsuspend project (Major) 01-Oct-2021 01-Oct-2021 01-Dec-2021 Yes No  
Plan WP4- End of Planning - Major 20-Dec-2021 20-Dec-2021 14-Jan-2022 Yes No  
Design WP4- Mass Delivered Prototype 21-Feb-2022   21-Feb-2022 No No  
Accept WP4- Initial UoE System Testing 25-Mar-2022   25-Mar-2022 No No  
Accept WP4- Start UAT 04-Apr-2022   04-Apr-2022 No No  
Build WP4 UoE/Mass Bug Fixing 27-May-2022   27-May-2022 No No  
Deliver WP4- Go Live - Major 15-Jul-2022   15-Jul-2022 Yes No  
Accept WP4- End & Sign off UAT - Major 30-Aug-2022   30-Aug-2022 Yes No  
Accept WP4- Deploy sign off 01-Aug-2022 01-Aug-2022 16-Sep-2022 No No  
Close WP1, WP2, WP3, WP4 - Project Close (Major) 24-May-2021 30-Sep-2022 01-Nov-2022 Yes No  

Estates Business Readiness and Adoption of SEP P&M 

EST129

 

Milestones Dates are available at this link

RAG Status – Remaining RED

 

 

 

 

 

 

 

 

Achievements Last Period

Overall status is Green, specific deliverable by workstream are listed in the following table.

Work stream

(Defined Key Date Schedule)

Achievement

Archibus Changes

Analysis on changes required started. 

 

For Information, this works stream has been deprioritised to divert EST129 resources to support Finance Operations.

Change Management & Communications

Work has started to Identify Estates Resources that will be impacted by SEP P&M.  The Estates Staff Scheduler.

 

For Information:

  1. The Estates Staff Scheduler will be used to identify and monitor Estates resources activity at each stage of the project where applicable: SIT, UAT, Training, Go Live and Communications.  
  2. A new SEP P&M lead has been identified at the programme leads meeting, mid-June. The lead will cover Training, Change Management & Comms.

Data & Document Migration

  1. Continued to support ad hoc data requests from SEP P&M.   Including Accounts Receivable (AR) Data for UoEESCO.
  2. Assessed deliverables from Historical Data Storage (HDS) project.

Finance Operations (People / Organisation/ Process Re-Design)

  1. Analysis on Estates Chart of Accounts {COA (including POETA)} at a mature stage.  Estate team have CoA approach had included rationalisation of codes. Early versions shared with Project Modules Leads.
  2. Capital Assets definition & design for inclusion in set up for new projects 70%.  FIRST.
  3. Receivable Work package closed with identification of Debtor Reports, included in Work Stream Reporting.
  4. Finance Leases discovery 100%.
  5. Karen Adamson confirmed Estates Internal Transfer (EIT) processes on P&M.  Further discussions held with SEP P&M.

Go-Live

A new SEP P&M lead identified.  A high level overview on scope was provided at the programme leads meeting, mid-June.

Planning

  1. Regular meetings scheduled with each work stream managed by Programme lead to: monitor & record progress, identify & manage Risk, Issues, Decisions, and Dependencies.  Evidence of query management by work stream leads.
  2. Regular forums with Estates Stakeholders (weekly) and key SME (monthly, Steering  group) established.
  3. Risk & issues reviewed by IS Senior Supplier, Estates Programme Lead and EST129 Project Manager.
  4. The Project Brief, approved by Stakeholders was submitted and approved by WIS on the 15th June, Resubmission to reflect Work Breakdown structure and IS effort.  Recommendations from WIS review applied.

Process re Design

Included in Finance Operations & Procurement Operations work stream.

Procurement Operations (People / Organisation Process Re-Design)

  1. High level Visio mapping of the hand offs between Procurement Operations and Estates for Route 1 procurement (Over £1K, less than £50K with quotes) has been drafted. These files are now with Procurement for verification, next steps would be to share these with the Estates SLT.
  2. The work packages for the procurement work stream have been created and are currently with Procurement operations for detailed review. Priorities have been identified as follows:
  • DAS work package
  • Reporting

Reporting

A new SEP P&M lead identified. 

 

Estates report requirements defined, based on As Is reporting.  

System Integration Testing (SIT)

Work streams: Finance Operations, System Integrations, Procurement Operations and Reporting have started to define Estates User scenarios in preparation for SEP P&M managed SIT.

System Integrations

Good Progress on all deliverables.

 

Noted that the SEP P&M programme for Integrations will include build of the Enterprise Data Warehouse (EDW) to provide storage of historical data from P&M transactions.

Training & Support

Refer to Change Management & COMMS for latest status

User Acceptance Testing (UAT)

Work identified for SIT will feed into UAT.

 

Next Steps

Planned activities for July are listed in the following table, with key dependencies:

Work stream

(Defined Key Date Schedule)

Next Steps

Dependency for work stream.

Archibus Changes

On Hold.

System Integrations, SEP P&M Signed off PDDs and SDD.

Change Management & Communications

Continue to Build the Estates Staff Scheduler.

 

 

Await delivery of scope and detailed plans from the SEP P&M team.

Data & Document Migration

No specific actions planned for July. 

 

For August expectations set that support required for output from Project Module deep dive sessions.

Await delivery of scope and detailed plans from the SEP P&M Project.

Finance Operations (People / Organisation/ Process Re-Design)

  1. Karen Adamson approved version 1 release of the CoA on 1st July.
  2. Karen Adamson to review and comment on Capital Assets process flow in SEP P&M.
  3. Project Modules deep dives scheduled EST129 & SEP P&M for July & August.
  4. Request meetings for VAT Compliance overviews to validate impact on Estates (Rules & Processes).
  5. Review SEP P&M Spotlight communications to validate rules and how applied in P&M to support work packages defined for: Invoicing, Refunds, Budget and Period Close and Year End.
  6. Support P&M definition and design of EIT processes.

Await SEP P&M playback on:

  1. Open questions CoA.
  2. Definition and Design of P&M solution for EIT processes in P&M.

Go-Live

No specific actions planned for EST129.

Await delivery of scope and detailed plans from the SEP P&M team.

Planning

Business As Usual activities to maintain project reporting and support for deliverables.

When SEP P&M scope and plans released an Impact Assessment & re planning exercise will be required.

Process re Design

Included in Finance Operations & Procurement Operations work stream.

 

Procurement Operations (People / Organisation Process Re-Design)

  1. DAS modelling continues and will be presented to the Estates SLT on the 5th July & EST129: SEP P&M Steering Group 6th July 202
  2. Time booked with Reporting Work stream lead to validate Reporting.

 

Work packages (not listed to the left) await prioritisation from the SEP P&M team).

 

Reporting

Karen Adamson planned to sign off July 2nd.

 

Reports list to be shared with New SEP P&M lead.

Await delivery of scope and detailed plans from the SEP P&M team.

System Integration Testing (SIT)

Continue exercise to support definition of Estates Users scenarios as knowledge is built on SEP P&M deliverables.

Await delivery of scope and detailed plans from the SEP P&M team.

System Integrations

Continue to support SEP P&M Project to deliver integrations to Estates Third party systems: Archibus (EBIS) and myProject.

Await delivery of scope and detailed plans from the SEP P&M team for EDW.

Training & Support

Refer to Change Management & COMMS for latest status.

 

User Acceptance Testing (UAT)

No specific activities defined for July.

Await delivery of scope and detailed plans from the SEP P&M team.

 

Risks

Risks are detailed at the following link. The project remains on overall RED Rag status

  

Issue, changes, Assumptions & Decisions;

These are detailed at the following link and cover the challenges with Scope, Time and Effort based on delay of SEP P&M plans. 

Milestones

Milestones Dates are available at this link

 

Estates Power Monitoring Expert Server 

EST133

RAG status GREEN

Achievements:

  • Work completed

Planned

  • Project to be closed once deployment checklist completed and decision on whether system should go live or be decommissioned

 Estates Building Energy Management System (BEMS) Server Upgrade

EST134

RAG status GREEN

Achievements Last Period

  • PID signed off
  • Initial technical discussions with Schneider
  • 2 virtual servers ordered

Issues / Outstanding

  • None

 Next Steps

  • Build completed on virtual servers by IS
  • Software and config set up by Schneider
  • Migrate data

Risk Log

No new risks. Risk log can be found here 

Stage Milestone Original Date Previous Date Current Date End of Stage Complete Date Completed
Initiate Project Initiation 28-May-2021   28-May-2021 No Yes 28-May-2021
Plan Planning Milestone 04-Jun-2021 04-Jun-2021 11-Jun-2021 No Yes 11-Jun-2021
Execute UoE Infrastructure Delivery 25-Jun-2021   02-Jul-2021 No No  
Execute User Acceptance Sign Off 16-Jul-2021   16-Jul-2021 Yes No  
Deliver BEMS Upgrade Go Live 26-Jul-2021   26-Jul-2021 No No  
Deliver Deployment Sign Off 28-Jul-2021   28-Jul-2021 Yes No  
Close Project Close 31-Jul-2021   31-Jul-2021 Yes No

Section Four: Closed or Withdrawn Projects

None

Section Five: Programme Risk Register 

Risk

RAG

Comments

     

Availability of Estates staff

RED

Lack of progress due to Estates staff availability

Delay in P&M Integration work on EST129 RED Lack of clarity and timelines on P&M / SEP projects
     
Programme Status
RAG Status
Overall
GREEN
Has formal escalation taken place?
No
RAG Commentary
All projects are GREEN with the exception of EST129