PORTFOLIO RISK MANAGER

• US 20130151398A1
• Filed: 12/07/2012
• Published: 06/13/2013
• Est. Priority Date: 12/09/2011
• Status: Abandoned Application

• Current Assignee: Dun & Bradstreet Business Information Solutions, Ltd.
• Original Assignee: Dun & Bradstreet Business Information Solutions, Ltd.
• Inventors: Mateti, Devi, Doyle, Keith, Harris, Curt Woodson, Johnsen, Richard C., Kaufman, Jeffrey Lewis, McCann, Claire, Peterson, Cynthia Marie, Porreca, Robert, Rajpal, Sachin, Reginatto, Joao
• Application Number:
  US13/708,649
• Publication Number:
  US 20130151398A1
• Time in Patent Office: Days
• US Class Current: 705/38
• CPC Class Codes: G06Q 40/03 Credit; Loans; Processing thereof
• CPC Class Codes: G06Q 40/06 Asset management; Financial planning or analysis

Abstract

There is provided a method for portfolio risk management. The method includes (a) updating a transaction database with data relating to an operation of an entity, (b) synchronizing a reporting database to the transaction database, where the synchronizing comprises copying the data from the transaction database to the reporting database, (c) receiving a request to prepare a report, (d) obtaining the data from the reporting database, (e) preparing the report from the data obtained from the reporting database, and (f) outputting the report to a user interface. There is also provided a system that performs a method, and a storage device that includes instructions that control a processor to perform the method.

Claims

1. A method for portfolio risk management, comprising:

updating a transaction database with data relating to an operation of an entity;

synchronizing a reporting database to said transaction database, wherein said synchronizing comprises copying said data from said transaction database to said reporting database;

receiving a request to prepare a report;

obtaining said data from said reporting database;

preparing said report from said data obtained from said reporting database; and

outputting said report to a user interface.

2. The method of claim 1,

wherein said updating comprises:

updating a record in said transaction database in accordance with an update process; and

issuing to a synchronization process, (a) a process identifier that identifies said update process, and (b) a record identifier that identifies said record, and

wherein said synchronizing is performed by said synchronization process.

3. The method of claim 2, wherein said synchronizing comprises:

obtaining, based on said process identifier, (a) a query to update said reporting database, and (b) a cross-reference between said record and a location in said reporting database;

reading data from said record; and

utilizing said query to write said data to said location in said reporting database.

4. The method of claim 1,

wherein said updating comprises:

updating a batch of records in said transaction database in accordance with a batch update process; and

issuing to a synchronization process, (a) a process identifier that identifies said batch update process, and (b) a batch transaction identifier that identifies a data structure that contains identifiers of records in said batch of records, and

wherein said synchronizing is performed by said synchronization process.

5. The method of claim 4, wherein said synchronizing comprises:

obtaining, based on said process identifier, (a) a query to update said reporting database, and (b) a cross-reference between said records and locations in said reporting database;

obtaining, from said data structure, said identifiers of said records;

reading data from said records; and

utilizing said query to write said data to said locations in said reporting database.

6. The method of claim 1,

wherein said data concerns a business entity, and

wherein said preparing comprises:

obtaining a data universal numbering system (DUNS) number for said business entity;

constructing a corporate family hierarchical tree that includes said business entity and other business entities, based on said DUNS number;

obtaining additional data concerning said other business entities from said reporting database; and

incorporating said additional data into said report.

7. The method of claim 6, wherein said report includes information selected from the group consisting of:

(a) payment performance for at least one of said business entity and said other business entities;

(b) a list of the largest customers and legal ownership connections between said business entity and said other business entities;

(c) changes in credit risk levels for at least one of said business entity and said other business entities;

(d) a view of customer segmentation by multiple level standard industrial classification (SIC) code;

(e) geography, size and age of at least one of said business entity and said other business entities;

(f) portfolio distribution of at least one of said business entity and said other business entities based on risk bands;

(g) a validation of an existing bad debt calculation or estimation of bad debt collection for at least one of said business entity and said other business entities;

(h) a comparison of credit risk levels for at least one of said business entity and said other business entities and a national average;

(i) a credit limit for at least one of said business entity and said other business entities; and

(j) collections prioritized by oldest/biggest dollars, for at least one of said business entity and said other business entities.

8. A system for portfolio risk management, comprising:

a transaction database;

a reporting database;

a processor; and

a memory that contains instructions that are readable by said processor to control said processor to;

update said transaction database with data relating to an operation of an entity;

synchronize said reporting database to said transaction database, wherein said synchronizing comprises copying said data from said transaction database to said reporting database;

receive a request to prepare a report;

obtain said data from said reporting database;

prepare said report from said data obtained from said reporting database; and

output said report to a user interface.

9. The system of claim 8,

wherein to update said transaction database, said instructions control said processor to:

update a record in said transaction database in accordance with an update process; and

issue to a synchronization process, (a) a process identifier that identifies said update process, and (b) a record identifier that identifies said record, and

wherein to synchronize said reporting database, said instructions control said processor to execute said synchronization process.

10. The system of claim 9, wherein to perform said synchronization process, said instructions control said processor to:

