About

Detail-oriented and quantitatively driven Data Analyst with a rigorous foundation in Pharmaceutical Sciences (B.Pharm) and Clinical Research. Proficient in transforming raw clinical trial and healthcare datasets into actionable insights using SQL, Python, Advanced Excel, and Power BI.

Projects3

• Clinical Trial Adverse Event (AE) Analysis & Safety Dashboard

  Ingested and cleansed multi-center trial records covering 2,500+ patient entries; resolved null values, standardized medical coding terms, and enforced CRF validation rules. Designed and executed SQL aggregation queries and window functions to compute AE occurrence frequency, severity distribution, and treatment-emergent incidence rates.

  • Power BI
  • SQL
  • Excel

• Healthcare Hospital Operations & Patient Readmission EDA

  Conducted end-to-end Exploratory Data Analysis (EDA) on over 10,000 anonymized patient records using Python (Pandas) to pinpoint key drivers behind 30-day hospital readmissions. Delivered a structured summary report outlining actionable patient monitoring recommendations, identifying a 14% higher readmission variance in multi-medication cohorts.

  • Python
  • Pandas
  • Seaborn

• Pharmaceutical Retail Sales Performance & Inventory Tracker

  Engineered an automated Excel inventory model employing XLOOKUP, dynamic Pivot Tables, and conditional alerting to monitor stock replenishment and drug expiry dates. Analyzed quarterly sales trends across 40+ drug categories to forecast re-order thresholds, mitigating potential stock-out risks by 20%.

  • Advanced MS Excel

Education2

• LM

  Bachelor of Pharmacy

  2022 — 2027

  Lucknow Model College of Pharmacy (AKTU)

  Pharmaceutical Sciences

• SI

  Senior Secondary

  2020 — 2022

  SBN Inter College

Certifications3

• Advanced Certification in Clinical Research, CDM & Pharmacovigilance

  Udemy

• Data Analysis & Visualization Foundations

• Hands-on Clinical Research Workshop

  CPA Institute