Vatsal Ahir

Vatsal Ahir

Followers of Vatsal Ahir671 followers
location of Vatsal AhirCambridge, Ontario, Canada

Connect with Vatsal Ahir to Send Message

Connect

Connect with Vatsal Ahir to Send Message

Connect
  • Timeline

  • About me

    Assistant Store Manager at Walmart Canada | Data Analyst | Business Analyst

  • Education

    • Conestoga College

      2018 - 2019
      Graduate certificate Information technology business analysis 3.4

      Activities and Societies: Project manager in Academic project for Cober Solution.

    • Gujarat Technological University (GTU)

      2013 - 2017
      Bachelor of Engineering - BE Information Technology 6.98

      Activities and Societies: Goal Keeper in College Football Team

  • Experience

    • Rising Wings Creative Pvt. Ltd.

      Aug 2017 - Aug 2018

      • Setup and maintained WordPress blogs• Designed websites using CodeIgniter and Laravel frameworks.• Designed user interface to meet client specifications and content management system.• Gathered specifications and other key details to meet requirements of site development.• Actively listened to customers, handled concerns quickly, and escalated major issues to the supervisor.• Excellent time management, situation handling, team coordination, and risk management to satisfy end-userexpectations.• Managing the flow between customer, business, and technical team.• Analyze, verify, and respond to customer’s business requirements. Show less

      • Technical Support Specialist

        May 2018 - Aug 2018
      • Junior Web Designer

        Aug 2017 - May 2018
    • Walmart Canada

      Mar 2020 - now

      Providing forecast recommendations to ensure a proper level of inventory in the store and developing positive relations with vendors, customers, and employees. In addition to that, responsible for creating reports for demand management, business objectives, and replenishment analysis in Microsoft Excel (Pareto Charts, Fishbone diagrams, Pivot Tables)Responsible for managing multiple Successful projects such as VizPick Installation, Optima, and Christmas Readiness Nation Tour. Successfully increased profit for Homelines from 98% to 103% YTD compared to the previous year and increased basket size by 5.6%. • Determined replenishment quantity by maintaining cycle counts with the Inventory Management System (IMS) and ordered materials to meet planned inventory levels.• Coordinate movement of old and slow-moving inventory from the Backroom to the sales floor with forecasted sales opportunities which led to a 33% reduction in Backroom inventory. I achieved this by creating worksheets related to the “IF” function in Microsoft Excel.• Participated in continuous improvement by generating suggestions, and engaging in problem-solving activities to support teamwork.• Presenting Quarterly reports to the Market Leader about sales and shrinkage for each quarter to show the performance of the department. • Forecasting sales based on previous year trends in each season.• Making plans and schedules considering budget allocation and availability.• Used coordination and planning skills to achieve results according to schedule.• Worked with tools such as SAP to fulfill tasks within deadlines. Show less Providing forecast recommendations to ensure a proper level of inventory in the store and developing positive relations with vendors, customers, and employees. In addition to that, responsible for creating reports for demand management, business objectives, and replenishment analysis in Microsoft Excel (Pareto Charts, Fishbone diagrams, Pivot Tables)• Developed and maintained relationships with over 80 different suppliers globally to streamline overseas distributors and reduce material shortages by up to 25% by creating a manual procuring routine with SAP.• Determined replenishment quantity by maintaining cycle counts with Inventory Management System (IMS) and ordered materials to meet planned inventory levels.• Partnered with upper management to develop a forecasting system (Customized Excel Worksheets) for ordering, transportation, and inventory which resulted in the deduction of paper shrink by 15%.• Analysed daily inventory levels by creating Pareto Charts for annual consumption value versus percentage of inventory items to increase the accuracy in the store’s backroom by 20% and used those charts to manage more than 300+ SKUs in store.• Coordinate movement of old and slow-moving inventory from the Backroom to the sales floor with forecasted sales opportunities which led to a 33% reduction in Backroom inventory. I achieved this by creating worksheets related to the “IF” function in Microsoft Excel. Show less Creating a daily planner to assign work. Hosting associate huddles and providing feedback plus any necessary training. Responsible for completion of return authorization and recalls. Printing weekly bin inventory report to work on dead (reds) and semi dead (yellows) inventory to maintain accuracy in inventory. Claiming all the damaged and defective inventory out of store’s system.• Created and implemented plans to increase store’s backroom capacity by 16% with the use of Just In Time (JIT) analysis to meet seasonal goals.• Performed inventory analysis by 80/20 rule to avoid low stock and overstock. Generated weekly reports on inventory levels using ERP software.• Analysed root causes of inventory issues such as inaccurate binning, shrink and provided resolutions in terms of MRP method to order inventory after considering the sales forecast.• Assisted in developing the training tools (videos and presentations) for new hires going forward, which helped them in learning the process in a quick and efficient manner. Show less

      • Assistant Store Manager

        Dec 2021 - now
      • Day Support Lead

        Feb 2021 - Dec 2021
      • Support Manager

        Mar 2020 - Feb 2021
  • Licenses & Certifications