Ranjeet ki Kumar
Payroll Professional
New Delhi,Delhi
Summary
https://bold.pro/my/ranj eet-kumar- 230627082049/525 Skills Payroll Processing Advanced MIS Reporting Upper intermediate Statutory Compliance Upper intermediate Compensation & Benefits Upper intermediate Time office Administration Advanced HR Operation Intermediate Ranjeet Kumar Payroll Professional 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
18
18
years of professional experience
6
6
years of post-secondary education
Work History
Assistant Manager - Payroll
CHEIL INDIA, A SAMSUNG GROUP
05.2022 - Current
- Managed payroll data as well as attendance and leave records for workforce of 30,000 Samsung promoters /
- Sales representatives across pan India in coordination with various vendors
- 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 reversals data as per RFAs received
- Conducting training programs for newly hired sales promoters on leave, attendance, grievance handling, and other HR-related topics
- Manpower Costing
- Upper intermediate
- Software
Deputy Manager
GOLDEN TOBIE
01.2019 - 09.2022
- Maintaining master data for sales promoters/sales representatives
- Conducting staff survey and collecting data for preparing HR Reports
- Prepared MIS reports on HR-related metrics, contributing to management decision- making
- Processing Salary on monthly attendance basis, ensuring error free payroll, Preparation of statements – Salary, deductions of PF and
- ESI, advise same to accounts for payments,
- Meeting deadlines related to payroll processes, ensuring timely disbursement of salaries/wages
- Ensuring timely preparation & closing of monthly attendance
- Preparing consolidated attendance records employee wise by end of each month
- Creation of DASHBOARD/Reports using
- Advance Excel, Google Sheet, VBA
- Automation and standard reporting functionality in response to business and regulatory requirements
- Responsible for providing timely and accurate various reports to management in prescribed format
- Collection and consolidation of inputs from all departments & branches for payroll processing
- Preparation and maintenance of Payroll
- Reconciliation, Gap analysis, Variance report
- Timely submission of contribution challans and completion of Statutory Compliance like -PF, ESIC,
- TDS, Professional Tax
- Updating employees' personnel files for the
- Statutory requirements Like PF, ESI, superannuation, attendance & several sources of deduction and Earnings
- Processing all salary related Reimbursements like Medical, Fuel & Maintenance,
- Telephone & Internet, chauffer & LTA etc,
- Processing Meal Vouchers for all employees having the same in their salary structure
- Employee Onboarding, Training &
- Orientation,
- Processing Full & Final Settlements of all left employees, coordinating with Finance department for timely payout of Full & Final
- Settlements
- Main Coordinator and Responsible for Audit in Payroll related activities by providing timely and accurate various reports to
- Auditors in prescribed formats
- Preparing monthly Inclusion, deletion and addition reports and organizing help desks for Mediclaim policy and co-ordinate with employees as well as TPA for medical cases.
Assistant Manager
LEMON ELECTRONICS LTD
01.2014 - 08.2019
- Responsible for entire payroll administration
- Ensuring timely preparation & closing of monthly attendance
- Preparing consolidated attendance records employee wise by end of each month
- Assuring prompt and satisfactory resolution of payroll related query of all employees
- Creation of DASHBOARD & Reports using
- Advance Excel, VBA Automation and standard reporting functionality in response to business and regulatory requirements
- Collection and consolidation of inputs from all departments & branches for payroll processing
- Preparation and maintenance of Payroll
- Reconciliation, Gap analysis, Variance report
- Timely submission of contribution challans and completion of Statutory Compliance like -PF, ESIC
- Processing all salary related Reimbursements like Medical, Fuel & Maintenance,
- Telephone & Internet, chauffer & LTA etc.,
- Processing Meal Vouchers for all employees having the same in their salary structure,
- Processing Full & Final Settlements of all left employees, coordinating with Finance department for timely payout of Full & Final
- Settlements.
Assistants Manager
Accounts, MIS, LEMON ELECTRONICS LTD
06.2009 - 02.2014
- Preparation all types of voucher like (Journal
- Voucher, Purchase Voucher, Sales Voucher,
- Payment & Receipt Voucher)
- Billing & Collection entry
- Preparation Bank Reconciliation and
- Debtors & Creditors Reconciliation
- Stock Valuation at time of Balance Sheet
- TADA Processing of Employees
- Creating and maintaining reports in Excel, that allows the company to get information on daily business activities
- Preparation of monthly Performance Status
- Reports to Senior Management
- 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 company
- Creating MIS/ Dashboard report and presenting it to concerned Department
- Understand requirements, design formats, deploy formats, follow up with Business development Team, Client Services
- Department, and Quality team and validate data.
MIS Executive
JORJY INTERNATIONAL PVT LTD
, Delhi
01.2006 - 05.2009
- Daily /Weekly/Monthly Sales Report
- Preparation of all types of vouchers like (Journal Voucher, Purchase Voucher, Sales
- Voucher, Payment & Receipt Voucher)
- Preparation Bank Reconciliation and
- Debtors & Creditors Reconciliation
- Creating MIS/ Dashboard report and presenting it to concerned Department
- Bookkeeping
- Generated reports each month covering
- Sales data.
Education
MBA - Human Resources Management
Jaipur National University
New Delhi 2016 - 2018
Bachelor of Arts - Secretarial Studies and Office Administration
Delhi University
New Delhi 2002 - 2005
Diploma - Computer Application
YMCA
New Delhi 2004 - 2005
Skills
- MS OFFICE (Advance Excel,
- VBA (Macro), Word, PPT)
- Advanced
- TALLY, ERP SOFTWARE, CMS
- Upper intermediate
- GOOGLE SHEETS
- Basic MSSQL, Basic Python
- Elementary
- Languages
- English
- Intermediate
- Hindi
Interests
Listening – Music, Sports-Athletics (Running) and
Cycling
Timeline
Assistant Manager - Payroll
CHEIL INDIA, A SAMSUNG GROUP
05.2022 - Current
Deputy Manager
GOLDEN TOBIE
01.2019 - 09.2022
MBA - Human Resources Management
Jaipur National University
2016 - 2018
Assistant Manager
LEMON ELECTRONICS LTD
01.2014 - 08.2019
Assistants Manager
Accounts, MIS, LEMON ELECTRONICS LTD
06.2009 - 02.2014
MIS Executive
JORJY INTERNATIONAL PVT LTD
01.2006 - 05.2009
Diploma - Computer Application
YMCA
2004 - 2005
Bachelor of Arts - Secretarial Studies and Office Administration
Delhi University
2002 - 2005
Similar Profiles
Ranjeet KumarRanjeet Kumar
Assistant Manager-Payroll at CHEIL INDIA (A SAMSUNG GROUP)Assistant 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