SKILLS

• SQL querying knowledge of SQL Server 2005 and above.
• SQL querying knowledge of Oracle 10g and above.
• Ability to write complex SQL scripts to accomplish data conversion/validation testing
• Complete working knowledge of SDLC and STLC lifecycle model
• Basic knowledge of performance tuning of long - running SQL queries with Oracle & SQL Server
• Experience developing and documenting analyses of business needs
• Experience with test plans and test cases.
• Produce reports of testing results.
• Development of recommendations for fixes and database performance and tuning optimizations to programmers
• Development and execution of automated test scripts for regression testing and retesting
• Experience in Windows or Linux
• Experience in automating data validation processes in similar data conversion projects
• Experience with SharePoint
• Experience with Microsoft Project
• Experience with scripting procedures/languages to automate and speed up project tasks

EMPLOYMENT HISTORY:

Confidential, Piscataway, NJ

ERP Migration/QA Lead

Data Migration is to Confidential from Confidential and Baan legacy systems. It has three major areas like historical data, base data and Dynamic data. Entire project testing activities managed by HP Quality Center 10

Responsibilities:

• Managed testing activities for Confidential to Confidential Data migration with team of 4 onsite and 6 offshore resources.
• Involved in Data Migration strategy planning
• Co-ordinate Data Migration activities from BaaN to Confidential .
• Planning for Data migration testing.
• Prepared Test Cases that provide a detailed list of conditions under which the system will be tested using Mercury Test Director.
• Followed up with standard software testing life cycle (STLC) to perform different types of testing for the projects.
• Worked with Microsoft Sharepoint for accessing the documents.
• Tested bug fixes and performed extensive Regression Testing on each test cycle
• Manage Multisite (North America, India, and Singapore) teams for Data Migration testing activities.
• Written complex SQL procedures for data extraction and for data migration testing.
• Manage administration and security testing activities for Confidential, Confidential .
• Involved in Quality center site admin activities.
• Responsible for Quality Center (QC) Admin activities which are QC Admin project
• workflow creation, QC Customization for various Project, QC Migration, Project creation etc.

Environment: Confidential, BaaN, Confidential, Delphi, .Net, Sysbase15, Oracle11i, SDLC, Windows 2003 Server.

Confidential-Piscataway, NJ

QA Lead

Confidential is a Confidential in-house ERP product. This has the functionality for entire manufacturing operations like placing orders, order processing, and repair process till shipment of those orders. It communicates with Baan in financial operations. Based on business needs it has internal projects like FedEx shipment consolidation.

Responsibilities:

• Preparing of Test Plans and Test Summary Reports.
• Conducting CCB meetings and analyze the work orders created by the users.
• Involved in Project Estimation for various projects in BaaN.
• Followed up with standard software testing life cycle (STLC) to perform different types of testing for the projects.
• Documented Master Test Plan and scheduled tasks over Microsoft Project Planner
• Interface testing with third party applications like FedEx servers.
• Involved in Data Validation testing with Legacy Systems.
• Prepared Test Cases that provide a detailed list of conditions under which the system will be tested using Mercury Test Director.
• Tested bug fixes and performed extensive Regression Testing on each test cycle
• Bug tracking using Teamtrack and Trackit tools.
• Created and maintain documents in Agile.
• Experience in writing Data Driven Test scripts in Quick Test Professional from scratch by hand scripting to make the best use of the native functions and reusable functions
• Worked on SharePoint portals to share documents (check in/check out) Process.
• Backend testing using complex SQL queries.
• Install, Configure and administration of QC and testing tools.

Environment: Delphi, HP Quality Center9.2, .net, Sybase15.0, VSS, Agile, SQL Server2005,Oracle 10g,SDLC, Windows 2003 Server.

Confidential-Rye, NY

QA Lead

Working as a QA Lead for various B2C and B2B Applications. It includes Web Office, DLM Canada Pilot, Confidential Conference, Inside Confidential, Confidential Redistricting, and YesMail, eMail Deliverability and WebE.

