William Gallien Email & Phone Number

Greater Seattle Area

Greater Seattle Area

Seattle, Washington, United States

Greater Seattle Area

Purchasing/Buying: Purchased all domestic goods based on sales data and seasonal promotional schedule. Negotiated pricing with vendors. Brought in new items and managed whole product life cycle for my lines.Data Analysis: Provided ad hoc reporting on store sales trends, web sales trends, seasonal promotions and more. Developed automated reports including weekly reorder worksheet, store overstock and understock reports, web free shipping profitability summaries, and more (SQL, SSIS… Show more Purchasing/Buying: Purchased all domestic goods based on sales data and seasonal promotional schedule. Negotiated pricing with vendors. Brought in new items and managed whole product life cycle for my lines.Data Analysis: Provided ad hoc reporting on store sales trends, web sales trends, seasonal promotions and more. Developed automated reports including weekly reorder worksheet, store overstock and understock reports, web free shipping profitability summaries, and more (SQL, SSIS, Python, VBA, and Excel).Project Management: Managed purchase, development, and installation of POS software for multiple retail locations. Wrote data transfer requirements, wrote POS training materials, tested functionality, ran in house testing with store sales associates, validated functionality with SQL scripts and Excel and worked with accounting team to develop needed reporting functionality. Other projects included: Building of warehouse demising wall, office remodel, purchase and installation of business phone system, installation of low voltage wiring.Negotiation: Successfully led negotiation of several Ocean Shipping contracts (50-100 TEUs) to reduce rates and unexpected costs (ONE, NYK, Hanjin). Reduced LTL and Small Package costs. Negotiated directly with UPS and FedEx and leveraged multiple offers to obtain better pricing. Member of POS negotiating team.Inventory Management: Set inventory levels for all stores. Created and executed inventory plans for new store openings, seasonal promotions, and sales. Developed, ran, and automated cycle counting program (Excel, VBA, Python). Monitored and gave feedback on store orders. Trained store managers on ordering and inventory methodologies. Show less

Purchasing/Buying: Purchased all domestic goods based on sales data and seasonal promotional schedule. Brought in new items and managed whole product life cycle for my lines.Data Analysis: Provided ad hoc reporting on store sales trends, web sales trends, seasonal promotions and more. Created weekly reorder worksheet. Helped move to ordering from POS sales data rather than inferential shipping data.Inventory Management: Set inventory levels for all stores. Created and executed… Show more Purchasing/Buying: Purchased all domestic goods based on sales data and seasonal promotional schedule. Brought in new items and managed whole product life cycle for my lines.Data Analysis: Provided ad hoc reporting on store sales trends, web sales trends, seasonal promotions and more. Created weekly reorder worksheet. Helped move to ordering from POS sales data rather than inferential shipping data.Inventory Management: Set inventory levels for all stores. Created and executed inventory plan for new store openings, seasonal promotions, and sales. Allocated all new merchandise and provided documentation to stores and web team for new items. Show less

Portland, Oregon Area