Ritvik Sharma

● Import Procurement & Cost Control: Spearheaded international procurement and strategic sourcing for raw materials (Steel, Aluminum) and trade components (Hoses) across Italy, China, and Taiwan; managed end-to-end white- label production cycles to expand product portfolios while maintaining high quality standards. ● Logistics & Compliance Management: Managed end-to-end import logistics collaborating with Freight Forwarders for shipment booking and CHA for customs clearance—including BOE filing, documentation control, and the resolution of customs queries ● Demand Forecasting & Data Analysis: Engineered an end-to-end forecasting ecosystem by architecting a Power BI demand forecasting dashboard using ETS-modeled sales trends, fetching sales data from SQL to Power BI and streamlined the MRP update process by exporting this forecast to optimize Min/Max levels, safety stock and reorder point parameters from Power BI into SAP B1 via DTW, ensuring procurement was always aligned with current market demand. ● Inventory Optimization: Analysed Inventory Turnaround Time (TAT), ABC/XYZ and Pareto classifications to identify slow-moving and non-moving inventory using powerful 9-box matrix that tells you exactly how to set your SAP B1 parameters, driving measurable improvements in inventory health and achieving a 12% reduction in excess safety stock and an 8% improvement in inventory turnover. ● Vendor Management and Performance Tracking: Created Supplier On-Time Delivery (OTD), Quality Defect PPM, and Cost Compliance dashboards in Power BI to track supplier performance and mitigate risk. ● Technical & Analytical Skills: Utilized Power BI and Advanced Excel to transform raw supply chain data into actionable dashboards, insights, and KPI reports for executive-level decision-making.

● Strategic Sourcing & E-Bidding: Managed the end-to-end procurement lifecycle for OPEX, Packaging, MRO, Chemicals, and Utilities, aligning sourcing strategies with operational needs converting PR to PO within TAT to ensure 100% material availability. ● Vendor Sourcing & ERP Integration: Handled Source-to-Pay process by managing vendor onboarding and e-bidding on SAP Ariba and Reliance RFX; maintained 100% data accuracy within SAP S/4HANA for the entire PR–PO lifecycle, facilitating seamless financial month-end closures and ensuring full compliance for internal/external audits. ● Negotiation & Cost Optimization: Negotiated competitive pricing, payment terms, and SLAs with suppliers by leveraging Reliance RFx platform to draw RFI, RFQ, RFP to develop comparative analyses, delivering measurable cost savings and improving overall Cost of Goods Sold (COGS). Implemented should-cost and TCO models using advanced Excel and Power Query, improving negotiation outcomes with key suppliers. ● Data Analytics & Dashboard Development: Leveraged Power BI to eliminate manual Excel exports, establishing a direct link between dynamic data pipeline using OData Services to retrieve data from SAP S/4HANA backend tables for real-time tracking of Supplier OTIF and Material Price Variances. ● Inventory & VMI Management: Oversaw Vendor Managed Inventory (VMI) and inventory ageing, implementing precise tracking of lead times and consumption patterns to optimize replenishment cycles and minimize stockouts. ● Supplier Performance & KPI Tracking: Monitored vendor performance through KPIs such as OTIF (On-Time-In-Full), lead-time adherence, On-Time Delivery (OTD), Defect Rate (PPM) using Power BI dashboards and SAP Ariba. ● Contract: Supported principals on Annual Rate Contracts (ARC) and Annual Maintenance Contracts (AMC).

● Delivering proactive technical support enhances supply chain resiliency and fosters operational excellence, directly contributing to core business objectives. ● Forecasting & Demand Categorization: Managed end-to-end demand forecasting for high-priority engine programs, including LEAP, GEnx, and CF6, using Oracle Demantra; categorized spare parts by Lumpy, Intermittent, and Erratic demand profiles to apply tailored statistical models. ● Material Planning & Inventory Optimization: Executed demand planning within Oracle AMPS (Aerospace Material Planning Systems), adjusting lot sizes and procurement schedules to align with engine shop visit forecasts. ● Data Analytics & Performance Reporting: Engineered automated Forecast Accuracy dashboards to track Forecast accuracy across different engine platforms, driving continuous improvement in supply chain reliability.