Erin Scupham
*** ***** ****** *****, ** ***** Phone: 440-***-****
********@*****.***
OBJECTIVE: To obtain a position that affords the opportunity to utilize
organizational, project planning, finance and communication skills to
increase productivity, reduce costs and improve programs.
EXPERIENCE:
THE SHERWIN-WILLIAMS CO. Cleveland, OH
Senior Financial Analyst - Reporting & Planning November 2009
- present
. Responsible for the preparation, coordination and
submission of the Global Finishes Group annual Budgets and
Operating Plans, as well as monthly financial projections
for two functional areas within the Global Group.
. Prepare monthly P&L's, Working Capital, Exchange Impact,
Balance Sheet Summaries, Sales Analysis and Acquisition
Reporting as well as Daily Sales Reports and various Ad-Hoc
Reports.
. Consolidate, review and analyze business results for the
Chemical Coatings, Protective Marine and Emerging Markets
business segments within the Global Group.
. Conduct training sessions and serve as the lead analyst for
the implementation of the Oracle Business Intelligence
Sales Database, as well as provide continued support for
all users.
. Responsible for the maintenance of the Hyperion reporting
application for Global Group.
THE SHERWIN-WILLIAMS CO. Cleveland, OH
Financial Analyst - Asset Management November 2007 - November
2009
. Prepare Pro Forma's and ROI calculations for potential new
branch locations, relocations and possible closings, as
well as all proposed capital expenditures for the
Automotive Division.
. Conduct continuous reviews of policies and procedures, as
well as evaluating current processes to identify and
implement best practices for the Division.
. Create and provide ad-hoc reports to management to be used
in evaluating program effectiveness, and cost-benefit
relationships.
. Streamlined equipment giveaway program and fixed asset
processing and reporting, through automation and the
elimination of non-value added activities.
. Analyze and reconcile several general ledger accounts on a
monthly basis, perform month-end closing journals, and
research and provide responses for P&L and Balance Sheet
transactions.
. Responsible for reconciling fixed asset system to the
subledger, accounting for capital additions, transfers,
disposals, adjustments and depreciation for the Automotive
Division.
. Supervise and train the Fixed Asset Processor.
THE SHERWIN-WILLIAMS CO. Cleveland, OH
Corporate Auditor February 2007 - November 2007
. Participated in Sarbanes-Oxley compliance effort by
facilitating key document preparation, detail controls
testing, and evaluation of control effectiveness.
. Analyzed accounting entries to ensure adherence to
accounting policy, and recommend solutions to control
weaknesses.
. Planned, organized and conducted examinations and
evaluations of the adequacy and effectiveness of the system
of internal controls to enhance company operations.
. Conducted assigned audits including those of Sherwin-
Williams manufacturing and distribution facilities,
Corporate Division functions, and other audits of an
advanced nature.
THE SHERWIN-WILLIAMS CO. Cleveland, OH
Field Auditor - Bettendorf, IA March 2006 - February 2007
. Scheduled and completed sixty four solo audits of company
stores throughout the Midwest to monitor adherence to
company policy and governmental laws.
. Conducted numerous shrink reviews to assist District and
Store Managers in identifying and explaining inventory
variances and control procedures.
. Exceeded expectations in all goal areas set forth by Audit
Management, including cost savings, accuracy and number of
audits completed.
. Planned, organized and performed District Meetings to help
Store Managers understand monthly operational duties and to
clarify policy and procedure.
. Clearly assembled and communicated data pertaining to
employee dishonesty to Loss Prevention
. Chosen to be a Mentor, New-Hire Trainer and participate in
special request audits.
BRIDGESTONE/FIRESTONE Brook Park, OH
Accounting Associate November 2005 - March 2006
. Prepared and filed sales and use taxes on a monthly basis
for four states.
. Reconciled ledger accounts and prepared adjusting journal
entries.
. Investigated and reconciled banking differences on a daily
basis.
EDUCATION: Baldwin-Wallace College Berea, OH
M.B.A Accountancy 2008-present
The University of Iowa Iowa City, IA
B.B.A Finance July 2005
additional Proficient in Oracle, FACTS, OBIEE, Hyperion, OnBase, Mobius,
Monarch,
SKILLS: Business Objects and Microsoft Office applications - Excel,
Word, PowerPoint
COMPLETED Managing for Business Results and Lean Management
SEMINARS: