Jonathan T. Oxborrow

Analytics, Pricing, S&OP/IBP, and Forecasting Professional

209 Court Drive
Washington, IL 61571

Experience

Analytics Manager - Parts Pricing

Manages a team of Data Engineers and Data Scientists providing analytics and cloud system support for the Global Aftermarket Parts Pricing and Sales Variance Division. Has fulfilled the role of Data Steward for aftermarket parts pricing data. Has fulfilled the role of IT owner for key pricing systems including AWS, Snowflake, and new parts pricing system. Responsible for supporting corporate data governance and security efforts. Provides thought leadership in analytics and systems.

Primary responsibilities include automation and modernization of pricing and sales variance processes, planning and directing analytics projects, and recruiting and developing data science talent. Also, supporting and leading key multi-year data efforts in the implementation of the a new multi-million dollar pricing system. Drives system and reporting modernization.

Senior Analytics Team Lead

Coordinates day to day Caterpillar Part Pricing Analytics activities and task management using modern DevoOps tools. Supports pricing automation efforts as well as pricing studies using the R language. Directly responsible for pricing $75 million in annual parts sales and over 150,000 individual part numbers. Provides programming support of data engineering efforts in PySpark. Experienced creating analytic apps and dashboards with Alteryx and Tableau respectively. Coordinates parts pricing project efforts and supports personnel and resource management.

Key Results:
  • Co-authored Global Parts Pricing Analytics Team Reorganization.
  • Designing Parts Pricing Analytics Pricing Automation Evolution Roadmap.
  • Provides team leadership in Advanced Analytics and Data Engineering.
  • Interim data steward delegate and technical leader in AWS, Snowflake, R, Python, Alteryx and PowerBI.
  • Leads automation and reproducible reporting efforts (i.e. AMC, TAP Insights Reporting, and more).

S&OP Coordinator - Analytics

Led data efforts for new forecasting system implementation. Prepared first centralized Energy & Transportation scoped hierarchical statistical forecast. Engineered first industry standard forecast accuracy metric for Energy & Transportation. Managed setup of Energy & Transportation S&OP analytics server.

Key Results:
  • Led data implementation for cloud based forecasting system with external vendor.
  • Implemented analytics server for increased automation and analytics.
  • Championed data governance and validation processes for forecasting system and reports.
  • Built consensus across industry groups for key analytics initiatives.
  • Prepared centralized E&T scoped statistical forecast, driving demand forecast accuracy.
  • Developed and coached S&OP Analytics Team.

Machine Demand Forecaster

Prepared the Demand Forecast and Long Term Forecast for mining product. Forecasted over $3 billion in annual revenue. Mined Haver databases for leading indicators. Used these indicators in a machine learning model for mining industry sales. Developed Excel based forecasting tool for the division.

Key Results:
  • Developed monthly demand forecast and annual Long Term Forecast for L&H product.
  • Managed key forecast stakeholders, with competing objectives, to generate forecast consensus.
  • Prepared forecast analysis for upper management in Executive S&OP meetings.
  • Presented monthly to product managers on forecast changes and performance.
  • Mined economic databases for leading indicators for machine learning models.
  • Developed Excel/VBA based forecasting system for use across the division.

Regional Economic Analyst

Prepared the North America economic forecast proposal, including GDP, inflation, interest rate, construction and mining activity forecasts. Also prepared North American machine industry sales forecast. Supported the company business cycle monitoring processes.

Senior Economic Analyst

Provided economic forecast proposal for the United States and Canada. Enhanced the U.S. GDP forecast through the use of chaining to ensure hierarchical forecast consistency. Authored Canada economic summary for Board of Directors meetings.

Key Results:
  • Prepared North American economic forecast (GDP, CPI, PPI, interest rates, IP forecasts).
  • Enhanced the U.S. GDP forecast using chaining to ensure hierarchical forecast consistency.
  • Prepared North American machine industry sales forecast.
  • Authored Canada economic summary for Caterpillar Board of Directors meetings.
  • Managed and communicated North America PINS/market share assumptions to the organization.
  • Prepared worldwide long term exchange rate forecasts.
  • Supported business cycle monitoring processes and various enterprise initiatives.

Economic Analyst

Maintained Latin America databases and monthly business processes. Provided translation of relevant Spanish language news material. Assisted in the preparation of written economic assumption reports for Business Plan and Long Term forecast.

Senior Quantitative Analyst

Responsible for the maintaining databases and monthly processes for Asia Pacific and Latin America. Assisted elsewhere as necessary.

Key Results:
  • Maintained and monthly processes for Asia Pacific and Latin America.
  • Translated relevant Spanish language economic articles.
  • Assisted preparing models and reports for Business Plan and Long Term forecast.
  • Assisted in on-boarding new analysts and interns.

Education

M.A. Economics

Illinois State University (May 2005)

Received a M.A. in Economics with a GPA of 3.41. Coursework included an above average load of econometrics, statistics, and labor economics coursework. The Master of Arts degree required demonstration of the command of a foreign language.

B.A. Economics

Brigham Young University (December 2002)

Received a B.A. in Economics with a GPA of 3.19. Coursework included a number courses in mathematics, computer programming, and Spanish. Bachelor of Arts required additional mathematics.

Certifications

Machine Learning & Artificial Intelligence

ML and AI Certification, UC Berkeley

Date Earned: 2025-03

Data Strategy

Data Strategy Certification, UC Berkeley

Date Earned: 2024-04

Amazon Cloud Certifications

AWS Certified Cloud Practitioner

Date Earned: 2023-08

Professional Forecaster

Institute of Business Forecasting and Planning (June 2010 - June 2014)

Earned the designation of Certified Professional Forecaster from the Institute of Business Forecasting and Planning (IBF).

Economic Measurement

National Association for Business Economics (October 2011)

Earned the Certificate in Economic Measurement from the National Association for Business Economics (NABE).

Core Proficiencies & Skills

Leadership

  • Communication ‐ Demonstrated strong communicator, both verbal and written.
  • Ownership ‐ See things through. Takes responsibility for outcomes.
  • Integrity ‐ Honest, consistent, fair, driven by principles.
  • Teamwork ‐ Functions well as part of a team, both as lead or team member.
  • Goal/Result Oriented ‐ Sets goals, prioritizes activities to achieve best outcomes.
  • Continuous Learner ‐ Always investigating job relevant emerging technologies.

Analytics & Productivity

Programming Languages & Software

  • Proficient: R, RMarkdown, SQL, git, and MSOffice/VBA.
  • Experienced: Tableau, Python/Pyspark, SAS, STATA, EViews, shell scripting.
  • Functional: Power Automate, Office Script, Javascript, C/C++, docker

Statistics & Analytics

  • Proficient: Time Series Modeling & Forecasting, Seasonal Adjustment, Regression/GLM
  • Experienced: Classification, Simulation, Machine Learning, Survival Analysis
  • Functional: Network Analysis

Language

Reads, writes, and speaks Spanish. Lived in Chile for two years from February of 1997 to February of 1999. Took Spanish coursework and proficiency exams while in college.

English Native.

Additional Projects & Activities

YNABR

This github project is an API client package for the You Need a Budget web application for downloading data. It is implemented in the R programming language.

XRANDRGUI

This github project is an experimental GUI for the xrandr Linux commandline utility, implemented in Python.

BYU-Idaho

Online Instructor - Econ 150: Microeconomics, Fall 2021 - present.