SQL/SSIS/SSRS Developer Resume Nebraska - Hire IT People

SUMMARY:

Strong hands - on experience in developing Business Intelligence solutions with the Microsoft Business Intelligence stack.
Extensive experience in Information Technology with special emphasis on design & development of Database/Data Warehousing/Client-Server/e-commerce applications.
Proficient in ETL (Extract - Transform - Load) using SQL Server Integration Services (SSIS) .
Hands-on experience in design and development of ETL solutions for data warehouses and data marts, using different architecture, design techniques.
Hands-on experience on SQL Server Reporting Services to design Reports.
Experience in analysis, design and construction of Data warehouses and Data marts.
Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
Hands-on experience in Performance tuning, Query Optimization and Indexing of database using SQL Profiler and Query Analyzer.
Ability to code and implement complex business rules in T- SQL using Functions, Triggers and Stored Procedures.

TECHNICAL SKILLS:

Data warehousing/ ETL Skills: SQL Server Integration Services (SSIS) 2005/ 2008

BI Reporting Tools: SQL Server Reporting Services (SSRS) 2005/ 2008

Programming Languages/ GUI: SQL, PL/SQL, T-SQL, Visual Studio

ETL Sources/ Databases: DB2/ SQL Server

PROFESSIONAL EXPERIENCE:

Confidential, Nebraska

SQL/SSIS/SSRS Developer

Responsibilities:

Profiled data from the source, and transformed the data to meet the user’s requirement.
Worked on complete Migration of data from one system to another.
Designed SSIS Packages using several transformations to perform Data Migration
Analyzed the data to implement incremental load.
Extensively worked on Stored Procedures, Cursors, and Functions in T-SQL.
Worked with SQL Server Profiler to analyze the query performance and improve it.
Worked and setup the Sql Server Performance Studio to monitor Queries and database.
Used FOR XML to generate an XML document from the result of a SQL Server relational query.
Used Tabular and Matrix Reports Layout to design reports, based on the requirement.

Environment: O/S: Windows 2003 Server