2. sql server business intelligence development studio 2008

A skilled problem-solver and an efficient Team player, collaborative and self-starter, excellent oral and written skills.

Strong individual with Technical, organizational, analytical and design skills.

Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.

Produced complex table calculations, use of parameters, actions, filters and other advanced options in Tableau.

Implemented a well-planned backup and restore strategy for databases against data loss due to damage caused by a variety of failures.

Good knowledge of defining, developing and deploying Star Schema, Snow flake Schema and Dimensional Data modeling using MS SQL Server Analysis Services (SSAS).

Experience in creating Multidimensional cubes using SSAS.

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 2005/2008 R2/2012.

Good Knowledge in design and implementation processes for deploying, upgrading, managing, archiving and extracting data for reporting using SQL Reporting Services (SSRS).

Developed Tableau visualizations to support ad-hoc analyses.

Proficient in merging data from various data sources using SSIS.

Expertise in ETL (Extracting, Transforming and Loading) development using DTS and SSIS for migration of data between legacy systems to SQL Server 2000/ 2005/2008.

Expert in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS) and MS SQL Server Analysis Services (SSAS) of MS SQL server 2005/2008/2012.

Implemented cursors for rebuilding indexes.

Experience working on Normalized Databases and designed database/tables and the requisite relationships, designed partition tables and partition views.

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 2012/2008 R2/2005/2000.Experience with scripting in T - SQL, constructing tables, joins, user functions, views, indexes and user profiles.Around 8 years of IT experience as SQL developer in design and development of various applications for Financial, Banking and Manufacturing Industries.

2. sql server business intelligence development studio 2008