• Understanding the Client’s business, i.e. Requirement gathering, and creating a Desing document.• End to End Developing the Project Development (Backend/Data Load through ETL and visualization).• Developing the Azure DF pipelines using Python/Pyspark/metadata activity, Data Flow activity and stored procedure activity.• Achieving the business transformation using Mapping Data Flow/Stored Procedure/Pyspark.• Developing the Azure Synapse analytics/ Azure Database/ Stored Procedures in SQL Server 2017. • Developing Pyspark script to move data from Hive metastore to Azure Synapse analytics.• Creating Azure Automation Runbook to execute the Ingestion process.• Designing the overall Data-Warehouse structure, writing complex stored procedures, developing the Azure Data factory components, for the ELT process, developing the tabular model cube, and Power BI reports mainly to be used by the end user.

• Involved in End to End implementation of Retailing project for P&G.• Translating the functional design into technical design.• Understanding the Client’s business, i.e. Requirement gathering, at Onsite designing the dataflow design, designing of HLD document.• End to End Developing the Project Development (Backend/Data Load through ETL and visualization).• Developing the Azure DWH/ Database/ Procedures in SQL Server 2017.• Developing Azure Data Factory pipelines to move data from On-Premise SQL DB to Azure Blob Storage.• Developing the Azure DF pipelines using copy activity, hive activity and stored procedure activity.• Designing the overall Data-Warehouse structure, writing complex stored procedures, developing the Azure Data factory components, for the ELT process, developing the tabular model cube, and Power BI reports mainly to be used by the end user.• Establishing the PySpark connection to process and anlayze the large amount of data in the Azure HD-Insight environment.

Accomplished as a Senior Software Engineer with 2.8 years of experience specializing in Microsoft Azure Data factory, Azure Analysis Service, Power BI and Business Intelligence using MS SQL Server 2008 R2/2012/2016 and SSIS. • Involved in End to End implementation of Branch Merchandising project for Maplin, ensuring, the Right Product at Right Store from the very scratch phase of the project.• Designing the overall Data-Warehouse structure, writing complex stored procedures, developing the Azure Data factory components, for the ELT process, developing the tabular model cube, and Power BI reports mainly to be used by the end user.• Developing the Azure DF pipelines using copy activity, hive activity and stored procedure activity. • Developing the DWH/ Database/ Procedures in SQL Server 2016.Developing ADF pipelines to move data from On-Premise SQL DB to Azure Blob Storage.• Creating an Event Hub to receive the data from Google Analytics and move data to Azure SQL DWH using Azure Stream analytics service.

• Involved in Product migration (data and processes) from Oracle 11g to SQL Server 2008.• Involved in XML extraction from Pega to SQL Server 2008 R2.• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2008.• Involved in extracting the data from XML through T-SQL for the Aegis product.• Developing T-SQL queries, triggers, functions, cursors and stored procedures.• Alter the schema for the required objects.• Created automated stored procedures for day end operations using SQL Server agent.• Used SQL Server Integration Services (SSIS) to load the data into staging tables for Quality check.• Involved in various transformation to load the data into the various OLDB Destination.• Assisted developers in tuning Stored Procedures, Triggers and Functions over performance issues.