Reports Quality Assurance Tester Resume
Englewood, CO
SUMMARY:
- Software QA tester with 6 plus years of experience in software design analysis, QA software testing and user acceptance testing.
- Experience with quality assurance testing within ETL and working with Tableau Desktop and Server.
- Domain Experience in Live Meeting Application, Banking, Telecom, Prepaid Telephony, Credit Card Processing in Banking, Finance and Satellite Internet.
- Knowledge of best quality practices like Waterfall, Agile/Scrum, or Iterative testing methodologies.
- Very good knowledge in analyzing the requirements to perform static testing and writing the test cases based on the revised and analyzed requirements.
- Excellent in performing test peer reviews for accuracy based upon company standards.
- Determined if testing should proceed by performing Entrance criteria.
- Experience in performing all aspects of verification including Functional, System, Integration, GUI, Backend, Data Driven, User Acceptance, Validation, Regression in different stages of Software Test Life Cycle (SDLC) using HP Quality Center, QTP, SOAPUI, JIRA.
- Good knowledge in web services testing using SOAPUI/Rest API services and Postman and understanding of HTTP code responses.
- Experience in using SQL DML, DDL, TCL commands in validation of test results, identifying issues.
- Proficient knowledge in rerunning the existing test cases once the bugs are fixed and running complete regression test suites whenever needed.
- Managed the regression test results and reported the execution status to direct management as well as the release management.
- Assisted in UAT testing, involved in passing the UAT concerns across the board.
- Good knowledge in automation testing using Java - based Selenium including Selenium IDE record and play.
- Quick learner and adapt to the new tools and technologies and evaluate their test applicability.
- Familiarity with Selenium locators such as XPath, CSS selector and Id to find web element.
- Tableau desktop Including dashboard creation, report authoring and Troubleshooting, Data sources management.
- Knowledge on creating and editing SQL Queries and Tableau Data sources.
- Knowledge Publishing Interactive dashboards in Tableau Server
- Ability to blend data to create Tableau dashboards.
- Ability to create Action Filters, Parameters and Calculations for Dashboards and Worksheets.
- Have Excellent analytical, problem solving and debugging skills, with order strong ability to quickly learn and comprehend business processes and problems in to effectively develop technical solutions to the requirement.
- Have work experience on Development of Tableau dashboards using Tableau Desktop Tool like Dual Axis, Bar Graphs, Scorecards, Scatter Plots, Pie-Charts, Heat Maps, Tree Maps and Geo Maps.
TECHNICAL SKILLS:
Operating Systems: Mac OS, Linux, Windows 10, Windows XP, UNIX, MS Dos, Windows 2000Windows 95/98
Testing Tools: ZEPHYR, HP Quality Center/ALM 11.0, QTP/UFT, Postman, SOAPUIEclipse Neon, Selenium IDE, Cygwin, puTTYJob Function Requirement Analysis, Manual/Automation TestingDocumentation, Maintenance.
MS Office: Excel, PPT, Word, Access, Outlook
Protocols: HTTP, HTTPS, Web Services etc.Reporting Tools
Cognos, Crystal Reports: Data Management /Visualization Tools
Tools: phpMyAdmin, Oracle 10g, 11g, MySQL, SQL Server 6/7.0, MS Access, HeidiSQL, MySQL Workbench, Toad, PL/SQL Developer, PostgreSQL, pgAdmin, Dbeaver
Languages: HTML, XML, JAVA, SQL
PROFESSIONAL EXPERIENCE:
Confidential, Englewood, CO
Reports Quality Assurance Tester
Responsibilities:
- Worked in an Agile Environment in analyzing data and testing Sox Compliance Reports, Operational Reports and Customer Communications Reports.
- Participated in Grooming, Sprint planning, Daily stand up, Review and Retrospective meetings as part of the Scrum environment.
- Coordinated with Business Users to understand business needs and implement the same into functional Data warehouse design.
- Analyzed business requirements, system requirements and data mapping requirement specifications interacting with Users, business Analyst, developers.
- Estimated the level of effort (LOE) for testing in each release and changes.
- Involved in preparing Detailed ETL Test Cases according to the data mapping documents.
- Responsible for developing test case procedures and maintaining test documentation including Sox compliance documentation.
- Generated test cases, test steps using Zephyr Test management tool.
- Tested reports for cosmetic and data requirements.
- Performed test activities and defect tracking using JIRA.
- Created input files to run the report directly on data for tests.
- Performed all aspects of verification, validation including functional, structural, Retesting, regression, and User Acceptance Testing.
- Involved in validating new functionalities based on test cases.
- Conducted user acceptance testing to ensure that developed reports satisfy the needs of business as specified in their functional requirements.
- Coordinate with business analyst and development team in resolving the issues.
- Worked on a project with source and target data in different databases and environments.
- Created Test data for the requirements and validated the data after the report is run.
- Validated the requirements and tested several business reports generated from PL/SQL Developer.
- Extensively test the reports for data accuracy and ETL related errors.
- Validate report formats, column header, run date, time and data accuracy etc.
- Tested the ETL process for both before data validation and after data validation process.
- ETL Data validation using SQL and data verification as per the requirements.
- Used Toad and PL/SQL Developer for querying the data loaded into various database tables.
- Developed queries using joins in Toad and executed against Oracle.
- Using SOAPUI created automation test suites to test data threshold on the plans.
- Involved in Release support -Release to QA, involved in environment setup, testing the release process.
- Validated the data using Internal UI tools like SPYGLASS, FSM, SUPPORT PORTAL(PGUI), RETAILER PORTAL., RB(CAM)
- Verified and Validated the data using Internal Databases like DWRPT, WBA, FSM, RB, VB, Openet.
Confidential, Greenwood Village, CO
Software QA Tester
Responsibilities:
- Followed Agile/Scrum methodology in developing and testing ARRAY application.
- Participated in daily scrum meetings to discuss the daily work progress and roadblocks.
- Involved in sprint planning meetings and feature grooming meetings to discuss key essence of features as a team.
- Participated in Retrospective and Review meetings to discuss what went well, what did not go well, how can we improve to overcome previous issues.
- Created detailed Test Cases based on the user stories.
- Used Zephyr Test Management tool for creating Test cases.
- Tested the new functionality thoroughly based on the test scenarios created.
- Tested happy paths, negative scenarios and if any edge cases found for the acceptance criteria.
- Executed the related test cases against the new functionality.
- Logged defects for the failed test scenarios against the new user story.
- Retested the bug fixes and revalidating whole feature.
- As the Application consisted of different apps, involved in testing the functionality in all the apps.
- Executed Smoke tests for the build to ensure that the high-level functionality of the Feature is covered.
- Performed compatibility testing for Array Admin on different browsers (IE, Chrome, Firefox, Safari) and different Operating Systems (Mac OS, Windows)
- Performed Database testing to make sure each Activity is created, and the data is inserted into appropriate tables.
- Conducted end to end System Testing in evaluating Admin Activity with decks is pushed from admin dashboard to client app.
- Tested out each socket event between Admin app and Client app to make sure each event agenda is correctly pulled to the client app.
- As part of integration testing, tested the API functionality and validated if API meets expectations in terms of reliability, performance, and security of the Application.
- Experience in RESTFUL web service testing using Rest Assured framework with Java.
- Validated JSON formatted data, different http status code like 200,201,400,415,500 etc.
- Create test strategy, test plan, and put into execution for both UI and REST API’S.
- Independently developed project specific functions to interact with Rest API service and external data sources such as Excel sheet, JSON, and XML files.
- Built an automation test plan and framework from the ground-up, utilizing multiple testing technologies including Selenium (Java), TestNG, Maven and the Page Object Design Pattern.
Confidential, Englewood, CO
Software QA Tester
Responsibilities:
- Participated in Agile/Scrum methodology that consisted of two-week sprints which focused mainly on Sprint ceremonies.
- Involved in sprint planning, daily stand ups, backlog grooming, retrospective meetings, review meetings.
- Analyzed the Business Requirement Details and prepared detailed test cases.
- Prepared Test cases in Zephyr for the Admin, Scorer and the Customer Facing UI modules.
- Participated in both internal and external Peer Review to make sure all Test cases are covered for the application.
- Gave feedback and made corrections from the input which is received from the peer review meetings.
- Performed Traceability matrix using Jira/Zephyr to ensure that all requirements are mapped to test cases.
- Conducted Smoke tests as part of Entrance criteria to make sure no high severity concerns are found.
- Tested Admin, Scorer, customer facing modules to check high level working of the functionalities.
- Logged, tracked the defects and performed retesting and regression testing in Spira Test, and JIRA.
- Verified the database by writing SQL queries and compared the reflected data updates against GUI.
- Checked the changes made in the front-end are affecting the backend by tracking the UNIX log file.
- Performed UAT and reported test escapes, user training issues and wish list to Cric drive team.
- Automated the login, new match, add fixture, add squad and assign match to the scorer pages using Selenium WebDriver in Eclipse Neon framework.
- Involved in testing REST services using Postman and tested both XML and JSON formats.
Confidential
QA Test Engineer
Responsibilities:
- The vHome project will provide following features to the Verizon customers: Caller ID, incoming call logs, Outgoing call logs, unified messaging, click to call, special ringing, family mail, listen to e-mail, ringback tones and calendar. Application features provides Verizon subscribers to use single device to see their Caller ID incoming call log, see all outgoing call logs, listen to voicemail, place a call with one click and update their features on a browser and client interface.
- Validated if all the functional requirements have been implemented in the application.
- Involved in the Analysis, Design, and development of vHome Application.
- Created hundreds of test cases for positive and negative test scenarios in Quality Center based on requirements.
- Followed the Agile Methodology during each release of the product.
- Provided guidance for Test Planning and Test Execution along with defect root cause Analysis and reporting.
- Followed the Test Defect Life Cycle using the QC/ALM.
- Reported and validated the test defects during the testing cycle.
- Participated in defect management of UAT with the project management team to ensure defects are fixed in a timely manner in order facilitate timely completion of UAT.
- Performed the black box, functional, cross-client, Manual and Automation testing on the application.
- Worked with the Product Development team to understand the requirements and helped them with the new requirements if any.
- Supported the smoke test on mobile devices with different operating systems versions in different environments.
- Worked on SOAP UI, Postman as part of Soap/Rest API calls Testing.
- Modify/Rewrite the parameters in the Json files to create different error scenarios.
- Capture the logs using Splunk and reporting to the dev team for errors and exceptions.
Confidential
QA Analyst
Responsibilities:
- Collected software requirements and specifications perform feasibility analysis and proposing alternatives.
- Kept track of the new requirements / changes in requirements of the Project.
- Identified critical Test transactions and developed automated SOAP UI Test Scripts.
- Performed the black box, white box, unit, functional, manual, automation, regression testing.
- Involved in verification of data correctness in the database while running unit and data driven tests.
- Wrote the SQL Queries to test the validity of the data.
- Followed the Test Defect Life Cycle using QC.
- Report and validate the test defects during the testing cycle.
- Interacted with multiple business operation teams for UAT testing to analyze the requirement gaps.
- Supported for deployment by doing the smoke testing and key support for user testing.