Steven Espinosa
Financial Planning Analyst · FP&A Department
Seattle, WAIn My Own Words
Experience in budgeting, financial forecasting, and variance reporting (plan v. actual) for over six years. Innovate problem-solver with remarkable analytical skills whose meticulous and pays close attention to detail. Proven team leader who is capable of training and supervising employees. Able to pull data from numerous different system sources and match the data to create a cohesive report to upper management. Advanced in MS Excel (Creative logic formulas by using commands such as If, Sumif, Match, Index, H-lookup & V-Look up) Strong Data Manipulation skills in MS Excel (Pivot slicers, conditional formatting & pivot tables) Proficient financial modeling skills (Understanding the importance of your assumptions and leave space to make the model dynamic for sudden request changes to the model) . Proficient in MS Word, MS Access (Create queries to present large data sets in summary level to upper management), Business Objects, Workday (FP&A Tool), Financial Management System (Ulti -Pro), and Adobe Acrobat.
Work Experience
Financial Planning Analyst
FP&A Department2015 – Present
Implement and supervise financial forecasting and variance reports for 2016 & 2017 Plan Budget. Improve / create financial models for FP & A by making them more comprehensive and user friendly. • Explaining financial plan variances to Market Financial Officers, analyze current and past trends in key performance areas such as revenue, cost of sales, expense, capital expenditures & medical cost. • Develop financial forecast models for all entities within Chen-Med by Market then by Center within the Market. • Created a business case and estimated the ROI to hire 10 case managers to reduce patient admissions to various Chen Med hospitals; which provided a 1M medical cost savings. • Impact Sales & Marketing by providing PAC (Patient Acquisition Cost) analysis. • Created controls to the new ERP (Workday) system for Cost Center's base upon job titles so there wouldn't be any inappropriate allocations of funds from a cost center perspective; which we will lead to more accurate forecasts to provide to Leadership / Upper Management.
Senior Capital Investment Analyst
FP&A Department2018 – Present
Implement capital and Annual Contract Value (ACV) projection models to provide analysis to the MCG executive team and Hearst corporations.
• Support area leaders in the development and prioritization of projects (capital planning). • Work with Product and Development Leaders on concise scopes of work, cost estimates, and detailed project schedules. • Coordinate contractor activities with Product managers and Director to anticipate and reduce the impact of overspending on projects. • Meet monthly with the Executive Leaders for Development & Product Team to coordinate and complete capital projects as well as align requesting for funding each month on current capital projects. • Develop, monitor, and maintain Capital FY Estimation; review cost estimates & identify any Risk or Opportunity to address to the Executive Team. • Develop and maintain forecast models. In-depth market analysis by geography, product, and channel. Analyze pricing strategies. Work with internal teams on competitive analysis. Examine end-user demand drivers. • 5 year Product ACV Monte Carlo Projection analysis with Triage Sensitivity results
Market Analyst
FP&A Department2017 – 2018
Implement and supervise financial forecasting and variance reports for 2016 & 2017 Plan Budget. Improve / create financial models for FP & A by making them more comprehensive and user friendly. • Train & assist several analysts regarding the comprehension of financial models & the impact of fully understanding the P&L. • Created financial modeling tools that demonstrate performance indicators, as well as highlighting trends and analyze causes of unexpected variance for R&O purposes. These financial modeling tools were presented to the Market CFO's which led to a major discrepancy finding of YTD Actuals - Company wide. • Significant involvement in business cases, estimate ROI for a new medical center which would add 1,700 new members and provide approximately 35M - 80M in revenue within 5 years. • Supervised and collaborated with an Intern on several projects; including the FTE cost center reconciliation which has significant impact on the 2018 Financial Plan.
Financial Analyst II
Finance Department2014 – 2015
Collaborated with the Sales Team to construct and improve upon the Sales Reporting / Compensation plan for the Sales team. • Perform a variety of special fiscal projects in support of revenue collection; ex: "bad debt". • Collect, analyze, evaluate and report data in order to increase sales productivity and to eliminate low selling products. • Collect sales records & trends and evaluate performance measured against sales quotas. cute ad-hoc headcount and expense. • Assist sales management, inside sales, channel sales and other sales related functions with various analytical, reporting and process change needs. • Responsible for Regional Sales Calls activity reporting and production of Regional Scorecards.
Analyst, Infrastructure IT
Citi Group2011 – 2014
Develop and integrated user-friendly reports to capture city-wide financial plan savings. • Provide monthly Financial Headcount for US RETAIL IT Citigroup which consist of over 5,000 employees and contractors. • Assist with the process of completing the SOW (Statement of Work). Monitor contractors that are involved in the SOW; verify all the expense codes are accurately aligned with the perspective contractor. Work with Procurement and Finance department to make sure the money of the SOW is distributed to the accurate WO (Work Order) that ties in with the expense code. • Communicate with Finance, Procurement, and Human Resource to answer various headcount and expense questions. • Summarize expense and personnel forecasting discrepancies in the spending plan, in addition to conveying said discrepancies to Accounting.
Billing Agent, Corporate
Hotel Gansevoort2010 – 2010
Answer any questions or concerns regarding any charges billed to the invoice.
Analyst, Mergers & Acquisitions
Mackenzie Partners2008 – 2009
Develop and integrated user-friendly reports to capture city-wide financial plan savings. • Analyzed legal and financial documents with the SEC concerning mergers, acquisitions, private placements, tender offers, annual Shareholder meetings and proxy voting.
Education
BA
FORDHAM UNIVERSITY2006
BA