Sql Server Master Program Trainee
Current• Created numerous simple to complex queries involving self joins, correlated subqueries and XML techniques for diverse business requirements. Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies.• As part of a team, analyzed the business requirements and systematically designed a database for an online-movie (DVD/Blu- Ray) rental company. Employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers, and implemented the importation and exportation of data using XML and SSIS. • As part of a team, created various reports according to the business requirements for the movie rental company. Individually authored, installed, deployed and managed reports using SQL Server 2008 Reporting Services for a library database. •Individually designed a bank application according to business requirements, and implemented robust stored procedures, functions, and triggers to implement required functionalities.