DAVID FOX
**** ******* ***, ***** *****, CA ***51
650-***-**** . ******@*****.***
OBJECTIVE
Finance Manager position in an organization seeking an excellent record of:
creating financial models and forecasts, mining data for meaningful
analysis, effective business partnering and supporting senior management.
QUALIFICATIONS SUMMARY
Technically savvy Finance Manager with over ten years of experience aiding
corporate and business unit management by delivering critical analysis and
driving enhancements to planning and reporting systems. Core competencies
include:
- Financial Forecasting & Modeling - Budgeting - Customer
Profitability
- Business Unit Profitability - Financial Reporting - Cost Variance
Analysis
- Strategic Financial Planning (Deal Analysis) - Product Forecasting -
Inventory Planning
- Efficiency Improvements - Report Automation - Technology Integration
- Cognos BI: Analysis Studio, Report Studio, CAF - Microsoft Office
(Excel expert) - Cognos Planning
PROFESSIONAL EXPERIENCE
Silicon Storage Technology; Publicly Traded until April 2010, now a
subsidiary of Microchip, Inc (public). SST Annual Revenue of $320M,
Sunnyvale, CA. (11/2006 - Present)
Achievements
. Established expense allocation methodology for calculating business unit
operating profitability.
. Designed and managed implementation of Cognos Planning budget tool.
. Reduced time required to generate revenue audit reports by 87 percent.
. Developed MD&A expense analysis which saved reporting manager nearly two
days in preparing SEC filings.
. Implemented monthly budget versus actual reviews with business unit
managers.
. Created Excel model for projecting earnings guidance.
Manager, Financial Planning & Analysis
. Reporting directly to CFO, and at times CEO, responsible for maintaining
consolidated corporate forecast, partnering with IT to improve reporting
tools and drive management projects.
. Coordinate and direct company wide budget; maintaining Cognos Planning
tool and managing budget process.
. Manage up to two Financial Analysts on budgeting, cost variance analysis
and enterprise reporting tools.
. Write monthly financial letter for Board of Directors and prepare board
presentations.
. Provide analysis and schedules to support SEC reporting, audits, SOX
compliance, and mergers & acquisitions.
Monster Cable Products; Privately Held, Brisbane, CA. (05/2001 - 11/2006)
Achievements:
. Designed, built and distributed key business metrics that measured
corporate performance.
. Created financial forecasts to evaluate strategic proposals; presented
results to senior management.
. Initiated detailed customer profitability analysis by leveraging data
from sales analysis and cost accounting.
. Developed quarterly pro forma income statements for ten divisions using
financial and non-financial data.
. Partnered with Director of Manufacturing to develop standardized
inventory aging reports and analysis.
. Teamed with Inventory Management to construct analytical model for
evaluating product forecast accuracy.
. Served as reporting expert during and after Peoplesoft implementation:
structured data, created database queries and constructed financial
reports.
Manager, Financial Analysis & Reporting
Additional Roles & Responsibilities:
. Responsible for internal and external financial reporting,
consolidated corporate financial forecast and varied analysis
supporting Senior Executive decision-making.
. Managed up to three Financial Analysts and two Commissions Analysts.
. Collaborated with Sales Operations Director on proposal to enhance
Monster's commission structure.
. Member of the Planning & Leadership Team: contributed to and evaluated
methods of improving operational and financial performance.
Senior Finance & Business Analyst
Additional Roles & Responsibilities:
. Process Owner for FP&A: member of ERP Steering Committee. Determined
optimal data extraction methods for analytics and reporting. Served
as a technical resource for other departments.
. Built Business Cases for new product lines: reviewed contracts,
constructed financial models and evaluated operational impacts with
other departments.
. Established formal partnership between Finance and Product Development
by creating financial plans, providing analytical reports, identifying
trends and targeting improvement areas.
. Guided counterparts in Europe on financial analysis, creating
management reports and database queries.
Financial Analyst
. Constructed and maintained comprehensive, annual corporate financial
forecasts.
. Developed Pro Forma Income Statements & recommended cost reduction
strategies per division.
. Conducted monthly financial statement variance analysis and wrote
management review of results.
. Created and maintained cash forecast model; estimated borrowing level
necessary for cash requirements.
. Participated in Peoplesoft implementation by leading financial report
design, development and strategy; created queries to extract
information directly from database.
Oracle Corporation; Publicly Traded, Annual Revenue of $18B, Redwood
Shores, CA (05/2000-05/2001)
Achievements:
. Decreased excess and obsolete inventory by $300,000.
. Restructured planning process from a life-cycle build to a just-in-time
model of CD Pack Kitting.
. Collaborated with Procurement, Inventory Control, and Kitting to
implement M&D's In House Build Process.
. Trained individuals on Oracle planning methods and applications.
Planner
. Forecasted initial build quantities for new packs through historical
demand analysis.
. Managed $7 million of inventory by analyzing product availability versus
demand.
. Calculated reorder quantities for CD Packs and components; the purchases
of which total $35 million annually.
. Analyzed and reported key performance indicators measuring the duration
and causes of inventory shortages.
The North Face; Privately Held Subsidiary of VF Corp, San Leandro, CA
(10/1998-04/2000)
Achievements:
. Created several key reports concerning cost analysis, margin
calculations, and average selling price.
. Lowered discontinued inventory by $9.2 million (36%) for Spring 2000.
. Improved global net order matching by $1.8 million in 1999 through
production reallocation.
. Developed Microsoft Access training materials and instructed individuals
to an intermediate user level.
Merchandise Analyst (Sales Forecast Analyst)
. Forecasted domestic wholesale demand for the largest product division
($76.5 million in 2000).
. Projected future inventory levels and calculated necessary quantities to
purchase at the SKU level.
. Compiled world buys - $140.5 million in 2000 - to optimize production
quantities, ensuring that all purchases satisfy minimum requirements.
TECHNICAL SKILLS
MS Excel (Macros, Pivot Tables, Charts, vlookups, etc.), MS Access, MS
Word, Peoplesoft Financials & Supply Chain Management, Peoplesoft
Query, Nvision, Oracle 11i, Cognos Planning: Analyst, Contributor
Administration, Cognos Business Intelligence: Analysis Studio, Report
Studio, Cognos Analysis for Excel (CAF ), Oracle Supply Chain Planner,
FRX Reporting
EDUCATION
B.A., Economics & Political Science (dual majors), University of
California, Davis, CA, 1998
Cumulative GPA: 3.42, Deans List Honors