SUMMARY:

• Over 7 years of professional experience in Information Technology with extensive skills in Software Testing, Integration Testing, Functional Testing, Regression Testing, System Testing, Software Design, Development, and Quality Analysis.
• Extensive experience in the entire application Software Development Life Cycle(SDLC), which includes Requirements, Design, Development, System Testing, Configuration, Installation, Release Authorization, and Maintenance Phases.
• Over 4 yr’s experience in the field of Health Care, Banking & Financial Domain.
• Experience in analyzing Business Requirements and Specifications.
• Worked with Development and Business Analysts to define, write and execute test cases.
• Experience in Testing Methodology and Test Plan Formulation.
• Complete understanding of QA methodologies.
• Expertise and experience in performing different kinds of testing like black box testing, functional testing, GUI testing, integration testing, Back - end Testing, System Testing, regression testing and bug tracking system.
• Experience in testing Web, Client/Server and Stand-alone Windows applications.
• Extensive experience in writing Test plans, Test cases/scenarios, Test procedures and analyzing test results for manual and automated tests.
• Extensive experience in manual testing in various environments and using automated testing tools of HP (formerly Mercury interactive) Quick Test Professional (QTP), Win Runner and Quality Center.
• Expertise in problem solving and Bug Reports using Quality Center.
• Strong experience in client interaction and understanding business application and data relations from Product development group.
• Experience in Manual and Automated testing, test schedule planning, test case design, Documentation and Execution. Editing and playback the scripts after fixing the bug.
• Good exposure to RDBMS, SQL and PL/SQL, writing SQL scripts for backend/database testing.
• Extensively involved in Back-end Testing and manual testing using SQL and PL/SQL statements for data manipulation
• Good communication, analytical skills and flexible to learn advancements in the IT industry. Capable of performing multi-tasking and meets deadlines.

TECHNICAL SKILLS:

Testing Tools: Quick test professional 11.0, Win Runner7.0, Quality Center ALM

Databases: Oracle 8i/9i, SQL Server 2000/05

Languages: C, VB Script, SQL, PL/SQL, HTML

Reporting Tools: Crystal Reports 9.0/10.0

GUI: Window Forms, Web Forms

MS: WINDOWS XP/ 7/2003/2008/2008 R2, UNIX

Hardware: IBM, Dell Compatibles

Packages: MS Word, MS Excel, MS Power point

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr.QA Analyst

Responsibilities:

• Analyzed User requirements and documented test requirements, Test Plans, Test Cases using Quality Center.
• Followed Agile Methodology in Project Life Cycle. Participated in stand up meetings and weekly status meetings.
• Managed and conducted System testing, Integration testing and Functional testing.
• Tested the Real Time and Scheduled reports based on the requirements specified by business analyst.
• Extensively used the AutoSys jobs for the entire project.
• Extensively used XML’s for all types of messages to load data in to CDW for verifying ETL logic.
• Automated the test cases for the data loads using QTP.
• Created the store procedures for exporting the results in to Excel sheet’s to data comparison.
• Responsible for designing Framework and executing automation scripts using QTP.
• Managed and conducted System testing, Integration testing, Functional testing, UAT and Regression testing.
• Extensively used the XMLSPY for PXsd data mapping validation.
• Loaded data to different databases using SQL scripts and maintained a repository for data loading scripts.
• Execute batch processing and verify the jobs status and data in database tables.
• Managed and conducted System testing, Integration testing and Functional testing.
• Created the Xml’s for all the HL7 messages types to load the data in to the CDW tables.
• Prepared status summary reports with details of executed, passed and failed test cases
• Worked closely with the business analyst, Pharmacist and Clinical validation for validating the requirements.
• Validation of the reports using SQL queries
• Test data creation is one of the daily tasks to better validate the reports to cover more number of different scenarios.
• Responsible for designing Framework and executing automation scripts using QTP.
• Created QTP scripts to validate the Layout of the report in the regression, by standardizing the input file.
• Participated in business requirements reviews and software system (application) designs for testability.
• Written SQL Queries and executed them using IBM®DataStudio and AQT.
• Attended application walk-through and reviewed Requirements to understand the scope of the project and Attended project meetings as needed and Coordinated with the Developers to resolve the issues/defects
• Uploaded Requirements and Excel Test Cases into Mercury Quality Center. Executed Test scripts from Test Lab manually.
• Involved in System Testing, Regression Testing and Integration Testing
• Worked as a part of team in creating test database and generation of the test data based on different scenarios.
• Created XML Framework for generating xml files from the data sources.
• Created QTP scripts to create and load XML files for bulk loading of Test Database
• Worked on research for finding suitable tool for parsing HL7 Message and loading into database.
• Created Store Procedures to validate the field to field mapping validation.
• Initiated the process for Creating test cases in quality center using reusable modules
• Involved in analyzing functional requirements documents for multiple projects.
• Attended daily meetings, status meetings and defect tracking meetings
• Interacted with developers, Business & Management Teams and End Users.

