Integrating Underwriting & Claims:
Commission Calculation & Analytics for commissions tracking dashboard with Qlik to replace the multiple excel spreadsheets used to calculate and report agent commissions. The dashboard tracked agents performance based on policies sold and dollars collected. The dashboard provided data access and analysis capabilities to the commission facts.
The goal was to provide users with access to policies sold and fees collected at the agent, field manager and AVP levels.
The Commissions model incorporated both fiscal information and new meta data. Solve100 assisted client with design and recommended changes to the core business processes before implementing those changes in the client’s core systems. The application design will allow scalability for future phases and show additional data from which to make critical business decisions. Tasks included:
Claims Data Analytics for a national insurer for home and auto allowed the client to analyze claims data and identify potential fraudulent claims including roof repair and replacement based on geography, weather metrics and dates. The analytics application also allowed them to identify errors in claims processing and better streamline internal processes that ultimately lead to a more profitable organization.
BI Environment Optimization and support for an organization that supports Benefits Consulting, Compliance and Healthcare Data Analytics. Utilized data analytics for:
Cost reduction and control for benefits administration
Identification of problem areas and associated solutions
Evaluation of plan performance to ensure effective and more efficient benefit plans