Skip to content
View Pranav-MSK's full-sized avatar
🎯
Focusing
🎯
Focusing
6 followers · 8 following

Achievements

Achievement: Pull Sharkx2Achievement: Pair ExtraordinaireAchievement: Quickdraw

Achievements

Achievement: Pull Sharkx2Achievement: Pair ExtraordinaireAchievement: Quickdraw

Highlights

Block or report Pranav-MSK

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.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

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

Report abuse
Pranav-MSK/README.md

 

Typing SVG

profile views   LinkedIn   Email

🙋 About Me

  • 📊 Data & Cloud Specialist building end-to-end ETL pipelines, analytics dashboards, and cloud automation workflows.
  • 🛠️ Technical proficiency spanning Python (Pandas, NumPy), SQL (MySQL, PostgreSQL), R, Power BI, and Tableau.
  • ☁️ Developing cloud infrastructure workflows using Google Cloud Platform, Firebase, and GitHub Actions CI/CD.
  • 🎯 Focused on scalable database architecture, query optimization, and real-time data ingestion platforms.

🛠️ Tech Stack

Languages & Core
Python SQL R JavaScript HTML5 CSS3

Data Engineering & Analytics
Pandas NumPy Power BI Tableau Streamlit

Databases, Cloud & Automation
MySQL PostgreSQL MongoDB Google Cloud GitHub Actions

🚀 Featured Projects

💼 Job Intelligence Dashboard

Automated ETL pipeline and analytics dashboard for tech market intelligence.

  • Designed REST API extraction pipelines using Python & MySQL to ingest software role postings.
  • Built an interactive Streamlit reporting dashboard analyzing regional salary benchmarks and skill demand trends.

📈 Superstore Profit Optimization

Executive data analytics case study isolating retail profit leakage.

  • Processed complex transaction-level records via Python (Pandas) to isolate margin erosion triggers.
  • Designed a diagnostic Tableau dashboard uncovering a high-leverage $65K promotional value drain.

🩺 Healthcare Data Analysis

SQL and Power BI workflow mapping clinical utilization and financial metrics.

  • Executed complex aggregate queries in SQL to evaluate patient billing distributions and length-of-stay parameters.
  • Modeled interactive Power BI dashboards detailing departmental profitability and patient demographics.

📁 More Projects

  • 🚲 Cyclistic Bike Share Analysis: R & Tableau case study evaluating rider usage patterns to drive membership conversions.
  • 🌍 India AQI Dashboard: Time-series analysis of 5 years of air quality metrics across major Indian metropolitan areas.
  • 📊 Exam Period Habit Analysis: Exploratory data analysis assessing academic stress impact on sleep and productivity trends.
  • 📁 LabSync: Vercel-powered file uploader for secure, passcode-protected uploads to a private GitHub repository from shared computers. (Private)
  • 🎓 CGPA Calculator: Responsive dashboard application built with Vue.js and Vite for dynamic semester metric tracking.
  • 🎨 Issue Ink: Interactive pixel-art grid canvas driven by GitHub Issues and GitHub Actions workflow automation.
  • 📝 Text Summarizer: Python NLP utility for automated key text extraction and summary generation.

📊 GitHub Stats

GitHub Stats   Top Languages

GitHub Streak

Pinned Loading

  1. job-market-intelligence job-market-intelligence Public

    End-to-end ETL pipeline and analytics dashboard for software engineering job market intelligence using Python, MySQL, Streamlit, and the Adzuna API.

    Python

  2. superstore-profit-optimization superstore-profit-optimization Public

    End-to-end data analytics case study isolating corporate profit leakage using Python (Pandas) and an interactive Tableau dashboard. Moves past surface-level aggregate margins to target a high-lever…

    Python

  3. india-aqi-dashboard india-aqi-dashboard Public

    Visualizing 5 years of air pollution data across India's major cities, uncovering seasonal patterns, COVID-19 lockdown effects, and city-wise pollutant breakdowns using Python and Tableau.

    Python

  4. Healthcare-Data-Analysis Healthcare-Data-Analysis Public

    An end-to-end Data Analytics workflow using SQL and Power BI that analyzes a synthetic healthcare dataset to explore patient demographics, medical conditions, hospital admissions, insurance coverag…

    Jupyter Notebook

  5. Pranav-MSK Pranav-MSK Public

    Hi 👋 Welcome to my GitHub profile!

    1

  6. Issue-Ink Issue-Ink Public

    A collaborative pixel canvas powered entirely by GitHub Issues and Actions. Paint one pixel at a time.

    1