PROFESSIONAL SUMMARY:

• Over 7 years of IT Professional experience with Microsoft SQL Server 2000/2005/2008, SSIS/SSRS in T - SQL and OLTP and OLAP environment
• Experienced in T-SQL (DDL, DML) documentation, coding, programming and implementation of Business Intelligence solutions using SQL Server 2000/2005/2008.
• Good knowledge in RDBMS concepts and constructs along with Database Objectscreation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
• Expertise in working on all activities related to the development, implementation, administration and support of ETL process for large scale Data Warehouses using Bulk Copy Process(BCP), Data Transformation Services(DTS) and SSIS with MS SQL Server 2005/2008/2008R2
• Expertise in writing SSIS packages with Configuration, Custom Logging, Deployment, SQL Mail, Check Point, Custom Control Flow, Auditing, Variables, Expressions, Procedure Error Handling and Data Error Handling, in SSIS.
• Experienced in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous Systems using SQL Server tools like SSIS, DTS, Bulk Insert, BCP and XML.
• Sound knowledge on Object-Oriented & Service-Oriented Architecture, its implementation for creating and integrating efficient business solutions.
• Experienced in writing Transact-SQL (DDL/DML) queries.
• Experienced in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS/SSIS Packages.
• Created Customized Reports using SSRS.
• Strong knowledge of Data Warehousing Concepts and Data Modeling Techniques like Dimensional Data Modeling, Star Schema Modeling and Snow-Flake Modeling
• Extensive experienced in Data Analysis, Database Design, ER diagrams and Normalization techniques
• Experienced in DB2 queries.
• Experienced in source systems analysis and data extraction from various sources like Flat files, Oracle, DB2, MS SQL Server

TECHNOLOGICAL SKILLS:

Languages: T-SQL, SQL, PL/SQL, C#.Net, VB.Net, ASP.Net, XML, HTML, Java Script, UNIX Shell Script, PL1, COBOL

Tools/Utilities: Enterprise Manager, SQL Server Management Studio(SSMS), Query Analyzer, Business Intelligence Development studio, DTS, Analysis Manager, SQL Profiler, SSIS, SSRS, SSAS, Visual Studio 2005/2008, SQL Advantage, SQL * Plus, Toad, Erwin, Rational Rose, Microsoft Visio 2003/2007

Databases: MS SQL Server 7.0/2000/2005/2008, Oracle10g/9i, MS Access

Source Control Tools: Visual source safe

Software: MS Office, Adobe Photoshop, Ms Excel, MS-Project 2007

Reporting Services: Excel, SQL Server Reporting Services, Crystal Reports 2005/2008, Business Objects

PROFESSIONAL EXPERIENCE

Confidential, California

MS SQL Server/SSIS Developer

Responsibilities:

• Experience in extracting and transforming data using DTS Import/Export Data, Bulk Insert, BCP and DTS Packages.
• Rewrote SQL queries to upgrade SQL Server performance using SQL Server 2000/2005/2008.
• Experienced in writing queries on DB2 servers.
• Designed an ETL process to load data from heterogeneous sources like SQL Server, CSV, and text and Excel files.
• Created database, tables and procedures to update and clean the old data.
• Worked with the front end application developers with their queries.
• Created and modified procedures, triggers and functions.
• Created schemas, views, stored procedures, Triggers and functions for Data Migration. Involved in the complete life cycle of the project, from Planning Staging and pushing the codes to production.
• Checked Performance Tuning, Indexing, Query Optimization.
• Employing Indexing Strategies and optimizing them using SQL Profiler & Index Tuning Wizard.
• Involved in relational database modeling like, designing the tables, algorithmic diagrams for the input data (entity diagrams), indexes.
• Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks).
• Created and customized SSIS packages and used load data from difference sources.
• Modifying existing SSIS packages and optimizing it.
• Created schemas, views, stored procedures, Triggers and functions for Data Migration. Involved in the complete life cycle of the project, from Planning Staging and pushing the codes to production.
• Involved in writing different testing scripts for the testing of the Codes in ASP.Net.
• Worked with the front end application developers with their queries
• Expert in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP, DTS and SSIS utilities.
• Created schemas, views, stored procedures, Triggers and functions for Data Migration. Involved in the complete life cycle of the project, from Planning Staging and pushing the codes to production.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Database Tuning Advisor, SQL Enterprise Manager .

Environment: Microsoft SQL Server 6.5/2000/2005/2008 Enterprise Edition, Oracle 10g, DB2, Toad 10.5, Visual Studio 2005/2008, C#, ASP.NET, T-SQL, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services 2005.

Confidential, New York

MS SQL Server/SSIS Developer

Responsibilities:

