MOHD SHEHNAWAJ

MIS Analyst | Data Analyst

Experienced MIS and Data Analyst with 9+ years of expertise in data management, operational reporting, workforce analytics, dashboard development, automation, and business insights across BPO, Telecom, and Mortgage domains.

Call: +91 98719 01050 Email LinkedIn View Experience

Profile Highlights

Experience: 9+ Years

Location: Uttam Nagar, New Delhi

Specialization: MIS Reporting, Excel Automation, SQL, Dashboards

Domains: BPO, Telecom, Mortgage, Workforce Analytics

Professional Summary

MIS Analyst and Data Analyst with strong experience in data management, operational reporting, workforce analytics, P&L reporting, agent performance analysis, trend analysis, dashboard creation, data validation, and process automation. Skilled in Advanced Excel, VBA Macros, MySQL, SQL, MS Access, and Google Sheets, with a proven ability to deliver accurate reports and actionable insights to senior stakeholders.

Key Competencies

Technical Skills

Advanced Excel Pivot Tables VLOOKUP XLOOKUP VBA Macros SQL MySQL MS Access Power BI Python Google Sheets

Analytical Skills

Data Analysis MIS Reporting Dashboard Development Data Visualization Trend Analysis Forecasting Capacity Planning Workforce Analytics

Soft Skills

Stakeholder Management Team Management Critical Thinking Problem Solving Leadership Negotiation

Professional Experience

Amadeus Distribution India Enterprise Pvt. Ltd.

Process Associate | Feb 2026 – Present

  • Designed daily, weekly, and monthly MIS reports for productivity, attendance, SLA compliance, and agent performance.
  • Created Excel-based dashboards to track operational KPIs and support senior management decisions.
  • Performed data validation, cleaning, and quality checks to maintain report accuracy.
  • Generated ad-hoc reports and insights on workforce trends and SLA performance.

Interglobe Technology Quotient / ITQ Technologies Pvt. Ltd.

WFM Analyst | Feb 2024 – Jan 2026

  • Monitored and shared interval-wise Abandon Reports during operational hours.
  • Prepared daily Agent Performance, Attendance, and Shift Adherence Reports.
  • Automated recurring reports using Advanced Excel formulas and VBA Macros.
  • Compiled Monthly Review and Agent Bonus Reports for senior management and payroll processing.

Welco Infotech Pvt. Ltd.

MIS Executive | Dec 2022 – Jan 2024

  • Managed databases of 100+ VoIP clients using Excel and MySQL.
  • Generated daily Profit & Loss reports for senior and C-level stakeholders.
  • Prepared weekly, fortnightly, and monthly MIS reports.
  • Mapped pricing and service modules to ensure accurate billing and reporting.

Suntec Web Services Pvt. Ltd.

Process Associate | Apr 2016 – Nov 2022

  • Managed US Mortgage data processing in MS Access databases.
  • Performed data cleaning, duplicate identification, validation, and discrepancy resolution.
  • Generated daily and weekly MIS reports for team leads and stakeholders.
  • Worked across projects including US Medical Log Processing, Social Media CMS, and IntoGO App.

Education

Master of Computer Applications

IGNOU, New Delhi | 2014 – 2016

MCA with focus on computer applications, databases, and technology-based problem solving.

Bachelor of Computer Applications

IGNOU, New Delhi | 2011 – 2014

BCA with foundation in programming, database management, and computer systems.

Languages

English Hindi
↑
```