About Me

A rewarding opportunity in a growth-oriented company, this gives me scope to apply my knowledge and become an active member of a team to work. I am seeking responsible position as to use my diverse skills, experience. 2 years of experience in Microso...eking responsible position as to use my diverse skills, experience. 2 years of experience in Microsoft SQL Server Development. Used System Functions (String Functions and Convert Functions and Rank functions and Date functions) in complex Queries in order to meet Requirements. Developed SQL Joins for Retrieving data from multiple tables. Developed Set operators for combining data from multiple select queries into a single one. Extensive experience with SQL Server and T-SQL in constructing Procedures, Table variables, User Defined Functions, Views, Indexes, CTE, Temp Tables , Cursors with proper naming convention. Used Recursive CTE Instead of while loop for generating dates. Worked on Dynamic SQL (sp_executesql, exec). Used Error Handling (Try -catch) inside stored procedure to find an errors. Used Transactions (Begintran, commit and rollback) inside stored procedures. Written DML Triggers (For insert, for update, for delete and Instead of Triggers) for Audit purpose. Good knowledge on performance tuning and procedure performance. Knowledge on database designing concepts (Normalization-1nf,2nf,3nf) Hands on experience on Sql server import export wizard for loading files from multiple source systems (excel files,flat files ) into sql server. Knowledge on datawarehouse concepts Slowly changing dimensions. Installing all versions of SQL Server (SQL server 2008/2012).