Jennifer Shetler
Windsor Heights, IA 50322
abmudu@r.postjobfree.com
Qualifications A Financial Analyst with varying experience in
analyzing the accounting data of
Summary: multiple industries. Effective and efficient in managing
projects and tasks requiring the organization of data
in an understandable format to senior management and
other departments. Visionary of the end result and
the process to reach goals by utilizing my strength
of technical skills including database creation and
queries.
Experience August Home Publishing Company 2005 -
present
Summary: Financial Analyst
Responsible for financial reporting, budgeting, projections and
analysis for two magazine divisions and also for all
products of this publishing company.
. Created and maintained financial models reflecting
the profitability of two magazine divisions,
ensuring accurate future marketing decisions and
trained personnel on the use of the new system.
. Created new system for analyzing invoicing to
ensure billing correctly matches contract and
trained personnel on its use.
. Produced new model for ancillary product sales,
resulting in more accurate projections.
. Created and maintained various databases,
including those for use in the analysis of books
and newsstand sales and television series market
coverage.
. Analyzed and projected printing costs for all
magazine divisions and books, including variance
analysis.
. Backup to controller for creation of financial
statements for all company divisions.
. Developed system for analyzing sales and
profitability of coverwraps, individual products
and marketing campaigns and promotions, including
web-based, to determine future marketing
strategies.
. Created and maintained inventory balance sheet for
tracking, which provided senior management with a
quick tool for determining future promotional use
and to ensure levels met company guidelines.
. Primary person responsible for creating special
request analysis regarding sales and both long and
short term profitability for CFO and owner in a
timely and efficient manner.
. Created new billing analysis tool and completed
project by testing and training on its use.
. Analyzed all possibilities for re-purchasing of
various products to determine best levels to
ensure costs kept low while ensuring adequate
inventory levels to meet sales expectations.
. Worked with vendor on new reporting system for use
in analyzing product sale, including testing and
working with co-workers to learn the system.
. Presented findings on various analysis to VP/CFO,
Owner and Editorial Managing Directors.
. Collaborated with IT to develop a tracking system
for web sales.
Tone Brothers, Inc. 1999 - 2005
Senior Financial/Contract Analyst
Managed and analyzed contracts for this $300 million consumer
packaged goods company in the food industry.
. Analyzed contract proposals and adjusted to
present several options regarding costs and
benefits to sales, marketing and upper level
management.
. Prepared and reviewed financial proposals for new
and renewed customers by creating financial models
to determine profitability and presented findings
to senior management ensuring that they met
company strategies.
. Set guidelines and timetable for contract review
and educated analysts on the new process and tool
I created for reviewing.
. Worked with vendor to implement new tool for
analyzing deductions and trained personnel on its
use.
. Used technical, financial and database query
writing knowledge to gather and prepare
information for senior management, customers and
sales personnel, including cost and variance
analysis, marketing fund analysis and cash flow
analysis to be used in making strategic decisions
and plans.
. Successfully supervised department consisting of 3-
10 people.
. Prepared $50 million annual contract budget within
short time frame, which management felt fully
comfortable relying on for strategic planning.
. Worked extensively with programmers to create and
implement enhancements and changes to system which
reduced errors and man hours.
Thomas C. Porter & Associates
1997 - 1999
Controller
Managed entire accounting functions for a small
independently owned local advertising and public
relations firm.
. Supervised system for billing of clients ensuring
all customers were sent accurate and timely
invoices and providing revenues as quickly as
possible.
. Preparation of various monthly management reports
and profitability analysis and creation of reports
on demand for the owner's use in strategic
planning.
. Successfully completed conversion of accounting
system by preparing for, installing and testing
within a minimal time frame with little down time.
. Implemented new system of analyzing billable
hours, eliminating significant errors and
increasing profits.
Liberty Services, Inc.
1995 - 1997
Accountant
In this bank servicing company, responsible for
accounts payable, payroll and financial reporting for
an independently owned 8 bank group located in Iowa
and Arizona.
. Prepared monthly management reports for entire 8
bank and 36 branch group accurately and
efficiently for senior management and owner's
review.
. Assisted management in computer conversion to new
in-house payroll system.
Norwest Mortgage, Inc.
Funding/Marketing Accountant 1992 -
1995
Reconciliation Accountant
1991 - 1992
Trust Reconciliation Accountant
1991
Provided various accounting tasks for this nationally
growing mortgage banking group.
. Prepared Monthly Management Report on Analysis of
Secondary Marketing Gain/Loss.
. Creation of Finance Summary each month showing
changes in market price, amount of loan
applications and fundings.
Education: BS, Accounting, Drake University, Des Moines, IA,
1990
Technical Skills: Have gained knowledge and proficiency in the
following computer software and systems:
* Microsoft Word * Microsoft Excel *
Microsoft Access
* AS400 Database System, with query creations.
* ITI Database System
* ABRA Payroll System * ADP Payroll System *
Chicor Deduction System
* Data Tracker Database system, with query creations
* MAS90