Divyanshi Sharma
Delhi
Summary
Proven Data Engineer/ Analyst Consultant at ZS Associates, adept in data warehousing and stakeholder management. Have optimized backend SQL frameworks and automate ETL pipelines, leveraging AWS, SQL, and Python, with a knack for translating complex data into actionable insights for pharmaceutical sales strategies.
Overview
3
3
years of professional experience
Work History
Business Technology Associate Consultant
ZS Associates
Delhi
10.2024 - Current
- Lead a team to efficiently process and manipulate raw backend data from a large client data warehouse, utilizing Redshift as the primary analytical tool.
- Designed and optimized complex SQL queries within the PostgreSQL database engine to analyze and prepare backend data for integration into the dashboard system.
- Utilized Pandas, SQLAlchemy, and Boto3 frameworks to write Python scripts, driving efficient data processing and manipulation.
- Delivered updated Tableau dashboards to stakeholders, enabling comprehensive exploratory data analysis to support commercial sales strategies for pharmaceutical products.
- Engaged with stakeholders to gather requirements and led client calls to ensure clear and effective communication.
Business Technology Associate
ZS Associates
Delhi
01.2022 - 09.2024
- Worked with Amazon RDS and Redshift to process and retrieve large amounts of data from data lakes.
- Automated an ETL pipeline to clean and standardize raw clinical trial data using Python, AWS Lambdas, CloudFormation, and RDS, reducing manual work by 70% and increasing revenue by 35%.
- Provided important insights and key performance indicators (KPIs) to stakeholders using Spotfire, helping with exploratory data analysis in oncology and immunology.
- Manager : Subramanya Sarma Vadlapatla
Education
Bachelor of Technology - Information Technology
Guru Gobind Singh Indraprastha University(BPIT)
New Delhi08.2022
10 + 2 - PCM + CS
St.Xavier's School
Delhi05.2018
Skills
- Data Warehousing
- SQL Query Optimization/ Creation
- SDLC
- AWS Glue
- AWS S3
- AWS Lambdas
- Amazon Redshift
- Amazon RDS
- Pandas Dataframes, Numpy, Boto3, SQLAlchemy
- MS Excel
- Stakeholder Management
- Cross-Functional Collaboration
- Analytical problem solving
Accomplishments
- AWS Certified Data Engineer Associate - DEA-C01 (https://cp.certmetrics.com/amazon/en/public/verify/credential/6c11faa325474d11b888dcb8133f4dc1)
- AWS Cloud Practitioner Course
- HackerRank 5* - SQL Expert Badge
Personal Project
End-to-End ETL Pipeline on AWS Glue instance by importing sas data from S3 buckets, transformations using EMR cluster, loading and visualizing it using tableau and into a target S3 bucket.
Languages
- English, Full Professional Proficiency
- Hindi, Native or Bilingual Proficiency
Timeline
Business Technology Associate Consultant
ZS Associates
10.2024 - Current
Business Technology Associate
ZS Associates
01.2022 - 09.2024
Bachelor of Technology - Information Technology
Guru Gobind Singh Indraprastha University(BPIT)
10 + 2 - PCM + CS
St.Xavier's School
Similar Profiles
Vinita Ahuja BajajVinita Ahuja Bajaj
Senior Human Resources Associate - Staffing at ZS Associates (ZS)Senior Human Resources Associate - Staffing at ZS Associates (ZS)
ADINATH RAJEGOREADINATH RAJEGORE
Senior Test Engineer at ZS AssociatesSenior Test Engineer at ZS Associates
Shubham KumarShubham Kumar
AI Product Lead at ZS AssociatesAI Product Lead at ZS Associates