GAIN Financial Data Management Technology

GAIN Financial Data Management Technology (GAIN FDMT) is a comprehensive data management and workflow management platform for:

• the standardization of the reference data management of financial instruments
• the control and improvement of data quality
• the development of data interfaces to new and existing systems
• the creation and management of a Security Master File / a Golden Copy

GAIN FDMT is based on a multi-data-feed architecture, which means that all types of providers can be matched not only for pricing information, but also for the whole range of reference and static data. It accesses data feeds (external or internal) and databases, processes messages (formatting, de-formatting, validation, completion) and exports data to applications and databases of the bank.

With facilities for security master file management, corporate actions, and exception handling, the FDMT provides much of the daily data management out-of-the-box. The modular approach of the FDMT supports the step-by-step creation of a fully fledged data management platform that synchronizes growing needs in the backoffice area with expenditures.

Areas of application

• Selection management
• Direct requests to several data providers according to user defined criteria
• Potential optimization of data procurement costs
• Feed handler (15+ different feeds)
• Multi-data feed integration
• Cross-Referencing
• Support of different ID schemes for the matching of different data sources
• Data Scrubbing
• Validation of data (application of rules)
• Cleansing and Normalization (Harmonization of data structures of different sources)
• Merging and prioritizing different data sources
• ETL (Extract, Transform, Load) functionality
• Rule engine and Workflow Engine
• Data mapping (structure and content)
• Development of STP interfaces (e.g. to Avaloq) by direct export of data feed data to databases of the client or in other desired formats
• Security Master File (SMF) / Golden Copy Management
• Storage and Management of the data
• Display of data in dynamic forms
• Automatic and manual processing of exceptions (Exception Handling)
• Generation of user defined data models

Supported data feeds and interfaces

Data that can be processed and stored

• Static data (Basic data)

• Reference data
• Pricing data
• Corporate actions (Events)
• Custodian data
• Internal information
• Ad-hoc requests and data for the intra-day creation of newly added instruments