MSBI Developer Resume

PROFESSIONAL SUMMARY:

Around 3 years of IT experience on MS SQL Server suite of products like SSIS and SSRS.
Good exposoure on ETL Process using SQL Server Integration Services (SSIS), SQL Server Reporting Services(SSRS).
Handling various kinds of data from hetrogenous sources.
Good working knowledge on SQL and T - SQL.
Having good Experience in Designing the Packages with different types of Tasks and Transformations, Securing and Deploying the Packages.
Experience in Integration of various Data Sources like MS Excel, Flat Files, Different Database Sources and Other Sources into the Staging Area.
Good understanding of RDBMS concepts and experience in writing Joins, Sub queries, Views, Stored procedures, Functions .
Creating the reports as per client requirement in the form of table, matrix, Chart and list.
Experience in generating different types of reports like Drill Down, Drill Through, Sub Reports and Parameterized Reports.
Expertise includes Report Builder.

TECHNICAL PROFICIENCY:

BI Tools: MS SSRS, MS SSIS

Databases: MS SQL Server 2008R2

Operating Systems: Windows 7, Windows Server 2000/2003/2008.

PROFESSIONAL EXPERIENCE:

Confidential

MSBI Developer

Environment: SQL Server 2008, SSIS and SSRS

Responsibilities:

Involved in creating Technical specification Documents For Given Requirements.
Implementing Triggers For cash Deposits and cash withdrawals.
Created Branch wise, Month wise Totals using Views.
Created stored procedures and used that in a job to Identify a Inoperative Accounts.
Created Queries for doing Analysis.
Used Linked Servers to get the data from another server.
Created simple and complex reports like Parameterized, chart, matrix, and other types of reports according to the client Requirement.
Created Unit Test cases for Unit testing.

Confidential

Environment: SSRS, SQLSERVER 2005

REPORT DEVELOPER

Responsibilities:

Reports are developed as per the requirements in the form of Matrix, Table and Chart Using SQL Server 2005 Reporting Services.
Different Types of reports are designed like Drill Down, Drill Through, Sub Reports and Parameterized Reports.
Building and generating reports with the help of Report Builder in the Report manager.
Developed Report Models and Ad Hoc Reports using Report Builder.
Generated the Reports Weekly and Monthly basis as per the Client Require.