DataRaptor®: Mortgage Portfolio Loan Stratification System

DataRaptor® is a loan-level data management application that utilizes a highly efficient ETL process to load, reformat, standardize, audit, and aggregate mortgage asset data. DataRaptor® is a user-configurable tool that facilitates custom data solutions and reporting options. DataRaptor® features:

Data Extraction

Flexible data model that works natively with SQL Server, but will accept data from any ODBC data source
Wizards and Tools with automatic type recognition that enable easy creation of input and output templates
Support for user-configured field formats that assist data validation and loading of non-standard data

Data Cleansing

User-configurable tools for formatting, standardizing, and auditing data fields
Built-in scripting language offering complete flexibility in configuring business logic or data scrubbing rules with built in string, date, and math functions as well as syntax checker and test rule features
Audit engine with wizards and modules to facilitate creation of data mapping, error tracking, and calculation rules
Support for external data as well as wild cards and numeric ranges

Aggregation and Output

Creation of pooling categories or trees via interactive interface
Support for all standard loan aggregation types
Pass loan-level or pooled or tranche level data into WinOAS™, MarketShield™, MIAC-ALM™ or any other table format
Stratification of MSR Assets
Stratification of Whole Loan Assets

Reporting

Built-in reporting tool to create, edit, export (pdf, excel, html, txt, etc), and print customizable reports
Ability to view reports created in Crystal Report

OLAP (On-Line Analytical Processing) and Data Cubes

Imbedded support for OLAP (with SQL Server)

Wizards to facilitate creation of multidimensional cubes

Cube viewer to visualize data relationships and to create and save user-defined views

Export data to HTML and Excel