Payroll Coordinator Administrative Assistant

* * * * * T E N T O N A V E N U E, A P T * H, P H I L A D E L P H I A, P A 1 9 1 18

* * * - ***- * 7 9 1 • C E L L : 2 1 5 - 5 2 7 - 5 7 9 0 • J O N N Y D 7 6 0 6 @A O L . C O M J OHN L . D E R H AM

OBJECTIVE

To find a position which utilizes my twenty years of experience in payroll administration and budgeting.

EMPLOYMENT

Green Tree School & Services

2015-2025 Payroll Coordinator/Administrative Assistant System Administrator for ADP/Payroll System

Add, update and terminate all new hires, rehires and terminations in ADP system

Calculate pay changes: salary increases, reductions, new hires, and final pay.

Investigate employee payroll discrepancies in a timely manner. Input date of employee vacations, personal days, sick leave, etc. And review to ensure accuracy of payroll

Audit payroll reports prior to transmission of information to ADP Assist HR Director as back-up related to ADP additions or changes Address and resolve payroll or time clock issues

Process biweekly payroll including liens, garnishments, and other deductions

Maintained EZ Labor Manager time and attendance system Prepares general ledger entries and other reports for accounting department as needed

I led the conversion from ADP to UKG Pro Workforce Magement in 2020.

The Franklin Institute

2014-2015 Senior Accountant, Payroll

Process biweekly payroll including liens, garnishments, and other deductions

Prepare and input monthly payroll journal entries

Upload payroll distribution reports to Actuate reporting software Administer EZLM time-attendance system, time clock. Payroll G/L interface, and ADP Report Writer systems

Process and fund 401(k)/457(b) retirement plans

Compile yearly 401(k) census

Assist with budgeting process

File US Department of Commerce census reports

Perform bank account reconciliations including researching discrepancies with credit card settlements, bank deposits, coin/currency orders, and other transactions

Complete account reconciliations and analysis

Perform monthly/yearly journal entries including analyzing information received

GES USA, Inc.

2010-2014 Payroll Coordinator

Process weekly payroll and related withholdings for 150 employees in compliance with Federal, state and local regulations using HRB and Pay eXpert software

Monitor locations of traveling employees and adjust state and local tax withholding as necessary

Audit the payment of Federal, state, and local taxes Prepare general journal entries using Timberline software Administer company’s 401(k) plan

Prepare various management reports using ADP Report Writer software Greater Philadelphia Health Action, Philadelphia, PA 2008-2010 Accountant/Payroll Coordinator

Process biweekly payroll and related withholdings for 300+ employees in compliance with Federal, state and local regulations using ADP PCPW and Pay eXpert software

Audit the payment of federal, state, and local taxes Prepare payroll section of monthly financial statements Process monthly consultant/contractor pay for physicians Prepare general journal entries using Solomon software Maintain fixed assets inventory using FAS fixed assets software and prepare monthly depreciation system

Compile data for annual payroll and employment tax budget Audit and reconcile the payment of employee medical and dental insurance invoices and resolve outstanding issues

Synthes USA, West Chester, PA

2003-2008 Payroll/HRIS Specialist

Audit and check daily payroll/HRIS data entry of 3,800- employee company to ensure accuracy

Monitor HRIS database maintenance of employee records and tables to include: new hire entry, hours and earnings entries, transfers, promotions, performance review updates, review of consistent data practices

Responsible for payroll processing in Ceridian Source 500 system Perform analysis of payroll related general ledger accounts Oversee reconciling of payroll bank statements and monthly reporting for general ledger interface

Perform monthly processing and reporting of 401(k) Monitor payroll taxes and payments in all fifty states Prepare reports using Excel and Access to HR department Handle employee questions, and act as backup for Payroll Manager Philadelphia Newspapers, Inc., Philadelphia, PA

1999-2003 Senior Financial Analyst

In addition to responsibilities listed below, was responsible for the processing of weekly payroll data from PIE timesheet system to ADP system for weekly processing. Instrumental in the conversion from ADP to Fidelity payroll system.

1992-1999 Financial Analyst

Coordinated full-time equivalent (FTE) budget and prepared weekly and monthly FTE budget variance reports. During this period I created an Excel macro which compressed the time needed to manually calculate weekly FTEs from 4 hours per week to 15 minutes per week. I also converted a Lotus macro for the annual budgeting process into an Excel macro.

Prepared and maintained confidential month payroll, prepared federal, state, and local tax returns, processed and maintained Vanguard 401(k) investment savings plan and loan repayments, and prepared annual 401(k) non-discrimination test data. General ledger account analysis.

1990-1992 Payroll Accountant

Prepared manual checks, processed payroll tax payments, performed general ledger account analysis.

SUMMARY OF SKILLS

Experience with ADP, Fidelity, Ceridian, and UKG Pro Workforce Management payroll systems

Advanced skills in Microsoft Excel and Access. Proficient in ADP ReportSmith and Solomon software

Long experience working in a multi-union, multi-state environment Certified Payroll Professional

EDUCATION

1996: St. Josephs University, Philadelphia, PA

B.S. Accounting

REFERENCES

Available upon request.

Contact this candidate