*Hi**,*
*Hope you are doing great!!* * Please find the requirement below **,* *If you find yourself comfortable with the requirement please reply back with your updated resume with details to this email id s.dak...@esskay-inc.com <s.dak...@esskay-inc.com> and I will get back as soon as possible.* *Position: Demand Planner* *Location: Chicago* *Contract Period: 6 Months Plus* *Overview/Summary* The Demand Planner is responsible for managing the end-to-end supply chain planning function. This individual contributor role is responsible for using formal analytic techniques to predict and plan future demand on approximately $750 million of inventory for devices to support approximately 480 Retail locations, Direct Fulfillment, and Agent supply chain channels. This role will capture, analyze and make recommendations at the SKU level and provide target specific cause and effect relationship information on demand to various levels of leadership. Determine and govern key performance metrics surrounding inventory turn, service levels, and obsolescence. Lead partnerships with cross-functional teams such as Marketing to determine estimated and actual promotional lifts, Device Management to report item performance, Replenishment Analysts to assist in tiered buying strategies and identifying channel fill quantities. Communicate and educate various partners on demand planning strategies. Prevent and manage inventory backorders by collaborating with Inventory Analysts on short term and long term forecasts. This position reports to the Manager, Device Supply Chain. *Responsibilities*: *Lead the end-to-end supply chain planning function:* · Monitor cell phone accessory sales at various depths of granularity (by product by category and/or by location). · Develop cell phone forecasts based on trends, promotions and pricing. · Partner with Inventory Analyst on demand forecasts to achieve targeted inventory goals. · Analyze store and DC inventory levels and sales rates, recognizing company sales trends. Develop and manage a course of action that will allow for a maximization of identifiable opportunities including mix of product, allocation strategies, or performance of productive vs. non productive inventory. · Develop and lead device lifecycle planning through the development of unit plans for all device SKU’s. · Collaborate with peers and device channel partners to improve advance planning and reduce end of life obsolescence. · Participate in monthly Obsolescence review. *Manage the reporting function for device supply chain:* · Determine reporting requirements and analysis surrounding inventory performance as well as forecasting for future demand. · Utilize SAP BI for reporting · Identify and support ad-hock reporting needs. *Management of cross-functional relationships:* · Lead short and long term demand forecasting for all product categories using CPFR (Collaborative Planning and Forecasting Replenishment Model). · Lead and consolidate performance data from Planning Team to present vendor · Performance results at quarterly departmental meetings with suppliers. · Partner with Inventory Analyst to prevent and manage inventory backorders, manage open orders by timing and quantity as needed to respond to changing demand patterns. · Categorize article selling by product category and/or feature sets to provide feedback to accessory management team on breadth & depth of assortments. · Partner with Inventory Replenishment Analysts to ensure in stocks are being met. · Partner with cross-functional teams to understand upcoming promotions and new product launches. Analyze results of similar promotions or similar products in order to estimate and plan for demand. · Responsible for participating in various projects as a subject matter expert and lead resource for device supply chain related initiatives. * Other duties as needed:* Minimum Experience and Educational Requirements · Bachelor's degree or equivalent experience required. · 5-7 years of relevant work experience required; inventory planning in retail or related field preferred. · 1-3 years of demand planning experience required. · Excellent written and verbal communication skills required. · The ability to work with multiple computer applications at the same time. · Ability to balance multiple tasks at once, and reprioritize as needed. · Strong ability to manage time affectively, and to be versatile. · Self motivated, and demonstrates initiative. · Ability to develop relationships and work in a team environment. · Experience with vendor (or 3rd party) relationships. · Demonstrated analytical ability. · Ability to sort through ambiguity and work in sometimes undefined roles. · Understanding of retail math concepts. · Leadership experience is desired. · Knowledge of unit planning is required. · Advanced knowledge of PC Windows based applications (Excel and Word). · SAP experience (IS Retail, R3) and/or understanding of POS systems is desired. SAP-APO experience a plus. Thank You -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.