Highly experienced in all aspects of software development life cycle such as requirement analysis, design, development, testing, implementation, deployment and maintenance of projects. Over 10 years of database development experience with Microsoft SQL Server 2005/2008/2008R2/2012/2014/2016/2017/2019 in OLTP and OLAP environments. Expertise in Microsoft BI Stack: SSIS, SSRS, SSAS, Azure, Power BI and PowerShell. Expertise in Database Administration on dev/prod servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities. Broad Experience in Database Development including effective use of database objects, SQL Trace, Data Profiling, Execution Plan, Different types of Optimizers, Hints, Indexes, Table Partitions, Sub Partitions, Materialized Views, Global Temporary tables, BCP, Bulk Binds, Dynamic SQL, SQL Agent and CLR functions Highly experienced with ETL processes, and data warehousing including multi-dimensional modelling, full/incremental loads, and SCD. Excellent knowledge in RDBMS concepts and constructs along with database objects creation such as tables, user defined data types, indexes, stored procedures, views, user defined functions, cursors, CTEs and triggers using T-SQL. Expert in creating complex ADF, SSIS, DTS packages for ETL purposes like Data Migration, Data Conversions, Data Extraction/Transformation/Loading, Data Validation and Data Manipulation using custom scripts like VB, C# and PowerShell. Experience working with different file formats like XML, CSV, EXCEL and other raw files. Knowledgeable in designing XML documents using DTD, XML Schemas, XSLT and XPath queries for its integration in database. Extensive experience working with SOAP and REST APIs. Experience in Azure SQL, Azure Data Lake, Azure Data Warehouse, Azure Data Factory and Azure Blob Storage. Experience in Azure Blob storage and azure pipelines Experience in developing Power BI Reports and Dashboards from multiple data sources using data blending. High-skilled in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS 2016/2014/2012/2008 R2/2008. Team player with good leadership skills. Ability to communicate well with all levels of corporate personnel.