SUMMARY

• 7 years of IT experience with extensive expertise in SQL Server technologies like MS SQL Server 2005/2008 suite of products like SSRS, SSAS and SSIS including development, deployment, testing and support.
• Experience with software development life cycle (SDLC) and Project Management Methodologies.
• Experience in SQL Server Programming, Analysis Services and Reporting services 2005/2008.
• Hands on Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2000/2005/2008 .
• Experience in Data Warehouse Development environment using Microsoft DTS, SSIS and SSRS.
• Experience in Database Development and Release Management Concepts, Practices and Procedures along with Performance Tuning Database Code in OLTP and OLAP environments.
• Experience in data Extraction, Transformation and Loading (ETL) processes using SSIS, DTS Import/Export Data, Bulk Insert, BCP and DTS Packages.
• Involved in logical design of database using ERWIN.
• Experience in mapping data into database objects.
• Very strong Transact - SQL Development Skills which includes creating Complex Business Stored Procedures, Tables, Cursors, Views, Indexes, Triggers and Functions.
• Expertise in Creation and Maintenance of Procedures, Triggers and Functions.
• Experience in creating, maintaining and implementing sql scripts.
• Involved in creation of MRP (Master Release Plan).
• Experienced in the migration and implementation from other databases to MS SQL Server.
• Experience in providing technical support to internal developers and external clients
• Experienced in Data Loading using T-SQL, Fine Tuning of Database and improving Performance, Creating new Database, Creating and Modifying Table space and Optimization.
• Experienced in DTS and BCP of SQL Server to populate the data from various sources in various formats
• Excellent Communication, Analytical skills and Interpersonal skills. Versatile team player with proven problem solving skills and ability to quickly learn new technologies.

TECHNICAL SKILLS

Programming Languages: T-SQL, C, C#, C++, Assembly

Databases Tools: SQL Server Enterprise Manager, SQL Server Management Studio, Query Analyzer, SQL Profiler, Data Transformation Services(DTS), ETL, Query Builder, BCP, Bulk Insert, SSIS,SSAS,SSRS, BIDS,VSS, Crystal Reports, ERWIN.

Databases\Data Access: SQL Server 2000/2005/2008 , Oracle 9i/10g, Sybase, MS Access.

Other tools: MS Word 2003/2007/2010 , MS Excel 2003/2007/2010 , MS Outlook 2003/2007/2010 , MS Visio, SharePoint Server 2007.

Operating Systems: Windows NT/ 2000/2003/2008/ XP/7

PROFESSIONAL EXPERIENCE

Senior SQL Developer

Confidential, Charlotte, NC

Responsibilities:

• Understand Business Requirements.
• Worked primarily on the request made by front end developer depending on the business need.
• Created and modified stored procedures, functions, views and indexes to provide best performance.
• Created table, views, columns and constraints as per Java developer’s request.
• Created Sql server script and managed its implementation.
• Manually maintained an Excel sheet with charge code, companies name and various other information to manage implementation of scripts.
• Worked with DBA and QA in development of MRP (Master Release Plan).
• Was primarily responsible for making sure scripts ran according to the MRP.
• Provided technical support to internal developers and external clients.
• Created scripts and SQL jobs to facilitate database backup and recovery, server and data processing monitoring and alerting.
• Worked closely with other DBAs in the design and implementation process for deploying, upgrading, managing, archiving and extracting data for reporting
• Optimized the performance of queries with modifications in T-SQL queries, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Worked on DTS and BCP of SQL Server to populate the data from various sources in various formats.

Environment: SQL Server 2005/2008, Windows XP,SQL Enterprise Manager, Query Analyzer, SSIS, SSRS, T-SQL, Visual studio2005, MS Excel

Confidential, IL

SQL Developer

Responsibilities:

• Created and managed schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
• Worked with SSIS to design the packages for ETL Support.
• Generated T-SQL scripts for application development.
• Created Stored Procedures and User Defined functions.
• Created Indexes to speed up the queries.
• Created roles and permissions for the data warehouse applications.
• Participated in re-design and development of back-end SQL Server database, wrote queries, triggers and stored procedures
• Programmed SQL Server 2005 Reporting Services using Microsoft Visual Studio 2005.
• Performed Migration of databases from SQL 2000 to SQL2005 using SSIS
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation
• Scheduled Jobs and Alerts using SQL Server Agent
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Involved in logical design of database using ERWIN and mapping the data into database objects.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: SQL Server 2000/2005, Windows 2000/XP Query Analyzer, MS Excel (pivot tables) SSIS, SSRS, T-SQL, Visual studio2005, ERWIN

