Business Need

The client, a prominent financial service provider, sought a dedicated solution for their data analytics and reporting requirements. The primary objective was to consolidate loan data and generate comprehensive reports for stakeholders. However, the loan data received from various financial service companies presented data quality issues. To enable effective analytics and reporting, it was crucial to address data deduplication and cleansing. The solution needed to be agile, catering to ad-hoc data requirements promptly. Moreover, the solution was expected to empower the identification of trends within the loan data.

Business Challenges

The primary challenge lay in processing billions of records to ensure regulatory compliance and enable effective investigations and surveillance. Complex compliance, investigation, and surveillance requirements necessitated the correlation of data across multiple silos. Furthermore, the volume of data involved required robust data discovery and analytics capabilities.

Business Solution:

NuSummit addressed these challenges by delivering a comprehensive solution, including:

1. Building a edicated data warehouse to consolidate loan data from different financial service companies
2. Establishing a framework for monthly reconciliations of loans to identify data quality issues
3. Resolving data quality issues in loan data either at the source end or within the Data Warehouse
4. Implementing NLP-based deduplication functionality at the Data Warehouse level to easily identify unique borrowers and their loans
5. Developing a framework to fulfill ad-hoc data requirements for obtaining various views of loan data, including types, outstanding details, and tenure
6. Creating interactive dashboards with row/column level security, enabling multiple stakeholders to access relevant data

Tech Stack:

• QlikSense
• Talend
• MySQL.

Project Differentiator:

The solution provided by NuSummit introduced several differentiators:

• Trend analysis of loan data
• Comparative analysis capabilities
• Geographical analysis for enhanced insights

Business Impact:

The implementation of NuSummit’s data analytics solution for loan management had a profound impact on our client’s operations. By streamlining their data processes and providing actionable insights, the solution played a pivotal role in enhancing efficiency and decision-making within the organization.

• Drastic reduction in turnaround time for obtaining reports
• Increased client adoption of the solution
• Timely generation of reports
• Implementation of interactive dashboards with precise row/column level security, catering to multiple stakeholders
• Substantial improvement in data accuracy