ALEXANDER GUERRA

Telephone # 347-***-**** Email/Skype ID: adyugr@r.postjobfree.com

SUMMARY

Payroll professional with diversified experience and globally known financial services firms. Highly numerate, energetic and quality-oriented individual with meticulous attention to detail. Proven record of successfully handling both daily duties and critical projects from inception to completion. Works equally well independently or as a team member. Calm when working under tight deadlines, on critical projects, or under stressful conditions.

EDUCATION

Baruch College, New York, NY

•Completed, Advance Payroll Skills (Winter Semester December through February 2005)

Course Content: Advanced level of payroll knowledge and application skills suitable for advancement to supervisory and

managerial positions.

•Completed, Essential Payroll Skills (Fall Semester, September through December 2004)

Course Content: Application skills in the area of Federal payroll law and managerial positions.

•Completed, Primary Payroll Skills (Summer Semester, July through September 2004)

Course Content: Comprehensive review of fundamental payroll calculations and applications.

TECHNICAL SUMMARY

ADP WorkForceNow(Extensive Knowledge), Pay Expert, Pay Force, EV5, EV6, Ez-labor, E-time, Essential time, Kronos, General Ledger Interface, HRIS, HCMS, PeopleSoft Payroll for NA 9.2, Ceridian Latitude/Time Solutions, Oracle, Ultipro Software, Workday, Expatriate, Global and Multi State Taxation employees, Union and Non-Union, ADP QuickCalc, Microsoft Excel, Word, PeopleSoft Queries, and Report Writer.

EMPLOYMENT HISTORY

WPP. Remote, Home February 2022 to Current

Payroll System Analyst & Process Support

•Provides HR, Benefits & Payroll Support for both the US ADP EV5/EV6 and Canada ADP WFN for approximately 25,000 employees, 165 pay groups and approximately 140 administrators and practitioners.

•Security Master for the US, Puerto Rico and Canada, provides HR and Payroll practitioners access according to their roles, pay group designation, assigned and hires temporary workforce in ADP EV5 & WFN with legal SSN, ETIN numbers and dummy numbers when necessary.

•Issues password reset, PRC codes, troubleshoots login issues such as Portal Access, Java and Browsers, examples: Chrome, Edge and Internet Explorer for administrator and self-service users.

•Primary point of contact for EV5 inbox, this is an Outlook accounts that is designed to received inquiries from all Opcos with issues related to Payroll, HR, Benefits, from this account we either take proper action to resolve the issue or redirect and reach out to the proper department or third-party vendor for a resolution. Example: ADP, Alight, Vanguard

•Collaborates with team members on a daily and weekly basis on current projects and future implementations.

