John Dyer

**** ******* ******, *** ****, CA *****

Mobile 408-***-**** acplvp@r.postjobfree.com

Financial Analyst

PROFILE OVERVIEW

Well rounded Analyst with more than twenty years of corporate experience in

the areas of finance, operations, IT, sales and marketing with both start-

ups and well established companies. Recognized for innovative solutions to

analytical problems that have made a significant contribution to the

financial stability of the companies he's worked for.

AREAS OF EXPERTISE AND MAIN CAPABILITIES

iProcurement Google Analytics OIC Certified Strategic Financial

Planning Advanced Excel

Financial Reporting Financial Modeling/Analysis Forecasting Hyperion

Essbase MS Project

Google Docs Benefit Cost Analysis Budgets Smartsheets KPIs

Advanced PowerPoint

Expense Analysis Dashboards Variance Analysis Pivot Tables

Performance Reporting

PROFESSIONAL EXPERIENCE

Financial Analyst - Contractor

Cisco, San Jose, CA Apr 2015 - Current

Responsible for procurement and budget activities in the Enterprise PSM

- Strategy, Planning and Operations department.

. Proofed and edited SOWs submitted for approvals. Entered SOWs into the

Oracle iProcurement module, tracked project requests and provided

notification of purchase order codes.

. Created new reporting scheme for procurement and spending performance.

. Created, reformatted, distributed and maintained Smartsheets for the

department heads.

. Assisted Finance with quarterly close activities.

Founder & Principal

Commutercost, Los Gatos, CA Oct 2012 - Current

Developed groundbreaking Commutercost calculator and supervised

implementation of website.

. Created Excel version of cost calculator that supports vehicle and mass

transit commuting with the Google Maps interface. Directed development

of website that provides the customer a personalized detailed report of

itemized costs and most importantly their effective wage based on

mileage, time and other contributing factors.

. Accomplished customized financial benefit cost analysis for clients

through excel modeling.

Finance Area Lead / Project Manager - Contractor

Cisco, San Jose, CA June 2010 - July 2012

Responsible for sales compensation and goaling activities for recent

Cisco acquisitions.

. Point man on annual sales goaling activities for new acquisitions at

Cisco. Enjoyed an unwavering connection collaborating with Human

Resources, Sales Management, Sales Comp, Financial Analysts and

Controllers - created and maintained goal metrics and revenue targets for

400 sales agents compensation contracts worldwide. Expert in OIC

(Oracle Incentive Compensation) system and SHARE. A good working

knowledge of SFDC and Zoho CRM.

. Lead weekly status meeting involving 13 global corporate teams ensuring

method, milestones and deadlines were documented in preparation before Go

Live. Revised Compensation plans and sales territories when business

required change in strategy.

Business Analyst - Contractor

Accelerate-IT, San Jose, CA Jan 2009 - July 2010

Responsible for managing customer database, performance reporting,

budgeting, analysis.

. Created and maintained customer internal data in Excel. Performed

various reporting tasks, whatever was needed for this small startup.

Wrote specifications and requirements.

Marketing Analyst - Contractor

Incline Productions, Los Gatos, CA Jan 2008 - June

2008

Responsible for importing, merging, analyzing and reporting on

marketing data.

. Created and maintained millions of units of internal customer data by

identifying optimal targets, generating list pulls, supporting marketing

efforts for new customers and creating reports in PowerPoint. Manipulated

Pivot Tables to create detailed presentations targeting thousands of

companies.

Budget/Financial Analyst - Contractor

Levi Strauss & Co., San Francisco, CA Aug 2006 - Jan

2008

Responsible for departmental PERs, reporting, budgeting and cost

analysis activities within IT.

. Performed monthly, quarterly and annual close, journal entries,

forecasting and procurement. Created Macros to streamline the monthly

close process. Created and distributed the monthly reports that detailed

the most important financial and operational metrics for the CIO.

. Maintained consistent contact with budget owners and finance reps,

ensuring accurate and timely updates are provided and issues flagged.

Built robust and meaningful relationships with all key operational

stakeholders, troubleshooting problems with Accounts Payable,

Procurement, vendors and internal groups.

. Reported monthly, quarterly and annual spending & head count figures for

IT departments. Updated Cost Center sheets and staffing plans. Coded

purchase orders in Ariba.

. Interacted directly with project teams to develop business case

documentation for major and minor projects. Prepared Project Expenditure

Requests (SOWs) in support of CIO organization totaling more than

$75,000,000. Collaborated with all levels of management and stake

holders to get project financing approved 100% of the time. Ensured that

the descriptions, goals and financial impacts were clearly defined for

approvals as prominent as the board of directors and CEO. Used MS

Project to track and audit IT Project costs during production phase.

Senior Project Analyst

Etak and Tele Atlas North America, Inc., Menlo Park, CA July 1987 - April

2005

Responsible for all departmental reporting, budgeting and cost analysis

activities in Operations.

. Performed accurate forecasting, strategic planning, corporate reporting

and budget vs. actual variance analysis in a growing company. Created

and maintained project Key Performance Indicators and Cockpit charts

(Dashboards). Experience also includes compiling and reporting on

competitor data and patents. Access to and maintained extremely

confidential information. In nearly 18 years of employment at Tele

Atlas, received 15 promotions.

. Ensured all project and departmental budget owners stay with their

forecasted financial constraints. Informed budget owners of problem

areas and suggest solutions to solve complex/simple problems. Managed

monthly, quarterly, and annual budgets ensuring real-time, ongoing

monitoring and reporting of all finances and budget expenses. As a

member of the senior staff, directly reporting to the Senior Vice

President of Operations and Technology, maintained budgets and head count

for 15 divisions totaling 290 individuals in the USA and 550 overseas

contract workers located in India. Successfully managed Operations and

Engineering budgets where 95% of months did not exceed forecast spending.

. Designed advanced excel models to develop project cost estimation,

manufacturing analysis and company-wide reporting for all major

Operation's initiatives including annual shareholder reports and company

mergers. Produced and distributed monthly, quarterly, annual and long

term financial/operational achievements and goals for distribution to all

levels including the company board.

. Ability to work on multiple projects simultaneously. Developed and

managed custom projects that had the largest impact toward creating and

expanding new markets. Performed beta testing on software. In the role

of Custom Mapping Manager in support of Sales, created over 100 project

cost estimates supporting 56 customers and balancing engineering, mapping

and management resources, delivering an average of two certified products

per week. Prior to my leadership, an average of two certified products

per quarter were delivered.

EDUCATION

Bachelor of Arts Degree, San Jose State University, CA

American Production and Inventory Control Society, Accounting, Bills of

Materials/Engineering Change Order Concepts and Fundamentals, Master

Production Scheduling Fundamentals, Materials Requirements Planning

Fundamentals, Fundamentals of Inventory Management, Manufacturing

Fundamentals Overview

Contact this candidate