Supply Chain Analyst with 3 years of experience in optimizing warehouse operations using Oracle Retail Warehouse management Systems (WMS). Skilled in creating and using sql queries to determine the flow of goods within a warehouse by creating and using various database queries ,ensuring efficient inventory management, accurate order fulfillment, and improved visibility throughout the supply chain to meet customer demand while minimizing costs.
• Utilized WMS software (Oracle retail) to manage and optimize warehouse processes, including receiving, putaway, picking, packing, and shipping.
• Collaborated with cross functional teams to implement warehouse layouts to reduce order processing time.
• Worked on back end testing by writing SQL queries to join the tables , verify the data, generating reports and identifying patterns to optimize inventory management and warehouse processes in WMS.
• Corrected stock quantities in inventory when there were discrepancies between WMS and RMS resulting in more than 90.70% accuracy.
• Conducted regular inventory audits and cycle counts, for maintaining an average inventory accuracy of 99.05%.
• Utilized Advance Shipping Notices (ASN) to streamline receiving processes, reducing receiving time and improving inventory accuracy.
• Optimized inbound receiving processes, ensuring accurate and timely processing of return receipts to maintain efficient warehouse operations.
Pl/Sql certified at ineuron