•Participate on weekly meeting with the Opcos (Pay groups and ADP on current issues and implementation.

•Monitors, creates, downloads, distributes and troubleshoots ADPR reports for Sox security and compliance purposes on a weekly and monthly basis.

•Creates ADPR reports on a as need basis for upper management, other WPP departments for Auditing, Compliance, State and Federal agencies with demographic and wages/taxes related data: VETS 100, California compliance data requirements.

•Evaluates current procedures and practices for accomplishing department objectives to develop and implement improved procedures and practices to ensure efficiencies.

•Key prayers in creating follow up on ADP SR request from WPP to ADP on payroll related issues.

•Meeting on a as needed basis with Payroll Practitioners, Administrators and employees thru Teams, Webex & Zoom on a variety of issues affecting their day-to-day responsibilities and personal payroll related matters.

•Liaison between ADP, third-party vendors and all Opcos, on unresolved issues or escalating to higher ups to get proper resolution on a timely manner.

•Directly responsible for the uploads of Alight benefits deductions files for all Biweekly and Semimonthly pay groups on a pay period basis.

•Currently upgrading ADP EV5 to EV6 in the US for 23,000 employees go live date July 2023. And working on a Workday integration for WT pay group for HRIS purposes.

•In 2022 WPP acquired/migrated 15 pay groups in Canada from ADP Pay@work to ADP WFN, this year in 2023 WPP acquired 3 additional pay groups and we are in the middle of migrating them into ADP WFN for which I am the main point of contact, for integration, roll out, liaison between ADP and the new pay groups, Providing security access to new Admin and Practitioners.

•WPP Canada migrated from the existing benefits plan to totally new set up for 125 Cafeteria plan under Canada Life for all pay groups with a go live effective date of May 2023. I am directly responsible for the migration and integration files, and I am the main point of contact between ADP, Canada Life and playgroups.

ADP. Remote, Home November 2021 to February 2023

PRIS/IS Contract

•Year End Support through ADP WorkForceNow & Time and Attendance set up training and first-time payroll cycle processing for NA and Multi-State employees through an extensive knowledge of ADP WorkForceNow.

•Provided on the spot technical support for ADP products, helping clients with product hardware, software, and operating system issues via Phone, Webex and Cobrowse remote access.

•Managed ADP in house applications such as: Henry, TLM, Smart compliance, Net secure and Service portal.

•Received/Place clock orders for clients, monitor shipment and configured clocks in WFN on the ADP side, provided instructions to clients on how set up physical clocks or Ipads and how to use it and in WFN on demand.

•Provided extensive essential time training to Administrator and Practitioners on how to use T&A and end users.

•Process and updates all Manual checks, and QuickCalc through ADP WorkForceNow for various clients.

•Completed a 6-week training for Time & Attendance, benefits set up on the new version of WorkForceNow.

•Directly responsible for troubleshooting Alex (Clients) issues with payroll, security and smart compliance.

•Engaged in processing payroll changes such as new hires, terminations, term vacation payout, severance, status changes, direct deposits, garnishments, taxes, 125 Cafeteria plan, job titles and department transfers.

•Created and ran reports through I-reports for balancing and Auditing purposes

•Uploaded client’s information through import files in Workforce.

•Managed, Meal breaks, Client PTOs policies, updated PTO’s requests for all company codes, adds exception time, miss punches, imported batch #90, time not reported from previous pay periods, and time accruals.

Diesel, OTB North America. New York, NY May 2021 to November 2021

Sr. Payroll Analyst (Temporary)

•Managed daily operations for bi-weekly payrolls (5 Company Codes) 4 USA, and 1 Canadian, process payroll for approximately 300 multi-State employees through an extensive knowledge of ADP WorkForceNow.

•Processed all employee payroll changes new hires, terminations, status changes, direct deposits, garnishments, taxes, 125 Cafeteria plan, clothing allowances, job titles and department transfers.

•Ran reports through I-reports for processing purposes and internal-external auditing.

•Set up, reviewed and updated PTO accruals for the entire payroll population.

•Administered time and attendance system through ADP essential time, audits timecards, sent second-tier emails notification to approving managers to complete/approve timesheets on a biweekly basis, responsible for sending I-Pay and TLM set up instructions to new hires and passwords reset as needed.

•Manages New hires PTOs policies, updated PTO’s requests for all company codes, adds exception time, miss punches, time not reported from previous pay periods, and time accruals.

•Responsible for BLS updates and directly contacts different tax agencies regarding new tax Jurisdictions due to new business or changes for new locations.

•Process and updates all Manual checks and QuickCalc through ADP WorkForceNow.

Affinity Health Plan, Bronx, NY. June 2019 to October 2019

HR/Payroll Analyst

•Supervised a biweekly payroll of 700 multi-State employees through extensive knowledge of ADP WorkForceNow.

•A key player in the implementation of ADP WorkForceNow for HRIS, Benefits, Payroll, and essential time for

exempt and non-exempt employees, as well as contractors, and temporary staff.

•Performed full-cycle payroll implementation from Kronos to ADP WorkforceNow, worked closely with internal IT,

ADP implementation consultants’ developers, mapping import files from Epicor, Litmos into ADP WorkedForceNow.

• Review biweekly reconciliations and validations, stop payments, and direct deposit deletions/reversals.

• Functioned as a technical resource to the Human Resources Department and advocated the use of affinity’s self-service

• portal, trained managers, supervisors, and other staff on the functionality of ADP WorkForceNow.

• Oversaw the processing of employee status change transactions, new hires, taxes, direct deposit, LOA’s, name changes

severance, transfers, terminations, through the ADP WorkForceNow HRIS application.

•Produced Ad hoc reports for all HR functions, and upon request from managers.

•Interfaced with recruitment, compensation & benefits in order to accurately maintain the HRIS database.

•Monitored time & attendance for managers & supervisor’s approvals, missed punches, PTO requests, monthly

accruals. provided a guide to approving supervisors to edit and correct employee’s timecards.

•Generated and reconciled payroll journals to the general ledger and performed related functions.

121 In-flight Catering (DNATA) Inwood, NY. November 2018 to March 2019

Sr. Payroll Analyst

•Managed daily operations for weekly payrolls for seven company codes. Oversaw the processing, and reconciliation of 600 multi-State employees, including California, through extensive knowledge of ADP WorkForceNow.

•Utilized PeopleSoft version 9.2 as the system of record for HRIS, flow into ADP WorkForceNow

•Maintained and processed Garnishments, Levies, Student loans, and other mandatory deductions.

•Maintained ADP WorkForceNow Master File, mapping, salaries, titles, earning, and deductions codes.

•Evaluated internal controls and processes. Make recommendations to ensure best practices and maintain an efficient payroll environment ensuring compliance with the organization’s policies, federal and state laws.

•Filing and reconciling quarterly tax reports, year-end, and tax regulations updates.

•Processed sign-on bonuses, expenses and uniform reimbursements, salary increases, promotions, transfers, terminations.

•Processed stop payments, EFT reversals, check reversals, and issued manuals checks as needed.

•Preparing, auditing, transmitting, and receiving payroll files from ADP WorkForceNow.

•Review and import timecards, missed punches for union hourly employees, add exception time, and time not reported for previous pay periods, updated futures PTOs request and time accruals for Exempt, and Non-Exempt employees.

• Enrolled New Hires into time and attendance clock system, and monitors time in WorkForceNow.

• Performed special projects and produced ADP WorkForceNow reports on a needed basis for accounting, senior mana-

gement, and Human resources department.

• Monitored and processed leave of absences for STD/LTD, FMLA, worked closely with internal customers, and HR

• Performed audits of ADP and other applications to ensure proper updates, such as WageWorks transit, 401K, 401k

Match, Loans, General ledger reconciliation for accounting purposes, and resolved other payroll related issues.

Various Companies / Greater New York Area May 2012 to September 2018

Contracts Roles with:

Blink Fitness, LIVunLtd, Exl Services, Fairway Markets, Altice USA, Columbia University, Society Generale, Bank

of Nova Scotia, Bryan Health Care, Mizuho Bank, Ziff Davis, ConEd and Metro North Railroad

Sr. Payroll Analyst/Specialist

Utilized ADP WorkForceNow(Extensive Knowledge), Pay Expert, Pay Force, EV5, Ez-labor, E-time, G/L Interface, I-Pay, Ceridian Latitude, MSAS, Oracle, PeopleSoft Payroll for NA, Ultipro, and Workday.

•Managed payrolls for between 500 to 10,000 employees, exempt, non-exempt, union, and non-union.

•Administered various payroll cycles for multi-state employees in AL, AZ, CA, CO, CT, FL, GA, IL, IN, MA, ME, MD, MI, MO, NJ, NV, NY, OR, PA, PR, TX, UT, and WA. including proper taxation for expat and global earnings employees.

•Processed Canadian employees transferring to the USA payroll for proper taxation, and funds transfers.

•Audited monthly and quarterly ADP wage and tax registers, reconciled and issued W-2, W-2c as needed for both U.S. and global mobility employees.

•Monitored and processed LOAs for STD/LTD, FMLA, as well as Garden leave payments.

•Prepared weekly, bi-weekly, semimonthly, monthly and quarterly reports utilizing ADP reporting function.

•Performed special projects on an as needed basis for accounting, senior management, and human resource departments.

•Processed stop payments, EFT reversals, check reversals and reissued wires or manuals checks as needed.

•Updated PTO’s requests for various payroll cycles, added exception time and time not reported from previous pay periods, updated vacation request, and time accruals.

•Administered time and attendance system through HRIS/HCMS PeopleSoft and ADP portals, audits timecards, sent second-tier emails notification to employees and approving managers to complete/approve timesheets on a weekly, and biweekly basis, responsible for sending I-Pay and TLM set up instructions to new hires and passwords reset as needed.

•Performed audits of ADP and other applications to ensure proper updates, such as WageWorks transit/parking, 401K, General ledger files for accounting purposes, and analyzed other payroll related issues.

•Researched and analyzed existing systems and processes; identified data, process workflows along with integration points articulated modification risks, and barriers; recommended system migration or updates.

•Conducted new hire orientation to assure proper documents were on filed such as Federal, State, Local and tax treaty forms, I-9-required back up and other pertaining visa documents for international employees/students.

•Monitored new hires, issued temporary social security numbers to foreign employees/students and followed up on updating actual numbers designated by the social security administration within 10 days of hire date.

•Processed stipends, additional compensation for fellow employees, and monitored daily logs for e-terminations, TBHs,

PAF, LAF, Nominations for faculty and support staff employees.

•Received, analyzed and administered garnishments, levies, student loans in compliance with all legal requirements.

•Researched, prioritized, scheduled, processed out cycle payrolls for weekly, bi-weekly, and semimonthly payrolls.

•Made recommendations and escalated urgent payroll issues to upper management.

Preferred Health Plan, Brooklyn, NY December 2010 to November 2011

Payroll Manager

•Managed daily operations for the bi-weekly and monthly payrolls. Oversaw the processing, and reconciliation of 800

employee’s payroll through HRIS and Ceridian Latitude, and Enterprise software.

•Key liaison and subject matter expert for all payroll inquiries and help maintain vendor relationships.

•Performed Full payroll Cycle implementation from Ceridian Source 500 to Ceridian Solutions, General Ledger interface team up with Internal departments, HR, IT, as well 3rd party vendors, and consultants to develop, mapped import files from system of record to the new Ceridian Solution application.

•Performed reviews and updates of process documentation, monitored workflow of employee’s benefits data between Ceridian Source 500 and Ceridian Solution database, Ran Parallel payrolls to ensure accuracy, and data integration.

•Made recommendations for best practices in the implementation of the Web-based time, and attendance modules.

•Processed manual checks and updated employee earnings through Ceridian Latitude XPresscheck.

•Responsible for auditing bi-weekly and monthly Payrolls according to 153, and 1199 union rules

•Maintained and processed Garnishments, Levies, Student loans, and other mandatory deductions.

•Collected punches through Novatime application and emailed timesheets to call center administrators for approximately 500 hourly employees on a weekly basis.

•Processed uniform allowances, Third-party sick pay, PTO accruals, and union dues for 153 & 1199 employees

•Audited Ceridian wage and tax register reconciled and issued W-2, W-2c as needed.

•Generated and uploaded payroll journals to the general ledger and performed related functions.

•Created and ran power queries/reports for bank reconciliations, HR, journal entries, and upper management.

•Oversaw payroll coordinator’s overall functions and kept track of Ceridian operating costs.

CitationAir, Greenwich, CT May 2006 to October 2010

Payroll Manager

•Oversaw all facets of the daily operations for the entire payroll cycle through Pay Expert, ADP PCPW/Oracle HRIS Database for a semi-monthly payroll of 550 multi-state employees in 30 different states, including California.

•Responsible for managing payroll administrator, and general ledger related functions.

•Implemented Ez-labor management application for 200 pilots, and 350 Non-exempt employees, trained, and mentored team members, supervisors, managers, identified development needs for peers, and work with leadership to coordinate additional training as required by the company.

•Maintained Oracle/ADP connection, mapping, Master file, job titles, earning, and deductions codes.

•Evaluated internal controls and processes. Make recommendations to ensure best practices and maintains an efficient payroll environment ensuring compliance with the organization policies, state, and federal laws, filing, reconciling quarterly tax reports, and tax regulations.

•Performed audits of ADP database to ensure proper updates, analyzes payroll related issues and uploaded 401K plan and General ledger files for accounting purposes. monitored leaves of absences for Military, FMLA, STD, and LTD.

•Worked closely with internal customers, Human resources, Accounting, and all levels of Management.

•Supervised the new hire onboarding process, employment applications, I-9s, employment eligibility verification forms to ensure compliance with both external/internal policies, and updated departmental procedures, trained new staff

•Processed overtime, per-diem gross-up & stipend payments for 300 pilots, and crew members.

•Set up new hires through Oracle database and export applicant’s data through Oracle/ADP connection software.

•Processed manual checks and updates employee earnings through ADP CheckMate, and gross-up calculations.

•Verified edits ensuring that terminated employees received correct amounts, severance, term vacation pay, and any other entitlement

TRAINING

* Affinity Health Plan corporate training for intermediate, advance Microsoft Excel and Word (July-August 2019)

* Active American Payroll Association member through 2020

* American Payroll Association seminar:

Completed: APA PR-201 Payroll Administration Course (Las Vegas, NV April 2008) Course Content: Taxability, and reporting of employee benefits, Federal taxation and withholdings, FLSA "white collar" exemption rules, how to prepare forms W-2c and 941c and their impact on other filings, impact of benefit plans on the payroll process.

LANGUAGE

•Fully bilingual in English and Spanish.

Contact this candidate