SUMMARY

• 21 plus years of experience in Information Technology.
• Worked as Production DBA, Development DBA, Database Developer, ETL - DTS-SSIS designer, SSRS Designer, Data warehouse developer, Web and windows based Client/Server applications developer.
• Extensive experience in SQL Server 2005/2008 Integration Services Packages and SQL 2000 DTS packages development.
• Developed several SQL Server 2005 Reports.
• Deployment of SSIS packages and SSRS reports to SIT, QA, UAT, DR and Prod Servers.
• Fine tuning/Optimizing of T-SQL code and procedures.
• Involved in full Life Cycle development of Software Applications dat involves analysis, design, coding, testing and documentation.
• Followed eXtreme Program practices including Test Driven Development, and Software Refactoring Practices.
• Used Software Design Patterns for code development.
• Proven ability to support multiple complex projects under tight deadlines, often with competing priorities.
• Strong interpersonal and communication skills.
• Self-guided and able to hit the ground running.
• Database modeling with ERWin and Visio.
• Database Clustering.

TECHNICAL SKILLS

• Windows Server 2012 Enterprise Edition Windows Server 2008 Standard Edition
• Windows Server 2003 Enterprise Edition
• Windows Server 2000 Standard Edition
• Windows XP Professional Edition
• Windows 98/Me/3.1
• MS-DOS
• UNIX
• LINUX
• Server Applications:
• IIS 6.0
• IIS 5.0
• Commerce Server
• MSMQ
• Site Server
• Windows Server 2003
• Windows application using .Net
• VB
• Web applications using ASP
• ASP.NETVBScript
• JavaScript
• SQL 2005
• SQL 2000 and Oracle
• Database Experience:
• SQL Server 2012/2008
• SQL Server 2005
• SQL Server 2000/7.0
• Oracle 8.1
• SSIS
• SSRS
• DTS
• TSQL
• PLSQL
• PowerShell
• C#
• Vb.net
• VB 6
• ASP.Net 3.0 2.0 1.1
• ASP
• Visual Studio .
• Crystal Reports
• VC++
• JavaScript
• VSTS
• HTMLTools:
• Quest SQL Lite speed
• Embarcadero DBArtisan
• RML Utilities for SQL Server
• Oracle SQL Developer
• SQL Compare
• SQL Data Compare
• SQL Loader
• BCP
• VisioApplication Center Test
• Fiddler
• SVN
• Visual Source Safe
• Clear Case
• CVS
• True change
• ERWin
• Visio

PROFESSIONAL EXPERIENCE

Database Administrator

Confidential, Plano, TX

Responsibilities:

• Sync reference tables data from Production to non-Prod database instances
• Implemented data masking based run time data transfer from Production to non-Production instances
• Implemented automated Data masked table transfer process between Production to Non-Production Servers
• Implemented TEMPeffective security access control process for existing users and creating new users
• Implemented schema tracking process
• Syncing logins, SQL jobs, SSIS packages between Prod to DR environment
• Documented and performed datacenter move from SQL 2000 to SQL 2005, SQL 2005 to SQL 2008R2 and SQL 2008R2 to SQL 2012R2.
• Documenting and performing database disaster recovery test.
• Developing SSIS Packages using Business Intelligence development studio (BIDS).
• Developing reports using SSRS.
• Developing, trouble shooting, and fine tuning complex SQL Stored procedures.
• Improving database performance by creating proper clustered and non-clustered Indexes.
• Implemented table level partitioning to speed up the queries.
• Solving database deadlock issues.
• Backup and restore databases.
• Implemented database SQL application login auditing
• Regularly verifying the data and database consistency.
• Scheduling and monitoring database jobs using SQL Server agent.
• Designing entity Relationship diagrams with Erwin and Visio 2003.
• Developed OLAP cubes using SQL 2005 and SQL 2000 Analysis services.
• Developed web pages to display Cube data using Office Web Components (OWC) and Office Web Charts.
• Gathering Business requirements from the Client and Preparing the Detail Design Documents, and implementing changes.
• Deployment of SQL Changes, SSIS packages, SSRS Reports, SSIS packages to various environments.
• Maintaining system through all the stages like development, SIT, QA, UAT, DR and Production.
• Mentoring and distribution of work to Offshore Team.
• Used True change and Visual Source safe for version management.

