Naukri_AkshathaS[5y_0m]

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 2

Akshatha S

Azure Data Engineer : +91-8310913166


: shivakumarakshatha48@gmail.com

Major Skillset: SQL/TSQL, Azure Data Factory, Azure Synapse Analytics, Azure Databricks, ETL using SSIS & ADF,
SQL Server Query Optimization and performance tuning, Data modeling & Data Warehousing.

Briefing : Tech Stack

 Microsoft Azure Data Engineer with 5 years of experience with extensive exposure to Financial, Healthcare &
Insurance domains.
 Experienced in developing Azure data factory pipelines integrated with ADLS Gen2 Data Lake and Azure
Databricks. Also hands on experience with designing logic apps and analysis solutions in Azure.
 Experienced in building Azure Synapse Analytics pipelines, also hands on experience working with serverless
and dedicated pools in Synapse.
 Stream data processing using Azure Stream analytics job and Azure Event Hubs.
 Experienced in developing and designing data warehouse solutions using SQL and Migration of On-premises
processes and applications to Azure Cloud.
 Experienced in writing T-SQL Queries, Dynamic-queries, subqueries and joins for generating Complex Stored
Procedures, Triggers, User-defined Functions and Views.
 Proficient in requirement analysis, designing and implementing BI, ETL solutions to applications integrated with
Microsoft SQL, SSIS and reporting using SSRS, PowerBI.
 Experienced in performance tuning and optimization, using Microsoft SQL Profiler & SQL tuning advisor.
 Thorough understanding of Data Warehousing and Business Intelligence concepts, experienced in Gitbash &
Azure Devops for source code control.
 Hands on experience with Microsoft Azure along with ADF pipelines.
 Experienced in developing and implementing data models and database designs to support business
requirements.
 Super proficient in communication skills and representational abilities.

Page 1 of 2
Professional Experience Summary

Corporate Software Pvt Ltd. - Azure Data Engineer (October 2023 – Till Date)
Project – Costa Coffee
- Currently working on building Azure ADF pipelines for processing client’s source
data and sending it to Data warehouse after applying transformations using
Stored procedures and generating outbound files for third party sources.
- Using multiple transformation types including Azure Databricks, Synapse
Notebooks, Azure logic apps to send email alerts in case of success & failure
both.
- Working on 2 OLAP cubes(Sales & Loyalty) to provide data for Client’s analysis
in form of PowerBI reports.
- Writing stored procedures from scratch to store data from Data lake in temp table
and then loading those in dimension & fact tables in Data warehouse.
- Implemented Snowflake data model of data warehouse in Azure SQL for Costa
client.

Marktel Technologies Pvt Ltd. Azure Developer (Apr 2021 – Aug 2023)
- Developed Ameriprise’s application Brokerage Products using multiple Azure
Services. Creating data transformation pipelines using azure data factory with
SFTP source.
- Implemented Microsoft Azure cubes using Azure analysis services to generate
dashboard for client directly.
- Leading a team of 6 resources with development work from India on Ameriprise’s
application Brokerage Products along with end-to-end BAU activities.
- Streamlining infrastructure for BP and EMMS application and reducing
maintenance activities work hours. Reporting to leaders by creating PowerBI
Dashboards.

MSBI Developer (Nov 2019 - Mar 2021)


- Worked on various data layers namely: Data Staging, Data integration, ODS,
Data Export developed using SSIS tool with data source as client imported DB
BACPAC file.
- Performed data imports from client on-prem server to implement Anti-money
laundering scenarios in Fiserv’s FCRM tool integrated with Microsoft SQL Server.

Technical Skills

Tools\Applications Efficiency : SQL Server Integration Services(SSIS), JIRA, Service-Now

Databases Microsoft SQL Server, Azure SQL Database


Reporting Tools Microsoft SQL Server Reporting Services(SSRS), Microsoft PowerBI
ETL Tools Microsoft SSIS, Azure Data Factory,
Domain Expertise Financial Services, Reinsurance, Health & Welfare, Banking
Cloud Services Microsoft Azure (ADF & Databricks),
Educational Qualification B.E in Computer Science from VT University with 50% aggregate score.

(Akshatha S)

Page 2 of 2

You might also like