SUMMARY:

• Possess 14 + years of Software Application Development /Database Development experience in Developing projects and providing support.
• Over 4 years of database development experience with Microsoft SQL Server 2000/2008.
• Having good knowledge in Extraction, Transforming and Loading (ETL) data flows using SSIS. creating mappings/workflows to extract data from SQL Server and Flat File sources and load into Various Business Entities.
• Handled development of some large/medium - sized applications using Microsoft Technologies for developing Client-Server and Web applications.
• Performed analysis, created functional specs, Design, development, testing, deployment and documentation.
• Provided production support for various applications.
• A self-motivated team player with hands on experience in programming Real time applications.
• Having good knowledge on Six Sigma and ITIL.
• Self-motivated and able to work independently as well as in a group environment with an active Team player attitude.
• Excellent communication, interpersonal and analytical skills.
• Extremely motivated, able to work smoothly even under pressure, meet deadlines in advance, ready to accept new challenges and adapt quickly to new technologies.
• Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, ViewsUser Defined Functions, Cursors and Triggers.
• Hands on expertise on database migrations from MS SQL Server 2000 to MS SQL Server 2008 R2.

ENGAGEMENT OVERVIEW:

Confidential, Cincinnati, Ohio

Responsibilities:

• Create and modify DB2 Stored procedures using Aqua data Studio.
• Execute SQL Statements, Stored Procedures using DB Visualizer.
• Involved in Analysis, Design, Coding, Testing, and Post implementation support phases of the project.
• Major and Minor enhancements in the Enterprise Sales PlanningKroger Category Management Systems Data Warehouse and AUTOAD applications.
• Involved in complete software development life cycle (SDLC) i.e. requirement Analysis & Specification, technical design and Implementation
• Contribute to process improvement initiatives
• Participate in deployment, system testing, UAT (onsite and offshore).
• Used Jira/Infra ticket tracking systems.
• Create Test cases to test the functionality of newly developed features and upload in Quality Center.
• Implemented business requirements in backend using efficient stored
• Procedures and flexible functions, and facilitated easy implementation to the front end applications.
• Debug recurring support issues and come up with permanent solutions.
• Use of CSC Proprietary tools and techniques (GHPAT, GPF) in the project as needed.
• Deploy the developed code base in development environment and perform unit testing.
• Create and Update technical documents and links in SharePoint server.
• Move Data extract shell scripts to Test and Prod Servers by using FileZilla.
• Debug recurring support issues and come up with permanent solutions.
• Create and Update technical documents and links in SharePoint server.
• Move Data extract shell scripts to Test and Prod Servers by using FileZilla.
• Execute Data extract shell scripts using Putty by running UNIX commands.
• To provide 24/7 production support and emergency handling within specified SLA for merchandising applications.
• Utilize the following tools:
• Aqua data studio, DB Visualizer, Putty, FileZilla, JIRA, Infra Quality center (QC)Stash, and Microsoft Visual Studio 2008, MS Access 2010

Environment: C#.NET, VB 6.0,DB2,Unix,SVN,Sharepoint,SQL Server 2008 R2

Operating System Windows 7,Windows XP, Windows 2008

Confidential

Responsibilities:

• Worked on Database migration from SQL Server 2000 to SQL Server 2008 R2.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and Modified the Packages accordingly using the advanced features of SQL Server Integration Services.
• Played a major role in production support of SSIS jobs.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services
• Increased query performance, necessary for statistical reporting by more than 25% after Performing monitoring, tuning, and Optimizing Indexes tasks by using Performance Monitor, Profiler, and Index tuning wizard.
• Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application.
• Worked on table designing, writing stored procedures, triggers, functions in SQL Server.
• Worked on performance improvement of SQL Queries.
• Involved in interacting with the business community to understand their requirements
• Design and developed PL/SQL procedures, packages and triggers to be used by team members.
• Developed packages using DTS.
• Having good knowledge on SSAS and SSRS.
• Created test cases and tested many database components.
• Worked on resolving database related issues.
• Actively involved in Unit testing, System Testing, UAT and implementation during project development.
• Involved in Analysis, Design, Coding, Testing, and Post implementation support phases of the project.
• Worked on Crystal reports for some of the applications.
• Worked on Excel applications using VBA macros.
• Migrated VB6.0 applications into ASP.net.
• Migrated classic ASP applications into ASP.net.
• Developed new applications in C#.net.
• Contribute to process improvement initiatives
• Participate in deployment, system testing, UAT (onsite and offshore).
• Used Peregrine/Infra ticket tracking systems.
• Having good Knowledge on ITIL.
• Involved in complete software development life cycle (SDLC) i.e. Requirement Analysis & Specification, technical design and Implementation.
• Provided support for applications and worked to reduce the support tickets.
• Worked on many enhancements on existing applications to save users time and effort and improve Application performance.
• Worked on Server Migration project from one location to another location.
• Worked on Database migration from SQL 2000 to SQL Server 2008 by converting existing DTS packages into SSIS packages.

Environment: ASP,ASP.NET,C#.NET,VB.NET, VB 6.0,SQL Server 2000, SQL Server 2008 R2,SSIS, DTS packages, DOS,CD Utility

Operating System: Windows XP

Confidential

Responsibilities:

• Coded for Claims Management module.
• Involved in Unit Testing, Debugging and coordinated with Clients for delivery.
• Created Tables and developed database schema scripts, stored procedures and triggers
• Troubleshooting and Performance of SQL Queries and Stored Procedures

Environment: ASP, VBScript, SQL Server 2000, JavaScript, SQL Server 2000

Operating System: Windows 2003 Server

Confidential

Responsibilities:

• Developed Administrator module
• Self Testing.
• Developed database schema scripts.
• Wrote stored procedures and triggers

Environment: VB 6.0, Windows 2003 Server, SQL-Server 2000, Crystal Reports

Operating System: Windows 2003 Server

Confidential

Responsibilities:

• Designed and developed Screens for the project. Involved in calculating Billets, Checking tension of the drives, Displaying Online Data and Generating Reports.
• Developed dll files for the project.
• Developed database schema scripts.

Environment: VB.6.0, ASP.Net, Windows 2000 Server, SQL-Server 2000, TOP Server, OPC, ActiveX Control

Operating System: Windows 2000 Server

Confidential

Responsibilities:

• Designed Screens and coding
• Developed database schema scripts and wrote stored procedures and triggers
• Unit testing

Environment: VB 6.0, SQL-Server 2000

Operating System: Windows 2000

Confidential

Software Engineer

Responsibilities:

• Designed Screens and coding project.
• Developed database schema scripts, stored procedures and triggers.
• Developed dll files and developed ActiveX controls for the project.
• Unit testing

Environment: VB 6.0, TCP/IP Sockets, RS-232

Operating System: Windows 2000