Keerthi Yanala

QA Automation Engineer Dallas, TX

Education: Master’s in computer science (Jan 2009) - New Jersey Institute of Technology

Citizenship: India

Working Permit: H4 EAD

Profile

Having over 8 years of automation and manual testing of client/server, DWH, ETL, business intelligence reports (OBIEE) and web-based applications and having experience in different SDLC methodologies namely waterfall and agile.

Handled various phases of implementation life cycle such as requirement analysis, test case design, and functional integration testing and go-live support.

Technical

Testing Tools: Selenium, Postman, Quality Center 10/9.2/11, Rational Clear quest

Databases: My SQL, SQL Server 2008/2005, Oracle, MS Access

ETL Tools: Informatica 8.6.1

Reporting Tools: Business Objects, OBIEE

Web Technologies: C#.NET, ASP.Net, CSS, PHP, and AJAX.

Languages: Java, SQL, PL/SQL, Shell scripting, XML, VB Script, HTML

Experience/Project Work

Client: Southwest Airlines - Dallas, TX

Role: Mobile Web Services / Automation Engineer Duration: Aug 2016 – Mar31 ‘20

Responsibilities:

Analyzed business requirements, mobile specific requirements, and responsible for documenting functional requirements and supplementary requirements in Quality Center.

Involved in extensive web service testing using POSTMAN.

Participate in analysis of Business and functional requirements.

Worked in Agile environment where in we delivered different functionalities of the application in every two weeks of sprint cycle and the stories were tracked using JIRA tool.

Participated in scrum meetings with product owner team which includes both development and QA team to size the user stories based on the complexity of the functionality

Develop Test Plan, Test Scenarios, Test Cases and Test Scripts using MS Word and MS Excel.

Working in the team where Mobile CHAPI (channel API) web services were developed as per the Page API model.

Done extensive testing for the web services JSON validating request and response are matching as per Page API design

Make sure the CHAPI once consumed by the mobile apps are working good as per the business requirements.

Developed Rest Assured Automation Framework and build automation suite using IntelliJ IDEA for Web Services Regression Testing.

Added Assertion in regard to all the validations required for each layer of process so that the Automation suite covers all the possible scenarios.

Checked the logs to identify the cause of the error response occurred when executing the web services.

Perform all aspects of verification, validation including functional, structural, regression, load and system testing.

Report bugs and track defects using HP Quality Center and Jira.

Environment: IntelliJ IDEA, JAVA, Rest Assured, POSTMAN, Quality Center 10.0/11, JIRA, UNIX, CSV files.

Client: NYC DEPT. OF HEALTH AND MENTAL HYGIENE – Queens, NY

Role: QA Analyst /SQL Server Tester Duration: July 2015- May 2016

Responsibilities:

Participate in analysis of Business and functional requirements.

Testing the Finance applications and make sure the functionality is working as per the business requirement.

Worked with Business Analyst, SME, QA lead to analyze the requirement and had BRD, FRD documents to review and make test strategy.

Prepared test plan, test cases by understanding the business requirements, Data Mapping documents and technical specifications.

Worked with HP Quality center/ALM 11 as test management tool for test plan, test cases, test strategy and defect tracking and reporting

Created the test data for interpreting positive/negative results during functional testing.

Tested various SSRS reports which included validating revenue based on area, population for a particular city, borough, and zip code.

Tested PL/SQL procedures that were developed to load the data from temporary tables using sql Server management studio.

Write complex SQL queries for validating the data populated to the application is same as the data stored in different database tables.

Responsible for updating and maintaining the Quality Center for reporting and logging the defects found during functional and regression testing and follow up the bug life cycle.

Perform all aspects of verification, validation including functional, structural, regression, load and system testing.

Report bugs and track defects using HP Quality Center/ALM 11.

Environment: Quality Center11, ASP.Net, Sql Server Management Studio 2012, SSRS 2008/2012.

Client: Starwood Hotels and Resorts - Stamford, CT

Role: Automation QA/Siebel Analyst Duration: Dec 2010- June 2015

