Mohit Kumar Ojha

Data Analyst & MIS Executive

Experience : MIS Executive

1 Year 11 Months experience in data reporting, data analysis, and dashboard management.

Skills :

Excel / Sheets (95%)

BI Tools (90%)

SQL (90%)

Data Analysis (92%)

Data Visualization (95%)

Data Cleaning (90%)

About Me

Welcome to my portfolio! I’m Mohit Kumar Ojha, a Data Analyst & MIS Executive with experience in data reporting, dashboard development, MIS reporting, and business intelligence. Skilled in Excel, SQL, Power BI, Tableau, Looker Studio, and Python, with a strong focus on automated reporting, data analysis, and data-driven decision-making. Currently working as an MIS Executive at Smile Foundation .

Profile : Data Analyst & Business Analyst
Education : Bachelor of Arts (History)
Tools : Advanced Excel, Power BI, Tableau, SQL, Looker Studio, DAX, Power Query, Python (NumPy, Pandas, Matplotlib, Seaborn).
Skills : Data Analysis, Data Cleaning, ETL, KPI Reporting, Dashboard Automation & MIS Report
Software : Google Sheets, MS Office, Copilot, Google Forms, MySQL, PostgreSQL, Jupyter Notebook, VS Code.
Soft Skills: Analytical Thinking, Problem Solving, Teamwork, Communication, Time Management, Business Analysis
Language : Hindi & English
Interest : Traveling, Singing, Dancing, Teaching, Cricket

0 + Projects completed

GitHub

Resume

Data Analyst & MIS Executive with strong expertise in Advanced Excel, SQL, Power BI, Python, Tableau, and Looker Studio. Experienced in data cleaning, data modeling, ETL workflows, KPI reporting, dashboard development, and MIS reporting. Proven ability to optimize reporting workflows and build interactive dashboards, driving faster, data-driven decision-making .

Experience

MIS Executive — Smile Foundation

Sep 2025 – Present

Tools: Advanced Excel, Power BI, Looker Studio, SQL, Google Sheets, Power Query, Google Forms etc.

Processed and analyzed large datasets to generate insight-driven MIS reports.
Built dashboards in Excel, Power BI, and Looker Studio, improving decision-making by 40%.
Automated reporting using Google Forms, Sheets, and ETL, reducing delivery time by 30%.

MIS Executive — Greet India (Gifts) Foundation

Apr 2024 – Aug 2025

Tools: MS Office, Advanced Excel, Google Sheets, Power BI, Tally, Google Forms, Looker Studio etc.

Trained 300+ students in MS Office, Excel, Google Sheets, Tally, Power BI, and Google Forms.
Designed and optimized MIS reporting templates, improving accuracy and consistency.

Data Analyst — Unified Mentor (Internship)

Sep 2024 – Oct 2024

Tools: Power BI, MYSQL, Python, Excel, Power Query etc.

Internship Certificate 👈

Analyzed 1,000+ data points using Power BI, Tableau, SQL, and Python.
Built dashboards that reduced reporting time by 30% and improved insight accuracy by 20%.