Pavan Malapati

Supply Chain Analyst @Cognizant

US

Optimized upstream supply chain operations in drilling and production by integrating forecasting, logistics, and procurement data, improving material planning accuracy and service delivery. • Managed sourcing and procurement cycles (SOW, RFQ/RFP, PO, PR) through SAP ERP, ensuring 100% on-time delivery of drilling tools, chemicals, and rental equipment. • Built predictive inventory and demand planning models using Python (Pandas, NumPy) and SQL, reducing stockouts by 20% and minimizing excess inventory costs. • Developed real-time dashboards using SQL, Power BI, and DAX to track rig utilization, equipment availability, and supplier KPIs, enabling faster data-driven decisions. • Achieved 15% cost savings in drilling operations by conducting supplier benchmarking, performance analysis, and negotiation using structured procurement data. • Automated supply chain reporting workflows using advanced SQL queries and Power BI refresh pipelines, cutting manual reporting time by 30%. • Conducted root cause analysis of logistics and inventory disruptions using data mining techniques and RCA frameworks, improving reliability and reducing rig downtime. • Collaborated with cross-functional teams across engineering, procurement, and finance to apply quantitative modeling and scenario planning for optimized demand-supply alignment and global logistics network design.

VRS & VIGNANA JYOTHI RESIDENTIAL SCHOOL

School

VNR Vignana Jyothi Institute of Engineering and Technology (VNRVJIET)

Bachelor of Technology - BTech, Civil Engineering

Urbane Junior College

Intermediate, MPC

California State University - East Bay

Master of Science - MS, Statistics-Data Science