PROFESSIONAL SUMMARY:

• Over 7 Years of IT experience as a ETL Developer using MS SQL Server 2012/2008R 2/2008/2005/2000 in OLAP/OLTP environments.
• Extensive experience in implementing SSIS, SSRS, SSAS using Microsoft Business Intelligence development studio (MSBI) using Visual studio 2010/2008/2005 ..
• Expertise in writing T - SQL queries using Joins, Sub queries, Stored Procedures, Triggers etc in MS SQL Server 2008/2005.
• Expertise in writing DML DDL and Transaction queries in T-SQL for MS SQL Server database.
• Experience in designing, creating, testing and modifying User-defined Functions and Stored Procedures.
• Extensive experience in creating and designing SSIS Packages for Integration and Migration of data from XML, Excel, DB2, Sybase, Flat file, Oracle to MS SQL Server using BCP and DTS utility and extracting, transforming and loading of data using SSIS.
• Implemented various Control flow and Dataflow elements of the SSIS Package.
• Experience in creating XML data files using SSIS Script task (VB.NET, C#.NET).
• Experience in developing, deploying and managing various reports like ad-hoc reports, Crystal Reports, simple and parameterized reports using SQL Server Reporting services (SSRS).
• Hands on experience in creating Parameterized reports and Linked reports with thorough knowledge of report service architecture. (Table, chart and matrix report).
• Proficient in writing Queries for generating Drilldown reports and designing report layout from XML, SQL Server, and MS excel as data sources using MS SQL Server Reporting Services (SSRS).
• Knowledge in SSAS and different schemas like Star Schema and Snow Flake Schema and also Data
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, and Logging using SSIS.
• Involved in Cube development and deployment in SSAS (SQL Server Analysis Services).
• Experience in designing conceptual, logical and physical database models using Erwin.
• Extensive experience with Database Backups, Recovery Procedures, Backup strategies and scheduling.
• Worked on Performance Tuning, Query Optimization, Client/Server Connectivity, and running Database Consistency Checks using DBCC Utilities.
• Strong analytical and problem-solving skills coupled with excellent written, verbal and inter-personnel communication skills.

TECHNICAL SKILLS:

Databases: MS: SQL Server 2012/2008R 2/2008/2005/2000 , Oracle 11g/10g/9i Microsoft Access, SharePoint 2010/2007, Oracle SQL Server 9i/10g/11g.

Programming Languages: T: SQL, PL/SQL, HTML, DHTML, XML, VB.NET, C#.Net.

IDE Tools: Visual Studio .Net 2010/2008/2005

Framework: Microsoft .Net Framework 4.0/3.5/3.0

Data Modeling: Erwin, MS Visio 2010.2007/2005.

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Services (DTS)

Reporting Tools: SQL Server Reporting Services (SSRS) 2008R2\2008\2005, Crystal Reports

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development studio, Enterprise Manager, SQL Profiler, Query Analyzer, Import & Export(DTS),performance point server 2007.

Configuration Management Tools: JIRA, Team Foundation Server (TFS) 2010/2008/2005 .

Operating System: Windows Server 2003, Windows 2000 Advanced Server/Professional, Windows NT, Windows XP Professional /Standard.

PROFESSIONAL EXPERIENCE:

Confidential, MO

SQL/ETL Developer

Responsibilities:

• Experience in designing, creating, testing and modifying User-defined Functions and Stored Procedures.
• Extensive experience in creating and designing SSIS Packages for Integration and Migration of data from XML, Excel, DB2, Sybase, Flat file, Oracle to MS SQL Server using BCP and DTS utility and extracting, transforming and loading of data using SSIS.
• Implemented various Control flow and Dataflow elements of the SSIS Package.
• Experience in creating XML data files using SSIS Script task (VB.NET, C#.NET).
• Experience in developing, deploying and managing various reports like ad-hoc reports, Crystal Reports, simple and parameterized reports using SQL Server Reporting services (SSRS).
• Hands on experience in creating Parameterized reports and Linked reports with thorough knowledge of report service architecture. (Table, chart and matrix report).
• Proficient in writing Queries for generating Drilldown reports and designing report layout from XML, SQL Server, and MS excel as data sources using MS SQL Server Reporting Services (SSRS).
• Knowledge in SSAS and different schemas like Star Schema and Snow Flake Schema and also Data
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, and Logging using SSIS.
• Involved in Cube development and deployment in SSAS (SQL Server Analysis Services).
• Experience in designing conceptual, logical and physical database models using Erwin.

Environment: MS-SQL Server 2012/2008 R2/2008 Enterprise Manager, MS Business intelligence (BIDS) SSIS, SSRS,SSAS, MS Visual Studio 2010\2008, SharePoint Server 2010, MS Visio 2010, MS-Office 2010, XML, Windows Server 2008, TFS 2010.

Confidential, VA

SQL/SSIS/SSRS Developer

Responsibilities:

• Experience in designing, creating, testing and modifying User-defined Functions and Stored Procedures.
• Extensive experience in creating and designing SSIS Packages for Integration and Migration of data from XML, Excel, DB2, Sybase, Flat file, Oracle to MS SQL Server using BCP and DTS utility and extracting, transforming and loading of data using SSIS.
• Implemented various Control flow and Dataflow elements of the SSIS Package.
• Experience in creating XML data files using SSIS Script task (VB.NET, C#.NET).
• Experience in developing, deploying and managing various reports like ad-hoc reports, Crystal Reports, simple and parameterized reports using SQL Server Reporting services (SSRS).
• Hands on experience in creating Parameterized reports and Linked reports with thorough knowledge of report service architecture. (Table, chart and matrix report).
• Proficient in writing Queries for generating Drilldown reports and designing report layout from XML, SQL Server, and MS excel as data sources using MS SQL Server Reporting Services (SSRS).
• Knowledge in SSAS and different schemas like Star Schema and Snow Flake Schema and also Data
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, and Logging using SSIS.
• Involved in Cube development and deployment in SSAS (SQL Server Analysis Services).
• Experience in designing conceptual, logical and physical database models using Erwin.

Environment: MS-SQL Server 2012/2008 Enterprise Manager, MS-SQL Server 2005, SSRS 2012, Oracle SQL Developer, TOAD, MS Business intelligence (BIDS) SSIS, SSRS,SSAS, SharePoint Server 2010, XML, MS Excel, MS Visio 2010, VB.Net, C#.Net, Visual Studio 2008, Visual Studio 2005, Windows Server 2008, TIDAL,SQL CMD Utility JIRA.

Confidential, MI

Database Developer

Responsibilities:

• Experience in designing, creating, testing and modifying User-defined Functions and Stored Procedures.
• Extensive experience in creating and designing SSIS Packages for Integration and Migration of data from XML, Excel, DB2, Sybase, Flat file, Oracle to MS SQL Server using BCP and DTS utility and extracting, transforming and loading of data using SSIS.
• Implemented various Control flow and Dataflow elements of the SSIS Package.
• Experience in creating XML data files using SSIS Script task (VB.NET, C#.NET).
• Experience in developing, deploying and managing various reports like ad-hoc reports, Crystal Reports, simple and parameterized reports using SQL Server Reporting services (SSRS).
• Hands on experience in creating Parameterized reports and Linked reports with thorough knowledge of report service architecture. (Table, chart and matrix report).
• Proficient in writing Queries for generating Drilldown reports and designing report layout from XML, SQL Server, and MS excel as data sources using MS SQL Server Reporting Services (SSRS).
• Knowledge in SSAS and different schemas like Star Schema and Snow Flake Schema and also Data
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, and Logging using SSIS.
• Involved in Cube development and deployment in SSAS (SQL Server Analysis Services).
• Experience in designing conceptual, logical and physical database models using Erwin.

Environment: Visual Studio 2010/2008, MS-SQL Server 2008R2/2008 Enterprise Manager, TOAD, MS Business intelligence (BIDS) SSIS, SSRS,SSAS, MS Access, MS Visio 2007, SharePoint Server 2010, XML, MS Excel, C#.Net, Visual source safe, Windows Server 2008,TFS 2008.

Confidential, MI

MS SQL/SSRS Developer

Responsibilities:

• Experience in designing, creating, testing and modifying User-defined Functions and Stored Procedures.
• Extensive experience in creating and designing SSIS Packages for Integration and Migration of data from XML, Excel, DB2, Sybase, Flat file, Oracle to MS SQL Server using BCP and DTS utility and extracting, transforming and loading of data using SSIS.
• Implemented various Control flow and Dataflow elements of the SSIS Package.
• Experience in creating XML data files using SSIS Script task (VB.NET, C#.NET).
• Experience in developing, deploying and managing various reports like ad-hoc reports, Crystal Reports, simple and parameterized reports using SQL Server Reporting services (SSRS).
• Hands on experience in creating Parameterized reports and Linked reports with thorough knowledge of report service architecture. (Table, chart and matrix report).
• Proficient in writing Queries for generating Drilldown reports and designing report layout from XML, SQL Server, and MS excel as data sources using MS SQL Server Reporting Services (SSRS).
• Knowledge in SSAS and different schemas like Star Schema and Snow Flake Schema and also Data
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, and Logging using SSIS.
• Involved in Cube development and deployment in SSAS (SQL Server Analysis Services).
• Experience in designing conceptual, logical and physical database models using Erwin.

Environment: Visual Studio 2005/2008, SQL Server 2008/2005 Enterprise Edition, SharePoint Server, Microsoft Business intelligence development studio(MSBI) SSIS, SSRS, SSAS, Crystal reports 10, Oracle, Share Point Services, VB.net, and Windows Server 2003.