Shivani Sharma Email & Phone Number

India

Pune

* Migrated the legacy ORACLE database to Cloud using Azure services and created the globaldata model while considering various regional-level business requirements.* Interacted with business analysts and clients to gather and understand requirements forcreating and maintaining optimal data pipeline architectures.* Designed and implemented a data warehouse involving various heterogeneous data sourcessuch as SQL, CSV files, JSON, and XML.* Developed ETL pipelines for ingesting, cleansing, and processing insurance domain datausing Informatica Intelligent Cloud Services (ICS) and AWS.* Automated, parameterized pipelines are used to populate the facts and dimensions, part ofthe dimensional model, the output of which is connected to reporting tools such as PowerBi.* Eliminated data load dependencies by leveraging Hash-keys, allowing parallel data loads thatraised the efficiency standard.* Containerized ETL Application Developed ETL Pipelines to create Fact and Dimension tablesin Azure Synapse Data Lake, ingesting the data from OBIEE and API's for different businessfunctions such as cloud consumption data, Customer Data and Quotes Data.* Developed Data Models in Power BI and built multiple dashboards for various Businessteams to provide Data Insights and Analysis into different business areas like Sales,Marketing, Customer Data and Finance.

Gurugram, Haryana, India

*Extract Transform and Load data from multiple file formats to Azure Data Storage servicesusing a combination of Azure Data Factory, PySpark, Spark SQL.*Ingested, transformed and aggregated the data in the dataframe using PySpark and sparkSQL.*Established a process to handle change data capture which optimized the data pipeline byreducing the execution time from 15 hours to 1 one hour.*Provision the appropriate cluster estimating the cluster size according to the workload.*Mounted Azure storage to Databricks and created mount points that can be accessedthrough Databricks notebooks using the file semantics.*Used Azure key-vault to store and use and secret values in the Databricks notebook usingDatabricks Secret Scope.*Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to extract, transform andload data from different sources.*Created DDL’s for tables and executed them to create tables using PySpark and spark SQL.

Gurugram, Haryana, India

*Delivered cloud solution for new and existing client moving to or from IBM cloud’sEnvironment.*Implemented Disaster Recovery Solution within IBM cloud o Implemented IBM SVCconfiguration per clients High Availability Specification.*Migrated production workload from VMware vSphere to IBM SVC.*Created custom private, public and Hybrid cloud solution for 50+ customers leveragingVMware and IBM cloud.* Analysed complex project server issues and worked on large enterprises and businesscritical applications.

New Delhi, Delhi

Data Visualization Tool: Built a data visualization website using Python, Django and D3.js.Added support for building interactive graphs, multiple database formats and buildingdashboardsImplemented a data engineering solution using Azure Databricks and Spark core foranalyzing and reporting on real World Formula1 motor race. Ingested and transformed thedata using PySpark and analysed data using Spark SQL in Azure Databricks. Also createdAzure Data Factory pipelines to execute Databricks notebooks and Azure DataFactory triggers to schedule pipelines as well as monitor them.

Bachelor Of Engineering, Electronic And Telecommunication

12