John Schaefer

About John Schaefer

Experienced finance and analytics professional inspired by learning opportunities and…

Experience

1. Sr Financial Analyst - Revenue Strategy and Tools

   Comcast

   Jun 2016 — Present · Centennial, CO, US

   Perform ad-hoc and recurring analyses on revenue exceeding $15 billion in 2017 for the West Division of Comcast Cable within all six regions. Work cross-functionally with the Residential and Commercial Operations, Marketing and EBI teams to leverage available data sources and deliver insightful reporting-Utilize Teradata SQL, Oracle Essbase, MS SQL and Tableau to identify areas of opportunity and develop advanced reporting dashboards utilized by leadership to inform future business decisions surrounding promotional activity, rate events, product and packaging offerings and new initiatives-Mine large relational databases to isolate specific customer populations and track the financial impact of their migration activity on ARPU, Churn, MRM and other relevant financial metrics employing the use of multiple joins, case when clauses and volatile tables to accurately and efficiently process data-Develop financial modeling and individualized customer churn profiles on semi-annual rate events which yield $350M+ of incremental revenue per year across the Division. Utilize sensitivity and scenario analyses to assist senior leadership in optimizing the balance of incremental revenue and increased churn activity-Involved with long range planning initiatives, including forecasting revenue and subscriber performance one, three and five years into the future reliant on detailed historical analysis and knowledge of the competitive landscape-Create detailed promotional analyses for our CB team, evaluating ARPS by channel and connect dispersion across our products utilizing advanced SQL pulls and Excel formulas to identify and quantify activity at the service code level-Prepare monthly growth meeting deck slides utilized by senior leadership to monitor the performance of the business and adjust initiatives as necessary to ensure budgetary goals are being met-Comfortable working within compressed timelines including the ability to handle conflicting priorities.

Education

• University of Colorado Boulder - Leeds School of Business

  B.S. in Business Administration, emphasis in Finance

  2007 — 2011

Skills

• Marketing
• Microsoft Office
• Sales
• Leadership
• Time Management
• Adobe Marketing Cloud
• Data Analysis
• Business Analysis
• Management
• Budget Management
• Forecasting
• Retail
• Financial Analysis
• Customer Service
• Analysis
• Teradata Sql
• Financial Modeling
• Microsoft Excel
• Powerpoint