Part of the logistics and analysis team, doing end-to-end financial analysis, carrier negotiation, RFP creation, invoice creating, and auditing for Online Grocery Did weekly financial analysis for Last Mile, Middle Mile logistics, and presented it to VP, LogisticsTracked the increase, and decrease of cost and volume per week for the perishable meal kit and online grocery of Goodfood Single point of contact for all the 3PL Last Mile carriers, which included negotiating with them for better rates, tracking their quality in terms of late delivery/non-delivery of our boxesCreated a comprehensive pricing file in Excel by going through carrier contracts, and compared rates for each carrier for over 1600 FSAs across the country, thus deciding the feasible carrier for each FSA and splitting the weekly volume across carriers accordinglyDid a 6-month audit of 3PL invoices and got $30k in chargebacks based on wrongly invoicing the companyWorked with the finance team, and prepared weekly invoices for Goodfood drivers doing last mile delivery across the country using advanced ExcelRouted packages for Greater Montreal Area twice a week based on the customer volume using Locus software

Part of the Operations team, supporting the carrier optimization and allocation tool to assign the fastest and least cost carriers• Expertise in using JDA to solve several issues that come up while running reports that help the uppermanagement understand overall fuel usage, inbound/outbound containers, rental container usage, and carrier optimization• Did cost-benefit analysis of creating routes that led to bypassing DCs and assisting direct store delivery bringing $1M in savings• Created databases and reports in Access and Excel that managed the fuel surcharge, FTL costs, LTL costs, and carrier rates• Created a tool to track Canadian Tire containers (19000) across the country, leading to faster turnaround and cheaper deliveries• Assisted in the creation of a new hub in Vancouver that would bring about $3M in cost savings and 120 hrs of time savings to BC• Primary contact for managing the Carrier Allocation Tool that assigns trips all across the country using over 40 carriers• Primary source of contact for all co-ops and interns, helping them in all VBA, Excel, MS Access, and Power BI-related queries• Worked with multiple teams like Offshore Transportation, Carrier Plan, and Domestic Transportation, gaining in-depth knowledge

Inventory Management: Optimal quantity is carried, and timely stock replenishments are madeOptimization: Perishable product with a shelf life of 2 weeks, profit maximized as the product deterioratesImproved inventory and transportation management in a food and pharmaceutical industry over a 3 month time horizon Route optimization: Delivering product to 50 geographically dispersed retailers from one distribution center or depot using 2 vehicles (Vendor Managed Inventory)Process Improvement: Reduced inventory holding, aging, and routing costs over different demandsDemand Planning: Forecasted up to 6 month’s demand employing MS Excel and pythonRan 30 data sets on the three models and did data analysis to measure model effectiveness using MS Excel functions and pivot table

Assisted professor in generating and marking exams and assignmentsTook lectures, tutorials for Data Analysis, Inventory Management, Probability, and StatisticsStudent mentor: Conducted Engineering TA Workshop, tutored students on the duties, and responsibilities as a Teaching Assistant

Aided the flow of the supply chain with effective communication among cross-functional teamsAssisted in 3PL logistics management, and improved customer service level to 97%Brought about 22% cost savings through effective inventory managementApplied lean/six sigma principles ensuring the product is replenished according to the demand forecast

Process Improvement: Automated 630 test cases and was responsible to bring about to cut the release time from 6 to 4 months Supervision: Managed a 10-person automation team, making sure that the automation is done strategically such that test engineers can benefit from it

Created a Dashboard that had user-friendly, dynamic and actionable charts using the company databases requiring the use of Python, Django MVC Framework and Tableau