Nancy Simmons Email & Phone Number

Nancy Simmons is a Allocation Analyst at Eclipse Stores Inc..

• 

  Allocation Analyst

  Eclipse Stores Inc.

  Jul 2015 - Present

  - Analyze sales trends and inventory levels to determine which styles to ship to stores, in which quantities and sizes to optimize sales. Requires creation of queries in SQL based database (using SQL based UI) to extract information and further manipulate and analyze data using Excel.- Analyze sales at the style level and transfer product from one store to another to increase profits.- Create and improve on Excel models and templates and create macros using VBA. - Provide inventory management software support to all stores (80+). Testing of this software before upgrade goes live, including communication with supplier to optimize configuration and functionality. Write manual for users and keep up-to-date. Experience using Jira (project /ticket management).- Create various 3D maps in Excel for presentation to District Managers to represent visualization of sales trends, return rates, e-commerce sales and other meaningful data.- Provide Excel support to other head office employees.- Track and investigate overdue shipments and transfers.- Provide transfer compliance report to management to help detect training/shrink/sales issues.- Provide support to management with further high-level inventory analysis and shrink reporting.- Prepare inventory related memos and instructions for store staff.- Participated in meetings with potential ERP providers.- Participated in various training sessions for ERP and retail IT functions.

• 

  Memorial University Of Newfoundland

  Management Science