MS Data Analytics | Webster University (Dec 2024) Piscataway, NJ | Open to Remote and Relocate across US | STEM OPT Active

I turn messy real-world data into decisions that save money, improve operations, and solve problems that matter.

7+ years across healthcare, recruitment, and business analytics — including managing data relationships with 30+ NHS hospitals in the UK. Now combining that domain expertise with Python, SQL, machine learning, and AI to build tools that actually get used.

Lean Six Sigma Black Belt. I don't just find problems in data. I frame them as business solutions.

Analytics Track: Data Analyst · Business Analyst · Healthcare Analyst · BI Analyst · SQL Analyst

Healthcare Recruitment Track: Account Manager · Client Success Manager · Workforce Analytics Manager · Healthcare Staffing Analyst

Available immediately. STEM OPT active. No sponsorship required for OPT period.

🎯 Currently focused on job applications. Actively interviewing — happy to walk through any project below in more depth.

Most analytics candidates have notebooks. I have live deployed tools anyone can use.

Most list SQL on their resume. I have 25 queries across two real datasets with a live SQL explorer anyone can run queries against right now.

Most have domain knowledge OR technical skills. I have 7 years of NHS hospital account management AND Python, SQL, ML, and SHAP explainability.

Most have a degree. I have a degree AND a Lean Six Sigma Black Belt — which appears as a requirement in most supply chain and operations analyst postings.

Analyzed 9.6M real US Medicare records to identify physician staffing gaps across all 50 states.

• Processed 1.1M unique providers across 104 medical specialties
• Built 5-tab Streamlit dashboard with US choropleth maps
• Applied Lean Six Sigma DMAIC framework to recruitment gap analysis
• Wyoming 97.7%, Vermont and Alaska identified as most critically underserved
• Full analysis on 9.6M records locally — dashboard shows 50k sample

Live: https://karan-healthcare-analytics.streamlit.app Stack: Python · Pandas · Plotly · Streamlit · CMS Medicare Data

25 advanced SQL queries across healthcare and supply chain real datasets.

• 6 basic, 9 intermediate, 9 advanced queries
• Window functions: RANK, DENSE_RANK, ROW_NUMBER, NTILE, LAG, LEAD, running totals, moving averages
• CTEs for ABC inventory classification and cross-domain state comparison
• Live SQL Explorer — write and run any SQL against real database in browser

Live: https://karan-sql-analytics.streamlit.app Stack: SQL · SQLite · Python · Plotly · Streamlit

End-to-end ML pipeline predicting 30-day hospital readmission risk.

• 101,745 real patient records from 130 US hospitals
• 4 models trained and compared — XGBoost won with ROC-AUC 0.598
• SMOTE to handle 11.2% class imbalance
• SHAP explainability — shows clinicians exactly why a patient is flagged
• Live risk predictor with gauge chart and clinical recommendations

Live: https://karan-healthcare-ml.streamlit.app Stack: Python · XGBoost · SHAP · SMOTE · Streamlit

180,519 real orders analyzed — 57% delivered late across 23 global regions.

• 42.7% on-time delivery rate — Central Africa worst at 60.7%
• 15 SQL queries covering late rates, revenue, customer segments
• ABC inventory segmentation — Class A drives 80% of revenue
• Full DMAIC Six Sigma structured analysis

Live: https://karan-supply-chain.streamlit.app Stack: Python · SQL · SQLite · Plotly · Streamlit · DMAIC

Same 180k order dataset rebuilt in Power BI to demonstrate Microsoft-stack proficiency alongside the Python/SQL version. Stack: Power BI · DAX

15,000+ employee records. 90% prediction accuracy for turnover. Repo · R · Logistic Regression · Decision Trees

$3M cost reduction through optimized loan default prediction. Repo · R · Logistic Regression

600 customer profiles segmented for AXANTEUS market research agency. Repo · R · K-Means · Random Forest

Languages:     Python · R · SQL (GROUP BY through window functions and CTEs)
Visualization: Plotly · Streamlit · Power BI · Tableau · Seaborn
ML:            Scikit-learn · XGBoost · SHAP · Random Forest · Logistic Regression
               Decision Trees · Clustering · Time Series · Predictive Modeling
Imbalance:     SMOTE (imbalanced-learn)
Database:      SQL · SQLite · PostgreSQL · MySQL · DAX · Excel Advanced
AI/LLM:        LangChain · OpenAI API · Hugging Face · ChromaDB RAG (exploratory)
Process:       Lean Six Sigma Black Belt · DMAIC · SIPOC · RCA · FMEA
Domain:        Healthcare · Supply Chain · HR Analytics · Finance · Recruitment

• Google Data Analytics Certificate — in progress
• Udemy courses — sharpening SQL, Power BI, and analytics skills while job searching

• Lean Six Sigma Black Belt — Benchmark Six Sigma (2021)
• Lean Six Sigma Green Belt — Benchmark Six Sigma (2021)
• MS Data Analytics — Webster University (Dec 2024), GPA 3.31
• Microsoft PL-300 Power BI — Microsoft Learn (in progress)

Senior Accounts Manager — ID Medical LLP (Healthcare Staffing, UK) 30+ NHS hospital accounts · Forecasting accuracy +25% · 15% YoY revenue growth · Excel analytics and data-driven client reporting

Senior Recruitment Consultant — QX KPO Services 453 shifts booked in one month · £25,000 revenue · Shift analytics and rota forecasting · Led 4-member team

International Peer Mentor and Writing Coach — Webster University CRLA Level 2 Certified · Student outcomes +94%

krntrivedi@gmail.com · LinkedIn · Healthcare Dashboard · Supply Chain Dashboard · ML Pipeline · SQL Analytics · GitHub

4 projects live, 1 wrapping up. Currently focused on job applications — reach out anytime.

Human-Capital-Analysis — Public Predicting employee turnover using Logistic Regression, Decision Tree, k-NN & SVM on 14,999 employees. Decision Tree achieved 97% accuracy & 0.97 AUC. Built in R. Dataset: 10 attributes. R

Bank-Loan-Decision-Making-Analysis — Public Predicting home improvement loan defaults using Logistic Regression & Decision Tree in R. 77.47% accuracy, 80.65% sensitivity, $1.165M cost reduction. Dataset: 5,960 applicants | 13 variables. R

Consumer-Segmentation-Analysis — Public Consumer segmentation & brand loyalty prediction for 600 profiles using K-Means clustering, Logistic Regression & Random Forest. Built for AXANTEUS market research agency. Built in R. R

Karant15 — Public

Healthcare-Workforce-Analytics — Public Analyzing 9.6M US Medicare records to identify physician staffing gaps and recruitment priorities across 50 states

Supply-Chain-Analytics — Public Analyzed 180,519 supply chain orders to identify delivery failures and inventory gaps using Lean Six Sigma DMAIC framework