Grandview helped this client successfully build a security and reference master using Markit EDM as its foundation, bringing together instrument reference and time series data across multiple vendors to enable a “golden copy” of data built on ISO standards for use across the organization.
The investments division of a large multi-national insurance company with approximately $95 billion assets under management with investments spanning across all major public and private asset classes. The client manages liabilities across multiple insurance segments inclusive of life, annuities, and property & casualty.
The client uses several prominent vendor technologies to manage their portfolio, including Blackrock Aladdin, eFront, and Eagle PACE. The data produced from core operating systems is centralized within a proprietary database and managed by a central data team, however the reporting function is siloed across numerous business functions, causing inconsistencies in how data is interpreted and reported to downstream consumers.
The process for business users to develop and produce reports was manual and lacked standardization as it relates to common aggregation and calculation methodologies. To overcome challenges with inconsistent data outputs and delays in producing reports, the client sought to develop an internal analytics data warehouse that would move common logic upstream from the reporting layer to the database layer.
To achieve this objective, the client evaluated their resourcing needs and identified a gap in expertise to combine both the business and technical aspects of the initiative. The client engaged Grandview to lead business analysis, data analysis, and overall architecture of the target solution.
Grandview was engaged to provide their expertise in portfolio risk and performance from both a business and technical perspective. We began the project by evaluating current state reporting processes, building an inventory of reports, limitations, and pain points, and recommending the roadmap and priorities to migrate legacy reports to the new framework.
The project required a deep level of technical skill to analyze existing data structures, stored procedures, and complex MS Excel workbooks that contained embedded logic. Additionally, Grandview provided expertise managing investment-specific data including positions, transactions, performance, benchmarks, and risk calculations, which allowed us to quickly deploy solutions without a middleman between the business and technology teams.
500 West Madison StreetSuite 1000Chicago, IL 60661
Grandview Analytics is a technology consulting and data management software company serving financial institutions nationwide. We offer strategic advisory, technology implementation, systems integration, and data and analytics consulting services as well as managed data services powered by our Rivvit data management and reporting platform.
500 West Madison St.Suite 1000Chicago, IL 60661