John Panner

Experience

• 

  University Housing - The University of Georgia

  May 2016 - Sept 2016

  Desk Assistant

  • Applied customer service skills by working directly with residents to ensure satisfaction.• Followed appropriate policies and procedures with regards to working the 24-hour front desk, including, but not limited to: key control, equipment check-out and the monitoring of the security system.• Supported the community office staff by performing administrative responsibilities assigned effectively and efficiently.

• 

  PepsiCo

  May 2017 - Aug 2017

  Operations Intern

  • Utilized hands-on experience to develop foundational knowledge of PepsiCo’s daily operations• Worked alongside both bay and bulk delivery drivers to deliver product to customers in small and large format accounts• Assisted the Reset Specialist team in rearranging cold vaults to match merchandising standards and customer specific planograms• Performed merchandising duties across Walmart and grocery channel

• 

  Royal Caribbean Cruises Ltd.

  Jun 2019 - Aug 2019

  IT Operations and Shipboard Technology Intern

  • Collaborated with program manager in the planning phase of $900,000 project to install 1500 smart TVs in major cruise ship revitalization.• Served as a key point of contact between project manager and project stakeholders, managing and scheduling meetings and communication plans regarding project among internal and external team.• Interfaced with project management team in an agile environment to create various reports presenting overall program status, ensuring that key milestones were achieved on time and on budget. • Gained international business experience while working in Singapore and Barcelona; one of four interns selected from group of over 100 to provide intern testimonial for company’s career page feature. Show less

• 

  Chewy

  Jun 2020 - May 2024

  • Managed daily promotional activity totaling 97k distinct promoted SKUs in 2021. Acted as key point of contact for any questions regarding the execution of promotions, hosted educational workshops on the promotions process for Category Managers, and created onboarding documentation for new team members.• Partnered with cross-functional teams (e.g. Site Merchandising, Category, Supply Chain, Marketing, etc.) to ensure successful execution of site-wide tentpole event spanning Black Friday through the holiday season. Show less • Built and automated business review distributed weekly to senior leadership encompassing assortment size, inventory cost, and publication/inventory status for all SKUs in the catalog. Organized key discussion points and facilitated conversation during each meeting.• Took ownership of previously outsourced Python script used to import product attributes from Excel file into internal system. Quickly gained understanding of the script required to add new attributes and input validation, ensuring latest content and site merchandising requirements were sourced from vendors.• Implemented revised Jira ticketing process requiring forms containing all necessary inputs for quick action by operations team, reducing re-work and extended communication previously required on 20% of tickets.• Created Tableau reports highlighting inconsistencies in vendor number entered at time of item setup compared to expected vendor number for SKUs within the same brand/category/merchandising classification, as well as POs rejected by EDI system due to incorrect vendor number or cost inputs. Show less

  • Program Manager

    Mar 2024 - May 2024

  • Pricing Manager

    Apr 2022 - Mar 2024

  • Senior Pricing Analyst

    Oct 2021 - Apr 2022

  • Merchandising Analyst

    Jun 2020 - Oct 2021
• 

  Subway

  Jun 2024 - now

  Manager, Business Intelligence and Analytics