From Bootcamp to MIS Analyst
Pawan transformed his career trajectory in just 6 months. By mastering data analysis, business intelligence, and MIS reporting, he secured a 5.0 LPA package and a pivotal role at upGrad — a global leader in online education.
Pawan Mehra
MIS Analyst
5.0 LPA
Salary Package
45
Days to Hire
upGrad
EdTech Leader
Top 5%
Cohort Ranking
The Pivot
Before the Program
- Basic understanding of Excel and spreadsheets.
- Struggled with SQL queries and Python logic.
- Imposter syndrome during technical interviews.
- No portfolio of MIS reporting projects.
After the Program
- Mastery in Power BI, SQL, and Python Pandas.
- Confident in data modeling, dashboarding, and business reporting.
- Aced technical rounds with multiple offers.
- Built an enterprise-grade sales and marketing dashboard.
The Learning Journey Timeline
Phase 1: The Foundation
Mastering Excel, core SQL, and fundamental statistics. Building a strong base for MIS reporting and business intelligence.
Phase 2: The Application Phase
Diving into Power BI, Python Pandas, and ETL processes. Developing comprehensive dashboards with real-world complexities.
Phase 3: The Placement Prep
Intensive mock interviews, data story-telling whiteboarding, and resume optimization. Refining the personal narrative for analyst roles.
Core Tech Stack Mastered
Capstone Project Mastery
EdTech Revenue & Engagement MIS Dashboard
POWER BIAn end-to-end MIS dashboard tracking student enrollments, revenue, and marketing ROI across multiple regions for a leading EdTech platform.
Handling large, disparate datasets from multiple databases and Excel sheets with poor data quality.
Implemented Star Schema data modeling, optimized SQL queries, and used Python Pandas for ETL. Achieved a 40% faster decision-making cycle for the management team.
Performance Scorecard
Overcoming Challenges
Transitioning to data modeling and handling large datasets was initially a significant hurdle. Pawan spent over 40 additional hours in peer-programming sessions to master SQL joins and Python Pandas. Balancing full-time study with part-time work required immense time-management discipline, teaching him prioritization skills that proved invaluable during his technical interviews.
Interview Preparation Intensive
Mock Interviews
Completed 15+ rigorous technical mocks with industry experts, refining approach to SQL queries and data storytelling.
Resume Workshops
Iterated on portfolio presentation to highlight impact-driven metrics and dashboard design decisions.
Soft Skills Training
Mastered the STAR method for behavioral rounds, ensuring clear, confident communication of past experiences.
Interview & Placement Process
Online Assessment
Aced a 90-minute SQL and Excel challenge focusing on data extraction, joins, and statistical logic.
Technical Round
Live coding interview tackling Python Pandas transformations and DAX calculations.
System Design
Whiteboarding a scalable data pipeline for an e-learning platform with 1M+ users.
Managerial
Final discussion focusing on business acumen, culture fit, and career aspirations.
The Offer
upGrad
MIS Analyst
Joining the core analytics team responsible for driving data-informed decisions to enhance learning outcomes and business growth.
Trajectory: The Ascent
Pawan's compensation growth mapping from his entry-level role to his current MIS Analyst position, highlighting the 5.0 LPA leap post-graduation.
From Internship to MIS Analyst
- 1.0 LPA — Entry-Level Internship
- 1.5 LPA — Junior Analyst
- 3.0 LPA — Post-Graduation
- 4.0 LPA — Data Analyst
- 5.0 LPA — MIS Analyst
MIS & Data Analyst Trainers & Mentors
Mr. Syed Najeeb
Ex-Employee: Air India | ISAP India | Ramtech Software Solutions
Connect on LinkedIn
Mr. Irshad Khan
Ex-Employee: KPMG | Global logic | Ministry of health and welfare
Connect on LinkedIn
"Pawan's dedication to mastering the fundamentals of data analysis before jumping into complex visualization tools is what set him apart. During our 1:1 sessions, he consistently asked probing questions about data integrity and business impact. He didn't just want to make charts; he wanted to understand the story behind the data. That curiosity is the true hallmark of a skilled analyst, and it's exactly why he excelled in his interviews."
- Mr. Syed Najeeb
"Think IT Job. Think Uncodemy. Consistency was my secret weapon. The curriculum was tough, but showing up every single day and trusting the process changed my life. 'We rise by lifting others.'"
- Pawan Mehra
Ready to Write Your Own Success Story?
Join our intensive program and take the first step towards your career transformation.