• Collected the user and system requirements and write technical specifications.
• Implemented complex conceptual database design into SQL Server 2008/2005 using various constraints and triggers.
• Performed data transfers using BCP and BULK INSERT utilities. Was involved in the design and implementation of Disaster Recovery.
• Created tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Designed and maintained Data Warehouse schema, data model and data standardization
• Created complexT-SQL Stored Procedures, triggers, cursors, Index, views and other statements for applications.
• Experience in writingT-SQL Scripts and Batch files.
• Imported various Sources, Targets, and Transformations using SSIS packages.
• Expert in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP, DTS and SSIS utilities
• Experience in creating packages, Jobs, Sending Alerts using SQL Mail
• Involved to work with .NET, C# environment within SSIS, SSRS to implement the business requirements.
• Created stored procedures and triggers for database transactions in SQL Server
• Performing Backup and Recovery& Automation of Backup and Recovery.
• Created Triggers, Stored procedures, Tables and queries. Import and export of SQL objects from and to various sources.

Environment: MS SQL Server 2008/2005/2000, Migration, SQL Reporting Services, SQL Server

Confidential, Chicago

MS SQL Server/SSIS Developer

Responsibilities:

• Worked with Client/Server tools like SQL Server Enterprise Manager and Query analyzer to administer SQL Server.
• Used DDL and DML to writing triggers, stored procedures to check the data entry and payment verification
• Created Triggers, Stored procedures for implementing the business logic.
• Implemented User defined functions and stored procedure.
• Involved in requirement gathering, analysis, design, development, change management, deployment
• Fine tune complex SQL queries and Stored Procedures to increase performance.
• Created stored procedures for database transactions in SQL Server.
• Created and customized SSIS packages and used SSIS to load data from difference sources.
• Created stored procedures and triggers for database transactions in SQL Server
• Involved in performance tuning of queries and stored procedures.
• Created Views to facilitate easy user interface implementation, and triggers on them facilitate consistent data entry into the database.
• Involved in performance tuning of queries and stored procedures.
• Actively participated in Code Reviews and Design Reviews to establish Coding and Design standards
• Participated in Requirements Gathering and Design sessions

Environment: SQL Server 2008/2005, SSIS, SSRS, Windows Advanced Server, MS Excel, MS

Confidential, MN

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Created and modified procedures, triggers and functions
• Created all administration tasks of SQL Server and designed database
• Used system stored procedures and DBCC commands
• Performed daily backups and developed recovery procedures
• Created DTS package to export and import data to SQL Server from MS Access, text files, Excel files and Oracle databases
• Checked Performance Tuning, Indexing, Query Optimization
• Wrote complex T-SQL queries and procedures for retrieval of data
• Created DTS packages for migration of data from SQL Server to MS Access and Oracle databases
• Scheduled DTS Packages and Involved in data extraction and loading using DTS in MS SQL Server 2000 and SSIS in MS SQL Server 2005. Import Export data, Bulk Insert and BCP.
• Created jobs for automatically running stored procedures for day-end operations using SQL Server agent such as index rebuild, data loads and summary reports
• Employing Indexing Strategies and optimizing them using SQL Profiler & Index Tuning Wizard
• Dropped and recreated the Indexes on tables for performance improvements
• Performing Data Transfer/Migration using Export/Import and Data Transformation Services (DTS)
• Partitioned lot of tables, which have frequent inserts, deletes and updates to reduce the contention and to improve the performance
• Generated reports using SSRS for reporting and SSAS cubes

Environment: MS SQL 2000/2005, Windows NT/2000/XP, DTS, SSIS, MS Reporting Services (SSRS), SQL Query Analyzer, SQL profiler and Enterprise Manager

Confidential

MS SQL Server Developer

Responsibilities:

• Actively involved in different stages of Project Life Cycle.
• Actively participated in gathering of User Requirement and System Specification.
• Used SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Involved in creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Rules and Defaults.
• Experienced in writing queries on DB2 servers.
• Worked within a MVS (mainframe) environment using programming language such as DB2, PL/1, and C.
• Worked as a developer in creating complex Stored Procedures, DTS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Created User Defined Functions and Stored Procedures, and also defined Roles and Privileges to control access to database.
• Created Constraints, Defaults, Views and Indexes.
• Created Triggers to enforce data and referential integrity.
• Converting complex business logic into Stored Procedures and Functions to achieve functionality required by business analysts.
• Managing Extraction, Transformation and Loading (ETL) process pulling of data from various data sources using DTS, BCP applications to staging areas.
• Extracting data from the old legacy system to the staging area. In the staging area, I was involved in data cleansing and data validation to ensure data integrity and data consistency.
• Testing application for database behavior, correctness of data using SQL Profiler to capture slow running stored procedures.

Environment: MS SQL Server 2000/2005, Windows 2000 Advanced Server, VB 6.0, and XML, DB2.