Manufacturing

MAJOR U.S. SEMI - CONDUCTOR MANUFACTURING COMPANY

SPI was selected to provide design, development and implementation of a comprehensive, automated data security systems.

THE BUSINESS NEED

  • Design analysis, concept development, programming services.
  • Documentation of preliminary specifications, design, and development.
  • Conversion of IBM Mainframe data, and Honeywell computer systems data.
  • Convert PC Server data into Oracle database tables, indexes and procedures.

THE SPI SOLUTION

Automated the process to run multiple times per month and imported all worldwide data (from European, Pacific Rim , Japanese, and North American offices into a centralized data warehouse on an Oracle Server at the corporate office) and performed redundant security and data integrity checks. SIC coding was also performed against this data to create functional and activity based hierarchies of the customers and prospects. Using OraWEB as the primary WEB server, views and snapshots were developed to access the data in the warehouse behind the internal security measures and then presented that data on the intranet.

OVERVIEW OF THE PROJECT

During this project SPI provided design analysis, concept development and programming services. In addition, the documentation of preliminary specifications, design, and development were also provided by the SPI team. DBA services were provided when required during the life cycle of this project. Senior SPI consultants participated in the project scheduling and coordination of activities which included assisting in the development of presentations, multimedia tools, and papers to explain the product and goals of the project to marketing and management personnel.

SPI was actively involved in the design, development, troubleshooting, and implementation of a data warehouse which was developed to import and parse data from mainframe and server sources. The data contained information of sales, resale, and marketing activities of the client for the last seven years.

Management reporting and customer market planning involved converting IBM Mainframe data, Honeywell Computer Systems data, and other PC Server data into Oracle database tables, indexes and procedures. The SPI team automated the process to run multiple times per month to import all worldwide data (from European, Pacific Rim , Japanese, and North American Offices into a centralized data warehouse on an Oracle platform.