Hi, I'm Mohit Pammu, MBA

 

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

Mohit Pammu Profile

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

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
SVHN 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...