Projects

Dashboards, Python analysis, machine learning, and data systems. Each card gives the problem, approach, and result; open “More detail” for the full story. Full code for nine of these projects is on GitHub.

Showing all projects.

Showing all projects.

All projects

Machine LearningRisk Analytics

Credit Risk Scorecard: Development, Monitoring, and Stress Testing

Predict which credit card customers will default next month, grade the portfolio, and estimate losses under a downturn.

Approach
Validated 30,000 credit card accounts (UCI), built behavioral features while excluding sex, marital status, and age, selected features by weight of evidence and information value, and scaled a logistic-regression scorecard to points. Added risk grades, a cutoff strategy, expected loss, PSI monitoring, and stress scenarios.
Result
Hold-out Gini 0.49 and KS 0.40. Grade E defaults at 53.7% vs about 10% for grades A and B; a 520 cutoff approves 71.8% of accounts and cuts their default rate from 22.1% to 12.6%. Expected loss came within about 5% of realized loss, and a severe stress scenario raised it by 50%.

Tools: Python · pandas · scikit-learn · Logistic regression · Gradient boosting · Tableau · Power BI · DAX

More detail

Business impact

Shows how a lender can turn account behavior into an explainable score, set approval cutoffs, size expected losses, and see how those losses grow in a downturn.

Technical challenges

Two utilization and payment features flipped to the wrong direction alongside the delinquency features, so they were dropped to keep the scorecard explainable. A gradient-boosting challenger scored higher (Gini 0.55) but gives no points-based reasons, so it serves as a benchmark.

Lessons learned

Explainability, stability monitoring, and fair-lending checks matter as much as raw accuracy in a credit model.

Business IntelligenceHealthcare AnalyticsTableau

Lead Intelligence and Scoring Dashboard

The organization needed a clearer way to identify high-priority healthcare leads, monitor engagement, and support outreach decisions.

Approach
Cleaned and standardized lead records; created KPI scorecards; analyzed lead source, owner, engagement, contact completeness, and readiness; built a Top-50 prioritization queue with filters and drill-downs.
Result
Improved visibility into lead quality and supported faster outreach prioritization.

Tools: Tableau · Excel · Google Sheets · SQL · Python · Pandas

More detail

Business impact

Improved visibility into lead quality and gave stakeholders a clearer way to prioritize outreach, monitor readiness, and discuss pipeline quality.

Technical challenges

Required standardizing fragmented lead fields, defining transparent scoring logic, and presenting contact readiness without exposing confidential records.

Lessons learned

This project strengthened my ability to transform fragmented healthcare lead data into an executive-ready prioritization dashboard while balancing technical accuracy with business usability.

Business IntelligenceTableau

Competitor Pricing and Market Intelligence

Medicidiom needed a structured view of competitor pricing, product features, market positioning, and potential strategic gaps.

Approach
Benchmarked 14 medical-language and healthcare-related competitors across pricing models, AI capability, delivery models, geographic focus, certification, and B2B positioning.
Result
Identified priority threats and market gaps and produced an internal decision-support resource.

Tools: Excel · Google Sheets · Tableau · Competitive analysis · Market intelligence

More detail

Business impact

Turned scattered competitor information into a structured view of pricing, feature positioning, and market gaps for strategy conversations.

Technical challenges

Required normalizing inconsistent public competitor details and separating evidence-backed insights from assumptions.

Lessons learned

This project reinforced the value of turning scattered market signals into a structured recommendation framework that leaders can use without needing to inspect every raw data point.

Business IntelligenceTableau

LinkedIn Performance Analytics Dashboard

The team needed visibility into social performance, audience composition, and content engagement.

Approach
Analyzed impressions, reactions, engagement patterns, geography, job functions, seniority, industries, and post performance.
Result
Created an interactive reporting view for content and audience analysis.

Tools: Tableau · Excel / Google Sheets · KPI development · Data visualization

More detail

Business impact

Connected content performance with audience composition so stakeholders could understand reach, engagement, and growth opportunities.

Technical challenges

Required balancing time-series trends, audience segmentation, and dashboard density without overloading non-technical users.

Lessons learned