obtain, based on said process identifier, (a) a query to update said reporting database, and (b) a cross-reference between said record and a location in said reporting database;

read data from said record; and

utilize said query to write said data to said location in said reporting database.

11. The system of claim 8,

wherein to update said transaction database, said instructions control said processor to:

update a batch of records in said transaction database in accordance with a batch update process; and

issue to a synchronization process, (a) a process identifier that identifies said batch update process, and (b) a batch transaction identifier that identifies a data structure that contains identifiers of records in said batch of records, and

wherein to synchronize said reporting database, said instructions control said processor to execute said synchronization process.

12. The system of claim 11, wherein to execute said synchronization process, said instructions control said processor to:

obtain, based on said process identifier, (a) a query to update said reporting database, and (b) a cross-reference between said records and locations in said reporting database;

obtain, from said data structure, said identifiers of said records;

read data from said records; and

utilize said query to write said data to said locations in said reporting database.

13. The system of claim 8,

wherein said data concerns a business entity, and

wherein to prepare said report, said instructions control said processor to:

obtain a data universal numbering system (DUNS) number for said business entity;

construct a corporate family hierarchical tree that includes said business entity and other business entities, based on said DUNS number;

obtain additional data concerning said other business entities from said reporting database; and

incorporate said additional data into said report.

14. The system of claim 13, wherein said report includes information selected from the group consisting of:

(a) payment performance for at least one of said business entity and said other business entities;

(b) a list of the largest customers and legal ownership connections between said business entity and said other business entities;

(c) changes in credit risk levels for at least one of said business entity and said other business entities;

(d) a view of customer segmentation by multiple level standard industrial classification (SIC) code;

(e) geography, size and age of at least one of said business entity and said other business entities;

(f) portfolio distribution of at least one of said business entity and said other business entities based on risk bands;

(g) a validation of an existing bad debt calculation or estimation of bad debt collection for at least one of said business entity and said other business entities;

(h) a comparison of credit risk levels for at least one of said business entity and said other business entities and a national average;

(i) a credit limit for at least one of said business entity and said other business entities; and

(j) collections prioritized by oldest/biggest dollars, for at least one of said business entity and said other business entities.

15. A storage device that comprises instructions that are readable by a processor, and that control said processor to:

update a transaction database with data relating to an operation of an entity;

synchronize a reporting database to said transaction database, wherein said synchronizing comprises copying said data from said transaction database to said reporting database;

receive a request to prepare a report;

obtain said data from said reporting database;

prepare said report from said data obtained from said reporting database; and

output said report to a user interface.

16. The storage device of claim 15,

wherein to update said transaction database, said instructions control said processor to:

update a record in said transaction database in accordance with an update process; and

issue to a synchronization process, (a) a process identifier that identifies said update process, and (b) a record identifier that identifies said record, and

wherein to synchronize said reporting database, said instructions control said processor to execute said synchronization process.

17. The storage device of claim 16, wherein to perform said synchronization process, said instructions control said processor to:

obtain, based on said process identifier, (a) a query to update said reporting database, and (b) a cross-reference between said record and a location in said reporting database;

read data from said record; and

utilize said query to write said data to said location in said reporting database.

18. The storage device of claim 15,

wherein to update said transaction database, said instructions control said processor to:

update a batch of records in said transaction database in accordance with a batch update process; and

issue to a synchronization process, (a) a process identifier that identifies said batch update process, and (b) a batch transaction identifier that identifies a data structure that contains identifiers of records in said batch of records, and

wherein to synchronize said reporting database, said instructions control said processor to execute said synchronization process.

19. The storage device of claim 18, wherein to execute said synchronization process, said instructions control said processor to:

obtain, based on said process identifier, (a) a query to update said reporting database, and (b) a cross-reference between said records and locations in said reporting database;

obtain, from said data structure, said identifiers of said records;

read data from said records; and

utilize said query to write said data to said locations in said reporting database.

20. The storage device of claim 15,

wherein said data concerns a business entity, and

wherein to prepare said report, said instructions control said processor to:

obtain a data universal numbering system (DUNS) number for said business entity;

construct a corporate family hierarchical tree that includes said business entity and other business entities, based on said DUNS number;

obtain additional data concerning said other business entities from said reporting database; and

incorporate said additional data into said report.

21. The storage device of claim 20, wherein said report includes information selected from the group consisting of:

(a) payment performance for at least one of said business entity and said other business entities;

(b) a list of the largest customers and legal ownership connections between said business entity and said other business entities;

(c) changes in credit risk levels for at least one of said business entity and said other business entities;

(d) a view of customer segmentation by multiple level standard industrial classification (SIC) code;

(e) geography, size and age of at least one of said business entity and said other business entities;

(f) portfolio distribution of at least one of said business entity and said other business entities based on risk bands;

(g) a validation of an existing bad debt calculation or estimation of bad debt collection for at least one of said business entity and said other business entities;

(h) a comparison of credit risk levels for at least one of said business entity and said other business entities and a national average;

(i) a credit limit for at least one of said business entity and said other business entities; and

(j) collections prioritized by oldest/biggest dollars, for at least one of said business entity and said other business entities.