Pankaj Malviya

Experience

• 

  BVG India Limited

  Sept 2015 - Sept 2021

  Tech & Ops Support with Management Information System Analyst

  Reporting and Data Analysis:Preparation, monitoring and fetching of technical and non-technical reports based on the organizational (Dial-100- Department/ PMC/ BVG) standard and other requirements for Research, Analysis, Data study, Development, sharing. Vendor coordination and maintain the stock report (Related to product support or stock management).Receiving and downloading data from different - different sources, Cleaning and formatting data using by EXCEL.Analyze reports & other statements with a view toUpdating Data Tracker and MIS Dashboard on daily and weekly basis.Excellent in MS Excel (Hookup, VLOOKUP, lookup, Pivot Table & PivotTable Chart, Charts, data validation & Scenarios, Data Table, Reverse VLOOKUP, Multiple data access one time with VLOOKUP. Goal Seek.)Training and Documentations: Providing Training new team members. Monitoring the performance of junior staff. (3000 field employee plus other MP 53 Districts supervisor).Documentation verification to new employee.Prepare documents for training and other verification.Handling to overall managerial work MP Police Control room (Related to technical, training, vehicle Maintenance, internal audit).Technical hardware and software support Desktop remote service provide, installing application and testing.Resolved software and hardware problems and took client's feedback.Technical Support (Rugged Devices handle to Hardware & Software support). Audit and complianceExecute Maintenance Coordinate with Maintenance Executive for off road the vehicle and send to service center for upkeep as per schedule.Manage to complain portal Co-ordinate and Handling the complaint portal, Timely close the issue. Prepared daily weekly and monthly Reports on services provided.Team Management & Team SizeMonitoring and handling (3000 field employee plus other MP 53 Districts supervisor).Ask for input when making decisions.Make time for team collaboration.Focus on your team's well-being. Show less

• 

  Altius Customer Services Pvt Ltd

  Nov 2021 - Sept 2022

  Management Information System Analyst

  Reporting and Data Analysis:Data Upload Also Receiving and downloading data from different - different sources, (Sales Forces, Sticker software, Lead Management System, Slash RTC, Cleaning and formatting data using by EXCEL.Create a record for WFM CenterThere is multiple report of different campaign like sales, inbound, Chat, email to create a metrics file for comparison.In sales campaign there are different view of report – Create metrics, comparison, lead conversion lead upload for particular given format and uploaded in LMS.Create Team Wise Performance weekly and monthly report as well as compare last 6 month or year comparison.Campaign Wise Report:Sales:IN Sales Campaign there are two separate Create a lead format in excel to upload in the PLLMS & SALES LMS.To Create the CSAT & DSAT analytics Comparison of metrics and generate and publish report on the daily basics. Create a report lead wise and center wise performance.Create a dashboard for weekly and monthly.To mapping the daily ARC AND APR IN given file format. Create a key performance report, agent performance, Center performance. Email:Create the email agent performance to mapping the daily productivity for the salesforce.To Create the CSAT & DSAT analytics Create a dashboard for weekly and monthly.Create a key performance report, agent performance, Center performance. In this report AHT, SLA Call time, CSAT & DSAT, Quality and other parameter included to creating for agent performance report Show less

• 

  MIT Institute of Design

  Sept 2022 - now

  Senior Management Information System Analyst

  Report : Digital marketing lead data analysis report | Centre Data handling & Reporting | Employees data performanceReport Analysis : Daily, weekly monthly, quarterly & yearly Comparison analysisGeographical Analysis: All over India & Outside India