• Listening – Music, Sports-Athletics (Running)& Cycling.
Hi, I’m
Ranjeet Kumar
Payroll Professional
East Delhi,Delhi
Summary
A dynamic and experienced professional with over 15 years of experience in Payroll, HR MIS, Accounts, Time Management, Compensation & Benefits (C&B), Leave Management System, HR Operations and Onboarding. Proven ability to manage people effectively, handle employee grievances, and maintain healthy employee relations. Expertise in administering and coordinating payroll. Excellent data reporting skills, with experience in managing large data sets, Advanced Excel, VBA (Macro), Google Sheets, Word, and PowerPoint. Hands-on experience with ERP, Tally, and CMS.
Overview
17
years of professional experience
6
years of post-secondary education
2
Languages
Work History
CHEIL INDIA (A SAMSUNG GROUP)Gurugram, Haryana
Assistant Manager-Payroll
May.2022 - Current (2 years & 7 months)
Job overview
- Responsible for end-to-end India Payroll for 30,000 Samsung employees, including processes, procedures, accounting, and audit support, ensuring accurate and consistent payroll while maintaining ownership and accountability.
- Responsible for updating/changing the HRMS system (CPS) according to business requirements, ensuring ownership and accountability.
- Tracking new joiners, resigned employees, and rehired employees through HRMS.
- Work with internal Tech teams for various HRMS (CPS) integrations & Updates.
- Conducted regular audits to verify attendance records, identifying and rectifying discrepancies promptly.
- Prepared and processed monthly payroll reports, ensuring accurate calculation of salaries, deductions, and benefits.
- Preparing full and final settlements, daily, weekly, and monthly attendance reports, leave balances, and LOP reversal data as per RFAs received.
- Conducting training for new sales promoters on leave, attendance, grievance handling, and other HR topics.
- Administration of social security (PF, ESIC & LWF)-Challan generation, enrolment, Exit, Transfer, Withdrawal, etc.
- Maintaining master data for sales promoters/sales representatives.
- Conducting staff surveys and collecting data for preparing HR Reports.
- Prepared MIS reports on HR-related metrics, contributing to management decision-making.
GOLDEN TOBIE
Deputy Manager
Sep.2019 - Apr.2022 (2 years & 7 months)
Job overview
- Processing monthly salaries based on attendance, ensuring accurate payroll, preparing statements for salary, PF, and ESI deductions, TDS, and advances, forwarding them to accounts for payment, meeting payroll deadlines, and ensuring timely salary disbursement.
- Preparing consolidated attendance records employee-wise by the end of each month.
- Creating dashboards and reports using advanced Excel, Google Sheets, VBA automation, and standard reporting features to fulfill business and regulatory requirements.
- Collection and consolidation of inputs from all departments & branches for payroll processing.
- Preparation and maintenance of Payroll Reconciliation, Gap analysis, and Variance report.
- Timely submission of contribution challans and completion of Statutory Compliance like -PF, ESIC, TDS, and Professional Tax.
- Updating employees' personnel files for statutory requirements such as PF, ESI, superannuation, attendance, deductions, and earnings.
- Handling processing of salary-related reimbursements (e.g., Medical, Fuel & Maintenance, Telephone & Internet, Chauffeur, LTA) and processing Meal Vouchers for eligible employees.
- Employee Onboarding, Training & Orientation,
- Processing Full & Final Settlements.
- As the main coordinator, responsible for payroll audit activities by providing auditors with timely and accurate reports in the required formats.
- Preparing monthly additions and deletions for Mediclaim, organizing help desks, and coordinating with employees and TPA for medical cases.
LEMON ELECTRONICS LTDNoida, Uttar Pradesh
Assistant Payroll Manager
Mar.2014 - Aug.2019 (5 years & 5 months)
Job overview
- Responsible for the entire payroll administration.
- Ensuring timely preparation and closure of monthly attendance and
- preparing consolidated employee-wise attendance records by month-end.
- Assuring prompt and satisfactory resolution of payroll-related queries of all employees.
- Creating dashboards and reports using advanced Excel, VBA automation, and standard reporting features to meet business and regulatory needs.
- Preparation and maintenance of Payroll Reconciliation, Gap analysis, and Variance report.
- Timely submission of contribution challans and completion of Statutory Compliance like -PF, and ESIC.
- Processing Full & Final Settlements of all left employees,
LEMON ELECTRONICS LTDNoida, Uttar Pradesh
Assistants Manager-MIS/Accounts
Jun.2009 - Feb.2014 (4 years & 8 months)
Job overview
- Preparation of all types of vouchers (Journal Voucher, Purchase Voucher, Sales Voucher, Payment & Receipt Voucher).
- Billing & Collection entry.
- Preparation Bank Reconciliation and Debtors & Creditors Reconciliation.
- Stock Valuation at the time of Balance Sheet.
- TADA Processing of Employees.
- Creating and maintaining reports in Excel, that allow the company to get information on daily business activities.
- Collate Analyze and Present company performance details quarterly, half-yearly, and yearly.
- Provide information to management and meet weekly to ensure consistency in data and information across the company.
JORJY INTERNATIONAL PVT LTD
Executive
05.2006 - 05.2009
Job overview
- Daily /Weekly/Monthly Sales Report.
- Preparation of all types of vouchers (Journal Vouchers, Purchase Vouchers, Sales Vouchers, Payment & Receipt Vouchers).
- Preparation Bank Reconciliation and Debtors & Creditors Reconciliation.
- Creating MIS/ Dashboard report and presenting it to the concerned Department.
- Bookkeeping.
- Generated reports each month covering Sales data.
Education
Jaipur National University, New Delhi
MBA from Human Resource Management
2016 - 2018 (2 years)
Delhi University, Delhi
Bachelor of Arts from Office Management & Scretarial Practices
2002 - 2005 (3 years)
Y.M.C.A, New Delhi
Diploma from Computer Application
2004 - 2005 (1 year)
Skills
Payroll Processingundefined
Interests
Software
Microsoft Office (Advance Excel, VBA (Macro), Word, PPT)
Google Sheets
Tally, ERP, CMS
Basic MSSQL, Basic Python
Timeline
Assistant Manager-Payroll
CHEIL INDIA (A SAMSUNG GROUP)
May.2022 - Current (2 years & 7 months)
Deputy Manager
GOLDEN TOBIE
Sep.2019 - Apr.2022 (2 years & 7 months)
Jaipur National University
MBA from Human Resource Management
2016 - 2018 (2 years)
Assistant Payroll Manager
LEMON ELECTRONICS LTD
Mar.2014 - Aug.2019 (5 years & 5 months)
Assistants Manager-MIS/Accounts
LEMON ELECTRONICS LTD
Jun.2009 - Feb.2014 (4 years & 8 months)
Executive
JORJY INTERNATIONAL PVT LTD
05.2006 - 05.2009
Y.M.C.A
Diploma from Computer Application
2004 - 2005 (1 year)
Delhi University
Bachelor of Arts from Office Management & Scretarial Practices
2002 - 2005 (3 years)
Similar Profiles
Ranjeet ki KumarRanjeet ki Kumar
Assistant Manager - Payroll at CHEIL INDIA, A SAMSUNG GROUPAssistant Manager - Payroll at CHEIL INDIA, A SAMSUNG GROUP
Hitesh AgarwalHitesh Agarwal
Director - Data Biz at Cheil India Pvt Ltd (Samsung Group)Director - Data Biz at Cheil India Pvt Ltd (Samsung Group)
Rohit SharmaRohit Sharma
Associate Account Director at Cheil India, a part of Samsung IndiaAssociate Account Director at Cheil India, a part of Samsung India