Vikas Verma
Manager
Gurgaon
Overview
14
14
years of professional experience
4
4
years of post-secondary education
Work History
Manager
Maruti Suzuki India Limited
Gurgaon
03.2020 - Current
- Led a team of 5-10 employees to meet Project schedule, resulting in no delay for Production trials. Managed cost, timeline, and quality benchmarks, ensuring line operational efficiency target of [~95%].
- Analyzed BIW defects and body quality trends for all Running models[Excel, Power BI and SQL) identifying root causes, track recurring defects, process inefficiencies and proposing solutions for improvement to Stake holders.
- Worked with cross functional teams to identify root causes at Part and Body level, leading to a 15% reduction in BIW defects and improved overall body quality maturation.
- Developed an interactive Power BI dashboard for real-time monitoring of TOP 3 defect pattern across all Running models, enabling proactive corrective actions and quality refinement.
- Developed a production line status report to track cycle time, breakdowns, and identify less efficient areas.[Excel, Power BI]
- Analyzed data to identify bottlenecks and inefficiencies which later improved production efficiency and reduce downtime, resulting in a 15% increase in overall productivity.
- Implemented automated alerts for critical items, leading to a 20% decrease in unplanned downtime and saving cost
- Implemented visualizations and dashboards to provide real-time insights for decision-making and Manpower Planning.
Deputy Manager
Maruti Suzuki India Limited
Gurgaon
03.2016 - 01.2020
- Implemented data-driven decision-making using Excel/Power BI and SQL for project performance tracking.
- Collaborated with vendors for improving project delivery success rate by 15%.
- Supplier pricing optimization
- Optimized supplier pricing data using Excel, SQL, Power BI resulting in a 10-15% increase in profit margins.
- Implemented SQL queries to analyze historical pricing data over past 3-4 models and identify trends, leading to a 20% reduction in procurement costs.
- Developed a dynamic dashboard in Power BI to track supplier performance metrics [supplier-wise spend, and on-time delivery rates.] and identify cost-saving opportunities.
- Spares Ordering Optimization
- Ensure timely availability of critical spares while minimizing excess inventory.
- Optimized spares ordering process by developing an Excel-based tool [ABC Analysis] to automate inventory tracking and ordering, resulting in a 20% reduction in lead time.
- Utilized SQL queries to analyze historical data and identify frequently ordered spares and their supplier reliability, leading to a 15% decrease in excess inventory costs.
- Created interactive dashboards in Power BI to visualize ordering patterns, usage Trend, down time Impact for critical items, resulting in a 25% decrease in stockouts.
Assistant Manager
L&T Technology Services
Vadodara
03.2011 - 01.2016
- Robotic Simulation [Siemens Software], Layout and Process Automation and optimization for meeting production volume targets.
- Resolved customer Queries and Technical feedback implementation effectively, maintaining a satisfaction rate of 95%.
- Implemented new training program for team members, resulting in a 10-20% increase in productivity.
Education
B.E - Mechanical
Faculty of Technology And Engineering
04.2007 - 03.2011
Skills
Data Analysis and Manipulation:
My SQL, Python (Pandas, Numpy,Sentiment Analysis),Excel (advanced functions, pivot tables,Market Basket Analysis)
Data Visualization: Power BI, Matplotlib, Seaborn
Analytical Skills: Data Analysis, Data Visualization, Statistics
Project management
Cross-functional teamwork
Timeline
Manager
Maruti Suzuki India Limited
03.2020 - Current
Deputy Manager
Maruti Suzuki India Limited
03.2016 - 01.2020
Assistant Manager
L&T Technology Services
03.2011 - 01.2016
B.E - Mechanical
Faculty of Technology And Engineering
04.2007 - 03.2011
Similar Profiles
SAIKAT MALSAIKAT MAL
Quality Assurance Engineer at MARUTI SUZUKI INDIA LIMITEDQuality Assurance Engineer at MARUTI SUZUKI INDIA LIMITED
VAIBHAV JAINVAIBHAV JAIN
Assistant Manager (Business Analyst) at Maruti Suzuki India LimitedAssistant Manager (Business Analyst) at Maruti Suzuki India Limited
Rahul KambojRahul Kamboj
Electric Vehicle Service Planning & Development at Maruti Suzuki India LimitedElectric Vehicle Service Planning & Development at Maruti Suzuki India Limited
Aryan SharmaAryan Sharma
Associate Manager at Maruti Suzuki India LimitedAssociate Manager at Maruti Suzuki India Limited
Sanjivani PurwarSanjivani Purwar
Tutor at TeachingTutor at Teaching