Dynamic Senior Operations Team Leader at Walmart Logistics with a proven track record of enhancing shipment efficiency through advanced Excel tools and SQL. Skilled in cross-functional coordination and staff development, driving team performance to exceed operational goals. Adept at leveraging data analytics to optimize warehouse operations and inventory control.
· Improved the On Time Shipment KPI to 99+% by creating tools in Microsoft Excel using VBA and SQL to automatically pull and process the raw data related to customer orders from CSV files, and make it available for analysis instantly
· Leading daily start-up meeting, assigning duties accordingly to meet daily production schedules
· Coordinate physical and virtual workflows, or flow of orders and materials to ensure products are shipped on time to meet customer delivery promise
· Driving the performance management of on average 60 team members
· Opening tickets in ServiceNow to resolve system-related issues and collaborate with Tech Support team as an SME of Warehouse Management Systems: GLS and Dematic
· Developed strong partnerships with cross-functional teams to improve overall business performance
· Developed macro in Excel using VBA and SQL to extract the list of active slots with space availability from a large dataset, which was utilized by Inbound Replenishment team, thus improving stock replenishment efficiency by 10%
· Validated and implemented a new Warehouse Execution System (Dematic) for outbound order processing as part of the testing team, coordinating with both internal and external stakeholders
· Assisted in the implementation of GLS software by collaborating with the Developers
· Conducted end to end testing after scheduled deployments of software updates
· Create process flows, SOPs and train operations support personnel
· Design SAP/Excel queries to simplify end-user reporting and investigation process
· Providing Ecommerce order fulfillment service to Walmart using SAP and Dematic system
· Responsible of generating picking tickets(waves) by following proper procedures
· Assisting management in operations planning by analyzing issues and providing recommendations
· Performing all the necessary tasks to meet the service level agreement (SLA)
· Responding to high volume of emails on Microsoft Outlook in a timely manner
· Consistently providing training to other EPAs on the shift
· Coordinating with other team members to maintain the consistent flow of activities
Microsoft Excel
o VBA Scripting - Macros
o Advanced Functions – Vlookups, Index Match, If Statements
o Pivottables
SQL
Microsoft Access
Working knowledge of Python (Pandas Library)
Working knowledge of PowerBI
Leadership
Operational excellence
Staff development
Cross-functional coordination
Warehouse operations
Inventory Control
Ability to communicate in three different languages
Customer Service