d-insights

LORA – Loan Origination Rapid Accelerator

LORA delivers rapid and valuable insight by transforming loan origination data into a business focused Data Marts and presenting it in a rich, Visual Interactive Data Discovery and Analysis dashboard to identify trends, exceptions, outliers and hidden patterns. The result is a rich and intuitive solution that isolates business users from the need to master the technical complexity of the Loan Origination platforms, while allowing rapid, in depth reporting and analysis.

RAPID MARTS Accelerators: An Analytical Data Mart Solution

  • Disbursement /Sales Pipeline
  • Disbursement, Target and Goals
  • Portfolio KPIs
  • Branch Performance
  • POS, PAR, Arrears and Collection Analytics
  • Delinquency Trends and Risk Management
  • Customer Scoring with Lifecycle Analysis
  • Spend Tracking and Analysis
  • Employee Performance

The Reporting & Information Challenge

Most loan origination databases are operational (OLTP) databases designed to support inserts, updates, or deletions of transactional data and not designed to support reporting and analytics. OLTP reports are primarily targeted for department silos and integration across silos entails a significant cost  

Due to large and/or complicated queries needed to retrieve loan origination data – reports and analytics run against these databases are often very slow – reports can take hours to run or even time out before completion. Reporting directly against these databases can be resource intensive and can result in performance degradation of the application.

The Solution

LORA has been designed and implemented to provide consistent reporting across all subject areas such as documenting data model, immediately understandable and consumable by an organization’s business staff.

Benefits of LORA

LORA is primarily for decision makers and executives at NBFCs, Micro Finance Companies (MFI) and Home Loan providers. It is designed for Business Users and Analysts with little or no technical backgrounds to rapidly access, extract and incorporate loan origination systems data into custom presentation, distribute and publish the information quickly for in depth analysis. The visual presentation of data via the LORA visualization layer allows users to access, extract, slice & dice, perform what if analysis interactively for analysis and sharing with other users and systems.