15 + years of total IT experience in the Design, Modeling, Development, Implementation and Support of SQL Server 2005/2008/2008 R2/2012/2017.
Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.
Extensive knowledge of Normalization and Relational Database Management Systems.
Hands on experience on various SQL Server Services like Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2017/2012/2008r2/2005/2000.
Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
Experience in Performance Tuning and Query Optimization.
Experienced in using ETL tools in (SSIS) MS SQL 2017,MS SQL 2012 and DTS in MS SQL 2000
Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
Data Loading Experience in SQL Server 2008 using SSIS ETL and Experience in developing packages in SSIS and DTS according to task.
Data analysis and data migration by transferring them using SSIS packages.
Experience with logical and physical data modeling and database design using Erwin.
Experience in Designing and Building the Dimensions and cubes with sta