Created a model to track the company's capital expenditures and the contracts of the company. This included the creation of a new financial model, and the development of a new tool to calculate the NPV.
Designed and implemented a new Excel based financial model to automatically generate reports using Essbase. The tool was used to automate the manual process.
Created and maintained the Hyperion financial system to track and report on the monthly sales and expenses. This included the creation of a new forecast tool, and the tracking of the actual cost of goods sold.
Senior Financial Analyst
San Diego City College
Created and maintained financial models for monthly flash reporting, annual budgets, quarterly forecasts, and monthly analytics. Conducted analysis of key performance indicators (KPIs), and provided insight into the business.
Analyze and interpret monthly sales compensation results using Excel and other business intelligence tools. Provide recommendations to improve performance.
Responsible for financial analysis for the CFO and CEO. The company is a key role in the development of the annual operating plan.
Analyze and interpret monthly variances and trends between actual results and forecast. Develop and maintain financial models to support business decisions.
Prepare and present monthly financial results to senior management. Review and analyze key performance indicators (KPIs) and provide recommendations for improvement.
Provide financial analytics to support the compensation plan and the annual budgeting process. Create and maintain Excel models to analyze and report on the business.