Insurance company outsources data management and reporting using Grandview's Rivvit platform

Client Profile

An Insurance company with ~$90 billion in assets allocated across multiple investment managers and accounting systems.

    Business Situation

    The Client outsources their investment management function to multiple investment managers who use Blackrock Aladdin as their Investment Book of Record (IBOR). The Client utilizes CAMRA (SS&C Technologies) and ePAM (State Street) internally for their Accounting Book of Record (ABOR). Additionally, the Client maintained multiple spreadsheets to track private investment activity, securities lending, and actuarial data for their insurance policies. In total, the Client has over 20 unique data sources and 50 report templates that are manually compiled on a periodic basis. As an Insurance Company, the Client is also subject to various regulatory filings and liquidity requirements that are audited on a periodic basis. The Client started an initiative to create a central data warehouse to support their internal and external reporting needs with the goal of increasing operational efficiency and establishing better process controls.

    The Client engaged multiple prospective solution providers and ultimately selected Grandview based on the rapid deployment of a working prototype; proving the flexibility of the Rivvit platform and the team’s detailed knowledge of the underlying asset classes and Insurance accounting concepts.

      Results

      In three months, the Client went “Live” after Grandview integrated all data sources and developed 50 custom report templates. Additional highlights include:

      • Created a centralized data hub across previously siloed systems, personnel, and data providers.

      • Deployed a portfolio and security master across 3 legal entities, 30 portfolios, and 6000 unique securities.

      • Migrated 12 months of historical data including 20,000 lot-level positions and 180,000 transactions.

      • Integrated the Client’s ABOR and IBOR to add new risk calculations across complex asset types.

      • Increased reporting frequency for reports that were previously too time consuming to produce monthly.

      • Established a data source hierarchy to provide a single source of truth for each data field.

      • Automated model calculations to support stress testing and scenario analysis for key liquidity ratios.

      • Eliminated the need for 3rd party compliance calculation agent; saving $100,000 annually.

      • Tripled the number of accurate and available data fields to allow for future reporting enhancements.

      500 West Madison Street

      Suite 1000

      Chicago, IL 60661

      Technology

      Rivvit

      Contact Us

      info@grandviewanalytics.com

      (516) 286-7792

      Contact form

      Follow us

      Copyright © 2014 - 2020 Grandview Analytics, LLC and Grandview Technology Solutions, LLC