SUMMARY

• Over 6 years of IT experience in Quality Assurance and Software Testing of various business applications in Client/Server environments and Data Warehousing solutions.
• Experience in complete Software Development Life Cycle and Software Test Life Cycle and highly proficient inSDLCmethodologies Waterfall and Agile.
• Proven experience in writing Test Plans, Test Scenarios and detailed Test Cases for conducting Functional, System, Regression and end to end testing of applications.
• Hands on experience with test case designing, test execution, defect reporting, triage, tracking, coverage analysis and coordination of testing efforts.
• Experience in both Manual and Automation testing using HP Quality Center, HP Quick Test Professional (QTP) or UFT.
• Experience in developing end to end automation using Selenium WebDriver, J - Unit, TestNG, Maven, JMeter, Web Services (REST, SOAP) using Postman, SOAP UI.
• Have created Test Cases (Test Scripts) using Selenium Webdriver, Java and TestNG
• Have tested several complex reports including dashboards, summary reports, master detailed, drill down and score cards.
• Involved in preparation of RTM, Defect Reports, and Weekly Status Reports.
• Experience in manual testing using ETL techniques and QA methodologies.
• Strong Understanding of Database Management Systems (Oracle, SQL Server) and experienced in writing SQL Queries for Business application to validate Data.
• Experience in loading the data from Flat Files to Database tables for Bulk Loading.
• Great knowledge of an automated functional and regression testing tool IBM Rational Functional Tester
• Proficiency in defect management including defect creation, modification, tracking, and reporting using Industry standard Tools like Quality Center, Clear Quest, TFS, Rally.
• Expertise in problem solving & defect tracking tools like Quality Center and JIRA
• Experience in Data Analysis, Data Cleansing (Scrubbing), Data Validation and Verification, Data Conversion, Data Migrations and Data Mining.
• Knowledge of analyzing and debugging Shell scripts
• Excellent interpersonal, communication, documentation and presentation skills.

TECHNICAL SKILLS

Testing Tools: HP QC, UFT/QTP, Selenium WebDriver, IBM RFT, Postman

Languages: Java, SQL, VB Script

Web Technologies: HTML, CSS, XML, JavaScript

Databases: Oracle, MySQL, SQL Server, MS Access

Application: MS Office, Visual Studio

Operating System: Windows, Unix, Linux

PROFESSIONAL EXPERIENCE

Confidential, Amarillo, TX

Sr. QA Automation Analyst

Responsibilities:

• Involved in organizing daily Scrum meeting with the teams and conducted review of accomplishments, targets and issues.
• Involved in designing automation test suites for regression testing using knowledge of Java programming language and Selenium WebDriver.
• Created Test Cases (Test Scripts) using Selenium Webdriver, Java and TestNG Annotations
• Developed Test cases manually and generated Automation Scripts using open source tool Postman, making the API calls and doing the backend testing
• Worked with Business Analysts, developers while reviewing the Business Requirement Documents and when there are enhancements in the applications.
• Executed automated test scripts/plans and provide defect and usability feedback to the SCRUM team in a timely manner.
• Involved in providing the Testing Effort estimates and provided the timely feedback on progress of the testing.
• Generated the execution results and sent it across to the team, by way of gathering and analyzing the Test Metrics for the purpose of reporting.
• Performed functional testing on the application using UFT and revised automation framework to decrease maintenance of updating automated Test case.
• Reviewed project requirements and worked closely with BA and Development for creating Positive & Negative Test Cases using HP ALM.
• Worked with UFT in customization and creating checkpoints, parameterization and break points for debugging.
• Performed End-to-End testing on the release version of the software application and detected GUI bugs.
• Involved in analyzing the scope for automation and creating shell scripts based on the requirement.
• Updated JIRA with all the changes made to the test case and closed it when all the requirements were met as specified.
• Inserted database checkpoints using SQL queries to validate the backend testing on the application on SQL Server database.
• Involved in generating Matrices Reports and Charts for Defect Analysis to analyze statistical nature of the defects.
• Tested ETL process to push transactional data from source systems into landing tables.
• Developed SQL scripts for verification of data at extraction phase to ensure, transformation phase and loading phase of the data to ensure correctness of the data and also verifying the ETL mapping rules.
• Applied Selenium IDE for Open source web testing.
• Identified the test cases that affect the basic and major functionality of the application to Smoke Test the application.

