Data collection, aggregation and dissemination presents an ongoing challenge for financial services organisations and performance teams, with the need to collate data from disparate sources, including internal and external systems, spreadsheets, databases and vendor feeds.

Kurtosys’ data management capabilities provide a complete solution for capturing, consolidating, aggregating and integrating data from multiple and wide-ranging sources, enabling delivery of accurate and timely data for client communications through a central data mart. With connectivity to multiple data sources, from trading and accounting systems to market data feeds and file-based commentary, all your client communications data can be captured via workflow processes, with built in audit and controls, for ease of deployment across multiple media, whether web, print, PDF, Excel or Powerpoint.

The Kurtosys data management module integrates with the core client communications platform and can be deployed across the entire range of Kurtosys’ business solutions for accurate and consistent presentation of data across client reports and marketing materials, websites, secure portals and corporate presentations.

Data integration and consolidation

  • Connectivity to multiple data sources and market data feeds
  • Flexible data store for diverse instrument types – e.g. OEICs Unit Trusts, Pooled funds, segregated funds, Multi-currency classes, REITS
  • Centralised business data and documents  – accurate transactions, positions, valuations and accounting data is accessible across multiple media and business modules
  • Consolidation of real time, structured and unstructured content
  • Reusable data – single input for multiple outputs, e.g. reports, charts, tables, web
  • Data processing and matching

Data extraction

  • Capture data from any ODBC-compliant database, data vendor feeds, applications and files
  • Automatic and manual data feeds
  • Simple and advanced SQL queries

Data validation and transformation

  • Data integrity and exception checking
  • Data mapping, transformation and validation rules
  • Pre- and post- calculation

Data loading

  • Ad-hoc or workflow-driven data loads
  • Load data into a central data mart or link to an external source
  • Audit history

Flexible data model

  • Support for any data schema
  • Standards-based data models with custom capabilities