Skip to content
View Malay19's full-sized avatar
🎯
Focusing
🎯
Focusing

Block or report Malay19

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

Malay Patel

Operations Strategy & Business Intelligence Analyst Intern @ IMMEC · MS Business Analytics & AI, University of Maryland

I build the layer between messy operational data and the decision someone actually has to make — pipelines, forecasts, optimization models, and dashboards that get used after the presentation ends.

I like building systems that make numbers behave.

Featured work

Prince George's Coffee Site Selection — Site-selection screen over all 214 census tracts in Prince George's County, MD. Integrated Census ACS, LEHD workplace, and scraped business and review data into a common tract grain, then scored survivors in an interactive Tableau model with adjustable weights. Python pandas Tableau Census & LEHD APIs sentiment analysis

Yelp Review Usefulness Prediction — Stacked ensemble over 1.58M labeled reviews predicting review usefulness under a hard business constraint: false positives at or below 10%. Reached 0.9081 AUC, recovering 69.1% of useful reviews at a 9.70% false-positive rate. Fourth place in a class-wide competition. XGBoost LightGBM scikit-learn TF-IDF VADER

Uber Dynamic Pricing Decoded — Four linked Tableau dashboards explaining fare structure, surge mechanics, and geographic demand across 99,899 trips. Built with parameter-driven scenario filters so stakeholders run their own comparisons. Live on Tableau Public. Tableau geospatial scenario modeling

Monte Carlo Marketing Budget Allocation — Simulated 58 feasible splits of a $100K monthly budget across three channels under uncertain conversion rates, click costs, and order values — ranking on probability of profit, not just expected value. Excel @RISK Monte Carlo

Multi-Stage Supply Chain Optimization — Three-stage pipeline chaining store pricing, warehouse allocation, and vehicle routing under real capacity and feasibility constraints. $58K+ simulated daily profit. AMPL Gurobi optimization

TransitPulse KPI Analytics — Relational model across 9+ core tables joining ridership, reliability, and safety data, with SQL views computing YoY change and crime-per-million-riders to surface multi-factor hotspot stations. SQL relational modeling KPI design

Experience

IMMEC — Operations Strategy & Business Intelligence Analyst Intern Business intelligence, process improvement, and AI automation for operational workflows.

Roche — Healthcare Analytics Intern Replaced a manual weekly reporting cycle with SQL and Python pipelines spanning Athena, Excel, and SQL sources. Built the reporting structures behind recurring forecasting KPIs for Ocrevus and Hemlibra.

HorizonCore — Data Analyst Intern Built demand forecasting models and the dashboards on top of them, used by managers to shift budget toward higher-performing channels and to tighten inventory planning.

Tools

Python SQL Tableau Power BI Excel pandas NumPy scikit-learn XGBoost LightGBM Gurobi AMPL AWS Jupyter Git

Outside the code

Executive VP of Operations, Smith Masters Student Association · Graduate Course Assistant, Government by Algorithm (AI & Public Policy)

Contact

LinkedIn · malayajay.patel@gmail.com

Pinned Loading

  1. Multi-Stage-Supply-Chain-Optimization Multi-Stage-Supply-Chain-Optimization Public

    End-to-end pricing, warehouse allocation, and vehicle routing optimization using AMPL and Gurobi to maximize profit under operational constraints.

    Jupyter Notebook

  2. TransitPulse-WMATA-KPI-Analytics TransitPulse-WMATA-KPI-Analytics Public

    SQL-based public transit analytics system integrating ridership, incidents, and crime data into a star-schema for KPI monitoring.

    TSQL

  3. FAANG-ROE-Business-Model-Analysis FAANG-ROE-Business-Model-Analysis Public

    Regression-based financial analysis using DuPont decomposition to evaluate profitability drivers across FAANG firms (2015–2024).

    R

  4. Smart-Lender-Applicant-Credibility-Prediction-For-Loan-Approval Smart-Lender-Applicant-Credibility-Prediction-For-Loan-Approval Public

    A machine learning-based system to assess loan applicants' credibility using models like Decision Trees, Random Forest, KNN, and XGBoost. The best-performing model is integrated into a Flask-based …

    Jupyter Notebook

  5. SympAI-Intelligent-Symptom-Analysis-for-Communicable-Diseases SympAI-Intelligent-Symptom-Analysis-for-Communicable-Diseases Public

    Developed an AI-driven system for early detection of communicable diseases using symptoms, combining deep learning models (BiLSTM, Transformer) with explainable AI (SHAP, LIME), deployed via Stream…

    Python

  6. Business-Analytics_case-study Business-Analytics_case-study Public

    Indian IT services giant seeks rapid margin growth (11% vs 26% industry avg) through strategic acquisitions of niche tech startups. This case study explores their challenges and proposes an M&A-dri…