Levi Anstine, C.M.

Experience

• 

  City of Colorado Springs

  Oct 2008 - Mar 2010

  Air Service Analyst

  Built business cases to pitch to airlines with data accessed from aviation statistical databases. Prepared monthly passenger and landing weight forecasts for airline rates and charges models. KEY COMPETENCIES: FORECASTING, FINANCIAL MODELING, ANALYSIS, EVALUATION, COST STABILIZATIONCreated stable forecast data associated with terminal and airfield cost centers to set prices• Developed accurate forecast models to project landed weight forecasts• Analyzed past trends in completion rate, load factor and other key data from future schedules• Applied current trends and past results to projected schedule to forecast landed weights and passengers Show less

• 

  Southwest Airlines

  Mar 2010 - Jan 2014

  Developed and managed financial models using regression and other forecasting techniques. Supported Network Planning with revenue, cost and profitability analysis. KEY COMPETENCIES: VALUATION, FINANCIAL FORECASTING, DATA GATHERING & ANALYSIS, COLLABORATIONPerformed assessment of high value acquisition slots and assets in LGA and DCA airports during procurement process• Gathered suggested capacity set from Network Planning and mature forecasted profitability• De-maturized forecast to demonstrate projected ramp-up profitability or loss by year after acquisition• Collaborated with Treasury team to determine current WACC and discount amount for NPV analysisKEY COMPETENCIES: STREAMLINING, ANALYSIS, CODING, DATABASE QUERY, PROCESS IMPROVEMENTReduced time for updates to FP & A reports from 4-8 hours to few minutes• Analyzed set up of current spreadsheet and mapped where data was stored• Consolidated spreadsheets to remove duplicate information and aligned data headers with Essbase• Introduced macros to extract data with VBA coding to limit need for human interaction Show less Lead Analyst on Business Performance and Analytics Team. Refined and coordinated cross functional strategies to ensure long-term market viability. Performed business analysis to detect commercial weaknesses and develop marketing remedies. Trained new employees in coding and analysis.KEY COMPETENCIES: DATA ANALYSIS, SQL, POWERPOINT, PRESENTATIONS, EVALUATION, COMMUNICATIONConducted presentations to Senior Marketing Leadership each Monday regarding business performance • Developed storyline and material at end of prior week• Analyzed trends Monday morning to ensure storyline did not change over weekend• Presented to CMO and direct reports in meeting Show less

  • Business Consultant - Financial Planning and Analysis

    Apr 2013 - Jan 2014

  • Analyst - Marketing

    Mar 2010 - Apr 2013
• 

  DFW International Airport

  Jan 2014 - Jun 2014

  Air Service Development Manager

  Analyzed passenger and schedule data extracted from aviation statistical databases to develop marketing and air service presentations for airlines. Attracted and retained domestic and international passenger and cargo airline service.KEY COMPETENCIES: REVENUE GENERATION, NETWORKING, LEADERSHIP, PROMOTION, CAPACITY BUILDINGIncreased airport revenues and promoted economic growth while keeping fares low• Networked at industry events• Developed and solidified relationships with key airline decision makers • Pitched cases for increased frequency of flights into and out of DFW Airport and new routesKEY COMPETENCIES: STRATEGIC PLANNING, CAPACITY BUILDING, ANALYSIS, PRESENTATIONSDeveloped business strategies to increase capacity in and out of DFW airport• Analyzed data from various databases to uncover trends matching current airline strategies and tactics• Created PowerPoint presentations to be used as tool to demonstrate case Show less

