Sales Project
Resume:
**** ****** ***** ***** 732-***-****
Toms River, NJ trevornandersen@gmail.
TREVOR N. ANDERSEN
WORK EXPERIENCE:
Dover Corporation
October 2009 to Present
Sr. Analyst
. Responsible for developing re forecasting plans for corporate segment
totaling 150M and projecting three year spend trending.
. Project lead on new BI tool for Oracle reporting that will allow for a
more responsive analysis and reduce the amount of time in formatting key
reports.
. Analyzing all existing OPCO's & Holding Company templates for 2009 and
plan 2010 to determine if there are any inconsistencies from the previous
year template.
. Personally responsible for forecasts for 5 departments and SG&A trending
based on current drivers.
. Reviewing reports monthly to determine discrepancies and minimize risk
impact on P&L fluctuations.
. Responsible for month end close analysis such as P&L Flux analysis and
new Oracle spreadsheets required for the close.
. In charge of reporting actuals to budget variances for all departments
and making recommendations based on variances.
. Developed new analysis's for reporting purposes and created faster ways
to obtain financial data.
. Reviewed all account coding for 09 GL mergers into new Oracle GL
system.
Young & Rubicam Inc
Jan. 08to Sept. 09
Sr. Financial Analyst, Post Production (8/09 - 9/09)
. Compared budget to actuals from an operating perspective and setting
tolerance levels for upper management.
. Developed key reports for management by utilizing pivot tables and
advanced excel methods.
. Conducted operational and financial analysis of each department within
business unit.
. Streamlined daily processes and increased productivity levels.
. Evaluating internal controls, identified areas for risk exposure, and
improved operational efficiency levels.
. Completed project within 1 month originally speculated to take 4 to 5
months based on project performance.
Sr. Financial Analyst, Client Operations (1/08 - 2/09)
. Assisted the Controller and CFO in the preparation of each business
unit's annual budget and review of departmental budget data.
. Responsible for all research and financial data when handling RFP
requests.
. Developed staffing plans based on client needs and
profitability potential.
. Ran different model scenarios to determine KPI's and
risk potential.
. Worked within each account group to determine client
trending and seasonality.
. Worked directly with the CFO to develop pricing models and strategies
based on current trending.
. Coordinated financial analysis and forecasting for each individual BU
under local CFO control.
. Developed new procedures to improve timeliness and accuracy of data and
information flow to all areas of the organization.
. Lead market research projects to determine client profitability in key
target areas.
. Worked directly with CFO and Controller to create
revenue recognition policies for each BU.
. Created financial reports to improve inefficiencies, decrease expenses,
improve overall employee utilization for each Business Unit. These
included:
-A new Income Report which provided upper management with a
distinguishable correlation between employee performance
and income.
-New Sales and Expense Reports (for Bare Society, LLC.) to decrease
project lag and decrease OOP costs.
. Analyzed P&L for any variances and reported any
inconsistencies to our local Controller.
. Reviewed income statement and balance sheet accounts for
variances.
James Joseph Group Inc. December 2006 to November 2007
Financial Analyst
. Managed daily inventory levels based on our internal BE scenario and
specific inventory need.
. Established a BE scenario on all inventory for each of the 5 locations.
. Introduced a new method for perishable goods by creating discount
arrangements with existing older inventory.
. Developed inventory forecasts in excel to better understand our
supply/demand principles.
. Worked with the GM to establish sales budgets then established monthly
targets for each store.
. Developed cost base analysis based on industry inventory trends and sales
analysis.
. Determined risk/opp scenarios based on our current sales trending.
. Maintained a acceptable levels of inventory and reproduced older goods
into a discounted format.
. Made daily deposits; maintained bank relationships. In charge of monthly
billing for largest customers and maintaining accounts receivable;
followed up on past-due accounts.
. Defined measurable goals for marketing strategies and
provided a positive marketing ROI.
. Effectively used direct and indirect marketing
strategies to improve net sales and customer/client
satisfaction.
. Developed guidelines and protocols to eliminate and
reduce operational inefficiencies.
EDUCATION
Coastal Carolina University, 2006
BS: Business Administration, concentration in Management
KEY AREAS OF STUDY
Cost Accounting, Corporate Finance, Managerial Finance, Real Estate
Finance, Acquisition Analysis, Strategic Management, International
Business, and Capital Budgeting
COMPUTER SKILLS
Advanced Excel (Pivot tables, V Look ups, and Macros), Macola, Khalix,
Oracle, Outlook, Project, PowerPoint, Visual Basic, Word, SharePoint,
GEACC, Cartesis, Donovan Data Software, and Eagle POS System
Contact this candidate