Summary
Overview
Work History
Education
Skills
Languages
Personal Information
Timeline
Generic

SANDEEP KUMAR

Gurgaon

Summary

Dynamic HR professional with extensive experience at Cheil India Pvt. Ltd., specializing in HR analytics and vendor management. Proven track record in creating impactful dashboards using Power BI and Tableau, enhancing reporting efficiency. Adept at data analysis and fostering collaboration across teams to drive strategic HR initiatives.

Overview

11
11
years of professional experience

Work History

Sr. HR Analyst

Cheil India Pvt. Ltd
11.2021 - 12.2024
  • Company Overview: Samsung
  • Managed HR day to day activities (Joining formalities, HR Inductions, HR Reporting, Attendance management & Payroll management).
  • Create and managed new / exiting HR related reports and regularly update the HR dashboard for live data tracking and for ready to use report. Dashboard - Live HR dashboard, Attrition Dashboard, TA Dashboard, C&B Dashboard.
  • Manage on roll employee attendance on daily basis, check and maintain their leaves approvals and other approvals. Share weekly attendance with employee for cross check and update the vendor as per employee request.
  • Working with 3rd party vendors and agencies to manage on roll and off roll employee’s monthly payroll. Share the monthly basis report to senior management and Audit the final salaries with vendor and agencies on regular basis to minimize the errors.
  • Manage and create the yearly HR budgeting with different stakeholders and discussed with senior management after completion. Next year budget includes – Employee salaries (Including complacencies cost), Admin cost, off roll salaries (Including agencies fees and their complacencies fees), Employee benefits, Employee welfare and company yearly events.
  • Create monthly basis HR data analysis report and convert the data KPI’s in business strategies as per business requirements. Share HR reports & KPI’s deck with senior management on monthly basis.
  • Partially working with PMS team and management to understand and implement the yearly increment cycle and manage incentives / bonuses of the employees.
  • Regularly working with different teams on projects and discussion to understand the business problems and help them with data analysis and presentation. Regularly manage the audits with different stakeholders. Share and present the monthly presentation in HOD’s meetings.
  • Samsung

Human Resources Senior Analyst

Getronics India Pvt. Ltd.
Gurgaon
05.2020 - 09.2021
  • Managed HR database on SAP HRIS system (New joiners, Employee transfers and Employee exits).
  • Creation of HR Dashboard on Tableau, Power BI and Excel (HR Headcount dashboard, Talent acquisition dashboard – Open position, Interview and closed position, Employee exit dashboard.
  • Creation of HR report as per business and management requirement on weekly and monthly basis to ready to use reports and Understand business requirement – for create ad-hoc reports, Cost per hire and employee benefits and compensation report.
  • Creation of HR portal training to HR leads as per their requirements (SAP Training, Power BI training, Tableau).
  • Audit all salary sheet received from different countries (30 Countries). Check all salary changes and employee cycle changes. Share monthly report to HR COO and analysis of salary data.
  • Help to do employee manpower planning with different data analysis and previous trends with different festival data analysis.

Human Resources Senior Analyst

Gates India Pvt. Ltd.
Gurgaon
04.2019 - 05.2020
  • Handing the payroll for India employees. Submit the attendance to the vendor and audit the payroll sheet every month.
  • Help to create the training material for India employees and create/assign the new trainings in the system (LMS) for complete organization. Share the deep analytical feedback after completion of training.
  • Handing the Incentive / Bonus for India employees on monthly and yearly basis (As per pay out timelines). Share the accruals amount for bonus/ incentive to the teams.
  • Create the new Dashboards and handing the existing dashboards for HR team and make the changes as per the higher management requirements. Share the weekly/Monthly HR reports to management with deep analysis.
  • Handing the vendor management for India (Payments, Billings, Company events, Inventory management, Travelling, Pantry).
  • Having experience with HR generalist & Admin profile (Joining formalities, Documentation, off roll bulk hiring, Employee database, HRIS process, Attendance management, HR Dashboard, BGV, Employee code generation, Manager mapping, Database audits, Organization structured, Payroll attendance sheet, Vendor management, Administrative, Inventory management, Pantry).
  • Created Automated F&F format for help smoothed and faster way to process the day to day F&F activities. Also created TA tracker to track day wise open position and closed position and Admin tracker for monthly budgets.

Senior HR Executive

Delhivery Pvt. Ltd.
Gurgaon
06.2015 - 08.2018
  • Manage over 40000 employee’s database and all the related reports.
  • LOP’s Summary, Man-day’s summary, Region wise attendance Summary.
  • Mention HR Dashboard on Power BI, Google data studio, Advance Excel, Tableau, Google Spreadsheets.
  • Based on manpower cost and other expenses, calculation of cost per shipment.
  • Implement the incentive plan based on performance and reduce the overall costing.
  • Comparison of the total manpower cost with total revenue with different companies’ data.
  • Number of Shipments delivery on daily basis with live updates.
  • Having experience with HR generalist profile (Joining formalities, Documentation, Off roll bulk hiring, Employee database, HRIS process, Attendance management, HR Dashboard, BGV, Employee code generation, Manager mapping, Database audits, Organization structured, Payroll attendance sheet).

MIS Executive

DTDC COURIER & CARGO LTD
Delhi
06.2014 - 06.2015
  • Maintain all the reports as per management requirement in Advance excel.
  • Daily con call with regional managers and AGM and taking care of all the MIS Data.
  • Handling all the MIS related reports in excel & PPT, share with senior management on weekly and monthly review.
  • Working with different teams for collection of data and results related issues.

Education

Master of Business Administration (MBA) - Human resource and Operations

SIKKIM MANIPAL UNIVERSITY
07.2025

B.COM -

University of Delhi
01.2012

Skills

  • Manpower planning & Reporting Analyst
  • Vendor management
  • Power BI & Tableau Dashboard
  • Time office management
  • Exit formalities
  • HR Analytics and MIS Reports
  • F&F Automation
  • Salary & Payroll calculations
  • SAP Training module
  • HRIS Management
  • HR Oracle
  • HR SAP
  • Case-cade
  • Database management (HRIS)
  • Data Analysis & Management reports
  • Biometric Portal
  • Joining /Induction
  • Reporting automation
  • Employee trainings

Languages

  • English
  • Hindi

Personal Information

Date of Birth: 06/25/92

Timeline

Sr. HR Analyst

Cheil India Pvt. Ltd
11.2021 - 12.2024

Human Resources Senior Analyst

Getronics India Pvt. Ltd.
05.2020 - 09.2021

Human Resources Senior Analyst

Gates India Pvt. Ltd.
04.2019 - 05.2020

Senior HR Executive

Delhivery Pvt. Ltd.
06.2015 - 08.2018

MIS Executive

DTDC COURIER & CARGO LTD
06.2014 - 06.2015

Master of Business Administration (MBA) - Human resource and Operations

SIKKIM MANIPAL UNIVERSITY

B.COM -

University of Delhi

Similar Profiles

CREATE PROFILE
SANDEEP KUMAR