Dedicated and Confident Data Professional with almost 7 years of Experience into preparation of analytical reports, Dashboards using Advance Excel and for 1 last year using with Power BI as well in HR analytics.
• Preparation of Pan India Agent performance report on Excel [ Productivity, FTF, ASAT Scores]
• Preparation of pan India KPI report using Advance Excel with different formulas
• Downloading Dump for from multiple CRM’s [ Swift, Sumeru, Hyperion tool]
• Uploading daily closures data in SQL on daily basis
• Preparation of reports for different processes [Wcom, NFLC]
• Providing data as per client’s requirement
• Providing overall dump as per requirement
• Providing hourly dump as per requirement
• Providing Training to new team members
• Checking and Answering escalation and other mails on daily basis
• Preparing daily sales report in excel (invoice/billing & receipts entries difference between Tally v/s CRM)
• Preparing appointment and NC report on daily basis with useful information by providing to respective department
• Doing invoicing/billing in TALLY ERP 9.0 and CRM on behalf of clinic due to lack of availability of accountant
• Converting raw data into useful information using advance excel
• Co-ordination of MIS reports with different departments (lab/customer care)
• Maintaining day to day operations (Support to the staff regarding invoicing and other operational entries)
• Training of new joiners & technical support of CRM software (newly developed)
• Solving the problem of concerned department (lab/clinics/call center/customer care/operations/inventory)
• Providing ideas for development of new CRM & required help in implementing the new CRM
• Preparing documents regarding different- different modules in the CRM software as per manager
• Coordinating to the HOD of concerned department regarding their query and requirement in CRM
• Working as a team player and leading CRM team
• Preparation of clinics audit report of done and not done entries and sending them on daily basis
• Preparation of user manuals for all the operation module in the CRM using Microsoft word
Power BI
Tally ERP 9.0