Parmeet Kaur Arora

About Parmeet Kaur Arora

Transforming healthcare and clinical data into compliance-ready insights through SAS…

Experience

1. Senior Data Analyst

   Walgreens

   Oct 2022 — Present · Columbus, OH, US

   Generated various reports using SQL Server Report Services (SSRS) for business analysts and the management team.•Clean data and processed third-party spending data into maneuverable deliverables within a specific format with Excel macros and python libraries such as NumPy, SciPy, and Matplotlib. •Responsible for providing SAS programming and analysis support for Phase I and Phase 2 clinical drug trial.•Developed SAS programs to validate programs written by other SAS programmers.•Designed, developed, and validated 20+ recurring SAS and SQL reports for pharmacy claims and vendor utilization, reducing manual reporting time by 30%.•Worked on data that was a combination of unstructured and structured data from multiple sources and automated the cleaning using Python scripts.Integrated EHR and retail pharmacy data using Spark and unified into Snowflake; designed real-time analytics dashboards in Power BI and Tableau.•Designed, developed, and validated 20+ recurring SAS and SQL reports for pharmacy claims and vendor utilization, reducing manual reporting time by 30%.•Partnered with PBMs, clinical teams, and vendors to define reporting requirements and resolve data discrepancies.•Created Tableau dashboards and Excel-based KPI trackers for adherence trends, cost metrics, and utilization patterns.•Conducted QA checks and UAT for internal pharmacy analytics tools, ensuring compliance with HIPAA. •Automated standard monthly reports in SAS, reducing report generation cycle from 3 days to 1 day. •Created reusable internal R and Python packages for epidemiology and statistical functions; versioned with Git and GitHub.•Conducted CDISC SDTM/ADaM transformation; supported database lock, audit trail, and FDA submission readiness.•Performed automated data QC, reducing manual validation time by 40%; applied Great Expectations, Pandera for data profiling.•Mentored junior data scientists in reproducibility, Git workflows, and clinical ML modeling.

Education

• GuruSchool

  SAS Clinical

  2025 — 2025

• The Ohio State University

  Certificate

• The Ohio State University

  Associate's degree

  2024 — 2024

• College Of Technology, G.B.P.U.A&T, Pantnagar

  Master's degree

  2000 — 2003

• Sanjay Gandhi Post Graduate Institute of Medical Sciences, Lucknow

  Doctor of Philosophy - PhD

• GuruSchool

  DATA Science

  2021 — 2022

• Mahatma Jyotiba Phule Rohilkhand University (MJPRU), Bareilly

  Bachelor's degree

  1997 — 1999

• The Ohio State University

  Data Analyst

  2024 — 2024