Warehousing

Provided data analysis, data modeling, data warehousing, business intelligence, and financial system services for Citizens Property Insurance Corporation ("Florida Citizens"), a company with annual written premium in excess of $3.5billion.

i4 successfully created and implemented data warehousing and business intelligence solutions for Florida Citizens personal lines and high risk transaction systems which are two distinct policy and claims systems. i4 developed and documented the data and business rules to facilitate the creation of the data warehouse environment without the benefit of internal systems documentation and staff assistance. This solution provided Florida Citizens with sophisticated measures, such as earned house years, earned premium, credibility, frequency, loss costs, loss ratios, etc. These measures may be trended historically and viewed by any combination of dimensions such as product, geographic regions, agents, catastrophes, cause of losses, etc. This solution has enabled Florida Citizens to greatly improve the visibility into their business and support expert decision making.

i4 also performed services to reconcile the Florida Citizen's data warehouse to the financial statements for 2 annual reporting periods.

i4 performed services to validate key Florida Citizen's policy and claim production reports and provided change specifications as necessary when production reports were incorrect.

i4 provided the specifications and business rules to implement a ceded premium function ("take-out" premium processing) for Florida Citizen's 25 year old legacy system.