Managing All Import Merchandising Sourcing.Vendor Coordination & Order Management.Order Delivery & Shipment Planning.New & Reorder Planning.

Analyse historical data to find out best sellers and make trigger the re-ordering point.Communicating with International Suppliers for New/ Repeat orders.Managing Import process which includes Order placement, Payments schedules, Document preparation, Container Booking. Managing Product Funnel report to keep track of production for timely launches.Vendors' performance analysis to identify the right vendor for right product.Reviewing production schedules and shipping schedules to ensure that orders are delivered on time.Communicating with suppliers about fluctuations in demand for materials, product changes, pricing changes, or delivery schedules.Monitoring inventory levels and making adjustments to ensure that supply levels are adequate but not excessive.

Brand analysis, Product level and Sales analysis to forecast future growth.Inventory analysis to calculate stock cover days.Gap analysis between sales target and available inventory.E-commerce content and sales analysis.Planning to improve business on going process.Profit and Loss analysis on Store level.Dynamic reporting by using Advanced Excel and Power BI tools.

Inventory planning for Allocation & Replenishment.Sales Forecasting to plan Inventoey requirements.Keep track of slow moving or dead stock.Analyse Inventory turnover to find growth %ge.Sales comparison with normal day sales.Enhance the reporting accuracy and processing by using Macros in Advance Excel.

A supply chain analyst to identify problems in supply chain system and purpose solution of problems to make supply chain smooth and optimized. The role to forecast required supply according to demand by analysing sales trend of last years and targets of next year.To conduct data analysis for improvement of supply chain operations to increase efficiency and reduce costs. Helping supply chain to run smoothly and profitably as possible.To achiecve the above targets I have to keep track of whole inventory of company which includes stock movement from import to factory to dealers.I also working to keep the inventory level updated and generate the re-ordering point on Monthly basis by analysing difference in current stock and sales targets.Also made transportation analysis for Route optimization and to get per unit cost of sold stock for minimizing transportation expenses.Working in advance excel to consolidate whole inventory of company's pipeline in a single report which was previously available in more than 4 sources separately. And analyse the sale trend to forecast the reordering point required to achieve sales targets smoothly.

Search for new potential products line up.Negotiations with International vendors to get best prices.Listing new products and management of existing Live products.Weekly Reconciliation of Physical inventory with system.Answer all customer queries and complain.Keep eye on content of Live products to make sure the relevant data is uploaded.Packing and shipping new orders within SLA and handle customer returns.