Experience with scripting in T-SQL, constructing tables, joins user functions, views, indexes and user profiles. Proficient in creating Index, Views, Complex Stored Procedures, appropriate functions, and effective Triggers to facilitate efficient data manipulation and data consistency in MS SQL Server SQL 2005/2008/2008R2/2012. Implemented cursors for rebuilding indexes.?Expert in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS). Expertise in ETL (Extracting, Transforming and Loading) development using DTS and SSIS for migration of data between legacy systems to SQL Server. Proficient in merging data from various data sources using SSIS.? Good Knowledge in design and implementation processes for deploying, upgrading, managing, archiving and extracting data for reporting using SQL Reporting Services (SSRS). Strong ability in defining query for generating drill through, drill down reports, canned and cache reports with drop down menu option, sorting the data, defining subtotals and handling parameterized reports and creating report layouts using SSRS.
Involved in optimizing?code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.? Strong individual with Technical, organizational, analytical and design skills.
Reviews For This Service