Azure Data Information Technology

Divya Agarwal

Evanston, Chicago *****

•***********@*****.***• +1-773-***-****

PROFESSIONAL SUMMARY

● Result-driven data professional with 3+ years of experience in ADF, database, tableau, ETL

● Passionate about staying at the forefront of technology trends, constantly upskilling myself

● Open to relocation including remote opportunities; Authorized to work in USA ACADEMIC QUALIFICATIONS

Northwestern University, Chicago: Master of Science in Information Technology Sep 2024-Dec 2025 Delhi Pharmaceutical Science & Research University, India: Bachelor’s in Science (GPA:- 3.7) Aug 2017-Sept 2020 EXPERIENCE

Deloitte USI (Consulting): Associate Analyst Jun 2021 – Aug 2024

● Designed and implemented data ingest and transfer pipelines on Azure Data Factory, utilizing Azure data flow, and seamlessly transferring the processed data into Azure Data Lake in multiple formats including JSON, Parquet, ensuring the completion of the entire pipeline.

● Worked on developing ETL pipelines for incremental data using Azure Data Factory.

● Worked on Google cloud console to access Big Query for the data transfer by using cloud run jobs.

● Design and prepare Unit test cases, validating the data and detail design document for mappings.

● Experienced with performance optimization, identifying errors, testing, debugging and providing resolution for the same.

● Created dashboards on Looker for detailed analysis of data.

● Identified critical bugs during UAT, thus taking care of quality deliverables. KPMG, India: Data Analytics Trainee Jan 2021 - Mar 2021

● Worked upon cleaning the Data with the help of Excel and SQL queries and gain basic knowledge on Python programming and reporting tool tableau.

● Acquired basics in the domain of Artificial Intelligence and Machine learning libraries like NumPy, PyTorch TECHNICAL SKILLS

Coding Languages Python, R, SQL, NoSQL, SQLite, Big Query Cloud Technology Microsoft Azure, Google Cloud Platform Certifications Python Data Structures, Getting started with python, Microsoft Azure Fundamentals(AZ-900), Microsoft Data Fundamentals(DP-900)

PROJECTS

Sobeys (ADF, Azure Data Studio, ETL, Azure Data Lake, GitHub, Zephyr, JIRA)

● Responsible for developing support, maintenance for ETL extraction, transformation, loading processes using ADF.

● Developed pipelines for incremental data load using Azure Data Factory.

● Performed data transformation using Azure Data flows.

● Developed business extracts and reports using Azure Data flows.

● Dealing with creation of test cases, perform unit testing and validation of ETL flow. Chanel (GCP, Big Query, Looker)

● Setup the process for GCP team to load 69 objects into BQ from CDP & S3 that helped looker team to generate reports.

● Created dashboards in Looker according to the business requirements to get more insights on data.

● Introduction to the load control table makes the process user friendly.

● Enhanced recon report to understand changing CDP count trends.

● Automated, Scheduling and deployment of CDP-BQ loads in prod and dev.

● Part of Data migration team during hypercare which aim to resolve issues with go live.

Contact this candidate