In this case study, you’ll learn how a Canadian insurance group leveraged the PilotFish Integration Engine solution to read in and parse data for electronic distribution to over 30 agencies and MGAs. In doing so, PilotFish was able to demonstrate the performance and scalability of an eiPlatform interface and deliver an affordable solution on a technology stack with plenty of room for future growth.
The Client is an international financial services holding company with interests in life insurance, health insurance, retirement and investment services, asset management and reinsurance businesses. Through its subsidiaries, it meets the financial security needs of its customers. These needs include a diverse range of products and the handling of policy claims, managing retirement and investment savings as well as providing workplace mental health support. Three of its subsidiaries have licensed PilotFish products.
On a nightly basis, the Client provided a fixed-width file extract containing information about all the policies in the company’s book of business. This extract contained a number of data records for each policy, including detailed information on associated Parties and Coverages. As business expanded, the number of policies in this file was expected to grow to 1-2 million, with a file size in the range of 10-20 GB.
The Client also provided a “hierarchy file”. This file contained information about the relationships between agents and various distribution channels, as well as details about those individuals and organizations. This file contained roughly 50-300 distributors and their associated agents, with the total file size expected to be approximately 15-30 GB.
When a set of policy-related records was processed, the Hierarchy File had to be used to both enrich the data stream with distributor and agent-level information as well as to direct the policy information to the correct outbound extract. Outbound CITS extracts were bound to the distributor through which the policy was sold.
Each policy (and its related parties) had to be translated into a CITS-compliant ACORD XML representation and aggregated into the associated distributor-specific file. The final file for each distributor had to represent ACORD and CITS-compliant TXLife transactions. The file then had to be named appropriately per the CITS standard, compressed via the ZIP algorithm and staged for FTP transmission to the various distributors.
The production of 50-300 outbound CITS XML files from the in-force Policy extract and associated hierarchy file was required to be handled within a 6-7 hour batch window.
PilotFish, along with the Client, completed a major implementation demonstrating the performance and scalability of an eiPlatform interface used to generate a set of ACORD XML data feeds. Previously, PilotFish worked with the Client to implement an initial, prototypical version of the CITS In-Force interface. This exercise demonstrated the capabilities of the PilotFish IDE (the eiConsole) and how it could be used to implement an interface that would generate CITS-compliant output from smaller samples of the extracts mentioned above. While “correct” output was obtained from this prototype, results of initial scalability testing were insufficient to quell concerns over the performance of the production interface.
In the initial proof-of-concept, the interface was designed as three separate eiConsole routes. The first route was responsible for parsing the Hierarchy file and generated a fast, in-memory representation for subsequent reference. The second route was responsible for parsing and transforming individual policies from the administration system extract into individual CITS fragments. Distinct data transformations were implemented for generating Party, Holding and Relation elements of the CITS feed. The third route was responsible for combining the file-based fragments and generating the distributor-specific CITS XML files.
In the follow-on engagement, the interface was simplified to include only a single route. The data flow was as follows:
The reimplementation of this interface was conducted mainly on a developer-class laptop running Windows. In the new server environment, the full file of 1,000,000 policies was processed in approximately 20 minutes. Tests of smaller versions of the file indicate that performance is O(N) (linear). Given this, the observed rate of processing 1,000 policies/second indicates a capacity to handle more than 25,000,000 policies in the 6-7 hour batch window – far more than the number of in-force policies of even the very largest North American carriers.
Running the same interface in an affordable server infrastructure easily exceeds service level expectations more than 10 times over – leaving plenty of room for future growth and additional interface instrumentation.
Since its founding in 2001, PilotFish has been solely focused on the development of software products that enable the integration of systems, applications, equipment and devices. Billions of bits of data transverse through PilotFish software connecting virtually every kind of entity in healthcare, 90% of the top insurers, financial service companies, a wide range of manufacturers, as well as governments and their agencies. PilotFish distributes Product Licenses and delivers services directly to end users, solution providers and Value-Added Resellers across multiple industries to address a broad spectrum of integration requirements.
PilotFish will reduce your upfront investment, deliver more value and generate a higher ROI. Give us a call at 860 632 9900 or click the button.
This is a unique website which will require a more modern browser to work! Please upgrade today!