Automated inventory tracking logs in Excel, improving efficiency by 20%, reducing manual errors, and enhancing stock visibility.
Developed an Excel-based dashboard to monitor worker attendance from biometric data, leading to a 12% reduction in overtime costs through optimized scheduling.
Provided logistical support for raw material procurement, coordinating supplier communications, tracking deliveries, and managing invoices to ensure uninterrupted production.
Supported the project manager in planning, evaluation, and ensuring timely completion of projects while adhering to quality assurance standards.
Business Operations Intern – Customer Service & Operations
Hyundai Motor India Ltd.
Noida, India
05.2021 - 08.2021
Designed and generated over 20 weekly performance dashboards in Excel to track vehicle turnaround time and other KPIs for leadership.
Conducted root cause analysis which contributed to a 12% increase in operational efficiency.
Forecasted hardware component demand based on vehicle servicing schedules, reducing excess inventory by 20%.
Standardized weekly sales data collection and reporting processes, ensuring 100% accuracy and timeliness for quality assurance.