OBJECTIVE
Seeking a challenging position as a Software Engineer which allows career advancement in Database Development or Administration

SUMMARY

• Eight years of experience in SQL Server Development.
• Experience in Database Development such as Creation of Databases, Tables, Stored Procedures, Triggers, Views and Functions using Transact-SQL.
• Hands on Experience in migrating data from MS SQL Server 2000 to MS SQL Server 2005
• Extensive experience in writing queries by using Joins Indexes and views.
• Extensively involved in data extraction and loading using DTS in MS SQL Server 2000 and SSIS in MS SQL Server 2005.
• Wrote T-SQL Script for Database maintenance like DBCC REINDEX, DBCC SHRINKDB/SHRINKFILE, DBCC CHECKDB etc. and scheduled them
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS/SSIS Packages.
• Experience in SSIS (SQL Server Integration Services) and SSRS (Reporting Services).
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and maximize performance, implementing technology solutions, and training /supporting end users.
• Ability to work on fast paced work environment.
• Excellent communication skills, ability to work in teams and plan activities to meet deadlines.

WORK EXPERIENCE

Confidential, April 2011 - Present
SQL Server Developer
Irving, TX

Responsibilities:

• Worked on new Work Requests(WR) which includes creating and modifying of schemas, Stored Procedures, Functions, Views and SSIS packages.
• Created PCR which include scripts (Insert, Delete, and Modify) to push data (Product catalog) changes to production on daily basis.
• Monitored the Dataload, replication and rename Jobs.
• Enhancing the existing SSIS packages.
• Troubleshooting the SSIS packages.
• Created SSIS package to be table driven.
• Created Internal logging mechanism in each data loading procedure by creating one table which will store every instance of procedure run with details like date time, period of run, etc.,
• Created SSIS package to loop all the tables to get loaded.
• Created QA check in SSIS from last load before loading the refreshed data in Production.
• Involved in deployment of SSIS packages to Production Server.
• Created views for data loading purpose when data needs to be loaded from different sources hiding the complexities underneath.
• Created Data Labels (Date, Source and Version) on all tables.
• Created Driver Table to handle Load operations.
• Interacted with front end team to get the requirements for the test data.
• Updated all the changes on TFS for every release.
• Build the kit for every release in Dev Environment.
• Restored the DB in staging during release when required for testing from Production copy.
• Identify the parent child relationship and the sequence of objects which needs to be deployed for release.
• Involved in Production support when needed.
• Worked on IR's raised by the Rep and providing a resolution and root cause for the IR.

Environment: SQL Server 2000/2005/2008, Transact-SQL, TFS, BIDS, SQL Server Integration Services (SSIS), SSMS, Analyzer, DTS, Excel, Text Pad, Sametime, Outlook, UltraEdit-32.

Confidential, July 2010 - March 2011
SQL Server Developer/DBA
Irving, TX

Responsibilities:

• Moved all the StoredProcedures and functions from Legacy Server to New Server.
• Created New Packages in SSIS Based on SQL Server 2000 DTS Packages and scheduled it as per the requirement.
• Imported aggregate Data from Oracle Production Database to SQL Server Production Using SSIS Package for reports.
• Imported data from various Sources (Oracle, Flat File, Excel and Raw File) and export to various Targets using SQL Server Integration Systems.
• Involved in deployment of SSIS packages to Production Server.
• Imported multiple Flat files at once to the Databases using SSIS Packages.
• Created Complex SSIS Packages to move data from SQL Server to Oracle Production database on daily basis.
• Data importing and transformation has been done for huge volume of records.
• Performed data conversions from flat files into a normalized database structure.
• Extensively involved in troubleshooting of SSIS Packages.
• Created complex Stored Procedures extensively for the required Report format.
• Monitoring the Daily Reports and SSIS packages.
• Wrote Queries in Oracle Database using Toad 9.0.
• Check in the deployment changes into TFS for every release and track it.
• Involved in Code Deployment and moving the Code to Staging before deployment.
• Setup the login credentials and Daily database Backup using maintenance plan.

