Summary
Overview
Work History
Education
Skills
SELECTED PROJECTS
Timeline
Generic

SWAPNIL SRIVASTAVA

Roxbury,Massachusetts

Summary

Entry-level Statistical Programmer and Data Analyst with hands-on experience building CDISC SDTM-compliant datasets and developing efficient SAS workflows. Proven success in implementing structured QC processes, achieving a 9.5% reduction in record discrepancies. Currently pursuing an MPH in Epidemiology & Biostatistics, complemented by SAS certification.

Overview

2
2
years of professional experience

Work History

Statistical Programming Intern

Med-Kick
West Palm Beach, FL
05.2025 - 08.2025
  • Built a scalable, metadata-driven SDTM pipeline in SAS 9.4, replacing domain-specific scripts with parameterized macros to enable reusable, study-configurable dataset generation — accelerating standardization workflows by 17%.
  • Developed 9 CDISC SDTM-compliant domains (DM, AE, EX, +6) for a simulated multi-site clinical study of 1,100 subjects (~77,000+ records), producing submission-ready structured datasets aligned with SDTM standards.
  • Implemented structured QC checks, including cross-domain consistency validation and record-level discrepancy resolution, detecting and resolving ~9.5% record-level discrepancies prior to finalization.
  • Generated Define-XML metadata, performed Pinnacle 21 compliance checks, and aligned controlled terminology to ensure submission-ready dataset structure.

Data Analyst (Intern)

Zuari Industries Limited
11.2023 - 05.2024
  • Automated documentation workflows and analyzed complex datasets to identify trends that informed business decision-making.
  • Created visual reports using Excel and Tableau for stakeholder presentations, collaborating with cross-functional teams to define data requirements.
  • Cleaned and managed operational datasets in Excel and SQL for monthly reporting, supporting compliance accuracy through systematic inconsistency detection.

Education

Master of Public Health (MPH) - Epidemiology & Biostatistics

Boston University
Boston, MA
05-2026

Bachelor of Pharmacy - Pharmaceutical Sciences

D Y Patil University
Pune, India
08-2024

Skills

  • Programming & Data: SAS 94 (Base, Macros, PROC SQL), R, Python, SQL, Data analysis
  • Data analysis
  • Data wrangling
  • Data management
  • SQL
  • R
  • Python
  • Data visualization

SELECTED PROJECTS

  • Clinical SDTM Mapping & Validation (SAS) — Independent, 2024, Built a scalable, metadata-driven SDTM pipeline (DM, AE, EX, LB) using parameterized macros for reusable, study-configurable dataset generation., Engineered deterministic data normalization and derivation logic to resolve multi-format dates, partial records, missing dose data, and non-standard terminology., Delivered submission-ready outputs with automated validation, including Define-XML generation, Pinnacle 21 compliance, and cross-domain integrity checks.
  • Observational Epidemiology — CRP & Depressive Symptoms — BU MPH, 2024–2025, Analyzed 2,951 participants to model the association between log-CRP and CES-D depression scores using sequential multivariable linear regression; crude β=0.489 attenuated 83% after BMI adjustment, identifying BMI as a key confounder., Tested CRP×menopause and CRP×smoking interactions and tertile-based exposure models; no significant effect modification observed., Conducted robustness analyses (exclusion criteria, multiple imputation m=20, influence diagnostics); estimates stable across 4 model specifications (<10% change in β).
  • Homocysteine and Depressive Symptoms — Independent, 2024, Integrated a 900-subject multi-domain clinical dataset (PROC SQL, join audits, ID validation) with a QC-driven pipeline (MAD/IQR outlier detection, dual-program verification); identified 26% informative missingness (final N=663)., Modeled plasma homocysteine–cognition association via multivariable regression and LASSO variable selection (SBC criterion); 61% attenuation after adjustment indicated minimal incremental predictive value beyond age/education.

Timeline

Statistical Programming Intern

Med-Kick
05.2025 - 08.2025

Data Analyst (Intern)

Zuari Industries Limited
11.2023 - 05.2024

Master of Public Health (MPH) - Epidemiology & Biostatistics

Boston University

Bachelor of Pharmacy - Pharmaceutical Sciences

D Y Patil University
SWAPNIL SRIVASTAVA