Romyy Gautam

Data Analyst with 7+ years of experience translating complex biotech and laboratory data into decision-ready reporting, dashboards, and operational insights. Skilled in SQL, Python, Power BI, Tableau, Snowflake, and data modeling, with experience integrating LIMS, Benchling ELN, and Veeva Vault data. Improved reporting efficiency, standardized KPI definitions, and supported QC, manufacturing, and leadership decisions in GMP/GLP-regulated environments.

Data Analyst, Data Engineering and Analytics at Ultragenyx Pharmaceutical (2023-05 – Present)

• Built and maintained SQL and dbt models that integrate LIMS, Benchling ELN, and Veeva Vault data into Snowflake through Fivetran CDC, adding automated tests and source-to-target reconciliation.
• Automated QC stability trending and out-of-trend detection with Python, Snowpark, pandas, and SciPy, replacing a two-day manual Excel process with a scheduled, version-controlled pipeline.
• Developed Power BI dashboards and Snowflake semantic models for assay performance, method qualification, stability trends, and KPIs across 6 AAV gene therapy programs, reducing weekly reporting from 8 hours to under 1 hour.
• Integrated and reconciled analytical data from internal teams and 4 external laboratories, identifying data gaps and inconsistencies across method-transfer, qualification, and program milestones.
• Delivered trend analyses, CMC summaries, and executive reporting for 30+ OOS/OOT investigations, deviations, CAPAs, and change controls in partnership with QC, QA, Regulatory, and Analytical Development.

Associate Scientist II, Data and Assay Analytics at ElevateBio (2022-09 – 2023-05)

• Used SQL and Python to clean, join, and validate experimental and biomarker data from 30+ studies, creating analysis-ready datasets for reporting.
• Defined KPIs, requirements, and acceptance criteria with stakeholders and automated SQL validation checks, reducing rework from inconsistent data by approximately 25%.
• Built 15+ Tableau dashboards for performance metrics and trends, reducing manual reporting time by 40% and standardizing weekly cross-functional reviews.
• Applied trend analysis, control charts, ANOVA, regression, and outlier detection across 15+ data sources to investigate variability and identify performance shifts.

Data Analyst, Business Intelligence at Oxford Biomedica Solutions (2021-07 – 2022-09)

• Designed Azure Analysis Services tabular models and star-schema relationships to support consistent Power BI reporting and improve report performance.
• Created reusable DAX measures and standardized KPI definitions, cutting ad hoc data requests by 25%; implemented row-level security and Power BI dataflows to improve report access accuracy by 20%.
• Automated data preparation with Python and Tableau Prep, combining and validating data from multiple sources for repeatable, governed reporting.
• Analyzed QC cycle-time and quality KPIs using SQL and Tableau, contributing to an 18% reduction in average QC testing turnaround.
• Analyzed GMP release, stability, and in-process data across 60+ AAV batches, informing production planning improvements of 15% and a 10% reduction in supply chain risk.

Research Data Analyst at University of Massachusetts Dartmouth (2020-09 – 2021-05)

• Designed a data collection framework for a drug-delivery study covering 12 hydrogel formulations and built Python and MATLAB workflows to clean, validate, and analyze time-series results.
• Applied nonlinear regression and correlation analysis across release, mechanical, chemical, and cell-viability data; automated repeatable processing and reporting with Python, GraphPad Prism, and Excel.

Research Associate at MassBiologics, UMass Chan Medical School (2019-01 – 2019-12)

• Generated and analyzed reproducible laboratory data using GraphPad Prism and Excel while supporting cell-based assays, high-throughput processes, and protocol optimization under quality-controlled procedures.

Research Intern at University of Massachusetts Dartmouth (2018-06 – 2018-08)

• Analyzed research data using R and GraphPad Prism and documented experimental results in accordance with GLP and laboratory quality protocols.

Bachelor of Science in Bioengineering and Biomedical Engineering – University of Massachusetts Dartmouth (2014-09 – 2019-05)