Overview
Work History
Education
Skills
Certification
Personal Skills
Timeline
Generic

SHRISTI SAXENA

Data Engineer & ETL Developer
Gurgaon

Overview

6
6
years of professional experience
6
6
years of post-secondary education
2
2
Certifications

Work History

Business Technology Associate Consultant

ZS Associates
Gurgaon
01.2023 - Current

Project: Cloud Migration across AWS environments

  • Tech Stack: Databricks ETL Pipelines, AWS, Data Warehousing, CDOCS, Python, PySpark, SQL, GxP
  • Migrated clinical modeling workloads from Client-hosted infrastructure to Vendor-hosted cloud
  • Reducing maintenance overhead and improving scalability.
  • Defined ETL pipelines for ingestion and transformation of clinical trial data under GxP standards
  • Created HLDs and data flow diagrams to support regulatory audit documentation
  • Acted as the primary liaison with QA and Validation teams to ensure compliance and CAPA coverage

Project: Data Engineering & Compliance

  • Tech Stack: Databricks ETL Pipelines, PySpark, AWS, Python, CDOCS, Data Security
  • Supported ongoing enhancements and KTLO tasks for biomarker data pipeline.
  • Led delivery for Security tool - Privacera Sunset release.
  • Designed scalable data ingestion workflows for high-throughput genomic data
  • Proposed automation enhancements that improved validation turnaround time by 30%

Validation Leadership across GxP Projects

  • Led test case creation, execution, and deviation handling for validated systems
  • Ensured audit readiness by managing controlled documentation in CDOCS
  • Coordinated functional testing with QA for validated systems hosted on AWS

Business Technology Associate

ZS Associates
Gurgaon
01.2020 - 06.2023

Project: Clinical Data Automation Platform

  • Tech Stack: PySpark, Kedro ETL Pipeline, PostgreSQL, AWS, Dash
  • Built ETL pipelines for clinical data harmonization, enabling analytics and visualization layers for global stakeholders.
  • Automated ingestion of biomarkers, and patient datasets across multiple studies building reusable data quality modules with custom DQM checks
  • Developed interactive dashboards using Dash and RShiny for client-facing reports

Project: Data Reporting Rationalization:

  • Tech Stack: SQL, Python, JIRA, HP ALM, Data Modelling
  • Audited and rationalized 1̃00+ legacy reports used across business units to identify opportunities for consolidation.
  • Partnered with business leads to defining metrics and eliminating redundant reports

GxP Validation & Testing Initiatives

  • Developed and executed IQ/OQ/PQ protocols and traceability matrixes aligned to FDA 21 CFR Part 11, and conducted UAT with stakeholders

Education

B.Tech. - Information Technology

DIT University
Dehradun, India
08.2016 - 06.2020

Senior Secondary - Science

CBSE
Ghaziabad, India
02.2015 - 03.2016

High School -

ICSE
Lucknow, India
02.2013 - 03.2014

Skills

Core Competencies: Data Engineering, ETL Development, Data Modelling, Business Intelligence, Performance Optimization, Data Governance, Data Quality Management

Certification

AWS Cloud Practitioner Core AWS Services

Personal Skills

  • Analytical Thinking
  • Adaptability
  • Leadership
  • Problem Solving
  • Communication
  • Creative Thinking

Timeline

Business Technology Associate Consultant

ZS Associates
01.2023 - Current

Business Technology Associate

ZS Associates
01.2020 - 06.2023

B.Tech. - Information Technology

DIT University
08.2016 - 06.2020

Senior Secondary - Science

CBSE
02.2015 - 03.2016

High School -

ICSE
02.2013 - 03.2014
SHRISTI SAXENAData Engineer & ETL Developer