Principle Focus

Strong professional goal-oriented team player who consistently exceeds

expectations with drive, energy, and a resolved determination to increase

the bottom line. Expert at MS Excel and has extraordinary SQL and analytic

abilities, always striving to achieve excellence and quality results,

paying attention to both the details and summaries. Applies innovative

methods to consistently add value and improve business processes. Highly

motivated to do whatever is needed for the success of the hiring manager

and the team he is directed to serve. A problem solver. Reliable and

dedicated.

Major Projects

GRO Enterprises, West Covina, CA

Built dynamically integrated Excel spreadsheets for company financial

services.

Department of Defense, Barstow, CA

Designed, built, and implemented new labor process using Access, Cognos,

and Excel Pivot Table tools, reducing cycle time from 2 days to 15-30

minutes.

Menemsha Construction Solutions, Hawthorne, CA

Designed, built, and implemented $140M cash flow database, models, and

trend reports using Timberline, Access, and Excel Pivot Table tools to

break six-month log jam on construction project for Chase Bank acquisition

of Washington Mutual.

CBS Television, Santa Monica, CA

Successfully mapped 2.5 million data records for divisional reorganization

and new Oracle application, performing system integration testing and

client validation, leading to prompt completion of contract.

Fox Studios, Century City, CA

Redesigned and implemented new automation for monthly reporting cycle,

reducing preparation time from 4 hours to 1 hour, significantly reducing

the error rate for manual data entry.

Paramount Pictures, Hollywood, CA

Built MS Access database and query mechanisms to successfully map and

integrate data for Dream Works acquisition for monthly close cycle. SIT

testing, MS Access database design, query creation.

Millennium Signs, Temple City, CA

Managed A/R and A/P, created financial system and spreadsheets, ordered and

managed supplies, performed financial planning and analysis.

E-Universe, Santa Monica, CA

Built P&L and BS spreadsheets. Cash flow. Financial Analysis and

reporting.

Highlights of Career Positions Prior to Consulting Career

Condor Systems, San Jose, CA (3 Years)

Manager of Financial Planning and Analysis: Held P&L, Balance Sheet, and

Cash Flow responsibility for $100 million company, including variance

analysis and collaborative budgeting:

Revenue recognition, EBITDA analysis, receivables and cash management.

Launched initiatives to improve processes, efficiency, and resource

allocation.

Developed target methodology to implement and close a 2-year-old unresolved

financial plan.

IBM, Santa Teresa Laboratory, San Jose, CA (13 years)

Held progressive responsibilities from Capital Planner Analyst to I/S

Financial Analyst to OH Financial Analyst to Balance Sheet Analyst to Site

Expense Planner to Product Financial Analyst to Lead Product Financial

Analyst to Business Analyst to Financial Plan and Measurements

Consolidator, managing highly complex requirements over a wide range of

financial and accounting duties:

Managed $200 million budget and supervised 12 analysts. Led team to

provide HQTR interface and develop presentations for senior management.

After building data warehouse through collaboration, initiated

reengineering efforts to implement Essbase forecasting process to save

$200K annually and achieved 99.8% forecasting accuracy 2 consecutive

quarters.

Revenue recognition and ROI analysis.

Dramatically increased productivity through process simplification,

automation, and enhanced reporting. Earned reputation in query access and

forecasting techniques.

Reduced data input process from 130 steps to 30. Achieved 89% reduction in

data errors.

Maintained high level of customer satisfaction despite 60% staff turnover.

Won year-end forecast contest by achieving within .01% of forecast.

Created effective sales model by analyzing requirements and designing

specs.

Built detailed financial model providing more efficient information for

product pricing.

Covered all aspects of $260M balance sheet. Write off analysis and

investment proposals.

Received on average 1 to 3 awards each year for personal and team

performance.

Gregory Olson, MBA, B.S. Accounting

902 Parkside, Azusa CA, 91702

626-***-****

abs0lw@r.postjobfree.com

Gregory Olson

Consultant

Skills and Experience

Financial:

Analysis

Planning

Modeling

Forecasting

Budgeting

Measuring

Reporting

Presentations and Proposals

EBITDA, ROI, NPV, Break Even, Etc.

Technical Implementations:

Data Warehousing

Process Reengineering

Tools and query building

Data Integration and Mapping

System Integration Testing

Target and Budgeting Methodologies

Cost Containment and Reduction

Process Documentation

Automation of Data Input and Output

Accounting:

Revenue Recognition

Cost Accounting

O/H and I/S Allocations and Rates

Gen and Sub Ledger Reconciliations

Systems and Controls

Inventory and Asset Management

Depreciation and Amortization

Cost Center Administration

Financial Statement Preparation:

P&L, Balance Sheet, Cash Flow

Trend and Variance Analysis

Industry Lines

Software Development

Manufacturing

Entertainment

Construction

Department of Defense

Computer Applications

MS Office

SQL

Cognos

Oracle

Essbase

Hyperion

Timberline

Office Connect

IBM QMF

Education

MBA

BS Accounting, Magna Cum Laude

Other

Book Author

The Banks Have Tricked Us

Contact this candidate