Transaction aggregator

• US 8,086,528 B2
• Filed: 06/25/2010
• Issued: 12/27/2011
• Est. Priority Date: 11/19/2008
• Status: Active Grant

• Current Assignee: Visa International Service Association (Visa, Inc.)
• Original Assignee: Visa International Service Association (Visa, Inc.)
• Inventors: Barrett, Melyssa, Scott, Joe, Hilgers, Nancy
• Primary Examiner(s): Khattar, Rajesh
• Application Number:
  US12/824,030
• Publication Number:
  US 20100262536A1
• Time in Patent Office: 550 Days
• Field of Search: 705 35- 45
• US Class Current: 705/38
• CPC Class Codes: G06F 16/24556 Aggregation; Duplicate elimination
• CPC Class Codes: G06Q 10/067 Enterprise or organisation modelling
• CPC Class Codes: G06Q 20/4037 Remote solvency checks
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising
• CPC Class Codes: G06Q 40/02 Banking, e.g. interest calculation or account maintenance credit or loans G06Q40/03
• CPC Class Codes: G06Q 40/03 Credit; Loans; Processing thereof
• CPC Class Codes: G06Q 40/08 Insurance
• CPC Class Codes: G07F 7/08 by coded identity card or credit card or other personal identification means without personal verification means G07F7/02

Abstract

Systems and methods for determining and reporting aggregated transaction level data regarding a particular user are disclosed. Based on the requests of one or more information requesters, an aggregator server can request transaction level data for all accounts associated with a particular user from a transaction database. The transaction database returns raw transaction level data for all accounts associated with the particular user to the aggregator server. The aggregator server can then parse the raw transaction level data based on a number of transaction level data elements and information requester input. The parsed raw transaction level data can then be used to determine the number of predefined or information requester defined transaction level data aggregates. The resulting transaction level data aggregates can then be sent in a report to the one or more information requesters.

Claims

1. A method for deriving aggregated transaction data comprising:

sending a user inquiry file to a data source from an aggregator server;

wherein the user inquiry file comprises a specific consumer level information for one or more users;

receiving at the aggregator server a linkage response file from the data source based on the user inquiry file;

parsing the linkage response file to determine a user account identifier using the aggregator server, wherein the user account identifier is unavailable prior to receiving the linkage response file;

generating a transaction data inquiry file comprising the user account identifier using the aggregator server;

sending the transaction data inquiry file from the aggregator server to a transaction database;

receiving at the aggregator server a transaction data response file from the transaction database in response to the transaction data inquiry file;

parsing the transaction data response file according to the user inquiry file using the aggregator server; and

determining aggregated transaction data from the parsed transaction data response file using the aggregator server;

wherein the transaction data response file comprises raw transaction level data having transaction data records for all accounts associated with a particular user;

wherein the aggregated transaction data is based on customized transaction aggregates defined by one or more information requesters; and

wherein parsing the transaction data response file comprises extracting transaction data elements based on a plurality of transaction level data element identifiers.

2. The method of claim 1 furthering comprising generating a report file including the aggregated transaction data using the aggregator server and sending the report file to one or more information requesters.

3. The method of claim 1 wherein the raw transaction level data further comprises a plurality of transaction level data elements.

4. The method of claim 3 wherein parsing the transaction data response file comprises grouping the transaction level data records according to the transaction data level elements.

5. The method of claim 1 wherein the aggregated transaction data comprises a bankruptcy risk management indicator.

6. The method of claim 1 wherein the aggregated transaction data is based on a model transaction aggregate.

7. The method of claim 6 wherein the model transaction aggregate comprises a bankruptcy risk management aggregate.

8. A system for deriving aggregated transaction data comprising:

a memory; and

a processor;

wherein the processor is configured to send a user inquiry file to a data source, receive a linkage response file in response to the user inquiry file from the data source, parse the linkage response file to determine a user account identifier, generate a transaction data inquiry file comprising the user account identifier, send the transaction data inquiry file to a transaction database, receive a transaction data response file based on the transaction data inquiry file, parse the transaction data response file according the user inquiry file using, and determine aggregated transaction data from the parsed transaction data response file; and

wherein the user inquiry file comprises a specific consumer level information for one or more users;

wherein the user account identifier is unavailable prior to receiving the linkage response file

wherein the transaction data response file comprises raw transaction level data having transaction data records for accounts associated with a particular user;

wherein the aggregated transaction data is based on customized transaction aggregates defined by one or more information requesters; and

wherein parsing the transaction data response file comprises extracting transaction data elements based on a plurality of transaction level data element identifiers.

9. The system of claim 8 wherein the processor is further configured to generate a report file including the aggregated transaction data and send the report file to one or more information requesters.

10. The system of claim 8 wherein the raw transaction level data further comprises a plurality of transaction level data elements.

11. The system of claim 10 wherein the processor is further configured to group the transaction level data records according to the transaction data level elements.

12. The system of claim 10 wherein the processor is further configured to extract transaction data elements from the transaction data response file based on a plurality of transaction level data element identifiers.

13. The system of claim 8 wherein the aggregated transaction data comprises a bankruptcy risk management indicator.

14. The system of claim 8 wherein the aggregated transaction data is based on a plurality of model transaction aggregates.

15. The system of claim 14 wherein the model transaction aggregates comprise a selection of bankruptcy risk management indicator aggregates.