We provide IT Staff Augmentation Services!

Qa Analyst/tester Resume

Jacksonville, FL

SUMMARY:

  • 7 years of experience in Quality Assurance and Manual Testing on web based, Client/Server applications. Expertise in Healthcare, Retail and Banking/Financial domains etc.
  • Well - versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
  • Strong analytical and QA testing skills, capacity for work and diagnostic ability, gathering different kinds of project requirements. Covered Agile and Waterfall models of SDLC.
  • Extensive experience with Functional, GUI, Database, Stress, End-to-End, Integration, UAT, Regression, Load and Performance Testing.
  • Experience in preparing Test Strategy, analyzing the Test Plan, developing detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
  • Experience in using HP ALM/Quality Center, Jira for Bug Tracking and Defect Reporting.
  • Experience in using SOAP UI and REST UI for testing web services.
  • Experience in manual testing process and in creating automation environment using Quick Test Pro QTP.
  • Experience in writing SQL queries to validate data from the database.
  • Expertise in querying and testing RDBMS such as Oracle, SQL server and DB2 using SQL for data integrity.
  • Experience in testing in the LINUX/UNIX and Windows environment.
  • Excellent communication, interpersonal and analytical skills.

TECHNICAL SKILLS:

Databases: Oracle 10g/11g, SQL Server 2008, Teradata

Utility Tools: Toad, SQL Loader, SQL Developer, SQL Server Management Studio

ETL Tools: Informatica 9.5/9.0, SSIS

BI Tools: Cognos, Business Objects 4.0, SSRS

Testing tools: HP ALM, JIRA, SOAP UI

Programming: SQL, PL/SQL, C, C++, Java, Python

OS: Linux/Unix, Windows

PROFESSIONAL EXPERIENCE:

Confidential,Jacksonville, FL

QA Analyst/Tester

Responsibilities:
  • Creating Test case & Test scripts by Agile Methodology.
  • Planned, designed and executed test cases based on requirement specifications document and developed manual test cases for Positive, Negative and Functional testing.
  • Involved in Regression, Functional, Integration and System Testing.
  • Performing the Smoke testing of the build and verifying the fixed defects.
  • Involved in writing detailed Test Cases and Test Scripts using HP ALM/Quality Centre (QC) for Functional and Regression Testing.
  • Analyzed business requirements, data mapping requirement specifications, and responsible for documenting functional and supplementary requirements in HP ALM.
  • Used HP ALM to track and report system defects.
  • Written complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
  • Developed components to retrieve, display and administer the records that are stored into Oracle database.
  • Tested Pl/SQL procedures that were developed to load the data from temporary tables in staging to target tables in data warehouse.
  • Compared and validated Reports Generation with Query Outputs using SQL Scripts and Cognos.
  • Performed quality assurance reviews throughout System Development Life Cycle.
  • Participated in defect review meetings with the team members and improve data quality.
  • Scheduled Review meetings to discuss Test Plans, Test Cases and Test Results.
  • Prepared test data on both database level and UNIX level.
  • Participated in daily Agile/scrum meetings and sprint planning meetings.
  • Written UNIX scripts commands which involve data validation.
  • Interacted with the users to ensure meaningful development of the scripts and simulated real time business scenarios.

Environment: HP Quality Center/ALM, Oracle 11g, SQL, Agile, Jira, TOAD, UNIX, Toad, Sql developer

Confidential,Chicago, IL

QA Analyst/UAT Tester

Responsibilities:
  • Created test cases and test plans for user acceptance testing and system testing based on functional specifications.
  • Analyzed the Functional requirements, Application Design Documents, Interface Specification documents and developed Test Plan, Test Cases, Test Scripts and Test Suites to cover overall quality assurance testing using HP Quality Center.
  • Prepared test data to cover all the test scenarios.
  • Performed End to end testing starting from the source to the report.
  • Conducted and coordinated integration testing and regression testing.
  • Involved in User Acceptance Testing (UAT).
  • Maintained all the test cases in HP Quality Center and logged all the defects into the defects module. .
  • Provided support to offshore QA team by giving them knowledge transfer and helping them with closure of the defects.
  • Tested the messages published by ETL tool and data loaded into various databases.
  • Logged defects using defect tracking tool- Jira.
  • Performed Database Testing using SQL and PL/SQL scripts in TOAD for Oracle
  • Perform web services testing using SOAP UI.
  • Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
  • Wrote Automation test cases and executed it according to the application.
  • Tested the XMLs feeds received from another source which is a third party for data consistency.
  • Tracked defects to closure by coordinating with the dev team.

Environment: SOAP UI, XML, HP QC/ALM, Oracle 10g, SQL, Agile, SQL Server, UNIX

Confidential,McLean, VA

QA Analyst/SQL Tester

Responsibilities:
  • Involved in all stages of SDLC from conception to completion. (Based on Agile).
  • Participated in Test Plan, Test Cases and Test Summary Reports internal and external review meetings with clients and Project Stakeholders.
  • Knowledge with Digital Documentary System (DDS) and verified with each single cycle.
  • Written complex SQL queries and PL/SQL scripts to test the integrity of the application and Oracle Databases.
  • Tested reports on smart phone applications. (IOS, Windows) and some knowledge with Android platform.
  • Developed and executed Test Script and reports results to the development team through QC.
  • Performed Functional, Black box, Integration, Regression testing of the modules.
  • Participated with on shore and offshore team member and resolve the RSD phase.
  • Worked with Users and Business Analysts to define and design Test Scenarios and Test Data.
  • Maintained traceability Matrix for the latest test results information.
  • Extracted data from various sources like Oracle, flat files and SQL Server.
  • Attended walk through, periodic meetings, teleconferences and led discussions on problem resolution
  • Analysis of the test result, identification of defects and preparation of test reports, defect reporting in Quality Center, follow-ups and defect resolutions.
  • Used Quality Center for bug tracking and reporting, also followed up with the development team to verify bug fixes and update bug status.
  • Wrote SQL queries to test Data, Integrity, and Referential Integrity and performed Database Testing for the Application.

Environment: HP Quality Center, Teradata, Oracle, UNIX, XML, SQL, Total System (TSYS)

Confidential,Philadelphia, PA

QA Test Analyst

Responsibilities:
  • Performed the Back-end Integration Testing to ensure data consistency by writing and executing SQL statements.
  • Tested both incremental and initial loads
  • Written and executed SQL queries for the cross verification of data.
  • Verified all the source flat files for the format and data.
  • Performed web services testing (SOAP) using the SOAP UI tool.
  • Performing Web Services Testing calling REST end points using JSON.
  • Managing the RESTful APIs documentation on Swagger.
  • Maintained all test cases on HP Quality Center.
  • Participated in daily scrum meetings and sprint planning meetings.
  • Tracked all the defects down to closure using defects module in HP Quality Center.
  • Interacted with the users to ensure meaningful development of the scripts and simulated real time business scenarios.

Environment: RESTful APIs, JSON, SOAP UI, XML, Agile, Scrum, Oracle, SQL Server, Quality Center, SQL

Hire Now