Randy Koliha

Experience

• 

  W.S. Badcock Corporation

  May 2022 - Jul 2022

  Ecommerce Analyst Intern

  Projects: Abandon Cart, Workflow improvement (Power Automate), General front end website maintenance (tagging, HTML, lighthouse runs)oAbandon Cart Study (SQL, Excel) - In the study, I collected raw SQL data and stitched together data from Google Analytics to understand the customers’ behavior. Specifically, abandoned cart reminder emails and their respective conversion rates.

• 

  Coca-Cola Beverages Florida

  May 2023 - Jul 2023

  Manufacturing and Supply Chain Intern

  Projects: Manufacturing process learning, Transportation modeling process learning, Projecting Sales & Volume (SAP, Blue Yonder), MLR sales and promotional dataoMLR Modeling of Publix Nielsen Data (R, Excel) - In the study, I collected Nielsen sales data of Publix stores and cross-referenced that data with Publix promotion data on Coke Beverages Florida products. Specifically, how the influx of promotions and different combinations of ads will drive sales/volume.

• 

  Publix Super Markets

  Apr 2024 - Jul 2024

  Manufacturing Production Planner

  Summary: Manufacturing production planning of the sandwich section of Publix stores.oSAP Planning (SAP) – I utilized planning software and statistical/planning knowledge to ensure that materials and orders were fulfilled efficiently. I ensured that forecasted products and materials for each product are followed, maintained, and processed. I also ensured strong communication with suppliers and the production facilities to enable proper supply chain flow.

• 

  Starboard Group

  Jul 2024 - now

  Summary: Planning Coordinator for the fashion watches category; PO creation, maintenance, and tracking. Category weekly reporting covering top-level conversion rates, sales, and volume drivers.oNAV PO Creation and Maintenance (Navision) – I use Microsoft Navision to create purchase orders with Excel based on cruise line needs and help facilitate shipping documentation for a smoother supply chain. I also ensure timely delivery and correct POs when data discrepancies or changes occur. I also produce weekly reports about top-level information for the team to learn about our category's performance. Show less

  • Retail Planning Budget Analyst

    Mar 2025 - now

  • Planning Coordinator

    Jul 2024 - Mar 2025