Business Challenge
- Multiple departments accessing mainframe data across the regions.
- Dependency on Mainframe batch for monthly/weekly reports.
- Building a single data repository for downstream applications.
Engagements
The major insurance company wanted to build a data lake for their Mainframe master files in the cloud environment (AWS).
The Solution
Approach & Solution
- Analyze, Map, and Build the copy books for master files (i.e. COBOL, Easytrieve, Assembler copy books).
- Trailer splitting from master files (using python split scripts).
- Build the processing Parameter file for the python conversion scripts.
Benefits & Outcome
- Reduce MIPS in mainframes.
- Availability of RAW data to all the downstream applications.
- Easily accessible by the user for data analytics/reporting.