Pablo Mercado
Imperial
Summary
Payroll professional with 8+ years of experience processing and reviewing high-volume payroll for
workforces exceeding 1,000 employees. Experienced in payroll administration, payroll reporting,
payroll reconciliations, compliance monitoring, employee support, and data analysis. Proven ability
to troubleshoot payroll discrepancies, maintain accurate payroll records, prepare management
reports, coordinate with cross-functional departments, and ensure payroll accuracy in fast-paced environments. Bilingual in English and Spanish.
Overview
9
9
years of professional experience
Work History
Payroll & Reporting Manager
Scaroni Family of Companies
Heber
03.2017 - Current
- Process and review weekly payroll for more than 1,000 employees, ensuring accuracy, timeliness, and compliance with payroll procedures and company policies.
- Verify payroll transactions, earnings, deductions, tax information, and employee data prior to payroll processing.
- Investigate and resolve payroll discrepancies involving employee earnings, deductions, timekeeping records, and payroll system data.
- Maintain payroll records and employee payroll information, including status changes, payroll adjustments, and reporting data.
- Generate payroll, operational, and management reports used to support organizational decision-making and workforce planning.
- Perform payroll validation checks and reconciliation procedures to ensure accurate payroll processing an reporting.
- Utilize Famous, Picktrace, Symmetry, and Microsoft Excel to analyze payroll information and maintain accurate records.
- Develop and maintain Excel reports using Pivot Tables, VLOOKUP, If Formulas, and other advanced functions to improve reporting efficiency and data accuracy.
- Respond to employee and management inquiries regarding payroll information and reporting matters.
- Coordinate payroll workflows and support a team of 12 payroll staff to ensure timely completion of payroll-related activities.
- Train and onboard employees on payroll processes, reporting systems, and departmental procedures.
- Assist with payroll audits and compliance reviews by validating payroll records, researching discrepancies, and preparing supporting documentation.
- Serve as a key of point of contact and act on behalf of management during Payroll Manager absences.
Education
Technical Degree - Accounting
Center For Employment Training
El Centro, CA02-2017
Bachelor's Degree - International Business
Universidad Autonoma De Baja California
Mexicali, Baja California05-2016
Skills
- Payroll Processing & Administration
- Payroll Reconciliation & Auditing
- Payroll Reporting & Data Analysis
- Timekeeping Verification
- Employee Payroll Support
- Payroll Compliance
- Direct Deposit & Deduction Administration
- Payroll Record Maintenance
- Internal Control & Quality Assurance
- Microsoft Excel (Pivot Tables, VLOOKUP, If Functions)
- Microsoft Office Suite (Excel, Word, Outlook)
- Payroll Systems: Famous, Picktrace, Pago, Symmetry
- Bilingual: English & Spanish
Timeline
Payroll & Reporting Manager
Scaroni Family of Companies
03.2017 - Current
Technical Degree - Accounting
Center For Employment Training
Bachelor's Degree - International Business
Universidad Autonoma De Baja California