A data mapping & management platform to facilitate analytics, reporting and reconciliation Qorus Innovation in Insurance Awards 2024

A vast amount of data used to come each month to the client’s European offices from authorized agents, all in disparate formats. Mapping was done manually using Excel files. The project goal was to automate data mapping and provide the client’s talents with clean data for insightful reports and reconciliation for several insurance business lines (warranty servicing, P&C, M&C, ATE insurance, Accident & Health insurance).

We started the project with the simplest thing: using our in-house developed data management methodology, we mapped the Excel files with insurance data we received, brought them to one readable format, and uploaded them to the database. The client's analytics team tested the data and our solution was thus verified.

The resulting product is a non-GUI system. All the processing happens under the hood, hidden from the business users. Automatic data input happens at a set interval. In our case the system collects files once every hour. Such an interval is comfortable for the users and ensures an optimal load on the server.

- Once a business user gets a file from a contractor, he/she puts it in a designated folder and waits for an email notification – processing success/failure/error, etc. - The system collects the files from the configured catalogs and knows where the output files go, respectively. - If the file input is a success, the process ends here for the underwriter. The system will do the rest and the analysts will soon get their clean data in the output folder in the warehouse. - If not, he/she receives a notification in an email on what kind of error occurred (a simple user-friendly notification system was implemented to help business users communicate with the platform). - If he/she can figure out the error him-/herself – rename the file, fill in the missing fields, etc. – then he/she does those basic corrections and the cycle starts again. If not, then the support team comes in to figure things out.