This project sharpened my ability to connect content metrics, audience segments, and growth decisions in a way that supports clearer communication strategy.

Healthcare AnalyticsMachine LearningSQL / Data Engineering

Medical Appointment No-Show Analysis

Identify patterns associated with missed healthcare appointments and possible opportunities for outreach improvement.

Approach
Cleaned 110,527 appointment records, engineered booking lead time, ran chi-square significance tests, checked the SMS-reminder pattern for confounding, and built a gradient-boosting risk model.
Result
Lead time was the strongest driver (4.6% no-show same day vs 33% for 30+ days ahead). The risk model (ROC-AUC 0.73) flags 83% of missed appointments; the riskiest 20% of bookings had nearly twice the average no-show rate.

Tools: Python · Pandas · SciPy · scikit-learn · Matplotlib

More detail

Business impact

Translated appointment data into outreach and scheduling insights that could inform reminder strategy, patient communication, and operational planning.

Technical challenges

Required careful cleaning, feature interpretation, and clear separation between correlation, prediction, and clinical claims.

Lessons learned

This project strengthened my ability to move from exploratory healthcare data analysis to practical outreach recommendations while clearly communicating limitations.

Machine LearningGraduate Coursework

Used-Car Price Prediction

Predicted fair selling prices for 15,232 used-car listings from age, mileage, engine, power, brand, and fuel type.

Approach
Cleaned duplicates and impossible values, built leak-free scikit-learn pipelines, and compared linear, log-price, Ridge, Lasso, and tree models with 5-fold cross-validation.
Result
Tuned log-price Ridge model reached R² 0.857 on the test set (typical error $1,740); a premium-car classifier reached a cross-validated F1 of 0.89.

Tools: Python · Pandas · scikit-learn · Jupyter · GridSearchCV

More detail

Technical challenges

Skewed prices made a straight-line model predict 591 negative prices; modeling log price fixed this and cut RMSE from $6,255 to $4,214.

Lessons learned

Residual plots and a held-out test set reveal problems a single accuracy number hides.

Machine LearningGraduate Coursework

Titanic Survival: End-to-End Data Mining

Explored which passenger traits are linked to survival and built models to predict it, from data quality checks through tuned models.

Approach
Wrote a data quality report, engineered Title and FamilySize features, mined association rules, and compared five classifiers before tuning a random forest.
Result
83.9% test accuracy (F1 0.77); showed that the Cherbourg survival gap is mostly explained by passenger class, not port.

Tools: Python · Pandas · scikit-learn · mlxtend · Seaborn

More detail

Technical challenges

Choosing a decision threshold to fit the goal: a 0.3 threshold raised recall to 0.83 for a rescue scenario at the cost of precision.

Lessons learned

Check for confounding before reading a pattern as cause, and pick metrics that match the decision being made.

Healthcare AnalyticsSQL / Data EngineeringTableau

Healthcare Data Pipeline and KPI Reporting

Fragmented CSV and claims-style datasets made consistent reporting difficult.

Approach
Combined multiple files and reporting inputs; used SQL and Python for cleaning, transformation, and validation; built weekly KPI scorecards and prepared data for Tableau reporting.
Result
Improved repeatability and consistency of reporting while reducing manual preparation.

Tools: SQL · Python · Pandas · Excel · Tableau

More detail

Business impact

Improved repeatability of KPI reporting by showing how raw healthcare files can be cleaned, validated, and prepared for dashboard use.

Technical challenges

Required designing transformations that are transparent, reproducible, and easy to validate before visualization.

Lessons learned

This project reinforced the importance of repeatable data preparation, validation, and documentation before any dashboard or KPI report can be trusted.

Healthcare AnalyticsMachine LearningResearch Prototype

Federated Learning for Multi-Hospital Clinical Prediction

Train predictive models across institutions without centralizing sensitive patient data.

Approach
Split a public breast-cancer dataset across four simulated hospitals of different size and case mix, implemented federated averaging and differential privacy (clipping plus Gaussian noise) from scratch, and measured the privacy-utility trade-off.
Result
The federated model matched pooled-data accuracy (97.2%) without sharing records and beat hospitals training alone (95.5% average); adding privacy noise lowered accuracy step by step. Research prototype only.

