Qa Analyst Resume Profile
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
