Formerly known as Global Research & Risk Solutions
70% TAT reduction in investor reports for a top private asset manager, leading to 30% growth in reporting frequency
About the client
- A leading US-based private asset manager required transformation in investor reporting support for its most complex product
- The mandate encompassed automating Excel-based reporting, creating and updating reports, setting up recurring presentations for existing and prospective clients, and providing periodic product updates and fund manager summaries
Challenges
- Fragmented workflows, undocumented product logic, unstructured Excel workbooks and inconsistent decks made reporting heavily manual, with recurring formula errors
- Multiple data source migration and changing requirements added delivery risk
Our solution
- Team set-up: We set up a team with varied expertise across hedge funds, private markets, technology and experienced leadership to aid informed client decision-making
- Delivery management: We established reporting timelines, coordinated stakeholder dependencies and adapted workflow requirements and multiple data-source migrations without interrupting product delivery
- Automation of reporting: We rebuilt and streamlined data backups using SQL, Power Query and Excel, and standardized recurring and quarterly decks, linking tables and charts to underlying data for near one-click refreshes
- Quality review: We conducted structured reviews, reconciled underlying data against a third-party platform and resolved discrepancies, and established controlled data backups to improve auditability
- Improved analytical contribution: We analyzed performance trends independently and drafted commentary for investors and senior stakeholders. Also handled ad hoc return data requests and performed compliance checks
- Documentation and process continuity: We documented each deliverable, including relevant backups, SQL queries and reporting procedures through detailed SOPs. Cross-trained team members to minimize/eliminate keyperson dependency
Impact
70% reduction in turnaround time across 25+ recurring reports, enabling 30% growth in reporting frequency
|
80% reduction in monthly investor reporting efforts |
50% reduction in large dataset validation time |
50+ hours saved monthly through automation and workflow redesign
|
Reduced platform risk and strengthened client confidence
|
Explore Crisil, a company of S&P Global