Manager Software

**** ******** *****, ************, ** *****

215-***-**** CELL: 267-***-**** act71l@r.postjobfree.com

JOHN L. DERHAM

OBJECTIVE

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

EMPLOYMENT

Green Tree School & Services

2015-present Payroll Coordinator

System Administrator for ADP/Payroll System

Add, update and terminate all new hires, rehires and terminations in ADP Workforce Now and Enterprise systems

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

Maintain EZ Labor Manager and Timesaver time and attendance systems

Prepare general ledger entries and other reports for accounting department as needed

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, and Ceridian 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