Data Analyst Healthcare

HARVALEEN

BHATHAL

Frisco, TX *****

330-***-****

***********@*****.***

linkedin.com/in/harv12

US Citizen

TECHNICAL SKILLS

Statistical Analysis &

Programming: SAS, R, SPSS,

Python(basic), SQL (complex

queries, SQL Joins, subqueries)

Data Visualization & Reporting:

Tableau, PowerBI, Microsoft Excel

(Advanced: Pivot Tables, VLOOKUP,

macros, PowerQuery)

Data Processing & Cleaning: R

(dplyr, tidyr), SAS PROC SQL,

Python (pandas)

Survey & Data Collection Tools:

REDCap, Epi Info

Mathematical and Statistical

Techniques: Regression, Predictive

Modeling, Time Series Analysis,

Hypothesis Testing, Bayesian

Statistics, Trend Analysis & Quality

Measures, Gap & Root - cause

Analysis

Other Skills: Microsoft Teams,

PowerPoint, Outlook, Snowflake,

EMRs/EHRs knowledge &

management, Protocol writing,

Program development, Health care

codes like ICD-10 knowledge, ETL

processes, Claims & Healthcare data

(CMS), Infection prevention, Disease

Surveillance, Epic systems,

STARs/HEDIS Knowledge

Soft Skills: Analytical Thinking,

Problem Solving, Attention to Detail,

Critical Thinking, Communication,

Organizational, Time Management,

Adaptability, Teamwork,

Continuous Learning, Decision

Making, Client-facing experience

PROFESSIONAL SUMMARY

MPH-trained Biostatistician and Healthcare Data Analyst with 4+ years of experience in public health surveillance, predictive modeling, and healthcare claims analysis. Proficient in SQL, R, SAS, Power BI, and Excel, with hands-on experience in EHR and claims data integration, statistical analysis, and dashboard development. Adept at communicating complex analytic findings to stakeholders to support strategic planning and resource optimization. PROFESSIONAL EXPERIENCE

Heluna Health, San Leandro, CA

Data Analyst March 2022 – April 2025

• Team lead for designing and development of dashboards to monitor performance measures using claims and EHR data from Medicare and SNP populations, analyzed healthcare utilization and outcomes; supported care coordination, gap closure, and reimbursement strategies aligned with CMS guidelines.

• Collaborated with physicians on HBV, pertussis, RSV, and syphilis in pregnancy for resource allocation. Data collection using REDcap survey, other data sources like claims data & EHRs to access trends in clinical practices, treatment and co-morbid conditions.

• COVID-19 surveillance using EHRs, CEIP, CalConnect & SPOT. Trend analysis using R and implemented control measures to limit spread.

• Conducted root-cause analysis using SQL to identify circumstances leading to occurrence and transmission of COVID-19 in LTCFs using claims and HER data with primary aim to enhance support to improve care and resource allocation. Created dashboards in Microsoft excel & PowerBI for the same.

• Conducted gap analysis using SQL & R to compare two different data sources for reported hospitalizations and deaths related to COVID-19 with an aim to pinpointed areas of weakness within the data sources and developed processes of data flow and data integrity.

• Conducted integrated analysis of COVID-19 cohorts using claims and EHR data to assess epidemiological trends and financial impact; identified underreported services (e.g., oxygen therapy), improved comorbidity capture, and supported data-driven decisions on care management, reimbursement optimization, and resource allocation. Created dashboard for the above measures in PowerBI.

• Conducted predictive analysis using R for vaccine uptake, thus collaborated in planning proactively for COVID-19 vaccine hesitancy among LTCFs residents, resulting in 12% increase in vaccine uptake in the desired population.

• Developed statistical models that predicted hospitalization & death outcomes post- vaccination with 85% accuracy, resulting in targeted resource allocation towards the same.

• Authored statistical portions of internal proposals and analytical reports, contributing to program planning and resource allocation.

• Team lead for 2+ years, training, and supervising 15+ data clerks, standardizing QA processes and improving data workflow efficiency by 30%.

Tools: R, SQL, PowerBI, Microsoft Excel, CMS, EHR, Salesforce, CalCONNECT, CalREDIE, CAIR, Snowflake Los Angeles County Department of Public Health, Los Angeles, CA Epidemiology Analyst March 2021 – October 2021

• Collaborated in the design and maintenance of public health surveillance systems.

• Coded and automated statistical procedures using SAS macros to monitor vaccination coverage and data quality.

• Created COVID-19 data tools in REDCap and analyzed longitudinal patterns in infection trends.

• Wrote QA scripts and provided regular statistical summaries for public health dashboards. Tools: R, SAS, Tableau, Microsoft Excel, CAIR, REDcap EDUCATION

• Boston University School of Public Health September 2019 – January 2021 MPH, Epidemiology & Biostatistics

• Bharati Vidyapeeth Medical College, Pune, India June 2009 – Jan 2015 MBBS, Bachelor of Medicine & Bachelor of Surgery

RESEARCH & PUBLICATIONS

• Research Assistant - Murray Causal Lab, Boston, MA August 2020 – Jan 2021

Applied DAGs to infer causal relationships between health variables and outcomes.

• Volunteer - Epidemiology COVID-19 Response Corps, Boston, MA June 2020 – March 2021

Conducted data cleaning and visualization of COVID-19 misinformation on Twitter using Python.

• Publication: Bhathal, H. “To Study the Analgesic Effect of Transdermal Nitroglycerine with Intrathecal Clonidine in Lower Abdominal Surgeries.” http://www.iosrjournals.org/iosr-jdms/papers/Vol16-issue7/Version- 7/H1607074364.pdf

CERTIFICATIONS

• Infectious Disease Transmission Models for Decision-Makers – Johns Hopkins University

• COVID-19 Contact Tracing – Johns Hopkins University

• HIPAA & Research Data Security – CITI Program

Contact this candidate