Arvind Kumar

Preparing Various Reports and coordination with recruiter for Hiring:

a) Managing the BU requirements of Hiring- Demand, Offer, joined and dropped candidates for PAN India.

b) Operated and maintained applicant tracking and candidate management using

spreadsheets, liaising with the larger team to maintain alignment on process

flow during planned events

c) Gender Diversity Ratio.

d) Refer-Back Analysis on ORC.

e) Onboarding plan for campus hires.

f) Partner with internal and external clients and take lead responsibility for aggregating monthly management information (MI) reports

g) Supports HRIS data quality and integrity by auditing and analyzing current data, data flows, as well as making suggestions for future improvements

h) Queries or extracts data from the HR repository, modifies and calculates data in Excel

i) MIS of candidate movement tracker from screening to joining.

j) Coordination with placement cell of colleges for Campus hiring.

k) Database of colleges for across the country.

l) Managing Campus Drive data.

m) 5+ years hands on experience in HRIS reporting and analytics within a large organization, with a strong preference for PeopleSoft expertise

n) Managing campus recruitment process from PPT to Drive day.

Preparing Reports on Hiring: Key Attributes:

a. Business Unit wise Joining’s. (Using pivot for crafting the report).

b. Mid-week Joining’s (Using day formula to bring out the Day).

c. Gender Ratio of new joiner’s (Using pivotand represent it into pie chart).

d. Location wise joining (Using pivot for crafting the report and present it to Bar chart).

e. Marital Status (Using pivot to crafting the report and present it to pie chart).

f. Grade Level Joiner’s (Using pivot for crafting the report and present it to Bar Chart).

g. Age Group Report. (Using datedif formula to bring out the age of new joiner and present it to Bar Chart).

h. Shift User Report. (Using pivot to create the report and arranging the cab for night Users).

i. Appointment Letter Report. (Fetching raw report from portal “Right Signature” and make sure every employee signed the AL within 7 working days.

j. Maintaining daily conciliation report, opening and closing headcount of ELI and sharing the Active employees list to payroll team.

k. Incentive calculation of Recruiter. (Using date formula to bring out the TATof closing the position and preparing the incentive reports.

l. Maintaining the open position tracker and sharing the updates to respective stakeholders on their respective open positions.

m. Comparison and analysis on positions and dropouts. (Using Pivot to see the maximum reason of dropped out candidates).

Preparing Reports on Attrition: key Attributes:

a. Calculation of Attrition Using opening, closing, joining and exit counts of employees.

b. Generating the report on BU Wise. (Using pivottable for crafting the report).

c. Reason of Attrition. (Using pivot table to bring out the maximum reason of exit).

d. Tenure Wise Attrition (using date formula to bring out the tenure of employee and crafting the report on tenure wise exits).

e. Function wise attrition. (Using pivot table for crafting the report and presents the maximum function of employees are exiting).

HR Operations: Key Attributes:

a. Onboarding:

i. Download the report from our internal software wherein recruiter feeds the data of new joiner.

ii. Coordinating with IT team for id creation and asset preparation of every new joiner.

iii. Sharing the schedule for induction with new joiner as welcome mail.

iv. Make sure they fill all statuary forms and submit all the documents.

v. Arranging the HR, Admin, Payroll and employee benefits session for every new joiner.

vi. Circulating new joiner details to all support departments.

b. Sharing payroll report- salary annexures, BU Head approval, onboarding tracker and Mediclaim/ESI tracker with payroll team for further process.

c. Implemented new HRMS i.e. Data migration, testing, training.

d. Completing BGV done for every new joiner with third party.

e. Maintaining website and Intranet of ELI.

f. Onboarding survey and analysis.

g. Vendor Management- taking care of contract of freelancers and vendors.

h. Taking care of FNF of exit employees and providing them exp/relv letter.

i. Employee Personal file and Vendor Management (Related for personnel file documentation).