Payroll, Accounting, Human Resources Systems

KATHLEEN J. MAGNUSSON

********@*********.***

SUMMARY: Self motivated, organized professional with an extensive

background in general

ledger, accounting, receivables, payables, audits, bank

reconciliations, multi-state payroll, employee benefits, human

resources information systems and structured query language

(SQL).

EDUCATION: Roosevelt University-Bachelor of General Studies-Major

Computer Science,

Minor Accounting-GPA 3.76 (Sept 1993 - May 1999).

EMPLOYMENT HISTORY:

Northwest Special Recreation Association: (August 2012 - Current)

Payroll Specialist (part time position)

. Assisted with conversion from Paychex payroll system to ADP payroll

system.

. Process and verify payroll for 500+ part time employees & 40 full time

employees.

. Update time & attendance ADP module to ADP payroll system.

. Preview and accept payroll for processing by ADP.

. Establishing benefit accrual reports/procedures with ADP.

. Create various reports using ADP's report writing feature and

Microsoft Excel.

. Developed payroll procedures for new hires, terminations, and

personnel updates.

. Perform background checks for prospective new hires.

. Maintain security and reset passwords for users of the ADP system.

Town & Country Mortgage Services: (Sept 2011 - March 2012)

Mortgage Loan Originator:

. Contacted by phone or met in person with prospective clients wishing

to refinance their homes for a lower mortgage interest rate.

. Explained all the procedures regarding obtaining a loan.

. Locked in rates at clients' requests.

. Obtained credit checks on clients.

. Followed up with clients, banks, insurance companies, title companies,

credit agencies, appraisal companies to ensure a smooth, timely

closing on each loan.

NONPROFIT/VOLUNTEER WORK EXPERIENCE: (Sept 1999 to June 2011)

Organized fundraisers and established Excel worksheets for various

organizations. Set up Access databases, Word documents and Excel

worksheets for personal use. Bookkeeper for non-profit church using

financial software and Excel worksheets.

Discover Financial Services: (June 1981 - March 1996)

Human Resources Rep / Data Base Analyst: (October 1992 - March 1996)

. Provided human resources information systems (HRIS) support for

operation centers and headquarters.

. Streamlined the HRIS security administration process to increase

confidentiality.

. Established complex human resources and payroll reports for management

using SQL.

. Recommended and implemented enhancements to the HRIS database.

. Maintained and audited human resources and payroll tables to ensure

database integrity.

. Created SQL reports on an as needed basis from home office two days a

week.

Staff Accountant: (December 1988 - September 1992)

. Supervised and performed the month-end close process.

. Reviewed journal entries, reconciliations, and various other

accounting functions performed by two accounting assistants.

. Completed the income statement, balance sheet, operating ratios,

deferred cost computations, tax schedules, and estimated financial

statements

. Acted as liaison for the accounting department with external auditors.

Payroll Manager: (February 1986 - November 1988)

. Managed and trained a staff of 15 including 3 supervisors.

. Coordinated and tested multi-state ADP payroll database conversions.

. Analyzed and implemented payroll system enhancements/upgrades.

. Communicated with management on payroll, accounting and systems

issues.

. Developed and implemented payroll procedures.

. Streamlined employee benefits billing process.

. Designed payroll and human resources reports for upper management.

. Processed highly confidential executive payroll.

. Established an out of state satellite payroll unit.

Payroll Supervisor: (November 1984 - February 1986)

. Accomplished an ADP payroll batch to system upgrade.

. Supervised the processing of multi-state payroll taxes, reports and

employee input/benefit documents.

. Ensured that all payroll deadlines were met.

Accountant: (April 1983 - November 1984)

. Reconciled the corporation's major accounts including bank

reconciliations.

. Prepared accrual and other journal entries.

Payroll Accountant: (June 1981 - April 1983)

. Processed multi-state payroll using the ADP service bureau.

. Prepared annual pension and profit sharing reports.

. Reconciled all payroll accounts.

. Filed multi-state monthly, quarterly, and annual payroll taxes.

. Audited W-2 forms for accuracy.

Computer Skills: Structured Query Language (SQL)

ADP Payroll System

Multiple In-House Payroll, Human

Resources & Accounting Systems

Microsoft Access, Excel and Word

QuickBooks on-line training

Contact this candidate