SUMMARY:

• 5+ year’s total experiences.
• Having 4+ years of IT experience in Development and maintenance of Data warehousing and Client Server applications using SQL Server Integration Services (SSIS), SQL Reporting Services (SSRS), SQL Server analytic service (SSAS) and SQL Server
• Experience in SQL (Index, View, transaction), T - SQL (Stored Procedures, Function,Trigger,Cursor )
• Strong experiences in SQL, T SQL in SQLSERVER 2008R2
• Good Understanding of SQL Server Indexes, Data Partitioning Techniques
• Good at writing complex stored procedures
• Strong experience in Extraction, Transformation and Loading (ETL) in SQL Server database.
• Experiences in control flow and data flow in SSIS
• Experiences in various type of tasks in control flow in SSIS
• Data Transfers, Migrations from Excel/ CSV files/Text files to Database
• Good Experience in Implementing Checkpoint, Transactions in SSIS
• Experience in creating Reports, Jobs, Alerts and Scheduled SSIS Packages.
• Experiences in tablix report, tabular report, and link report
• Supported team in resolving SQL Reporting service and ETL related issues.
• Expert in preparing all types of reports using SSRS.
• Strong Experience in Creating Different Reports like Drill through Dashboard Reports, Drill down Report, Matrix Reports, Sub Reports, Ad hoc Reports, Tabular Reports, and Chart Reports.
• Using xml to generate a report in SSRS
• Experience in SSAS Cube Analysis using MS-Excel.
• Experience in SQL Server Analysis Services (SSAS) OLAP Cubes Implemented Snow Flakes Schema and Star Schema
• Proficient in building Cubes in SSAS defining Referenced Relationships and creating Hierarchies key in SSAS
• Experiences In mdx queries in SSAS
• Experiences in KPI, partition in SSAS

IT SKILLS:

IDE: Visual Studio .NET 2005, 2008

BI Data Warehouse Tool: SSIS, SSRS, SSAS

Databases: MS SQL Server 2008, 2005, MS Access,excel

Languages: T-SQL,C#, VB.Net

Reporting/ETL: SSRS, SSIS

Platforms/OS: Windows XP, Windows7,sever 2003

MSC: IT from SM UNIVERSITY with 73% in 2007

PROFESSIONAL EXPERIENCE:

Confidential

MSBI TOOLS: SSIS, SSRS, SSAS

Database: SQLSERVER 2008R2

Responsibilities:

• Indexes, views, transaction, stored procedures, Function, triggers, Cursor are used in the SQL Server.
• Using in control flow and data flow in SSIS
• Using in various type of tasks in control flow in SSIS
• Using Extraction, Transformation and Loading (ETL) in SSIS
• Using Data Transfers Migrations from Excel/ CSV files/Text files to Database in SSIS
• Created ETL packages using SSIS to move data from various heterogeneous data sources.
• Migrating Data Transformation Services in Packages
• Development of reports using different SSRS Functionalities like sort prompts and cascading parameters, Multi Value Parameters.
• As per requirements developed the reports in the form of Matrix, Table using SQL Server Reporting Services(SSRS)
• Designed Different Types of reports like Drill Down, Drill Through, Sub Reports and Parameterized Reports in SSRS
• Scheduled Reports Weekly and Monthly Basic as per the Client Requirements in ssrs
• Using in dashboard operation and how to generate report in SSRS
• Using in tablix report, tabular report, and link report IN SSRS
• Experiences in creating cubes in SSAS
• Creating cube and Adding a User Hierarchy key in SSAS
• Mdx query also used in SSAS
• Using in SSAS Cube Analysis using MS-Excel.

Confidential

MSBI TOOLS: SSIS, SSRS, SSAS

Database: SQLSERVER 2008R2

Responsibilities:

• Indexes, views, transaction, stored procedures, Function, triggers, Cursor are used in the SQL Server
• Development of reports using different SSRS Functionalities like sort prompts and cascading parameters, Multi Value Parameters.
• Using in Creating Different Reports like Drill through Dashboard Reports, Drill down Report, Matrix Reports, Sub Reports, Ad hoc Reports, Tabular Reports, and Chart Reports in SSRS.
• Using in tablix report, tabular report, and link report in SSRS
• Using matrix report in ssrs
• Using in SSAS Cube Analysis using MS-Excel.
• Using in Sql server Analysis Services(SSAS) OLAP Cubes implemented Snow Flake Schema and Star Schema
• Creating Cubes in SSAS
• Creating Hierarchies key in SSAS
• Using MDX Queries in SSAS
• Using in control flow and data flow in SSIS
• Using in various type of tasks in control flow in SSIS
• Using Extraction, Transformation and Loading (ETL) in SSIS
• Using Data Transfers Migrations from Excel/ CSV files/Text files to Database in SSIS
• Using Checkpoint, Transactions in SSIS
• Created ETL packages using SSIS to move data from various heterogeneous data sources.
• Migrating Data Transformation Services in Packages
• Deployment the Package in SSIS

Confidential

BI Developer

MSBI TOOLS: SSIS, SSRS, SSAS

Database: SQLSERVER 2008R2

Responsibilities:

• Indexes, views, transaction, stored procedures, Function, triggers, Cursor are used in the SQL Server
• Migrating Data Transformation Services in Packages in SSIS
• Created ETL Package using SSIS to move data from various heterogeneous data sources.
• Used Control Flow Tasks like For Loop, For Each Loop Container, and sequence container and Execute SQL Task and Data Flow Task in SSIS
• Used transformations like Derived Column, Look up, Merge Join, Multicast and Sort to load data into SQL Server Database in SSIS
• Deployment of package in SSIS
• Using in Creating Different Reports like Drill through Dashboard Reports, Drill down Report, Matrix Reports, Sub Reports, Ad hoc Reports, Tabular Reports, and Chart Reports in SSRS.
• Using in tablix report, tabular report, and link report in SSRS

Confidential

MSBI tools: SSIS,SSAS, SSRS

Database: SQL SERVER 2008

Responsibilities:

• Indexes, views, transaction, stored procedures, Function, triggers, Cursor are used in the SQL Server
• Report Creation and usage in SSRS.
• Using in Creating Different Reports like Drill through Dashboard Reports, Drill down Report, Matrix Reports, Sub Reports, Ad hoc Reports, Tabular Reports, and Chart Reports in SSRS
• Experiences in tablix report, tabular report, and link report in SSRS
• Scheduled Reports Weekly and Monthly Basic as per the Client Requirements
• Migrating Data Transformation Services in Packages in SSIS
• Created ETL Package using SSIS to move data from various heterogeneous data sources.
• Used Control Flow Tasks like For Loop, For Each Loop Container, and sequence container and Execute SQL Task and Data Flow Task in SSIS
• Used transformations like Derived Column, Look up, Merge Join, Multicast and Sort to load data into SQL Server Database in SSIS
• Deployment of package in SSIS
• Using in SSAS Cube Analysis using MS-Excel.
• Using in Sql server Analysis Services(SSAS) OLAP Cubes implemented Snow Flake Schema and Star Schema
• Creating Cubes in SSAS
• Creating Hierarchies key in SSAS
• Using MDX Queries in SSAS
• Involves in Database Administrations, Performance, Back up/ Recovery and Maintenance jobs