Lokesh Devaraju

• Cost Saving through Spend Analysis (Strategy-80:20, 1:1:1 till 1:1:10, Top spend, Last Price Paid).
• Strategic Sourcing & Business Align data analytics, dynamic reports through Excel, 4 blockers PPT & Power BI visuals/dashboards for Decision Making.
• RCCA, BKM, SOP's, ADHOC resolutions, simple VBA.
• Applications - Microsoft (Excel, PPT, Power BI, Teams, Planner, Outlook, SharePoint) & SAP.

Metrics:

• 2 data sets with 610 variances were reduced to 40 in a week for 78 events (93%), through append variance report.
• 1.2 M$ savings in FY 24-25 (10%) through spend analysis.
• 4 FTEs (16%) movement through minimal & maximal efforts activity calculation.
• Regular tasks turnaround time reduction from 5 hrs. to 3 hrs (60%).
• 115+ commodities (Primary, Sub & Tech classifications) classification & validation
• 85,000+ parts Part Drawings download automation through VBA.

• PPPC (PO Place, Pull, Push, Past Due and Cancel).
• 10M$ savings through PO cancellations.
• MRB clearance of 100+ parts in a day.
• Variance clearance of 80+ parts in a day.
• Dashboard – Material Shortages, PO acknowledge, PO communication, Free Stock, Variances, MRB & re-work orders, Contract Management.
• RCCA & ADHOC resolutions, Project support to SCM (Supply Chain Management) divisions.
• Applications - Microsoft (Excel, Teams, Outlook), SAP & Web Dashboard.

• DTP review and update, leading process with responsibility of handling a team, Generate Idea, Primary Buyer and Documentation.
• Identify potential suppliers with effective pricing and payment terms, RFQ & PO creation.
• Contributing to cost savings by either boarding low-cost vendors or re-negotiating with existing vendors.
• Preparing spend report for preferred vendors vs non-preferred vendors.
• Preparing weekly reports on Outstanding receipts report and publishing to all plants.
• Applications - Maximo, Coupa & SAP.