Environment: SQL 2008, SQL 2005, SQL 2000, Quest SQL Litespeed, Erwin, DB Compare, SQL Refractor, Visio 2003, ASP.NET 2.0/1.1, C#, ADO.NET, Microsoft Fiddler, Web development Helper, XML, XSL, JavaScript, Visual Studio 2005, Windows 2003/XP.

Senior Software Engineer

Confidential, Dallas, TX

Responsibilities:

• Developing SSIS Packages using Business Intelligence development studio (BIDS).
• Developing Reports using SSRS.
• Developing, Trouble shooting, and Fine tuning SQL Stored procedures.
• Improving database performance by creating proper Clustered and Non Clustered Indexes.
• Implemented Table level partitioning to speed up the queries.
• Solving Deadlock issues.
• Performing Database data Clean-up task for new releases.
• Implemented Transactional Database replication.
• Backup and Restore databases.
• Regularly verifying the data and database consistency.
• Used SQL Compare and Data SQL Compare to find out the Schema and Data changes between databases.
• Scheduling and monitoring database jobs using SQL Server agent.
• Designing Entity Relationship diagrams with Erwin and Visio 2003.
• Developed OLAP cubes using SQL 2005 and SQL 2000 Analysis services.
• Developed web pages to display Cube data using Office Web Components (OWC) and Office Web Charts.
• Gathering Business requirements from the Client and Preparing the Detail Design Documents, and implementing changes.
• Deployment of SQL Changes, SSIS packages, SSRS Reports, DTS packages to various environments.
• Maintaining system through all the stages like development, SIT, UAT, PRT and Production.
• Mentoring and distribution of work to Offshore Team.
• Used Visual Source safe for version management.
• Migrating Database from SQL 2000 to SQL 2005.

Environment: SQL 2005, SQL 2000, Erwin, DB Compare, SQL Refractor, Visio 2003, ASP.NET 2.0/1.1, C#, ADO.NET, Microsoft Fiddler, Web development Helper, XML, XSL, JavaScript, Visual Studio 2005, Windows 2003/XP, URL Scan.

Senior Software Engineer

Confidential, Houston, TX

Responsibilities:

• Tables and Views Designing.
• Developed stored procedures to encapsulate the business logic and to get data from the database.
• Trouble shooting, and Fine tuning SQL Stored procedures.
• Developing Reports using SSRS.
• Developing SSIS Packages using Business Intelligence development studio (BIDS).
• Improving database performance by creating proper Clustered and Non Clustered Indexes.
• Performing Database data Clean-up task for new releases.
• Developed Extraction, Transformation, Load (ETL) for loading data for the Data ware housing
• Backup and Restore databases.
• Scheduling database jobs using SQL Server agent.
• Verifying the data and database consistency.
• Used SQL Compare and Data SQL Compare to find out the Schema and Data changes between databases.
• Used CVS repository system for code management.

Environment: ASP.NET, .Net Frame work 1.1, C#, ADO.NET, VB, XML, XSL, JavaScript, SQL Server 2005/2000, CVS, Code Smith Studio, MS SQL Manager, and Windows XP Professional.

Senior Developer

Confidential, Dallas, TX

Responsibilities:

• Developed stored procedures to encapsulate the business logic and to get data from the database.
• Trouble shooting, and Fine tuning SQL Stored procedures.
• Tables and Views Designing.
• Improving database performance by creating proper Clustered and Non Clustered Indexes.
• Performing Database data Clean-up task for new releases.
• Developed Extraction, Transformation, Load (ETL) for loading data using SQL 2000 DTS.
• Backup and Restore databases.
• Scheduling database jobs using SQL Server agent.
• Verifying the data and database consistency.
• Designing Entity Relationship diagrams with Visio 2003.
• Implemented downloadable Excel Files generated by merging Excel Template and Sql Data.
• Used Rational Clear Case for version management.
• Gathering Business requirements from the Client and Preparing the Detail Design Documents, and implementing changes.
• Maintaining system through all the stages like development, SIT, UAT, PRT and Production.
• Mentor/Handling and distribution of work to Offshore Team.

Environment: ASP.NET, .Net Frame work 1.1, C#, ADO.NET, VB, XML, XSL, JavaScript, SQL Server 2000, Windows 2000 Server.

Senior Developer

Confidential, Dallas, TX

