Mis Project- Hris

Management Information System

HUMAN RESOURCE INFORMATION SYSTEM Of

SENSYS™ (Private) Limited

Submitted to: Mr. Tauseef-ul- Hassan Group Members:

Hafiz M. Usman Akram - PGD 2007-083 • Masood Shahid - PGD 2007-123 • Ahsen Ali - PGD 2007-129 •

REQUIREMENT PHASE

IDENTIFICATION: We have identified after the study of Human Resource system of SENSYS (Private) Limited is very weak. There is an irregular and/or on demand requirements are more frequent and centralized inventory data sheet is incomplete in many aspects. Procurement procedure also kept gaps of delayed delivery of items in case the said item is not in inventory. There is no concept of store. IT (Computer Hardware and Accessories) and Office Supplies (Employee’s entertainment and office cleaning/maintenance supplies) inventory record are kept in a separate datasheets and there is lack of an updated inventory record and in hand and issued. Furthermore, if there is any previous ownership of any inventory item, there is no such record or track.

OBJECTIVE: The main objective of this study is to maintain the centralized HR database that will be helpful to maintain the better and updated HR system. This practice will be time saving and the updated record will be available on demand. This will reduce the human efforts and other costs. We are also going to improve the centralized datasheet that will track employee’s history.

SCOPE: The concept of a centralized datasheet will be implemented for Human Resource Department. It will help the management and concerned HR Personnel to track the employee’s records every time when it is required. It will also help to find out the required human force demand in house or outsource.

ANALYSIS PHASE Distribution of Efforts in various Phases: S.No. 1. 2. 3. 4. 5. 6. 7. 8.

Phase

Efforts (%age) 15 20 10 15 15 05 10 10

Requirements Phase Project Planning Project Management Designing Coding Integration User Documentation Quality Assurance

PROJECT PLANNING 1. ESTIMATION: a.

Effort Estimation in various Phase: [Effort

=

Time x

People

=

Man Days]

Effort Estimation in Requirement Phases:

Task

Quantity

Effort Per Item

Total Effort (Man Days)

1

Job requirement meeting

2

1

2

2

Job Analysis

1

1

1

3

Resource Hiring Process

2

1

2 5

Total

Effort Estimation in Planning Phases:

S.No. Task

Quality

Effort Per Item

Total Effort (Man Days)

1

Effort Estimation

1

2

2

2

Cost Estimation

1

1

1

3

TimeEstimation

2

1

2

4

Scheduling

1

1

1

5

Resource Allocation

1

1

1

6

Risk Analysis

1

1

1

Total

8

Effort Estimation in Project Management Phases: S.No. Task 1

Project Management

Quantity 1

Effort Per Item

Total Effort (Man Days)

1

1 1

Total

Effort Estimation in Designing Phases: S.No. Task

Quantity

Effort Per Item

Total Effort (Man Days)

1

Entity Relation Diagrams

1

1

2

Dataflow Diagrams

1

0.5

0.5

3

System Flow Charts

1

0.5

0.5 2

Total

1

Effort Estimation in Coding Phases: S.No. Task

Quantity

Effort Per Item

Total Effort (Man Days)

1

Tables and Relationship

1

0.5

0.5

2

Forms

1

0.5

0.5

3

Procedures/Queries

1

0.5

0.5

4

Reports

1

0.5

0.5 2

Total

Effort Estimation in Integration Phases: S.No. Task 1

Integration

Quantity

Effort Per Item

1

1

Total Effort (Man Days) 1 1

Total

Effort Estimation in User Documentation Phases: S.No. Task 1

User Documentation

Quantity

Effort Per Item

1

1

Total Effort (Man Days) 1 1

Total

Effort Estimation in Quality Assurance Phases: S.No. Task 1

Quality Assurance

Quantity

Effort Per Item

1

1

Total

Effort Estimation

Total Effort (Man Days) 1 1

Grand Total= 21 man days

TIME ESTIMATION Time Estimation = Efforts / People S.No.

Phase

People

Effort Time (Man days) (Working Days)

1

Requirement

2

5

2.5

2

Project Planning

2

8

4

3

Project Management

1

1

1

4

Designing

1

3

3

5

Coading

1

2

2

6

Intigration

1

1

1

7

User Documentation

1

1

1

1

1

1

8

Quality Assurance

Total

15.5

COST ESTIMATION: Cost = = =

Effort Estimation x 21 Man days x Rs. 210,000

Company Rate Rs. 10,000 Per Man days

SCHEDULING:

2.

Phase

Days

Start Date

End Date

Person

PreRequisite

1 1 2

01/01/08 02/01/08 03/01/08

01/01/08 Gull, 03/01/08 Saira 05/01/08

None

2

05/01/08

After 2 days

1 1 2

08/01/08 09/01/08 10/01/08

07/01/08 (Gull Saira) 08/01/08 (Gull, 09/01/08 Siara) 11/01/08 (Saira)

Project Management:

1

11/01/08

11/01/08 Saira

After 3 days

Designing:

2

12/01/08

After 3 days

Coding:

2

15/01/08

14/01/08 Ahsan. Samra 16/01/08 Samra

Integration:

1

17/01/08

17/01/08 Saira

After 1 day

User Documents:

1

18/01/08

18/01/08 Ahsen

-

Quality Assurance:

2

19/01/08

21/01/08 Usman

After 2 days

Requirement: –

– –

Meeting Meeting for Job Analysis Meeting Call for job Resource

Project Planning: –

– –

Study of organizational environment Determine organization’s Job Analysis Call for Resource process

After 5 days

RESOURCE ALLOCATION:

1. a)

Hardware/ Software Resource Allocation:

Item

Quantity

Allocated to person

