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.


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


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


  • 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


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


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:


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

We pride ourselves on hiring talented and experienced employees. We are staffed with industry experts who have worked in many facets of the financial sector for decades, making it easy for us to relate to the needs of our clients.

Request a demo