|
JPMorgan, one of the world's leading investment banks, develops the innovative financial solutions for clients, including M&A advisory, capital markets, restructuring, risk and research platform of unrivaled scale.
An equity and analytics division of JP Morgan’s investment bank services needed a more visual way of communicating broker commission information, without creating a drain on server performance. Additionally, the solution needed to be capable of handling navigation through the complex commission structure, which regularly double compensates traders.
The Challenge:
JP Morgan challenged Chateaux to the task of creating a more dynamic representation of their business that allowed for both a new visual user interface and the capability to handle the large amount of information that went into each commission report.
The company also sought to cut down on the time-consuming process of creating a report, in order to more effectively process commissions and pay its brokers.
The Approach:
After sitting down with end users to confirm the initial list of business requirements, it became clear that what was needed was an entirely new way of handling the building of reports. Chateaux encouraged management to consider moving away from their current Excel-based paradigm, which was unable to handle the thousands of imported data points, to Flex Reporting and a redesigned data structure, much better suited to working within their Business Objects environment.
Chateaux worked with the client to create a list of critical information categories that could be chosen at a high level and then drilled down into for more details. The new delivery system was then tailored to the organization’s unique needs.
By re-architecting JP Morgan’s underlying data warehouse to be better suited to Business Objects, Chateaux technologists were able to create an interface that would allow users to develop their own reports on the fly for a variety of hierarchies and data sets.
Chateaux also worked with end users to educate and train them on the new system and how best to utilize the new functionality.
The Result:
JP Morgan’s new Flex Reporting solution created an intuitive, visual user interface that was easy to navigate for end users.
Where they once used a spreadsheet system to deliver 10,000 data points on a single sheet, they now had the ability to define and develop reports on demand that were clear and easy to read.
Managers were able to access information and compile reports more quickly and effectively. What had once taken a week to compile, now only took a few minutes.
Broker commission overlap was easier to determine, and the department saved the organization more than $150,000 in excess broker commissions.
Flex Reporting was promoted throughout the organization as an example of the value of BI for increasing productivity and affecting the bottom line.
Cathie Jin, JP Morgan analyst, confirmed, “Chateaux was able to give us a great solution. They worked with our staff and mentored them on the proper use of BI solutions within our organization. They did a great job!”
SO004
|
