Rebecca Fenichel Email & Phone Number

San Francisco, California, Us

Atlanta, Georgia, Us

Delivery Analytics - Delivery Options• Led team of 4 analysts to support fulfillment options and freight cost optimization across delivery networks• Identified $9M freight savings opportunity from using optimal delivery vehicle in deliver-from-store network• Strategized with merchants to increase shipping efficiencies in dropship network based on analytical models• Built model using R and SQL to quantify package consolidation opportunities and drive improvement• Supported rollout of new shipping service system by detailing business requirements and identifying risks• Identified opportunities for automation and process improvement to significantly reduce ad-hoc work on teamDelivery Analytics - Last Mile• Led team of 3 analysts to support the growing last mile delivery business through analytical projects• Created new metric to holistically measure customer delivery experience and built user-friendly Tableau reports• Automated forecasting processes using SQL and Tableau to provide operations team with more real-time data• Executed analytical process improvements to increase accuracy of delivery volume and truck forecasts by 13%• Identified opportunity to remove 79 under-utilized trucks from the store delivery network saving $6.3M annually• Developed analytics to measure success of new downstream distribution centers and support ongoing rollout

Atlanta, Georgia, Us

One Supply Chain Development • Automated ramp plan creation for new supply chain network rollout using Python, SQL, and Tableau • Optimized inventory stocking strategy to decrease distribution center space utilization by 22% • Lead team transition from Microsoft SQL Server to Google BigQuery • Trained Senior Logistics Analyst new hire Supply Chain Delivery Analytics • Developed interactive Tableau dashboard to compare delivery speeds with top online competitors • Automated flooring delivery pilot program evaluation using SQL and Tableau • Managed weekly report analyzing OGSM metric statuses across department • Developed Tableau dashboard to monitor UPS Saturday Delivery rollout performance • Created prioritization algorithm and Tableau dashboard comparing fulfillment center product selection strategies • Led department-wide Tableau training session covering dashboard design, actions, parameters, and more

Atlanta, Georgia, Us

• Improved shipping speed for 21% of online products using SQL to analyze shipping origin history• Upgraded and maintained script using SAS and Teradata used to build item master tables which provide visibility to several item data attributes including shipping and sales data• Completed weekly reporting used to measure sales and margin impact of changes to shipping charges• Developed SQL query to quantify business impact of current and future potential order splitting logic and cost saver shipping methods• Built reporting using SQL and Tableau to track effectiveness of increased signage for new delivery options

Cincinnati, Ohio, Us

• Used value stream mapping to decrease storage costs for excess mid-cut alcohol by over 40% annually• Compared and recommended regional distribution methods for mid-cut alcohol based on cost, speed, and risks• Investigated a foreign supply chain infrastructure for potential reapplication opportunities• Developed an automated tool using VBA to decrease monthly transportation budgeting time by 90%• Worked on a team to create a visualization model for company-wide IT system adoption levels using Spotfire• Completed weekly experience logs used to improve the internship program as an Intern Advisory Board member

Atlanta, Ga, Us

• Managed, coordinated, and planned projects based on client needs and internal development capacity• Created and executed test plans for quality assurance to proactively identify issues• Developed an automated tool to simplify the quality assurance testing process using VBA• Presented project status updates internally and externally on a regular basis• Managed project issues by creating tickets and assigning resolvers using JIRA project tracking software• Verified project’s operation by manually querying production SQL database

Atlanta, Georgia , Us

• Mentored a group of Georgia Tech freshmen in their transition into college life

Bachelor’S Degree, Industrial Engineering

Industrial Engineering