Skip to content
View MohitPammu's full-sized avatar

Block or report MohitPammu

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don't include any personal information such as legal names or email addresses. Markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
MohitPammu/README.md

Mohit Pammu, MBA

Data Analyst | SQL, Python, Power BI

Turning complex data into clear business insights across healthcare, finance, and operations

What I Do

Data analyst with 5+ years of experience transforming messy data into actionable business intelligence. I work end-to-end across the analytics workflow: SQL for data extraction and transformation, Python for statistical analysis and automation, and Power BI for interactive dashboards that help stakeholders make informed decisions.


Technical Stack

Data Analysis & BI
SQL Python Power BI R Excel

Python Libraries
Pandas NumPy Matplotlib Seaborn

Development & Tools
Git GitHub Jupyter VS Code

Expanding Into
TensorFlow Scikit-learn Docker


Featured Projects

HR Workforce Analytics Dashboard
Power BI | DAX | Row-Level Security
Analyzed 546K+ employee records with advanced DAX measures and row-level security for 6 regional roles. Revealed that 73% of new hires are under 30 yet this age group drives highest separations—identifying critical retention gaps requiring targeted interventions across regions.

Global Sales Performance Dashboard
Power BI | Multi-Market Analysis | Profit Optimization
Built sales analytics dashboard analyzing $62.3M across global markets with row-level security implementation. Uncovered 23.8% average annual growth alongside critical profitability challenge: 2.4% profit ratio with Central Asia operating at -9.4% loss.

Cyclistic Bikeshare Analysis
R | tidyverse | Statistical Analysis
Analyzed 4.3M+ ride-sharing records using R to identify usage patterns between casual riders and annual members. Delivered marketing strategy with 5 actionable recommendations for membership conversion and customer retention.

FoodHub Order Analytics
Python | Pandas | Data Visualization
Conducted comprehensive analysis of 1,898 orders using Python (pandas, matplotlib, seaborn) to identify trends in restaurant popularity, cuisine preferences, delivery times, and customer ratings—providing strategic recommendations to improve revenue and customer experience.


Education & Certifications

  • Google Data Analytics Professional Certificate (2024)
  • Edureka Business Analyst using Power BI (2024)
  • MIT Professional Education - Applied Data Science Program (2025)
  • MBA, Finance Concentration - La Sierra University
  • Currently Pursuing: SQL Fundamentals, Advanced Python for Data Analysis

Professional Background

Business Analyst → DC consulting, supporting $50M+ healthcare projects
Operations Manager → Restaurant industry, process optimization
Data Analyst → Cross-functional analytics across healthcare, finance, and operations

I leverage business operations experience and stakeholder management skills to translate technical analyses into actionable business recommendations. I focus on asking the right questions before writing the first query.


Current Focus

📚 Learning: Advanced SQL (window functions, CTEs, query optimization)
🔨 Building: End-to-end analytics projects demonstrating ETL → analysis → visualization workflow
🎯 Goal: Transition into predictive analytics and machine learning applications
💼 Open to: Data Analyst, BI Analyst, and Analytics Engineer roles


Connect

Portfolio LinkedIn Email


Profile views

Pinned Loading

  1. SVHN-Digit-Recognition SVHN-Digit-Recognition Public

    Optimized CNN achieving ~90% accuracy with 38.6% parameter reduction for production-ready digit recognition

    HTML 1

  2. Facial-Emotion-Detection Facial-Emotion-Detection Public

    Real-time facial emotion detection using optimized CNN architecture achieving ~82% accuracy. Built with TensorFlow/Keras for production deployment with grayscale optimization and data augmentation …

    HTML 2