COMPUTER METRICS SYSTEM AND PROCESS FOR IMPLEMENTING SAME

• US 20120215585A1
• Filed: 10/19/2011
• Published: 08/23/2012
• Est. Priority Date: 10/21/2010
• Status: Active Grant

• Current Assignee: HSBC Technology & Services Incorporated (HSBC Holdings plc)
• Original Assignee: HSBC Technologies Inc.
• Inventors: Hayes, Martin, Loveday, Darren P., Sanghavi, Hitendrakumar, Manning, Philip C., Dodd, Paul
• Granted Patent: US 8,589,213 B2
• Time in Patent Office: Days
• US Class Current: 705/7.29
• CPC Class Codes: G06Q 40/02 Banking, e.g. interest calculation or account maintenance credit or loans G06Q40/03

Abstract

A metrics computer system is configured to collect and analyze metrics from a plurality of account opening data sources including at least one component of an account opening system and a local entity storing account opening data. The metrics computer system includes a data acquisition layer, a data processing layer, and/or an information delivery layer. Various embodiments are described, including a computer implemented method for collecting and analyzing metrics using a metrics component and/or module.

Claims

1. A metrics collection and analysis computer system architecture, comprising:

a plurality of account opening data sources including at least one component of an account opening system and a local entity storing account opening data;

a computer system configured for communication with said plurality of account opening data sources, and including;

a data acquisition layer, acquiring the account opening data from said plurality of account opening data sources including the at least one component of the account opening system and the local entity at a first frequency, and transmitting the data at a second frequency;

a data processing layer receiving the data from said data acquisition layer, extracting amount values to at least one interface file, generating at least one table using input from the at least one interface file, and saving the at least one table in a database; and

an information delivery layer generating and delivering a plurality of account opening reports representing the metrics collection and analysis.

2. The computer system architecture of claim 1, wherein said data acquisition layer acquires the account opening data via group standard data feeds, and wherein said data processing layer generates the account opening reports responsive to the account opening data, providing a standard view of the account opening process, customer and staff interactions, and profitability of account opening processes globally.

3. The computer system architecture of claim 1, wherein said data acquisition layer acquires the account opening data from the at least one component of an account opening system including logs of events and status changes acquired from at least one of an account opening front end, an application processing engine, a queue management system, a customer communications module, a funding system, and a product system.

4. The computer system architecture of claim 3, wherein said data acquisition layer acquires front end logs of management information events and application data from each front end application.

5. The computer system architecture of claim 3, wherein said data acquisition layer acquires front end logs of exit and re-entry events for front end screens supporting local exit points from each front end application.

6. The computer system architecture of claim 3, wherein said data acquisition layer acquires front end data used to identify which configuration options are offered to the user, application processing engine data used to identify the configuration options selected by the user, and wherein the front end data and the application processing engine data are available at an applicant level and a product level.

7. The computer system architecture of claim 3, wherein said data acquisition layer acquires front end logs comprising at least one of a Configuration ID, a Process ID, a Flow ID, and a Tracking ID.

8. The computer system architecture of claim 3, wherein said data acquisition layer acquires front end logs of events comprising at least one of:

terms and conditions displayed to the user on a terms and conditions screen, user accepts or declines the terms and conditions on a terms and conditions decision screen and exits the terms and conditions decision screen, product offer displayed to the user on a product offer screen, and user accepts or declines the offer on an offer decision screen and exits the offer decision screen.

9. The computer system architecture of claim 3, wherein said data acquisition layer acquires front end logs including time difference between rendering of a screen until the user selects to continue from the screen.

10. The computer system architecture of claim 1, wherein said data acquisition layer acquires the account opening data from the local entity including at least one of media agency data, promotion data, and operating plan data.

11. The computer system architecture of claim 1, wherein said data acquisition layer acquires the account opening data from the plurality of account opening data sources including at least one web analytics provider.

12. The computer system architecture of claim 3, wherein said data acquisition layer acquires from the queue management system an extraction of data on the queues.

