University Claim Automation Management System

Tang, Shirleyann Chooi Teng (2017) University Claim Automation Management System. Final Year Project (Bachelor), Tunku Abdul Rahman University College.

Text Shirleyann Tang Chooi Teng_FULL TEXT.pdf Restricted to Registered users only Download (4MB)

Abstract

Purpose : University Claim Automation Management System is developed in partial fulfillment of the requirement for the Bachelor of Information Technology (Honours) And Bachelor of Science, Campbell University, U.S.A. The system aims to eradicate the current manual claim application process in TAR University College (TARUC) as the current way of applying claim is still using forms and it has to be manually filled out. The manual ways should be replaced with the computerized system as manual process is tedious and the data may not be reliable. With the developed system, staffs can efficiently apply claim, reduce human error, and others. Current TARUC staffs use paper-based claim and the processing time usually take around 2 months while other organizations are already using computerized system. Existing computerized claim system such as CELCAT Pay Claim Management (PCM), Employee Self Service (ESS), and Manager Self Service (MSS) used by other organizations resulted in reduced HR workload, decreased number of data validations, reduced costs, and more. Scope : The developed system provides functions such as login, change password, retrieve forgotten password, claim application, view claim status, maintain claim rate, set public holiday, send reminder, maintain student-supervisor list, claim approval, and view report. Methodology : The system is developed following the Waterfall model as each phase must be completed before proceeding to the next. During the design stage, database is designed using Microsoft Access and IBM Rational Software Architect Designer For WebSphere. While in the coding stage, Microsoft Visual Studio 2013 has been used to develop ASP.NET web pages. The system uses MySQL database which is already included in the Visual Studio package. Development phases : In the requirement analysis stage, background of the current manual system is studied to come up with the appropriate functions or modules of the proposed system. After that, the system design stage produced the database design and user interface design of the system. When the database and user interface design has been completed, the system is ready to be coded according to the user requirements. The functional system is then tested using several type of testing methods. Test cases were prepared to test the system to make sure the system is bug-free. Assessment criteria used : Before the system can be used by user, the system has undergone several testing such as unit testing, integration testing, system testing, and acceptance testing. Results : The developed system has achieved the objectives of increase efficiency and reducing human errors as most process are automated or require less user input. The system proved accurate in data and efficient process. The only weakness of the system is that it does not consider claim for project and industrial training (full time staff) and for staff that quits in the middle of the job. Conclusions and Recommendations : From this project, management skill is enhanced apart from increased programming knowledge. This will help in future software or project development. The system developed may not be perfect. Hence, there will need to include a larger scope and consider more scenarios.