12+ years of professional experience in IT, as MS SQL Server 2016/2012/2008/2005/2000 Database Developer having strong skills in T-Sql, ETL process, SSIS, SSRS, C#.Net, Oops concepts.
Expert in designing and implementing Database using various RDMS like SQL SERVER, Oracle and MS Access.
Extensive knowledge and experience in developing scripts using T-SQL for querying against databases
Expertise in implementing business logic using Triggers, Views and Stored Procedures and User defined functions.
Expertise in writing T-SQL Queries using Joins, Sub queries, CTE, Window function.
In-depth knowledge in Tuning SQL Queries and improving query performance.
Experienced with extract data from one or more sources like databases, file systems, Excel.
Experienced with SSIS performance tuning on Control flow, Data flow, Error handling, and Event handler, re-running of failed SSIS packages,
Experienced on Managing SSIS packages with SQL server management studio, create SQL server agent jobs, configure jobs, configure data sources and schedule packages through SQL server agent jobs.
Hands on experienced in Deploying, Build, and SSIS Packages/Project, Securing SSIS packages, Managing and Browsing SSIS packages.
Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.
Developed C#.NET scripts for SSIS packages.
Experience in creating Jobs, Alerts, SQL Mail Agent, and Scheduling DTS and SSIS Packages.