BHAVYA GAUR

• Leading cross-functional teams to implement data-driven strategies for client projects.
• Managing project timelines and deliverables to ensure alignment with client expectations.
• Collaborated with data scientists to define data requirements and workflows.
• Implemented data quality checks to ensure accuracy and reliability of datasets.

• Spearheaded process automation that eliminated the need for a four-member team, resulting in annual cost savings equivalent to four full-time employees (FTEs), and boosting project efficiency by about 50%.
• Optimized ETL processes by enhancing Python scripts, and improving dynamic data processing efficiency.
• Lead the design and implementation of cloud-native data architectures on AWS, supporting analytics and reporting workloads at enterprise scale.
• Partner with business, analytics, and platform teams to understand requirements and propose technically sound solutions, balancing scalability, performance, and cost.
• Delivered automation initiatives reducing operational effort equivalent to 4 FTEs, improving platform efficiency by ~50%.
• Designed and reviewed solution architectures leveraging AWS Lambda, Glue, S3, Redshift Spectrum, supporting high-volume data ingestion and processing.
• Actively participate in solution walkthroughs and technical reviews with stakeholders to validate design decisions and ensure adoption.
• Led migration of 20+ Lambda services to GitHub with CI/CD pipelines, reducing deployment cycles by 30% and improving release reliability.

Alnylam Reporting Layer Development and Commercial Operations

• Worked closely with commercial and analytics teams to define data and reporting requirements for enterprise pharmaceutical clients.
• Designed scalable reporting architectures enabling insights across sales, targets, and performance metrics.
• Supported solution validation discussions with stakeholders by explaining technical trade-offs and data models.
• Acted as a liaison between business users and engineering teams to ensure solutions met both technical and commercial expectations.

Nexus Upgrade - On-Premise to On-Cloud Upgradation

• Independently designed the orchestration architecture of data pipelines using python scripting & Airflow
• Developed data pipelines for over 50 workflows on Airflow
• Automated ETL processes resulted in the reduction of 50% of manual effort

CPM - Commercial Product Master

• Performed master data management & data governance on pharmaceutical data throughout all project lifecycle phases
• Built new functionalities in SQL for data ingestion & management for over 70 unique data sources
• Managed large data sets with advanced MS Excel functions & created dynamic data reports
• Currently Migrating all BOOMI processes to Airflow, resulting in 70% cost reduction

C-SCAN - Cloud Solution for Commercial Analytics

• Worked on reporting tool using PostgreSQL
• Optimized ETL processes resulted in a 30% reduction in process execution time.

Project: NFMT - Network Function Management Transfer

• Code maintenance, error removals & bug fixing of existing processes using Java programming