Project Summary
InsurQuote Systems, Inc. develops leading-edge rating technologies and lead processing tools for the insurance industry. Since the company's first product release in 1986, InsurQuote has consistently provided the most powerful, accurate, and timely insurance rating products available. InsurQuote rating system for Auto Insurance Quotes is available on numerous well-known Internet portals to provide visitors with online quotes. Quote information is gathered through a series of forms with the data gathered and stored in the InsurQuote database. At the end of the quote process the data is compiled and routed to the appropriate insurance firms for fulfillment and follow up dependent on the visitor’s location and various additional qualifiers.
Bender Insurance Agency wanted to extend the quote process to gather additional, unique information and store the complete quote information in a local system for reporting and follow up. A future phase is to include the uploading of the data to their in-house legacy system.
TNP was selected to work in collaboration with InsurQuote to develop a system that would collect (pull) the InsurQuote user data at the end of the initial quote and send (push) that information to a local database at Bender Insurance. Additionally, TNP developed the interim step of gathering the additional, unique information the insurance agency needed to finalize the quote – all while making this interim step transparent (and simple) to the end user. After the user submits the final round of forms to the insurance agency they are returned to InsurQuote and then redirected back to the originating portal site.
TNP was faced with the challenge of not knowing the number of drivers, vehicles or violations that would be pushed in a quote request – these values were variable. Another challenge was to make this process open-ended and modular for licensing to many different insurance companies with different needs.
We solved this problem by using Active Server Pages technology with SQL Server to dynamically generate the HTML, and to dynamically generate dynamic client-side JavaScript code to drive functionality (navigation, validation) for a cross-browser multi-part tabbed form. Yes, you read this right - it’s DD - dynamically creating dynamic code!
In addition to the pull-push processes and dynamic forms, TNP also wrote an extensive logging system to track incoming transactions, raise any errors to the Windows NT logs, and trigger an email notification to the technical staff. This was accomplished with custom programmed COM components.
Reporting on hits by portal and quote request composites were created using Crystal Web Reports available through secured web-enabled access.
|