Client
The client is a leading outsourced chief investment officer (OCIO) partner and global investment solutions firm providing a wide range of investment capabilities to institutional investors, financial intermediaries, and individual investors around the world. The client has over $1 trillion in assets under advisement and $288.3 billion in assets under management for its customers in 32 countries. Headquartered in the US, the client has offices in 19 cities around the world, including London, New York, Toronto, Sydney, Tokyo, and Shanghai.
Challenge
The problem faced by the client:
- Siloed data
- Multiple operational data stores (ODS) and warehouses
- Lack of agile data mining and analytics services
- Slow time-to-market
- Absence of an operating platform for supporting planned enhancements
What the client needed:
Consolidation and integration of data for the following feeds:
Security, Position, Transaction, Trades, General Ledger, Tax Lot, Forward Currency Contract, Net Asset Value (NAV), Price, FX rates, Adjustable-rate Mortgages (ARM )data, Over-the-counter (OTC), Investment Book of Records (IBOR), etc.
Solution
Multiple data sources added to the complexity and compounded security risks for the client. A centralized single solution can ensure consistency across all the distributed data sources. Hence, Hexaware decided to have a single data source by implementing an EDM (Enterprise Data Management) platform.
A layered approach
We replaced the client’s multiple data hubs with a single EDM platform that comprised a 5-layer architecture.
- Data sources
- Data acquisition
- Enterprise data store/integration
- Data governance
- Consumers
Challenges faced during the transformation
- Improving the accuracy of delivered reports by focusing teams on data sources and systems managing the reports
- Addressing performance issues in matching the data from different sources (data providers)
- Reducing the dependency of the data operations team on technical support teams for checking the job status, data management, and viewing reconciliation reports
How we resolved these challenges
- Implementing Markit EDM Warehouse to access historical data and meet regulatory requirements
- Integrating the Markit EDM platform to validate and manage financial and customer data
- Implementing Core Matcher for improved performance and transparency through a web UI
Benefits
- USD 10,000 cost savings per month by curtailing the cost per security request
- 10% effort reduction of customer data analyst through the transition of some of the specialized tasks to Hexaware’s data operations support team
- Reduction from 3 hours to 1 hour in the execution time for critical feed processing
- Initiation of daily service level agreement (SLA) status report to show red, amber, and green (RAG) status for all the critical downstream data availability and delays
User groups that benefited
- Investment Division
- Risk Metrics Division
- Portfolio Managers
- Research Analysts
- Finance Division
Summary
Hexaware helped a leading investment management firm tackle its data management challenges and improve operational efficiency. The client consolidated and integrated their data sources by implementing an Enterprise Data Management (EDM) platform, eliminating silos and enhancing reporting capabilities. Hexaware’s layered approach, including Markit EDM Warehouse and Core Matcher, brought significant benefits such as cost savings, reduced effort, faster execution times, and improved data availability. The investment division, risk metrics, portfolio managers, research analysts, and finance divisions were among the user groups benefiting from this successful data transformation.
