Highlights:Having +13 Years of experience in Automotive Industry with OEM Organizations across India, as a Business Analyst, Extended Warranty Claims Management lead, After Sales Planning & Administration. Currently working with Ford Motor Company from past 5 Years as a Deputy Manager Strategy Analyst. Key job responsibilities are Generate revenue insights at part level based on repair order data across the region (North America, Europe, Middle East & Africa), measure the scope of revenue improvement, connect with business leads discuss on the business potential, Access big data base using Alteryx /SQL, Develop Dashboard using Qlikview/Qliksense. Working on special project to develop the dashboard for Battery Electric Vehicle Performance Insights tracking compared with Combustion Engine vehicles. Experienced and knowledgeable Business Analyst and Project Management with a demonstrated track record of leading tactical planning, scheduling, and project prioritization strategies for high profile initiatives, with focused experience in the areas of Business Intelligence, Data Analysis, Reporting, Dashboard development and Data Process Automation.

Skills:Dashboard Development, QlikView, Alteryx, Robotic Process Automation, After Sales Process & Standards, Service planning & Administration, Field Operations, Warranty Management, Dealer Management System, Business Insights, Cost Control

Goal:After Sales Planning & Administration, Extended Warranty Claims Management, Filed Service & Customer Service Management, Business Analyst Expert with +15 Years of experience in Automotive Industry with OEM Organizations across India. Proven Competence in setting up as well as turning around business, while successfully scaling them up into sustainable & profitable operations. Deft in formulating business strategies, addressing operational issues, resolving performance bottlenecks, and achieving revenue & profitability objectives

Certification:Aleryx, Python

Honor:Awarded with ‘TURBO STAR AWARD’ in Asia Motor Works Ltd. as ‘OPERATIONAL EXCELLENCE’ by two times. (For Critical failure analysis)Awarded with ‘THATKAL AWARD’ in Asia Motor Works Ltd. for product development analyzing. Recognized for ‘SPOT AWARD’ by three times special service activity & product establishment, at Mahindra & Mahindra Trucks and Buses Division. Recognized and rewarded with ‘SPOT AWARD’ for huge cost save and better system control implementation, at Ford Motor Company. Recognized and rewarded with ‘ASIA PACIFIC RECOGNTION’ for Automated Dashboard Development, at Ford Motor Company.

Customer Care Manager 06/2021 - 05/2014
Field Service Engineer – After Sales & Service, Pune, Maharastra India
Industry: Automobile Manufacturing
Customer Care Manager – After Sales & Service
• Driving the dealership team towards customer satisfaction by ensuring quality & prompt service responds. • Developing service process quality by educating & reviewing the dealership periodically. • Analysis on workshop MIS month by month to increase revenue. • Time to time warranty claim settlement. • Monthly/Quarterly warranty claim audit. • Handling Warranty administration and control of all expenses attributing to organization’s bottom line. • Warranty process implementation in dealership. • AMC claim handling & settlement to dealers within stipulated time. • AMC process implementation. • Frequent & prefixed service campaign conducting at customer location. • Service responds time analysis & review for development. • Manpower skill development by evaluating frequently. • Promotional activities organizing for customers, Drivers, Fleet managers, Technicians. • Service network expansion by allocating & developing the RSA, SYNERGYE at various locations. • Spare parts sale synchronization along with service by reviewing the MSL. • Spare parts availability at customer door, by making retailers & CTP’s. • Leading and managing Service operations in the assigned territory in line with the service standards and achieving high customer satisfaction levels. • Formulation of strategy & activity plans and service business development. • Enforcement and promotion of service policies. • Product performance Establishment. • Trouble shooting guidance to tipper site team. • Ensuring guidance to tipper site drivers for best FE establishment Dealer development. • Conducting road trials / back to back trials on haulage vehicles for product performance Technical Support at Mining site. • Back to back trials at tipper site for product establishment • Ensuring service support readiness at site in terms of manpower, parts, tools etc. with support from respective CCMs. • Identifying areas of obstruction/ breakdowns and take steps to rectify the equipment’s through application of trouble shooting tools.--
Deputy Manager Strategy Analyst 11/2016 - current
Ford Motor Company Pvt Ltd, Chennai, Tamilnadu India
Industry: Automobile Manufacturing
Deputy Manager Strategy Analyst – Ford Customer Service Devison, Global Revenue Management
o Develop spare parts market share for Global Markets (North America, Europe, Middle East & Africa, Asian, China) o Develop revenue analysis metrics for Global Markets, Measure the revenue potential, identify the scope to improve the revenue. o Feed key performance insights to business plan. o Periodic connect with market leads on Analytical results. o Access big data base using Hadoop, Alteryx/SQL o Arrange data sources from various business applications, validate the accuracy. o Preform Battery Electric vehicle retail traffic reports, BEV Vs ICE behavior analysis. o Develop dashboards on retail traffic insights, retention analysis, daily sales metrics. o Develop dashboards on repair order fill rate dashboard. o Develop Battery electric vehicle warranty costs analysis metrics. o Develop business on Battery electric vehicle & ICE vehicle parts commodities. o Manage team size of 5+ off roll members on Global analytical activities.--
Assistant Manager – After Sales planning & Administration 06/2014 - 06/2015
Isuzu Motors India Pvt Ltd, Chennai, Tamilnadu India
Industry: Automobile Manufacturing
Assistant Manager – After Sales planning & Administration
o New warranty policy creation. Implementing warranty settlement process at all over India dealers. o Warranty training to each authorized dealer present at various location of India. o ‘No pendency’ assurance all India dealer by every quarter. o Frequent warranty audit at each dealership. o Warranty settlement with Isuzu – Thailand for CBU products. o Competitor warranty process & policy study. o Product recall activity monitoring. o New retailed vehicle warranty registration. o Charge back system process creation & implementation o New warranty policy creation. Implementing warranty settlement process at all over India dealers. o Warranty training to each authorized dealer present at various location of India. o ‘No pendency’ assurance all India dealer by every quarter. o Frequent warranty audit at each dealership. o Warranty settlement with Isuzu – Thailand for CBU products. o Competitor warranty process & policy study. o Product recall activity monitoring. o New retailed vehicle warranty registration. o Charge back system process creation & implementation--
Field Service Engineer 06/2008 - 06/2012
Field Service Engineer, Bhuj, Gujarat India
Industry: Automobile Manufacturing
Field Service Engineer – After Sales & Service
• Product failure analysis investigation report to company. • Resolving Customer complaints. • Finalizing AMC agreement along with customer & dealer. • Enrolment & renewal of AMC business with dealer service support. • Looking after AMC and warranty claim settlement. • Dealer development. • New ACG & ASC introducing & developing. • ACG & ASC technical training, customer mechanic training program conducting. • On job training to Technicians and Drivers. • Monitor product performance in field • Monitoring retro fitments. • To educate customer about product • Spare parts sale monitoring & maintain the parts sale. • Synchronize with Spare and Sales dept. • Updating Dealer Application DMS & VMS--

JRN Rajasthan Vidyapeeth University 04/2009 - 04/2012
Udaipur, Rajasthan, India
Degree: Bachelor's Degree
Major:Nechanical Engineering
Passed out with First with Honor. Percentage of the mark 63%

Login to view resume: Automobile Business Analysis - Business Analyst