Javaid A. Qazi

Sr. Manager Planning (Merchandise/Demand/Supplier/Inventory)

PAN Emirates Home Furnishing - Dubai, UAE

From June 2013 to till Date

Duties & Responsibilities

•           Successfully Setup the complete Merchandize Planning Department by analyzing the Company’s Upward Growth Trend.

•           Effectively designed the complete Product Set and move all the SKU to their respective Category, Department, Group, Sub-Group and at UDA level

•           Prepared and maintain the crystal reports and Dash board for the stakeholders.

•           Managing a team of 12 full time Employees, which includes, Sr. Planners, Planning assistants, Pricing analyst, Suppliers Coordinators, and Shipping Coordinators.

•           Successfully Migrated the complete, Item Master, Purchase Orders, pending sales and Replenishment Orders of all the territories to the New system without disturbing the operations by running both old and new system parallel.

•           Efficiently defined and maintained the MDQ of the Key performing SKU throughout the year to meets the projected Sales budgets.

•           Analyzing the Buying trend and raising the concern whenever the buying shows positive trends.

•           Managing the Supplier Price with Various Level of product group discounts.

•           KPI Monitoring Budget Vs Actual Purchase.

•           Monitoring Stock and Order values & keeping proper control on OTB.

•           Analyzing the Ageing Inventory and repricing it for faster liquidation.

•           Competition Price Simulation (Competitor analysis and Benchmarking).

•           Constructively Pricing the promotional offer products by keeping the competitor study in mind.

•           Tracking the Shipment status by the Online platform provided by the shippers.

•           Precisely making the container fits of items, based on the agreed MOQ with the suppliers.

•           Maintain healthy relations with the supplier and buyers to execute the unplanned orders in emergencies

•           Actively involved with marketing, E-commerce and Retails team while designing any promotion offer for the sales growth

•           Systematically analyzed & selected (K-Line SKU's), exclusive for online based on the ATV (Average transaction Value).

•           Successfully Planned reorders based on requirements & events (3 to 6 months) in advance.

•           Monitoring the daily stock and sales to make sure all the stores should hold the key performing SKUs.

•           Efficiently maintained the desired GP of the company by proper Pricing Strategies.

•           Maintaining the ageing inventory by less than 5 or 6% with the help of First Time Right pricing and adding additional discount based on the item’s age.

•           Thrivingly running various monthly and weekly promotions by keeping Price and Cumulative GP under control.

•           Prioritizing and advising the imports on Containers priority to be pulled from the port based on sales and stock covers.

•           Successfully prepared various templates in system to deliver swift data analyzing for the correct call or decision.

Duties & Responsibilities

•           Managing the inventory and product setup, & Pricing of the entire Middle East.

•           Preparing various inventory reports on a daily, weekly and monthly basis for analysis.

•           Monitoring the buying trend of all the Middle East.

•           Product Grouping, Option Count & range plan.

•           Preparing the ageing stock list by category and department, group and sub-group wise and submitting the same to retail and strategic department to come up with faster liquidation process.

•           Preparing Re-order stock report considering the 70-30 Thumb rule of procurement.

•           Defining the Product ranking based on its performance and accordingly matching to the ranked stores.

•           Planned and executed the Competitor study to be updated as per the market trend.

•           Repricing or price mark down of the tail inventory and discontinued items for easy and quick liquidations.

•           Preparing Monthly stock cover reports and item contribution reports to discontinue some slow and non-performing SKU and to introduce the New Launches.

•           Successfully maintaining the 70% re order items and 30% new launches on a monthly basis.

•           Guiding the Retail planner on MDQ and stock selection with the help of sales trend, ATV and basket size.

•           Successfully define the K-Line items and was making sure the stock availability of the same throughout the year.

•           Stock transfer handling, upon day-to-day stock & sales analysis & on territory demand.

Duties & Responsibilities

•           Inventory management using WMS leading to International sourcing back office management.

•           Handling all the inventory operation of Home Center UAE.

•           Preparing, Implementing and monitored the Inventory Procedures and Guideline.

•           Handling and assigning inventory related task to the team for smooth transaction to maintain the accurate inventory

•           Management with LN as ERP, pre sourcing budget assistance through MIS and post receiving analysis, Assisting In the annual plans of marketing, budget monitoring and its implementation.

•           As an inventory controller conducted periodic & annual inventory checks and reduced inventory-holding errors assisted by perpetual inventory management techniques.

•           Monitoring and supervising all the receiving and issuing of stocks to the outlets as per the requirement.

•           Monitoring GRN and getting the audit done if found shortage and excess.

•           Monitoring the ageing stock and maintain its availability physically.

•           Constantly doing random check in Showroom’s Back store to make sure the physical stock tally with the system stocks.

•           Cycle count. &   Stock Taking.

•           Auditing Damage Stocks.

•           Stock Audit of all the out lets across UAE, KSA, Oman & Qatar.

Duties & Responsibilities

•           Assisting the retails for all kind of promotion, price changes.

•           Item Labeling and data entry.

•           Making SOP of Showrooms in the areas of In-bound, Out- Bound and Sales Return.

•           Auditing the Sales Return of the showrooms by weekly.

•           Always adhere the company’s policies and procedures.

•           Event Management / Promotions: Leading a team of members to participate in Exhibitions; like GITEX.

•           Retail Operations: Administrating Showroom, maintenance of showroom, layout, merchandising of staff and job allocation of staff on daily bases.