Summary
Overview
Work History
Education
Skills
Timeline
Generic

Sasi Alapati

Ajax,ON

Summary

Results-oriented IT professional with over 4 years of industry experience, specializing in Microsoft Azure Cloud technologies. Demonstrated expertise as a Azure Data Engineer with 3 years of experience as an Azure Administrator. Proficient in Azure Data Factory (ADF), Azure Data Lake Store (ADLS), Azure SQL Data Warehouse, and Azure Databricks.

Key Skills:

  • Experienced in building and optimizing data pipelines using Azure Data Factory components such as Integration Runtime, Linked Services, Data Sets, Pipelines, and Activities.
  • Proficient in Azure Synapse Analytics, Azure Databricks (ADB) Spark-Python, and Azure Stream Analytics.
  • Hands-on experience with various ADF activities including Get Metadata, Lookup, For Each, Wait, Execute Pipeline, Set Variable, Filter, and until.
  • Implemented dynamic pipelines to extract multiple files into multiple targets using a single pipeline, enhancing automation and efficiency.
  • Automated ADF pipeline execution using triggers, ensuring timely and accurate data processing.
  • Designed and developed data ingestion pipelines from on-premises sources to Azure Data Lake Storage using ADF V2.
  • Utilized Logic App Service for email notifications on pipeline success and failure.

Overview

7
7
years of professional experience

Work History

Data Engineer

IBM
11.2021 - Current
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • .Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
  • Responsible for planning and handling day – to – day scrum calls, team activities, retrospection, resources, and productivity.
  • Migrating from source Data base (SQL, dB2, Teradata, Oracle) to Snowflake using ADF pipeline
  • Created one automated pipeline for both full and incremental data loads.
  • Automated the pipeline in multiple tables using control table to run pipelines.
  • Created Email notification to send alters to required teams.
  • Created log table and maintaining end-to-end table details through one entry.
  • Received files from BODS and stored them into Blob storage for archive purpose for using Azure data factory.
  • Responsible for creating different tables on multiple tables in hive database using DB Visualizer.
  • Created pipelines for loading BODS files data into hive tables by using Azure data factory.
  • Responsible for loading incremental data for sales, Purchase and Customer master data into hive database.
  • Responsible for Creating DDL’s in hive database to load BODS data.
  • Responsible for Migrating DDL’s, HQL’s and pipelines from DEV to QA and PROD
  • Identifying duplicate data in BODS files by using UNIX hdfs commands.
  • Responsible for Creating pipelines, datasets, linked services and event-based triggers.
  • Responsible for automating jobs to run on daily basis in Azure data factory studio.
  • Load data from stage to Compact by using merge statement.
  • Validating data from Source and Target (stage and compact layers).
  • Monitoring pipelines and any issues occurring, then analyze data and fix issue.
  • Generate and validate BCBS outbound files and validate Header and filename and records counts.

Azure Administrator

Nihilent Technologies
08.2017 - 11.2019
  • Handled sensitive information discreetly, maintaining strict confidentiality at all times as required by company policy or legal regulations.
  • Maintained personnel records and updated internal databases to support document management.
  • Responsible for documenting all analysis, coding and testing performed related to User Stories and maintaining VSO hygiene on daily basis.
  • Gathering requirements from client managers and implementing them as tasks as per requirements.
  • Worked on architecture improvement and changes on existing system by modifying multiple database model to single database architecture by significantly bringing down expenditures.
  • Building pipelines to copy data from source to destination in Azure Data Factory.
  • Worked on creating dependencies of activities in Azure Data factory.
  • Monitoring Produced and Consumed Data Sets of ADF.
  • Creating Data Factories in Azure Data factory.
  • Moving data from on premises DB to Azure SQL DB with help of Confidential Flows.
  • Created automated workflows with help of triggers.
  • Moving data between Excel and Servers using Flows.
  • Migrating data from different sources to destination with help of ADF.
  • Migrating data from different sources to destination with help of ADF
  • Transforming data in Azure Data Factory with ADF Transformations.
  • Scheduling Pipelines and monitoring data movement from source to destinations
  • Transforming data in Azure Data Factory with ADF Transformations
  • Creating Multiple Data Sets in Azure worked in migration of SQL Server 2008/2012/2014 to SQL Server 2017.
  • Used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
  • Trouble shoot any kind of data issues or validation issues.
  • Provide support of production applications by trouble-shooting issues, and developing, testing and migration of Data Bases.
  • Moving CSV files from Azure blob to Azure SQL Server.

Education

Post Graduation - Mobile Application Development

Canadore College
North Bay, ON
10.2020

Bachelor of Technology - Computer Science and Engineering

SRM University
Chennai, India
05.2016

Skills

  • Programming: Structured Query Language (SQL), PL\SQL, C
  • Operating Systems: Windows 8, Windows 10, Windows 2008/2012
  • ETL Tools: Azure Data Factory
  • Database: Azure SQL, Spark SQL and Hive
  • Cloud Technologies: Azure Data Lake storage, Azure Data Bricks, Azure Administration, Azure synapse, Azure stream analytics and Azure Data Factory

Timeline

Data Engineer

IBM
11.2021 - Current

Azure Administrator

Nihilent Technologies
08.2017 - 11.2019

Post Graduation - Mobile Application Development

Canadore College

Bachelor of Technology - Computer Science and Engineering

SRM University

Similar Profiles

CREATE PROFILE
Sasi Alapati