Any function that demands the import and management of Excel data can be dramatically simplified and made much more accurate by the use of CATEX’s Data Vera, says Frank Fortunato.
A few years ago CATEX had a small US-based reinsurer as a client, which licensed the Pivot Point transaction system. An interesting feature of this company was that it recorded the details of every single proposal that was ever submitted to it either by a broker, managing general agent or directly.
CATEX is itself an insatiable consumer of data—we never pass up an opportunity to structure an import process to any of our systems to allow for ingress of more data—so we thought highly of this effort until we learned several things.
The first thing was how difficult it was for our smaller-sized reinsurer to capture all the details of all the incoming placement proposals. Our client constructed a master spreadsheet that expanded as new data fields were unearthed and more proposals were submitted. The Excel file was ever-expanding and the personnel authority rules as to who could modify the template were draconian. One slip-up on one field and the other three people adding in dozens of proposals weekly could effectively be adding to gibberish.
To continue reading, you need a subscription to Intelligent Insurer. Start a subscription today for £655.
In-house feature articles, the archive and expert comment require a paid subscription. Subscribe now.
Want to give it a try? We are offering a two week free trial to the Intelligent Insurer website – register and select “Two Week Free Trial” to begin access to the full Intelligent Insurer archive and read the latest news, features and expert comment. Begin your free trial here.
Is your 2 week free trial about to end? Upgrade to a 12 month subscription for £655 now.
If you have already subscribed please login.
If you have any technical issues please contact support.
CATEX, Frank Fortunato, Technology, Data Vera