AMY ESTRADA 480-***-****
Gold Canyon, AZ ***** aduyy4@r.postjobfree.com
SYSTEMS & TECHNICAL EXPERTISE
UltiPro, UKG Pro Workforce Management, ADP – ADP WorkForce Now, ADP PayForce, ADP Vantage HCM, ADP eTime, Replicon, SAP HR, PeopleSoft, Great Plains, Kronos, Microsoft Office, System Interfaces, HRIS Functions. Advanced Custom Reporting/Ad-Hoc Reports, Security Management, Field Definitions and Mapping.
WORK EXPERIENCE
Verra Mobility – Mesa, AZ 8/2021 – July 2022
Sr. Payroll Analyst
Business liaison between the payroll department and the payroll provider UltiPro
Ensure registration setup of all state and local taxes in Payroll/Time configuration via system mapping
Perform analysis, generate reports, and assist Benefits, HR and Accounting teams with special projects that will streamline processes and improve procedures
Quarterly/Yearly Tax reporting
Assist in developing and implementing payroll policies, procedures & system automation
Business Intelligence report development, database analysis and support expert
Biweekly Journal Entry and Monthly PTO accrual
Provide functional and technical testing of custom reports and software changes
Develop test data, test plans, test cases and validate results
Maintain and support data analytics platforms
Assist Accounting/Finance team during the month-end close process
Perform audits and reconciliations of the payroll accounting and financial systems, accounts, records, and related activities to ensure accuracy and adequate internal control, sufficient security, and audit ability
Provide support to the entire organization regarding all payroll related matters
Provide backup support to various Payroll staff and Payroll Manager
Bank of the West – Tempe, AZ 1/2020 – 7/2021
Sr. Payroll Analyst
Business liaison between the payroll department and the payroll provider ADP
Analyzes all payroll issues, and then resolved the issue correctly within the payroll department
Assist with US biweekly payroll processing full cycle
Escalates complex problems to appropriate parties for quick resolution
Recommends changes to the payroll systems to help streamline and improve processes
Responsible as backup for all incoming and outgoing interface files according to pre-established processing dates
Review files for accuracy and communicates issues to business partners and third-party vendors
Troubleshoots and resolves interface issues
Responsible for ensuring all pre/post Payroll job streams throughout each pay cycle are completed and ensure all transactions are posted correctly and balances to the Bank’s General Ledger
Understanding of all accounting and auxiliary system requirements to ensure accurate reporting. This includes W-2 balances, tax filings, banking requirements, benefits and pension/401k record keeping
Business liaison between the payroll department and the timekeeping provider Ceridian
Complete understanding of all state and federal labor laws to ensure the system is programmed properly for accurate overtime reporting. Recommends changes to the timekeeping system to help streamline and improve processes.
Developed/wrote ongoing Payroll reports as well as ad hoc reporting as needed.
Key team member for all Payroll projects including testing and preparing all test scripts, testing, and communicating changes and key project dates/milestones to the payroll operations group
Set up new earnings and deduction codes as needed, analyzing the requirements to ensure the mapping is correct for all Taxes, 401K, and GL and Special Accumulators
Assist in security access maintenance for the payroll system and all related systems used by the payroll department
Relational Database models such as SQL, Oracle, and MS Access
Working with MS Excel utilizing macros and complex formulas
ASML – Chandler, AZ 1/2019 – 10/2019
Sr. Payroll Analyst
Full Cycle Bi-weekly Payroll Multi-state Processing using ADP PayForce
ADP Support Center & Smart Compliance processing of Garnishments, Wage Payments, Tax & Invoicing
Perform technical research and analysis on wage and payroll tax regulations
Lead cross-functional payroll process improvement projects and implementation
Manage in-bound and out-bound payroll system interfaces, including with payroll and benefit service providers
Setup of new Tax Jurisdictions & Quarterly/Yearly reporting
Process 401(K) & Benefit wires
Process and calculation of Special payments: Commissions, Awards, Tuition, Stock
Sox control internal audit
Process Commissions, Severances, Patient Awards and One-time payments
Provide employee/ internal customer support on payroll-related matters
Provide reports and business insight regarding payroll data to internal business partners
Provide payroll audit support to internal, external, and benefit plan auditors
Contribute to projects to improve the efficiency, control, and business analysis capabilities of the payroll department within a cross-functional environment
Subject matter expert for ADP Custom Reporting (including calculations, VLOOKUP and pivot table functions)
Freedom Financial Network – Tempe, AZ 10/2015 – 11/2018
Sr. Payroll Specialist
Processing of Biweekly and Semi-monthly Multi-state payroll for two ADP company codes using ADP WFN V18.00
ADP Support Center & Smart Compliance processing of Garnishments, Wage Payments, Tax & Invoicing
Running of off cycle payrolls for Terminations, Spiff & Commissions
Subject matter expert for ADP Custom Reporting
Register and setup State, SUI/SDI and Locals’
Validate payroll system setup for new tax rates, tax codes, and other payroll regulatory changes
Handle Incoming Garnishments and child support orders
Assist with internal and external audits
Develop Standard Operating Procedures and internal department checklists
Accounting and auditing duties such as ACH and reporting
Prepare, examine, and verify financial documents and reports
Complete payroll accruals, journal, and GL reconciliation
Handle all incoming Tax notices/Tracers with ADP tax department for resolution & Support Center
System Administration liaison between Finance, HR, Compensation, Benefits, Recruiting and IT
Implementation of process of system improvements & upgrades with HRIS Analyst
UAT Testing for automation for Onboarding
Work closely with accounting to ensure timely payments of payroll, tax liability & ADP 401 K
Acquisitions which include new hire processing, custom validation table & tax setups
Mentor and lead less-experienced specialists on the team