Operations Research Analyst and R Developer

Resume posted by tsterle in IT.

Desired position type: Any
Location: Dayton Ohio, United States

Contact tsterle

Summary

• Twenty-three years in simulation, operations research, data analytics, and software development
• Innovative creator of original, unique methods and algorithms for custom applications; prolific coder
• Proven record representing complex systems and operations in the logistics, transportation, and retail domains
• Proficient in R, Simul8, Extend/OR; limited experience with Unix, C++, VBA, and CPLEX

Education

M.S. Operations Research, Air Force Institute of Technology, WPAFB OH, 1993

B.S. Chemistry, John Carroll University, Cleveland OH, 1985

Experience

Operations Research Analyst, Kroger Technology, Blue Ash OH                      Sep 2008-Mar 2016

 

  • Independently developed an alternative routing engine for outbound transportation
  • Over 100K possible load and route configurations generated from orders by product type
  • Found lowest cost route set fulfilling all orders, subject to trailer capacities, load sequencing, delivery windows and maximum deliveries per order
  • Route plans reduced delivery costs by 2 to 3% and hourly warehouse volume variance by 50%

 

  • Designed a desktop application to find the set of trip assignments minimizing the drivers needed per work shift, while hitting targets for mileage allocation to carriers
  • User can import two different sets of route files and cut off portions of each to match shift times
  • Converts cryptic route files to conveniently display trip stop times, salvage pickups, hours, miles
  • Handles pre-assignment of selected tours, and transmits output directly to carriers
  • Consultant estimated annual savings totaling $700K to $1M

 

  • Independently created and coded a suite of methods for computing one of two main input quantities (called the “MIN”) for the automated ordering in all 2,500+ stores
  • Converts input sales, forecast, item, and planogram data to structures allowing speedy processing
  • Identifies seasonal items using a method recognized as “clever” by a senior customer analyst
  • Zeroes in on 10 representative time periods for simulation, then tracks balance-on-hand, sales/demand, deliveries, and costs due to lost sales, inventory, and restocking
  • Finds lowest cost MIN, and an alternate presentation MIN using standards set by business rules
  • Analyst can tune parameters using trade-off data from experimental results tables

 

  • Built detailed checkout lane simulations to compare the efficiency of various single-queue systems
  • Intricate, adjustable logic controls each customer’s lane selection and movement from queues
  • Developed a version with multiple queues for comparison, calibrating it with actual utilizations
  • Provides key insights into what conditions might favor the single queue system

 

  • Devised/coded a complex procedure to compute recommended shelf allocation quantities
  • Formulated a regression model based on how often the current allocation fell short of both daily and between-delivery sales
  • The new recommended allocations align shelf space with product movement, and enable new products to be introduced in the reclaimed space

 

  • Developed a simulation of a proposed new operational concept for certain distribution centers
  • Complex logic controls the job sequencing and movement of special vehicles as they transfer cases from vendor pallets and take completed store pallets to the shipping area
  • Analyzed results to identify potential show-stoppers such as vehicle congestion and a significant imbalance between inbound and outbound volume for many products

 

 

   Modeling/Simulation Analyst, Kelley’s Logistics Support Systems, Fairborn OH         2006-2008

 

  • Designed and developed a generic simulation of complex manufacturing or maintenance operations
  • Used the Extend/OR modeling suite with Excel worksheets for input and output
  • Detailed stochastic model can optimize process inputs such as personnel and equipment levels, part stocking and reorder policies, task sequencing, and work schedules

 

  • Created an original simulation of sustainment activity for a key military vehicle, in response to an urgent customer need
  • Processes thousands of missions, sidelining vehicles for failure and damage repairs, as well as scheduled maintenance
  • Determines which of over 200 parts are needed for each repair, and tracks inventories and resupply
  • Analysis capability allows 15 major inputs (such as time-to-failure and repair times) to be adjusted to determine effect on mission completion rates, and time in each mission capability status category
  • Over 25 output charts are automatically generated, facilitating analysis of logistics support concepts to increase the operational availability of a critical combat system

 

Skills

  • R (7 years)
  • Simul8 (2 years)
  • Extend/OR (2 years)