Expertise in designing and implementing enterprise scale database (OLTP) and Data warehouse solutions.
Hands on experience in implementing Azure SQL Database, Azure SQL Date warehouse (Azure Synapse Analytics) and big data processing using Azure Databricks and Azure HD Insight.
Expert in writing T-SQL programming for complex stored procedures, functions, views and query optimization.
Should be aware of Database development for both on-premise and SAAS Applications using SQL Server and PostgreSQL.
Experience in ETL and ELT implementations using Azure Data Factory V2 and SSIS.
Experience and expertise in building machine learning models using Logistic and linear regression, Decision tree and Random forest Algorithms.
PolyBase queries for exporting and importing data into Azure Data Lake.
Building data models both tabular and multidimensional using SQL Server data tools.
Writing data preparation, cleaning and processing steps using Python, SCALA, and R.
Programming experience using python libraries NumPy, Pandas and Matplotlib.
Implementing NOSQL databases and writing queries using cypher.
Designing end user visualizations using Power BI, QlikView and Tableau.
Experience working with all versions of SQL Server 2005/2008/2008R2/2012/2014/2016/2017/2019
Experience using the expression languages MDX and DAX.
Experience in migrating on-premise SQL server database to Microsoft Azure.
Hands on experience in using Azure blob storage, Azure Data Lake Storage Gen1 and Azure Data Lake Storage Gen2.
Performance tuning complex SQL queries, hands on experience using SQL Extended events.
Data modeling using Power BI for Adhoc reporting.
Raw data load automation using T-SQL and SSIS
Expert in migrating existing on-premise database to SQL Azure.
Experience in using U-SQL for Azure Data Lake Analytics.
Hands on experience in generating SSRS reports using MDX.
Experience in designing predictive models using Python and SQL Server.
Developing machine learning models using Azure Databricks and SQL Server
