More than 800 Validations to check for data quality anomalies
Manual and automated procedures for significant data enhancements
Data augmentations leading to more accurate loss analysis
RMS was appointed by a leading global MGA underwriting specializing in an extensive range of specialty insurance products to provide a series of data services across the company’s property & casualty portfolio, including portfolio roll-up and reporting.
While working on client data, the RMS Analytical Services team ran a stringent validation algorithm that comprises of over 800 checks for data quality anomalies. During this check for approximately 500,000 properties, the team noted poor geocoding due to missing address attributes as well as limited and incorrect information on critical building attributes, such as construction type, year built, occupancy, and number of stories.
This shortfall in data quality and completeness reduced the accuracy of modeled results and heighted uncertainty of loss estimates, hence impacting portfolio management and capacity allocation decisions.
The RMS Analytical Services team flagged these issues with the MGA and conducted a data enrichment process across the portfolio to illustrate the impact on model outcome.
Data quality enhancement is a core service of the Analytical Services team and the team’s combination of scale, expertise, technology, and process efficiency ensures a quick turnaround time, even when enhancing large volumes of location data. The team applied multiple engineering heuristic validations and augmentation processes to the dataset, including both manual and automated procedures, to establish geocode accuracy, remove invalid information for each location, and introduce missing building attributes.
By combining manual and automated processes, the team achieved extensive data enhancements which included:
By improving data accuracy and introducing critical building attributes into their property portfolio, the MGA was able to achieve a more accurate loss analysis. As a result of this exercise, the MGA noted a decline in Average Annual Loss (AAL) for Earthquake (16 percent), Windstorm (5 percent) and Severe Convective Storm (37 percent) and an increase for Winterstorm (12 percent) compared to modeled losses using the original data.
Establishing this improved modeled loss accuracy enabled the MGA to adjust the allocation of capacity more effectively. The enhanced data clarity provided a stronger foundation for portfolio management and capacity allocation decisions. It also enhanced claims preparedness through a more accurate event loss analysis.
Manage Your Business
Expand your analytics capabilities with RMS-managed and on-demand analytical services offered by a worldwide team of 400 specialists with deep domain knowledge and rapid responsiveness.Read More
Highly predictive and comprehensive solutions for underwriting property cat risk.Read More