Lakshmibhargavi

Payroll Analyst with 3+ years of experience supporting payroll operations, payroll systems, data validation, reconciliation, testing, and reporting across Workday HCM/Payroll, Oracle HCM/Payroll, and ADP-supported environments. Experienced in pre- and post-payroll validation, gross-to-net reconciliation, earnings, deductions, taxes, benefits, employee data changes, and payroll variance analysis, with hands-on involvement in Oracle-to-Workday payroll migration, parallel payroll testing, UAT, regression testing, defect validation, and post-migration support. Skilled in Advanced Excel and SQL for payroll reconciliation, data validation, exception analysis, audit support, and reporting.

Knowledgeable in US payroll operations and experienced with Indian payroll statutory requirements, including PF, ESI, Professional Tax, TDS, and LWF. Proven ability to work with Payroll, HR, Finance, and technical teams to investigate discrepancies, maintain payroll data integrity, and support accurate and timely payroll processing.

Payroll Analyst at AEP (2025-09 – Present)

• Support Workday HCM and Payroll operations for a payroll population of approximately 2,000+ employees, reviewing employee and payroll data and assisting with payroll exceptions to support accurate and timely processing.
• Perform pre-payroll and post-payroll validation of earnings, deductions, taxes, benefits, garnishments, and employee changes, investigating discrepancies and coordinating corrections with Payroll and HR teams.
• Reconcile gross-to-net payroll results and employee-level payroll data, researching variances related to compensation changes, deductions, tax withholding, benefits, retroactive adjustments, and other payroll transactions.
• Support Workday Payroll system maintenance and enhancements by assisting with requirements gathering, impact analysis, documentation, and validation of payroll-related system and data changes.
• Execute UAT and regression testing for payroll updates and system changes, completing approximately 20–30 test scenarios during major testing cycles, documenting defects, validating results, and retesting corrections before production release.
• Create and maintain Workday payroll reports and use Advanced Excel functions including PivotTables, XLOOKUP/VLOOKUP, SUMIFS, and conditional formatting to support payroll reconciliation, exception analysis, audit requests, and operational reporting.
• Monitor payroll-related data exchanges between Workday and ADP for selected payroll, tax, and compliance activities, validating inbound/outbound data and escalating integration issues to appropriate technical teams.
• Partner with Payroll, HR, Finance, and technical teams to investigate payroll issues, maintain data integrity, support audit requests, and resolve routine payroll discrepancies within 1–2 business days, depending on issue complexity.

Payroll Analyst at TalentPro India HR Pvt. Ltd. (2022-03 – 2024-07)

• Supported monthly payroll operations for approximately 800+ employee records, validating employee master data, attendance, earnings, reimbursements, deductions, and payroll changes to support accurate and timely processing.
• Supported payroll data integration and reconciliation with Oracle Payroll, validating payroll inputs, deductions, statutory components, and payroll reports while investigating discrepancies between source data and payroll outputs.
• Performed pre- and post-payroll validation of gross pay, taxable earnings, deductions, net pay, arrears, salary revisions, new hires, and full-and-final settlements, resolving payroll exceptions within established processing timelines.
• Supported Indian payroll compliance and taxation involving PF, ESI, Professional Tax, TDS, and LWF, while conducting monthly reconciliation and investigating approximately 20–30 payroll exceptions per cycle related to employee data, salary changes, and deductions.
• Used Excel and SQL for payroll reconciliation, data validation, variance and exception analysis, and reporting, leveraging PivotTables, XLOOKUP/VLOOKUP, and SUMIFS to analyze headcount, gross pay, deductions, statutory contributions, and net pay.

Master of Computing and Information Systems in Computing and Information Systems – Youngstown State University

Bachelor of Science in Electronics and Communication Engineering – Sastra University