SQL Server Analysis Services (SSAS)
Extensive hands-on experience on designing, building and optimizing large scale SSAS databases
Strong relational/dimensional data modelling skills
Strong multi-dimensional expression (MDX) language skills.
Worked on at-least 2 Data Warehousing projects.
SQL Server Integration Services (SSIS)
Proficient in implementing all transformations available on the SSIS toolbox.
Excellent knowledge of using variables and expressions in packages.
Experienced in creating master and child packages, package configurations and logging.
Experienced in SSIS package Auditing.
Experienced in SSIS package deployment and Scheduling
Working experience on Master Data Serveries (MDS) and Data Quality Services (DQS)
SQL Server Reporting Services (SSRS)
Experience of creation and implementation of canned reports in SSRS.
Experience of creating Scorecards, chart reports and Dashboards.
Excellent hands on experience on scheduling and the deployment of the reports and uploading files to a report server catalogue from the report manger.
Experience of delivering SQL server reports to SharePoint.
Excellent command on subscriptions, report snapshot and report cache.
Experience of configuring report server and report manager scheduling, giving permissions to different level of users in SQL Server Reporting Services (SSRS).
Expert in designing and implementing relational database and Dimensional model as per business needs.
In-depth knowledge of Transact-SQL (DDL, DML)- creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
Experience in Performance Tuning and Query Optimization
Experience on tools like SQL Profiler, Index Tuning Wizard and database Engine tuning wizard
Experience in Microsoft SQL Server Database backup & recovery strategies, server logins, database permissions, creating Jobs and schedule DTS/SSIS Packages.