Professional Summary
- 3 Years of experience in IT with primary skills on the Analysis, Design, Development and Support of Client/Server application using Microsoft SQL Server 2016, 2014, 2012 and BI suite. - Very good experience in developing Business Intelligence Solutions in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and exposer to SQL Server Analysis Service. - Experienced in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL) solutions using SQL Server Integration Service (SSIS). - Good knowledge in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities. - Good knowledge of writing, modifying, and implementing Tables, Stored Procedures, Functions, Views, Indexes, Triggers, Cursors, Joins & User Defined data types. - Very good in creating different types of SSRS reports such as Crosstab, Conditional, Drill-down, Drill-Up, Drill-through, Top N, Summary, Form, Lists, Sub reports, Matrix Reports and formatting them. - Very good in writing MDX queries with extensive experience in creating and customizing Cubes using SQL Server Analysis Services SSAS 2012/2014/2016. - Good in migration of Data from Excel, Flat file, Oracle to MS SQL Server using MS SQL Server DTS and SSIS. - Good familiarity in Logical Data Modeling, Data warehouse design concepts, Dimensional Modeling using Star/ Snowflake Schemas, Normalized and De-normalized Schemas with respect to query and analysis requirements. - Excellent Communication and interpersonal skills with strong ability.