Environment: SQL Server 2000/2005/2008, Transact-SQL, SQL Server Integration Services (SSIS), Toad 9.0, SSMS, Asp.net,C#,Query Analyzer, DTS, TFS,Excel, Text Pad, Lotus Notes, UltraEdit-32, Windows Server 2003

Confidential, August 2007 - June 2010
SQL Server Developer/DBA
Irving, TX

Responsibilities:

• Created New Database in SQL Server 2005 and moved the data from SQL server 2000.
• Created Indexes and views on the Tables in New Server based on the requirements
• Moved all the StoredProcedures and functions from Legacy Server to New Server.
• Created New Packages in SSIS Based on SQL Server 2000 DTS Packages and scheduled it as per the requirement.
• Imported aggregate Data from Oracle Production Database to SQL Server Production Using SSIS Package for reports.
• Imported data from various Sources (Oracle, Flat File, Excel and Raw File) and export to various Targets using SQL Server Integration Systems.
• Involved in deployment of SSIS packages to Production Server.
• Imported multiple Flat files at once to the Databases using SSIS Packages.
• Created Complex SSIS Packages to move data from SQL Sever to Oracle Production database on daily basis.
• Data importing and transformation has been done for huge volume of records.
• Performed data conversions from flat files into a normalized database structure.
• Extensively involved in troubleshooting of SSIS Packages.
• Created complex Stored Procedures extensively for the required Report format.
• Monitoring the Daily Reports and SSIS packages.
• Wrote Queries in Oracle Database using Toad 9.0.
• Excellent exposure to new version 2008.
• Wrote some complex Queries using New Features of SQL Server 2005(Pivot, CTE…)
• Involved in Code Deployment and moving the Code to Staging before deployment.
• Actively involved in creating new tables for the list of stored procedures, reports, jobs and their schedule for references.
• Setup the login credentials and Daily database Backup using maintenance plan.

Environment: SQL Server 2000/2005/2008, Transact-SQL, SQL Server Integration Services (SSIS), Toad 9.0, SSMS, Asp.net,C#,Query Analyzer, DTS, TFS,Excel, Text Pad, Lotus Notes, UltraEdit-32, Windows Server 2003

Confidential, Wilmington, DE, June 2006-July 2007
SQL Server Developer

Confidential, is a leading provider of information-based product development, consulting, integration, and mobile services to transportation, logistics, financial, and other industry organizations in North America. Founded in 1997, Syncretic has compiled a compelling list of installed systems and has tripled in size.
Responsibilities:

• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages.
• Actively involved in creation of database, Importing Data, modified tables and store procedures to clean and validate the data so as to meet the company specifications.
• Involved in troubleshooting of existing SSIS Packages.
• Worked on SSIS Packages, changes Structure of tables and created new Columns during transformation using SSIS packages.
• Performed data conversions from flat files into a normalized database structure.
• Imported data from various Sources (Flat File, Excel and Raw File) and export to various Targets using SQL Server Integration Systems.
• Involved in deployment of SSIS packages to Production Server.
• Imported multiple Files at once to the Databases using SSIS Packages.
• Creating and running SSIS Packages for Import and Export of Heterogeneous Data.
• Making a Report as per requirement using MS Reporting Services 2005.
• Imported Data from Oracle Database to Sql Server Using SSIS.
• Using SQL Server Management Studio Created joins and sub-queries for complex queries involving multiple tables.
• Wrote Some Queries Using Common Table Expressions (CTE) to reduce their complexity.
• Wrote T-SQL statements for retrieval of data and Involved in performance tuning of TSQL queries and Stored Procedures.
• Worked with DBA to set up the daily database backup & restoration and monitor the performance of Database Server.
• Responsible for providing daily and weekly reports to the immediate supervisor and actively involved in the daily and weekly meeting to discuss project status.

Environment: SQL Server 2000/2005, Transact-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Query Analyzer, DTS, Excel, UltraEdit-32, Windows Server 2003.

Confidential, Chicago December 2005-May 2006
SQL Server Developer

