endorsedCompleted

SQL & Python Scripting for Lending Company

Services Covered:

Custom Software Development

Industry

Financial Services

Duration

6 months

Budget

Confidential

Start Date

1 July 2019

Team Size

1-5 Employees

Engagement Model

Onshore

Project Capability Score (PCS)

77/100

Good

Project Capability Score (PCS) estimates how capable Liventus Inc. is of successfully delivering a project like this, based on its past experience, track record, and ability to handle similar work. Learn more about PCS

Client

Confidential

United States of America

Project Summary

Liventus developed SQL and Python scripts to reconcile multiple loan reporting systems for a lending company, enabling the client to calculate numbers used in performance reports. The delivered code was clean, well-commented, and suited to business owners; it supported reporting on a roughly $700 million loan book. The client noted timely delivery, good communication, and that the work stayed under budget.

Key Challenges

Provide scripting support for financial reporting
Reconcile multiple loan reporting systems
Produce calculations used in performance reports for finance partners

Project Deliverables

Series of SQL scripts
Series of Python scripts
Reconciliation scripts for loan reporting systems
Documentation and sample outputs

Project Solution

Liventus wrote and delivered a set of SQL and Python scripts that reconciled different loan reporting systems. The client provided access to their loan book database plus documentation and sample outputs; Liventus produced clean, well-commented code that the business could run to calculate numbers for performance reports. The engagement was a light-scope project with communication via email and delivered under budget.

Project Outcome

Delivered high-quality, well-commented, clean, and simple code
Supported reporting on a roughly $700 million loan book
Met deadlines, communicated effectively, and delivered under budget

Platforms

Tech Stack

Python
SQL

Client Endorsement

Overall Review Rating

4.88

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“Liventus delivered a very high-quality, extremely well commented, clean, and simple code that was used to reconcile a $700 million loan book. The client was very happy with the level of support, communication, and work quality received. The team was also timely and stayed under budget.”
Anonymous
VP of Products & GM of Consumer
Date: 10/22/2021