The Company
The client is a global insurance, retirements and employee benefits provider with 6000 employees and 13.8 million customers. It had revenue $ USD 8.5 billion for 2018 and $547 billion total assets under management.
Objective
- Reduce Mainframe footprint in Claims Applications with modern and strategic solutions:
- Consolidate four different claims mainframe applications.
- Decommission the legacy Employee Benefits Claim applications and divert the interfaces to new the claim system
- Align systems to Company’s IT roadmap by using new and emerging technologies (ETL, SFDC Cloud, Oracle financials):
- Replace the system with Salesforce Database.
- Divert multiple interfaces such as product configurator, workflow, reporting & manual entries to the target system
The Challenge
- Employee Benefits – Claims Applications:
- Multiple redundant and obsolete legacy Claims Applications for Employee Benefits.
- These applications could not be integrated with latest technology in the industry.
- Employee Benefits – FasTracker Application:
- The existing application FasTracker was on Sybase platform. It maintained employee benefit sales and premium data for reporting purpose.
- Maintenance of FasTracker application involved high costs, time and efforts
- Duplicate data across multiple systems lead to data inconsistency in reports.
- No consolidated Sales/Premium/Product/ Coverage details available at one place.
The Solution
- Consolidation of four Claims Mainframe Applications involving 25 key integration points.
- Decommission of FasTracker (Power builder) and Sybase database and move everything to existing Salesforce application.
- Replaced legacy Mainframe Cobol jobs with Informatica jobs with significant performance improvement.
- Migration of Active data from IBM DB2 database to Oracle using Informatica. Historical
- Data Archival to Hadoop using Sqoop utility
- 25 sales and in-force premium reports migrated to Salesforce involving 13 integration points .
- Designed and Developed unified Claims ODS database in Oracle.
Technology Stack
Applications in Scope:
- Four Claim Applications:
- IBM Mainframe – COBOL, JCL, DB2
- Oracle
- Informatica
- Hadoop
- One FasTracker application
- Power builder
- Sybase
- Salesforce
- Informatica
The Impact – Amplifying Outcomes
- Operating Cost of 4 Legacy Systems of $ 11.5k brought to zero (due to decommissioning)
- Consolidation of Claims Applications and FasTracker to Salesforce resulting in recurring cost reduction of $650k (approx.) YoY
- Retirement of 13 EB applications to reduce and simplify EB Application portfolio
- Digital alignment with new accounting software – Oracle financials and SFDC
- Introduction of emerging technologies to enhance interfacing & reporting capabilities through ETL and Analytics
- Integrated EB’s Sales Reporting process into Salesforce.com Employee Benefits platform
- Elimination of redundant business process and Reduce legacy footprint - Mainframe, DB2,
- PowerBuilder, Sybase
- Replaced older, non-strategic reporting technologies called Actuate and Hyperion Intelligence
