Completion Report

Project Summary:

Project Review

This project was initiated to identify and deliver key enhancements to ABS and IS Apps-developed applications within Finance. This is a yearly project funded by Finance to complement the 'keeping the show on the road' support provided by Production Management.

The aim of this project was to deliver as many enhancements as possible within the allocated budget.

 

1.1 Scope

The project had a fixed budget of 128 days.

The project was split into Work Packages, which lasted for a pre-determined length of time (approx. 6 weeks). This allowed the priority of the items within the work packages to be decided in at the time of starting a new work package (borrowing loosely from Agile methodology).

Items that are considered high priority but not completed under FIN099 will be carried over into the project for 2015/16, FIN108. These items will be re-prioritised accordingly at the planning stage.

 

1.2 Objectives and Deliverables (from Project Brief)

Objective/DeliverableDescriptionDelivered?
O1: Define packages of workTo gather the in-scope items that were to be targeted for FIN099.Yes
O2: Document the packages in priority orderTo gather further requirements for the identified items and put these in priority order for each work packageYes
O3: Schedule delivery of each packageTo decide on the amount and duration of the work packages for the lifetime of the projectYes
D1: List of enhancements required in priority orderTo maintain a full list of the enhancements and their priority rating (MoSCoW)Yes
D2: Updated technical documentationAs and when enhancements are done, any relevant technical document should also be updatedYes

 

1.3 Summary of Work Packages devliered

There were 5 Work Packages completed over the duration of the project.

In total there were 21 enhancements and bug fixes delivered under this project, all of varying size and complexity. There was also significant progress made on items that will be carying over into FIN108 (International Bank Validation, eIncoiving, FPM install of v2.2).

Below is a list of each completed item and the benefits achieved/expected from each:

Work Package and items completeBenefits
Work Package 1: 05-Sept-14 - 31-Oct-14 
No items completed, scoping work for eight items started, mainly eAuth enhancements
  • Investigation and analysis carried out to gather requirements and estimates
Work Package 2: 31-Oct-14 - 12-Dec-14 
FIN099-04 Purchase Order PDF Printing complete
  • Substantial reduction in paper usage, storage and wast - financial and environmental savings
  • Substantial reduction in printer toner usage and waste - financial and environmental savings
  • In 2013/14 approximately 130,000 purchase orders were process through eFinancials with each order generating 3 pages. This equates to potentially 390,000 paper prints.
FIN099-57, 58, 59, 60, 63, 64 eAuth Helpdesk calls
  • 6 Enhancements and bug fixes originating from Unidesk and previous projects:

  • Bug fixes mean that Finance can now stop using manual workarounds that saves time and reduces the risk of errors.

  • Changes to email notifications  will save Finance time in dealing with these requests without having to open each one.

  • One of the email notifications was stopped as there was no action required. This reduces the amount of email traffic that Finance have to administer.

Work Package 3: 16-Jan-15 - 27-Feb-15 
FIN099-09 Suppliers Name Table
  • Automation of a process that was previously done by Apps Management for Finance. Finance can now do this themselves, freeing up time for Apps Management to spend on support
FIN099-54 Supplier Self Service Patch
  • Bringing SSS to the most up-to-date release to allow the application to be rolled out to a pilot supplier
Work Package 4: 13-Mar-15 - 24-Apr-15 
FIN099-05 eProc Purchase Order Printing
  • See benefits listed under FIN099-04 above
FIN099-06, 07, 14 eStores fixes
  • Reporting now working correctly
  • Low stock level alerts are now working correctly so stock levels can be maintained at the necessary level - avoids having to buy emergency items at short notice, potentially at a higher price
  • Ashworth store now has more functionality (access to barcodes)
FIN099-66 eFIN SQN Vers on Dev/Test
  • This was an internal updated to the Dev and Test environments. Ensuring all environments are on the same versions avoids buidling up 'technical debt' that would increase the effort required for another project to retrospectively address.
Work Package 5: 30-Apr-15 - 17-Jul-15 
FIN099-15 Webfirst fix
  • Fixing a discrepancy in two reports increases the integrity of the data and the confidence in decisions made based on the information provided
