Completion Report

Completion Report reviewed  by the following:   

Craig Henderson

Jeff Borthwick

Simone Martin

Dorothy Cunningham

John Allison

Stella Mackinnon

Anne Finnan

Heather Larnach

Julieta Pineda

Nikki Stuart

Paul Ranaldi

 

Comments received from the following:

Nikki Stuart     

--------------------------------------------------------------

PPS008: eCommerce Implementation: Completion Report

Caveat

The completion report has been written by the incumbent project manager, appointed in February 2016. Comments have collated from others who have a longer association with the project

Objectives Analysis  

 

Objective

(as stated in original Brief)

 

Objective Status

(Achieved / Partially Achieved / Not Achieved).

Commentary.

 

O01

Migrate all PECOS users onto SciQuest by the end of November 2015.

 

Not Achieved.

 

Actual migration of users to PECOS was de-scoped from project.

 

O02

To migrate the required suppliers that are on PECOS onto SciQuest.

 

Achieved.

 

 

O03

To implement any interface improvements identified during analysis phase.

 

Achieved.

 

 

O04

To decommission PECOS

 

Not Achieved.

 

Actual migration of users to PECOS was de-scoped from project.

 

 

Deliverables Analysis

 

 

Deliverable

(as stated in original Brief)

 

Deliverable Status (Delivered / Partially Delivered / Not Delivered).

Commentary.

 

D01

Requirements gathering and analysis with key stakeholders.

 

Delivered.

D02

Existing interfaces documented.

 

Delivered.

 

 

D03

Gap Analysis for eProc(eFin)/ SciQuest.

 

Delivered.

 

 

D04

Investigating, and if possible, implementing an option for a Good’s Receipting facility.

 

Delivered.

 

 

D05

A facility for ensuring the use of valid and current codes.

 

Delivered.

D06

A method of maintaining user accounts and ensuring valid authorisation.

 

Delivered.

D07

Communication plan for rollout and advising users of the change.

 

Not Delivered.

 

Roll-out de-scoped from project.

 

D08

User Training provided and eProcurement Help documentation updated.

 

Not Delivered.

 

Roll-out de-scoped from project.

 

D09

Decommissioning of PECOS.

 

Not Delivered.

 

D10

All the required suppliers moved over from PECOS to SciQuest prior to the Go-Live date.

 

Partially Delivered.  

Key suppliers set up in Sciquest, but not exhaustive list.

 

D11

All users moved across from SciQuest to PECOS

This deliverable should be stated as moving users from PECOS to SciQuest.

 

Not delivered.

Roll-out de-scoped from project.

 

 

 

 

Scope Analysis  

 

Scope

(as stated in original Brief)

 

Scope Status (Scope Delivered / Partially Delivered / Not Delivered).

Commentary.

 

S01

The outcome of PPS003 has recommended the retention of SciQuest, so the project will primarily be concerned with moving users who use PECOS to SciQuest. As PECOS will no longer be supported by the Procurement Office, this system will be decommissioned.

 

Partially Delivered.

 

Migration of PECOS users to SciQuest has been de-scoped.

 

Decommission of PECOS has been de-scoped.

 

S02

PECOS offers some functionality that is not isn’t currently provided by SciQuest. As the analysis progresses, the project will determine which functionality can be replicated in SciQuest.

 

Delivered.

 

 

S03

PPS003 informed the business decision to make SciQuest the system of choice but there still remains some analysis into how the desired integration with existing Finance and Procurement systems will be achieved. This work was de-scoped from PPS003 and will now form the first phase of the eCommerce Implementation. The initial request for signoff is therefore for the budget to complete the analysis to complete the integration requirements with a further milestone to request authorisation for the remainder of the project to proceed following once this is complete.

 

Delivered.

 

S04

As well as transferring users from PECOS, a number of integrations are desired to allow for the most efficient operation of SciQuest, both from a user and a support perspective. Although eProcurement would like to investigate these integrations and if possible implement them, they are not considered essential to the success of the project. The current business processes can support the transfer of the users from PECOS to SciQuest without any changes.

 

Delivered.

 

Integrations included into scope of project.

 

S05

An analysis of the requirements for these integrations and how the interfaces and functionality can be achieved, will be undertaken to produce more detailed requirements and identify any opportunities to standardise interfaces, and reduce support effort.

