223: Investment Research and Portfolio Management Analytics using Oracle OLAP
Chris Claterbos , Vlamis Software Solutions, Inc.    Biography
Peeyush Shukla , Mesirow Advanced Strategies, Inc.    Biography

Objectives: Present a Solution for a complex problem
Familiarize audience with Oracle BI Stack
Demonstrate that there is always a Solution to any given problem.
Abstract: Mesirow Financial is a diversified financial services firm headquartered in Chicago decided to step into the future and create a set of integrated tools and dashboards to help there analysts manage and analyze their performance. They had the following challenges: - Performant solution needed to aggregate complex hierarchies quickly - Replace existing quantitative statistical application - Data to be fed from Pervasive database to Oracle - Scalability of solution as the data volumes and users increase - Flexibility and speed of rollout essential as multiple different application to be rolled out, using same footprint. - 10 years of historical data, from multiple data sources, to be stored and aggregated in one database. - Support for dynamically changing model

This presentation provide a technical overview of the solution and demonstrate some of the unique solutions that were created to solve their problems using Oracle Database, OLAP, JDev and BI Beans.

Audiernce Focus: Developers
Expertise: Intermediate
Track: Business Intelligence/Warehousing
Date: Wednesday, April 16, 2008
Time: 9:45 AM - 10:45 AM