Mohit Kumar Ojha

Data Analyst & MIS Executive

Experience : MIS Executive with 1 Year 6 Months Experience in data reporting, analysis, and dashboard management.

Skills :

Excel / Sheets (95%)
BI Tools (90%)
SQL / MySQL (90%)
Python (Libraries) (80%)
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 strong experience in data reporting, dashboard development, and business intelligence. I specialize in converting raw data into meaningful insights using tools like Excel, SQL, Power BI, Looker Studio, Tableau, and Python. My focus is on building automated reporting systems, improving data accuracy, and creating interactive dashboards that support smarter and faster decision-making.

Currently, I work as an MIS Executive at Smile Foundation, where I manage end-to-end reporting, visualization, and data validation processes. Previously, I gained hands-on experience as a Computer Trainer & MIS Executive and completed a Data Analyst Internship at Unified Mentor, working with real-time datasets and analytical problem-solving. I’m passionate about continuous learning and using modern analytics tools to help organizations optimize workflows and make data-driven decisions with confidence.

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

0 +   Projects completed

GitHub

Resume

Resume

Detail-oriented and result-driven Data Analyst | MIS Executive | MIS Analyst | Business Analyst with hands-on experience in Advanced Excel, Google Sheets, SQL, Python, Power BI, Tableau, Looker Studio, Business Intelligence and Data Reporting. Skilled in building dashboards, cleaning datasets, automating reports, and generating actionable insights that support data-driven decision-making by up to 40%.

Experience


Sep 2025 - Present

MIS Executive

Smile Foundation.

Smile Foundation is a non-profit organization supporting underserved communities through education, healthcare, and livelihood programs.

  • Analyzed and processed large datasets, creating detailed reports in Excel, Power BI, and Looker Studio, improving decision-making by 40%.

  • Used Google Forms, Sheets, Excel, Looker Studio, Power BI, and ETL tools for data cleaning and automation, reducing reporting time by 30%.

Apr 2024 - Aug 2025

MIS Executive

Greet-India (Gifts) Foundation.

Greet India Coaching Institute is a reputable educational center focused on providing quality training in computer applications and IT and technology .

  • Trained 300+ students in ADCA, MS Office, Excel, Tally, Google Sheets, Google Forms, Looker Studio, and Power BI with 95% satisfaction.

  • Designed and automated MIS reports supporting effective decision-making.

Sep 2024 - Oct 2024

Data Analyst (Intern)

Unified Mentor

Unified Mentors is a professional training and internship provider that helps individuals develop skills in fields like data analysis .

  • Analyzed 1,000+ data points using Power BI, Tableau, Python, improving insights by 20%.

  • Built dashboards using SQL, Excel, and ETL tools, reducing reporting time by 30%.



Education


Bachelor's Degree

Session:- 2021 to 2024

Veer Kunwar Singh University , Ara (Bihar).
Duration:- 2021 to 2022
Advance Diploma In Computer Applications
From : - Greet-India (Gifts) Foundation.
Advanced Excel

Duration: - 30 Days Mar to Apr 2024

From : - Skill Course E-Learning Platform.
Microsoft Power BI

Duration: - 30 Days Sep to Oct 2024

From : - Skill Course E-Learning Platform.
Data Analytics

Duration: - 6 Months jun to Dec 2024

From : - Esclancer E-Learning Platform.
Data Analyst internship

Duration:- 1 Month Sep to Oct 2024

From : - Unified Mentor.
SQL Course

Duration:- 1 Month Jan to Feb 2025

From : - Skill Course E-Learning Platform.
Microsoft Power BI

Duration:- 1 Month Feb to Mar 2025

From : - Udemy online E-Learning Platform.

Certification


Projects

Below are Some Data Analytics projects !

Mobile-sales-Dashboard

Analyzed Mobile Sales data using Excel and Power-Bi, visualizes mobile sales Data across cities, brands, payment methods, and time trends.

Ms. Dhoni ODI Proformance

Showcases MS Dhoni's cricket performance, highlighting his runs, strike rate, dismissals, achievements by year, ground, and opponent.

E-Commerce Sales Dashboard

presents Ecommerce sales insights, including profit, quantity, amount, customer and state-wise distribution, payment modes, and category performance.


Maven E-Commerce Market

This Power BI dashboard provides an overview of Maven Market's transactions, profit, returns, country-wise sales, product performance, and revenue trends.

Super Store Data analyze

sales performance insights, including regional and segment-wise sales, payment modes, sub-category sales, shipping methods, and year-over-year trends..

Ola Ride Booking Report Analyzed

In this power-Bi project analysing ride trends, booking statuses, payment methods, and customer behaviour for data-driven insights.


Analysis Zomato Sales Data

Create Dashboard for data analysis on Zomato sales using Python to improve the customer experience.

Credit Card Financial Dashboard

A Power BI dashboard providing insights into credit card spending patterns, revenue distribution, and customer segmentation.

Digital Music Store Data Analysis

Analyzed music store data using advanced SQL queires to identify gaps and increase the business growth.

Find More Other projects on Github

I love to solve business problems & uncover hidden data stories


GitHub

Contact Me

Below are the details to reach out to me !

Contact Number

+ 91 7296052960

Email Address

ojhamohit108@gmail.com

Download Resume

Download Cv



"I'm always looking to improve. For any suggestions, feedback or questions, kindly get in touch."