Currently working as Lead engineer in developing ETL Pipelines using Azure Data Factory, have been deloping multiple data pipelines comprising different data sources for example Oracle, SQL Servers, Sharepoint List, API's. Designing the data pipelines in a way so that they can produce reuseability, and also giving multiple options that involves activiating a particular table for data load, setting up flag for full/incremental load on the basis of Business Needs, Giving option to load for a particular site level. Have been using Data lake, Azure SQL Database, Azure Databricks, Azure Synapse Analytics as intermediate layer for data storage and end products involving Facts and Dimensions that can be further consumed by Azure Analaysis Services. Worked on writing SQL Logic that involves pipeline re-run process so that pipeline can be re-run from the same watermark point as it was failed to avoid data loss. Also worked on Logic App to ingest the data from SQL Database into Sharepoint List on the basis of Row Active flag.

Leading multiple projects in parallel for US Based customers with the team of 5-6 Engineers. Solving customer problems/Issues with the project on a daily basis on call. Leading technical presales calls with guiding customers with the proper solution and also giving the cost of the Azure Resources they will consume. Giving Recommendations to customers as per cost, peroformance and security on the Azure Infrastructure they are currently using. Developing envioments for the customers as per there requirments on Azure. Worked on configuring FTP servers in Linux machines. Building POC Solution for a customer to Migrate 700 Databases in one go. Migrating Azure SQL Server 2008 R2 to Azure Managed Instance. Building Sync Mechanism to move data across AWS Redshift and SQL On-premise Machine to Azure Datawarehouse and building data models and using them with PBI Reports. Migrating On Premises SQL Server to Azure Synapse Analytics. Perofrmed POC to Migrate tableau reports to Power BI Reports. Migrating Amazon Redshift to Azure Data warehouse Building Power BI Reports using multiple data sources SAP BW, S4 HANA, Spreadsheets, SQL.