BACKGROUND

Meradia’s client, a $50 billion AUM multi-boutique investment manager, struggled to generate timely client or management reporting. Products included public funds, ETF’s, institutional, private client UMA, and retail UMA. Portfolio accounting, reconciliation, performance, and client reporting. These functions are outsourced to multiple vendors including Archer, SEI, Citi and CheckFree. Further challenging the client in this complex landscape was a lack of governance across the data landscape. The client struggled with taxonomy, legacy data, and poor documentation. They could not easily add new data sources or accurately report across all time periods and sources. The client’s Chief Technology and Operations Office engaged Meradia to initially work through the challenges faced by the Archer – Eagle Pace integration, and subsequently extended the engagement to provide the leadership, project management and analysis on a broader initiative to create a central source of clean data for all business and reporting.

ANALYSIS

The Meradia team worked with Eagle Professional Services to review past design decisions and plan a go-forward strategy that would continue to advance system integrations while in parallel tackling missing best practices across multiple subject areas. New integration work included creation, testing and deployment of ETL, Eagle ML, and Eagle Message Center processes. To increase longterm efficiency as the client prepared to integrate additional systems and investment franchises, Meradia worked with the client to establish a data dictionary, to establish historical data requirement policies that would guide conversions and thirdly, a series of data quality classifications that could be applied across different data sets and tied to expected data usage.

RESULTS

The initial engagement, integration of data sets from Archer to Eagle Pace was completed within the four months allocated, on time and in budget. This success led to the second broader engagement during which the Meradia team successfully integrated data between Eagle PACE and Vestmark, Citi, Foreside and FIS, led the Account Data remapping and cleanup in Eagle including integration with SalesForce (inbound) and SEI and Archer (outbound) and thirdly, directed the effort to report on AUM and cash flow from Eagle leveraging MicroStrategy. This substantial body of data work resolved the underlying problems in reporting and facilitated a far more robust and efficient client and management reporting process for the client.

Download Case StudyCategories: , ,