This work is needed to provide more detailed requirements into how the project objectives can be achieved and an overarching project plan can be produced.

 

Delivered.

S06

Not in Scope This project will not cover:

 

Any investigation or contribution to the decision between SciQuest and PECOS. SciQuest has already been chosen as the system the Procurement will support and this was covered by project PPS003.

Not Delivered.

 

SciQuest chosen as the procurement solution.

 

 

 

 

 

 

Project Schedule  

The project commenced in October 2014, with the completed code interfaces delivered in January 2017. The overall project schedule from initiation to completion is 29 months.

Key Milestone History  

Key Milestone

Baseline Date

Final Date

Planning

26/03/2015

26/03/2015

Acceptance sign-off

24/03/2016

19/08/2016

Deployment

04/04/2016

26/08/2016

Deployment sign-off

25/04/2016

17/02/2017

 

 

 

Budget Analysis

Budget Evolution

 

Date changed

Budget (days)

1. Original estimate

 

180

2. Project re-plan

30/11/2015

257

3. Project re-plan

23/03/2016

275

4. Project re-plan

29/09/2016

319

5. Project re-plan

21/10/2016

355

 

 

 

Final spend Analysis by Team

Team

Sum of Actual Effort/1d

Application Development

187

Application Mgmt

21

DT

14

Business Analysis

8

Project Mgmt

103

Tech Mgmt

1

Grand Total (days)

334

 

Final spend Analysis by phase

Phase

Sum of Actual Effort/1d

Build

197

Close

0

Initiation

7

Overhead

130

(blank)

 

Grand Total (days)

334

 

(For more spend analysis refer to the following analysis –K:\ISAPPS\csg\projects\PPS008\Project Completion\Project Extract - Task-Resource 2016-02-10.xlsx)

 

 

Key Issues / Learning Points  

 

Issue

Details

01

Excessive length of project

 

The planned project duration was approximately 12 months, and eventually ran for 29.

 

- The early phases of the project were delayed significantly due to the original PMs extended sick leave. A new PM should have been assigned at that time.

 

- 3 different project managers assigned at various stages of the project.  

 

- The design phase suffered from a lack of direction with a large number of days being spent with very little output.

 

- The length of time from the start of the project and the build tasks resulted in missed or poor specifications during the build.

 

- With the extended duration, a disproportionate amount of time was spent on project management activities (31%).

 

- The extended duration led to a lack focus and resourcing issues within development organisation.

 

- Lack of focus within the procurement organisation.

 

02

Lack of End-to-end testing of finance systems

 

Issues were encountered with the live printing of purchase orders within finance. The issue was relatively easy to fix, but highlighted the need to be able to run end-to-end tests across procurement and finance systems.

 

03

Complexity encountered around parallel and competing estates project EST083

 

A number of issues arose with the interaction between this project and an Estates project designed to re-align procurement and financial processes.

 

 

 

 

 

 

 

Outstanding Tasks  

 

Issue

Details

01

Migration of PECOS users to SciQuest.

 

Migration removed from scope of project. However, all the enablers are in place.

The procurement organisation can plan a migration schedule without the need to involve IS.

 

02

De-commission of PECOS system.

 

De-commission removed from scope of project.

A small project or application management activity will be required to pick this up once all users have migrated off PECOS.

 

03

PO Interface Changes

Development work has been done but not implemented.

These changes are to support the transfer of enhanced data into the finance systems.

 

See https://www.jira.is.ed.ac.uk/projects/PPS008/issues/PPS008-99

 

 

 

 

Acknowledgments

Thanks go to the entire team who have persevered with this project over a long period of time.

Procurement Team Craig Henderson Jeff Borthwick Simone Martin Andy Martin Dorothy Cunningham

Development Team John Allison Stella Mackinnon Emilio Lopez

Production Mgmt Anne Finnan Paul Ranaldi Heather Larnach Julieta Pineda

Project Services Nikki Stuart Sally Hayward Dawn Holmes

 

Project Info

Project
eCommerce Implementation (PPS008)
Code
PPS008
Programme
Z. Procurement (PPS)
Management Office
ISG PMO
Project Manager
Chris Lawford
Project Sponsor
Craig Henderson
Current Stage
Close
Status
Closed
Start Date
11-Nov-2014
Planning Date
n/a
Delivery Date
n/a
Close Date
17-Feb-2017
Programme Priority
1
Overall Priority
Normal
Category
Compliance