Ajay Jaiswar Email and Phone Number

● MIS Executive & Data Analyst.● Making Data of working process sheet of excel. ● Prepare corresponding & sending regular reports via email. ● Advanced MS Excel Knowledge (Conditional Formatting, V-lookup, H-lookup, IF Function, Count Function, Sum Function, Index Match, Data Validation, Data Sorting)● Working in excel as per data in Filter, Pivot table, & V-lookup. ● Preparing Reports and Dashboards for client and central management. ● MIS Preparation of… Show more ● MIS Executive & Data Analyst.● Making Data of working process sheet of excel. ● Prepare corresponding & sending regular reports via email. ● Advanced MS Excel Knowledge (Conditional Formatting, V-lookup, H-lookup, IF Function, Count Function, Sum Function, Index Match, Data Validation, Data Sorting)● Working in excel as per data in Filter, Pivot table, & V-lookup. ● Preparing Reports and Dashboards for client and central management. ● MIS Preparation of Daily/Weekly/Monthly records & data management. ● Maintenance & sharing of Daily /Weekly/Monthly report and as company required. ● Will be required to support other internet software where logical understanding can be utilized for report preparation. ● To get the raw Data, Paste it in applicable spreadsheets. ● Generating MIS Reporting as per company requirement. ● The technique used for collecting, compiling, and storing information and skills for contributing in the manufacturing of quality products. ● Maintain and update records with accuracy. ● To keep records and information about deals with clients. ● Analyze the actual sales versus the projected ones for each department. ● Supporting the field sales team regarding his performance, new product information, upcoming product internal support etc. ● Utilize graphic design tools and software to develop create custom PowerPoint presentations and templates from pre-generated content ● Manage the library of PowerPoint creative materials. ● Built effective database solutions using Microsoft Access based on unique needs. ● Developed and maintained Microsoft Access database. ● Create powerful queries to extract large database information from Excel to Access. Show less

Worked for HDFC Bank LI Complaints team on HDB Financial services Payroll as MIS OFFICER.• Preparing daily basis MIS report on pending cases.• Publishing Daily MIS Report ( Dashboard) at PAN India level for cases which are pending for actionable from branches.• Preparing weekly MIS Report on Refund tracker for policies which are accepted for cancellation by the committee and sharing with insurer.• Sharing the month wise update with the insurers related to the complaints… Show more Worked for HDFC Bank LI Complaints team on HDB Financial services Payroll as MIS OFFICER.• Preparing daily basis MIS report on pending cases.• Publishing Daily MIS Report ( Dashboard) at PAN India level for cases which are pending for actionable from branches.• Preparing weekly MIS Report on Refund tracker for policies which are accepted for cancellation by the committee and sharing with insurer.• Sharing the month wise update with the insurers related to the complaints cases received.• Drafting mails and sending it to branches and channels for inputs.• Follow with the branches and insurers for inputs.• Arranging requirements for investigation from insurers• Logging and Closing cases in CRM.• Resolving customer service related quires through mails.• Following up with the internal teams for sharing complete details post checking case in CRM.• Updating cases in MOM which were discussed in L2 committee and sharing the same with the Product Managers in case of any queries raised.• Updating the Master file post confirmation received from Product Managers related to the decision made on any of the complaints cases.Skill Show less