Resume of Shirley Ingram
**** ****** **** *****, *********, NC 28227
980-***-**** – ************@*******.***
Summary of Qualifications
Location: Shirley lives in Charlotte, NC and prefers to work in Charlotte.
Availability: Shirley is available for interviews with 24 hours notice and is available to start
immediately.
Professional Skills
• GL Accounting for 4 years
• Accounts Payable/Accounts Receivable for 3 years
• Proficient in SQL with the ability to Run Queries, familiar with UNIX
• Advanced Access and Excel including Pivot Tables, V-Look Ups, Spreadsheets, and
some formulas
• Excellent problem solving skills, excellent customer service as well as oral and written
communication
Professional Experience
Lash Group/AmerisourceBergen, Charlotte, NC January 2013 to Now
Finance/Payroll Analyst
• Run Reports to track billed hours for 300 temporary employees, answering
all inquiries, working out any discrepancies, working very closely with
several temporary agencies
• Entering and reconciling payroll for approx. 1000 employees.
• Working special projects for Payroll Manager, preparing spreadsheet for
quarterly bonuses, preparing spreadsheet for employees transitioning
from exempt to non-exempt, figuring overtime hours and amounts, using
V-Look up excel formulas, working on any project the manager may need.
BAE Systems, Inc., Charlotte, NC January 2012 to August 2012
Financial / Payroll Analyst
• Processed International payroll (ex-pat and in-pat) data for 150 employees,
biweekly with tax equalization, and hypothetical tax.
• Processed Shared Services, and Headquarter payrolls, biweekly.
• Processed Platform Solutions payroll data for 3,000 union and non-union
employees, weekly.
• Processed all payrolls from end to end, handling all issues, off-cycles, reversals,
stop payments, accrual balances running all reports, double checking everything,
strict compliance with union guidelines.
• Prepared for Government Contract Audits.
• Utilized Peoplesoft 9.0, Autotime timekeeping system.
Wachovia (Wells Fargo Company), Charlotte, NC October 2008 to May 2010
Financial Analyst/Payroll Operations
• Ran reports and corrected all errors on Data Quality and Pre-confirm reports, using
V-Look-up, Pivot tables, Excel spreadsheets.
• Completed Table Maintenance, resolving issues, with the ID Table, Corporate
Directory, Cost Centers, and Tax Tables, earnings, deduction and incentives codes.
• Generated Tax reports and complete Tax maintenance for the states of Maryland,
New York.
• Supported Department Managers, Communicating with virtual team. Helping with
System Change. Project, employee ID’s and personal information.
• Assisted with Payroll and tax audits.
• Wrote SOP’s clearly and precisely.
• Mapped all numerical data using People Soft 8.9/People Soft HRMS.
Paetec Communications, Charlotte, NC March 2006 to January 2008
Financial / Payroll Specialist
• Generated standard reports and queries, creating Crystal Reports and Pivot tables
and V-Look up in Excel as needed.
• Ran sales commission reports, census, and headcount reports, assisting month
end close
• Completed payroll accounting reports, journal entries, payroll tax reports,
researching, analyzing any discrepancies.
• Processed multi-state by weekly payroll for 1300 employees.
• Set all payroll runs, schedules, and training.
• Completed all multi-State leave of absence, working with FMLA and Workers
Comp, garnishments, separations, new hire, answering all inquiries
• Acted as back up for Health & Benefits Specialist, and Human Resource
Coordinator, helping with recruitment, reports, 401k, healthcare, retirement,
maintaining unemployment comp records.
• Generated standard reports and queries, creating crystal reports as needed
• Payroll year end, W2’s and W2c’s as needed.
• Work completed in Ceridian HR/Payroll and Ceridian Time and Attendance.
Hewitt Associates, Charlotte, NC July 2000 to April 2005
Financial Analyst
• Member of off cycle team, Processed off cycles, voids, reissues, stop payments,
reversals, adjustments.
• All work completed in SAP EPM.
• Maintained off cycle spread sheet in Excel, kept close contact with Store Managers
and employees nationwide.
• Weekly and Bi-weekly payroll, up-loads from Kronos, making necessary
adjustments, • off cycles, stop payments reversals voids, all queries, Pivot tables
and V-Look Up in Excel, checking all entries.
• Entered Accounts Payable batches, verifying invoices, matching to purchase
orders. Posting and printing checks, verified check printing in several remote
locations and managed end of Month closing and journal entries.
• All Customer Service questions, resolving all issues a priority.
Education
Marshall University, Huntington, WV
Technical Skills
MS Office Suite, PeopleSoft, AS400, Infinium, JDEdwards, SAP, Ceridian HR/Payroll,
Kronos, Crystal Reports, SQL