Sam Bentley

Experience

• 

  On the Money, LLC

  Jan 2020 - May 2021

  Accounting/Analytics Intern
• 

  Highnoon

  May 2021 - Apr 2022

  • Became the analyst responsible for two of the largest clients reporting needs. Included in this is the creation, verification, and eventual delivery of both ad-hoc and standard cadence reports to clients.

  • Data Analyst

    Sept 2021 - Apr 2022

  • Analytics Intern

    May 2021 - Sept 2021
• 

  Amazon

  Apr 2022 - now

  • Developed and maintained reporting pipeline for Inventory Health reviews, used by senior leadership to drive decision making. Coordinated with PMs to arrive at metrics that better informed the business as well as the goals being tracked towards. Included in this was Inventory spread, optimal cubic inventory levels, regional in stock %, incoming purchase orders, and weeks of cover (WoC) forecasting.• Oversaw the migration and recreation of 27 + high priority queries from MySQL to PostgreSQL in Redshift ahead of a Database consolidation. Utilized deprecate first mentality that allowed for a 100 + query impact radius to be tightened down to the final query sets without impeding Business function.• Leveraged Apache Spark and SparkSQL to reduce cost across distributed nodes when building out data pipelines.• Created production pipeline and definitions for determining excess cubic inventory, covering roughly ~160k individual product sets weekly. This is used by inventory health teams to inform buying decisions and drive product spread. Show less

  • Business Intelligence Engineer

    Jan 2024 - now

  • Business Analyst

    Jul 2023 - Jan 2024

  • Data and Reporting Analyst

    Feb 2023 - Jul 2023

  • Lead Transportation Specialist

    Apr 2022 - Feb 2023