Dhruv Sai

Data Analyst with internship experience in manufacturing operations at Kennametal India Ltd and four-projects built In Python, SQL, Power BI, and Tableau. Ran end-to-end Analysis on 1,400+ sales records, built pricing dashboards, and designed BI reports from scratch. Comfortable going from a messy spreadsheet to something a stakeholder can actually read.

Data & Operations Intern at Kennametal India Ltd (2025-07 – 2025-09)

Data and Operations Intern focused on manufacturing dataset analysis and inventory management

• Built an Excel lookup system (XLOOKUP, INDEX-MATCH) to merge 3 manufacturing datasets covering 1,000+ parts, removing the need for manual cross-referencing and improving data retrieval.
• Identified under-stocked parts across inventory records and mapped gaps by part category; findings were raised to the production scheduling team for planning review.
• Reconciled physical stock counts against system records, flagged discrepancies and reorganized storage layout to reduce retrieval time.

B.E. in Mechanical Engineering – M S Ramaiah Institute of Technology (2022 – 2025)