Confidential, St. Louis, MO

SQL Server developer

Responsibilities:

• Extensively wrote T- SQL codes for the project.
• Created Stored Procedures for Batch Processing.
• Developed stored procedures, triggers and functions and manipulated tables for data extraction, transformation, and data loading (ETL).
• Developed and modified the SSIS packages for ongoing data support.
• Manipulated tables, columns, triggers using TSQL.
• Worked with Business Objects and SSRS.
• Used Views, Triggers, and Stored Procedures for updating and cleaning the existing data.
• Developed, maintained and supported the enterprise data warehouse using SSIS and SSRS system throughout the SDLC.
• Delivered SQL server reports to SharePoint to enhance team collaboration
• Generated reports according to business requirements using crystal reports and reporting services 2005.
• Created monthly reports using reporting wizard with Visual Studio
• Involved in Scheduling backups and maintenance.
• Upgraded DTS packages to SSIS.
• Modified an Existing crystal reports and SQL Reporting Services Reports.
• Created indexes to improve the performance of the queries
• Created backups and restore of the databases.
• Used data conversions to convert different data types
• Created Views for Extracting Data using TSQL.
• Performed Migration of databases from SQL 2000 to SQL2005
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Created Distributed Partitioned Views.
• Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using SSISand also used BCP and Bulk Insert.

Environment: MS SQL 2000/2005,Sharepoint Windows NT/2000/XP,SSAS,SSIS, SSRS, Crystal reports Visual studio 2005, ASP 3.0,Business Objects, ORACLE 10g, MS Excel(Creating reports), SQL Query Analyzer, Enterprise Manager, MS Access, MS Word.

Confidential, Atlanta, GA

SQL Developer

Responsibilities:

• Participated in developing logical model and implementing requirements on SQL Server 2005.
• Created Stored Procedures and User Defined functions.
• Used SSIS and SSAS to collect, analyze and integrate data from various database sources to existing systems.
• Created database triggers to implement business requirements
• Created complex Stored Procedures and Functions to support the front-end application
• Optimized SQL queries for improved performance and availability
• Had primary responsibility of ensuring databases availability.
• Ensured data recovery, maintenance, and data integrity and space requirements for physical Database.
• Reorganized database structures as needed, automate procedures Confidential regular intervals.
• Created and maintained all types of Backups and recovery strategies and set up jobs
• Set up Profiler Traces, Analyze and replay Profiler Traces for Performance and long running queries
• Created Packages using DTS
• Optimized long running Stored Procedures & queries for effective data retrieval.

Environment: SQL Server 2005 (Query Analyzer, Enterprise Manager, DTS Designer, SQL Profiler, Index Tuning Wizard), MS SQL Reporting Services, Windows XP, MS Access, MS Word, MS Excel

Confidential

Sql Server Developer

Responsibilities:

• Installed and configured MS SQL Server on Advanced Windows 2003 server.
• Generated Script files for changes made to stored procedures or views or any other database objects.
• Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Managed the use of disk space, memory and connections.
• Ran DBCC consistency checks, and fixed data corruption in application databases.
• Installed SQL Server service packs based on the errors and flaws that are found in the application.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
• CreatedSSISpackage to automate maintenance, database back up, update statistics, re-build indexes as well as create error log for event during data load.
• Monitored MS SQL server for performance and network issues.
• Created and Rebuild the Clustered & Non Clustered indexes Confidential regular intervals for better performance.
• Generated MIS reports usingCrystal Reports.
• Installed SQL Server service packs based on the errors and flaws that are found in the application.
• Provided problem resolution, troubleshooting, tracked and resolved issues in the database environment.

Environment: SQL server 2000/2005, Windows 2000/2003, Windows Cluster Server2003 MS Office, Crystal Reports, Visual Studio.NET, C#.NET.