• Maintained Redshift data warehouse, Panoply and actively build and manage our BI Tool, DOMO using SQL for both Internal and External stakeholders.• Automated key internal and external Excel and BI reports thereby helping the team track relevant KPIs real time and improving the work efficiency.• Improved savings of member companies by $2M+ by analyzing their spend pattern and proposing better quality, cheaper alternates in the General, Specialty, and Electrical MRO (Maintenance, Repair, and Operations) field.• Negotiated with national and regional vendors on special price arrangements, price challenges and purchasing actions for special member projects and programs.• Implemented a major Lab supplies MRO program by consolidating our members spend and showing more than 10% YoY savings.

• Automated the manual monthly loading process of Planned Orders into Oracle ASCP, by developing macros using Excel VBA, resulting in a 99.17% cycle time reduction.• Designed a Supplier selection mathematical model (Analytical Hierarchy Process) for Finished Goods packaging and labeling process, replacing the existing ad-hoc process, thereby improving key contract negotiations.• Optimized the Supplier selection process by identifying most relevant KPIs based on 80-20 rule, enhancing process efficiency.• Improved workforce utilization by implementing an inter-departmental Continuous Process Improvement project w.r.t the Batch Production Record (BPR) creation in Oracle EBS, thereby eliminating redundant roles and processes.• Streamlined the BPR process and prepared work instructions adhering to GMP standards by carrying out Value Stream Mapping (VSM) and mapping the Immediate To-Be and Future states, thus reducing the systems and departments involved in the process.• Participated in meetings at a global level to have a Global BPR creation Process consistency, which moderated the discrepancies across the two plants.• Built Sales and Operations (S&OE) calendar using Excel VBA macros, which helped the Supply chain and Business leaders have timely brainstorming sessions to make sure the Production team can deliver, despite occasional challenges.• Visualized the Drug Substance Production Plan in Tableau using Pareto charts and box plots, which helped keep track of different plant’s capacity utilization and their production.• Made Excel dashboards by comparing previous month’s annual Commercial Production Plan (CPP) to current months, to monitor and highlight major changes in the plan.

• Enabled Change Management at Zydus Cadila by implementing Advanced Planning and Scheduling module of Planvisage, a SCM software, that improved their due date adherence KPI by 30%, enhancing their order promising performance.• Captured the Voice of Customer (VOC) via client assessment meetings to map the As-Is process and detailed blueprinting.• Designed framework to link Planvisage with the client’s ERP system (SAP) to retrieve information w.r.t Item Master, Bill of Materials, Procurement Data, Demand Data, among others of thousands of SKU’s.• Analysed Inventory KPIs and automated the creation of Purchase Orders by querying optimized stored procedures in MS SQL Server, thus bringing down the Inventory carrying cost.• Optimized future production schedule visibility from 15 days to 60 days for ATG Tires through efficient Capacity modelling and Operations Management, thus enabling them to build long lasting customer relations.• Trained 45 client users through boardroom multimedia presentations, namely Excel and PowerPoint, and documented user manuals for the client’s better understanding of the product operations.