Identity• A Microsoft Certified Professional with around 7.5 + years of total work experience in which 5.5+ years of IT experience in the Design , Modeling, Development, Implementation and Support of SQL Server 2005/2008/2012.
• Expert in analyzing, designing, developing, installing, configuring and deploying MS SQL Server suite of products with Business Intelligence in SQL Server Reporting Services, SQL Server Analysis Services of and SQL Server Integration Services.
• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions and Views.
• Expertise in creating control flow, dataflow, containers and other objects in SSIS packages.
• Skilled in error and event handling using precedence Constraints, Break Points, Check points and Logging.
• Skilled in incremental loading approach like CDC, SCD and Change Tracking.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Defining data warehouse (star and snow flake schema), fact table, cubes, dimensions, measures using SQL Server Analysis Services.
• Expertise in Creating Star Schema and Snow Flake Schemas.
• Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes.
• Expert in writing MDX queries.
• Expertise in using global variables, expressions and functions for the reports with immense experience in handling sub reports in SSRS.