Environment: Quality Center11.0, Quick Test Pro (QTP11.0), AQT, IBM®DataStudio 2.2.1.1, Business Objects, DB2, ETL, Data warehousing, UNIX Sun Solaris, Java, ASP, XML/SOAP UI Web Services.

Confidential, NJ

Sr. QA Analyst

Responsibilities:

• Involved in different phases of Software Development Life Cycle (SDLC).
• Developed & Implemented Test cases, Test scripts, and Test approach documents based on Business & Functional Requirement documents.
• Developed QTP Scripts using VB Script and Descriptive programming.
• Involved in Customization of Defect Module as per the requirement.
• Extensively involved in conducting the System integration testing, Regression Testing, Backend Testing and GUI Testing.
• Extensively Used QTP to develop the Regression Test Suite.
• Extensively involved in the installation and configuring QC and Quick Test Pro.
• Installed QTP and QC on Client machines installing using exe file and Silent installation.
• Installed QTP11.0 patches on the Client machines.
• Creating new projects and copying the existing Projects in the Quality center.
• Assigning (read/write) permission users to the projects in the quality center.
• Creating users in the Quality center.
• Extensively used Quality Center for Bug Tracking, Test case development
• Performed Data Driven Testing using QTP to test the application with different sets of data.
• Extensively used Share point for the project tracking and assigning the tasks for the team.
• Extensively used SQL Query Analyzer, PL/SQL Developer to do the Backend Testing by writing the SQL Queries.
• Created Entities in the defect module and enhanced the code in the Quality Center11.0 as per the requirement.
• Created and maintained a Requirement Traceability Matrix (RTM) for the applications under test and Customized the RTM as per the Team’s Needs.
• Actively participated in Design Reviews and Weekly Status Meetings.
• Responsible for Coordination with business analysts & developers to discuss issues in interpreting the requirements.
• Responsible for providing Testing Efforts, Estimates & Timely status.
• Coordinated with business team and facilitated for successful completion ofUAT.
• Prepared the System Test Plans and Test Cases for all the Production & Change Management releases.
• Tested Data transmission from SQL Database to Excel, Text & CSV Files and also tested various kinds of Reports based on external vendor requirements.
• Tested Security Module Role Based security for Access Control.
• Involved in developing and generating the Crystal reports for Test cases, Requirements, Execution Summary report.

Environment: Quick Test Professional 11.0, Quality Center ALM, Sprinter, Windows XP, Windows7 &Oracle 11g, SQL 2000/05, HTML, MS-Office 2003/07,10,Toad, Business Objects Crystal Reports, VB Script, Share point, Sprinter.

Confidential, NJ

QA Analyst

Responsibilities:

• Involved in different phases of Software Development Life Cycle (SDLC).
• Developed & Implemented Test cases, Test scripts, and Test approach documents based on Business & Functional Requirement documents.
• Extensively involved in conducting the System integration testing, Regression Testing, Backend Testing and GUI Testing.
• Extensively Used QTP to develop the Regression Test Suite.
• Extensively used Quality Center for Bug Tracking, Test case development
• Performed Data Driven Testing using QTP to test the application with different sets of data.
• Extensively used SQL Query Analyzer, PL/SQL Developer to do the Backend Testing by writing the SQL Queries (Select Statements and JOINS)
• Created and maintained a Requirement Traceability Matrix (RTM) for the applications under test and Customized the RTM as per the Team’s Needs.
• Actively participated in Design Reviews and Weekly Status Meetings.
• Responsible for Coordination with business analysts & developers to discuss issues in interpreting the requirements.
• Responsible for providing Testing Efforts, Estimates & Timely status.
• Coordinated with business team and facilitated for successful completion ofUAT.
• Prepared the System Test Plans and Test Cases for all the Production & Change Management releases.
• Tested Data transmission from SQL Database to Excel, Text & CSV Files and also tested various kinds of Reports based on external vendor requirements.
• Tested Security Module Role Based security for Access Control.
• Extensively used Configuration management using VSS(Visual Source Safe)

Environment: Quick Test Professional 9.2, Quality Center 9.2, Windows XP, Oracle 9/10, SQL 2000/05, HTML, C#.Net, ASP.Net, MS-Office 2003/07, VSS(Visual Source Safe)

Confidential, NJ

QA Analyst

Responsibilities:

