Post Job Free

Resume

Sign in

Excel Modeler

Location:
Winnetka, CA
Posted:
December 02, 2019

Contact this candidate

Resume:

Steven Erickson

202-***-**** aday3v@r.postjobfree.com

Experience

Contemporary Services Corporation (CSC), Los Angeles, CA 2017 - Present Finance Director

Manage budget ($125M to $255M), forecast, capex, cash flow & debt financing for all reporting (GAAP).

Support decision making for Regional Directors on business development, strategy, pricing & contract negotiation.

Implemented a mobile BI system, reducing debt financing expense 8% & increasing contract pricing revenue 14%.

Identified and lead migration to a new payroll system, improving compliance & reduce cost 18%.

Responsible for finance, accounting, project management, treasury, analytics & business development teams (13 FTEs). MediaNews Group (MNG), Los Angeles, CA 2014 - 2017 Financial Manager, Sales Revenue

Improved models for revenue, budget ($140M to $410M), forecasts, dashboards & private equity reporting (GAAP).

Closed M&A transactions, synergy models, diligence, data-room analytics, consolidation & integration.

Overhauled comp/commission/bonus plans increasing revenue 12%, account retention 8% & reducing COGS 16%.

Developed & reviewed 3 analysts that completed all KPI metrics, board decks, long-term planning and close reporting. Rubicon Project, Los Angeles, CA 2011 - 2014

Senior Financial Analyst

Built Finance Department: revenue, budget ($20M to $700M), forecast, KPI metrics, equity and big-data analytics system.

Worked directly with investment banks through strategy, compliance, diligence securitization, S1 reporting to IPO (RUBI).

Facilitated multi-investor venture rounds, allocating funds toward operating & capex investment ($11M).

Integrated: multi-location data centers, Quickbooks to Oracle, Salesforce, Anaplan & Microstrategy data dashboards. Warner Music Group, Los Angeles, CA 2008 - 2011

Senior Financial Analyst

Prepared revenue analysis models for digital licensing, publishing & royalties budget ($260M) (GAAP Standard).

Integrated various analysis for business KPI projections, software implementation (Oracle to SAP) & legal contracts.

Managed & reviewed 2 analysts to significantly improve monthly close process. KPMG, Washington, DC 2007

Finance Associate

Audited CDO portfolios for investment banks, creating analytical models combined with Bloomberg analytics. Washington Nationals Baseball Team, Washington, DC 2005 - 2007 Accounting Analyst

Constructed & maintained revenue, budget ($103M), forecasts and banking analytical models.

Teamed with sponsorship for growth 60%, operating cash flow of $45M & charitable fund of $5M annually. Education

University of La Verne, La Verne, CA 2015

MBA

St. Cloud State University, St. Cloud, MN 2005

Bachelor of Science, Finance

Worked 30+ hrs/week, with a full course load; competed in a Division I sport (All-Star level).

Investment Club board member; Member of the Real Estate Association & E-Commerce Club. Skills/Other Interests

Advanced proficiency: Microsoft Office Suite (highest level certification, Excel modeling instructor), SAP, Hyperion, Great Plains, Quickbooks, Oracle (NetSuite), Apples, AS 400, Collateral Analytic System, Sage, SQL, Microstrategy, Salesforce, Cognos, Mactive, Anaplan, Adaptive Planning, Power BI, Dynamics, Domo, Looker, Tableau, Prophix, Epic Systems, Cerner.

Certified medical first responder & traveled North America, Europe, South America, Central America, NZ & Africa.



Contact this candidate