Back to Developers
Sumit Rajak

Sumit Rajak

MIS Specialist | Data & Operations Analyst

Malda, West Bengal, India 5+ yrs exp 90 · Outstanding

About

MIS & Data Analytics professional with 5+ years of experience in data analysis, KPI reporting, dashboard development, reporting automation, and process improvement across retail and corporate environments. Experienced in Power BI, Advanced Excel, SQL, Power Query, VBA, DAX, and ERP data analysis, with a strong focus on operational reporting, performance insights, and management decision support. Skilled in automating recurring reports, analyzing trends, improving reporting efficiency, and delivering actionable insights to business stakeholders. Currently pursuing an MBA in Operations & Data Science from NMIMS CDOE.

Skills & Expertise (27)

Advanced Excel Advanced
8.5/10
5
Years Exp
Power BI Advanced
8.0/10
5
Years Exp
Operational Reporting Advanced
8.0/10
5
Years Exp
KPI Dashboards Advanced
8.0/10
5
Years Exp
MIS Reporting Advanced
8.0/10
5
Years Exp
Pivot Tables Advanced
8.0/10
5
Years Exp
SQL Intermediate
7.5/10
5
Years Exp
Presentation Skills Intermediate
7.0/10
5
Years Exp
Adaptability Intermediate
7.0/10
5
Years Exp
Time management Intermediate
7.0/10
5
Years Exp
Teamwork Intermediate
7.0/10
5
Years Exp
Problem Solving Intermediate
7.0/10
5
Years Exp
Analytical Thinking Intermediate
7.0/10
5
Years Exp
Management reporting Intermediate
7.0/10
5
Years Exp
Performance Analysis Intermediate
7.0/10
5
Years Exp
Business Analysis Intermediate
7.0/10
5
Years Exp
Team coordination Intermediate
7.0/10
5
Years Exp
Process Improvement Intermediate
7.0/10
5
Years Exp
KPI Analysis Intermediate
7.0/10
5
Years Exp
Google Sheets Intermediate
7.0/10
5
Years Exp
Macros Intermediate
6.5/10
5
Years Exp
VBA Intermediate
6.5/10
5
Years Exp
SAP Intermediate
6.5/10
5
Years Exp
Power Query Intermediate
6.0/10
3
Years Exp
DAX Intermediate
6.0/10
3
Years Exp
Tableau Intermediate
5.5/10
2
Years Exp
Data Validation

Work Experience

MIS Specialist | Accounts Receivable

Genpact India

Nov 2025 - Present

Managing billing, invoicing, and MIS reporting activities using SAP and ERP systems. Developing daily, weekly, and monthly MIS reports using Advanced Excel and Google Sheets to track operational KPIs and business performance. Automating recurring MIS reporting using advanced Excel formulas, Pivot Tables, and lookup functions, reducing manual effort by 40%. Handling data validation and reconciliation for billing and reporting activities. Monitoring KPIs such as billing accuracy, aging reports, productivity, and process performance. Preparing management dashboards and ad-hoc analytics using Power BI to support operational reviews and decision-making. Identified reporting inefficiencies and standardized MIS templates and workflows, improving reporting efficiency and reducing turnaround time. Coordinating with internal teams to resolve billing and reporting-related issues.

Senior MIS Executive

Oppo Mobile

May 2023 - Nov 2025

Prepared daily and monthly MIS reports using Advanced Excel, Power BI, Google Sheets, and ERP data. Improved reporting efficiency by 40% through automation using VBA macros, formulas, and data consolidation techniques. Analyzed sales and operational KPIs to support management reporting and business decisions. Managed and coordinated a team of 8, assigning reporting activities, monitoring deliverables, and ensuring timely completion of operational MIS requirements. Coordinated team activities and monitored workload, productivity, and operational performance to support effective task allocation and timely completion of deliverables. Automated data refresh and validation processes for recurring MIS reports, reducing manual effort and improving reporting accuracy. Managed data validation and reconciliation between ERP records and MIS reports. Created dashboards and performance reports for sales and operational tracking.

Cashier & Accountant

Reliance Retail

Sep 2021 - Apr 2023

Managed daily cash flow of ₹3–5 lakh and supported cash reconciliation activities. Recorded and tracked sales, stock, and cash transactions using SAP and Excel for daily operational reporting. Maintained inventory records and reduced stock mismatches by 20% through regular monitoring and Excel-based tracking. Assisted in billing operations, customer handling, and compliance with store procedures and reporting standards. Supported onboarding and training of new cashiers on billing and operational processes.

Education

MBA – Operations & Data Science - NMIMS CDOE

2025 - 2027 · Afghanistan

M.A. – Political Science - Netaji Subhas Open University

2022 - 2024 · Afghanistan

B.A. – Political Science - Malda College

2016 - 2019 · Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 15/15
💰 Rate 0/5
🏆 Certs 0/5
✅ Verified 5/5
Total Score 90/100

Profile Overview

Member sinceOct 2026