Confidential, Roanoke, TX

QA Automation Analyst

Responsibilities:

• Created test cases and tested them based on the Business Requirements, Test Scenarios and analyzed the actual results against the expected results.
• Implemented compulsory review sessions to discuss analysis of electronic devices with corporate teams and the inflight entertainment division.
• Tested several complex reports including Summary Reports, Master Detailed, Transaction Reports, Drill Down and Measures.
• Involved in testing the Cognos reports by writing complex SQL queries
• Developed test scripts using SQL queries to validate data.
• Used IBM Rational Functional Tester for compound automated functional and regression testing.
• Prepared mockup data for negative/positive scenarios for functional testing as planned.
• Participated in preparing Requirements Traceability Metrics (RTM), Test Results, Release Check list, Lessons Learned documents.
• Prepared test cases for UI, Integration, Smoke, Regression, Functional, Conversion, and System testing and executed them as well.
• Used JIRA as a defect issue log and defect tracking tool.
• Wrote test cases based on Change Request document & testing as per Change Request.
• Involved in meetings with the development team for closing a defect and also closing a minor cosmetic defect.
• Monitored and validated data flow from front end to back end.
• Performed Data Migration testing to ensure that the integrity of the Data is consistent.
• Validated the data in the Source and also validated the data in the Target as if the data are moving as expected.
• Designed SQL Queries to support backend testing of the DB and validated the data accuracy and integrity.
• Tested the Data integrity in SQL Server for data Inserts, Updates and Deletes.
• Conducted meetings with the UAT team for UAT.
• Enabled enhancement & maintenance of current test environment in Eclipse using Java.

Confidential, Omaha, NE

QA Tester

Responsibilities:

• Involved in entire QA Life Cycle, which includes Designing, Developing and Execution of the entire QA process and documentation of Test Plans, Test Cases, Test Procedures, Reporting and Tracking the defects.
• Used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Converted most of the manual test cases into QTP automated scripts to perform Regression testing.
• Develop Functional/Regression automated testing solutions using QTP, traditional QTP framework, and/or Data Driven techniques.
• Responsible for verifying log files for the submitted application.
• Validated format of the reports and feeds.
• Used Quality Center for Test Cases development and test execution status tracking.
• Created complex mappings involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
• Created SQL stored procedures for dropping and recreating indexes on target tables.
• Involved on testing the new functionality based on test cases and coordinated with development team in fixing the issues.
• Involved in generating Matrices, Reports and Charts for Defect Analysis to analyze statistical nature of the defects.
• Validated cube and query data from the reporting system back to the source system.
• Tested analytical reports using Analysis Studio
• Reported QA team status to senior management and served the team as one source of contact for end to end testing process.

Confidential, Virginia Beach, VA

QA Automation Test Analyst

Responsibilities:

• Design test strategy and test plans for the project for Functional testing, Integration testing and User acceptance testing.
• Develop and execute test scripts for various functions including whole-sale and retail pricing procedures of various brands by region.
• Develop and executed test scripts for volume discounts for distributors, seasonal discounts for retail chains.
• Worked closely with Development team and Business Analyst for collecting the requirements and prepared the Test Plan.
• Performed back end testing by using SQL for interacting with Oracle database to query.
• Test interfaces between order management and payment processing systems to integrate business processes and share data between the systems using SOAP UI.
• Coordinate with cross functional teams
• Used Quality center, Bugzilla, E-track and Remedy for Defect Management.
• Participated in Design Review meeting, projects meeting to discuss the test milestones and test deliverables.
• Performed back-end testing to ensure data was updated in database using SQL queries
• Reported bugs using ClearQuest and followed up with various development teams.
• Maintained Rational ClearQuest defect-tracking tool to submit defects to the application developers along with the release of defect aging reports.
• Provides test execution results and reviewed them with the project team.
• Developed test summary reports when test cycle is completed and prepare test metrics.
• Involved in End to End validation testing of messages
• Logged Defects and conducted defect review sessions with the dev team.
• Reported to QA manager on a daily basis of structured reports and informal meetings outlining issues.