Dharmesh Verma

Background

About Dharmesh Verma

Provide strong reporting to management team. Develop consistency across reports and develop meaningful dashboards. Escalate to the Seniors Management any potentially difficult situations which may impact the monthly reports. Preparation of Client Servicing Reports for complex and sensitive clients. Performs testing, reconciliations and ad-hoc issue resolution for report creation, design, and deployment. Develop, test, and implement reports and supplemental processes to support reports for Client ( MS Reporting Services,MS Excel & Power BI) Send daily shift end reports to Client or Customer & OPS. Make the report through daily, weekly and monthly basis using Excel, VBA & Power BI. Weekly business review & Monthly business review Designing on PPT. Preparation of all the reports regarding projects as required by Operation and Client. Dashboard template designing using by Excel, Power BI & VBA. Analyze all Operational Metrics including- MIS data utilized for Operational Reporting -Ongoing review of actual productivity Validate accuracy of data to identify any possible issues or concerns Time management skills to prioritize work and meet strict deadlines Drive automation of current reporting process via available tools (eg MS Excel, VBA, Power BI tools)TYPE OF REPORTS Agent Performance TL’s & GT’s Performance Performance Day end Dashboard Weekly Dashboard for internal & Client meeting Monthly Dashboard for internal & Client meeting KPI Dashboard for Higher Management WBR/MBR Report for Client HC Report Absenteeism Report Attendance ReportSKILLS Advance Excel :1. Excel Formula2. Pie Chart3. Pivot Table4. Graph Power BI1. Data Visualization Design 2. Data Preparation – Extract, Transform, and Load (ETL) 3. Business, Math, and Statistics. VBA1. Data Visualization from different source to single file2. Reduce the Repeat task.3. Automate mail send to OPS & Higher management using VBA WFM MatrixService Level, Average handled Time, Occupancy %,Productivity %, Shrinkage %, Net Login%, Projected Revenue, Actual Revenue, Calls Per hours, Cost per Hours, Schedule Count, Present, Off, Absent, Leave, Half Day, DNR, and Absenteeism %.tool for client o