Case Study

Pension Insurance Corporation PIC

Oracle Cloud HCM, Oracle ERP Cloud Financials, EPM, and Managed Support Services

A specialist UK insurer that replaced its bureau payroll and ageing HR system with an integrated Oracle Cloud Finance and HR platform, a managed payroll service, and a Fusion Practices managed support service.

Client: Pension Insurance Corporation plc (PIC)
250+
Reports and dashboards developed
3 standards
IFRS 4, IFRS 17 and Solvency II compliance
400+
Business scenarios in automated quarterly patch testing
01
Background

PIC wanted to implement a new integrated Finance and Human Resources Information System (HRIS) that included a Managed Payroll Service. The chosen system also had to offer Performance Management with 360 degree reviews, Recruitment and Applicant Tracking, Onboarding, Talent Management, and Learning Management.

PIC's payroll was run on a bureau basis by a partner accountancy firm, and the old HR system no longer met the HR team's needs. The project started with a requirement to replace the payroll service. PIC then recognised that the HR team needed additional technology to simplify areas that had become more urgent because of continued growth in headcount. The existing systems and suppliers could not deliver these requirements, so PIC reviewed the entire HRIS software spectrum, both current and strategic, to make sure the HR team could deliver on the agreed business plan.

Further background on PIC
  • -A specialist UK insurer providing tailored insurance products.
  • -Significant projected growth.
  • -The existing ERP was not used effectively.
  • -Manual processes were run in Excel.
  • -The same data was held in multiple places with different values.
02
Complexity

The PIC implementation was complex, with its own set of challenges:

  • -Integration with multiple source systems.
  • -Simultaneous compliance with IFRS 4, IFRS 17, and Solvency II.
  • -Development of more than 250 reports and dashboards.
  • -Development of enquiry pages to query archived data.
03
Scope
APlanning and modules
Worked closely with senior stakeholders to plan the move to Oracle Cloud.
Implemented and supported the following modules:
Finance, Procurement and EPM
Oracle ERP Cloud Financials (Accounts Payable, Expenses, Accounts Receivable, Cash Management, Fixed Assets, General Ledger), Procurement, and Enterprise Performance Management (EPM). Procure to Pay, Invoice to Cash, Record to Report, Budget Maintenance, and Bank Reconciliation were implemented across Oracle Procurement, Financials, and EPM Cloud.
Human Capital Management
Oracle Cloud HCM: Core HR, Absence Management, Performance Management, 360 degree Reviews, Onboarding, Organisation Management, Staff Surveys, Employee Share Portal, and an automated integration with the payroll provider.
BDesign and controls
Designed workflow approvals to make sure spend was authorised.
Built expense control and spend analytics that validated spend against the available budget.
Implemented an Azure data platform and integrated multiple systems, which automated processes and reconciliation.
Designed a new Chart of Accounts to comply with IFRS 4, IFRS 17, and Solvency II.
CReporting and data
Designed the reporting architecture and the financial and actuarial reporting strategy, with Power BI reporting for historic data that was not migrated to the cloud. Reports were generated as required by IFRS 17, IFRS 4, and Solvency II.
Enabled self-service reporting through Oracle Transactional Business Intelligence (OTBI) and SmartView.
Archived data from Oracle EBS R12 to Azure SQL.
DSupport and security
Provided post go-live support as a Managed Support Service with continuous service improvement.
Enabled role-based data access control and segregation of duties to keep data secure.
ETested before go-live
Managed business alignment and expectations by verifying solution components against business requirements frequently, in a modular but increasingly integrated way. The following tests were carried out before go-live:
Unit TestingSystem Integration TestingParallel RunPenetration TestingUser Acceptance TestingAutomated Quarterly Patch Testing
04
On-going support

PIC required support and enhancements across all the modules in scope. Our consultants supported both production and non-production environments and delivered enhancements as part of our BAU service. Support activities include:

  • -8x5 support coverage from the UK and offshore.
  • -On-call support (24x7) for critical issues.
  • -Automated quarterly patch testing.
Fusion Practices Managed Support Services highlights
  • -Publishing daily status reports before the start of the day, covering health checks, instance availability, and batch completion status.
  • -Ownership of L2 and L3 production support.
  • -Implementation and support of new enhancements.
  • -Proactive monitoring of service requests for critical issues in production.
  • -Enhancements that automated manual processes.
  • -Automation of quarterly patch testing, covering more than 400 business scenarios.
  • -Training delivery and maintenance of end-user training material.
05
Positive solution impact
  • -HR processes became consistent and effective.
  • -Onboarding and offboarding processes were simplified.
  • -HR policies such as maternity, grievances, and sick pay were implemented in Oracle Cloud HCM.
  • -Payroll calculations became accurate.
  • -Employee engagement improved through talent management and goal management.
  • -Self-service reporting capabilities were enabled for business users.
  • -One agreed source of data across Finance and HR.
  • -Reporting was delivered to measure KPIs.
  • -Stable integrations were maintained between Oracle Financials Cloud, Oracle Cloud HCM, and Oracle Planning and Budgeting Cloud.
  • -A reduction in support tickets, resulting from regular root cause analysis of all tickets.
  • -A significant reduction in manual processes, resulting from proactive enhancements delivered by our BAU team.
  • -Improved SLAs, achieved by applying permanent fixes to recurring issues.
  • -HR operations were kept aligned to HR policies, with training delivered to divisions within PIC for new processes and self-service reporting.
06
Issues resolved through collaboration

Issues and problems that were encountered and overcome through collaboration during the project.

Issues and problemsMitigation
Business and IT SMEs were not available because of the pandemic and quarter end.We encouraged PIC to commit the right number of business and IT SMEs, with the right skills and authority, to drive the project alongside Fusion Practices.
Decision making and design sign-off were slow because knowledgeable and authorised personnel could not spend time on the design and tests.Resolved through communication and an agreement that PIC work stream leads would commit 100% of their time during the project.
Talk to us about your Oracle managed service

Book a session with our Oracle Cloud team and we will work through implementation, support and reporting for the modules that apply to you.

Book a session consulting@fusionpractices.com