Trevor Smith Email & Phone Number

Memphis, Tn, Us

Memphis, Tennessee, United States

Memphis, Tennessee, United States

- Managed team of four senior analysts, two analysts and two software engineers, responsible for salesfloor planogram and flexogram operations, inventory replenishment, tool development, technical support and analysis for 30+ categories and 6,400 stores- Oversaw 90+ scheduled jobs for ETL pipelines, reporting, and DB maintenance- Administered team website and servers, developing and supporting 40+ tools for planogram operations, analysis and project management- Optimized automotive battery assortment and space, resulting in a 5% lift to DIY retail ($75M annual), while reducing inventory by $10M+- Introduced store-specific assortments for passenger car motor oil, resulting in a 1.5% increase in DIY sales, worth $15M when scaled to chain- Optimized space allocation for washer fluid in cold markets, resulting in a 10% lift in retail, quantity, and GP for the impacted SKUs- Led effort to optimize value and premium clusters for wipers, resulting in a 2.3% increase in DIY quantity in premium-to-value stores, and a 3.8% increase in DIY retail in value-to-premium stores- Redesigned assortment planning tool used by category managers and visual merchandisers, significantly improving UX and automating validations, resulting in a 5% reduction in analyst workload

Menomonee Falls, Wisconsin, United States

- Played key role in executing de-densification initiative, reducing fixturing to align with inventory plans and improve store experience- Helped to lead macro optimization process, providing analytics and directives for category growth, new initiatives- Issued style count guidance to merchants, driving product clarity and depth in stores- Coordinated micro space planners and store experience partners to support store-level execution

- Worked cross-functionally with merchant, technology, analytics and marketing teams to develop advanced analytic tools in BI systems such as MSI and Tableau- Provided input and developed tools for critical strategic initiatives, including store space optimization and digital customer analytics- Utilized Python and SQL to acquire, clean, wrangle and analyze various data

- Supported corporate-wide reporting and analytic tools utilized by merchants and others- Developed customer choice metrics and reporting, driving choice reduction strategy across the company- Led analytics training for merchant teams

- Worked with office planner to develop seasonal allocation strategies and inventory plans- Developed analytical tools to evaluate effectiveness of allocation systems, driving inventory reduction in underperforming stores - Regularly presented business findings to office, localization teams, and divisional leaders

- Managed lab website, provided statistical analysis, and reviewed research literature with lab members

Wisconsin, United States