Mudit vba

Payroll Optimization and Automation Specialist

S&P Global • Full-time

Apr 2026 - Present • 4 mos

Payroll Automation & Reporting Specialist 5+ Years Experience in Payroll Operations, Excel VBA Automation & Reporting Key Achievements: • Developed automated payroll reconciliation tools using Excel VBA, reducing manual reconciliation effort and improving payroll accuracy. • Built multi-source payroll validation and reconciliation solutions integrating payroll vendor files and internal HR systems, enabling faster identification of discrepancies and exceptions. • Designed employee headcount analysis and workforce reporting tools, automating new hire, leaver, active employee, and payroll control reporting. • Automated payroll variance reporting and exception management processes, significantly reducing manual review time during payroll cycles. • Created automated PDF generation and mail merge solutions for over 3,000 employees, eliminating repetitive manual document preparation and distribution activities. • Developed dynamic reporting dashboards and management reports to support payroll operations, headcount tracking, and business decision-making. • Automated large-scale Excel data processing workflows, including data consolidation, transformation, validation, and report generation. • Built custom Excel VBA applications for payroll, HR, and finance teams, reducing repetitive administrative work and increasing operational efficiency. • Implemented automated controls and validation checks to improve data quality and reduce payroll processing risks.