SUMMARY

• Over 7+ years of I.T Experience, 5+ years of diversified experience in Software Testing, Test Automation and Quality Assurance in domains like Banking, Airways, Health and Financial Industry Experiences in analyzing System Functionality, Conceptualization, Design and Implementation of QA Testing Strategy
• Have extensive experience in testing Web based and Client/server applications using Manual Testing and Automation Testing on Windows and UNIX platforms
• In Depth understanding of QA Methodology and Software Development Life Cycle (SDLC), and Software Testing Life Cycle (STLC).
• Developed Test Plans, Test cases, Test Scripts and Test reports for Manual as well as Automated testing for various applications to ensure proper business compliance.
• Excellent knowledge and experience in testing Multi - Tier application architecture and Black Box Testing.
• Experienced in SDLC Methodologies like Waterfall, Agile and Testing Methodologies like Functional Decomposition, Key Word Driven, and Test Plan Driven.
• Diverse experience in Information Technology with emphasis on Quality Assurance, Validation, Manual Testing, Automated Testing using Quick Test Professional, HP Application Lifecycle Management (ALM), Quality Center and Load Runner.
• Technical Proficiency in Oracle 9i/10g, SQL Server 2008/2005, PL/SQL, UNIX and Crystal Reports.
• Extensive knowledge in automation framework such as Keyword driven and Hybrid framework using functional tools like QTP.
• Knowledge in writing Descriptive Programming/VBScript for Automating Test Scripts.
• Diverse work experience in Functionality Testing, GUI Testing, System Testing, Regression Testing, Smoke Testing and User Acceptance Testing (UAT) and Performance Testing.
• Effectively involved in Defect tracking, reporting, reviewing and analyzing test results using Quality Center and HP Application Lifecycle Management (ALM) 11.0.
• Extensive experience in defect management, test status presentation and test data preparation.
• Skills in backend (Relational Database) testing, writing SQL queries, generating reports to ensure data integrity and validating business rules.
• Good communication skills, detailed and results oriented.
• Demonstrated experience in working in teams, capable of maintaining productive work relationships with management, clients, team members, QA testers and other groups.

TECHNICAL SKILLS

