Modernizing Insurance Data Management: A Comprehensive Solution for CDI

Customer Overview

Customer

California Department of Insurance (CDI)

Industry

Insurance

Products and Services

  • Power Pages

Client Challenge

The California Department of Insurance needed a modern, externally accessible application to replace its outdated Data Reconciliation Tool. The new platform had to support advanced analytics (BI/AI/ML) for adapting to changing industry standards and rate filing methods. Ensuring accurate data reconciliation before rate filing submissions to RRB was a key goal, as was fostering collaboration between CDI and insurers.

Client Solution

MERP delivered a comprehensive solution tailored to CDI’s needs. Key aspects included: 

  1. User-Friendly Portal: Built an intuitive portal on Microsoft Dynamics 365 for insurers and CDI staff to streamline data submission and review processes. 

  1. Automation and AI Integration: Automated data validation by converting Excel macros into Azure functions and used AI for predictive analysis. 

  1. Dynamic Web Forms: Replaced static Excel sheets with interactive web forms, enhancing user experience. 

  1. AI-Powered Assistance: Developed PARA-Chatbot using Azure OpenAI to provide real-time user support. 

  1. Streamlined Workflows: Incorporated automated notifications to improve workflow efficiency. 

  1. Advanced Reporting: Integrated Power BI dashboards for comprehensive insights into submission and compliance statistics. 

  1. Secure Collaboration: Leveraged Power Pages for secure, external case management and collaboration. 

  1. Multiformat Submissions: Enabled submission of completed applications in Excel and PDF formats, with summaries generated by Azure OpenAI. 

Business Challenges

  1. Outdated Tools: The legacy Data Reconciliation Tool lacked scalability and adaptability to evolving industry standards. 

  1. High Error Rates: Manual processes and Excel-based submissions resulted in frequent data errors. 

  1. Limited Collaboration: Existing systems were not accessible externally, hindering collaboration between CDI and insurers. 

  1. Inefficient Workflows: Manual notifications and data validation processes slowed the rate filing review process. 

Business Benefits

  1. Improved Data Accuracy: Automated data validation significantly reduced errors in rate filing submissions. 

  1. Enhanced Workflow Efficiency: Streamlined workflows with automated notifications accelerated the review process. 

  1. Advanced Analytics: Integration with Azure OpenAI and Power BI enabled predictive analysis and insightful reporting. 

  1. User-Friendly Interface: A low-code/no-code platform ensured ease of use for both insurers and CDI staff. 

  1. Secure Collaboration: Power Pages provided a secure platform for case management and collaboration. 

  1. Scalability: Extensible architecture supports evolving industry standards and advanced analytics. 

Key Features

  1. Intuitive User Portal: Simplified data submission and review processes for insurers and CDI staff. 

  1. Automated Data Validation: Converted Excel macros into Azure functions for seamless validation. 

  1. Predictive Analysis: Leveraged AI to predict potential submission errors and improve speed. 

  1. Web-Based Forms: Replaced Excel files with dynamic web forms for better usability. 

  1. AI-Powered Chatbot: PARA-Chatbot, developed with Azure OpenAI, provided real-time assistance for users. 

  1. Power BI Dashboards: Offered comprehensive insights into submission statistics for CDI, RRB, and NAIC. 

  1. Multiformat Submissions: Enabled submission of completed applications in both Excel and PDF formats. 

This solution addressed the county's immediate challenges and positioned them for long-term success by improving efficiency, reducing costs, and ensuring compliance with FOIA regulations.