Home / Case Studies / Credit Report

Industry: Financial Services

Borrower’s detailed credit report

Credit report is a Salesforce Lightning component that provides the credit history of a loan borrower, co-borrower and co-signer on the same platform. For a loan creditor, it’s necessary to gather the credit score details and the previous credit information of the loan borrower to approve the loan. This component converts the 3rd party credit report’s information in the readable format.

To gather the detailed report, borrower’s consent is mandatory to accept their Social Insurance Number (SIN). If the SIN is not available than credit report can be gathered with the help of DOB, permanent address or province.


Reduces creditworthiness, data inconsistencies, and details


Provided all three credit reports together, Loan approval is straightforward for the lender.


Reduced time for deciding the risk of an applicant, Streamlined onboarding process, speeded up decision making

The Objective

One of the publicly listed leading financial service providers in Canada was on a mission to empower Canadians to manage their finances, with credit building products, guidance, and tools to optimize their credit wellness. If a customer is applying for a loan, it makes perfect sense to check and realize. Where they can get it at best terms. When customers call a money lender, they’ll likely to pull the customer’s credit report to get a look on the score before giving the rate information. For a finance solution provider, it is required to gather the legible information of the borrower so that it gets easy to understand their complete credit history.

The Challenge

  • Constant reviewing of the credit score reduces the creditworthiness of a borrower.
  • Reporting agencies providing the credit report in a technical language which is not easily understood by the end-user.
  • Manually managing the data inconsistencies and details.
  • Collecting the borrower, co-borrower and co-signer’s credit report on different tabs.
  • Automating analysis of the credit reports and identifying inconsistencies to share alerts.

The Solution

Technology Mindz reviewed the requirements and challenges faced by the Salesforce Lightning users and by considering all the specifications, the following solution(s) were provided:

  • Provided the credit report of the borrower, co-borrower and co-signer at one place.
  • Created functionality to review the report in the following formats:
    • Summary – Short brief of user’s credit history.
    • Full report – Complete and detailed information.
    • New Window – To compare the summary with the detailed report.
  • Displayed red flags and deficiencies at the top to make it easy for the financial provider to decide whether they should approve the loan of the borrower.
  • Provision to access the complete report of a borrower to understand the risk factors involved in sanctioning the loan.
  • Created the search and sort functionality as per the section. Only relevant section(s) as per the information was visible.
  • Developed functionality to show the section that contains red flags only.
  • Top section of the report included;
    • Name of the applicant
    • Email
    • Phone
    • Reference ID
    • Priority
    • Status
    • Product type
    • Assigned
  • Summary includes;
    • Overview
    • Residences
    • Remarks
  • Full report includes
    • Overview
    • Residences
    • Employment
    • File Summary
    • Banking closed for cause
    • Trade
    • Registered Items
    • Bankruptcy Insolvency
    • Legal Items
    • Collections
    • Inquiries
    • Remarks

Technical Approach

By analyzing the requirements, the following technical approach was applied to fulfill the customer objectives;

  • Created a Lightning tab-set to manage borrower, co-borrower and co-signer’s credit report.
  • Created a function in apex class which converts JSON into string.
  • Use of regex for search functionality.
  • Created data tables with all lightning accordions.
  • Used wrapper class to display the data on the frontend.
  • Created a function to show and hide the sections according to the filters.
  • Created on-check function on a checkbox to show and hide the sections according to the filters.
  • Created functions that show the red flags on the insight section according to the criteria.
  • Created a function that display the error or if a report is missing or not received from the server. For every messages we have created the ShowToast function in lightning component which is displayed when an error occurs.
  • Created a function in lightning JS controller to display the summary report on separate tab through VF page.
  • Used lightning data-table and lightning accordion sections to show the credit report data.

The Benefits

The Salesforce users leveraged the following benefits from the solution(s) offered;

  • All the credit report information was accessible at one place.
  • Reduced risk of low credit score(s) of the borrower which happened due to constant reviewing.
  • Easy to understand credit report made available.
  • No need to note down any inconsistencies manually.
  • Improved the overall work efficiency.
  • Feature to display the relevant section as per the search.
  • Saved time of the loan officer by showing the deficiencies and red flag(s) on the top of panel.
  • Easy to compare summary report and full report.

The Results

The following results were achieved by using the enterprise solution(s) provided by Technology Mindz;

  • Significant reduction in time to decide the risk of the applicant.
  • Achieved complete user satisfaction by displaying the credit report of borrower, co-borrower and co-signer at single place.
  • Improved the edjudication speed to process more loan applications.
  • Simplified on-boarding process which has halved the time between loan applications and disbursement of loans.