Responsibilities:

Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.

Involved in extensive DATA validation using SQL queries and back-end testing.

Worked with database Oracle using TOAD and SQL Developer.

Participate in analysis of Business and functional requirements.

Worked in Agile environment where in we delivered different functionalities of the application in every two weeks of sprint cycle and the stories were tracked using JIRA tool.

Participated in scrum meetings with product owner team which includes both development and QA team to size the user stories based on the complexity of the functionality

Develop Test Plan, Test Scenarios, Test Cases and Test Scripts using MS Word and MS Excel.

Developed Automation Tests using eclipse IDE for Selenium Testing project which was based on page object model.

Wrote few page object classes which used css and xpath locators and also added defensive code to make sure locators are available before executing actions which improved reliability of tests and reduced flappers.

Automation testing jobs were configured in Jenkins to execute 500 or so tests against different environments based on groups such as heartbeat, smoke and regression using selenium grid which had 30 vm's.

Grid helped in executing all the tests in reasonable time and also allowed to execute tests against different browsers such as chrome, Firefox and IE.

Triaged test job failures and logged bugs if needed.

Tests were written to execute different workflows that spanned across multiple pages.

Did data conversion testing from legacy Delphi systems to Siebel Database application

After every sprint cycle end showcasing the functionalities to all business leadership and stakeholders for their feedback.

Had retrospective meetings to discuss what went well and which areas there is scope of improvement based on the previous sprint cycle.

If there are any user stories which we are not able to complete in that particular sprint those will be moved to the next sprint based on the prioritization which is made by product owner.

Tested the ETL process for both before data validation and after data validation process.

Worked with ETL testing for Data Completeness, Data Transformation & Data Quality.

Involved in the whole testing life cycle covering the entire project from initiation to completion

Created the test environment for Staging area, loading the Staging area with data from multiple sources.

Write complex SQL queries for validating the data stored in different database tables.

Making sure the software got delivered with good quality.

Perform all aspects of verification, validation including functional, structural, regression, load and system testing.

Report bugs and track defects using HP Quality Center.

Environment: Oracle 10g, Informatica Power Center 8.6.1, Erwin 4.1, SIEBEL 8.0/8.2, Quality Center 10.0/11, SQL, PL/SQL, JIRA, SQL Navigator, Shell Scripting, Java, Selenium, XML Files, Main Frames, Galaxy systems, CSV files.

Client: Southwest Airlines – Dallas, TX

Role: QA BI /Data warehouse Tester Duration: Aug 2010- Dec 2010

Responsibilities:

Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.

Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.

Involved in understanding the BAW specs, report specification documents and repository spec’s for validating the Siebel data against the OLAP data.

As an ETL tester, responsible for the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project using Informatica, Shell Scripting.

Involved in preparing Test Cases and test data for the validation of the data against the Siebel environment.

Involved in validating the inbound files data against the OLAP table data.

Involved in testing BI Reports developed using OBIEE BI tool both the look and feel of the report and as well the functionality of the reports as per the tech specifications.

Developed Test Cases and Test Scripts for System and UAT Testing

Worked closely with developers and report planners/analysts to ensure that an acceptance criterion is complete and accurate for desired report capability.

Developed and executed test cases and verified actual results with expected results.

Coordinate very closely with the developers regarding functionalities and defects

Design build and test-reports, dashboards, BI Publisher and Microsoft Integration and other functionality within the OBIEE suite.

Tested the reports different types of Customized Reports (Drilldown, Aggregation) Created by OBIEE to meet client requirements.

Performed database testing with SQL queries to verify data integrity using QTP.

Used Quality Center for bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.

Environment: Oracle 10g, SQL Assistant 6.0, Informatica Power Center 8.6.1, Erwin 4.1, OBIEE 10.1.3.4, SIEBEL, QTP 9.0, Quality Center 10.0, Rational Clear quest, SQL, PL/SQL, SQL Navigator, Shell Scripting, XML Files, CSV.

Contact this candidate