Demand Planner
Shalina Healthcare Limited
Total years of experience :17 years, 8 Months
Demand Planning
• Analyzed forecasts received from markets for variances from trend and historical data
• Consolidated final forecasts for more than 150 SKUs provided from across nine African markets
• Communicated with suppliers in China, India and UAE for details of dispatched/planned shipments
• Created demand plans based on lead time, stock policy per SKU, actual and planned shipments
• Segregated demand plans generated for all markets as per supplier locations (India/China/UAE)
• Based on stock availability, proactively diverted stocks to different markets as per criticality
• Created containerized plans for adhoc requests from customers for surgical/pharma range SKUs
Reporting
• Provided sales loss report due to production constraints/delayed shipments, to management
• Reported in-market performance of newly launched SKUs to New Products (NPD) team in India
• Reported immediate arrivals, planned shipments, excess/low stock situations to market managers
• Indicated expected out of stock situations and predicted monetary loss to management team
• Generated monthwise forecast accuracy reports to management and sales team across locations
Demand Planning
Collaborated with sales team and vendors to forecast demand for more than 600 SKUs
• Forecasted demand for promotions along with sales team, considering supplier ATL/BTL budgets, competitor activities and obsolescence of existing stocks
• Attended principal meets to review market demand, trade deals, promotions and cannibalization
• Conducted regular market visits along with the sales team to gather market intelligence
Supply Planning/Inventory Management
• Planned monthly stock replenishments considering agreed stock days, seasonality, supply constraints to ensure on-shelf availability
• Monitored stock status on a daily basis in order to effectively manage working capital
• Coordinated with cross-functional teams including sales, trade-marketing, finance, logistics and clearing agents to ensure availability of stocks
• Monitored satellite warehouse inventory on a weekly basis by ensuring on-time delivery of correct stocks to locations
• Handled consignment documentation on a daily basis to ensure timely clearing of containers
• Accounted for returnable containers, demurrages and managed claims and disputes
• Liaise with the clearance team to get the products registered and lab tested by the Municipality
Management Reporting
• Prepared monthly/weekly reports for the CEO/Senior Management on SAP/Excel to closely monitor forecast accuracy, ageing, near expiry and excess stocks
• Reported on a weekly basis, the performance of NPDs (new products), highlighting any major deviation of sales from agreed forecasts
Project Planning \n• Implemented quality software solutions for the US based automotive client’s ‘Worldwide Transportation and Customs’ project \n• Coordinated project activities such as estimations, technical discussions and resource management for the Customs project \n \nProject Execution \n• Provided technology support for real-time logistical issues during customs inspection at Canada \n• Collaborated with client managers to execute a critical software procedure concerning the monthly payment of customs duty to CBSA (Canadian Border Services Agency) \n• Transformed supply chain business requirements to technical documents for the team \n• Conducted regular IT checks to ensure high quality standards of deliverables \n• Executed successfully, three full life cycle projects for the client
Project Execution \n• Implemented various software enhancement projects for a Global Investment Bank \n• Interacted on a daily basis with the bank’s IT department to resolve business issues \n• Prepared business and technical documentations for the project
Department of Economic Development (DED), Government of Dubai Dubai, U.A.E
Supply Chain Intern Nov’09-Apr’10
• Conducted extensive and in-depth research of the third party logistics sector in Dubai to identify the operational and market entry hurdles faced by the organizations
• Interviewed the CEOs of various world class third party logistics organizations in Dubai to garner insights into the hurdles they face
• Recommended ways to attract more world class organizations to setup third party logistics operations in Dubai
Achievements:
• Received appreciation certificate from the Government of Dubai for outstanding work done and valuable recommendations provided as a part of the internship of five months
St. Joseph’s College of Engineering (SJCE) Chennai, India
Bachelor of Engineering Aug’01- May’05
Major - Electronics and Communications
Percentage - 84% with Distinction