13. The computer system architecture of claim 3, wherein said data acquisition layer acquires from the application processing engine an extraction of data on at least one of applications, product applications, applicants funding, to-do'"'"'s, and event-based transactions.

14. The computer system architecture of claim 3, wherein said data acquisition layer acquires from the customer communications module an extraction of communications data.

15. The computer system architecture of claim 3, wherein said data acquisition layer acquires from the product system comprising a cards system at least one of a credit card account balance, a Referrer ID, a Voucher code, and a Tracking ID.

16. The computer system architecture of claim 3, wherein said data acquisition layer acquires from the product system comprising a core banking system account details, including at least one of line of business, voucher code, and referrer details.

17. The computer system architecture of claim 1, wherein said data acquisition layer transmits the account opening data to a data interface layer comprising at least one of a channel events interface, an accounts interface, a customer interface, a products interface, a transactions interface, and a staff data interface.

18. The computer system architecture of claim 1, wherein the plurality of reports comprises at least one of a dashboard report, a daily report, a daily tracking report, a sales application funnel report, an application journey report, a media funnel report, a staff funnel report, a product application decisions:

approval ratio report, a product applications age at status report, a configuration options report, and a communications efficiency report.

19. The computer system architecture of claim 3, wherein said data acquisition layer acquires the account opening data responsive to a business process identifier tracked by the application processing engine and a flow identifier tracked by the account opening front end used to determine a sequence of processes for an end-to-end account opening journey.

20. The computer system architecture of claim 19, wherein each account opening journey has a channel attribute having at least one variable, and wherein said data acquisition layer is configured to, when the at least one variable changes to a new variable, acquire the logs of events and status changes responsive to the new variable, without IT intervention.

21. A computer implemented method for collecting and analyzing metrics, comprising:

acquiring account opening data from a plurality of account opening data sources including at least one component of an account opening system and a local entity storing account opening data;

extracting amount values from the account opening data to at least one interface file, generating at least one table using input from the at least one interface file, and saving the at least one table in a database; and

generating and delivering a plurality of account opening reports representing the metrics collection and analysis responsive to said at least one table.

22. The method of claim 21, wherein said acquiring the account opening data comprises acquiring the account opening data from the at least one component of an account opening system including logs of events and status changes acquired from at least one of an account opening front end, an application processing engine, a queue management system, a customer communications module, a funding system, and a product system.

23. The method of claim 22, wherein said acquiring the account opening data comprises acquiring front end logs of management information events and application data from each front end application, wherein the front end logs comprise at least one of a Configuration ID, a Process ID, a Flow ID, and a Tracking ID.

24. The method of claim 21, wherein said acquiring the account opening data from the local entity comprises acquiring at least one of media agency data, promotion data, and operating plan data.

25. The method of claim 21, wherein said acquiring the account opening data from the plurality of account opening data sources comprises acquiring the account opening data from at least one web analytics provider.

26. The method of claim 22, wherein said acquiring the account opening data from the at least one component of the account opening system comprises at least one of acquiring from the queue management system an extraction of data on the queues;

acquiring from the application processing engine an extraction of data on at least one of applications, product applications, applicants funding, to-do'"'"'s, and event-based transactions;

acquiring from the customer communications module an extraction of communications data;

acquiring from the customer communications module an extraction of communications data; and

acquiring from the product system comprising a core banking system account details, including at least one of line of business, voucher code, and referrer details.

27. The method of claim 21, wherein the plurality of reports comprises at least one of a dashboard report, a daily report, a daily tracking report, a sales application funnel report, an application journey report, a media funnel report, a staff funnel report, a product application decisions:

approval ratio report, a product applications age at status report, a configuration options report, and a communications efficiency report.

28. The method of claim 22, wherein each account opening journey has a channel attribute having at least one variable, and when the at least one variable changes to a new variable, acquiring the logs of events and status changes responsive to the new variable, without IT intervention.