Tools: Python · NumPy · scikit-learn · Federated learning · Differential privacy · pytest

More detail

Business impact

Demonstrated how institutions could collaborate on predictive modeling while reducing the need to centralize sensitive clinical records.

Technical challenges

Required simulating distributed nodes, reasoning about privacy-utility tradeoffs, and clearly labeling the work as a research prototype.

Lessons learned

This project deepened my understanding of privacy-preserving model development and the trade-offs between collaboration, utility, and data protection.

Healthcare AnalyticsMachine LearningResearch Prototype

LLM Agent for Clinical Documentation Support

Explore whether a retrieval-augmented AI assistant can support clinical-documentation workflows while reducing hallucination risk.

Approach
Built a retrieval-augmented, tool-using LLM workflow, connected structured lookup tools, generated clinical-note summaries, and evaluated outputs against reference material.
Result
Demonstrated a prototype workflow for grounded documentation support. Prototype only; not a clinically validated system.

Tools: LangChain · OpenAI API · RAG · Python · Tool-using agents

More detail

Business impact

Showed how grounded AI assistance could support documentation workflows while keeping risk controls and human review central to the design.

Technical challenges

Required retrieval grounding, tool-use design, and evaluation thinking to reduce hallucination risk and communicate workflow limitations.

Lessons learned

This project taught me to design AI prototypes around grounding, evaluation, and risk controls rather than treating generative output as automatically reliable.

Machine Learning

Student Admission Prediction

How do GRE, GPA, and institution rank relate to graduate admission, and how well can it be predicted?

Approach
Fit an interpretable logistic regression on 400 applicants, translated coefficients into odds ratios, compared against a baseline with cross-validation, and chose a decision threshold for a shortlisting use case.
Result
Institution rank had a large effect (rank-4 applicants had about one-third the odds of rank-1). Predictive power was modest (test ROC-AUC 0.67), reported honestly with fairness limits.

Tools: Python · scikit-learn · Logistic regression · Odds ratios · Model evaluation

More detail

Business impact

Provided an educational example of transparent predictive modeling and evaluation for admissions-style decision support.

Technical challenges

Required checking modeling assumptions, evaluation metrics, potential data leakage, and fairness limitations.

Lessons learned

This project reinforced the need for transparent evaluation, leakage checks, and careful interpretation when building predictive models for education use cases.

Machine LearningHealthcare Analytics

Heart Disease Prediction

Classify heart disease from 13 routine clinical measurements (UCI Cleveland, 303 patients).

Approach
Built leak-free pipelines, compared k-NN with logistic regression and random forest using cross-validation, tuned k, and evaluated once on a held-out test set.
Result
Tuned k-NN reached 86.8% test accuracy, 0.86 recall, and ROC-AUC 0.95; blocked vessels, thalassemia, and chest pain type carried the most signal. Educational project, not a diagnostic tool.

Tools: Python · scikit-learn · k-NN · Logistic regression · Random forest

More detail

Business impact

Demonstrated a healthcare classification workflow while making clear that the work is educational and not a diagnostic system.

Technical challenges

Required careful feature handling, metric interpretation, and responsible communication of clinical limitations.

Lessons learned

This project strengthened my understanding of healthcare model limitations and why educational classifiers should never be presented as clinical diagnostic tools.

Healthcare AnalyticsSQL / Data Engineering

MyClinic Secure Healthcare Cloud Architecture

Design a scalable and secure serverless architecture for a healthcare patient portal.

Approach
Mapped access, frontend, API, compute, storage, identity, encryption, WAF, and governance controls into a clear healthcare architecture diagram.
Result
Architecture project focused on security, scalability, resilience, and patient-data protection.

Tools: AWS Route 53 · CloudFront · S3 · API Gateway · Lambda · DynamoDB · Cognito · KMS · WAF · IAM

More detail

Business impact

Turned a healthcare portal concept into a clear, security-first cloud architecture.

Technical challenges

Required mapping AWS services into a coherent flow across identity, API, compute, storage, encryption, and edge protection.

Lessons learned

This project helped me connect cloud service selection, security controls, and architecture storytelling into a diagram that both technical and non-technical audiences can follow.