Colored Laser Printer

1

HR Manager

Overhead Projector

1

Scanner

1

Mounted in Conference Room Assistant HR/Admin

Project Design Tool

1

IT Executive

b) Human Resource Allocation: Person

Skills

Gull, Saira

Analyst

Task Allocated

Samra, Ahsan

Developer

Analyze the Human Resource requirements of the company. Program coding

Usman

QA Expert

Quality Assurance

RISK ANALYSIS:

1.

The Risk Table for the project is shown below: S.No.

Risk

1.

Staff turnaround will be high

2.

Delivery deadline will be tightened Technology will unable to meet expectations

3.

Probability (% age) 35

Impact 2

15

3

30

1

Impact values:

1- Marginal 2- Substantial 3- Critical

PROJECT MANAGEMENT PHASE

Personnel working on the project= 5 People Man days required for project: 21 man days 1 year ___________ 52 weeks 1 day ____________8 hours 1 month__________ 30 days Public Holidays _____ 18 per year Working days _______ 5 days per week Weekly Holidays_____ 2 days per week 21/5= 4.2 Days 30-1.5-9= 20 days per month 4.2/20= 0.21 Month required to complete the Project

DESIGNING PHASE Data Flow Diagrams: Employee’s Induction Process: Receiving of Credentials & Issuance of Appointment Letter & Contract sign Employee Induction

Department Head

HR & Admin Department

Finance & Accounts Department

IT Department

Employee Record

Employment Status& Designation

Role Issue Access Control Card

Addition of Insurances (Medical, Group, Salary)

Base Office and Seating Area

Introduction via email & in person

- Setup Email & Login accounts, - Enable Access Control Card,

Computer Type & Suggested Email ID Issue Computer and other assets like stationery, furniture etc

- Bank Account Detail - Add in Payroll

Employee’s De-Induction Process:

Issuance of Experience Certificate and Final Pay Cheque

Employee DeInduction Department Head

HR & Admin Department

IT Department

Finance & Accounts Department

Employee Record

Type of Termination

Receive Company/ Project Documentation (if any)

Delete from Payroll Receive and Disable Access Control Card

Delete or Disable Email Account Cancellation of Insurances (Medical, Group, Salary)

Handling over/ Taking over job Specific Information Exit Interview

Receive Computer and other assets

Arrange Farewell

Clearance of Advances

Delete or Disable Login accounts

Issuance of Final Cheque

Entity Relation Diagrams EmployeeBasicInfo

Central Inventory

Employee Induction Info

PK EmployeeID

PK,FK1 EmployeeID

First Name Last Name Date Of Birth Marital Status Address City Phone No Mobile No Personal Email ID CNIC Passport No NTN Blood Group Emergency Contact

PK

PK

StatusID

PK

IssueID

FK1

Title Assigned to Opend by Opened Date Status Category Priority Description Close Date Comments DepartmentID

FK1

Item Description Asset Category Condition Date of Purchase Purchase Price Vendor Manufacturer Make & Model Seriel No Issued to Issue Date Return Date Comments EmployeeID

DepartmentID

Description FK1 EmployeeID

Expense Category PK

Description FK1 EmployeeID

Product Issue

AssetID

Date of Joining Date of Leaving Department Employee Status Designation Base Office Role Reporting Comuter type Desired Email ID

Department

Employee Status

PK

CategoryID

Cost Center Description Income or Expense Taxable FK1 ExpenseID

Expense PK ExpenseID Expense Date Description Category Approval

Vendor PK

VendorID

FK1

Company Name Contact Person Contact No Fax No Address CostCenterID

Cost Center PK

CostCenterID

Description FK1 ExpenseID Customer PK

CustomerID

Customer Name Contact Person Contact No. Fax No Address FK1 CostCenterID

CODING PHASE

Emergency Contact Query: SELECT Employees.[Employee Name], Employees.[Blood Group], Employees. [Mobile No], Employees.[Ph No], Employees.[Emergency Contact] FROM Employees; Employee Address Book Query: SELECT Employees.[Employee Name], Employees.Address, Employees.City, Employees.[Ph No], Employees.[Mobile No], Employees.[Personal Email] FROM Employees ORDER BY (Employees.[Employee Name]); Total Salary Query: SELECT Employees.EmployeeID, Employees.[Employee Name], Salary.[Gross Salary], Salary.[Copmetance Adder], Salary.[Medical Reimbursement], Salary. [Travel Reimbursement], Salary.[Other Reimbursements], Salary.[Income Tax], Salary.EOBI, [Bank Detail].[Bank Detail], [Salary]![Gross Salary]+[Salary]! [Copmetance Adder]+[Salary]![Medical Reimbursement]+[Salary]![Travel Reimbursement]-([Salary]![Other Reimbursements]+[Salary]![Income Tax]+[Salary]! [EOBI]+[Salary]![Other Deductions]) AS [Total Salary] FROM (Employees LEFT JOIN [Bank Detail] ON Employees.EmployeeID = [Bank Detail].EmployeeID) LEFT JOIN Salary ON Employees.EmployeeID = Salary.EmployeeID; Asset Category Query: SELECT [Central Inventory].AssetID, [Central Inventory].Item, [Central Inventory].Description, [Central Inventory].[Asset Category], [Central Inventory].Condition, [Central Inventory].[Purchase Date], [Central Inventory]. [Purchase Price], [Central Inventory].[Vendor Name], [Central Inventory].Manufacturer, [Central Inventory].[Make and Model], [Central Inventory]. [Seriol No], [Central Inventory].[Issued to], [Central Inventory].[Issuance Date], [Central Inventory].[Returned Date], [Central Inventory].Comments FROM [Central Inventory];