• Analyzed ~100 million rows sales data using R and SQL to evaluate monthly targets and company performance• Developed and optimized existing legacy operational systems using Salesforce and R, reducing turnaround time from 2 weeks to 1 day

• Analyzed customer challenges/problems and developed a proof-of-concept to improve customer experience• Gathered customer requirements and build the roadmap and estimation of the effort

Worked on ETL process of a Fortune 500 Biopharmaceutical firm. Additionally, completely automated the process reducing the turnaround time by 30%, making the data readily available for users.Quality Events Dashboard - Setup methodology and processes for tracking and monitoring various quality events in clinical trials across studies to leverage the information and identify critical sites and generate insights for a Fortune 500 Bio pharmaceutical firmBuild a tableau dashboard for the same which could be utilized by various site managers to compare the various clinical trial sites across the globe Root cause for poor availability and excess inventory and core metrics trackingProvided analytical solutions for poor availability and excess inventory, and core metrics tracking for fortune 50 US Pharmacy Supply Chain team ( Inventory analytics team)Set up and maintained the reporting framework for tracking core Inventory metrics, reduced the turn around time by ~10x by process automation in SAS ,Hadoop and excel VBADistribution centre stock adjustmentLeveraged time-based information,forecast data,inventory data etc to predict expected inventory deficit of ~22 million across 17 distribution centresModel to predict expected service levelsWorking on building a regression model that integrates actual service levels measured pn ground, service levels budget set by org and JDA service levels which will help to bridge the gap between the three parameters leading to estimated savings of $150 million every monthDeveloped a time series model to forecast the demand of slow moving items for optimal inventory

Detailed study of machine shop to learn about the latest technologies and process used in industry

Studied and suggested reliable and efficient means of Ferro-Alloy Handling at Ladle Furnace