Report Generation For Mobile Banking System

Objective

The client required a reporting system that gets data from the mobile banking system on a daily basis in the form of flat files. Moreover, there was a huge volume of records (upwards of 60 million) that needed to be processed on a daily basis.

Solution

Hyper Beyond assisted in creating an automated solution for report generation for the mobile banking system. We have developed complex ETL (Extraction Transformation Load) scripts to load existing data from various sources. Later we created a dimensional model that is used by the reporting system. Then we have created a framework to handle the failures and re-runnable jobs on a daily basis. We created a self-serve environment where users can login and run the reports. Finally we made key reports that are mailed on a daily basis to important stakeholders and summary reports are created on a monthly basis across regions and users.

Result

KPI Reporting of the mobile banking system done using the BI system built by Hyper Beyond. No manual aggregation of multiple Excel files was required on a daily basis. Consequently, manual errors have been eliminated from the process as the application applies business rules uniformly across all data sources. Data, which was earlier only in disparate excel sheets, is now collated in a single source and is available for running reports. The system processes over 60 million records on a daily basis. Notifications and audit checks in place which will intimate about the health of the system.