OBS Write Up 1 - 13437
OBS Write Up 1 - 13437
OBS Write Up 1 - 13437
1 Background
In November 2012, the Social Security and National Insurance Trust (SSNIT) awarded contract
to Messrs. Perfect Business Systems (Ghana) / Silverlake (Malaysia) Consortium for the
development and implementation of a new software solution known as the Operational Business
Suite (OBS) as an outsourced project at a contract sum of US$34,011,914.21. The project was to
automate all the core processes in the administration of pension. The contract duration was for a
period of eighteen (18) months and it covered the head office, area and branch offices which
summed up to fifty five (55) sites. The complete solutions included various components such as
supply, installation and commissioning of the hardware, application software, data conversion,
data migration and system integration of all the components.
The following companies and joint venture responded to the tender as per the submission
deadline of 10:00am October 19, 2011.
No. Tenderer Tender Price
1 BSystems / Face Technologies /Systech USD31,908,441.59
2 Cedar Information System USD23,873,930.00
3 Computer Information System USD36,509,543.78
4 KPMG USD32,168,621.35
5 KRANE International USD27,897,298.89
6 Perfect Business Systems & Silverlake Consortium USD27,610,791.00
7 Persol Systems GHC17,401,846.00
8 Provision Consultants USD20,648,678.86
9 Sambus Company Limited USD9,891,732.69
10 Superlock Technologies Limited USD35,990,850.00
On March 5, 2012 SSNIT through the General Services Manager, informing Perfect Business
Systems and Silverlake Consortium of arithmetic errors that have been identified in the Perfect
Business Systems and Silverlake consortium. This resulted in an evaluated tender price of
USD34, 011,914.21 including 15% VAT. Arithmetic correction is an approved practice in tender
evaluation as per the guidelines of the Public Procurement Authority. Thereafter, undertook a
reference site visit in Ghana and Malaysia as part of their due diligence.
The formal contract for the OBS project was signed on November 15, 2012 between SSNIT and
Perfect Business Systems and Silverlake consortium (the signature page of the contract has been
attached as appendix 2).
The project as advertised was one complete project to be implemented in one phase. Based upon
SSNIT request, the project was re-structured into two phases. This was realised as a potential
risk as there was going to be information overload and will intend affect the project
implementation. Therefore, it was agreed with the vendors to structure the project into phases in
order to mitigate the risk and guarantee its success. The two phases of the project have been
outlined below:
The review teams for the various modules were selected from the various divisions including
Benefits, Operations, Finance, MIS, General Counsel, Office of the Chief Actuary, Internal
Audit Department, Corporate Affairs and the Identifiable Bodies. The members of the review
teams have been provided in Appendix 2.
3.5 Training
The project adopted the train-the-trainer concepts where the members of the user acceptance
testing (UAT) team were trained as trainers. The team in turn trained the rest of the SSNIT team.
Users from all the functional areas were trained for a minimum period of five (5) days and a
maximum of ten (10) days. The training programmes were held at two centres namely the
Mfanstiman Training Institute for the southern sector and the Kwame Nkrumah University of
Science and Technology for the Northern sector. The participants included the Area Managers,
Branch Managers, Benefits Division Managers, Contact Centre Staff, Corporate Affairs Staff, IT
Help Desk Staff and Benefits Officers. Others included Data Management Officers, MIS
Coordinators, Prosecutors, Accountants, Compliance Officers, Customer Care Officers,
Operations Monitoring Managers and staff of the Internal Audit Department.
In order to ensure a smooth a team of selected staff from the branches was created and trained as
support team providing assistance to staff. The training in all cases was hands on and hands
holding training.
The consolidation, cleansing and migration of the databases were achieved through the Data
Conversion and Migration. At the end of the exercise the following pockets of data were
migrated into the OBS environment.
Benefits Data 887,824 records
Registration Data (Employer and Members) 4,422,769 records
Members Financial Data 316,716,306 records
Employers Financial Data 21,865,572 records
Over 2 million Invalid Contribution Transactions were corrected and the members
financial credited
The datasets as described above were consolidated, cleansed and converted into a format
requested by the OBS Vendor for migration into the related data structures of the OBS System.
3.6.1 Methodology Used for the Data Conversion and Migration Exercise
As part of the processes undertaken for the data conversion and migration included the
following:
Agreed with vendors on the data structures to be use by the OBS system.
Developed Data Mapping Requirement Document (DMR) as a base document for the
data Conversion and migration exercise.
Created a staging area to store the relevant tables needed from the EBOS, Pensions
Systems, Record management and Benefit Processing and Payroll System.
Designed and developed scripts for the data extraction.
Designed conversion and report programs.
Conducted conversion test runs.
Conducted actual Data Conversion.
Some of the data required could not be mapped and thus was set to the default values. This
was because the Trusts systems did not have the data as required by the OBS system.
Inconsistencies in the field names of the various tables in the legacy environment made it
difficult for the design of the conversion and report programs which resulted in the team not
meeting the agreed timelines.
A total of 22,955 members with valid social security numbers and financial information but
did not exist in the legacy Member Personal Master and were converted and migrated into
the OBS environment.
The phase 1 was cutover to production on May 7, 2014 with the following modules /
components:
Employer and member registration
Employer and member re-registration
Employer and member update
Biometric system and smartcards production
Contact Centre implementation
Document management
The phase 2 was cutover to production on July 27, 2015 with the following modules /
Components:
Contribution and Receipts Management
Compliance Enforcement
Benefits Administration
Identity Management - Smartcard & Biometric system
Web Portal System
Reporting & Analysis tools (Business Intelligent)
Document Imaging System (Workflow & Form capture)
Self Service Information Kiosk
Interface to Internal Systems (Financial, HR, Fund transfer, etc.)
Interface to External Entities (e.g. NHIA, Banks, NIA, etc.)
Provides secured, current and online centralized database that provides same and single
view of data and information.
Provides Centralized database to aid effective reporting and exception management.
Provides one point of data entry and one source of information.