top of page

Most Recent Projects

Upcoming US Government Project

​

Will be serving a federal organization with assistance in the implementation of an Enterprise Resource Planning (ERP) system, including:

  • Understanding and evaluation of competing ERP systems;

  • Migration and ETL of data into the chosen system;

  • Re-engineering of migrated data as needed to facilitate planning processes;

  • Ensuring efficient inventory replenishment processes;

  • Adherence to best data governance practices.

A World-Leading Retailer

 

in 2021 and 2022, sub-contracted in service to a major retail client, also requiring demand forecasting models to better reflect the COVID and macroeconomic environment in their demand planning processes.

​

My duties here included:

  • Forecast data visualization:

    • "Big data" wrangling of massive demand forecast datasets for delivery into visualization software (using Python, PySpark, SQL in Google Cloud and BigQuery environments;

    • Creating data visualization reports (using Power BI Direct Query) allowing business users to consume:

      • Forecast model accuracy, to instill confidence in the forecast models;

      • Short and long-range units and revenue forecasts;

      • The impact of demand explanatory variables.

  • Baseline price forecast model development, enabling units forecasts to be converted to revenue.

  • Sourcing and updating of demand model explanatory variables.

​

A World-Leading Beverage Company

 

In 2021, sub-contracted in service to a major beverage company that required demand forecasting models to incorporate the impact of COVID and macroeconomic factors in client’s monthly demand planning process.

​

My part was to:

  • Write Python code to combine COVID-informed demand predictions with other competing forecasts or comparison.

  • Deliver those data to manager-specific spreadsheets that allowed managers to override demand predictions if needed.

  • Create and execute in-person training, videos and documents that instructed managers on:

    • the monthly demand planning process; 

    • how and when in the planning process to access the spreadsheets;

    • how to override forecasts within the spreadsheets and submit them to the demand planning system.

Sharing Knowledge

 

Since 2021, I volunteered to develop and teach a course called Introduction to Data Science for the University of Wisconsin - Milwaukee's College for Kids & Teens program. This two-week summer course, which I look forward to teaching in the future, is offered to students entering grades 9 through 12, and exposes them to:

  • Installing and configuring Python, R and Jupyter Notebook on their Windows, Mac or Chromebook machine;

  • Data analysis programming in Python and R;

  • Exploring data using visualizations (scatter plots, line charts, etc.) in Python and R;

  • "Big Data" and "Cloud" environments used in data science;

  • The basics of predictive model building (regression).

​

For more information on this course, please see https://uwm.edu/sce/courses/introduction-to-data-science/. I presented information on this course in the 2023 sySTEMnow Conference

​

bottom of page