Skip to content
View alokpalai's full-sized avatar
😋
Happyyy
😋
Happyyy

Block or report alokpalai

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

Alok

B.Tech Civil Engineering, Delhi Technological University | B.A. (Hons.) Psychology, IGNOU

Data analytics and data science portfolio, focused on statistical rigor and business-translatable insight.

Featured projects

Patient Journey Analytics & Treatment Persistence Prediction Predicting Type 2 Diabetes medication discontinuation using synthetic patient data. XGBoost with temporal validation (AUC 0.70, top-decile capture 68%), Kaplan-Meier and Cox proportional hazards survival analysis, SHAP explainability, and patient risk segmentation. Python PySpark SQL XGBoost SHAP Power BI

A/B Testing Analysis Designed and evaluated an A/B test on an Express Checkout feature across 20,000 users. Measured a 12.7% conversion lift at p = 0.0006, validated for sample-ratio mismatch and novelty effect before issuing a go/no-go recommendation. Python Statistics SQL

Product Funnel Analysis Mapped stage-wise conversion across 27,209 sessions, isolated the largest drop-off point, and sized the revenue opportunity from closing the gap. SQL Python Power BI

Skills

Machine Learning & Statistics: Logistic regression, random forest, XGBoost, clustering, survival analysis, hypothesis testing, A/B testing and experiment design, feature engineering, model evaluation, SHAP

NLP & Unstructured Data: Text preprocessing, TF-IDF, topic modeling, named entity recognition, transformer fine-tuning

Programming & Data: Python (pandas, NumPy, scikit-learn), SQL (MySQL, PostgreSQL), PySpark, Git

Business Analytics: Hypothesis-driven problem solving, market sizing, funnel analysis, RFM segmentation, cohort and retention analysis, KPI design

Visualisation & Reporting: Power BI, Tableau, Advanced Excel

Contact

alokpalai@gmail.com

Pinned Loading

  1. blinkit-sales-inventory-analytics blinkit-sales-inventory-analytics Public

    Sales and inventory analysis of a simulated quick-commerce network. 573K orders, 14 dark stores, 8 cities. SQL + Python + Power BI + Streamlit.

    Python

  2. portfolio-risk-analytics portfolio-risk-analytics Public

    Risk and performance analysis of a 10-holding, multi-asset portfolio vs the S&P 500 over 5 years of real Yahoo Finance data. SQL + Python + Power BI.

    Python

  3. zomato-product-analytics-dashboard zomato-product-analytics-dashboard Public

    End-to-end product analytics project on food-delivery order data — DAU/MAU, AOV, retention, RFM segmentation, and delivery KPIs, built with SQL, Python, Power BI & Excel.

    Python

  4. AB-testing-checkout-analysis AB-testing-checkout-analysis Public

    A/B test of an Express Checkout feature on 20,000 users — power analysis, SRM, novelty-effect testing, and annualised business impact in Python + SQL.

    Jupyter Notebook

  5. product-funnel-analysis product-funnel-analysis Public

    Stage-wise funnel analysis of 27,209 app sessions — isolated a 47% View Item → Add to Cart dropoff worth ₹3.5L/year. SQL · Python · Power BI

    Python

  6. customer-segmentation-rfm-analysis customer-segmentation-rfm-analysis Public

    Segments e-commerce customers using RFM (Recency, Frequency, Monetary) analysis in Python and SQL — identifies high-value and at-risk groups and recommends targeted retention campaigns.

    Python