Nikita Mohite

MIS professional & Data Analyst

Pune, Maharashtra $4/hr Full-time 4+ yrs exp 100 · Outstanding

About

MIS professional & Data Analyst skilled in SQL, Advanced Excel, and Power BI, with proven experience in managing large datasets and developing impactful reports and dashboards. Adept at ensuring data accuracy and transforming data into actionable insights, aspiring to grow in Data Analysis, Database Administration and Business Intelligence roles.

Skills & Expertise (28)

Advanced Excel Intermediate

7.5/10

Years Exp

Microsoft Office Tools Intermediate

7.0/10

Years Exp

COUNT Intermediate

7.0/10

Years Exp

If Intermediate

7.0/10

Years Exp

SUM Intermediate

7.0/10

Years Exp

Pivots Intermediate

7.0/10

Years Exp

VLOOKUP Intermediate

7.0/10

Years Exp

Data Cleaning Intermediate

7.0/10

Years Exp

SQL Intermediate

6.5/10

Years Exp

AVG Intermediate

6.0/10

Years Exp

Charts Intermediate

6.0/10

Years Exp

Joins Intermediate

6.0/10

Years Exp

Aggregate Functions Intermediate

6.0/10

Years Exp

Full join Intermediate

6.0/10

Years Exp

Right join Intermediate

6.0/10

Years Exp

LEFT JOIN Intermediate

6.0/10

Years Exp

Inner Join Intermediate

6.0/10

Years Exp

Power BI Beginner

5.5/10

XLOOKUP Beginner

5.0/10

Power Query Beginner

5.0/10

Years Exp

DAX functions Beginner

4.5/10

Stored Procedures Beginner

4.0/10

filter Beginner

4.0/10

CALCULATE Beginner

4.0/10

SUMX Beginner

4.0/10

Macros Beginner

4.0/10

Years Exp

Data visualization with Power BI and Excel Power BI (Advanced DAX)

Work Experience

Database & MIS Executive

Sri Balaji University

Sep 2023 - Present

Managed and maintained a centralized database of 2000+ BBA students across 1st, 2nd, and 3rd year, ensuring accurate academic, finance, and attendance records. Utilized SQL queries and Excel-based MIS reporting to extract, analyze, and update large datasets for academic and administrative decision-making. Developed and maintained structured data reports and dashboards for student attendance, fee tracking, and academic performance monitoring. Ensured data accuracy, integrity, and consistency by performing regular database validation, updates, and record maintenance. Collaborated with academic and administrative departments to manage financial records, student information systems, and data-driven reporting requirements.

MIS Executive

RKvity Classes Pvt LTD

Jun 2021 - Aug 2023

Prepared and maintained daily, weekly, and monthly MIS reports using Microsoft Excel. Managed and analyzed large datasets using Advanced Excel functions (VLOOKUP, HLOOKUP, IF, COUNTIF, SUMIF). Created Pivot Tables and Pivot Charts for data analysis and reporting. Performed data cleaning and validation to ensure accuracy and consistency. Used Conditional Formatting to highlight key trends and exceptions. Generated reports for tracking student performance, admissions, and fee collection. Automated repetitive tasks using Excel formulas to improve efficiency. Ensured timely submission of reports while maintaining data integrity and confidentiality.

Education

PGDM in Marketing - MIT School of Distance Education

2024 - 2025 · Afghanistan

Bachelor of Science in Physics - Pune University (SPPU)

2017 - 2020 · Afghanistan

Certifications

Power BI

Udemy · 2026

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 5/5

🏆 Certs 5/5

✅ Verified 5/5

Total Score 100/100

Profile Overview

Member sinceJun 2026

AvailabilityFull-time

Skills (28)

Click a skill to find developers with the same skill

Advanced Excel Microsoft Office Tools COUNT If SUM Pivots VLOOKUP Data Cleaning SQL AVG +18 more

Similar Profiles

Priyanshu Mishra

React.js Software Engineer

$40/hr

Swarupa Mishra

Junior Manager

$100/hr

Lakshdeep Mishra

Accounts Analyst | Data Analyst | MIS

Gaurav Mishra

Java Backend Developer

View All Developers →