For this paper, the student is positioned as the chief information officer (CIO) and is asked to lead an initiative to merge the data infrastructures of both insurance companies into a single consolidated data warehouse. You will submit your data integri

Scenario

Imagine you are the chief information officer (CIO) for Virtual World Insurance Company, an organization located in San Diego, California. It provides auto insurance coverage to more than 100,000 customers across the United States and currently has 100 employees. Virtual World Insurance Company has recently acquired Maxon Insurance Company, located in Ontario, Canada.

Maxon Insurance Company has 10 employees and provides auto insurance to 10,000 customers in Canada. As a result of this merger, the chief executive officer (CEO) has asked you to look at a data warehouse as a viable solution for merging both information technology (IT) infrastructures. After doing research, you decide to create a data warehouse that will combine the customer information from both companies into one centralized location. Maxon Insurance Company does not have a relational database. In fact, the company currently stores its data in multiple data sources. As a result, Maxon Insurance Company’s data does not have any unique identifiers. Also, customers with multiple insurance policies have duplicate records. Each spreadsheet repeats the customer’s demographic information. Each insurance company utilizes a distinct customer relationship management (CRM) system.

The CRM systems are used to keep a record of all customers and any communications that are sent to customers. The CRM systems tie into an in-house billing system that is used to bill for insurance premiums, insurance deductibles, and any other billable items. To manage organizational operations, each company uses a different enterprise resource planning (ERP) system. The ERP systems are used to manage human resources (hires, terminations, etc.), payroll, budgeting, accounting, and fixed assets.

To streamline operations and reduce maintenance costs, all data systems (ERP, CRM, billing, etc.) will need to be consolidated into a data warehouse. This will avoid duplicated information and data redundancy.