Client Experience

Olmstead was engaged to evaluate, recommend, and deliver a new reporting platform. Our team designed and delivered a fully integrated and dedicated data management solution to connect several structured and unstructured data sources. The Olmstead team managed the design and development of the reporting mart that automated the data feed for client reports. We also designed end-to-end workflows for data transportation, report creation and approval, report delivery, and storage. The new platform improved the development and delivery of client materials in terms of accuracy, automation, and delivery time (10 days to 3). 

The client was seeking a consulting firm with deep expertise in complex account structures to analyze the current state of their account master, assess data gaps and deficiencies, unwind complexities, and formulate a plan to ready their account master to support the implementation of an IBOR platform. Olmstead completed a mastering initiative that improved information structure, governance, and data trustworthiness. The project significantly reduced risks of new client onboarding, reduced processing delays, and improved reporting accuracy.

The client was struggling with their Salesforce being overextended and not satisfying their sales, service, and marketing teams' needs. The client was looking for consulting expertise to help them define the strategy for how they would utilize Salesforce.  Olmstead executed a full CRM health assessment for this asset manager by evaluating their process workflows, data management practices, reporting capabilities, and application support. An implementation roadmap was created, guiding the client to make several changes that were low effort for the client but contributed significantly to the health of their Salesforce usage and end-users’ satisfaction. 

Olmstead was engaged by a major service provider to design and develop an equity report template to provide an “out of the box” client report solution for their middle office clients and data mart clients.  This project led to a fully automated client reporting solution relieving clients of manual production of client reports.  Duties included the design of the client report, data gap analysis, and design of the business/data workflows, and UAT.  The Olmstead team also authored the Migration Specifications document used by the provider’s middle office clients who utilized Vermilion as part of their middle office solution. 

Olmstead was engaged by the client to lead their project to build a reporting data mart and implement Coric.  This project successfully created a fully automated client reporting process and a gold copy of reporting data resulting in a shorter production period utilizing pre-validated data. Our team was responsible for reporting project status to offices of the CTO, CFO, and Chief Reporting Officer via steering committee meetings.  We successfully automated the production of biographical data, investment commentary, and disclosures, and created Design Specifications for both the reporting data mart and the client report templates. 

Olmstead completed a corporate-wide account master assessment of a multi-affiliated asset manager. The proposed solution created a single account master across the client’s multiple affiliates. It allowed for a seamless flow of data from each individual affiliate to the parent, and enabled the affiliates to use a single corporate license for reference data, share a single platform to produce client reports & marketing materials, and house all data in an enterprise data warehouse.  The project enabled the client to reduce manual data processing, significantly reduce license costs, and cut maintenance efforts. 

Olmstead was engaged to assist with the first Nort American implementation of Vermilion at a large institutional & retail investment manager.  This project fully automated a previously manual client reporting process.  Olmstead's responsibilities included performing a data readiness analysis across multiple sources to determine the systemic availability of data needed to produce client reports.  Our team wrote the design specifications that detailed report design, data mapping, data validation, error processing, and approval workflows. We also developed and completed UAT testing.  Documentation was handed off to the client to be used by business analysts, system analysts, and developers detailing report components, data sources, stored procedures and business contacts.