Monday, January 15, 2018

The RFP for the Legacy Replacement Project

On December 28, 2017, NYCERS released the main RFP for the Legacy Replacement Project (LRP). This is three years after the NYCERS IT director proposed this project. The RFP itself is 88 pages long. With its 12 appendices and 13 templates it is at least 600 pages in total. We now know what Gartner was paid over $4M to do since the 2014.

Responses are due on March 12, 2018 and NYCERS plans to award the contract in December, 2018. That is another full year. You can guess what Gartner will be doing in 2018.

I have previously stated that NYCERS needs to implement a standard database platform for all agency applications and decide what hardware structure/s the agency will utilize going forward. The mainframe provides heavy duty processing power and can handle sophisticated database software but most modern software is being written for network structures including mobile access. Existing commercial software supporting the public retirement market is most probably running in a network environment.

On a personnel level NYCERS needs to review the IT management at NYCERS. Based on the major failures with database modernization, imaging/workflow systems, and the disaster recovery site, plus the squandering of staff resources over the last 12 years, the new executive director needs to make some hard decisions. She has already made some moves in that direction but she will have to do more.

What has the current IT division been doing the last 12 years to upgrade the legacy systems? What are the current personnel/fringe costs for the IT staff and what is currently being spent on consultants, equipment, software, and other services?

General Scope

On page 21 of the main RFP is the following paragraph

The proposed solution must support all of NYCERS' pension administration core business process areas and use cases, which are provided in Appendix 2 by leveraging robust business process and workflow management.

Appendix 2 is 240 pages long. I love words like "leveraging" and "robust". You can smell them a mile away.

But seriously, NYCERS is asking the vendor to redo the agency's entire IT applications structure, a massive undertaking. The existing legacy system was built over a 30 year period (1974-2005). Any replacement project will be a long process. A successful process will be made up of many clear short term tasks that build on each other and adapt to inevitable changes. It will be driven by competent in-house staff with the help of equally competent outside partners.

Workflow Software

The following is a quote from page 27 of the RFP under the section labeled "Required Applications" to be used in all proposed application architectures:

NYCEwork (IBM FileNet):

While NYCERS is looking to replace the BPM component of Filenet with the propose solution, the new solution is required to integrate with the content and document images stored in FileNet for the purpose of maintaing a single content storgae.

The selected Respondent will be responsible for identifying, testing and implementing all changes to NYCEwork (IBM FileNet software) required to support the proposed solution. This includes any required upgrades to NYCEwork (IBM FileNet) software necessary to support the proposed solution (must be explained in the proposal if needed)

In 2016 I wrote about the problems with NYCEwork. NYCERS only put NYCEwork into production in 2014 and now they want replace all the developed workflows. From 2008 to 2011, NYCERS paid the project vendor at least $2.2M to install this system. At that point NYCERS cancelled the contract but continued with the project. It is not clear what the costs were from 2011 to 2014. After suing the inital vendor NYCERS was only able to recover $301,000 in FY-2017.

So now the selected legacy vendor will have to redo at least all the workflows that NYCEwork is currently supporting. The vendor will, however, also have to utilize the existing FileNet document repository along with its database access structure. Trust me, this is huge job all by itself.

Customer Realationship Sofware

Just in case you thought this job was not hard enough, there is another little clip on page 27:


The NYCERS CRM solution (under procurement) must be used as the CRM (customer service) platform for the pension administration solution, including all functionality required to be delivered by the CRM as described in Section D.1.

The selected Respondent will be responsible for providing all interfaces necessary to enable the CRM to act as a robust pension administration portal (see Section D.2.4) and closely collaborating with the CRM project team to help ensure clients receive the optimal self-service experience.

NYCERS is currently evaluating the CRM RFP that it issued in October, 2017. NYCERS expects to award this contract on February 1, 2018. Initially, the CRM vendor will have to interface with the current Legacy systems. In turn, the Legacy vendor will have to interface with the new CRM systems. It is very likely that the Legacy vendor will not fully know what the CRM interfaces look like when the Legacy vendor starts doing its work and may not know for quite awhile exactly what that they are.

Why wasn't the main legacy project structure put in place first and then have the CRM project aimed at the new replacement system?

Time To Stop

Of course, the huge time delay for the LRP project is a definite red flag for this entire effort. If NYCERS does not stop and restructure this project, five years from now we will be looking at $100M down a rat hole and no end in sight.

It is ironic that in 2016 I completed a conversion project of a membership system that was running on a mainframe system using flat files. It now runs on a network platform using a commercial software package with a relational database system. It also provides a web interface. The system was analyzed over 10 month period. The vendor was chosen over a six month period. The vendor installed a live replacement system in 14 months for a cost less than 1/10th of what NYCERS has paid Gartner.


Spouse Walker said...


PMSI said...

i really like this article. nice and good article. yes I'm agree with you,i will share it with others. thanks for sharing the article with us.
Customer Relationship Management (CRM) Solution