Credit portfolio benchmarking system and method

• US 7,904,367 B2
• Filed: 03/05/2010
• Issued: 03/08/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:
  US12/718,701
• Publication Number:
  US 20100274734A1
• Time in Patent Office: 368 Days
• Field of Search: 705/35, 707/10, 706/12, 463/42, 701/117
• 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 build computer programmed to periodically generate at least one data file comprising a plurality of data items, 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 trade line data and consumer data are in a same table and the merged data includes data that categorizes the data into one or more peer groups of lending institutions; and

a benchmarking query application configured to communicate with the build computer to create a user input component display that comprises;

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

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

the benchmarking query application further configured to execute queries using at least a portion of the at least one data file generated by the build computer and at least a portion of the user-entered values.

2. The system of claim 1, wherein the parameters are related to population definition, attribute selection, and population segmentation.

3. The system of claim 1, wherein the hypertext links of the active query build portion are configured to allow a user to navigate through screens of the user input component display.

4. The system of claim 1, wherein the hypertext links of the active query build portion are configured to allow a user to edit a previously-entered value for one or more of the parameters.

5. The system of claim 1, wherein the active query build portion displays at least one of:

all of the user-entered values, a summary of the user-entered values, a subset of the user-entered values, and a representation of the user-entered values.

6. The system of claim 1, wherein the user input component display comprises multiple screens.

7. The system of claim 6, wherein the active query build portion remains visible in the multiple screens of the user input component display.

8. 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.

9. 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.

10. A credit portfolio benchmarking system comprising:

a benchmarking query application, executed on a computer system comprising one or more physical computers, configured to;

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

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

an active query build 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 in at least near real time to retrieve information about a first lending institution using at least a portion of the user-entered values;

determine peers of the first lending institution;

determine respective credit portfolios of the first lending institution and the peers of the first lending institution; and

generate an anonymized report that shows the credit portfolio of the first lending institution benchmarked against the peers of the first lending institution.

11. The system of claim 10, the anonymized report including a list of top peers of the peers competing for accounts of a particular type.

12. The system of claim 11, the list of top peers including a minimum number of peers such that portfolio characteristics regarding a specific peer are not determinable from the anonymized report so as to protect confidential information of the peers.

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

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

14. The system of Claim 13, the benchmarking query application further configured to execute the queries using the at least one of:

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

15. A non-transitory computer readable medium having computer executable code recorded therein, the computer executable code configured to cause a computer system to:

receive an indication of a first lending institution;

receive query parameters for querying a credit portfolio benchmarking database to create an anonymized credit portfolio benchmarking report, the query parameters relating to defining a query population, segmenting the population, and selecting attributes, the credit portfolio benchmarking database comprising pre-merged trade data and consumer data categorized into one or more peer groups 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

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

16. The computer readable medium of claim 15, wherein the anonymized credit portfolio benchmarking report further displays a list of top peers in the peer group competing for accounts of a particular type.

17. The computer readable medium of claim 16, wherein the list of top peers includes a minimum number of peers such that portfolio characters of a specific peer are not known.

18. A credit portfolio benchmarking system comprising:

trade records regarding the status of trade information;

consumer records regarding the status of consumer credit histories;

a build computer programmed to periodically generate at least one data file comprising a plurality of data items categorized into one or more peer groups of lending institutions, wherein each data item includes trade records pre-merged with associated consumer records; and

a benchmarking query application configured to;

execute queries in at least near real time to retrieve information about a first lending institution using user-entered values for parameters of population, population segmentation, and attribute selection and at least one of the plurality of data items generated by the build computer;

determine peers of the first lending institution using at least one of the plurality of data items;

determine respective credit portfolios of the first lending institution and the peers of the first lending institution using at least one of the plurality of data items; and

generate a report that shows the credit portfolio of the first lending institution benchmarked against the credit portfolios of the first lending institution'"'"'s peers.

19. The system of claim 18, the benchmarking query application further configured to create a user input component display that receives user-entered values for parameters, wherein the user input component display comprises an active query build portion configured to remain visible during user entry of a query and comprising hypertext links related to the parameters.

20. The system of claim 19, wherein the hypertext links of the active query build portion are configured to allow a user to edit a previously-entered value for one or more of the parameters.

21. The system of claim 18, 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.