Shubham Chaudhary

Data Analyst @Snap-on

Crystal Lake, IL, US

Created 10 Tableau dashboards to track individual productivity for picking, putaway and receiving departments •Analyzed over inventory transactions from WMS and Infor LN to write complex queries in SQL databases using joins, sub queries and window functions that tracked KPIs like Receiving efficiency, Inventory turnover and Order Fill Rates •Using predictive analytics created 1-year forecast for different totes that helped in making data-informed decisions for warehouse expansion by reducing overhead costs, finding opportunities for improvements in inbound and outbound processes •Trained natural language processing (NLP) models using customer data to create bots for fast resolution of customer queries •Analyzed over 10+ macros in MS Access to replicate the results in the form of Tableau dashboards by backtracking different SQL queries used at each step and writing the same queries using different tables, joins, schemas and aggregate functions

University of Illinois Chicago

Master's degree, Business Analytics

SRM University

Bachelor of Technology - BTech, Electrical, Electronics and Communications Engineering