Data Extraction, Transformation, and Loading

Data Agent ETL capabilities are specifically designed to efficiently facilitate the movement and transformation of the large, disparate data sets that are critical to investment managers. Our data adapters are designed to integrate easily into complex front, middle, and back offices in a short time frame and to provide the investment manager with secure and auditable trails of investment activities.

Quality Data is the Foundation for Critical Decision Making

The Data Agent ETL process has three major functions:

• Extraction of data from one or more internal and/or external data sources
• Transformation of data along predefined business rules for data cleansing, reformatting, standardization, and aggregation
• Loading of data into the Data Mart

The Data Agent team has real-world data management capabilities. We work with both large and small financial management companies across multiple sectors on a variety of data integration projects. Our “out of the box” data integration loaders include but are not limited to the following data sets:

• Built-in Data Loaders/Adapters
• General ledger packages
• Partnership accounting systems (Geneva, STAR, Axys, AFS)
• Private equity
• CRM systems
• Hedge fund data providers (Eurekahedge, Hedge Fund Research, LipperTASS)
• Market data vendors (Bloomberg, Reuters, Compustat, Barclays, S&P, MSCI, etc.)
• Custodian data (State Street, BoNY, Northern Trust)
• Synthetics (Markit Partners, Intex, etc.)
• Trade order systems (Charles River, Latent Zero)
• MBS analytical data (Fannie Mae, Freddie Mac, HUD, FHA)
• Economic statistics from MSCI, IMF, and U.S. government data sources (census data, Bureau of Labor Statistics, etc.)