Finisar Malaysia Sdn. Bhd

ACKNOWLEDGEMENT

First and foremost, I would like to express my deepest gratitude to Finisar Malaysia  Sdn. Bhd for I am able to complete my Student Industrial Training ( SIT ) and Student Industrial Project ( SIP ). Many valuable lesson and experience that I have gained through out the period that one day it will guide me to become a successful and well-rounded graduate in future time.

A special thanks and my highest gratitude toward people who have assisted me through out this internship period especially my supervisor Mr.Shahrulnizam Yeop Othman who has guide me in completing my project. He has been supportive and always assisting me in completing tasks and understanding on the project. Not forgotten also Mr. Faizal for his endless support and assistance. A special thank also to Mrs.Ponnee Govindasamy from Human Resource Department for taking a good care of all trainees through out my training.

In advance, I also would like to express my gratitude to Center For Student Internship Mobility and Adjunct Lectureship for helping me seeking answers regarding our SIP period. Not forgotten also, Dr Nordin Zakaria for answering my question regarding problems that I have encountered through out the SIP period. I also would like to thank to my university supervisor, Mr. Yew Kwang Hoi for his time and visit during the period of my industrial training.

Last but not least, my sincere appreciation to my family and friends for their never-ending support and encouragement through out this SIP period.

Abstract

The main focus of this project is to develop an application named Test Time Query and Automation that will be used by Industrial Engineering ( IE ) Module Team to extract data from Finisar database for analysis and making report. Users also will used this application to do some automation to make reports. The aim of this project is to increase the efficiency and effectiveness from the current manual process. This project was proposed by my supervisor in order to fulfill the requirement of Student Industrial Internship Program as well as to encounter most of problems occurs with the current manual process.

This new applications are developed to reduce the time in managing the entire process of extracting data from the database and also the process of making report. The inefficiency from the previous process can be identified as the test capacity module report that IE team previously using is barely updated. Thus, the time taken of making decision on a product taking a long time. This applications are designed to serve as a tools for IE team in reducing the time taken in completing process thus increasing efficiency and effectiveness of the current manual process.

Faster delivery of information is essential for many organizations especially in production and manufacturing company. The benefits of developing this application is it reduce the time usage for delivering information as all process are done through a system. Qualitative study will be adopted in order to consummate the literature review and to understand the concepts of the current process involved. Furthermore, it is important to identify the drawbacks of the current process thus gathers the users requirement for this project.

As for result, this new application is highly recommended to develop in order to cater all possible issues arisen to maintain data integrity as well accuracy that eliminates data redundancy and human errors.

Introduction

Finisar Malaysia was fully established in May,2001. The operation of the company started with at pioneer bath of 47 employees. Today, the facilities employed and boast at more than 6000 employees and still growing.

        In Finisar Malaysia, the company focused of the application of fiber optics to provide a broad line of high performance, reliable, value added optical subsystem for networking         and storage equipment manufacturing. Finisar Malaysisa is the largest offshore manufacturing plant in South East Asia today.

        The Test Capacity Planning by the IE Team         has not been perpetually enhanced to reflect the ever transmuting business environment that applying the technology throughout the whole processes. It is because the process taken a long time as most of the process are done manually. The flow of Test Capacity Planning is shown as below:

1.1        Objectives

The objectives of this projects are:

1. To reduce the time taken to extract data from Finisar database.
2. To reduce the time taken to calculate data based on selections.
3. To maintain data integrity and accuracy that eliminates data redundancy and human errors.
4. To ease the process of organizing, editing, and producing reports.

Scope Of Study

This study will focus in on Test Time and machine allocation which aggregates the fundamental knowledge of the details of the Test Capacity Planning requirements  and the process. It is intended to assists the IE Team in preparing the analysis report and thus ensure the decision in test capacity planning is correct. This project involves the designing of program using Visual Basic Application ( VBA ) and Structured Query Language ( SQL ). Microsoft Excel is used as tool.

The main application is expected to consist of several macro and one sheets with the ability to insert, alter and delete and able to do some automation in making report. The designation is based on the requirement stated by my Supervisor. This system is expected will be able to reduce the time taken to extracting data and making reports and reduces user’s mistakes on calculating and making reports.

1.3        Problem Statement

• In order to have an efficient and effective application, IE Team need to have a system that can implement convenient, prompt and accurate procedures. Furthermore, the procedures should be able to ease the making of capacity planning report which will be determined the successfulness of the project. The system will provide a convenient process of selecting, editing, and managing data as it will be complement with a proper and systematic instruction. Currently, the IE Team is using manual process which the extracting of the data must be done on Finisar Intranet Website using the CAMSTAR. In the manual process, it is taken a long time to complete one analysis thus making the generation of report taken a longer time than expected. Due to this, IE Team barely update the Capacity Planning file that already been placed in Finisar Server Drive. Issues faced by IE Team is listed as below :
• The Test Capacity Module File is barely updated due to the time taken of completing one test report.

• There are duplication of data by doing manual process.
• The data extracted using manual process are in messy format.
• The data file extracted using manual process are not in excel format.

1.4        The Relevancy of the Project

        I am supervised by Mr. Shaharulnizam Yeop Othman, Principle Engineer, Industrial Engineering, and Module Team. The IE Team use capacity planning report to determine the resource required for meet the product capacity set by the management. This project have been proposed by mr supervisor as it is required a basic knowledge of software development and coding and system testing. In order to complete the project, I need to gather all the requirements from my supervisor and documentation of previous reports. This project is relevant to my field of study which Information and Communication Technology ( ICT ).