Databases and Data Warehouses

JPMorgan Chase employees use various forms of technology every day. Most programs and databases are created and used for the retail sector of the company. These programs include, but are not limited to, “Teller Express”, “Customer Assist”, “Outlook”, “Internet Explorer”, “Training Central”, and “Contact Manager.” Databases can be found in “Teller Express”, “Customer Assist”, and “Contact Manager”. These three programs were created and maintained by employee teams at JPMorgan Chase. Each of the programs contains databases of customer information such as account numbers, account balances, contact history, address information, etc. Information is entered into the customer profiles by personal bankers, tellers, and other branch employees such as managers and SSAs which stands for sales and service associates. This information is obtained through contact with the clients, as well as clients’ transactions such as updating their contact information online or when they make a purchase or transfer that changes their balance. The programs are also able to track who viewed the information and also what was viewed and when. The database found in “Teller Express” contains the least information of the three programs. The only information that can be viewed is account numbers, balances, and customer addresses. If an employee needs to research anything for a customer, they would need to use “Customer Assist” because that database holds the most information. Managers can obtain information reports from any of the three programs. In “Contact Manager” and “Customer Assist”, reports are detailed, but tend to be based on individual clients; such as past and present customer transactions and clients’ contact notes which have been entered by other employees. The reports from Teller Express are less detailed but contain information drawn from a broader spectrum. For example, the program would allow you to print all monetary payments made on a specific day. Such reports can be obtained for any type of teller transaction on any specific day.

The investment banking sector of JPMorgan Chase uses “DataQuery.” This is a research tool used through “MorganMarkets” which is a research and data portal for institutional clients. “DataQuery” is an online interactive application. It pulls historical financial data from various locations before analyzing and charting it into one single database. “DataQuery” allows clients quick and easy access to view hundreds of thousands of data entries that could be beneficial to their purchasing and trading of investments. JPMorgan Chase uses OLAP which is an online analytical processing that allows the manipulation of information to support decision making. A data warehouse is a logical collection of information and is necessary for JPMorgan Chase to create customer relationship activities, strategies, and campaigns. By creating this data warehouse employees can view all transactions each customer has made at a given time any time, check opportunities, and study the different market for prospect customers.

The data mining tools are used to manipulate the data warehouse information and depending on which department needs this information, it can be small or big; the goal is to create business intelligence. An example of how JPMorgan Chase can use this tool would be in the case of the receivables department who create a data mart. Data marts are a subset of a data warehouse this is where a focus portion of the data warehouse information is kept. An example could be seen in the accounting department where one would be created to allow this department to have specific information based on the needs of a customer, making this data mart manageable considering the particular needs to the individual receivables items. JPMorgan Chase’s browser-based capabilities streamline exception management through structured workflow, enabling online dialogue, intraday decision-making, and automating decision-making within client-established parameters. For example, the capability to assign company distinct reason codes and to create notes to transaction allows clients to document their findings related to the individual.

All this processes have a correlation because data mining tools are to data warehouse users what data manipulation subsystems tools are to database users. Then, the data warehouse system has the responsibility of converting logical requests into physical equivalents through query and reporting tools, intelligent agents, as well as, multidimensional analysis tools and statistical tools. The software used for this department is Real-Time which supports a collaborative environment for trend analysis and benchmarking. Daniel D’Silva is the Senior Vice President and receivables executive for the treasury service business of JP Morgan Chase. With over 15 years of cash management experience, he is responsible for strategy, execution, technical sales support and delivery of the receivables products and service.