DataRaptor: Mortgage Portfolio Loan Stratifiaction System

DataRaptor® is a loan-level data manager that efficiently loads, audits, configures, aggregates, and creates reports for all mortgage assets. DataRaptor® is a user-configurable tool that facilitates custom data solutions. DataRapto® features

Input/Output Tools

• 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

Audit and Analytic Tools

• Data Audit
• 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

Pooling

• 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