The Nowel Group Home  |  Contact Us
aboutcustomersFAQs Client Log-in:
 


Case Studies in Data Conversion

Company 1
The investment division of a global, multi-line insurance company with assets under management of $120 billion. For this company, we rendered the following services:

  • Conducted an analysis of data sources to validate requirements for the design of a performance measurement system and the installation of our GIPS compliance solution.
  • Extracted CUSIP level information for all assets under management for the last ten years.
  • Populated multiple time period databases with data from a statutory accounting system.
  • Reconciled all inventory positions and historical transactions for ten years.
  • Identified procedures that required transformation for total return measurement:

    o Late-entered trades
    o Inter and intra company transfers
    o Portfolio mergers
    o Incorrect treatment of Interest Only CMO's
    o Inconsistent usage of transaction codes

  • Supplemented return calculation with new data and processes:
  • Built extracts to an ODS that interfaced directly with BlackRock Solutions
  • Built extracts for derivatives to an internal data warehouse
  • Designed new procedures to calculate committed cash, trade date cash, miscellaneous cash
  • Adapted a month-end paid-for-accrued procedure
  • Established monthly batch update procedures
  • Built comprehensive reconciliation procedures

Company 2
A global investment management company with assets under management of $14 billion.
This company required the following services:

  • Assembled ten years of data from multiple global sources to calculate composite returns.
  • Identified missing information in current accounting system and extracted required source data from archived databases.
  • Conducted data mapping, specification and transformation for ten years of account data and re-calculated all returns.
  • Supplemented data with missing characteristic codes.
  • Reconciled all results to published reports.
  • Populated a central repository with historical account returns and other required data for GIPS compliance.
Company 3
A domestic asset management company with assets under management of $150 billion. This company required the following services:
  • Extracted ten years of historical data from thousands of spreadsheets for 55,000 accounts.
  • Designed a central repository for all historical data.
  • Reconciled all data at the monthly level.
  • Supplemented data with codes required for GIPS compliance.
  • Built extract files for integration into another software application.

Company 4
The investment division of a domestic life insurance company with assets under management of $120 billion. For this company, we did the following:

  • Designed the original data warehouse with interfaces to multiple accounting systems — securities, commercial mortgage loans, equities.
  • Created several special purpose databases requiring extracts, transformations and updates from internal databases and external market data providers.
  • Managed many aspects of the conversion to PAM from a proprietary accounting system.
  • Managed the conversion of data for the merger
Information Request     |    Links Directory    |    Contact Us
© 2007 The Nowel Group. All rights reserved.