Process Mapping | Process Automation Role & Responsibility: -o Preparing Yearly and half yearly business plan report to enhance the growth of Company and to assign the goal of companyo Analysis and prepare Pan India partner's Marketing target towards the company's achievemento Creating of various score cards for ASM Measuremento Preparing and tracking Prayer Report on weekly and monthly basis for measurement of sales o Various other reports on Ad-hoc… Show more Process Mapping | Process Automation Role & Responsibility: -o Preparing Yearly and half yearly business plan report to enhance the growth of Company and to assign the goal of companyo Analysis and prepare Pan India partner's Marketing target towards the company's achievemento Creating of various score cards for ASM Measuremento Preparing and tracking Prayer Report on weekly and monthly basis for measurement of sales o Various other reports on Ad-hoc basic like Sale Dashboard Report, GFK Report, FPP Partners evaluation, etc. Show less

Data Analysis | Various Database Reports | Dashboard Programming |VBA Automation |Forecasting AnalysisRole and Responsibility:o Analysis and prepare retail and wholesale targets for PAN Indiao Set up a Dealer-based target vs. achievement grapho Prepare comparison SIAM Report-yearly, half yearly, quarterly.o Release the Retail Scorecard Dashboard, Dealer Dashboard, Market share Dashboard & PPT Presentationo Create reports using Excel formulas to make the reports in… Show more Data Analysis | Various Database Reports | Dashboard Programming |VBA Automation |Forecasting AnalysisRole and Responsibility:o Analysis and prepare retail and wholesale targets for PAN Indiao Set up a Dealer-based target vs. achievement grapho Prepare comparison SIAM Report-yearly, half yearly, quarterly.o Release the Retail Scorecard Dashboard, Dealer Dashboard, Market share Dashboard & PPT Presentationo Create reports using Excel formulas to make the reports in Dynamic wayo Master Month Opening Summary (MMRE) for forecasting analysiso Analysis and represent SPCR/Enquiry Mix Report through Excel/Graph/PPTo Flashing dashboard based on analysis of PMA datao Preparation of Presentation (PPT) for ISO Audit and in Various aspects of models monthlyo Analysis and maintenance on historical data of makers for forecast and planningo Facility Trackers -Sales and service Facility Tracker, Aged Stock Status Tracker, Vahaan Retail Historical Trackero Fetch data from respective sites to get Market Analysis to enhance company strategy accordinglyo Create Target Vs Achievement for comparison analysiso Providing Retail Target Explanation File to explain retail targets with root cause analysis o Flashing daily report of sold vehicles region wise, model wise, variant wise, dealer wise, etc.o Prepare presentation in PowerPoint & Dashboard as per the manager’s guidelineo Preparation of dealer agreement letters with mail merge Show less

After Promotion in MIS Department Worked for US Client Zurich American Insurance CompanyJob Responsibility:• Conceptualize, design, and implement MIS reports as required by management information needs• Work with business units/project manager to design and develop solutions to key business problems• Preparation on various process specific reports timely such as Progress analysis, Creating activity tracker, production tracker, Day end attendance record• Preparation of… Show more After Promotion in MIS Department Worked for US Client Zurich American Insurance CompanyJob Responsibility:• Conceptualize, design, and implement MIS reports as required by management information needs• Work with business units/project manager to design and develop solutions to key business problems• Preparation on various process specific reports timely such as Progress analysis, Creating activity tracker, production tracker, Day end attendance record• Preparation of Scheduled Adherence report to understand Efficiency and Occupancy of employees• Preparation of Pay for performance (P4P) Rating Report • Automated Report by Excel and VBA, Leave Tracker, APH Calculator and Break Calculator etc.• Ensure timely flow of MIS by planning and coordinating day-to-day activities with different teams• Analysis of row data to identify new performance metrics and to make decision for Projects• Maintaining utilization report for casting daily and future workflow• Coordinate with management to conduct star performer Awards Function in various aspects Show less

Worked for US Client YRCW (Yellow Roadway Corporation Worldwide)Job Responsibilities:• Providing support to the team and handling queue management in the absence of the supervisor.• Audit certain fields in a bill of lading processed by the billers and correct mistakes on those bills.• Assuring that all the fields are updated on the mainframe so that the customer does not need to resubmit the request.• Assist the new joiners in breaking out of the learning… Show more Worked for US Client YRCW (Yellow Roadway Corporation Worldwide)Job Responsibilities:• Providing support to the team and handling queue management in the absence of the supervisor.• Audit certain fields in a bill of lading processed by the billers and correct mistakes on those bills.• Assuring that all the fields are updated on the mainframe so that the customer does not need to resubmit the request.• Assist the new joiners in breaking out of the learning curve.• Analysis the data of audit department and give the suggestion to our senior. Show less