Completion Report
Project Summary:
Contributors
| Date | Name | Role |
|---|---|---|
| 28-Jan-2013 | Morna Findlay | Project manager |
| 28-Jan-2013 | Paul Cruickshank | Project Sponsor |
| 28-Jan-2013 | Andrew Stewart | Programme Manager |
| 28-Jan-2013 | Liz Torrance | Business Area Representative (Estates and Buildings) |
| 28-Jan-2013 | Donna Archibald | Business Area Representative (Finance) |
| 28-Jan-2013 | Stella Mackinnon | Development Lead |
| 28-Jan-2013 | Mike McMonagle | Developer |
| 28-Jan-2013 | Anne Finnan | Production Management /UAT quality assurance |
| 28-Jan-2013 | Ron Mcleod | Production Management |
| 28-Jan-2013 | David Foggo | Production Management |
| 28-Jan-2013 | Riky Harris | Development Technology |
| 28-Jan-2013 | Susan McKeown | Former Project manager |
| 28-Jan-2013 | Anne Mathison | Former Project Manager |
Deliverables, Scope and Objectives
Paul Cruickshank noted that Estates had originally wanted this project to include updates from Finance (advanced transaction report) being sent nightly back to Estates and incorporated into the Estates database. None of the project managers attending the meeting, or other project team members could recall this requirement and it has not been included in an the BRD, nor recorded as having been dropped from scope at any point in the project. Therefore only income and not expenditure is included. Deliverable D1 may refer to this.
All recorded deliverables recorded in the BRD were achieved.
| O1 | Transfer lease sales invoice data directly from EBIS to eFinancials (via CLINK) | |
| D1 | Interface which will transfer the Lease Sales Invoice information from the Archibus to CLINK for Sales Ledger S11 in eFinancials | IS Apps |
O2 | Eliminate duplication of effort and reconciliation between eFinancials and EBIS |
|
D1 | Removal of duplicated effort and reconciliation between eFinancials and EBIS | Estates |
O3 | Trigger for interface to run (due to special timing requirements for period 1) |
|
D1 | Mechanism for calling the interface | Mass |
O4 | Interface to be run on a monthly basis |
|
D1 | Monthly send to CLINK agreed with Finance | Estates/ Finance |
O5 | Interface to update Archibus that invoices have been extracted |
|
D1 | Archibus to have flag set that the interface has extracted the invoices (ie it is now an actual in Archibus) | IS Apps/Estates/ Mass |
O6 | All development to be completed against eFin4 |
|
D1 | Development completed against eFin4 | IS Apps |
O7 | Invoices and Credits to be sent in separate batches |
|
D1 | Separate batches for Invoices and credits | IS Apps/ Estates |
O8 | Payments of all types will have their payments concatenated into one invoice |
|
D1 | One invoice for all payments | IS Apps/Estates |
O9 | Email notification on completion of the interface running to be sent to Finance, Estates and Production Management |
|
D1 | Success email notification sent to Finance, Estates and Production Management | IS Apps |
D2 | Failure email notification sent to Finance, Estates and Production Management | IS Apps |
O10 | Business Requirements produced for interface |
|
D1 | Business Requirements Document which will include a Business Spec of the mappings required for the Interface | Estates/ Finance/IS Apps |
Schedule
This project remained on schedule until July 2011, The project was then subject to several severe delays:
- Project EST060 did not deliver the property and lease module till February 2012. This project depended upon EST060 and so could not proceed into the acceptance phase until then.
- Once UAT began, the main issues encountered were to do with the physical printing of invoices, as controlled by Efinancials software supplied by external supplier ABS. These issues took several months to resolve, preventing the project from proceeding to the delivery phase. The risk associated with printing invoices in Finance was not identified by the project before UAT began.
- The continued delay in the delivery of this project meant that the Archibus upgrade (EST069) came to have an impact on this project. The new version of Archibus was deployed to TEST and this project undertook UAT with version 19 of Archibus. EST069 then could not complete due to issues which the external supplier, MASS, took many weeks to resolve. AS EST065 had been tested against version 19, and LIVE remained on version 17, this project could not deploy to LIVE until EST069 completed. In addition, a table change introduced to EBIS by EST069 caused an issue with EST065 which caused additional effort for this project to resolve.
Lessons learned
Successes
- No post-deployment issues encountered, demonstrating robust and thorough user acceptance testing by Liz Torrance, Donna Archibald and Anne Finnan
- UAT resulted in very few changes having to be made to IS apps code demonstrating quality work from developer Stella MacKinnon. developer Mike McMonagle, who picked up project during UAT produced required fixes efficiently.
- Business owner was able to provide thorough understanding of business requirements.
- Introduction of JIRA was very valuable to the progress of the project.
Areas for Improvement
- Developer should be involved as early as possible during development of business requirements.
- Developers would benefit from a better understanding of practical business processes.
- Reliance on a single tester (In both Estates and Finance) presents a risk to project progress and can ( and did) introduce delays.
- Opinions in the meeting differed on whether EST060 and ESt065 should have been one, two or three projects. Adding scope to existing projects should be scrutinised very carefully in the future and particularly where external suppliers are involved. The risks of delays to one part of a project and its effect on remaining parts should be carefully considered. Although the reasons for attaching the property and lease module to EST060 ( originally a webcentral upgrade, not adding new features) and then establishing a separate project (EST065) to realise the benefits of the property and lease module may have made sense at the time, there was a lot of confusion and morale-sapping delay introduced by these decisions, as project team members were frequently faced with weeks without progress. additionally, code for EST065 had to be developed before the property and lease module was delivered.
- Future projects should carefully estimate the time required for robust user testing, especially if an external supplier is involved. Business areas should consider seconding staff to carry out testing and should resource staff accordingly.
- An extended period of user acceptance testing makes it hard to ensure that IS applications development resources can be made available when needed.
- It is an advantage to carry out testing over a concentrated period and getting testers and developers into the same room at the same time, if possible, can be very helpful.
- if a project is subject to delays and periods of inactivity there is a danger that the quality of communication between members deteriorates and project manager should bear this in mind.
Benefits delivered.
- Estates will save on average 2 days per month of staff time, although as the costs of this project ( not just in IS applications time) reduce this benefit in the short term.
- IS applications and Estates and Buildings and Finance staff now have experience of working together which should benefit future projects.
Resource breakdown by Team:
| Team | Estimate | Actual Effort |
| project services | 36 | 55 |
| development | 46 | 53 |
| development technology | 12 | 9 |
| applications management | 14 | 22 |
| other | 8 | 1 |
| TOTAL | 114 | 140 |
No outstanding issues
Analysis of Resource Usage:
Staff Usage Estimate: 116 days
Staff Usage Actual: 140 days
Staff Usage Variance: 21%
Other Resource Estimate: 0 days
Other Resource Actual: 0 days
Other Resource Variance: 0%
Explanation for variance:
- Extended duration of project increased PM time in particular because of extra requirements for resourcing, meetings and reporting, but also increased general team effort required for quality assurance.
- Additional work required, particularly by Applications Management, to solve printing issues which involved liaising with ABS, whose software was the cause of the printing issues.
- Extra work required by development team to solve issues introduced by Archibus upgrade and need to force blank lines into printed invoices.
Key Learning Points:
Outstanding issues:
None.
