DataRaptor® is a powerful data wrangling tool designed for companies managing large and complex portfolios. It facilitates data normalization, audit, encryption, automation, and comprehensive reporting, enabling detailed portfolio management. Its scalability and flexibility allow it to manage data for various purposes, including stress testing, scenario analysis, valuation, and reporting. The software comes with pre-configured asset classes such as Residential and Commercial Whole Loans, Mortgage Servicing Rights (MSRs), Consumer Loans, Credit Cards, Auto Loans, and Asset-Backed Securities. DataRaptor® integrates with systems like Loan Origination Systems, House Price Indexes, FRED Economic Data, and FEMA Disaster Zones, and supports Python and C# scripting languages for customization. Key features include data exception reporting, custom queries, web scraping/data mining, data lookup and Excel parsing, shareable data dictionaries, PII encryption, user-level permissioning, and Active Directory integration with always-encrypted technology, configurable behind firewalls. The data wrangling process involves importing raw data, mapping it into working tables, examining data quality and completeness through user-defined audit rules for correction and calculation, and stratifying data into smaller pools or tranches based on user-defined characteristics. Data enrichment and reporting capabilities allow users to visualize and understand complex datasets, with all loan-level data fields available for export to PDF, HTML, and text formats.

Features & Benefits

• Data Wrangling & Management: Enables data normalization, audit, encryption, automation, and reporting for detailed portfolio management.
• Scalability & Flexibility: Manages data for stress testing, scenario analysis, valuation, and reporting across various asset classes.
• Extensive Integrations: Connects with Loan Origination Systems, economic data sources, and supports Python/C# scripting.
• Advanced Customization & Security: Offers custom reporting, PII encryption, user permissions, and Active Directory integration.
• Comprehensive Reporting: Allows visualization and export of complex datasets to multiple formats.