1.2 ABSTRACT
A Human Resources (HR) department is a critical component of employee well-being in any business .It functions to encourage, through strategic management, the utilization of human resources to achieve both the mission and goals of the organization, promote the growth, satisfaction and development of the employees, Provide support to ensure legal compliance in the labor-related arenas of the law within the day-to-day employee process such as hiring, getting feedback, counseling, termination, safety and more. The project titled “HR Database” aims at developing a system which will automate the functioning of the HR Department of Sierra Atlantic Limited. This project automates all the activities that the HR Department has to perform prior to and after inducting Employees as well after getting seperated from the company. These activities constitute tasks like o
Basic Employee data
o
Skill Levels
o
Compensation data
o
Project data
o
Performance data
o
Passport Information
o
Visas information
o
Training programmes attend
o
Growth path
o
Separation data
Under the Company Details data the following details are stored. o
Maintain a list of the various Departments
o
Maintain a list of the various Designations
o
Maintain a list of the various Grade Levels
Under the Basic Employee Data the following details about an employee are stored. o
Employee Personal Data
o
Employee Official Data
o
Family Background
o
Educational Details
o
Previous Experience (if any)
Apart from these facilities
to add any branch, department, country, category, state names
in view of the future requirements and additions as and when done. Provides detailed reports to extend the decision makers ability to process information and knowledge, shorten the time associated with decision making ,improve the reliability of a decision process or outcome Employee transfers are made very easy, so that when a employee changes his department,or desgination or gradelevel to a new one the details are automatically updated in the employee profile.
The HR department is governed by the company’s quality system that governs all software development activities. There are a number of MIS reports generated by the HR Department, which at present, are either manually done or done using Microsoft Excel. The data is maintained in various Excel formats. There is a need to rationalize the database and bring in control in managing the data.
This entailed lots of unnecessary wastage of resources, especially for the book keeping related tasks of the HR Department . A need for the automation of all these activities was felt. To this effect the front end was deemed to be an internet browser and the data store backend was Oracle. The Java programming language has been selected to be the go between the data store and the application. The Java programs will be accessed by the browser using the JSP technology.