Responsibilities:

• Developed the Retail-COFEE application on web for causal business users using ASP.Net and C#.Net, and same time maintaining the client-server application initially written by Microsoft.
• Used Abstract class factory design pattern for implementing business logic.
• Used Crystal reports in ASP.NET for report generation to PDF and other file formats.
• Developing stored procedures and optimizing queries.
• Developed Web Services for providing business services to other Clients.
• Developed Web User controls for separating the business logic and to ease of maintenance.
• In web application used combination of asp controls and html Server and Client side controls.
• Used Microsoft Active Directory for saving/retrieving user information.
• Used Rational Clear Case for version management.
• Preparing the Detail Design Documents for the new requirements.
• Responsibilities also include customer support by solving day-to-day problems coming under the billing application and stabilizing it to maximum extent.
• Maintaining system through all the stages like development, System test, UAT, PRT and production.
• Mentor/Handling and distribution of work to Offshore Team.
• Gathering Business requirements from the Client and Preparing the Detail Design Documents, and implementing changes.
• Taking care of Release management on rotation bases includes build schedule, communicating with other developers about the progress of their work, and resolving issues to have a successful release.
• Implemented Test driven development using nUnit for Dotnet components.

Environment: ASP.NET, .Net Frame work 1.1/1.0 C#, ADO.NET, ASP, COM+, VB, XML, XSL, JavaScript, XML Spy, SQL Server 2000, MSMQ, Visual InterDev, ATL, ADO, Windows 2003/2000 Server, and IIS 6.0/5.0.

Senior Web Developer

Confidential, NY

Responsibilities:

• Conversion of existing ASP code to ASP.NET.
• Used code behind and in-line coding in ASP.NET for Web Forms.
• Conversion of existing VB components into VB.NET components.
• Converting existing C++ COM components into C# .NET components.
• Developed XML Web Service in VB.NET for B2B Business used for delivering Business documents.
• Developed COM component for generating Commerce server catalogs from the existing Oracle data.
• Implemented Cache COM component to cache product data, and Commerce server site terms.
• Written stored procedures for both Oracle and MS-SQL Server.
• Developed Visual Basic COM+ component to receive documents from BizTalk Message Queue and processing the document using MSXML parser, and then submitting to the BizTalk Channel.
• Developed VB Client program, and ATL COM component for importing the XML data for the Bridge Way System.
• Developing, Administrating, and maintaining BizTalk based Enterprise Application Integration.
• Involved in Business Process Modeling using BizTalk Orchestration Designer.
• Using BizTalk orchestration Designer designed XLANG Schedules.
• Used BizTalk Editor tool for creating the document specification for Business process.
• Used BizTalk Mapper tool for creating mapping business document specification.
• WebDAV used for storage and retrieval of mapping XML, which are used in BizTalk Message Channel.
• Configured BizTalk File Receive function for submitting documents to BizTalk server for processing.
• Code change in asp to use Commerce Server features.

Environment: ASP.NET, VB.NET, C#, ADO.NET, ASP, COM+, VB, XML, XSL, JavaScript, BizTalk Server, BizTalk Mapper, BizTalk Editor, Commerce Server 2000, XML Spy, Oracle 8i, SQL Server 2000, Crystal Reports, Visual InterDev, VC++, ATL, ADO, Visio 2000, Rational Rose, Windows NT Advanced Server 2000/4.0, and IIS 5.0/4.0.

Web Developer

Confidential, New York, NY

Responsibilities:

• Developed various mails sending ASP web pages for user interaction such as registering the new user, modifying the existing user account, and for forgot password feature.
• Coded the server side functionality in ASP and VBScript
• Developed various user feedback ASP web pages.
• Created client-side functions in JavaScript to validate inputs before sending data
• Developed site search using Microsoft Site server with web crawling and database crawling.
• Implemented SSL security to commerce pages.
• Written stored procedures for MS-SQL Server 7.0.
• Created COM component using Visual Basic for exporting reports to Excel.
• Developed Bulletin Board Service and Chat using eShare expressions 4.1 server programming.
• Involved in testing and documentation.

Environment: ASP, JavaScript, COM, MTS, Visual InterDev, eShare expressions 4.1, HTML, Microsoft SQL 7.0, Macromedia Dreamweaver 3, Windows 2000, IIS 5.0, and Site Server 3.0.