MBA final Year Projects course Intermediate Level by Spectrum Infogain Services

HR GENERALIST TRAINING PROGRAM
WE IMPART TRAINING IN FOLLOWING MODULES:-
1. LABOUR LAWS & STATUTORY COMPLIANCES
2. PAYROLL MANAGEMENT & INCOME TAX
3. HR GENERALIST AREA
4. CORE HR DOMAIN
5. INTERVIEW SESSION
6. RECRUITMENT & SELECTION
7. DESKTOP DATA SECURITY
8. ADVANCE EXCEL PRACTICAL SESSION
1. LABOUR LAW & STATUTORY COMPLIANCES
ESI ACT-1948
ESI-Act
Eligibility
Contributions From Both Employee & Employer
Filing (Monthly & Half Yearly)
Calculations
Filling The Forms
Benefits
PF ACT-1952
PF-Act
Eligibility
Contributions From Both Employee & Employer
Filing (Monthly & Yearly)
Filling The Forms
Calculations
Benefits
GRATUITY ACT-1972
Benefits
Form Filling
Coverage & Eligibility
Calculations
Tax Exemptions Limit
BONUS ACT-1965
Coverage & Eligibility
Calculation
Bonus Limit
FACTORY ACT
Factory Act Provision
Procedure
Registration & License
Forms
CONTRACT LABOUR ACT
Introduction
Applicability
Registration& Licensing
Wage considerations
Whole Procedure
SHOPS & ESTABLISHMENT ACT.
Applicability & Coverage
Returns
Registers
INDUSTRIAL DISPUTES ACT, 1947
PRELIMINARY
NOTICE OF CHANGE
AUTHORITIES UNDER THIS ACT
EQUAL REMUNERATION ACT, 1976
What is the scope & coverage of this Act?
Are there any exceptions?
What is meant by remuneration?
What is meant by same work or work of a similar nature
TRADE UNIONS ACT, 1926
APPLICABILITY
TRADE UNIONS
How do we Register a Trade Union
What is the Proof of Registration of a Trade Union
COMPANIES ACT
Definitions
Definitions of "Company", "Existing Company", "Private Company" and "Public Company"
Meaning of "holding company" and "subsidiary"
Meaning of "relative"
MATERNITY BENEFIT ACT
Introduction
Eligibility
Benefits
Documentations
PAYMENT OF WAGES ACT
Introduction
Implications
Documentations
MINIMUM WAGES ACT
Introduction
Implications
Documentations
STANDING ORDER ACT
Benefits
Coverage & Eligibility
2. PAYROLL PROCESSING
Leave Procedure:
Defining leaves i.e. CL,PL,EL,DL,etc
Leave Calculation
Leave calculation on pro-rata basis
Leave encasement
Calculation of OT
Maintaining muster rolls
PAY ROLL SOFTWARE MANAGEMENT
Salary breakup : manually as well as in Software
Defining and calculating (Basic, HRA, MA, TA, SA etc)
Designing and Calculating CTC
Defining and calculating Gross and Net salary respectively
Calculating statutory compliances: PF, ESI, Gratuity and Bonus as part of CTC.
Tax Deducted by sources (TDS)
Calculating TDS on the basis of CTC/Salary breakup.
How to exempt tax on the basis of breakup.
Professional tax
Education cess
3. HR GENERALIST AREAS LIST
HR AUDIT POINTS & ISO EXPECTATION FROM HR ORIENTATION ON KEY TERMS
Competency Mapping
Performance Management System
Appraisal Methods
Policy making
SWOT Analysis
HR Balance Score card
HR Dashboard
ISO 9000 & 14000
KAIZEN & 5S
HR ADMIN FUNCTIONS
Personal Files & Service Matters
4. CORE HR DOMAIN LIST
Man power planning
Full and Final Settlement (F & F)
Induction
Training and Development
ER Management
Attrition
Employee calculation
New joining calculation
Effective Retention Policies
Negotiation Skills
Employee Engagement
Grievance Handling
CASE STUDY
DRAFTING LETTERS
Appointment letter
Confirmation letter
Increment letter
Relieving letter
Acceptance letter
Experience letter
5. INTERVIEW S SESSION
Preparing Perfect Resume
Interview Tip
How to Face Interview
Preparing Interview questions
6. RECRUITEMENT & SELECTION
Manpower Requisition form, points to be seen in MRF.
Internal references by sending mail posting it on Job portal (MONSTER.COM,
TIMESJOBS.COM, NAUKRI.COM)
Points to be observed while dealing with HR consultants. How to negotiate with the
candidate.
Points to be observed while closing the position.
Hand holding or Buddy program for a new Joinee.
searching the database/web/jobsites to source out the required resumes /cv
Sell and forward the interested candidate resumes to clients against requirements with the help of
senior recruiter (recruitment team)
Handling three IT, ITES & Non IT recruitment
Making Cold & Head-hunting
Types of Poaching in recruitment.
Coordinate interviews efficiently and make the event happen
IT , ITES , Non IT Recruitment, Man Power Planning , End to End Recruitment Process , Joining
formalities and relieving procedures , Client Management, IT Skills Training to understand the
technical requirements
7. DESKTOP DATA SECURITY
IT Security Basic.
Data Back Up & Recovery.
Art of Googling.
8. MS. EXCEL PRACTICAL SESSIONS
Data Formatting & Custom settings: Number, Text, Date, Currency, Custom settings. Data
formatting & cleaning
Conditional Formatting: Once defined, it will automatically change color of values e.g. up or down, high or low, pass
or fail, profit or loss etc.
Filters, Queries & Data Sorting: Drill down your data to your desired level. Sort data based on your choice e.g. like
North, East, West, South rather than alphabetically.
Formula Writing & Fixing Errors: Financial, Logical, Text, Day and Time, Statistical, Mathematical etc Sum, Average,
Count, Minimum, Maximum, Absolute, Concatenate, Count, CountA, CountBlank, CountIf, Day, Today, Even, Exact,
Exp, Find, Int, IsBlank, Left, Len, Lower, Upper, Proper, Now, Power, Rank, Right, Round, Trim etc.
IF AND Logic: Produce different set of results based on slabs, conditions.
Vlookup / Hlookup : You have large amount of data placed at different locations & you want to merge it based on
common values & its relevance. To compare and search values from destination.
Graphs & Charts: In this workshop you will learn how to create, modify & update graphs / charts like Column, Line,
Pie, Bar, Area, Scatter, 3D etc.
Hyper / Data Linking: Hyper & data linking, within or outside Worksheet / Excel File is an important feature. This
helps update data automatically.
Grouping - Ungrouping: Sometime data needs to be grouped for summarized results & crisp view. Grouping &
ungrouping feature will help you do so.
Pivot Tables: Summarize your data as per your desire. You need to select data in a range & produce consolidated
results in user defined reporting formats.
Developer: To display the Developer tab or run in developer mode when you want ... that you previously recorded, or
create applications to use with Microsoft Office programs
Macros: Macros can help you automate repetitive tasks and save time. You can use the macro recorder to
record the macro
Security & Protection: It will help you protect your cells, worksheet or an excel file from unauthorized use.
Data validation: prevent wrong data entry in your specified format. This will help you design various formats based
on company requirements.
What- if analysis: What-If Analysis that allows you to explore different scenarios without changing the values in your
spreadsheet. This function is particularly useful for economics and management majors as well as business owners
because you can see how different values affect models, formulas, and projected profits.
Goal Seek: Excel s Goal Seek feature allows you to alter data in formulas to get different results. Goal Seek can
be used when planning new projects.
Scenario manager: Scenario Manager enables you to create and save sets of different input values that produce
different calculated results as named scenarios (such as Best Case, Worst Case, and Most Likely Case).
Advance Filter: An Excel Advanced Filter can extract data to a different sheet, filter list in place, extract list of unique
records to eliminate duplicates. Use the The Advanced Filter to use complex criteria to filter a range
Watch Window: When cells are not visible on a worksheet, you can watch those cells and their formulas in the
Watch Window toolbar. The Watch Window makes it convenient to inspect, audit, or confirm formula calculations
and results in large worksheets
View:
Split Pane: Excel s split screen feature lets you to split the screen into multiple panes allowing you to see more
than one copy of worksheet data.
Freeze pane: Excel s freeze panes feature will keep the headings at the top and down the side of the sheet from
disappearing when you scroll from top.