SUMMARY Over 11+ years of extensive work experience as a SQL Server Developer and in-depth proficient experience in Microsoft Business Intelligence stack, OLTP, Operational Data Source (ODS), Tabular & Multidimensional Modelling, Performance Tuning, Data warehouse, OLAP and Database technologies. Demonstrated expertise in designing, developing, and deploying Business Intelligence solutions using SSIS and SQL. Experience in installation, upgrade, and configuration of Microsoft SQL Server databases. Over 7+ years of extensive experience in T-SQL Programming in developing Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables, common table expressions (CTEs) XML and Complex Queries on SQL Server 2012/2014/2016/2017. Broad experience in Query Optimization and performance tuning of TSQL stored procedures, functions, SSIS packages. Over 6+ years’ experience in utilizing ETL tools, including SSIS, DTS and ETL Package design. Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages through scheduler such as Autosys and SQL Server Agent. Experience in development of coding in VB.NET, C# while working with SSIS. Interaction with the Users and Business Analysts for better understanding of business & reporting requirements.   HIGHLIGHTS  A Microsoft Certified Professional with around 12+ years of total IT experience in the Design, Modeling, Development, Implementation and Support of SQL Server 2012/14/16/17  Expert in analyzing, designing, developing, installing, configuring, and deploying MS SQL Server suite of products with Business Intelligence in SQL Server and Integration Services.  Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.  Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries, and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views, and Cursors.  Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.  Supported team in resolving SQL Integration services and T-SQL related issues and Proficiency.  Experience in importing/exporting data between different sources like Oracle/Access/Excel/CSV/txt etc. using SSIS/DTS utility.  Experience in Microsoft Visual C# and VB in script component of SSIS.