Total of 6.8 Years of Technical Experience on Azure. Currently, Working in L&T Infotech Mindtree as a Senior Data Engineer, Majorly involved in ADF Data Pipeline Development and Monitoring, Developing SQL Procedures as per business requirements, debugging issues related to data validations at different data layers.
Time Management Skills Team Player Analysis Organizational Growth Infrastructure Implementation Data Factory Azure Analysis Service SQL Server Management Studio Azure Synapse Analytics Azure SQL Databases Azure Data Lake Storage Gen2 Azure Devops Power BI Azure Virtual Machine Azure Infra Microsoft Office Multitasking Skills Good Communication Skill
December 2021 - Present
Currently working as Lead engineer in developing ETL Pipelines using Azure Data Factory, have been developing 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 reusability, and also giving multiple options that involve activating 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 Analysis 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.
June 2017 - December 2021
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, performance and security on the Azure Infrastructure they are currently using. Developing environments for the customers as per their requirements 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 Data warehouse and building data models and using them with PBI Reports. Migrating On Premises SQL Server to Azure Synapse Analytics. Performed 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.
2011 - 2015
English — Fluent Hindi — Native or Bilingual
Total of 6.8 Years of Technical Experience on Azure. Currently, Working in L&T Infotech Mindtree as a Senior Data Engineer, Majorly involved in ADF Data Pipeline Development and Monitoring, Developing SQL Procedures as per business requirements, debugging issues related to data validations at different data layers.
Time Management Skills Team Player Analysis Organizational Growth Infrastructure Implementation Data Factory Azure Analysis Service SQL Server Management Studio Azure Synapse Analytics Azure SQL Databases Azure Data Lake Storage Gen2 Azure Devops Power BI Azure Virtual Machine Azure Infra Microsoft Office Multitasking Skills Good Communication Skill
December 2021 - Present
Currently working as Lead engineer in developing ETL Pipelines using Azure Data Factory, have been developing 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 reusability, and also giving multiple options that involve activating 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 Analysis 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.
June 2017 - December 2021
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, performance and security on the Azure Infrastructure they are currently using. Developing environments for the customers as per their requirements 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 Data warehouse and building data models and using them with PBI Reports. Migrating On Premises SQL Server to Azure Synapse Analytics. Performed 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.
2011 - 2015
English — Fluent Hindi — Native or Bilingual