Customer Success Story Highlights
Client
- Leading Asia Pacific bank
Challenge
- Review of the current Warehouse ETL frame work & highlight the areas of improvements & propose design changes
Solution
- Established a Data Warehouse to meet SLA with various downstream data marts.
Benefits
- Significantly improved the performance of ETL jobs thereby reducing customer complaints.
![](http://optimumsolutions.biz/wp-content/uploads/2018/02/Client-Overview.jpg)
Client Overview
Client is a leading regional bank in the Asia Pacific
Key Engagement Highlights
![](http://optimumsolutions.biz/wp-content/uploads/2018/02/framework.png)
Review of the current Warehouse ETL frame work & Design.
![](http://optimumsolutions.biz/wp-content/uploads/2018/02/improvement.png)
Highlight the areas of improvements & propose design changes with POC.
![](http://optimumsolutions.biz/wp-content/uploads/2018/02/enhancement.png)
Implement the ETL enhancements with agreement & endorsement from DBS.
![](http://optimumsolutions.biz/wp-content/uploads/2018/02/benefits.png)
Benefit realization with statistics on DQ & performance.
![](http://optimumsolutions.biz/wp-content/uploads/2018/02/Opportunity-Context.jpg)
Opportunity Context
- ETL Improvements Project with key objective to improve the Data Quality and Performance of the warehouse..
Benefits to Client
- Significantly improved the performance of ETL jobs thereby reducing customer complaints.
- Established a Data Warehouse to meet SLA with various downstream data marts for the Business Units like CPMS & Risk Management Group.
![](http://optimumsolutions.biz/wp-content/uploads/2018/02/Benefits-to-CLIENT.jpg)