With unmatched global reach, relevance and local expertise, Travel port opens new possibilities and delivers greater value every step of the way. Whether you\'re a traveler, travel professional or travel supplier, we offer more ways for you to create and enjoy exceptional travel experiences.

Responsibilities:

• Created Stored Procedures, Triggers, Views and Functions for the Application. Extensive testing on the Performance of the Stored Procedures.
• Imported data from various Sources and export to various Targets using SQL Server Integration Systems.
• Developed complex T-SQL code for the application conversions.
• Wrote and integrated Stored Procedures to generate the Reports.
• Transferring the data from SQL server 2000 to SQL Server 2005 using SSIS.
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
• Perform data transfer and database transfer for server relocation, using DTS.
• Creating (SSIS) packages to gather data from various sources
• Created backup/restore and disaster recovery plans for production servers.
• Using Sqlserver reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Developed and implemented change control procedures to manage system modifications/upgrades.
• Worked with DBA to set-up the security roles for developers and end-users.
• Backing and Restoring of Databases on Scheduled basis.

Environment: SQL Server 2000/2005, SQL Server Integration Services(SSIS), SQL Server reporting services (SSRS) ,Transact-SQL, Enterprise Manager, Query Analyzer, DTS, Excel, Windows 2000 Server.

Confidential, October 2004 - November 2005

SQL Server Developer, VA

Confidential, is a unique national managed health care company that offers comprehensive services to payers across the country--including all 50 states, the District of Columbia and Puerto Rico. Serving the group health, workers\' compensation and state public program markets, and our core competency is managing total health care costs while educating and empowering consumers.
Responsibilities:

• Created Stored Procedures, Triggers, Views and Functions for the Application.
• Developed complex T-SQL code for the application conversions.
• Transferring the data from SQL server 2000 to SQL Server 2005 using SSIS.
• Wrote the Letter Extract Functions and Stored Procedures in SQL Server 2005
• Wrote the stored procedure to call the Functions.
• Migrated data from legacy Databases in SQL 2000 to SQL server 2005.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
• Created backup/restore and disaster recovery plans for production servers.
• Developed and implemented change control procedures to manage system modifications/upgrades.
• Backing and Restoring of Databases on Scheduled basis.
• Worked with DBA to set-up the security roles for developers and end-users.
• Extensive testing on the Performance of the Stored Procedures.
• I have set up Replication Environment for Development and Production Servers.

Environment: SQL Server2000/2005, SQL Server Integration Services (SSIS), Transact-SQL, Enterprise Manager, Query Analyzer, Excel, Xml, Windows XP Server.

Confidential, India July 2003 - September 2004
SQL Server Developer/DBA
Responsibilities:

• Create and maintain the databases using SQL Server.
• Plan the Backup policy for the databases.
• Plan and Schedule the Online/Offline Backups.
• Performing database recovery using the backup sets.
• Performing data transfer/migration using Export/Import and Data Transformation Services.
• Tuning And optimizing SQL Server by using performance monitor.
• Create packages, procedures, functions and triggers. Handle database performance and tuning.
• Creation of additional databases, logins and roles.
• Involved in writing complex queries using T-SQL.
• Data transfers between various servers using DTS.
• Creating and running DTS Packages for Import and Export of Heterogeneous Data.
• Creation of schema objects, granting of roles and privileges to the users, compilation of procedures etc.
• Ensuring that the backups are running fine for various databases on different servers.

Environment: SQL Server 2000, Excel, MS Access and Windows 2000/NT 4.0

TECHNICAL SKILLS:

• Databases: MS SQL Server 2000/2005, MS Access, Oracle
• Database Tools: SQL Enterprise Manager, SQL Profiler, SQL Query Analyzer, SSMS, BIDS
• ETL Tools: DTS, Integration Services (SSIS), Reporting Services (SSRS),
• Development skills: Transact SQL (T-SQL), PL/SQL
• Languages: C, C++
• Operating Systems: Windows NT/2000/XP.

Education Details:

Bachelors of Engineering ( E.E.E)

Willing to relocate and travel