Advanced HR Generalist & Analytics Training With Advanced Excel & SAP HCM- 100% Practical Training with Interview Guarantee

ASIAWEBMEDIA MANAGEMENT

Course Duration: 110 -120 Hours with 5 - 6 Trainers for 8 Modules

Advanced HR Generalist Practical Training Delivery Method:

Web / Desktop Base

Instructor-Led Classroom Sessions,

Presentations/Demonstration/Practicals of concepts.

Handouts/Assignments/Workshop Exposure

NOTE: Classes are Also Available on Module Basis

Module 1 - Statutory & Legal Compliance

1. EPF & Miscellaneous Provisions Act, 1952

Objectives

Applicability

Eligibility

Rate of Contribution / Share

Registration / Coverage

Registers & Records

Various Returns

Various Forms

Pension Eligibility & Calculation

EDLI Calculation & Limit

Online Activities

2. ESI Act, -1948

Objectives

Applicability

Eligibility

Rate of Contribution / Share

Registration / Coverage

Registers & Records

Various Returns

Various Forms

ESI Benefits

Contribution Period & Benefit Period

Online Activities

 3. Payment of Bonus Act, 1965

Objectives

Applicability

Eligibility

Calculation of Minimum Bonus

Calculation of Maximum Bonus

Registers & Records

Return

Displays

 4. Payment of Gratuity Act, 1972

Objectives

Applicability

Eligibility

Calculation of Gratuity

Maximum Gratuity & Taxability

Group Gratuity Policy

Various Forms

Display

Module 2 - Compensation And Benefits

1. PAYROLL PROCESSING

The Pay Structure

Basic, HRA, DA, Conveyance, Medical allowance, 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)

Module 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

Topics Covered

Introduction, Basic Understanding , Sum, Count, Count, Count blank, Average, Max, Large Min, Abs, Sumif, Count if, Lower, Upper, Proper, Trim, Len, Left, Right, Mid, Concatenate, Subtotal, And, Or, Day, Year, EOmonth, Edate, Net Workdays, Today, Weekday, Week number, Workday, Find, Search.

V-lookup, H-lookup, Day and Time Calculation, Numeric Calculation, If Logical Condition, Dynamic Pivot, Dynamic Chart, Conditional Formatting, Dated if, What If Analysis, Match Index,  Offset Function, User form  Function in Excel,  Data Validation, Advance Filter, Sorting, Group & Ungroup, Data split, Text Function (Data Separation), Substitute

Module 3 - Corporate IR / Labour Law Compliances

1. DISCIPLINARY ACTION/TERMINATION/MISCONDUCT

What's Disciplinary Action?

Definition of Misconduct/Violation of Code of Conduct.

Preparations of Show Cause Notice/Charge Sheet.

Domestic Inquiry

Termination

2. CONTRACT LABOUR (REGULATION AND ABOLITION) ACT1970

Objective

Applicability

Registration & License

Returns(Report)

Facilities

Registers and Records

Displays

3. SHWW Act, 2013 (New Topic Added)

Sexual Harassment Policy

Internal Complaints Committee

4. TRADE UNION

Definition

Condition/Clause

Function

Benefits and Drawbacks

5. SHOPS & ESTABLISHMENT Act,

Objective

Applicability

Registration

Conditions of Work

Registers to be maintained

Displays(Notice)

6. FACTORY Act, 1948

Objectives

Applicability

Licensing Procedure

Employment Conditions

Facilities

Committees

Statutory Appointments 

Registers & Records

Various Returns

Various Forms

Displays

6. INDUSTRIAL DISPUTES Act, 1947 (New Topic Added)

Purpose

Scope

Forms and Formats

Regulatory Body

Employer’s Obligation

Keywords used

6. MINIMUM WAGES Act,

Objective

Applicability

Notification

Provisions

Registers to be maintained

Returns

Display(Notice)

6. APPRENTICESHIP Act,  1961 (New Topic Added)

Objective

Contract of Apprenticeship

Termination of Apprenticeship Contract

Obligation of Employers Toward an Apprentices

Obligation of Apprentices

Payment to Apprentices

Health, Safety and Welfare of Apprentices

Rules and Guideline

Module 4 - Performance Management System (Advanced Topic Added)

Design a PMS System

Goal Cascading

Mapping the KRAs and KPIs

Link Reward System to Achievement of KRAs

Timelines Quarterly & Mid-Year Reviews

Performance Counseling Techniques

Reward & Recognition System.

Performance Report & Dashboard

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

Build Core and Functional Competency Frameworks

Learning Need Analysis/ Module Design/ Budgeting / Calendar          

Assessment Processes & Feedback Analysis

ROI Measurement

Organizational Diagnosis/Assessment

Module 5

     a.  Policies (New Topic Added)

Why Policies, Steps to Frame HR Policy?

Attendance Policy

Leave policy

LTA & Reimbursement Policy

Code of Ethics & Business Conduct

Email, Internet & Computer use Policy

Confidentiality & Non-Disclosure Policy

Effective Retention Policies

    b.  Employee Relationship Management

Joining Formalities and Relieving Procedure

Exit Interviews

Employee Engagement

Grievances

Module 5.1 - HR -Business Partner (Advanced Topic Added)

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

Design SOP.

Module 6 - Recruitment & Selections

End-to-End Recruitment Process & Head Hunting.

Hands on Experience on Job Portals i.e., Naukri / Monster with Sourcing Methodologies.

Boolean Search, Industry Mapping

Screening, Short-Listing of Resume.

Interview Checklist (Primary  & Secondary)

Module 7 - Workshop on Interview Skills (New Topic Added)

Topics to be Covered:

Myths & Reality

Building Right Attitude for Interview

Skills Required for Interview and How to Demonstrate Those Skills

Techniques to Improve Interview Performance

How to Prepare Yourself for Interview

Communication During Interview (Verbal/Non Verbal)

Importance of Physiology & Nonverbal Cues in Interview

5 Stages of Interview and Giving Your Best at Each Stage

Commonly Ask Interview Questions and Their Answers

Resume Writing

Module 8 - SAP HCM (End User)

Organizational Management

Personnel Administration

E-Recruitment

Time Management

Payroll

ESS and MSS

Reporting

(Please mention NCRJobs.in for reference)

Location : New Delhi

Address : Metro Station, Gate No. 2 Saket