Developing a cloud-based data solution for an investment management firm to improve data curation and reporting
Operate services | AI, Data and Insights
The challenge
The client, a large investment management firm, faced significant challenges in collecting and curating data from multiple sources, including a portfolio of more than 30 property managers and other third-party data providers with different systems. This data had to be gathered on a monthly or quarterly basis. The process was performed almost entirely manually, leading to frequent human errors and inconsistencies.
Consequently, there was considerable back-and-forth communication with business teams to correct these errors and finalise the monthly, quarterly, and yearly reports. This manual approach hampered efficiency and delayed the timely production of accurate, reliable reports, which were crucial for informed decision-making and strategic planning within the organisation.
US$22 billion in assets under management.
The solution
Deloitte Luxembourg designed and implemented an end-to-end, cloud-based data management solution named AlternativeLens for the client's daily operations. This included deploying a tailored data model on a state-of-the-art cloud platform, developing data quality controls, and automating reporting capabilities in formats like Excel, PowerBI and web-based dashboards for real-time data analysis.
AlternativeLens helped achieve accurate and timely reporting, reduce human error, and enhance operational efficiency. Deloitte Luxembourg continues to support the client by fostering continuous improvement of AlternativeLens and aligning with their strategic vision.
The outcome
Improved data quality and reporting
- Streamlined the reporting process, from data collection to report creation for a portfolio of US$22 billion assets under management, helping to ensure deadlines are consistently met.
- Facilitated a smooth transition from the existing process to the new system, including conducting workshops and onboarding business users and 40+ external data providers across several jurisdictions.
Operational efficiency
- Created a cohesive data model that spans the portfolio with more than 1400+ assets, helping to ensure consistent data usage based on modern data management standards.
- Optimised data collection and reporting workflows to help minimise errors and enhance efficiency.
- Enabled seamless integration of historical and real-time data from European, UK, and APAC portfolios, supporting continuous operational improvements.
Collaborative growth
- Deloitte continues to provide invaluable insights and ongoing support, empowering the client to develop a forward-looking vision and expand their operations strategically.
Nicolas Griedlich
Vincent Gouverneur
