The client is a clinical-stage bio-pharmaceutical investment firm with approximately $1.8B in assets under management and committed capital.
This client has an extensive track record of helping the world’s most transformative therapies come to fruition. Utilizing multiple systems to conduct thousands of calculations, the firm tapped Portfolio BI to automate the reporting. With the help of PBI EDM, the firm was able to increase efficiency inits operations while producing dynamic visualizations of their P&L data information in a centralized, secure, cloud-based platform.
Before PBI EDM, the client was taking data from their Portfolio Management System and manipulating it directly in Excel. They wanted sophisticated performance reports,portfolio management, and risk management tools in place from the start. Each portfolio manager wanted detailed metrics of their weekly reports, and the Chief Investment Officer wanted the ability to automate Investor Tear Sheets instead of going through a fund administrator. In addition to weekly reports, the client needed to maintain risk exposure, end of day, and historical P&L information in a centralized, secure, cloud-based platform.
"PBI brought the background of an experienced team as well as the system needed to expand our reporting capabilities. By hiring consultants to build something custom, you may end up with a system that is hard for others to support afterwards. With PBI, you get the platform as well as the expertise, customization, and ongoing support in a one stop shop." - COO/CCO
We customized and implemented PBI EDM, our flagship data warehousing and reporting solution for the client, based on their specific data needs, business model, and trading strategies. PBI EDM allowed the client to properly store all its portfolio-related data in a single location, and incorporated transaction,position, and P&L data from Excel. Our customization incorporates Risk Metrics data such as VaR, correlations, etc. PBI EDM provided users the ability to produce daily dashboards and reports across various attributes including P&L and end-of-month investor-level reporting. Investors were able to view historical information on both open and closed positions. Through simple design elements in the system, PBI EDM allows users to focus exclusively on their business objectives and view information at various summary and detail levels.