Gouse

 4 years of experience in Microsoft business intelligence Development under SQL Server environment,
with thorough knowledge of SQL Server 2012/2014/2016 databases. Experienced in Financial, Sales,
Health care and banking services.
 Very good experience in creating temporary objects like Temporary tables, Table variable and CTE.
 Experience in creating Tables, Views, Cursors, User Defined Functions (UDF) and Database
Triggers
 Experience in using various DDL and DML Commands.
 Very good experience in creating Indexes to improve the performance of query and Used Sub-Queries
and Joins to simplify complex queries involving multiple tables.
 Very well experience in creating and maintaining database objects like Functions, views, UDF’s.
 Experience in using all kinds of Constraints like Primary Key, Foreign key, Default, Check Constraint
and Unique key.
 Very good knowledge in designing database with proper relationship and schemas.
 Good knowledge in Performance tuning and Query optimization stored procedures.
 Implemented complex business logic into database design and maintained the referential integrity via
triggers and constraints