Faith Chuwang-Kwa

Integrated three institutional datasets (Applicant, Connect, SEVIS) covering 6,893 student records to support compliance analysis. Identified enrollment gaps (78% deposit non-payment, 65% I-20 document deficit, 52.7% SEVIS fee gap) and built a Looker Studio dashboard with 30/30 metric validations matching SQL queries.

Assessed hospital performance and financial trends across a 5,000-record patient dataset for the NorthBridge Health Investment Fund capstone, identifying 10 KPIs. Investigated data-quality issues and proposed fixes, including median imputation. Delivered a Power BI dashboard and analyzed claims denials to flag high-risk cases and project revenue-recovery opportunity.

Analyzed 8,558 student engagement records and built a Random Forest model to predict learning opportunity participation across 22 opportunities. Achieved 94% accuracy and 0.97 AUC-ROC, and delivered an end-to-end pipeline from cleaning and EDA through modeling and executive-ready recommendations.

Analyzed 30+ customer support tickets to identify trends in issue categories, sentiment, and operational performance, finding over 50% of tickets reflected negative experiences tied to account and billing issues. Built an Excel dashboard tracking ticket volume, issue distribution, and average resolution time (1.47 hours) and proposed workflow automation to improve ticket prioritization.

Supported analysis of admissions outreach and applicant datasets by cleaning, standardizing, and conducting exploratory analysis on geography, program demand, and outreach activity. Built an interactive Power BI dashboard and defined KPIs including outreach volume, follow-up rate, response metrics, and average contact attempts to inform admission outcomes tracking.

Cleaned, validated, and transformed multi-source datasets using SQL, Power Query, PostgreSQL, Excel, and Python to support financial and exploratory analysis projects. Built profitability/ROI and forecasting models, created Power BI dashboards, processed 48,000+ sports records and analyzed 50,000+ ride-hailing records, and produced structured insight reports with business recommendations.

Performed sales trend analysis to identify top products and seasonal customer patterns, and built dashboards to track key metrics such as top customers, sales by country, and product breakdowns. Cleaned and standardized large datasets to improve accuracy, and delivered actionable insights that informed marketing campaigns and strategic pricing decisions.

Prepared medical reports, memos, and patient records with high accuracy and served as departmental secretary to support administrative coordination. Assisted with patient diagnostics as an EEG and ECG technician.

Registered and dispatched laboratory results in the Hematology Department and supported blood bank operations, including patient blood requests and donor screenings. Provided administrative and clinical support within laboratory and bleeding room units.

Grade: 4.42

Activities and societies: N/A

Pursuing a Master of Public Health with a focus on Epidemiology. Applying academic training and hands-on analytics experience to deliver decision-ready insights.

Activities and societies: Relevant coursework: Research Methodology, Biostatistics, Cardiovascular Physiology, Laboratory Techniques in Physiology, Neurophysiology.

Completed a Bachelor of Science in Physiology with coursework spanning research methodology, biostatistics, and multiple physiology sub-disciplines.