Default profile banner
VG

Vasundhara Garg

@vasundharagarg

Associate Data Engineer at ECOM EXPRESS

Gurgaon, Haryana, India

https://www.linkedin.com/in/vasundhara-garg-0110b01a1

ECOM EXPRESSUPES

Vasundhara Garg is an Associate Data Engineer skilled in building scalable and fault-tolerant ETL pipelines. She has experience utilizing tools like Debezium, Kafka, Spark Structured Streaming, and Airflow to achieve significant latency reductions. Her expertise includes establishing connections between Redshift Spectrum and AWS Athena, and creating interactive dashboards using Power BI. She is proficient in Python, MySQL, and various AWS services.

Experience

Associate Data Engineer

ECOM EXPRESS

•Aug 2021 - Present•Gurgaon, Haryana

Developed and deployed a fully automated, scalable, fault-tolerant and cost-effective ETL pipeline to hydrate the data lake with transactional data for a 97% latency reduction. Achieved using Debezium, Kafka, Spark Structured Streaming, Airflow, Grafana. Established connection between Redshift Spectrum Database and tables created in AWS Athena using Power BI Dashboards. Created interactive and consolidated views with comprehensive filters which enabled viewers to receive several insights through dynamic visuals averaging 6000 views per day per dashboard by various stakeholders, leading to better monitoring and improving efficiency of shipments. Extracted data from MySQL, performed data analytics, and generated insights and summaries as per business requirements. Applied CSS to reports and scheduled them using cronjobs on AWS EC2 to share mailers periodically to different users and stakeholders, leading to ~67% reduction in generation time per report.

Education

UPES

B.Tech in CSE

Big Data

Jan 2021•Grade: 7.1 CGPA

St. Ann’s Senior Secondary School

Class 12th

Jan 2017•Grade: 76%

Skills

Python
MySQL
S3
EMR
Athena
MSK
Spark
Hadoop
MapReduce
Kafka
Airflow
Promethus
Grafana
Power BI