FIN099-16 Webfirst enhancement
  • Creating a new dowload for a report enables the Research Grants Section to use the information in forecasting and budgeting
FIN099-55 eIT enhancement
  • An enhancement following user feedback which gives the user clearer instructions on what is required of them
FIN099-56 Webfirst fix
  • Fixing a problem with the display of a report has increased the integrity of the data and the confidence in decisions made based on the information provided
FIN099-67 Supplier Self Service Patch #2
  • Second patch that contained bug fixes required for piloting to a supplier
FIN099-68 Paperclip
  • Adding paperclip functionality to more screens on eFinancials means more documents can be electronically added to the relevant screen for storage and viewing
FIN099-69 FPM v2.2
  • Installing this new version on Dev allows Finance the opportunity to begin extended testing (this is a larger than usual release)

 

Analysis of Resource Usage:

Staff Usage Estimate: 128 days

Staff Usage Actual: 130 days

Staff Usage Variance: 2%

Other Resource Estimate: days

Other Resource Actual: days

Other Resource Variance: 0%

Explanation for variance:

The project final time spent was six days over the allocated budget of 128 days. Several enhancements took more time than the initial estimate due to unforseen issues. The main ones were:

FPM v2.2 upgrade - several issues trying to install this upgrade on Dev. Was initially estimated at 0.5d but actually took 2.4d

International Bank Validation - several issues encountered between ABS and Experian. Carried over to FIN108 but 8.8d spent so far.

Key Learning Points:

  1. Using a 'work package' structure and milestones seemed to work well as there were regular reviews and the chance for priority items to be changed if needed. The PM would recommend this approach is used for the next project. However, the Business reps have reservations of how well this kind of continuous improvement project lends itself to a more Agile-based approach. Caution is needed here to get the right balance that suits this type of project.
  2. Resourcing: At times there was not enough resource in Finance for testing and there was also not always the necessary resource available from IS to achieve planned work. For the next project, perhaps a SLA could be agreed between IS and Finance so that potential delays on either side are highlighted and therefore reduced, thereby keeping momentum going and allowing the opportunity to move down the priority list if there are reasons for work not being achieved as planned.
  3. It was suggested that the Agile version of Jira could be used for the next project. By useing the Agile 'board' and separting the work packages into releases, this may give a clearer picture as to what stage each jira is at and be easier to report on.
  4. For FIN099 all the enhancements identified at a previous FInance/IS workshop were added to Jira. It perhaps wasn't necessary to add all items at once, especially when some of them didn't have any details other than a title. The recommendation for FIN108 is to only add new jira's for items as and when they are picked up to be worked on. That way a central list of enhancements can be maintained that will form the basis of the new project each year.
  5. The FIN099 Project Team felt it was important for FIN108 to note that the reason for the 'Essential Enhancements' yearly project is to deliver small, defined packages of work that improve the Finance applications. There can be a temptation for support work to be squeezed last minute under this project to get work done quicker, but this then holds back the items already agreed to be in scope.

Outstanding issues:

The following items were not completed under FIN099 and have been agreed, with Finance, to be carried over into FIN108:

  • International Bank Validation (was FIN099-02). Now split into two seprate tasks, one for the change of hosting from UoE to Experian and one for the screen changes in eFIN required to capture the international bank account details
  • eInvoicing Go-Live (was FIN099-24)
  • FPM v2.2 patch (was FIN099-70)
  • PDF Printing Remaining Modules (was FIN099-21)
  • Roll out Supplier Self Service (was FIN099-34)
  • Archiving Continuation (was FIN099-47)
  • New eStore for TCF (was FIN099-62)
  • FPM/CP through the Load Balancer (was FIN099-35)

Project Info

Project
Essential Enhancements for Finance Applications 2014/15
Code
FIN099
Programme
Finance (FIN)
Project Manager
Stephanie Ruthven
Project Sponsor
Elizabeth Welch
Current Stage
Close
Status
Closed
Start Date
04-Aug-2014
Planning Date
n/a
Delivery Date
n/a
Close Date
30-Jul-2015
Overall Priority
Normal
Category
Discretionary

Documentation

Close