Bryan Livingstone, Mba Email & Phone Number

Dallas-Fort Worth Metroplex

Provide analytics to the Vendor Performance/Vendor Compliance, Gold & Assembly teams inside Global Strategic Sourcing. A data/process foundation needed to be created to allow subsequent complex analyses. Tools available include Excel, SAP Business Objects (BO), Alteryx and Tableau.RESPONSIBILITIES• Design and creation of reporting and dashboards that lead to actionable insights. • Creation of a process that allows for Vendor comparative analysis.• Cash flow analysis reporting.• Gold and diamond component analysis (below SKU-level).• Completion of various ad hoc projects.ACHIEVEMENTS• Designed and built comprehensive Vendor dashboards in Tableau. Summarizes and compares 350 Vendors, over 7 years, across 8 Banners, with 75+ metrics. Designed as a self-service tool for Merchants. First time a tool has been developed at Signet that allows for a multi-year comprehensive Vendor comparative analysis.• Identified Vendor payment term discrepancies between systems. Quantified impact and collaborated with Treasury and AP to correct. At a point-in-time, Signet had paid $37M earlier than we were contractually obligated with no discount (affected cash flow only, Vendors were ultimately paid the correct amount). • Built a daily open order process in Alteryx that normalizes different BO outputs, adds calculated fields and exports to a Tableau dashboard for end user consumption.• Major project highlights include diamond price per carat (PPC) analysis, aggregate diamond demand, product category analysis in preparation for vertical integration and gold chain pricing analysis.

Dallas-Fort Worth Metroplex

Provided analytics to the KZP (Kay, Zales, Outlets & People’s) Divisional Planning & Merchandising teams. For the first time in my career, data and analytics were the focal point of my role instead of an “add-on”.RESPONSIBILITIES• Managed the Discount Controls governance tool that regulates promotional and clearance markdowns in POS.• UAT on POS modification relating to Discount Controls.• Help tickets from stores relating to discounting.• Clearance markdown process.• Ad hoc analysis and reporting.• Lead team of 3 Analysts.ACHIEVEMENTS• Upgraded Clearance process from Access to Alteryx. Improved production time by 85% (2 days to 2 hours). Excel files were 86% smaller and less prone to crashing or corruption. Created archive with cleaned, standardized and accessible data. More efficient multi-departmental process with better accuracy, higher quality data outputs and improved visibility to stakeholders to drive results.• Improved Newness reporting by increasing the number of summarized data points while cutting production time by 97% (4h to 8m) and decreasing the file size by 99% (25MB to 200kb).• Alteryx core certified.

Dallas-Fort Worth Metroplex

• Led team of 11 Supply Planners, overseeing ordering, stocking, and replenishment of 600k SKUs.• Developed Excel-based dashboard for Planners, resulting in 12% sales growth and 55% excess stock reduction.• Supported 2 Product Directors and 14 Product Managers with Vendor and Planner reporting.

• Led Merchandise Planning and Allocation for Consumer Electronics Team, overseeing 4,400 stores and a team of 20 to develop financial, inventory and replenishment plans.• Conducted regular Sales and Operations Planning meetings with key suppliers, resulting in the growth of tablets & accessories to a multi-million-dollar business in just one year.• Improved company profitability by expanding margin-rich categories and ensuring stores and distribution centers were well-stocked.

• Led team of 6 Planners and 3 Analysts in planning repairs and replenishment for Verizon Wireless (VZW) reverse logistics supply chain.• Conducted twice-weekly S&OP calls with Verizon, ensuring SLAs were met while improving forecast accuracy and reducing excess inventory.

Hoffman Estates, Illinois, United States

• Developed financial, inventory, and purchasing plans for 933 Sears stores. Managed 1 Senior and 2 Inventory Analysts.• Collaborated with Merchants to improve the profitability of licensed apparel markdowns.• Categories included men’s outerwear, swimwear, shorts, activewear and men’s/women’s/boy’s licensed apparel (NFL/NBA/MLB/NHL/NCAA).

Inventory and purchase planning for 5,000 company and 2,000 franchise locations for Consumer Electronic finished goods.

• Created purchase orders and managed inventory levels.• Created SKU naming convention to harmonize names for easier identification.• UAT testing on system enhancements.