Lokesh Sharma

Data Science Senior Advisor @Compass Health Brands

Cleveland/Akron, OH, US

Alteryx Workflow Designing: Working from about 5 years on over 150 Alteryx workflows ETL Pipelinedesign to import data from SQL DB2 data base. Clean, analyzed, modified, and build models on huge datasets and published the data to the Tableau Server.• Tableau Server and Dashboards: Created more than 150 user friendly dashboards using Tableau Desktop and Tableau Server.• Raspberry Pi’s: Published the Tableau Dashboard with the help of Raspberry Pi’s to the TV Screens located at the office as well warehouse to provide real time KPIs to the end users.• Supply Chain Key Projects, KPIs and Dashboards: Excess and Obsolete Inventory Tracking, ForecastAccuracy & Demand Master Analysis, Containers Booking Prioritization, Backorder/Backlog Tracking, POPush Outs, Inventory Health - Months on Hand, Master Data Cleanup, Supply Chain At-Risk Items Analysis, Inter DC Transfers, Inventory Turns, Safety Stock Calculations and so on. All the Alteryx Workflows and Tableau Dashboards refresh at the frequency of Hourly, Daily and Weekly Basis.• Warehouse Operations Projects, KPIs and Dashboards: Disappointed Customers Tracking, Receiving and Put Away Analysis, Picking Efficiency, Picks Remaining - Orders by Ship Date Inventory Accuracy, Item Receiving, Cycle Count Reconciliations, Inventory Transactions, Inventory Replenishments, DC Revenue & Order Volume, and Days Behind.• Finance Profit and Loss Dashboard: Built eye catching Tableau Animated visualizations to track Profit and Loss KPIs at various levels such as SKU, Customer, Product Family, Subproduct Family, Brand, Territory, Salesman, etc. KPIs included are Sales, Net Sales, Gross Margin, COGS, Avg Price, and Contribution Margin. Used complex LODs, Dynamic Parameters in Tableau to compare metrics Year over Year and Quarter over Quarter. New viz included are Dot Plots, Dumbbell Chart, US Map, and Rank Plot.• Purchasing: Initially worked as a Supply Chain Analyst to maintain the inventory and service level of SKUs

Clemson University College of Engineering, Computing and Applied Sciences

Master of Science (M.S.), Industrial Engineering

NETAJI SUBHASH INSTITUTE OF TECHNOLOGY,DELHI

Bachelor of Engineering (B.E.), Manufacturing Processes and Automation Engineering