Resources Case Study
Delivered a 50% reduction in time-to-market for onboarding end clients, superior fund manager decision support and end user experience.
State Street Corporation (Infra Hedge) is an American financial services and bank holding company headquartered in Boston, Massachusetts, US with worldwide operations. It is ranked 15th on the list of largest banks in the United States by assets. It is one of the largest asset management companies and custodian bank in the world. The Infrahedge product is offered by State Street Managed Accounts Services Ltd, a subsidiary company of State Street Corporation and part of its Alternative Investment Solutions Group. The Infrahedge team specialises in building and operating industrial strength infrastructure solutions for institutional investors in hedge funds. The company is ranked 259th on the Fortune 500 as of 2018.
The goal of Infrahedge was to provide better visual reports to its customers with the help of analytical reports, get automated for complex calculations of risk and performance metrics so that it could reduce the time lag, workload of the IT team and simultaneously remove delayed reports to the customers.
Infrahedge used QlikView but Gain Insights recommended to upgrade to Qlik Sense (upgraded version of Qlik View with added features).
As the business had complex calculations with huge model, it required a simplified process to solve it and the same was done where the calculation was done using excel. In context to that, now, a simplified model was prepared where the calculations were done in the back-end and not the front end. Now front end was used only to provide the final output to the users/viewers.
Now, there was the requirement to reduce the manual calculations and get automated for more than 50 files to provide a single output. Data was extracted from admin to Qlik in Qlik View Data (QVD) which did the complex calculations by itself for the file preparation and helped reduce the time to get reports from 2 hours lag to just 10 minutes.
For performance metrics lot of files was extracted from the database into single QVD but previously they had multi charts which were not linked and viewing the reports also became time consuming. We simplified the work by putting all metrics in performance metrics calculation into a single container. We added features like overlap of charts by creating buttons which could provide different charts such as line cart, bar chart, etc. into a single table. One more feature of drill down options was created to give reports of all the metrics of the Fund performance in the same container.
Different dashboards such as Risk dashboard, Fund performance dashboard, operations dashboard, summary dashboard, reports dashboard was created in a single application so that each customer can view all the reports in their respective single application. A Re-balancing dashboard was also created to provide the impact of Fund Performance and Risk Metrics across sectors, regions and class assets.