Environment: .NET, SQL Server2005, VSS, Test Director, Bugzilla

Responsibilities:

• Leading of 11 members offshore and 4 members’ onsite technical teams.
• Preparing of Test Plans and Test Summary Reports.
• Involved in Project Estimation and developing framework to automate GI3 application.
• Interface testing with third party applications like iCentris and eWay Direct.
• Involved in Data Validation testing with Legacy Systems.
• Involved in database testing using SQL queries and functions.

Confidential

Confidential

Senior Systems Engineer

Confidential is a product from Confidential HS which is an n-tier web-cum-client/server based application and is flexible to design custom workflows suiting any requirements. The product consists of modules like ADT, Orders, Lab Integration, Results, Nursing, Medication and Charge Capture modules with interface to external applications industries.

Responsibilities:

• Analyzed the Business and System Requirements for various modules of the application.
• Involved in gathering requirements from users and performed the data mapping as per the specifications.
• Part of Agile-Scrum team for Pharmacy module.
• Tested different UI screens using HTML/JSP/SWING/APPLET and user validations using JavaScript.
• Executed SQL scripts Database to validate data which flows to the end user with the actual data in the Database.
• Tested bug fixes and performed extensive Regression Testing on each test cycle
• Involved in the analysis of requirements and did modifications for existing test plans and test cases.
• Experience in writing Data Driven Test scripts in Quick Test Professional from scratch by hand scripting to make the best use of the native functions and reusable functions
• Parameterized and correlated the scripts and enhanced them according to the User Profile using Quick Test Pro.
• Documented Master Test Plan and scheduled tasks over Microsoft Project Planner
• Performed regression testing for the application and maintained a database of regression Scripts using Quick Test Pro.
• Execution status was taken and reported periodically using Skyview reports.
• Calculated and analyzed the Average CPU usage, Response time for each scenario.
• Conducted system testing in the sys test environment to detect defects and ensure conformance with the requirements prior to code migration to UAT.
• Entered the bugs in a tracker system, which is maintained in a database using Rational Clear Quest.
• Defects were tracked, reviewed, analyzed and compared using Quality Center.
• Responsible for computing a patch to update or fix problems within a supporting data.

Environment: Quick Test Pro, Quality Center, Rational ClearCase, Rational ClearQuest, Java,J2EE,JSP/Servlets, JavaScript, JProfile, VBScript, HTML, Windows 2003 Server, Windows 2000 clients, SQL Server 2005,Oracle10g,Visual Basic 6.0, C++, Web Services, XML,ISS,CSS/XSLT,TOAD, Windows 2000/NT/XP,SDLC

Confidential

QA Analyst

SMS is an n-tier web-cum- client/server based application and is flexible to design custom workflows suiting any requirements across the globe with its smart and intuitive UI. SMS is designed to enhance the patient care experience, and to enhance patient care throughout healthcare network. The product consists of modules like ADT, Billing, Patient Consultation, Nursing, Blood bank, Order communication, Pharmacy, SCM, and LIS with Patient Consultation being web-based.

Responsibilities:

• Review and Analysis of Business requirements, Functional Requirements documents to

understand the AUT in a better way.

• Involved in the analysis of requirements and did modifications for existing test plans and test cases.
• Prepared Test Cases that provide a detailed list of conditions under which the system will be tested using Mercury Test Director.
• Created and executed Functional, Security, Usability test cases.
• Designed the Multiuser scenarios with various user-mixes to perform Multiuser testing of the application.
• Report and maintained application bugs and errors, verified fixed defects, and prioritized outstanding defects.

Environment: Windows 2003 Server, Windows XP clients, SQL Server 2000, Visual Basic 6.0, C++, Java, Mercury Test Director 7.6, Rational Clear Quest.

Confidential

QA Engineer

• Written test script and test case
• Execution of test cases.
• Locked defects in Defect tracking tools.
• Involved in review meetings.