Sai Kiran A

Azure Data Engineer

Email: saikiran.askani@gmail.com | Contact: +91-8123906899

Linked in : https://www.linkedin.com/in/sai-kiran-66a594160/

Experience Summary

▪ Over 5+ years of hands-on experience in designing, developing, and maintaining data

analytics platforms within Cloud environments.
▪ Skilled in implementing data and ETL logics for effective data processing.
▪ Skilled in architecting, designing, and operationalizing large-scale data and analytics
solutions on Cloud Data Warehouses.
▪ Demonstrated expertise in migrating multiple analytics platforms from On-Premises Data
Warehouses to Cloud Data Warehouses.
▪ A solid grasp of Cloud Data Warehouse architecture, best practices, and techniques for
optimizing performance.
▪ Actively supporting Azure Center of Excellence (CoE) teams in solutioning, Proof of
Concepts (PoCs), Requests for Proposals (RFPs), and other initiatives.
▪ Experienced in automating platform monitoring to ensure data quality and handle
common data issues efficiently.
▪ Skilled in communicating with key stakeholders to assess project needs and establish
clear objectives for project teams.
▪ Responsible for solution, estimation, task breakdown, work allocation and validation.
▪ Experienced in Agile Scrum methodologies for project management.

Work Summary
PwC Jan 2022 – Till Date Senior Associate
Deloitte Dec 2020 – Jan 2022 Analyst
LTI Aug 2018 – Dec 2020 Data Engineer

Educational Qualification
Education B.E (ECE), BMS College of Engineering (8.48 CGPA)
BANGALORE | 2014 - 2018

Skills Summary
Domain Retail, Manufacturing,Pet Care, Healthcare
▪ Microsoft Certified: Azure Data Engineer Associate (DP-203)
Certifications ▪ Databricks Certified: Data Engineer Associate
▪ Microsoft Certified: Azure Fundamentals (AZ-900)
▪ Microsoft Certified : Administering Microsoft Azure SQL
Solutions(DP - 300)
 Tools and Technologies
▪ Azure Data Factory (ADF V2)
▪ Blob Storage
▪ Azure SQL Database
▪ Azure Synapse Analytics
▪ Azure Databricks
▪ SQL
▪ UniX
▪ Pyspark
▪ SSMS
▪ Azure Key Vault
▪ Logic Apps
▪ Azure DevOps
▪ Power Automate
▪ DLT (Delta live tables)
▪ Unity catalog
▪ Azure Purview

Work Experience

Project 1
Project Name Inventory Data Mart Team Size 12
Start Date Jun 2023 End Date Present

Stryker is a leading global medical technology company dedicated to

improving healthcare outcomes through innovative products and services
across orthopedics,medical and surgical specialties, and neurotechnology.
Project Working closely with Stryker, our team led the creation of a custom data
Description system to make managing inventory easier. We brought together different
kinds of data and used smart tools to give instant updates on inventory.
Our system also includes easy-to-use reports and visual tools so that
everyone involved can make better decisions, which helps things run
smoother and improves patient care.
▪ Led the discovery phase to thoroughly understand Stryker's
inventory challenges, guiding subsequent decisions.
▪ Played a key role in designing the data mart, using technical
frameworks like Medallion in Delta Lake.
▪ Actively participated in development, ensuring alignment with
project goals and client needs.
▪ Collaborated with teams to integrate data sources, employing
advanced ingestion via DLT.
▪ Contributed to testing, employing a robust metadata framework
Role & and Unity catalog for data organization.
Contribution ▪ Provided continuous support, addressing technical issues
promptly during implementation.
▪ Conducted knowledge transfer sessions to empower Stryker's
teams with technical skills.

▪ Orchestrated the development of a tailored data mart,

overseeing all phases.
 ▪ Integrated various data sources into a unified inventory
database.
▪ Implemented analytics techniques for real-time inventory
insights.
▪ Optimized operations and improved patient care through
data-driven solutions.
▪ Providing Hypercare to already completed projects.

Technology & Azure Snapse Analytics,Databricks, Datalake (ADLS), SQL, Unity catalog,
Tools DLT framework, Metadata framework

Project 2
Global Analytics Platform Migration to
Project Name Team Size 10
Azure
Start Date Jan 2022 End Date Jun 2023

Project Consumer Cellular is an American postpaid mobile virtual network

