Company Bio

The client is a global long/short equity hedge fund. It employs long/short event-driven and credit/high yield strategies to make investments.

Challenge

A well-established, multi-strategy hedge fund sought to complement its existing data warehouse with a way to compile data from various sources to create custom reports. The process for creating reports with multiple counterparties and data sources had grown cumbersome, and the firm had trouble dedicating the hours to create internal reports on a daily and weekly basis. The report creation process involved downloading select reports from each of the four prime brokers, position data from the administrator, and certain market data from Bloomberg.

The client tapped Portfolio BI to improve the way they handled their existing data requirements, and leveraged software to improve the quality, efficiency, and accuracy of their reports.

Approach

After evaluating the client’s current processes and reporting, Portfolio BI customized and implemented PBI EDM and integrated with the client’s in-house systems and their counterparties. We also built a security master to tag and monitor prices, while also customizing treasury functionality to find discrepancies quickly. The client’s treasury workflow process was automated, and reports were set to provide drill-down functionality and details. Users were able to interact with the data through dashboard analysis and reconcile their portfolios with ease.

‍

“PBI EDM helps us daily by compiling our data and providing checks and notifications to help us act on the data – whether we need to move cash or positions across prime brokers, or prepare a regulatory filing. During the workday, I keep PBI EDM open on my web browser to always have our reports available and accessible, and I appreciate being able to pull our archived data within seconds." - CFO

Solution

The implementation of Portfolio BI has had a significant impact on their business. We created a central hub of information for the client, and they can now autonomously store data in the cloud.

Our team assisted the client in implementing custom calculations on various data elements within the interface.  We’ve also given the client the flexibility to produce historical data sets, which were not easily accessible under past processes. Our software improved the overall operations of the firm and solidified that their data will always be in sync.