Transportation Specialist

Steve Trimpe

*****.******@*******.*** *** Ridge Meade Dr.

214-***-**** Lewisville, Tx. 75067

SPECIALTY

I use powerful technologies to extract, organize, and synthesize data to all levels of management. I work to improve a collaborative, team environment to the determine the best solutions to improve the company’s performance/profitability.

PROFESSIONAL EXPERIENCE (American Airlines)

Sr. Analyst - Revenue Management 2018 – 06/2020

-Created tools used by Pricing, Sales, and Revenue Management to improve revenue decisions.

oEntity market share reports, analyzing market share across industry.

oCombined Travel Management Company (TMC) reports, providing a comprehensive review of these top 5 sales outlets.

oCross-alliance booking pattern report to leverage new booking capabilities

oWeekly/monthly/adhoc reports on Contrated Pricing programs

-Departmental SME on data sources to improve departmental knowledge

oHistorical (flown) data, advanced booking data, pricing data

Sr. Analyst - Operations Engineering 1999 –2018

-Produced annual and monthly fuel volume forecasts for fuel operations and financial budgeting, providing forecasts of 2B gallons annually, or $4B

-Improved reporting against the forecasts with new waterfall charts to explain variances.

-Drove fuel conservation efforts by timely reporting on fuel policy progress.

oCompiled data for international fuel reserve reduction, saving $3M annually.

oLed Dispatch Performance Related Pay (PRP) analysis, reducing fuel levels to save $12M annually.

oStreamlined fuel tankering reporting to enable Flight Dispatch and Fuels Management to capture $34M annually through effective fuel planning.

oProvided seasonal updates to essential flight planning parameters

oMaintained alternate and diversion statistics to improve dispatch flight planning.

-Provided influential operational/regulatory reporting.

oAircraft routings to tax department to maximize tax savings at Federal and State levels.

oYearly fuel statistics to IATA to support worldwide fuel conservation.

oWeekly DCA curfew operations to limit noise violations.

-Enhanced and improved key departmental tools

oDeveloped new forecasting system for merged airline (AA/US)

oCoordinated enhancements to operational database with external consultants.

oTransitioned operation data from mainframe flat files to relational data warehouse.

PROFESSIONAL EXPERIENCE (American Airlines)

Sr. Analyst - Cargo Division 1992 – 1999

-Accurately forecasted freight capacity to improve cargo handling performance.

-Implemented yield improvement actions to increase revenue in key markets by 5%.

-Developed automation for Cargo Pricing/Revenue Management.

oRevenue Per Available Position (RAP) Reports to focus sales efforts on most valuable products.

oDaily Cargo Sales Report

oCustomer identification usage

oPriority Parcel (PPS) receipt compliance

Analyst - Passenger Yield Management 1990 - 1992

-Improved passenger revenue performance in Southwest competitive markets through inventory control strategies to maximize oversale/spoilage tradeoff.

-Coordinated activities of Market Manager and Market Specialists in a team environment.

EXPERTISE

Forecasting Programming (SAS, SQL, JCL)

Data Mining Reporting (Excel, Tableau, PowerPoint)

Data Visualization Market/Trend Analysis

Building collaborative teams Passion to dig deep to find answers

EDUCATION

Bachelor of Business Administration in Management & Transportation, The University of Texas at Austin

Contact this candidate