A large reinsurance broker provides fast and reliable analytics to their customers and partners to help them make better business decisions. Processing data accurately and quickly enables this broker and its partners to anticipate consumer needs, respond to sudden challenges, accelerate market entry and optimize profits. One of the valuable insights brokers provide to their customers (insurance companies) is that they can analyze and predict the risk of their portfolios through the client’s analytics platform. This platform superimposes geological and other threat data onto customer portfolios, allowing customers to evaluate the impact these events will have in specific regions. These customers provide the client with structured data files of different layouts and site level information. In the past, ingesting and processing this content was largely an ad-hoc process, requiring manual Excel manipulation, and custom stored procedures to properly load this data into their various models. This data ingestion process was long and costly due to the labor involved in managing and cleansing customer data.
In order to improve the onboarding process of their customers’ data, the broker hired NGDATA to create a self-service solution, with a web front-end, that would allow customers to upload their data directly into their analytics platform on their own. One of the key requirements for this solution was to have an underlying process which would auto-apply many different business rules to the data in order to organize the information and get it in the format desired by the downstream analytics platform.