In the fast paced information driven markets of today, traders and portfolio managers need readily available data to make quick decisions in order to stay ahead of the competition. The latest position and market data must be at their fingertips so time can be spent analyzing, not compiling, data to make the best investment decisions.

When our client came to us, their existing trade order management and management reporting process was excel based and completely manual. The process consisted of manually aggregating position and P&L information from their portfolio accounting system, index information from banks, and additional short rebate P&L information not housed in the portfolio accounting system from prime brokers all into Excel. Piecing all of this data together was labor intensive time consuming and error prone. The excel reports did not support historical reporting since the spreadsheet was designed to store only the current months data.

The client required an automated system to aggregate all the data feeds into a central data mart to produce the required monthly reports. In addition the client wanted an ad-hoc reporting facility to support their investment decision making processes.

FinServ brought in a team of seasoned professionals having an extensive background in distressed debt and systems integration.

Leveraging FinServ’s Systems Development methodology the team designed and implemented a data model that would facilitate the automated feed of data from the required data sources. FinServ built a calculation engine to transform the data providing the required complex report calculations. Data retrieval from the various systems was completely automated using a set of custom-developed web services.

A proprietary system was developed as the user interface and reporting engine on top of the data store.

FinServ delivered a system to the client that was able to produce enhanced reporting while drastically reducing the amount of time the team spent producing the reports. The processing of all the required data from each of the data sources was completely automated.

The report calculations and output were also automated, and the time required to produce the monthly reporting package went from weeks to just a few days. Furthermore, the new centralized data store and ad-hoc reporting facility FinServ setup allowed other uses of the information such as counterparty, commission, and industry analysis.