
Vatsal Ahir

Connect with Vatsal Ahir to Send Message
Connect
Connect with Vatsal Ahir to Send Message
ConnectTimeline
About me
Assistant Store Manager at Walmart Canada | Data Analyst | Business Analyst
Education

Conestoga College
2018 - 2019Graduate certificate Information technology business analysis 3.4Activities and Societies: Project manager in Academic project for Cober Solution.
.webp)
Gujarat Technological University (GTU)
2013 - 2017Bachelor of Engineering - BE Information Technology 6.98Activities 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 2018Junior Web Designer
Aug 2017 - May 2018

Walmart Canada
Mar 2020 - nowProviding 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 - nowDay Support Lead
Feb 2021 - Dec 2021Support Manager
Mar 2020 - Feb 2021
Licenses & Certifications
- View certificate

Data Analysts Toolbox: Excel, Python, Power BI
UdemySept 2021
Recommendations

Brendan mackey
Resident Physician at the Hospital of the University of PennsylvaniaPhiladelphia, Pennsylvania, United States
Paul kinney
Chief Technical Executive - US Federal at HCL America, Inc.Pennington, New Jersey, United States
Ayesha hamid
DentistRawalpindi, Punjab, Pakistan
Jill facarazzo
COO and Co-Founder of AlphaLight Capital LLC at AlphaLight Capital LLCGreater Phoenix Area
Nicole crivellone
Dispositional Advisor with the Minnesota Board of Public Defense, Fifth Judicial District | M.S. Hom...Canby, Minnesota, United States
Tom berenz
Estimator/Project Manager/Structural Engineer at Costello DismantlingNorth Middleboro, Massachusetts, United States
Ahmed eldaly
Senior IT ManagerCairo, Egypt
Patricia finley
President at Venture Anesthesia, P.C..Box Elder, South Dakota, United States
Cj obioha
Manager at MMD Hollywood 🌱Los Angeles, California, United States
Emmanuel charlie
QHSE Officer at PSGS Ltd, Basra, Iraq | HSE Supervisor | HSE Officer | Safety professionals | QAQC C...Al-Basrah District, Al-Basra Governorate, Iraq
Angélica van den heuvel
Verpleegkundige bij GGZ Oost BrabantNetherlands
Gustavo henrique
Técnico EletrônicoTaubaté, São Paulo, Brazil
Nourchen noamen
Full stack JavaScript developer (React JS / Node JS)Contact Info
Ghouse ahmed
civil engineerAndhra Pradesh, India
Bruce green
Site Manager at Macrennie Commercial Construction LtdAuckland, Auckland, New Zealand
Eimear butler
Assoc. CIPD - Human Resources at Templetuohy Farm Machinery LtdIreland
José luisce h.
Director de Construcción en TFCAPITALMiguel Hidalgo, Mexico City, Mexico
Sirisha bellamkonda
Clinical Research Coordinator at Rotunda Hospitals under RCSIDublin, County Dublin, Ireland
Charles hartke
Vice President Quality Services Division at APA - The Engineered Wood AssociationTacoma, Washington, United States
Lewis knapp
Finance Director at SetldPayWest Midlands, England, United Kingdom
...