Ujjivan, a leading microfinance firm turned small bank, faced challenges with legacy systems, siloed data, and compliance-driven governance needs. Using IBM InfoSphere with Change Data Delivery, Data Marts were built for faster ETL (16 hrs → 4 hrs), integrated with Cognos and SPSS for reporting and predictive analytics. The solution improved governance, trust, and productivity, while enabling cross-sell/up-sell opportunities and future-proofing with a common metadata layer.
Ujjivan is a leading Microfinance company in India and have recently been
awarded the Small bank license by the Reserve Bank of India.
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.
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.
–
IBM Information Server (IBM Datastage and IBM QualityStage), Information Governance Catalog / Glossary (IGC), IBM Change Data Delivery.
