Data integration from Postgres SQL for transferring loan data
For a non-banking finance company.
CLIENT & PROBLEM STATEMENT
- Non-banking finance company requires reporting on collection data for strategic decisions.
- Need to transfer, process and visualise data from Postgres-based LMS CRM system.
APPROACH
- Extracted collection data from client’s Loan Management System (LMS) CRM in PostgreSQL.
- Utilised G-Square’s proprietary ETL process in Python for data transformation and optimization.
- Stored transformed data in MonetDB for high-performance analytical querying.
- Integrated processed data with BI tool on Digital Ocean’s cloud for scalable, reliable reporting.
SOLUTION & OUTPUT
- ETL process efficiently transformed Postgres LMS data to MonetDB for analytics.
- Delivered comprehensive collection solutions using Digital Ocean cloud set up.
- The solution successfully integrated 100 million rows of historical loan data and automated the daily processing of up to 750,000 rows,ensuring real-time access to updated information.