• Analyzed the user/business requirements, functional specs and Use Case documents and created the Test Plans, Test cases for System testing.
• Preparation of Test Cases and Automation scripts Extensive testing Using QTP and Quality Center.
• Extensively used Quality Center for Bug Tracking
• Actively participated in System testing, integration testing and coordinated UAT.
• Performed validation of links, browser compatibility.
• Participated in Enhancements meeting to distinguish between bugs and enhancements.
• Documented all test activities as per the organizasition standards.
• Used all necessary checkpoints of QTP to make the reusable scripts on enhancements.
• Performed Functional testing and Regression testing using Quick Test Pro.
• Performed GUI Testing, Smoke testing, System testing, and White box testing.
• Extensively involved in testing core module “Claim processing Data loading”.
• Exported test cases from MS Excel to Quality Center by Manually.
• Performed the Back end testing by using SQL and verified the data integrity.

Environment: Quality Center 9.2, QTP 9.2 (Quick test pro), DB2, VB Script, Java, J2EE, VB, .Net, XML, Oracle, SQL, MSOffice, UNIX and Windows XP

Confidential, CO

QA Analyst

Responsibilities:

• Developed & Implemented Test cases, Test scripts, and Test approach documents based on Business Requirement documents.
• Actively participated in System testing, Integration testing and also active role in coordinating with Business groups.
• Preparation of Test Cases and Automation scripts Extensive testing Using QTP and Quality Center.
• Responsible for Preparing the Bug Reports for every test cycle.
• Responsible for analyzing bugs and reporting to the higher management.
• Automating the Functionality for Regression Testing.
• Responsible for testing the Production Builds.
• Wrote SQL test scripts for Back end testing and verified the data integrity.
• Performed manual testing, automated testing, defect tracking.
• Performed GUI testing, Functional testing, Smoke testing and System testing.

Environment: QTP, QC, Remedy 4.5, Application Server 4.5, JavaScript, Html, Developer 2000,Oracle forms, Oracle reports.

Confidential, NV

Sr. Oracle Developer

Responsibilities:

• Created the detailed Test cases from the business requirements document and meetings with the Business Finance Analysts.
• Conducted functionality testing using Win Runner.
• Generate TSL Script using Win Runner for Automation Testing.
• Parameterized the login and password ids to simulate unique users accessing the application.
• Identifying Test Cases to be run for Regression Testing and conducting Regression Testing as and when new builds were made.
• Customization of Test Director to suite the requirements of the testing effort.
• Reported Bugs using Test Director
• Involved in writing SQL statements to extract data from the database

Environment: Win Runner, Test Director, Manual Testing, SQL 2000, VB.Net

Confidential, DC

Oracle Forms/Reports Developer

Responsibilities:

• Writing Custom Packages to implement various functional areas
• Schedule jobs via Oracle jobs using DBMS JOB.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views in Development and Production environment using PL/SQL and SQL*Plus
• Responsible for Detail Design, Coding, Customization of Reports and coordinate with Onsite Implementation.
• Worked on enhancing both paper and web based reports to have dynamic parameter form, conditional formatting at the Group or Field Level and adding charts.
• Hands-on experience with Oracle Forms/Reports, SQL, PL/SQL.
• Keen focus on performance tuning, testing, and quality assurance.
• Modified database structures including table spaces, tables, views, triggers, stored procedures.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Providing code fixes as well as data fixes for bugs raised in SSP - Confidential QC Calls
• Written extensive SQL, PL SQL code as needed
• Involved in Internal Unit Testing.
• Use of various DBMS packages to reuse code and automate scripts.
• Use of DBMS packages to implement scheduling, Dynamic SQL and Extensive Usage of Ref Cursors DBMS SCHEDULER, DBMS PIPE and utilities.
• Extensive use of Oracle 9i features
• Extensive use of TOAD for extracting scripts from the dictionary
• Extensive use of PL/SQL Collections and Records.
• Created numerous web based Forms and Reports using Oracle Developer 6i.
• Responsible in writing Perl and Unix Shell scripts for customization.
• Responsible System Analysis & Preparing Use cases for the enhancements of the Application.
• Business analysis & Solution Designing for the new enhancements of the Application.
• Creation of Synonyms to create read only objects to maintain the security to give access to specific users.
• Use of Sequences to automate number generation
• Use of different Exception Handlers and also Create Some User defined Exception Handlers.
• Keen focus on performance tuning, testing, and quality assurance.
• Use of Bit map and Function based indexes to improve performance of queries
• Design and development of Interfaces to Integrate modules.
• Use of LOVs, RG, Alerts, Object groups and other important features of D2K

Environment: Oracle 9i, SQL, PL/SQL, Forms 9i, Reports 9i, SQL*Loader, SQL * plus. Windows 98,UNIX