NHS National Payroll Solution – Electronic Staff Record: 1.2m Employee Payroll & HR Records Migrated

The requirement for a national payroll solution for the NHS, encompassed circa. 600 organisations across the country, covering more than 1.2m employees. A hugely demanding and significant Data Migration effort was required to successfully migrate data from the 28+ different legacy payroll and 40+ HR solutions (including SAP) into the new Oracle E-Business Suite solution.

Addressing the Challenges

In order to successfully deliver this huge programme, Egress planned the delivery of 12 concurrent waves of Data Migration cycles onto the single shared Oracle platform with circa 50 organisations in each wave.

There were:

• 1,700 locally defined Allowances and Deductions per wave
• 2,000 Local Grades per wave
• 1,100 extract files processed per wave

• Developed Data Migration, Cleansing Strategy and Plan
• Egress Advance – DM toolkit for repeatable, automated outcomes
• Egress Assure – Payroll validation & assurance tools
• Managed implementation against a defined programme plan
• Delivered Data Cleansing to ensure successful testing outcomes
• Data mapping and transformation specifications
• Measured and reported every output to each Trust board throughout