Data Extraction, Transformation and Loading

At Data Agent we realize that accurate and timely access to your financial data is the driving force behind being able to make critical business decisions in real time. Data Agent’s ETL capabilities are specifically designed to facilitate the movement and transformation of large, disparate data sets. 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, working with some of the largest global investment managers on a variety of data integration projects. IM-Suite allows you to combine research and market data from external and internal sources. Calculate analytics and statistics on every asset class, including complex derivatives such as IRS’s, CDS’s, CDO’s, CDO-2’s, and loans. We work closely with your internal resources to de ne a centralized Security Master which will answer everything you need to know about any security, any asset or any liability, across any time series.

Our data integration loaders include but are not limited to the following data sets:

• Market data vendors (Bloomberg, Reuters, Compustat, 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.)