Client
Our client is an established asset and fund management firm serving diverse customers with their investment portfolios. The firm has over 35 years of investment experience and almost 25 billion dollars in assets under management, with a presence across nine Asian markets.
Challenge
Our client specializes in delivering fund management solutions to novice and professional investors, helping them achieve their financial goals. This required extensive collaboration among multiple teams and a detailed analysis of investor portfolios, to provide tailored solutions. However, the client faced significant challenges due to the non-availability of a centralized data solution and reliance on manual processes, which were primarily Excel-based. These challenges included:
- Difficulty in integrating information from various custodians
- Absence of a centralized data repository, making it difficult to manage and analyze data efficiently
- Lack of a consolidated view for fund management
- Limited data governance and data ownership, resulting in inconsistencies
- Dependency on multiple data sources for reporting purposes
- Delays in deriving insights, as the process was manual, time-consuming, and dependent on individuals to manage the large volumes of data
What the client needed:
The client wanted to modernize its enterprise data management landscape to enable a comprehensive 360-degree view of its asset management business. They aimed to generate advanced analytics across key areas, including sales performance, fund analytics, and investment management, to improve decision-making.
Solution
To address the client’s challenges, Hexaware implemented a comprehensive approach to transform their asset management analytics. By leveraging our analytics toolkit for investment management, we delivered the following:
- Management dashboards: Built management dashboards for sales analytics, fund flows, KPI score, and investment analytics
- Data integration: Integrated data from transfer agents, IBOR (investment book of records) and ABOR (accounting book of records) data from custodians, and other market data from various sources
- Data dictionary: Provided the company with a comprehensive organization-level taxonomy, significantly enhancing their ability to comprehend data and gain valuable insights
- Data governance and scalability: Successfully resolved data acquisition, governance, and hierarchy issues, streamlining the data management process and developed a scalable solution that ensured the smooth handling of increasing data volumes
- Flexible data model: Created a highly flexible data model, allowing seamless incorporation of new business requirements and additional data points to support the creation of new dashboards and analytics
- Advanced reporting capabilities: Modelled the Teradata system using our pre-built investment data mart, to enable the generation of performance and risk exposure reports and peer comparison of funds
Hexaware’s data and analytics solutions transformed the client’s data ecosystem into a robust, scalable, and insight-driven platform, aligning with their long-term business objectives.
Benefits
Hexaware’s advanced data and analytics solutions delivered significant benefits to the client, such as:
- 50% savings on ad-hoc reporting and data analysis requests through the provision of self-service to customers, businesses, and operations
- 50% reduction in query logs to the technology teams, as the data dictionary helped the business units and operations teams to understand the report content and its sources through mapping
- 100% automation in reporting, leading to improved efficiency
Summary
The client, an asset and fund management firm with over 35 years of experience, faced significant challenges in managing their enterprise data. With manual, Excel-based processes and an outdated accounting system, they struggled to integrate data from multiple custodians, lacked a centralized data repository, and found it difficult to generate actionable insights.
Hexaware addressed these challenges by implementing a comprehensive solution for analytics in asset management powered by our analytics toolkit for investment management. This included creating management dashboards for critical metrics, integrating data from various sources, developing a scalable and flexible data model, and establishing a standardized data dictionary for improved data governance and comprehension. We also introduced advanced reporting capabilities, automated key processes, and enabled the client to generate performance, risk, and peer comparison reports seamlessly.
As a result, the client achieved 50% savings in ad-hoc reporting, 100% reporting automation, and improved data understanding across the organization. Hexaware’s solution empowered the client with a robust, insight-driven platform, enabling them to make data-backed decisions and scale for future growth.