Description operator founded in October 1995.The company offers cellphones,
no-contract cellphone plans, and accessories with a focus on users age
50-plus. Objective of the project was to Ingest their on-prem data to cloud
and later analyze their data and produce reports based out of it so they
can change their business model accordingly as per the market demand.

▪ Responsible for conducting initial assessment, complexity

Role &
analysis & understanding existing architecture of the present on
Contribution
premise platform along with project timelines and other metrics
▪ Part of solutioning team which provided TO-BE architecture and
HLD
▪ Developed Pipelines in ADF and also developed the data model
in Azure Synapse with the help of Stored procedures and views
▪ Identified existing platform and application debt and planned
way workaround while doing the migration
▪ Supported/enhanced the automation created to migrate the DB
objects and data load
▪ Conducted data validations for the historical data loaded and
fixed any issues during the process
▪ Re-running the entire code on the new Azure platform and
comparing the outputs with existing On-prem SQL platform
▪ In case of mismatches conducting end to end RCA and provide
valid justification and fix for the mismatches to business users
and document the same in testing artifacts
▪ Helped the downstream reporting teams/users to connect to
Snowflake platform and ensured that downstream is not
impacted in terms of data quality
▪ Supported Hypercare for agreed timelines and conducted KT
sessions to the AMS team with proper notes and documents
Technology & Azure data factory V2, Azure Blob Storage,Azure Synapse analytics, SQL
Tools
Project 3
Data Ingestion and Implementation
Project Name Team Size 8

Start Date Feb 2021 End Date Dec 2021

Project Kroger, a prominent retail giant in the United States, boasting a legacy
Description dating back to 1883, operates a vast network of supermarkets,
department stores, and convenience outlets nationwide. In collaboration
with Kroger, our team took the lead in implementing a robust data
ingestion framework aimed at significantly enhancing data processing
efficiency. Leveraging advanced technologies and methodologies, we
successfully reduced processing time by 30%, enabling Kroger to
streamline its data ingestion processes and accelerate time-to-insight. This
initiative played a pivotal role in improving operational agility and
decision-making capabilities, ultimately driving greater efficiency and
effectiveness across Kroger's data operations.

▪ Responsible for conducting initial assessment, complexity

Role &
analysis & understanding existing architecture of the present on
Contribution
premise platform along with project timelines and other metrics
▪ Part of solutioning team which provided TO-BE architecture and
HLD
▪ Collaborated closely with cross-functional teams to gather
requirements, define project scope, and ensure alignment with
Kroger's business objectives.
▪ Implemented a data ingestion framework reducing processing
▪ time by 30%.
▪ Developed PySpark scripts improving data processing efficiency
▪ by 25%.
▪ Supported/enhanced the automation created to migrate the
objects and data load
▪ Contributed significantly to the testing and validation processes
to ensure the functionality and efficacy of the data ingestion
framework.
Technology & Azure Data Factory, Azure Databricks, Azure Data Lake Gen 2, SSMS, SQL
Tools
Project 4
Project Name EDP Migration to Azure Cloud Team Size 12
Platform
Start Date Jan 2019 End Date Nov 2020
First Solar, Inc. is an American photovoltaic (PV) manufacturer of rigid
thin film modules, or solar panels, and a provider of utility-scale PV
power plants and supporting services that include finance,
construction, maintenance and end-of-life panel recycling.
Project
Objective of the project is to build and Enterprise Data Platform (EDP)
Description
on Azure stack to transaction from its legacy data landscape to future
EDP to fulfil the operational and analytical reporting needs.
The project was executed in several phases, each phase containing set
of applications which was migrated from on premise to Azure cloud
▪ Responsible for creating design document and data model
based on the discussion with client/stakeholder.
▪ Responsible for providing the project estimates along with
other metrics.
Role & ▪ Creation of DB objects (Tables, Views, SP’s) as per the data
Contribution model.
▪ Creation, testing, migration & scheduling ADF pipelines to move
data from respective source system (On-Premise) to Azure.
▪ Hypercare provided to the deployed applications.
▪ Mentored the teammates and new entrants in team about the
technologies and process required for project needs.
Technology & Azure Data Factory(V2), Azure Blob Storage, Azure SQL Database, Azure
Tools SQL Data warehouse

Personal Profile
Date of Birth 28th Feb 1996
Marital Status Single
Nationality Indian
Phone +91-8123906899
Email saikiran.askani@gmail.com