Back to Developers
sarabjeet singh

sarabjeet singh

Data Analyst & MIS Professional

Noida 8+ yrs exp 90 · Outstanding

About

Data Analyst & MIS Professional with 8+ years of experience in MIS reporting, data analysis, and dashboard development. Expertise in Excel, SQL, and Power BI (DAX, Data Modeling) to transform complex datasets into actionable insights. Proven track record of improving operational efficiency by 10–15% through automation and KPI tracking. Skilled in data visualization, variance analysis, and stakeholder reporting to support business decision-making.

Skills & Expertise (39)

Pivot Tables Advanced
8.0/10
8
Years Exp
MIS Reporting Advanced
8.0/10
8
Years Exp
collaboration Advanced
8.0/10
8
Years Exp
Advanced Excel Formulas Advanced
8.0/10
8
Years Exp
Reports & Dashboards Advanced
8.0/10
8
Years Exp
Data Visualization Advanced
7.5/10
5
Years Exp
Data Modeling Advanced
7.5/10
5
Years Exp
DAX formulas Advanced
7.5/10
5
Years Exp
Power Pivot Advanced
7.5/10
5
Years Exp
Data Transformation Advanced
7.5/10
5
Years Exp
Power Query Advanced
7.5/10
5
Years Exp
Query Optimization Advanced
7.5/10
5
Years Exp
Google Sheets Advanced
6.5/10
2
Years Exp
CRM Tools Intermediate
5.5/10
1
Years Exp
Data Cleaning Intermediate
5.5/10
1
Years Exp
Zoho Intermediate
5.0/10
1
Years Exp
XLOOKUP Intermediate
5.0/10
1
Years Exp
INDEX Intermediate
5.0/10
1
Years Exp
MATCH Intermediate
5.0/10
1
Years Exp
ARRAYFORMULA Intermediate
5.0/10
1
Years Exp
Salesforce Intermediate
5.0/10
1
Years Exp
HubSpot Intermediate
5.0/10
1
Years Exp
Conditional Statements Select WHERE GROUP BY Joins Aggregations Subqueries Data Types Loops Sets Functions Lists Dictionaries Seaborn Matplotlib NumPy Pandas

Work Experience

SME – L1 MIS

Coronis IT Systems Pvt. Ltd.

Dec 2022 - Present

Managed daily task allocation, report timelines, and quality checks for a team of 2–3 MIS analysts. Collaborated with Operations, WFM, and Quality teams to deliver operational and workforce MIS. Prepared productivity, volume, TAT, and quality performance reports for billing and coding teams. Reviewed attendance, shift/roster, shrinkage, adherence, and MIS before management circulation. Developed dashboards and performance summaries for senior leadership and client reviews. Assisted capacity planning and forecasting using historical workforce data. Ensured MIS validation, reconciliation, and reporting accuracy across departments.

MIS Analyst (Contract)

Capri Global Capital Ltd.

Sep 2022 - Dec 2022

Prepared MIS reports for Sales, Credit Operations, and Finance teams. Generated loan disbursement, collections, payout, and sales dashboards. Maintained attendance and productivity MIS for operations staff. Delivered branch-wise and agent-wise performance insights to management.

MIS Analyst

Dalmia Biz Pvt. Ltd.

Jun 2022 - Aug 2022

Supported sales, inventory, and operations teams with MIS reports. Prepared order volume, revenue, target vs achievement, and fulfillment MIS. Analyzed inventory movement and operational productivity. Standardized MIS formats to improve reporting accuracy and turnaround time.

MIS Executive

Blue Crumbs Pvt. Ltd.

Aug 2021 - May 2022

Prepared sales performance, booking, revenue, and site-wise MIS reports. Maintained attendance and productivity MIS for sales and field staff. Delivered management presentations and ad-hoc analytical reports.

MIS Executive

Globiss Management Solution Pvt Ltd

Jan 2018 - Nov 2020

Prepared daily and monthly MIS for sales, billing, collections, and expenses. Maintained workforce MIS including attendance, shifts, and productivity. Ensured timely MIS delivery aligned with management requirements.

Executive – Operations

Aegis Ltd.

Nov 2014 - Jul 2015

Prepared daily and monthly MIS on attendance, productivity, and agent performance. Tracked call volume, utilization, and adherence for operations review. Coordinated with supervisors and WFM teams to resolve data discrepancies.

Education

Bachelor of Computer Applications (BCA) - IEC University

- · 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 sinceJun 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation