We provide IT Staff Augmentation Services!

Qa Analyst Resume Profile

4.00/5 (Submit Your Rating)

Quality Assurance Analyst

Skills

SQL querying knowledge of SQL Server 2005 and above

6 Years

2 - Proficient

SQL querying knowledge of Oracle 10g and above.

6 Years

2 - Proficient

Ability to write complex SQL scripts to accomplish data conversion/validation testing

6 Years

3 - Expert

Complete working knowledge of SDLC and STLC lifecycle model

6 Years

2 - Proficient

Basic knowledge of performance tuning of long-running SQL queries with Oracle SQL Server

3 Years

1 - Basic

Experience developing and documenting analyses of business needs

3 Years

2 - Proficient

Experience with test plans and test cases.

6 Years

2 - Proficient

Produce reports of testing results.

3 Years

2 - Proficient

Development of recommendations for fixes and database performance and tuning optimizations to programmers

6 Years

2 - Proficient

Development and execution of automated test scripts for regression testing and retesting as required

6 Years

2 - Proficient

Experience in Windows or Linux

3 Years

2 - Proficient

Experience in automating data validation processes in similar data conversion projects

3 Years

2 - Proficient

Experience with SharePoint desired

3 Years

2 - Proficient

Experience with Microsoft Project

3 Years

2 - Proficient

Experience with scripting procedures/languages to automate and speed up project tasks

3 Years

2 - Proficient

Employment History:

Confidential

Test Engineer

Responsibilities:

  • Documented Master Test Plan and scheduled tasks over Microsoft Project Planner
  • Worked with Microsoft Sharepoint for accessing the documents.
  • Worked with Business Analysts and Developers in gathering requirements analysis for the development of Test Plan, Test Cases and Test Reports.
  • Worked on the setup of Automation Testing Framework using data driven approach.
  • Implemented ATDD Acceptance Test driven Development model with testing.
  • Prepare Test data for application testing as per system specifications. Mapping process functionalities to test cases and test scenarios.
  • Followed up with standard software testing life cycle STLC to perform different types of testing for the project.
  • Data analysis for multiple cycles of conversions.
  • Developed Test plan and Test cases using Functional Specifications.
  • Performed Regression testing using Quick Test Professional automated test scripts.
  • Maintained the defect reports in JIRA.
  • Worked with client to establish and maintain a consistent test methodology. Coordinated with development team/client to generate/get test data and leverage best practices like standardized templates and defined test methodologies
  • Performed tuning of long-running SQL queries with Oracle DB MS SQL Server.
  • Performed Mirror Test before sending the files to drop into the Production.
  • Prepared test data for the UAT as per the specifications of BRD.
  • Performed data validation testing using TOAD and SQL scripts.
  • Wrote complex SQL scripts to accomplish data conversion/validation testing efforts on the project.
  • Reporting the test results Certifying a test as either Pass / Fail. Doing Analysis on results
  • Analyzed web user demographics and work flows to create web pages that enable users to complete tasks logically, quickly, and accurately, including finding information, transacting business.
  • Contributed and prepared the scripting procedures/languages to automate and accelerate project tasks.
  • Defined the Quality Assurance Metrics.
  • Created Status Reports template and prepared Weekly Status Report
  • Performed functional testing for new release enhancements.
  • Reviewed the project requirements and technical specifications.

Environment: Selenium 2, SoapUI, XML, Eclipse, JBoss 7.x, Edit plus, Oracle 10g, SQL Server 2008, PL/SQL, ETL, TOAD, JIRA,SDLC, Windows, Unix.

Confidential

Test Engineer

Responsibilities:

  • Analyzed business requirements, functional specifications and system requirements
  • Wrote Test Specifications, Test plans, Test Cases and defined Test Strategy.
  • Prepare the Requirement Traceability Matrix RTM .
  • Defined validations to be built into application in line with the functional requirements.
  • Created Keyword Driven Automated Frameworks using Selenium RC configured under Eclipse JUnit environment.
  • Followed up with standard software testing life cycle STLC to perform different types of testing for the projects
  • Used TOAD as a database interface to test Complex SQL queries
  • Review the test cases written for integration and functional testing as per the scenarios created.
  • Recording the scripts as per the test cases written.
  • Log all issues and risks during the functional testing process and work closely with other teams in fixing them.
  • Performed tuning of long-running SQL queries with Oracle DB MS SQL Server
  • Verified the fixed CRs and tracked them to closure.
  • Enhanced QA assessment frame work, and conduct reviews with various projects and teams for effectiveness of and adherence to quality processes.
  • Documented Master Test Plan and scheduled tasks over Microsoft Project Planner
  • Ensure process compliance. Track and report metrics of the team to the PM and Client. Provide data to PM for PDMR generation.
  • Performed Unit, Integration, System, UAT and Regression testing.
  • Performed database testing by executing the SQL scripts.
  • Worked with Microsoft Sharepoint for accessing the documents.
  • Evaluated comprehensiveness, testability and usability based on project requirements and system standards.
  • Wrote complex SQL scripts to accomplish data conversion/validation testing efforts on the project.
  • Contributed and prepared the scripting procedures/languages to automate and accelerate project tasks.
  • Report and maintained application bugs and errors, verified fixed defects, and prioritized outstanding defects.
  • Performed Bug tracking and reporting using Mantis Tracking System.
  • Query Solving status meetings with Client Business Analyst Developer's .
  • Wrote product documentation, including online help user manual, and training materials.

Environment: Soap UI, Eclipse, JUnit, Tomcat, Bugzilla, Oracle 10g, SQL Server 2005, SDLC, TOAD, Windows, UNIX.

Confidential

QA Analyst

Responsibilities:

  • Analyzed business requirements, functional specifications and system requirements.
  • Worked with IT department to develop appropriate QA environments for each project.
  • Importing Test Cases from MS word and Excel to Quality Center 9.0 using Add-ins.
  • Moving QTP 9.0 Scripts to QC 9.2 and associate the appropriate Repositories.
  • Responsible for Smoke test automation for the new builds using Quick Test Professional 9.0.
  • Verifying the functionality using Black Box Techniques on various scenarios Platforms .
  • Involved in the analysis of requirements and did modifications for existing test plans and test cases.
  • Installing/Uninstalling and upgrading the product on different hardware platforms and software configurations for the new builds.
  • 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.
  • Documented Master Test Plan and scheduled tasks over Microsoft Project Planner.
  • Verifying the data and behavior of the product for Pre-Upgrade and Post-Upgrade Scenarios.
  • Responsible for identifying the functional test cases for Regression Testing and automated these scripts using Quick Test Pro.
  • Database Testing done on SQLServer 2005/2000 and Oracle 10g/9i and MS-Access.
  • Logging and tracking Defects in Clear Quest, verifying the QA ready CQ items and closing
  • Backend Testing done on Red Hat Linux 3.0 using Oracle 10g and Oracle 9i.
  • Devised improvements to current procedures and develop models of possible future configurations.
  • Wrote complex SQL scripts to accomplish data conversion/validation testing efforts on the project.
  • Contributed and prepared the scripting procedures/languages to automate and accelerate project tasks.
  • Ensuring correct stakeholders are engaged and they understand their accountability.
  • Co-ordination with peers for executing the interdependent test Scenarios.
  • Performed Root Cause Analysis providing appropriate documents for incidents raised by users as a part of the Application Maintenance activities.
  • Define and track QA metrics such as defect densities and open defect counts

Environment: QTP 9.2, Quality Center 9.0, Clear Quest, Web Sphere 5.1.x, Jetty 5.1.3, JRun,

Crystal Reports 11, Oracle 10g/9i, SDLC, TOAD, SQL Server2005, MS-Access, Red Hat Linux3.0.

Confidential

QA Analyst

Responsibilities:

  • Defining a test automation strategy, plan, coverage analysis Effort estimation.
  • Worked with IT and development staff to gain knowledge and resolve questions in preparation for and during the testing phases.
  • Involved in the analysis of requirements and did modifications for existing test plans and test cases.
  • Develop skills and relevant test automation roles.
  • Test to ensure products and services meet company standards.
  • Record and Playback using QTP.
  • Selecting which tests to automate and converting from manual to automation.
  • Selecting the most appropriate test scenario to be automated to get the maximum return on the automation investment.
  • Database Integrity Testing in SQL Server 2005
  • Design flexible scripts keeping long term maintenance/Updating in case required considerations with minimal manual intervention.
  • Followed up with standard software testing life cycle STLC to perform different types of testing for the projects
  • Process automation, metric analysis and Weekly status reports preparation.
  • Provided high level picture in testing a product and find loop holes where the product has not been tested or where the product code violates the spirit and/or the documented letter of the Design and requirements.
  • Update and install new releases of testing tools used by the QA automation group and keep aware of new developments.
  • Obtain feedback from QA leads on projects, analyze performance data and provide management reports on the effectiveness of the QA system. Evaluated data for trends and initiate corrective actions.
  • Test environment preparation - test data Framework Enhancements.
  • Risk-based test planning and management: sizing and resource planning.
  • Prepare and manage the project software system quality assurance plan.

Environment: QTP 9.2, QC 9.0, Bugzilla, TOAD, Oracle 10g, SQL Server 2005, SDLC, Windows, UNIX

We'd love your feedback!