SUMMARY

• Over 5 years of IT experience in the Analysis, Design, Development, Administering Client/server application using Microsoft SQL Server and BI suite (Development, UAT and Production Environment.
• Strong technical knowledge in MS SQL Server development including SSIS,SSRS,T - SQL, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client-server based applications).
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008).
• SQL Server 2005/2008/2008 R2/2012 RDBMS database development including T-SQL programming. Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in training and support and also have experience in incremental data loading.
• Designed and developed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2008/r2 for Data Analysis and Reporting
• Implemented multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• ETL implementation using SQL Server Integration Services (SSIS).
• Developing reports on SSIS & SSRS on SQL Server ( 2005/2008/2008 R2). Sound Experience and understanding of SSAS, OLAP cube and Architecture
• Experience in logical, physical, and dimensional data modeling, data mapping, and data normalization, well verse in VISIO-2003.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Excellent communication skills, analytical skills, understand business requirements in various domains.

TECHNICAL SKILLS

Database: SQL Server 2005, 2008/R2

Operating Systems: Windows XP/2003/2008/Windows-7.

Programming Languages: T-SQL, PL/SQL, C

BI Suite: SSIS, T-SQL, SSRS

ETL TOOLS: DTS, SSIS, Informatica 7.1.3/6.2

Database Tools: Visio, Erwin.

SCM Tools: Visual Source Safe, Star Team, TFS

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

MS SQL Server/SSRS/SSIS Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase)
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in training and support and also have experience in incremental data loading.
• Designed and developed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Developed Report Models using report builder and distributed reports in multiple formats using SSRS in BIDS.
• Managed the migration of SQL Server 2000 databases to SQL Server 2005/2008.
• Experience in upgrading SQL Server software to new versions and applying service packs and hot fixes and unattended Installations.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
• Designed and implemented parameterized and cascading parameterized reports using SSRS
• Wrote store procedures to generate account statements for different types of accounts
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS
• Responsible for stylish design layout like Pie charts, graphs and linked reports
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Environment: SQL Server 2005 Management studio, T-SQL, Excel, Windows 2000/XP, SSIS, SSRS, SSAS.

Confidential, NJ

SQL Server Developer

Responsibilities:

• Loading data from various sources like, flat files, to SQL Server database Using SSIS Package
• Involved in Creation of Dimensions using STAR Schema
• Used Lookups Transformation to get the data from reference data sets
• Scheduling the SSIS packages and Jobs
• Created SSIS Packages to migrate slowly changing dimensions.
• Wrote DTS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
• Created tables for data ware housing applications and populated the tables from the OLTP database using DTS packages
• Transferring data between XML document and SQL server.
• Performed activities such as database creation, database tuning, performance planning, backup planning and database administration
• Actively involved in Normalization & De-normalization of database
• Materialized views, dimensions and stored outlines for optimal performance
• Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems.

Environment: SQL Server 2005 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, Crystal Reports, Erwin, XML, VB.NET, MS PowerPoint, MS Project, MS Access 2000 & Windows Server 2000, Oracle.

Confidential, Nashville TN

SQL Server Developer

Responsibilities:

• Created new tables, written stored procedures for application developers and some User- defined functions.
• Created SQL scripts for tuning and scheduling.
• Performed data conversions from flat files to a normalized database structure.
• Created and managed users, roles and groups and database security.
• Created Triggers to enforce data and referential integrity.
• Defined Check and default constraints, Indexes, and Indexed Views.
• Configured Server for sending automatic mails to the respective people when a DTS Process fails or succeeds.
• Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS) and bulk copy.
• Periodic monitoring of the system for bottlenecks.
• Created and maintained Indexes for various fast and efficient reporting processes.
• Analyzed database growth, space requirement and User/Login Roles.
• Managed test data and their updates between development and production databases and migrated stored procedures and database objects.
• Added replication definition and its function on Reporting Server and monitored replication.
• Configured Snapshot replication for reporting, user acceptance test and development servers. Created code documentation using Visual source safe.
• Experience in Configuring and Managing Linked Servers, data transfer between SQL Server and other heterogeneous relational database such as Oracle and DB2.

Environment: SQL Server 2005 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2003, Oracle 9i, Sybase.

Confidential, Atlanta, GA

SQL Developer

Responsibilities:

• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Involved in building and debugging SSIS packages with graphical tools and wizards.
• Created tasks for performing workflow functions such as FTP operations, executing SQL statements, and sending e-mail messages.
• Responsible for XML Support for Various SQL Server Data Types.
• Experienced in package configuration for deploying SSIS Packages to various environments.
• Designed data sources and destinations for extracting and loading data, transformations for cleaning, aggregating, merging, and copying data
• Involved in Integration Services for administering package execution and storage.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Created Stored Procedures to transform the data and worked extensively in T-SQL for various needs of the transformations while loading the data.

Environment: SQL Server 2000/2005, SQL Server 2008, Oracle 10g/11g, Windows 2003/2000, HTML, XML, Oracle SQL Data modular, SQL Navigator.