DataRaptor^®

Data Wrangling Tool

DataRaptor^® enables data normalization, audit, encryption, automation, and comprehensive reporting for detailed portfolio management.

Configure your Data Auditing Process According to Business Rules you Design

Because of its scalability and flexibility, DataRaptor can be used to manage data for a variety of purposes, including stress testing, scenario analysis, valuation, and reporting. Asset classes are pre-configured including Residential and Commercial Whole Loans, Mortgage Servicing Rights (MSRs), Consumer Loans, Credit Cards, Auto Loans, and Asset-Backed Securities.

Integrations

Loan Origination Systems
House Price Indexes
FRED Economic Data
FEMA Disaster Zones
Python and C# Scripting Languages

Customizations

Data Exception Reporting
Custom Queries
Web Scraping/Data Mining
Data Lookup and Excel Parsing
Shareable Data Dictionaries

Security

PII Encryption
User-Level Permissioning
Integrates with Active Directory
Always Encrypted Technology
Configurable behind firewalls to automate procedures and encryption

Data Wrangling Process

Raw data is imported into DataRaptor and mapped into working tables using a field mapping process. Source data loads and remains intact to provide a clear audit trail.

Imported data is examined for quality and completeness. Through user-defined audit rules, missing information can be identified, incorrect fields corrected, and new data calculated from existing data fields.

From a database of loans, and based on user-defined characteristics, smaller pools or tranches of loans with similar characteristics are created. During the stratification process, data is aggregated from asset to repline.

Data Enrichment and Reporting

Enrichment

Created specifically for companies managing large, complex portfolios, DataRaptor enables data discovery, automation, encryption, and comprehensive reporting for detailed portfolio management.

Reporting

DataRaptor’s reporting allows users to visualize and understand complex datasets of all sizes. All loan-level data fields from both the audited data file and source data fields are available for reporting. Reports can be exported to PDF, HTML, and text.

All Software Solutions Include:

Onboarding

We closely work with the client’s IT department for software installation. We create and provide the initial setups based on the client’s specifications. This saves the client FTO hours so they can focus on training.

Support (Onsite & Online)

We offer 2+ days onsite training and often follow-up with online sessions to reinforce training material. Our web-based support ticketing system allows clients to easily submit requests and monitor its progress. Our support team members work from several locations, which means we offer longer working hours.

Industry Expertise