Personal tools
EtWB Ltd - Claims Database
EtWB Claims Handling required a Database driven system to provide 25 users with the ability to process significant numbers of Total Loss Motor Insurance claims
EtWB provide a vehicle valuation service to the Motor Insurance industry.
Once a vehicle is declared a 'total loss' by the Insurance company EtWB can handle the claim to completion, thus freeing up Insurance company Engineers.
InfoCentrality provided EtWB with an InfoSea Office server for central data storage, for the original spreadsheet based claims handling procedure.
It was clear that a Database application would be required, and EtWB produced a Requirements Specification for a solution supporting 25 users and 70,000 claims per year.
InfoCentrality designed and implemented a Database application using a web browser for the client, an Apache web-server and a PostgreSQL RDBMS.
The ClaimsDB application went live on the 1st of June 2007.
The application runs on a Dell PowerEdge 2950 with a 2GHz quad core CPU, 4 GBytes of RAM and SCSI disks using a RAID controller.
To speed up and improve accuracy during the initial data entry, the system has been enhanced to connect to the Audatex database system via a Soap server to download and enter claim information automatically.
To date (Nov2008) it has been used to process more than 62,000 claims with a total database size of 68GBytes as it includes a lot of pictures, and routinely handles 50 users.
Recently InfoCentrality have provided an InfoSentinel system to connect EtWB's network to their leased line. Master and slave DNS and fail-over DHCP services have been implemented.
