Ariel Planz

CPA Candidate

Oak Park, CA *****

818-***-****

acz6bx@r.postjobfree.com

Summary of Qualifications

• Financial Analyst Experience: Over Seven Years • Senior Accountant Experience: Over 11 Years

• Management Experience: Assistant Controller • Industry Experience: Manufacturing, Pharmaceutical, Retail,

• Cost Accounting: Standard Costing, Process and Project Agriculture, Fulfillment, Finance

ERPS EXPERIENCE: JD Edwards, Great Plains, PeopleSoft, Navision, Oracle and SAP among Others.

REPORTING SYSTEMS: FRx, TM-1, SAP Business Objects (Magnitude), JDE E1, NetSuite.

(Various Companies: Gross Sales from $25M to $36B) March 2011 – Present

BGPL, CCRC, DTS, ValleyCrest, Delta Media, Arvato Bertlesmann, Avnet Integrated, Reach Local

SENIOR ACCOUNTANT, FINANCIAL ANALYST, (Permanent and Consultant).

Countries: U.S., Germany, Canada, Australia, Brazil, Mexico and the Netherlands

SOFTWARE: GREAT PLAINS, NAVISION, SAP, SAP Business One, JDE E1

Responsible for the month end close and closing entries.

Balance Sheet Reconciliations.

Cash Reporting and Forecasting.

Weekly and Monthly KPI Reports, Operating as well as Sales Forecasting to Senior Management.

SEC Reporting – 10Q and 10K.

Six Sigma

Forecasting: Proportional and Trend Adjusted Methods as well as Exponential Smoothing.

Budgeting: Annual Budgets, Rolling Budgets and Capital Budgeting

SOX Compliance: Developed Desktop Processes

Profitability Analysis per Profit Center and per Client

Cost and Corporate Allocation Analysis

Break Even Analysis

Reorganized Accounting Operations and Implemented Operational Efficiencies.

Designed New Reporting Models to Improve Reporting to Senior Management.

Multi – State Sales and Use Taxes, Multi Region Property Taxes, S-Corp Taxes and State Fuel Tax Refunds

DTS only: Responsible for creating income models from intellectual property licensing agreements.

Financial Modeling: what if analysis, discounted cash flow, IRR, NPV.

United Tote Manufacturing, a Division of YouBet.com (Gross Sales $100M) May 2009 – December 2010

SENIOR ACCOUNTANT Industry: Manufacturing

Countries: U.S. and Canada

SOFTWARE: GREAT PLAINS

Managed $5M in inventory assets.

Reviewed sales tax laws in various states and corrected internal procedures.

Corrected fixed assets accounts to eliminate $500K of false entries. Established new procedures.

In two months reconciled $2.3M of inventory in Great Plains. Implemented Cycle Counts.

Instituted the use of MS Excel and MS Word macro’s in Great Plains to manipulate large amounts of data

Established new revenue models based on written contracts (value up to $25M).

Over the course of seven months established inventory NRV. Established reserve criteria up to $500K.

Audited Partner Contracts to find over $500,000 in monthly lost revenues. Inproved bottom line by 30%.

SEC Reporting – 10Q and 10K.

1.Income Statement and Balance Sheet

2.Cash Flow

3.Schedules and Footnotes

Rachel Ashwell Designs, Inc. aka Shabby Sheik (Gross Sales $55M) October 2007 – February 2009

ASSISTANT CONTROLLER Industry: Retail and Manufacturing

Countries: U.S.

SOFTWARE: GREAT PLAINS

Implemented new credit criteria for wholesale accounts.

Reduced Account Receivable past due by 77% within three months.

Implemented new retail reporting procedures to improve work flow.

Implemented new techniques for accrual calculations.

Saved the company approximately $100M negotiating Letters of Credit.

Cash Reporting and Management. Budgeting (Rolling Budgets) and Forecasting (Regression Analysis)

Reiter Affiliated Companies (Gross Sales $700M) December 2004 – September 2007

SENIOR ACCOUNTANT / FINANCIAL ANALYST Industry: Agriculture

Countries: U.S., Mexico

SOFTWARE: ABBECAS

Performed the accounting for five separate companies.

Was responsible for financial reports, financial analysis, budgeting and monthly forecasting.

Implemented cost and accrual calculations for fixed and variable expenses.

Financial Analysis and Presentation to shareholders or partners

Product Price forecasting (financial and economic Analysis) for product risk.

Yearly Budgeting

Capital Budgeting

Quest Diagnostics Clinical Trials (Gross Sales $3 Billion) April 2003 – August 2004

SENIOR. ACCOUNTANT / FINANCIAL ANALYST Industry: Pharmaceutical

Countries: U.S., the United Kingdom and Singapore

SOFTWARE: PEOPLESOFT

Implemented new accrual calculation techniques on Excel spreadsheets.

Implemented improved monthly balance sheet reconciliation techniques.

Prepared financial presentation package which included financial analysis and monthly forecasting for Senior Management in New York and London.

Ameriflight, Inc. (Gross Sales $300M) March 2000 – March 2003

SENIOR ACCOUNTANT Industry: Air Courier

Countries: U.S., Mexico

SOFTWARE: JD EDWARDS (AS 400)

Instituted improved methods for property tax reporting.

Saved the company over $1.3 M in property taxes over the course of three years.

Managed the inventory and auditing functions for all cost centers in California (about $12 M in inventory).

Previous to 2000

FINANCIAL ANALYST INDUSTRIES: International, Investment, Commercial Banking, Management Consulting

Worked for Barclays Bank International (Miami and London) as a Risk Analyst/International Banker, Standard Chartered (Los Angeles) as an Investment Banking Trainee, and Dun & Bradstreet (U.S.) as a Financial Analyst.

EDUCATION

THE UNIVERSITY OF MIAMI, SCHOOL OF BUSINESS ADMINISTRATION

Bachelor of Business Administration – Finance. Minor in Engineering, JF Kennedy Presidential Scholar

COLUMBIA UNIVERSITY /LONDON BUSINESS SCHOOL (Fully Employed MBA)

MBA – In process. Will finish in June 2018

LANGUAGES: English, French, Spanish.

CERTIFICATIONS: Excel Expert Certification (by Microsoft) November 2012.

PUBLICATIONS: International Finance, Financial Analysis, Cost Accounting. (Dun & Bradstreet Publications)

Contact this candidate