Description
Qualification Summary * Expert in T-SQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches. * Expert in creating various types of reports such as complex tabula reports, matrix reports, bubble chart reports, polar chart reports, bar chart reports, gauge reports, etc. using SSRS. * Extensive experience in SQL Development, ETL development using SQL Server 2008 R2, SQL Server 2012, Microsoft SQL Server Integration Services (SSIS), and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS). * Strong experience in Data Modeling and Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers. * Expert in developing complex T-SQL stored procedures to feed the data and parameters for presenting SSRS reports. * Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), T-SQL stored procedures, Bulk Insert, and BCP. * Experience in design and development of SSIS packages and using various control flow task and data flow transformation from various heterogeneous data sources such as Excel, CSV, flat files. * Proficient in Tuning T-SQL queries to improve the database performance and availability. * Experienced hands in Query tuning and performance tuning. * Experience in monitoring SQL Server Performance using SQL Profiler, Extended Event and Windows Performance Monitor. * Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance. * Experience in upgrading and Migration of SQL Server 2008R2 to SQL Server 2012 * Involved in all the phases of Software development life cycle, especially recent years with Agile Scrum methodology. * Highly Proficient and efficient with the Visual Studio 2015 Team Foundation Sever Tool (TFS) * Comfortable in both independent and collaborative work environments.
Accomplishments
Highlights:
Keywords
