Completion Report

Project Summary:

The project has successfully installed and configured the Webcentral based Compliance Management module for use by the Estates Department Technical Services Group.   Having installed the module, all monthly compliance checks associated with Emergency Lights, Water Temperatures are now being scheduled and monitored on a monthly basis.  In addition, the staggered periodic checks of all lifts are now being scheduled and monitored.  The roll out of the remaining periodic checks will be subsequently controlled by the Technical Services Group. In addition, it should be noted that the added requirement to upgrade Archibus to version 21.2 has also been successfully completed.

In reviewing the business objectives and project deliverables;

 

No

Description

Comments

O1

Identify the business requirements with regards to cyclic maintenance in relation to both statutory compliance inspections and planned maintenance of plant assets throughout the University estate incorporating subsequently identified remedial work.

Delivered

D1

To produce a detailed business requirements document incorporating all associated workflow processes

Completed  

D2Prioritise all identified business requirements with regards to the following classification; mandatory, highly desirable, desirableCompleted
D3Define acceptable level of business requirements to be deliveredBased on must have requirements
D4Prepare a technical recommendation regarding the existing infrastructure being sufficient to deliver business requirementsNot required, having subsequently determined that very low system usage by four members of staff in Technical Services Group
O2Ascertain if the current 'out of the box' version of WebCentral would provide a solution that meets the acceptable level of business requirementsDelivered
D1

Prepare a gap analysis in relation to the defined business requirements classifications and the functionality offered by the  standard WebCentral (currently version 20.2)

A Gap Analysis report was prepared with the assistance of external consultancy and it was determined that the Compliance Management module would deliver the basic requirements to schedule, monitor and report on compliance related activities
D2Prepare time and cost based estimation to implement any additional configuration requirements relating to WebCentral to meet acceptable level of business requirementsNot required
O3

Determine possible alternatives if the gap analysis determines that WebCentral is deemed not fit for purpose

Not required
D1Identify and review alternative externally supplied solutions and determine costsN/A
D2Prepare detailed time and cost estimation to implement an agile based development associated with the business requirementsN/A

O4

Propose recommended strategy that meets the acceptable level of business requirements

Not required having determined that the Compliance Management module would deliver the basic requirements  

D1

Prepare revised project plan to implement solution

Project plan was prepared to implement Compliance Management module  

O5Implement WebCemtral on the basis that it meets the meets the acceptable level of business requirementsDelivered
D1Provide the ability to hold the all the required building details and associated assetsExisting building details utilised. Deciision taken to only utilise assets for periodic compliance checks
D2Automate the schedule of building visits on an annual periodic basis with regards to both planned maintenance and statutory compliance inspectionsSchedule has been configured by the Technical Services Group
D3Provide work instructions details on both paper and electronic formatThis is in place and was put together by John Shields. It is specific to the steps required within the compliance Module to set-up regulations and events.  It is not fully complete but almost there
D4Provide a workflow process regarding planned and any associated remedial work from initial recording through to completion and sign-offCompleted by business analyst and approved b project team
D5Provide the ability to either manually record compliance data  or electronically import relevant documentationUtilising existing processes to record compliance data with option to link compliance data relating to each specific compliance event
D6Provide alerts regarding overdue building visits and outstanding planned and associated remedial workDetailed via RAG status view

 

Analysis of Resource Usage:

Staff Usage Estimate: 111 days

Staff Usage Actual: 122 days

Staff Usage Variance: 10%

Other Resource Estimate: 0 days

Other Resource Actual: 0 days

Other Resource Variance: 0%

Explanation for variance:

In reviewing the overall project resourcing, the reason for the discrepancies are as follows:

  • Project Management - additional project management time due to project carrying over into 2014-15 and the monitoring of the pilot between August and October
  • Business Analysis - additional time required to assist with additional process flows and presence during the elongated pilot period
  • Development Technology - whilst additional time utilised, it should be recognised that the time set aside (but not utilised) to invesigate the mobile technology was offset by the additional time required to undertake the upgrade to Archibus 21.2
  • Development - no development requirements were identified as part of the project

 

TeamEstimted ResourceActual ResourceDifference
Project Management4859+22%
Business Analysis1640+150%
Development Technology1518+20%
Development201.5-92%
Applications Management63-50%
Technical Management10.5-50%
QA Sign-off Meetings5  
Total111122+10%

.

Key Learning Points:

When selecting package solutions, ensure there is a full understanding within the project team of the functional capabilities within the package.

  • The selected Compliance Module us a relative new member of the WebCentral product suite and whilst appeared to deliver the overall requirements, the assumption made during the inital evaluation, namely the full connectivity between The Compliance Module and the On-Demand (work order) functionality was subsequently proved to be incorrect.  To overcome this, the project could have undertaken an initial proof of concept within a workshop environment using a set of predefined requirements

User Training

  • Insufficient product awareness after the initial user training elongated the initial configuration within Test environment.  To overcome this, additional external consultancy resource could have been utilised to provide help and guidance during the configuration phase

Noted Improvements regarding the technical installation (as part of the upgrade to 21.2).

  •  MASS usually deliver the latest version of the application, in the form of a war file to be unpacked on tomcat.  They also deliver a set of scripts for making any changes to the AFM schema and its data.  Both these steps worked quite well.  However, it has been  suggested  that a project be set up in SVN, to contain anything that we receive from MASS.
  • MASS also provided a number of Excel spreadsheets required to be loaded, which are not included in the deployment plan (and need to be done by someone with access to the LIVE application).
  • There were a number of minor issues encountered post deployment that required to be resolved that have since been documented and will be taken into account for any subsequent upgrades

 

 

 

 

Outstanding issues:

Whilst ther are no outstanding issues, it has been recognised that furtehr analysis of teh reporting capabiliy supplied by the standard 'out of teh box' version has to be fully evaluated .

Project Info

Project
E&B Compliance Management System
Code
EST074
Programme
Estates General Programme (EST)
Project Manager
Andrew Stewart
Project Sponsor
Geoffrey Turnbull
Current Stage
Close
Status
Closed
Start Date
23-Aug-2013
Planning Date
n/a
Delivery Date
n/a
Close Date
28-Nov-2014