HR Generalist

Module 1 - Statutory and Legal Compliances

a. Employees’ Provident Fund (EPF)

EPF, VPF, RPF, etc.

Computation of Monthly PF Contribution

Computation of Interest & Penalty

Computation of Monthly Pension

Computation of EDLI Amount

Penalty & Interest

Practical Session (Workshop)

Online Registration of Establishment

Online Generation of UAN

Online Submission of KYC

Online ECR Generation

Online Bulk Exit

Online SharmSuvidha Portal

PF Report in Excel Sheet

Registers and Records

Various Forms (EE and ER), Display & Return

Payment of Bonus

Calculation of Bonus

Calculation of Available, Allocable Surplus

Computation of Set-on & Set-off

Penalty

Practical Session (Workshop)

Various Forms

Bonus Calculation Sheet

Bonus Payment Registers & Records

Annual Return

Display

b. Employees’ State Insurance (ESI)

Computation of Monthly ESI Contribution

Computation of Interest & Penalty

ESI Benefits (Medical, Maternity, Funeral etc.)

Contribution Period & Benefit Period

Penalty & Interest

Practical Session (Workshop)

Online Registration of Establishment

Registration of Branch/ Sub-Code

Online Generation of TIC/E-Pehchan/IP

Online IP Mapping with Aadhaar

Online Challan Generation

Online SharmSuvidha Portal

Accident Register and Records

ESI Report In Excel Sheet

Registers and Records

Various Forms (EE and ER), Display & Return

d.Payment of Gratuity

Calculation of Gratuity

Maximum Gratuity & Taxability

Group Gratuity Policy

Practical Session

Various Nomination Forms

Gratuity Claim Form

Display

Module 2 - Compensation And Benefits

1. PAYROLL PROCESSING

The Pay Structure

Basic, HRA, DA, Conveyance, Medical Allowance, OT, LTA, Lunch Allowance etc.

Salary Break up and Designing CTC.

Calculation of Gross , Net Salary & CTC

Calculation of Overtime & Leave Encashment.

Discussion on Compensation and Benefits.

Attendance & Leave Management (CL, EL, SL, and ML)

Preparation of Salary Sheet, Pay Slip, Full n Final Settlement.

PF Report in Excel sheet

ESI Report in Excel sheet

Professional Report Tax

Live Payroll Software Training (New Topic Added)

2. TAX PLANNING FOR SALARIED EMP.

LWF Slab Rate

PT Slab Rate

Income Tax Slab Rate

Tax Exemptions of Various Allowances.

Tax Deduction under Chapter VI-A

(80C, 80D, 80E, 80G, etc.)

Rebate U/S 87A

Education Cess

Routine Tax Planning (Investment Declaration Form)

TDS Certificate (Form 16)

2.1 – MS Excel- Lab Session

Objective: Provide Basic Understanding of Excel, Make user Familiar to Create Formula and give Platform to Make Good Analysis and Introduce Powerful Tools of Advanced Excel so that user can Make Advanced Analysis with the help of Those Tools. Introduction to Excel

Basic Understanding Menu and Toolbar, Introduction to different category of functions like Basics, Mathematical and Statistical, Date and Time, Logical, Lookup and References, Text and Information.

Mathematical Functions

Sum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs, Subtotal,

Aggregate, Rand, Randbetween, Roundup, Rounddown, Round, Sumproduct

Date & Time Function

Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time

Text Functions & Data Validation

Char, Clean, Code, Concatenate, Find, Search, Substitute, Replace, Len, Right, Left, Mid, Lower, Upper, Proper, Text, Trim, Value, Large, Small Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/ Font Color), Conditional Formatting, Data Validation, Group & Ungroup, Data split.

Statistical Function & Other Functions

Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext, Max, Min, Len, Right, Left, Mid, ,Maxa, Maxifs, Median, Minifs, Mina, Vara, Correl, Geomen

Logical Functions

And, Or, If, Iferror, Not, Nested If

Lookup & Reference Functions

VLookup, HLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup Formula’s, Past Special, Past link

Power Pivot- MIS, Data Analysis & Visualization

Pivot Table, Power Pivot, What-if Analysis, Data Table –One Variable and Two Variables, Data Analysis Using Statistics, Descriptive Statistics, ANOVA, Moving Average, Testing Hypothesis, Measuring Covariance and Correlation, Distribution, Regression, Graphs & Charts, Analysis Tool Pack, Solver, Histogram, Pareto, Water Fall, Import and Export data, Protect/Unprotect sheets/workbooks, Worksheet formatting and Print Display

Data Collection Method

With Data Quality, Collaboration & Security Like Share Your Workbook On Share Drive With Quality

Analysis Single/Multidimensional Analysis

Like Three Dimensional (3D) Tables, Sensitive Analysis Like Data Table, Manual What-If Analysis, Threshold Values, Goal Seek, One-Variable Data Table, Two-Variable Data Table

Advanced Dashboard in Excel

Overview of Chart types, Chart Formatting, Active X Form Controls, Principle of great dashboard design, Selecting Correct Chart to display data, Interactive Charts with Form Controls, Combo box, Check Box, Scroll Bar and Radio Button, Interactive Dashboard with Form Controls, Form Controls for reports automation, Data Models using Power Pivot

Module 3 - Corporate IR / Labour Law Compliances

3.1 (a). DISCIPLINARY ACTION/TERMINATION/MISCONDUCT

What’s Disciplinary Action?

Definition of Misconduct/Violation of Code of Conduct.

