Skip to main content
Dipen Patel

Dipen Patel

Data Analyst | Business and Inventory Analyst

Vancouver, Metro Vancouver Regional DistrictMember since April 7, 2023
SQLPostgreSQLPythonPower BITableauReplenishmentAutoCADSTAAD Pro
·

About

Retail assistant manager with hands-on experience in sales, Inventory, profit-loss analysis, book stock evaluation, high shrink report, reviewing performance matrix, shrinkage management, risk assessment, and data analysis to support the business in running smooth operations.

At Walmart

Canada, I was in charge of a team of 53. The key responsibilities are to prepare weekly and monthly reports on physical and paper inventory, identify the cause of any discrepancies, and explain them to the store manager and market leaders with a resolution. To generate and analyze these reports, we use a hybrid system to pull data from cloud-based servers and prepare visualizations using Power BI and Tableau.

Before moving to Canada for my higher studies, I worked as a civil engineer, where we used Microsoft Excel for estimation and billing, and STAAD Pro, AutoCAD, etc., for design.

Experience

Assistant Manager — Food, then Consumables - Walmart Canada Corporation - North Vancouver, BC

(2024-11 - 2026-06)

  • Prepared weekly and period reports for a department group of more than 50 associates. Combine sales, on-hand inventory, shrinkage, no-movement, and P&L data into one summary for store leadership.
  • Compared system inventory with physical counts. Reviewed receiving, claims, and POS records to find the cause of differences and correct the inventory records.
  • Improved the department's Excel reporting so key figures are updated automatically instead of being rebuilt by hand every week.
  • Presented results and explained the reasons behind them during reviews with store and market leadership.
  • Reduced shrinkage by 15% in one department group and 22% in the next by improving ordering, count accuracy, and follow-up on exceptions.
  • Helped deliver year-over-year sales growth of 23% and 29% across two department groups by monitoring demand and product availability.
  • Improved associate engagement to 82%, up 12 points from the previous year, by updating onboarding, scheduling, and follow-up routines.

Produce Department Manager - Walmart Canada Corporation - North Vancouver, BC

(2024-05 - 2024-11)

  • Managed ordering and inventory accuracy for a fast-moving produce department, where over-ordering quickly leads to waste.
  • Used past sales data to plan replenishment and merchandising up to four weeks ahead, helping improve availability and reduce out-of-stocks.
  • Led a team of 15 associates and documented the ordering process so other managers could follow it when covering the department.

Civil Engineer - Jalaram Projects Pvt. Ltd. - Gujarat, India

(2018-01 - 2021-11)

Government infrastructure contracts

  • Prepared quantity take-offs, cost estimates, and financial projections in Excel to support budget and scope-change decisions.
  • Compared measured site quantities with contractor invoices before payment, helping identify and correct overstated claims.
  • Coordinated schedules, materials, contractors, and partner organizations across several projects running at the same time.
  • Prepared progress, cost, and risk reports for government clients and company leaders, and presented the findings in review meetings.

Education

Master of Business Administration - Project Management, Leadership and Finance; minor in Marketing - University Canada West (2022 - 2023)

Bachelor of Engineering - Civil Engineering - Sardar Vallabhbhai Patel Institute of Technology (SVIT) (2013 - 2017)

Skills

Data AnalystBusiness and Inventory Analyst

Reviews

Related