Credit portfolio benchmarking system and method

• US 8,001,034 B2
• Filed: 02/15/2011
• Issued: 08/16/2011
• Est. Priority Date: 06/24/2005
• Status: Active Grant

• Current Assignee: Experian Information Solutions Incorporated (Experian plc)
• Original Assignee: Experian Information Solutions Incorporated (Experian plc)
• Inventors: Haran, Linda A., Lassen, Patricia Cheryl, Chung, Charles S., Granger, Angela
• Primary Examiner(s): Colbert; Ella
• Assistant Examiner(s): OJIAKU, CHIKAODINAKA
• Application Number:
  US13/028,106
• Publication Number:
  US 20110137824A1
• Time in Patent Office: 182 Days
• Field of Search: 705/36, 707 1- 5, 707200-201, 706 12- 14, 709/229, 726/26
• US Class Current: 705/36.00R
• CPC Class Codes: G06Q 10/06393 Score-carding, benchmarking or key performance indicator [KPI] analysis
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising
• CPC Class Codes: G06Q 40/00 Finance; Insurance; Tax strategies; Processing of corporate or income taxes
• CPC Class Codes: G06Q 40/03 Credit; Loans; Processing thereof
• CPC Class Codes: G06Q 40/06 Asset management; Financial planning or analysis
• CPC Class Codes: G06Q 40/08 Insurance

Abstract

A portfolio benchmarking system comprises a repository of trade data, a repository of consumer data, a build computer, and a benchmarking query application. The repository of trade data comprises a plurality of data items regarding trade lines. The repository of consumer data comprises a plurality of data items regarding consumers, wherein at least some information in the consumer data is not in the trade data and at least some information in the trade data is not in the consumer data. The build computer periodically generates at least one data file comprising a plurality of data items, each data item combining information from the trade data and the consumer data, such that searches can be performed on the combined data without joining trade data and consumer data at query run time. The benchmarking query application executes queries on the data file generated by the build computer.

Claims

1. A credit portfolio benchmarking system comprising:

a repository of trade data comprising a plurality of data items regarding trade lines including data for one or more loans;

a repository of consumer data comprising a plurality of data items regarding consumers including one or more names, addresses, and credit scores, wherein at least some information in the consumer data is private data that is confidential to the consumers and not in the trade data and at least some information in the trade data is not in the consumer data;

a computer system programmed to generate at least one data file comprising a plurality of data items of merged data, each data item including a combination of information from the trade data and the consumer data obtained by merging trade line data with associated consumer data so that the merged data includes data that categorizes the data into one or more peer sets, each peer set corresponding to one or more lending institutions; and

a benchmarking query application configured to execute a user-specified query against the merged data such that the trade line data and associated consumer data is pre-merged at a time of execution of said query, said benchmark query application additionally configured to use execution results of the user-specified queries to generate a benchmark report that compares a portfolio of a lending institution to portfolios of peers of the lending institution.

2. The system of claim 1, wherein the benchmarking query application includes a user input component display that comprises multiple screens.

3. The system of claim 2, wherein a portion of the user input component display remains visible in the multiple screens of the user input component display.

4. The system of claim 1, wherein the benchmarking query application is further configured to utilize a single window to present multiple screens in the window.

5. The system of claim 1, wherein the benchmarking query application is further configured to:

receive user edits of values;

determine whether the edited values affect other user-entered values;

present the user with a screen associated with at least one of the user-entered values which are affected to allow further edits by the user.

6. A credit portfolio benchmarking system comprising:

a benchmarking query application, executed on a computer system, configured to;

create a user input component display that receives user-entered values for parameters, the user input component display comprising;

a query portion configured to receive user-entered values for parameters of a query; and

an active query portion configured to remain visible while the user builds during user entry of a query and comprising hypertext links related to the parameters;

execute queries to retrieve information about a first lending institution using at least a portion of the user-entered values;

determine at least one peer of the first lending institution;

determine respective portfolios of the first lending institution and the at least one peer of the first lending institution; and

generate an anonymized report that shows the portfolio of the first lending institution benchmarked against the at least one peer of the first lending institution.

7. The system of claim 6, wherein the benchmarking query application is configured to execute queries in real time.

8. The system of claim 6, the user entered values relating to at least one of:

a population definition, an attribute selection, and a population segmentation.

9. The system of claim 8, wherein the benchmarking query application is further configured to execute the queries using the at least one of:

a population definition, an attribute selection, and a population segmentation.

10. A non-transitory computer storage medium having computer executable code recorded therein, the computer executable code configured to cause a computer system to perform method steps comprising:

receiving an indication of a first lending institution;

receiving query parameters for querying a portfolio benchmarking database to create an anonymized portfolio benchmarking report, the query parameters relating to defining a query population, segmenting the population, and selecting attributes, the portfolio benchmarking database comprising pre-merged trade data and consumer data categorized into one or more peer sets of lending institutions, the trade data including one or more loans, and the consumer data including one or more consumer names, addresses, and credit scores, wherein at least some information in the consumer data is private data that is confidential to consumers; and

receiving the anonymized portfolio benchmarking report that includes a portfolio of the first lending institution benchmarked against a set of lending institutions of the first lending institution'"'"'s peer set based at least in part on the merged data.

11. The non-transitory computer storage medium of claim 10, wherein the anonymized portfolio benchmarking report further displays a list of top peers in the peer set competing for accounts of a particular type.

12. The non-transitory computer storage medium of claim 11, wherein the list of top peers includes a minimum number of peers such that portfolio characters of a specific peer are not known.

13. The non-transitory computer storage medium of claim 10, wherein the peer set consists of one institution.

14. The non-transitory computer storage medium of claim 10, wherein the peer set comprises a plurality of institutions.