Strategic inventory optimization and process improvement based on spend pattern analysis▪ Integrated 36,000+ data lines of PO, GRN, and Consumption, spanning 3 FYs valuing INR 7610 Cr▪ Developed a Excel dashboard across 17 categories and 3 FYs for improved data readability▪ Analyzed spillover data and crafted automated inventory check foreseeing an 80% reduction in NMI▪ Examined usage trend and recommended scheduling PO release projecting a 45% lesser holding time▪ Proposed implementing an automated purchase block aiming for a 100% cut-down of surplus orders▪ Suggested default checks for suppliers to reduce lead time and open orders by 45% through re-evaluation▪ Identified and revamped a critical SAP error causing negative lead time for 34 line items

Database management and data transfer between platforms through ETL operations▪ Migrated over 250 million insurance records from Teradata to PostgreSQL with zero error rate▪ Optimized 100+ SQL queries for efficient data transfer resulting in a 70% reduction in execution time▪ Acted as the liaison between the testing and development teams to facilitate testing and bug fixes▪ Synergized with program managers and onshore leads for requirement planning and updates▪ Bolstered the team in sprint planning and user story management following agile methodology