• 

  Southwest Airlines

  Jun 2014 - Sept 2018

  Coordinate base planning process to ensure alignment with planning and system metrics. Plan route base capacity set and optimize future schedules. Forecast new market segment costs and revenues.KEY COMPETENCIES: REVENUE GENERATION, ANALYSIS, EVALUATION, STREAMLINING, LEADERSHIP, PROJECT MANAGEMENTGenerated $115M in incremental passenger revenue despite being down 5% in fleet • Drove analysis team building 4Q2017 network, retiring 32 airframes overnight with 9 replacement airframes• Evaluated and removed underperforming flights according to fleet retirement plan • Reduced average length of flights to allow more seats per day per aircraftKEY COMPETENCIES: AUTOMATION, PROGRAMMING, SQL, ALTERYX, ANALYSIS, DATA MANAGEMENTAutomated core schedule metrics and revised all published schedules• Built models using Alteryx and SQL and wrote custom SQL script to pull necessary data from Teradata database• Programmed script into Alteryx build to categorize, cut, and analyze schedules automatically• Created datasets by automating data load into Tableau extracts and other easy to view formats Show less Lead analyst on Marketing, Business Performance, and Analytics Team. Developed training plans and materials, trained new employees and conducted follow up to optimize individual and team performance. Conducted weekly CMO and direct reporting to Marketing Leadership Team.KEY COMPETENCIES: SALES GENERATION, NEGOTIATION, COLLABORATION, MANAGEMENT, VERIFICATION, ANALYSIS, COMMUNICATIONDrove increase in incremental searches and bookings in Southwest’s sales funnel• Analyzed current revenue and booking performance to define needs• Negotiated marketable price points and collaborated to develop sale list and terms and conditions Show less

  • Senior Business Consultant - Capacity Planning

    Nov 2015 - Sept 2018

  • Business Consultant - Business Performance and Sale Planning

    Jun 2014 - Nov 2015
• 

  Monarch Air

  Aug 2015 - Sept 2018

  Flight Instructor

  Conducted Part 61 and Part 141 Flight and Ground Instruction. KEY COMPETENCIES: LEADERSHIP, TEACHING, COACHING, ANALYSIS, PERFORMANCE OPTIMIZATIONAchieved 100% pass rate on all students endorsed for checkride compared to national average of 76-77%• Developed and adapted personalized lesson plans for each student while adhering to FAA standards• Coached students for checkride with mock exam including both oral and flight aspects to identify weaknesses• Addressed and corrected weak areas before student examinations Show less

• 

  Pratt & Whitney

  Nov 2018 - Aug 2021

  Data Analytics

  Built and maintained data analytics capability for Oklahoma City operation. Delivered proactive insights to reduce part overhaul turnaround time (TAT).KEY COMPETENCIES: ANALYSIS, EVALUATION, STREAMLINING, INFORMATION SYSTEMSDeveloped company's first full life cycle reporting model for the engine repair development and overhaul readiness process• Consolidated highly fractured and unstructured data across 18 different source files • Developd risk-to-plan identification techniques with weekly automated report to impacted teams • Developed and presented to C-level executives insights and risks associated within the repair development processEnhanced and automated processes and procedures to increase data and report accuracy while reducing overall report lead time. • Mapped current processes and procedures using the ACE (Six Sigma) methodology • Developed automation using automation software (Alteryx) and embedded software languages (VBA)Forecasted weekly engine part movements within the operations warehouse • Developed automated historical trending analysis to develop program specific vendor turn expectations• Forecasted enhanced the operation teams ability to plan dynamic workforce to make workforce supply with demand Show less

• 

  InterVISTAS Consulting

  Aug 2021 - Oct 2024

  Director

  Lead InterVISTAS US Air Service Development Team. Provide data modeling and analytical support for various other aviation product lines. Developed data-driven business case studies for various United States and Canadian-based airport clients • Analyzed industry databases, including Diio and Sabre MIDT, to develop a compelling storyline for carriers • Provided client strategy recommendations for business case development and carrier meetings • Implemented process standards for calibrating and forecasting Lufthansa System's LiftPlan (QSI Forecaster)Lead various projects, including policy analysis, ACRP studies, and total market assessments for emerging technologies• Led various A4A regulatory analyses, including analysis on California's Meal and Rest Break Law and EU261• Published author as part of ACRP 03-62 team – A Toolkit to Establishing Airport Catchment Areas• Completed total market assessment (TAM) for an emerging seaglider manufacturerConstructed and manage RFP lead process to ensure the maximum visibility of potential future business opportunities• Analyzed and onboarded various RFP/RFQ tracking systems, including USAopps, Periscope, and Bonfire• Engage industry partners, including the ACI-NA ASD Steering Committee and AAAE NAC Planning Committee• Led airport and airline consulting group RFP/RFQ response strategies and executionDeveloped various aviation data models to provide insights to airport clients and regulatory affairs clients • Developed the company's first airline profitability model based upon DB1B, Form 41 cost, and T-100 data• Profitability model served as basis for A4A regulatory affairs projects, which included airline profitability review• Developed cell phone data analytics strategy using NEAR cell phone data insights Show less

• 

  Mead & Hunt

  Oct 2024 - now

  Managing Director