ETL Migration
Application Migration of Rewards System from Mainframe to Ab Initio
One of the largest credit card brands in the U.S. needed to optimize its legacy Rewards system by migrating from mainframe to Ab Initio in order to make Rewards points calculations and redemptions across multiple platforms. As part of the project, the customer required efficient application support, storage and backup support, and code-artifact management.
Client Challenges and Requirements
- Migrating 100 million daily transaction records along with historical data from DB2 into Oracle database
- Installing the new system without impacting other active systems, especially vendor systems
- Identification and understanding of the job runtime and frequency over the mainframe
- Setup parallel batch-like production to compare result with legacy system
- Transaction based pricing for the data extraction via 3rd party from DB2 database production system
- Challenges in implementation of graphs to send the variable size file to mainframe
Bitwise Solution
- Migrate the existing Ab Initio application and 600+ new Ab Initio applications, along with rewrite of 500+ COBOL jobs to Ab Initio.
- Migrate data from different legacy systems to Rewards Oracle database before decommissioning the previous system.
- Implement a scalable and easy to maintain mechanism of data lifecycle tools.
- Implement Rewards points calculation process using Express>IT.
- Implement web services to access records and FTP the files to different vendors.
- Develop 50+ reports.
- Document each application along with demonstration to the client.
Tools & Technologies We Used
Ab Initio
Oracle
Unix/Linux
Java
Tivoli Work Scheduler
GitHub
Key Results
40% reduction in application development and maintenance time
25% improvement in SLA adherence
30% reduction in data validation effort
35% cost reduction in data extraction and storage
