REVIEWER: Sharon Schroebel, assistant vice president of Avemco Insurance.

BACKGROUND: For more than 40 years, Avemco Insurance has been insuring general aviation aircraft and pilots, with a specialization in property and casualty insurance for pleasure and business aircraft owners, renters and pilots. The company is the market leader in its industry and is the only direct writer of aviation insurance in the United States.

PLATFORMS: Avemco is currently migrating from AS/400 to NT.

PROBLEM SOLVED: Our market is very defined, with more than 99 percent of our customers coming from two lists the Federal Aviation Administration (FAA) compiles and disseminates each month. One file contains the names and addresses of all certified private pilots in the United States and its territories. The other file contains all registered private aircraft in the U.S. and its territories and the aircrafts' owners. However, a number of factors make harnessing this data more complicated than it would appear. The data is challenging. For instance, the aircraft registry file contains duplicate data, and fields contain both company and individual names. While we only provide insurance for the 50 states, the data also contains records from U.S. territories including Puerto Rico and the Virgin Islands. There is also a significant degree of overlap between the two databases, with many of the individual certified pilots listed in the first file also on the second file as registered aircraft owners. We must, therefore, parse each record into its component fields to determine which individuals are in both files and then eliminate duplicate entries.

PRODUCT FUNCTIONALITY: Group 1's technology enables us to ensure the integrity of our customer and prospect data as well as identify and consolidate duplicate records to obtain an accurate single customer view. When we receive the FAA lists, Group 1's solutions enable us to remove records from U.S. territories as well as records containing army post office (APO) or fleet post office (FPO) address information, both indicative of military pilots. Because the FAA lists may contain first names, middle names, surnames and company names in the same field, we utilize Group 1's technology to parse individual elements into separate fields, helping us improve processing efficiency. We must also de-duplicate these lists, which is critical because as many as 70 percent of the individuals on the aircraft registry are also licensed pilots and, therefore, on both FAA lists. Consequently, we must compare the current FAA lists with the lists from the previous month to determine which individuals are new to the list ­ and are new prospects. This process also helps us identify those individuals who are no longer on the FAA list and are not prospects. The merge/purge process additionally ensures we are not wasting resources and damaging customer relationships by marketing to current customers.

STRENGTHS: Group 1's technology is powerful and accurate. The products can be easily integrated in a seamless solution via Group 1's workflow-oriented interface, which provides end-to-end control over the entire direct marketing process. In fact, the technology is so easy to use that our marketers are comfortable managing the direct marketing process via the user interface.

WEAKNESSES: It is difficult to read SQL tables in certain data quality modules.

SELECTION CRITERIA: We have utilized Group 1's core address data quality technology for more than a decade. We recently licensed additional solutions from Group 1, and we did so due to our comfort in knowing that we are working with the market leader. We found the ability to control all data quality functions from a single, easy-to-manage interface to be most compelling.

DELIVERABLES: The technology provides accurate, consolidated name and address records.

VENDOR SUPPORT: We have greatly enjoyed working with Group 1. Calls regarding technical issues are returned promptly. We found an on-site visit from a professional services consultant was invaluable in providing us with an understanding of how the products can best be utilized in our enterprise.

DOCUMENTATION: The documentation could be improved to correspond better with the user interface. It would be difficult to run certain modules relying only on the documentation.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access