Riordan Manufacturing, Inc. is an industry leader in plastic injection molding. The company is headquartered in San Jose, California. Since formation in 1991 the company has acquired other companies with production facilities. Each of the acquired locations currently has their own IT systems in place. The company currently has facilities in Pontiac, Michigan, Albany, Georgia, and Hangzhou, China.
At present the company uses different information systems for finance and accounting, sales and marketing, human resources and general operations at each facility requiring much of the data to be converted to various formats in order to be shared with the corporate office. Some of the systems are computerized while others use pencil and paper to maintain records.
Riordan employs approximately 550 people. All of the offices have different network topologies, but they all have a T1 line coming in. The information system upgrade that would be the most practical and beneficial would be to set up the corporate office to provide resources such as software and programs through a hosted environment or cloud computing. Creating a VPN tunnel from each office to headquarters would ensure security of sensitive material.
By deploying a hosted structure, this would allow each facility to keep their current hardware configuration and would not interfere with operations. The The San Jose location would require two additional servers be brought online; one to host the companies remote environments and provide program access to all locations and the other as a SQL server to maintain their database information.
At the corporate level, SQL Server Management Studio (SSMS) and a SQL Server Reporting Service (SSRS) such as Report Builder 3.0 would be installed on the SQL server allowing for customized access, maintenance, and retrieval of company data. (Use SQL Server Management Studio)