Hi, I'm Mohit Pammu, MBA

 

Welcome to my portfolio website. Here you can find my projects and learn more about my skills.

Profile Image

About Me

I'm a Data Analyst with 5+ years of experience applying analytics across healthcare, finance, and business operations. Skilled in SQL, Python, Power BI, and Excel, I specialize in transforming messy datasets into clear, actionable insights for decision-making and operational improvement.

My path into analytics is grounded in real-world execution — from supporting a $50M Medicaid billing project as a Business Analyst to launching a culinary business where I used data-driven forecasting to reduce waste by 20% and increase profit margins. This background helps me connect technical analysis with measurable business impact.

I'm experienced in:

  • Cleaning, transforming, and validating large datasets using SQL and Python
  • Building dashboards and KPI reports in Power BI
  • Performing trend, anomaly, and statistical analysis for stakeholders
  • Using AI tools to streamline analysis, accelerate exploration, and improve workflow efficiency

I recently completed MIT Professional Education – Applied Data Science and am building skills in predictive analytics and machine learning through hands-on projects including fraud detection pipelines and computer vision models. My code and project write-ups are fully documented for reproducibility and business interpretation.

If you're looking for an analyst who combines technical depth with business understanding — and is actively growing toward advanced analytics — let's connect.

Email: mopammu@gmail.com
Location: Laurel, MD
Availability: Available for hire
Download CV

Credentials

Professional qualifications that validate my expertise

MIT PE ADSP Certificate

Applied Data Science Program

Issued by MIT Professional Education

June 2025

Google Data Analytics Certificate

Google Data Analytics Professional Certificate

Issued by Coursera

September 2024

Power BI Certificate

Microsoft Certified: Power BI Data Analyst Associate Certificate

Issued by Microsost

April 2024

Edureka Power BI Certificate

Business Analyst using Power BI Certificate

Issued by Edureka

January 2024

Core Skills Network

My Projects

HR Data Analysis

HR Workforce Analytics

A Power BI workforce analytics dashboard (Edureka certification project) analyzing 546K+ HR records to uncover retention risk patterns. Built with advanced DAX measures, row-level security for 6 regional roles, interactive filtering, and demographic segmentation, revealing that 73% of new hires are under 30 yet this age group shows highest separation volumes—enabling targeted retention strategies.

Power BI Dashboard DAX Row-Level Security
Global Sales Performance

Global Sales Performance

Power BI sales analytics dashboard analyzing 51K+ transactions totaling $62.3M across global markets (Edureka certification project). Implemented row-level security for Africa and Europe regional roles and DAX profit calculations. Revealed 23.8% average annual growth (2012-2015) alongside critical profitability challenges: overall 2.4% profit ratio with Central Asia operating at -9.4% loss, while Technology category drives 38% of revenue.

Power BI DAX Row-Level Security Profit Analysis
Cyclistic Analysis

Cyclistic Bikeshare Analysis

Analyzed ride patterns of 4.3 million Cyclistic bike-share trips using R, tidyverse, and data visualization techniques to identify conversion opportunities for casual riders to annual memberships, delivering actionable marketing recommendations.

R tidyverse ggplot2 Statistical Analysis
FoodHub Analysis

FoodHub Order Analysis

Conducted comprehensive data analysis on FoodHub's order dataset using Python (pandas, matplotlib, seaborn), examining 1,898 orders to identify key trends in restaurant popularity, cuisine preferences, delivery times, and customer ratings, ultimately providing strategic recommendations to improve revenue and customer experience.

Python Pandas Matplotlib Seaborn EDA
Sales-Customer-Analytics

Sales & Customer Analytics

Power BI dashboard analyzing Northwind database (2,155 order details, 830 orders) with advanced time intelligence DAX measures (Edureka certification). Revealed 80% year-over-year sales growth alongside critical customer concentration risk: top 3 customers represent 25.6% of $1.35M revenue, with Horst Kloss alone driving 8.7%. Features cascading filters, drill-through pages, and Q&A natural language interface for ad-hoc analysis.

Power BI DAX Time Intelligence Customer Segmentation
Netflix Content Analysis

Netflix Content Analysis

Power BI dashboard analyzing 5,806 Netflix titles (Edureka certification project). Built using Power Query transformations and DAX measures to visualize content distribution, genre mix, and global availability. Shows platform is 65% movies vs. 35% TV shows, with shows averaging 13% higher IMDB ratings despite lower production volume.

Power BI Dashboard Power Query Data Visualization
Digit Recognition

SVHN Digit Recognition

Achieved ~90% accuracy with 38.6% parameter reduction in SVHN digit recognition through systematic CNN optimization, AutoML hyperparameter tuning, and production-ready architecture design using TensorFlow/Keras.

Deep Learning Computer Vision TensorFlow CNN Python
Facial Emotion Detection

Facial Emotion Detection

Built facial emotion detection CNN achieving ~82% accuracy on 4-class classification. Outperformed VGG16, ResNet101, and EfficientNetV2 transfer learning models through grayscale optimization and systematic architecture design for production deployment.

Deep Learning Computer Vision TensorFlow CNN Python

Contact Me

Email

mopammu@gmail.com

Location

Laurel, MD

LinkedIn

linkedin.com/in/mohitpammu

Data Science News

Stay updated with the latest developments in data science and machine learning.

Loading latest industry news...