Karl Lewin

Responsible for forecasting maintenance expense (>$100mm/yr) on fleet of 130,000+ rail cars. Forecasting over multiple time horizons, monthly, annual and 3 year strategic plan. Automated large portions of the forecasting process reducing time spent preparing forecast by over 40% while also improving consistency and accuracy.

This used a combination of SQL, Excel and Python

Provided data and visualization support to find and understand key drivers to improve the reliability and availability of BNSF's locomotive fleet and tools for self service access to data.

Responsible for developing queries and reports that supporting the locomotive service excellence program.

Developed initial versions of locomotive performance dashboard.

Developed and supported various metrics pertaining to operation of BNSF's car and locomotive fleet, train performance and on time performance of rail car shipments.

Created reports and developed analysis tools to support initiatives to improve on-time train performance and understand empty car flow