-Uses SQL, R, and Power BI to design, develop, test and implement reports and dashboards for both merchandising and supply chain departments.-Continuously work to create efficiencies and improvements within reporting, procedures, and scheduling processes by transitioning reports to newer technology with the goal of automation-Influences decision-making by effectively communicating and translating the results of analysis into business insights and actions, resulting in the revamping of logic behind data tables and the cleansing of erroneous data-Collaborated with VPs and managers of cross-functional departments to create a scorecard dashboard that ranks the periodic performance of distribution centers across various KPIs.

-Responsible for managing a purchasing budget of ~$109 million and monitored the product flow from domestic and direct import suppliers to 41 distribution centers that supported ~6000 stores-Planned for future demand by executing analyses on forecasts, purchasing, and sales trends with the objective of driving sales and improving inventory health-Prepared weekly and periodic reports regarding inventory updates, root cause analyses, and resolution strategies-Collaborated with suppliers to discuss initiatives and resolve issues concerning but not limited to availability, order cycles and lead times, fill rate %, and returns-Recovered a category that was constraining ~90,000 units in just over a year-Served as SQL and inventory data subject matter expert for the inventory department-Lead and trained new hires on responsibilities and duties of inventory planning

-Managed the product flow of inventory from distribution centers to stores and vice versa by lowering and raising stocked quantities depending on sales trends, and adding and removing new and old product, respectively-Prepared weekly and periodic reports regarding inventory updates, root cause analyses, and resolution strategies-Led and participated in meetings involving the training of new and current team members, and the planning and execution of inventory strategies-Beat budgeted turned target for a category by 37.31% by removing ~$2M of unnecessary inventory from stores -Discovered a miscalculation within logic used to label inventory as unproductive and was selected to be part of a subcommittee to correct it, resulting in up to 20-25% reduction in unproductive inventory for some product lines-Developed a report that tracked weather data versus sales, which was used to explain anomalies within previous sales history and by other departments to project sales during extreme weather events

-Used Excel functions, macros and pivot tables to manage the daily reporting of inventory data across 11 warehouses and ~4000 stores, and to optimize reporting procedures resulting in earlier delivery times