Sanjeev Kumar
Ghaziabad
Summary
Results-driven MIS Analyst with extensive experience in process automation, data visualization, and workforce management. Proficient in leveraging tools like VBA, Power BI, and SQL to enhance reporting efficiency. Adept at analyzing and optimizing business operations to support organizational goals. Strong analytical skills with a keen eye for identifying process improvements. Proven ability to handle large datasets, optimize reporting processes, and provide actionable insights to drive business growth. Qualified Business Intelligence Analyst versed in data mapping and user acceptance testing to solve complex problems in high-pressure environments. Activates strong analytical skills to investigate trends in large amounts of data and formulate conclusions based on findings. Excels at cultivating, managing and leveraging client relationships to foster extended engagements and business opportunities.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Sr. Analyst WFM (Automation & Visualization)
Cognizant Technology Solutions India Pvt. Ltd.
Gurgaon
07.2023 - Current
- Automated reporting processes using VBA and Power BI, reducing manual efforts
- Prepared and managed comprehensive MIS & WFM reports, including attendance, agent performance, and schedule adherence
- Developed dashboards and interval reports for real-time analysis
- Conducted impact analysis for unplanned downtimes and operational inefficiencies
- Managed Power BI templates, ensuring optimized presentation and data accuracy
- Collaborated with stakeholders to optimize workforce planning strategies
- Designed and implemented reporting solutions for business insights and decision-making
Sr. Analyst WFM (Automation & Visualization)
BC Management Services Pvt Ltd (British Council)
Noida
01.2023 - 07.2023
- Designed automated manpower planning templates for efficient scheduling
- Developed and managed Short-Range & Long-Range Forecast (SRF & LRF)
- Created daily, weekly, and monthly C-SAT reports for email and chat support
- Worked closely with cross-functional teams to improve reporting accuracy and efficiency
Sr. Associate WFM
Capgemini Technology Pvt Ltd
Noida
05.2021 - 12.2022
- Prepared shrinkage and attrition reports, ensuring workforce optimization
- Designed and automated digital utilization reports for enhanced tracking
- Assisted in real-time monitoring and performance tracking
- Improved forecasting accuracy by analyzing historical workforce trends
Sr. MIS Executive
Ganpati Hi-Tech Distributors Pvt Ltd
Ghaziabad
06.2017 - 08.2019
- Managed MIS reporting and data analysis for business performance tracking
- Automated key reports, improving reporting efficiency
- Analyzed revenue trends and operational efficiency
MIS Coordinator
Digicall Teleservices Pvt Ltd
NOIDA
02.2016 - 06.2017
- Developed daily/monthly performance dashboards
- Managed service level achievement through optimized scheduling
- Automated multiple reporting processes for efficiency gains
Education
Bachelor of Arts -
Sunrise University
RajasthanIntermediate & Matriculation -
B.I.E.C
Diploma in Computer Applications -
Skills
- Power BI
- Power Query
- MS Excel (Advanced)
- Google Sheets
- Macro/VBA
- SQL (Basic)
- Python (Basic)
- Forecasting
- Scheduling
- Shrinkage & Attrition Analysis
- Agent Performance Reports
- AHT Reports
- Shift Hours Dashboards
- C-SAT Analysis
- QBR
- MBR
- WBR Report Analysis
- Automating repetitive tasks
- Operational efficiency
Languages
- Hindi
- English
Personal Information
- Date of Birth: 01/26/87
- Nationality: Indian
- Marital Status: Married
Technical Skills
Power BI, Power Query, MS Excel (Advanced), Google Sheets, Macro/VBA, SQL (Basic), Python (Basic), Forecasting, Scheduling, Shrinkage & Attrition Analysis, Agent Performance Reports, AHT Reports, Shift Hours Dashboards, C-SAT Analysis, QBR, MBR, WBR Report Analysis, Automating repetitive tasks to enhance operational efficiency
Certification
- PL-300 Certification : Microsoft Power BI Data Analyst
- Python for Absolute Beginners from Udemy
Timeline
Sr. Analyst WFM (Automation & Visualization)
Cognizant Technology Solutions India Pvt. Ltd.
07.2023 - Current
Sr. Analyst WFM (Automation & Visualization)
BC Management Services Pvt Ltd (British Council)
01.2023 - 07.2023
Sr. Associate WFM
Capgemini Technology Pvt Ltd
05.2021 - 12.2022
Sr. MIS Executive
Ganpati Hi-Tech Distributors Pvt Ltd
06.2017 - 08.2019
MIS Coordinator
Digicall Teleservices Pvt Ltd
02.2016 - 06.2017
Bachelor of Arts -
Sunrise University
Intermediate & Matriculation -
B.I.E.C
Diploma in Computer Applications -
Similar Profiles
Jatin Bholanath MattaJatin Bholanath Matta
Sr. Product and Soft Skills Trainer at Cognizant Technology Solutions India Pvt. Ltd.Sr. Product and Soft Skills Trainer at Cognizant Technology Solutions India Pvt. Ltd.
Vivekkannan SekarVivekkannan Sekar
SAP BW on HANA Consultant Technical Lead at Cognizant Technology Solutions India Pvt. LtdSAP BW on HANA Consultant Technical Lead at Cognizant Technology Solutions India Pvt. Ltd
Ahamadali GAhamadali G
Senior Service Delivery Manager at Cognizant Technology Solutions India Pvt LtdSenior Service Delivery Manager at Cognizant Technology Solutions India Pvt Ltd