ERIC JONES
Raymore, MO 64083
abm39n@r.postjobfree.com
QUALIFCATION SUMMARY
Seasoned Financial Analyst/Accountant with more than 10 years of
experience with large and small firms. Diversified experiences in the
analysis of financial data and providing a financial prospective in
decision making.
PROFESSIONAL EXPERIENCE
Colgate Palmolive's Hill's Pet
Senior Financial Analyst - Global Supply Chain Topeka, Kansas
May 2009 - Present
. Calculate and report packaging budgets of $85 million. Provide mid-
year budget updates (May & Sept LE's) along with monthly reporting of
packaging actuals with comparisons to budget.
. Finance SPOC (Specific Point of Contact) for project teams relating to
packaging. Responsible for providing financial leadership and
prospective as it relates to projects. Ensure costs such as
obsolescence are held to a minimum.
. FTG (Funding The Growth) finance leader. Track and report cost saving
projects to ensure saving targets are meet.
. Provide ad-hoc reports and work across multiple functional areas to
resolve issues that might arise.
Procter & Gamble, Inc - RetailPULSE
Finance & Accounting Analyst Kansas City, Kansas
Sept. 2007- May 2009
. Saved the company $400,000 by developing in-depth reporting an
analysis surrounding the usage of third party suppliers. This newly
developed reporting allowed management to visually see opportune areas
in which to minimize cost and maximize profits by keeping certain
types of work in-house.
. Manage a $40 Million Dollar third party budget by forecasting monthly
acutals based on prior year actuals and trends.
. Automated the "Additional Charge" process by working with the IT
department in the creation of an on-line process which allowed any and
all individuals of the organization to process their own additional
charge(s) via the web. This new process increased capacity for the
finance department to focus their attentions in more lucrative areas.
. Created an external program using VBA programming within MS Access
that allows me to reconcile the Siebel work-order activities to paid
actuals in SAP.
. Manage $1 Million Dollar expense budget for the Retail Merchandiser in
the field.
. Conducted an audit of the top 2 primary third party suppliers to
ensure their compliance to terms and conditions set by the agreed upon
contracts.
SunBridge Capital, Inc
Senior Accountant Fairway, Kansas
Jan. 2006-Sept. 2007
. Created and maintained inventory reports and roll-forward schedules
which gave management better visibility to the types of assets
repossessed. With the newly developed reports, management could quickly
make changes to their approval system based on trends in the types of
assets being repossessed.
. Learned Info-Lease programming language which allowed me to write my
own "InfoTrieves (Reporting Scripts)" within the system which
subsequently saved the department as well as the company money by not
having to pay the Info-Lease consultants to write the "InfoTrieves."
. When reconciling the clearing accounts for owned leases I discovered
the company was recording the payments of sold leases in balance sheets
accounts rather than recording those payments in an OBS (off-balance
sheet) account. After consulting with the CFO about my recommendation
he agreed to setup an OBS account to track payments received on sold
leases.
. Reconciled and process note payments, for various SunBridge Capital
borrowing loans.
. Responsible for solely reconciling 3-subsidary companies along with
several SunBridge Capital balance-sheet accounts.
Seaboard Foods
Staff Accountant Shawnee Mission, Kansas
Feb. 2000-Dec.2005
. Prepare weekly and monthly income statements for management, along with
month end reconciliations.
. Created and maintain an Access Database using VBA programming to track
employees using company vehicles.
. Handle the check deposits for Seaboard Farms and Superior Farms
(subsidiary of Seaboard Farms), along with balancing the bank statement
for Superior Farms.
Westlake Hardware
Accounts Payable Clerk Lenexa, Kansas
Sept. 1998-Feb. 2000
. Process hard copy invoices using AS/400 system and JD Edwards
accounting system.
. Work with department manager to implement their Inventory Management
System (automated invoicing).
. Generate manual checks in emergency cases.
EDUCATION
Bachelor of Science, Business Administration
May, 2008
National America University, Overland Park, KS
Accounting course included:
Accounting I and II Cost Accounting
Business Finance I and II
COMPUTER SKILLS
Operating Systems Creative Software
Financial/Specialized
Windows '00, NT, XP, Vista Word, Excel, Access-[VBA]
SAP
UNIX/Linux PowerPoint Visual Basic, SQL
Java, C++ Great Plains AS-400/JD-Edwards
Hyperion
TECHNICAL SKILLS
. Created financial models and template utilizing Excel spreadsheet(s),
including Pivot Tables and Macros.
. Design and implemented relational databases using MS Access, Excel and
Accounting Systems.
. Created and prepared presentations using PowerPoint and other MS
Office applications.
. Use VB (Visual Basic) & VBA (Visual Basic for Applications) to design,
development and code unique programs.