Seattle-based PEMCO Corporation is one of seven independent companies that form PEMCO Financial Services which provides one-stop insurance, banking and brokerage services. But because PEMCO Corporation is a business-to-business transaction processing clearing house for the umbrella company, its customers are all internal. Through PEMCO Corporation, the parent company shares common functions such as data processing, inventory and corporate accounting services.

"Two years ago, PEMCO was faced with two simultaneous challenges," according to programmer analyst Dianna J. Brinkley. "We wanted to build a Customer Information System (CIS) with a tool that would use our data as well as perform both traditional and non-traditional scrubbing--in other words, not just names and addresses. The CIS would function as a hub of various legacy operational systems. We also wanted to build an information or data warehouse, but our data of several million records was all in free-form fields--not heavily codified or edited."

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