- Achieved business SLAs:With CDD enabled, parallel data transformation, the ETL processing time was reduced from 16 hours to 4 hours.
- Improved Governance and Trust:Significantly increased the process and trust that the users had in the IT systems and Data.
- Improved Productivity: With less data issues to deal with, the business spends more time in analyzing data and gleaning insights
- Future Proof Investment: Common Meta data layer enables seamless integration with future tools and capabilities such as Data Quality, MDM and Smart Archiving
- Increased up-sell/cross-sell opportunities–The timely delivery of data into the mart for reporting and the predictive models enables substantial increase in revenue and paves way for future growth
About the client: Ujjivan is a leading Microfinance company in India and have recently been awarded the Small bank license by the Reserve Bank of India.
Business Challenges: The client wanted to gain better insights from their customer data. Multiple legacy systems and complex IT infrastructure meant that they were not able to glean timely insights. In addition the new banking license necessitated appropriate Data Governance frameworks to meet future compliance requirements and to increase the business trust in the underlying data and information systems.
Solution: The proposed solution using IBM InfoSphere will connect to various databases, capture changes at source (CDD) and perform complex ETL, and populate the Data mart. The Change Data Delivery option reduces the number of records moved/processed on the ETL server and help meet the business defined SLAs. Cognos and SPSS were used for Reporting and Predictive analytics. The Data Dictionary and Data lineage options were recommended to enable the business user to track the journey of data from reports all the way to the source systems, thereby increasing the trust in Analytics.
Technology: IBM Information Server, Change Data Delivery, Information Governance Catalog / Glossary (IGC)