Patra In Action – Data Migration

What is an effective AMS?

An effectively managed agency management system (AMS) means that an agency can be confident in its ability to service customers and run meaningful reports. Converting or consolidating agency management systems is an opportunity for an agency to rethink its data structure and review procedures to ensure effective, reliable data. For many years Patra has been providing migration services for agencies. Below is an overview of one such engagement.

In anticipation of a manual data conversion from a proprietary agency management system to a commercially available AMS product, a leading national agency contracted Patra to review the agency’s data management needs and migrate data. An API exchange would not work due to mapping limitations so the team was charged with manually moving more than ten thousand commercial policies from spreadsheets. This involved updating policy and billing screens and moving attachments to the document management system’s filing structure. This included certificate holders lists, statement of value spreadsheets and other pertinent underwriting attachments such as loss runs, applications, quotes, proposals, policies and endorsements with proper labeling.

With data integrity being of utmost importance to this broker, they opted to ensure there were no gaps in system data. Consequently, Patra was asked to compile a list of the customers with missing data points such as customer contact, NAICS/SIC codes, detailed COPE particulars and officers listed on workers’ compensation policies, to name a few. The Patra team simultaneously moved customers over while filling in the missing data.

Not only were their 10,000+ customers moved over successfully, and faster than estimated, the accuracy of the data allowed the broker team to ensure continuity of customer servicing.

About Patra

Patra is a leading provider of technology-enabled outsourcing services and software solutions to the insurance industry. Patra powers insurance processes by optimizing the application of people and technology, supporting insurance organizations as they sell, deliver, and manage policies and customers through our PatraOne platform. Patra’s global team of over 6,500 process executives in geopolitically stable and democratic countries that protect data allows agencies/brokerages, MGAs, wholesalers, and carriers to capture the Patra Advantage – profitable growth and organizational value.

William Wagner, VP of Marketing

Patra media contact

William Wagner
Vice President, Marketing

William Wagner is responsible for Patra's Global Marketing and Inside Sales organization. With over twenty years of marketing and product management, William ensures that Patra's services, technology innovation, and brand are closely aligned with Patra's prospects and customers' needs to bring forth transformative change in how insurance solution are delivered, supported and managed.