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
**********@*****.***
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