Languages: SQL,PL/SQL, Pro*c, C, C++, Java, .NET(Asp.net,Vb.net,C#.net)

Testing Tools: ALM 11.0, QTP 10/9.5/9.2, Quality Center 10.0/9.5/9.2, Win Runner, Load Runner

Databases: Oracle 11g/10g/7.x, 8.x and 9i, SQL server and Ms-Access

Oracle Tools: SQL* Loader, SQL Navigator and Toad

Operating Systems: Win NT and Windows

Scripting Languages: HTML, Java Script, VB Script and TSL

Applications: MS-Office 2000 (Word, Excel and PowerPoint)

PROFESSIONAL EXPERIENCE

Confidential, Durham, NC

Sr.QA Manual Tester

Responsibilities:

• Involved in testing web based Product Application Contract Manager. Developed using Java, J2EE and Documentum
• Responsible for GUI and Functional Testing, using Black Box Testing Techniques.
• Involved in End to End Functionality and Usability testing, Performed stress testing.
• Executed SQL statements to check if the data integrity has been maintained.
• Executed SQL statements to test the integration between application and database
• Performed Backend testing manually using complex SQL Queries and Query Analyzer by connecting to the database server
• Used HP Quality Center to perform Manual Testing and logging and tracking defect in BugZilla until the bug was fixed
• Created Manual Testing strategy and performed Database Testing using SQL Queries by retrieving data from Oracle Database
• Analyzed Manual Test Cases with QA Team for most important & high priority Requirements for conversion to Automated Test Scripts using HP QuickTest Professional (QTP)
• Solid Back End Testing experience by writing and executing SQL Queries.
• The initial testing demonstrated a marked improvement in the End to End testing efficiency.
• Exported the results through SQL and documented the test results for test cases, suites executed.
• Used SQL tools to run SQL queries and validate the data loaded in to the target tables
• Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS
• Involved in extensive DATA validation using SQL queries and back-end testing
• Involved in testing oninterface testing (Backend).
• Full Life Cycle Testing (SDLC) and development of both claim submission and remittance retrievals.
• Closely went through and worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression, and System (End to End), UI Testing, Browser Compatibility, Backend (Database) Testing.
• Strong exposure to the Software Development Life Cycle (SDLC) and extensive experience with QA testing methodologies and procedures.
• Experienced testing Web Services using SOA, SOAP UI, REST & Custom Based Approach.
• Experience in using SOAP Sonar for providing simple, intuitive and comprehensive testing for SOAP-, XML- and REST-based services
• Performed SOA Web Services Test (SOA Test) on project operated within agile environment, with 2-4 week sprints, daily scrum meetings, burn-down charts, task weighting, pair programming, refactoring, presentations and review
• Extensive knowledge on Black Box Testing, Functionality Testing, Positive Testing, Negative Testing and Regression Testing.
• Tested the functional UAT, Sanitary Testing and Regression Testing
• Performed Functional testing, regression testing, performance testing, load testing, white box testing and black box testing using QTP tool.
• Performed Black Box Testing, Security Testing, System Testing, System Integration Testing, Regression Testing, Performance Testing, Functional Testing.
• Involved in testing Restful web services using Soap UI.
• Involved in preparing the Test Plan, Testing migration scripts
• Review of Product documentation and release notes. Involved in testing workflow management system.
• Experienced with Project Portfolio Management (PPM).
• Worked with Automation tool QTP Version 10.00
• Design a systematic migration methodology & develop required software tools for migrating
• Conducted Data Migration and Data Cleansing
• Developed processes for data synchronization and data migration
• Developed shell scripts to automated data migration processes. Analyzed business processes.
• Defect Reporting & Defect Tracking using Quality Center.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Quality Center
• Involved in Identifying of the unused test cases in the Test Plan in Quality Center and prepared a consolidated doc to delete the test cases.
• Used Quality Center as a Defect tracking tool to report the defects encountered while testing. Base lined the Test Plan, Test Criteria & Project Schedule by walkthroughs and review meetings.
• Prepared Traceability Matrix to ensure the adequate coverage of the test cases.
• Participated in Daily Scrum meeting, Stand-up meeting, walkthrough meeting, weekly assessment meetings with business analysts and developers.
• Attended, discussed and submitting work progress report of the week to Project Manager.
• Worked with source version control tool such as CVS.
• Assigned, Monitored and Tracked Tasks of Team Members.
• Successful discussion with all members, Project manager and QA Lead to collect data for automation.
• Updated Test Plans and Test Cases periodically to manage changes in requirements.
• Documented and reviewed User and functional requirements document and participated in design of release schedule.

Environment: Java, SQL,JBOSS application server, Quality Center, NASCO, Oracle 11g,HIPPA, JIRA, SQL Developer, Data migration, Windows 2000 Server

Confidential, Atlanta, GA

QA Manual Tester

Responsibilities:

• Prepared Test Strategy Document and Test Case Document, Requirements Traceability Matrix to map the requirements with their respective test cases.
• Designed and developed detailed Test Plans.
• Created Manual Test Scenarios and Test Scripts by analyzing Functional, Business and Technical Requirements.
• Created Manual Testing strategy and performed Database Testing using SQL Queries by retrieving data from Oracle Database
• Performed Functional Testing, System Testing, Integration Testing and Regression Testing.
• Tracked and managed defects using ALM.
• Used MS Excel to find out the string lengths, count, comparisons.
• Worked on Various SQL Server procedures for various Bugs, executed queries in test databases using SQL queries.
• Executed SQL Queries for testing integrity of data in database (Backend Testing).
• Backend and Database Testing: Oracle, MS-SQL Server, MS Access databases.
• Executed SQL Queries for testing integrity of data in database (Backend Testing)
• Involved in the complete Software Development Life Cycle (SDLC).
• Wrote, prepared and executed Manual Test Cases based on Requirements and Use Cases, and Automated Test Scripts throughout Software Development Life Cycle (SDLC)
• Expertise in various testing methodologies like Black box testing, White box testing.
• Tested Web services (SOAP, WSDL) using SOAPUI
• Tested applications developed on web services - SOAP, UDDI, WSDLSOAPUI and REST based Services
• Performed Load Testing using SOAPUI Test Suite
• Performed Black box testing, White box testing, Grey box testing, GUI Testing, Unit testing, Integration testing and System testing.
• Involved in White Box Testing with the halp of developers and viewed the source code with the halp of Rational Rose.
• Involved in performing Black Box Testing..
• Prepared and contributed in creating Test plan and Test Strategy along with arranging and executing Test Cases for Manual and Automated Testing
• Used SQL tools to run SQL queries and validate the data loaded in to the target table
• Validated the data of reports by writing SQL queries in PL/SQL Developer against OD
• Involved in extensive DATA validation using SQL queries and back-end testing
• Developed, executed, and maintained Test Plans, Test Case, Test Scripts, and Test Data for manual testing approaches using track & defect management tool HP Quality Center (QC).
• Responsible for migration of extensive databases to MS Access utilizing tables, queries, forms, reports, macros, and modules.
• Identify business rules for data migration and Perform data administration through data models and metadata
• Through MS Excel spreadsheet by using built in functions generated counter strings, validated business logic etc.
• Validated the data loaded into the target database which extracted from multiple operational data sources DB2, Oracle, SQL Server and flat files.
• Developed and modified Unix Shell scripts to automate QA execution process in Test environment.
• Developed required SQL scripts for database testing and Performed Backend Testing, by executing the SQL queries. Wrote SQL Queries to extract data from the Tables.
• Analyzed tables and indexes for performance tuning, optimizing database objects and streamlining applications.
• Executed the Test Scripts on different releases and validated the actual results against the expected results.
• Performed Functional and Regression testing using Quick Test Professional.
• Recorded Test cases by inserting standard, page, table, bitmap, and database check points. Parameterized test cases by defining data table parameter.
• Verified the applications expected behavior at different stages by inserting Synchronization and checkpoints using Quick Test Pro.
• Ran JCL Jobs.
• Involved in User Acceptance Testing by providing test data for users and by testing UAT defects in test environment before, the new code gets moved to UAT environment.
• Involved in Test Case Review meetings with business analysts and developers.
• Created Test Execution Report, Test Completion Report for Test Sign Off, documented the testing process and Test evaluation summary.

Environment: BEA Web Logic, SQL, Java, UNIX, SQL Server 2008, XML, Data Migration, MS Excel, ALM 11.0, COBOL and JCL.

Confidential, San Francisco, CA

QA Manual Tester

Responsibilities:

• Worked with the development team to outline solid test processes.
• Prepared Requirements Traceability Matrix (RTM), Test Scenarios and Test cases based on requirements.
• Used Quality Center for Defect Tracking.
• Performed Smoke, System, Integration, Functional, Unit and Regression testing for the web application.
• Debug the problem to determine root cause analysis and provide development team sufficient detail to understand, replicate and resolve the issue.
• Participated in daily meetings, sprint meetings and retrospective meetings
• Used Siebel and BARTT tools for testing the applications.
• Used Siebel tool for generating the PNR for creating Standard, Freedom award, Companion Pass,etc
• Used BARTT tool for generating the PNR for the half flown flights and test the application
• Tested all the enhancements that were done in Select Flights page, Price page, Purchase page and the confirmation page by using the dollars and points.
• Performed analysis of software quality and testing progress to provide status to project team.
• Log the defects and follow up with development team in getting the resolution in timely manner.
• Tested the defects raised by the CTD and Communicated with the CTD and IT project management regarding the defects.
• Participated in test review meetings and provided statuses on testing.
• Manually tested the application functionality and developed Automation test scripts to perform functional and regression testing and prepared automation test scripts, Methods and functions in QTP.
• Performed Manual Testing.
• Used Quality Center for Defect Logging, Tracking and Defect Management.
• Prepared test data.
• Updated weekly status to Project Management (Project Manager, QA Lead) and Involved in Meetings with Development and Business Teams.

Environment: Java, J2EE, Windows XP, SQL, PL-SQL, JavaScript, Struts, HTML, Oracle, Quality Center.

Confidential, Madison, WI

QA Manual Tester

Responsibilities:

• Worked with users to define business process and information systems for supporting those processes and documented the above.
• Defined and communicated system requirements.
• Worked with non-transactional data entities for multiple feeds of reference data using Master Data Management
• Accountable for reading and understanding all systems requirements within deliverables and providing valuable feedback to other analysts.
• Created Manual Test Scenarios and Test Scripts by analyzing Functional, Business and Technical Requirements.
• Prepared and contributed in creating Test plan and Test Strategy along with arranging and executing Test Cases for Manual and Automated Testing
• Performed Functional Testing, System Testing, Integration Testing and Regression Testing.
• Documented Billing and Cash posting processes.
• Developed detailed unit test plans, test scripts and facilitated UAT with the stakeholders and the business users.
• Conducted rigorous testing per requirements and assisted in data mapping.
• Supported design, considering business requirements and system limitations.
• Updated partners and presented options for problem resolution.
• Recognized scope limitations and raised potential scope issues.
• Analyzed business workflow and system needs for Prudential Financial conversions and migrations.
• Responsible to project manage the tasks within a business/systems application, including problem resolution, software engineering standards and quality control standards.
• Developed comprehensive and accurate functional specifications and test plans for a variety of projects.
• Worked in close collaboration with the Project Manager and business users to gather, analyze and document the functional requirements for the various projects. Effectively communicated with both technical and non-technical users and produced project documentation.
• Understood the business processes used to support their needs.
• Worked with project leaders to identify reporting requirements and developed detailed business requirements.

Environment: Windows 2000/NT, UNIX, MS SQL Server, Oracle, Win Runner, Test Director, QTP, MS Project

Confidential -- Newark, NY

QA Tester

Responsibilities:

• Interacted with Client, Business, and Development teams for requirement analysis
• Worked closely with the Business in the analysis of requirements and test to Client needs.
• Analysis of Functional & non-functional Requirements, Business Requirements, Use case documents, and User Interface Specifications for creation of deliverables such as Test Strategy, Test Scenarios, Test Cases and Requirement Traceability Matrix (RTM).
• Created Test Plans, Test Strategies, and Test Metrics/Logs for System Acceptance Testing in HP Quality Center.
• Followed Scenario based approach in writing Test Cases.
• Extensively worked on Gap analysis.
• Handling a team of four, allocating work and preparing status reports.
• Wrote, prepared and executed Manual Test Cases based on Requirements and Use Cases, and Automated Test Scripts throughout Software Development Life Cycle (SDLC.
• Developed, executed, and maintained Test Plans, Test Case, Test Scripts, and Test Data for manual testing approaches using track & defect management tool HP Quality Center (QC).
• Responsible for periodic updating of Test Plans and Test Cases as per Requirement Specifications.
• Driving daily Defect/Bug review meetings with business, environment and development team to understand the problem and setting the severity levels and get resolutions for defects logged by team.
• Tested in Web based Java applications and also Client- server applications.
• Participation in Integration testing, System testing, Regression testing and UAT.
• Development of test plans for execution and maintenance of the test environment.
• Worked with SQL queries for backend verification of Company Blue Bookings & Reporting.
• Developed HTML and JavaScript tools which are used for testing.
• Execution of Automation Scripts for Test Data (reservations) creation for Supersonic Kiosk Check-in Application
• Provided technical assistance to teams in Kiosk Machine/Check-in application questionnaire.
• Verified the Check-in functionality in Mobile devices for Mobile Check-in.
• Attended the weekly Business Requirement Meetings, Project Status Meetings with the Business, Project, Development, and Testing Teams to table the Testing issues and thus bring them to a closure.
• Retested the fixed issues and approved the software changes for enhancements by generating Modification Requests.
• Mentored Interns in QA methodologies and activities, applications under test; trained several members of the team on Quick Test Professional and Quality Center tools by conducting demo sessions and by creating standard operating procedures.

Environment: Java, Java Script, HTML, SQL Server, Quality Center 9.2, MS Word, MS Excel, Quick base, TOAD, Teradata, Unix.