Skip to content
View smohan-21's full-sized avatar

Block or report smohan-21

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 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
smohan-21/README.md

Typing SVG


πŸ‘¨β€πŸ’» About Me

🎯 Aspiring Data Analyst focused on Financial & Business Data Analytics

  • πŸ” Passionate about uncovering patterns in complex datasets
  • πŸ€– Building ML-powered systems with Explainable AI
  • πŸ“Š Love creating dashboards that tell compelling data stories
  • 🧠 Skilled in SQL, Python, Machine Learning, and Tableau
  • 🌱 Currently sharpening skills in Advanced ML and BI Tools
  • πŸ“ Based in India

πŸš€ Featured Projects

End-to-end real-time fraud detection pipeline with SHAP explainability & live Streamlit dashboard

  • πŸ”§ Tech: Python, LightGBM, XGBoost, SHAP, SMOTE, Streamlit, Plotly, Optuna
  • πŸ’‘ Handles severe class imbalance using SMOTE; explains every prediction in plain English via SHAP
  • πŸ“Š Multi-page live dashboard deployed on Streamlit Cloud
  • 🎯 Models compared: LightGBM vs XGBoost vs Isolation Forest with threshold optimization
  • πŸ”— Live Dashboard: Click Here

ML pipeline to predict customer churn and segment by risk tier

  • πŸ”§ Tech: Python, Jupyter Notebook, Scikit-learn, Pandas, Matplotlib, Seaborn
  • πŸ’‘ Segments customers into Critical Risk, Suspicious, and Clear tiers
  • πŸ“Š Comprehensive model comparison with ROC-AUC and PR-AUC metrics
  • 🎯 Feature engineering + business recommendations for retention strategy

NLP-powered sentiment classification of e-commerce product reviews

  • πŸ”§ Tech: Python, Jupyter Notebook, NLP, Pandas, Matplotlib
  • πŸ’‘ Classifies customer reviews into Positive, Negative, and Neutral sentiments
  • πŸ“Š Visual insights into customer opinion trends across product categories
  • 🎯 Business-ready insights for product improvement decisions

End-to-end bank customer churn analysis using SQL + Python + Looker Studio

  • πŸ”§ Tech: SQL (MySQL), Python, Google Colab, Google Looker Studio
  • πŸ’‘ Identifies churn drivers by geography, gender, age, tenure, balance, and product usage
  • πŸ“Š Interactive dashboard with KPI scorecards on Looker Studio
  • πŸ”— Live Dashboard: Click Here

Complete end-to-end HR attrition analysis using MySQL

  • πŸ”§ Tech: MySQL, MySQL Workbench, GitHub
  • πŸ’‘ Full pipeline: schema design β†’ data loading β†’ cleaning β†’ basic/intermediate/advanced analysis
  • πŸ“Š Advanced SQL: window functions, aggregates, conditional logic, high-risk segment identification
  • 🎯 Identifies attrition patterns by department, job role, overtime, income, and tenure

Clinical heart disease data analysis with Tableau dashboards integrated into a Flask web app

  • πŸ”§ Tech: MySQL, Tableau, Flask, Python, HTML, CSS
  • πŸ’‘ Transforms raw clinical data into interactive visual insights
  • πŸ“Š Full-stack integration of analytics into a web application
  • πŸ”— Live Tableau Dashboard: Click Here
  • πŸ”— Live Story: Click Here

πŸ› οΈ Tech Stack

Python SQL Jupyter Pandas NumPy Scikit-learn Tableau Streamlit Plotly Flask Google Colab GitHub


πŸ“Š GitHub Stats

Β 



GitHub Streak


πŸ“¬ Connect With Me

GitHub


Pinned Loading

  1. fraud-detection-system-with-explainable-ai fraud-detection-system-with-explainable-ai Public

    "Real-time fraud detection with LightGBM, SHAP explainability & Streamlit dashboard"

    Jupyter Notebook

  2. customer-churn-prediction-and-risk-segmentation customer-churn-prediction-and-risk-segmentation Public

    "ML pipeline for customer churn prediction and risk segmentation using Python"

    Jupyter Notebook

  3. sentiment-analysis-on-product-reviews sentiment-analysis-on-product-reviews Public

    "NLP sentiment analysis on e-commerce product reviews using Python"

    Jupyter Notebook

  4. AI-Bank-Churn-Analytics AI-Bank-Churn-Analytics Public

    "Bank churn analytics using SQL, Python and Google Looker Studio dashboard"

    Jupyter Notebook

  5. HR-Employee-Attrition-SQL HR-Employee-Attrition-SQL Public

    "End-to-end HR employee attrition analysis using MySQL with advanced SQL queries"

  6. Heart-Disease-Analysis Heart-Disease-Analysis Public

    "Heart disease clinical data analysis with Tableau dashboards and Flask web app"

    CSS