Login   |    Register    |    Client Portal   |    Contact Us   |    Careers

Data Warehouse

  • GoldenSource DataWarehouse
    The GoldenSource Data Warehouse solution centralizes positions data to manage risk, performance and regulatory compliance.

    The Data Warehouse improves analysis and reporting capabilities, providing asset managers with a quick, single view of their customers' portfolios. Traders, middle and back office managers will, in addition, have an enterprise level view of risk and exposure.

    • Subject-oriented
      All data elements relating to the same business object are grouped and linked together
    • Time-variant
      All changes to the data are tracked and recorded so that reports can be produced showing changes over time
    • Non-volatile
      Persistent data: Data is never over-written or deleted – once committed, the data is static, read-only, and retained for future reporting
    • Integration-focused
      The data warehouse can capture data from all operational systems and ensure it is consistent and meets defined quality criteria

10 Business Impact Areas

  1. Centralizes positions for Order Management and Trading Systems
  2. Improves Compliance across all asset classes and product silos
  3. Shows Transparent and accurate data Assets Under Management (AUM)
  4. Allows Performance and Attribution data to be shared across the firm
  5. Stores risk data in a Single repository (can be organized by sector, industry, asset class etc.)
  6. Centralizes inflow/outflow data for Cash management savings
  7. Provides Collateral Management and Stock Lending programs
  8. Aggregates positions to reconcile futures contracts
  9. Acts as a single repository to feed billing and commission systems
  10. Automates position data collection for Client Reporting and RFP responses

GoldenSource Data Warehouse can be delivered on premise or OnDemand

Securities & Products

A global security master that creates, maintains and publishes a standardized reference data repository for all financial instruments.

Positions & Transactions

An integrated enterprise operational data store delivering accurate, consistent and reliable real-time positions data.

Customer Master

Global customer master and global counterparty master applications. Links instrument and entity information for risk and exposure management.