IT experience with SQL Server database development, extensively worked in OLTP, OLAP, Client-Server & Enterprise Data Warehouse Environments.
Strong experience in Microsoft Business Intelligence Tools including Integration Services and Reporting Services.
Should have knowledge with Snowflake.
Skilled at developing complex Stored Procedures, Functions, Triggers, Views, Cursors, Joins and indexes with T-SQL.
Well versed in Normalization/De-normalization techniques for optimum performance in relational and dimensional database environments.
Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Log Shipping, DTS, Bulk Insert and BCP.
Developed, monitored and deployed SSIS packages.
Extensive knowledge of various data sources like Oracle, Teradata, MS SQL Server, Flat files and excel files.
Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).
Strong experience in Oracle database, worked with versions Oracle 9i, 10g, 11g.
Solid experience in converting legacy MS Access and Crystal Reports to Reporting Services 2008/2008 R2.
Strong experience in creating dashboards using gauges and charts for analysis using SSRS 2008 R2.
Experience in integrating SSRS reports into external applications using report viewer controls and custom URLs.
Hands-on experience in using self Service BI tools such as power view, report builder and BIDS.
Strong experience in performance tuning and query optimization using tools like SQL Server Profiler.
Database Tuning Advisor and Index Tuning Wizard.
Strong experience deploying Power BI solutions across an organization.
Solid experience in version control tools such as Team Foundation Server (TFS) and Sub version (SVN).
Expertise in writing DML and DDL Code, Dynamic SQL as well as Query optimization& performance tuning.