Ownership of funded loans can frequently change. However, without a robust tracking system, these ownership transitions can lead to gaps in data accuracy, lack of transparency, and challenges in revenue attribution. This case study explores how our team identified a key oversight in tracking loan ownership changes and implemented a seamless, end-to-end solution to ensure complete visibility and control over the entire transfer process.

Problem Statement

Previously, there was no existing mechanism to track the transfer of ownership for funded loans. Specifically:

• There was no tracking system to monitor changes from the original owner to the new owner.
• The team lacked historical records showing when and to whom a loan was transferred.
• These data gaps made it challenging to analyze revenue attribution, identify transfer patterns, or uncover operational inefficiencies.

Solution

To address the problem, we introduced a multi-faceted solution:

• Trigger-based Service Integration: Whenever an ownership change occurs, a service is triggered to capture and reflect the change in the UI.
• Data Model Development: A new data model was created to extract ownership transfer information from the UI.
• ETL Integration: We built a data pipeline that loads and continuously updates ownership details - including old owner, new owner, and transfer date — into the Data Warehouse (DWH).

This approach ensures that all historical ownership data is recorded and readily accessible for analysis and auditing.