Pricing Optimization

Creating a High-Performance Analytics Environment to Optimize Loan Offerings

Learn how a Financial Services leader established a comprehensive analytical environment.

Data Analytics Success Story

Learn how a Financial Services leader established a comprehensive analytical environment to gain a unified view of data across processes, assess credit risk with precision, optimize loan offerings for its customers, and reduce losses significantly.



Analyzing the behavior of credit portfolios for the purpose of setting interest rates requires the graceful integration of data from a variety of operational activities. Our client — a Financial Services Leader — specifically required a unified view of marketing, underwriting, servicing, collection, and recovery activity.

Utilizing Lightwell’s proven data integration methodology and its automated architecture creation, the company established a comprehensive analytics environment to flexibly segment customers, deftly review the repayment behavior, and intelligently establish interest rates.

Business Challenge

Like most lending institutions, our client utilized multiple systems to originate and service its credit products. However, the various systems were not integrated, not easily relatable, and often contained conflicting information. How could the company simplify the integration and validation of information from these disparate systems?

banking financial


Working with the Lightwell Analytics team, the company’s IT organization transformed its data collection and modeling strategies, fostered a closer working relationship with their internal business customers, and created a high-performance environment to centralize information and deliver comprehensive analytics.


1000+ Data Elements

within an integrated data model highlighting critical account performance across the entire credit lifecycle, through time

Reports and Dashboards

were developed to consolidate, simplify, and replace the content of 800+ legacy reports

Reduction in Retail Credit Losses

as a result of improved risk segmentation and collection tactics

Shorter Development Time

to fundamentally rebuild the former analytical environment

The Story

Business Challenge: A Swing and A Miss

Our client’s success depended on offering competitively-priced loans to properly cover the expenses and risk posed by its borrowers. 

However, forecasting credit performance required harvesting and integrating data from half a dozen systems.

To overcome this challenge, the company engaged a large consulting firm to construct a data warehouse solution.  Four years and millions of dollars later, the company was still unable to properly identify risk segments within its credit portfolios. 

The interim, manually-built solution suffered from a variety of defects:

  • Complete source data was not properly collected and integrated
  • Data transformations were not accurately nor transparently executed, handicapping user adoption
  • The data model did not present the necessary data elements nor historical performance to support analytical needs
  • No data quality architecture was employed
  • No available metadata for source or target data

The absence of a disciplined development methodology prevented the solution from meeting the company’s analytical needs.

Further, the lack of automated development unnecessarily extended timelines and created inconsistent architectural processes.

The failed solution ultimately resulted in the propagation of rogue data solutions across the company.

Hundreds of incongruent analyses arose which led to haphazard pricing tactics. The company was consequently unable to maintain sustainable pricing and profitability within the riskier segments of its portfolio.

Transformation: Re-Evaluating Batting Techniques

The company sought an efficient, cost-effective means of fundamentally rebuilding its analytics environment. They chose the Lightwell Analytics Team to lead this rapid turnaround given our deep experience within the financial services industry, ability to automate architectural development, and proven credit data models.

Lightwell utilized a team of multi-dimensional experts in technology and finance:

To swiftly identify, profile, document, and centralize the company’s critical data assets. Lightwell then deployed its proven development methodology and proprietary software to rapidly automate the construction of the transformation architecture, data quality processes, and dimensional models.

To ensure speedy adoption of the new data environment:

Lightwell also designed and deployed a suite of interactive dashboards to present best-practice analysis of credit liquidation, delinquency migration patterns, and cohort-based loss analysis. Lightwell supplemented these dashboards with robust training curricula and on-line, interactive metadata resources.

Results: The Homerun

Reaction to the content, reliability, and flexibility of Lightwell’s solution has been overwhelmingly positive. Users who abandoned the initial solution to establish their own data environments elected to return to the improved, more reliable information within the new solution.

The newly-created dashboards also:

Promoted a culture of informational transparency and self-service analysis throughout the organization.

Ultimately, the Lightwell data model cleansed and integrated over 1,000 elements from virtually every aspect of the credit lifecycle (e.g. borrower demographics, underwriting attributes, servicing performance, collection activity, marketing promotions, etc.).

This integrated data perspective enabled our client to:

  • Surgically identify the risk segments within its credit portfolios
  • Offer improved pricing
  • Reduce credit losses by 60 basis points

Further, the availability of improved, centralized data and analysis techniques resulted in the reduction and consolidation of over 600 legacy reports.


Interested in saving or sharing this Success Story? Download the PDF version today.

Lightwell's Data Analytics Consulting Services

Lightwell helps organizations improve the way they access, manage, transform, and analyze their data.

Our highly-experienced data analytics consulting team has assisted leading enterprises across multiple industries — including financial services, insurance, healthcare, retail, and manufacturing — in achieving their goals through comprehensive services and solutions for Data Analytics StrategyData ManagementBusiness Intelligence, and Advanced Analytics. This includes:

Data Analytics Strategy and Planning

Data Management and Data Warehouse

Business Intelligence and Advanced Analytics

Let’s Get Started

Find out how Lightwell can help you create a high-quality data environment, optimized for high-performance analytics, while gaining powerful insights for better decision-making.

Feel free to explore our services on our website, view our data analytics services brochure, or contact us today to discuss your needs. We’ll be happy to help.

  • Lightwell is committed to protecting and respecting your privacy. Please confirm that you agree with our privacy policy by checking the box below.