Sales Accounting

** ***** ******

Leechburg, PA *****

Telephone: 724-***-****

Cell: 724-***-****

E-Mail: abi9f5@r.postjobfree.com

Gary L. Shepler

Experience August 2009 - Wal-Mart

Present Corporation Tarentum, PA

Staff Accountant

Reconcile, track and report various financial transactions

Monitor investments for maximum ROI while maintaining cash on

premises for adequate cash flow

Review various reports for accuracy and report discrepancies or

unusual activity to management

Perform audits to detect long/short activity

Research and explain any large differences in long/short

activity

Prepare any necessary journal entries

Assist with Corporate audits

Perform bank reconciliations

Monitor and report potential security risks

Audit and report any incorrect or inefficient processes

Monitor and correct any improper accounting practices

Advise others on accounting practices and principles

June 2008 - May 2009 Arnheim and

Neely, Inc. Pittsburgh, PA

Staff Accountant

Complete all bank reconciliations for operating and reserve

accounts for 65 client properties

Monitor all bank accounts to maximize interest and minimize fees

Review expense distribution reports for accuracy of expense

accounts used

Research and explain any large differences between actual

expense and budgeted expense

Monitor investments for maximum ROI and availability of cash

when necessary

Review A/P, A/R and payroll activity for accuracy

Prepare any necessary journal entries

Month-end close

Prepare monthly and year-to-date financial statements

Prepare and file state sales tax

Field and answer questions from property managers and directors

Coordinate and provide all data for year-end audits

Prepare new year's budget

Calculate monthly amounts, based on budget, to be billed to unit

owners

Coordinate and provide necessary data for the preparation of

annual tax returns

Calculate and monitor any special assessments

Set-up new client files as necessary

January 2008 - June 2008 Robert Half

International Sewickley, PA

Accounting Consultant

Perform specific duties in various areas of accounting as

defined by client of Robert Half International

Latest assignment:

Developed and analyzed gross and net margin files comparing

prior year with current year results

Accumulated necessary cost data for above comparisons including

distribution of costs back to various products

Provided client with a final analysis concerning their margin

comparisons with recommendations for improved cost control

Developed a process for ongoing data accumulation by client to

review margins

Created permanent, dynamic files for client use to develop

sales, material, direct labor, other direct, and overhead

variances

Developed dynamic Excel spreadsheets for use by client to

provide quotes to current and potential customers

Reviewed and made recommendations to client concerning improved

cash flow

June 2007 - December 2007

Western & Southern Financial Group

Monroeville, PA

Registered Representative

Assist District Sales Manager in establishing sales

relationships with local school districts

Establish relationships with local businesses to offer

affordable group health care, and other group insurance programs

Offer local businesses the ability to establish retirement plans

for themselves and their employees or transfer their current

plan

Service and support current clients with their financial goals

Establish new, individual client base by offering assistance

with their wealth accumulation, wealth protection, and wealth

transfer

February 2002 - November Leechburg Area Leechburg, PA

2006 School District

Business Administrator

Directly supervise staff of nine

Indirectly supervise staff of thirty-five

Fund Accounting

Develop, implement and monitor $12 million budget

Financial management according to GASB standards

Local, state and federal reporting

Local, state and federal audit procedures

Capital Fund Management

Fixed Asset Management

Revenue Management

Bank reconciliations

Student membership/child accounting

Human Resource Director

Group health benefits

HIPAA privacy officer

Contract negotiations with teachers (PSEA), secretaries and

instructional aides (PSEA), and food service workers,

maintenance and custodial workers (SEIU)

Postings for job openings

Conduct interviews

Workers' compensation

FMLA

Insurance and risk management

Trustee on the Armstrong/Indiana Insurance Trust where I served

on the executive committee

School Board Treasurer

January 1979 - February Allegheny Ludlum Steel Brackenridge, PA

2002 Corporation

Cost Accounting Supervisor

Directly supervise a staff of seven within the cost accounting

department

Coordinate and monitor the taking and reconciliation of the

annual physical inventory

Responsible for the annual revaluation of the finish cost file

Responsible for closing the company's books on a monthly basis

to determine sales and profitability

Compile and calculate data in assisting in the preparation of

the annual operations plan

Prepare monthly reports to upper management relative to sales,

cost, and profitability by product line, plant location, and

consolidated

Analyze and control issuance of various reports to upper

management

Define and designate cost centers for distribution of expenses

and establishing systems to classify and compile expenses

according to type of expense and cost center incurring cost

Work with marketing directors, technical services, production,

and product development in preparing cost estimates for new or

existing products

Coordinate controls of monthly closing function to monitor cost

accounting activity

Assist external public auditors with detailed explanations of

external reports and internal control system

Recommend new budgeting and cost accounting methods

Remain abreast of accounting procedures and methods

January 1982 - April Shepler Consulting West Leechburg,

2002 Service PA

Owner

Perform various accounting functions for small to medium size

companies and non-profit organizations

Bookkeeping

Payroll, including all weekly, monthly, quarterly, and annual

reporting for the states of Pennsylvania and Indiana

Federal payroll reporting, including W-2, W-3, 1099, 1098, 940,

941

Financial statement preparation

Performed accounts payable and accounts receivable functions

Prepare and submit annual income tax and informational returns

Perform annual audits

Bank reconciliations

Preparation of annual personal income tax returns for 100+

clients

Education Degree Program Pennsylvania State State College, PA

University

Bachelor of Science

Major: Accounting

Computer Background

Microsoft Excel: Introductory, Intermediate and Advanced Courses

Microsoft Access: Introductory and Intermediate Courses

Microsoft PowerPoint: Introductory Course

Microsoft Word: Introductory Course

QuickBooks: Certified

Peachtree: Working Knowledge

References Professional and personal references are available upon request.

Contact this candidate