WORKSHOP SESSION

Preparations of Show Cause Notice/Charge Sheet.

Domestic Inquiry

Termination

3.1 (c). SHWW Act, 2013 (New Topic Added)

What is Sexual Harassment

What is the workplace

WORKSHOP SESSION

Sexual Harassment Policy

Internal Complaints Committee (ICC)

Local Complaints Committee (LCC)

Penalty

3.1 (e). FACTORY Act, 1948

Objectives

Applicability

WORKSHOP SESSION

Registration and Licensing Procedure

Annual Leave with wage

Facilities

Annual & half Yearly Return

Safety-related Provision

Registers & Records

Various Returns

Registers and Records

3.1 (g). TRADE UNION

Definition

Condition/Clause

Function

Benefits and Drawbacks

3.1 (i). MINIMUM WAGES Act

Objective

Applicability

Notification

WORKSHOP SESSION

Registers to be maintained

Returns

Display(Notice)

Module 3.2 – Fully Practical Legal Calculations Class (Advanced Topic Added)

Design a PMS System

Calculation of Full and final settlement

Calculations of a Notice period

Calculations of LTA

Calculations of Medical Reimbursement

Calculations of Man days for required of all returns like factory and contractor returns etc.

Calculations of Attrition and issue &Control

Calculations of absenteeism

Calculations of suspension allowance

Calculation of Overtime with new rule

How to Draft the charge sheet in English for staff

How to Draft the Charge Sheet In Hindi for worker

3.1 (b). CONTRACT LABOUR (REGULATION AND ABOLITION) ACT 1970

Objective

Applicability

WORKSHOP SESSION

Registration & License

Returns(Report)

Facilities

Registers and Records

Displays

3.1 (d). SHOPS & ESTABLISHMENT Act,

Objective

Applicability

WORKSHOP SESSION

Registration

Conditions of Work

Registers to be maintained

Displays(Notice)

3.1 (f). BOWC (Building & Other Constructions Workers) Act, 1996

Objective

Applicability

Eligibility conditions

The responsibility of the Employer;

WORKSHOP SESSION

The responsibility of the Employer;

Registration Procedure

Registers, Records, and Returns;

A grievance by an employee;

The penalty for contravention of the Act

3.1 (h). INDUSTRIAL DISPUTES Act, 1947 (New Topic Added)

Purpose

Scope

Forms and Formats

Regulatory Body

Employer’s Obligation

Keywords used

3.1 (j). APPRENTICESHIP Act, 1961 (New Topic Added)

Objective

Contract of Apprenticeship

Termination of Apprenticeship Contract

WORKSHOP SESSION

Payment to Apprentices

Health, Safety and Welfare of Apprentices

Rules and Guideline

Module 3.3 – How to Get Registration with legal Authority (Advanced Topic Added)

Factory Registration/Licensing with full Procedure

Contractor Registration/Licensing with Full Procedure

Air & water NOC & Consent with Full Procedure

Standing Orders Certification with Full Procedure

Fire NOC with Full Procedure

Module 3.4 – HR Audit

What is HR Audit

Legal Compliance Audit

HR Payroll Audit

HR Policy Audit

How to make the HR Audit Report?

Module 4 - Performance Management System (Advanced Topic Added)

Performance Management System

Design a PMS System

Goal Cascading

Mapping the KRAs and KPIs

Link Reward System to Achievement of KRAs

Performance Counseling Techniques

Reward & Recognition System.

Performance Report & Dashboard

Timelines Quarterly & Mid-Year Reviews

Module 5 - Learning & Organizational Development (Advanced Topic Added)

Learning & Organizational Development

Build Core and Functional Competency Frameworks

Learning Need Analysis/ Module Design/ Budgeting / Calendar

Assessment Processes & Feedback Analysis

ROI Measurement

Organizational Diagnosis/Assessment

Module 6 - HR Policies (New Topic Added)

HR Policies

Why Policies, Steps to Frame HR Policy?

HR Policy Framework/Checklist

Attendance Policy

Leave policy

LTA & Reimbursement Policy

Code of Ethics & Business Conduct

Email, Internet & Computer use Policy

Confidentiality & Non-Disclosure Policy

Effective Retention Policies

Module 7– HR -Business Partner (Advanced TopicAdded)

HR -Business Partner

Contributions of HR from Business Perspective?

Review & Analyze Business Unit Data

Employee Budgeting and Man Power Planning

Workforce Planning, Succession Planning, Career

Architecture Program and Skills Assessment

Attrition Issues & Control

Module 8 - Employee Relationship Management Workshop Session

Employee Relationship Management Workshop Session

Joining Formalities and Relieving Procedure

Exit Interviews

Employee Engagement

Communication Downward, Upward, Horizontal

Gamification and Modern age engagement activity

BE open to coach and mentor

BE Open to new Idea and Initiative

Human Resource Round Table

Practical Role Play for Employee Relationship Building

Grievances

Module 9 - Recruitment & Selections

Recruitment & Selections

End-to-End Recruitment Process

Job Analysis, Job Advertisement

Industry Mapping

Head Hunting & Blind Recruitment

Profile Sourcing – Hands on Experience on Job Portals i.e., Naukri | Monster | Timesjob | LinkedIn

Sourcing Methodologies – Boolean Search, Keyword Search

Screening, Short-Listing of Resume.

Module 10- Interview

Interview

Interview Handling

Skills Landing Interview Technique

Mock Interview

Win-Win Situation