Legacy Application Modernisation

C-Store is an HR legacy payroll and finance system used within DWP for several years, last operational in 2007. The system is now used in a read only capacity to determine pensionable data for current and past civil servants. In 2018, the original C-Store hardware failed and faced a full data loss. After forensic data recovery the data was extracted and a tactical, interim solution, was developed. In parallel the FAMIS project was underway where a front end reporting solution was developed, providing an opportunity to add the C-Store data into the same reporting system improving end User experience and ensuring GDPR compliance. Required outcomes from the project:

- Analysis of the extracted data files in order to create an appropriate data model. Inclusive analysis of queries available in the original system in order to develop similar report layouts and workflows. - Development of transformation routines resulting in conversion and validation of the data into SQL. Validation must be done via an appropriate technique such as SQL BCP. - Designing and coding of new reports using an iterative process resulting in continuous testing and improving. - Training end users and offering support for UAT phases. - Appropriate post go live support