SUMMARY

• Over 7+ Years of experience in Quality Assurance in Information Technology. Involving analysis, both Manual and Automation testing of client server and Web applications.
• Worked as QA Analyst/Engineer, writing and executing test plans and test cases performing all types of testing (functional, acceptance, load, stress, performance, volume etc.)
• Expertise in QA Process and different levels of testing like Functional, Regression and integration testing with business scenarios.
• Expertise in working with Selenium IDE and Selenium Web Driver using TestNG for Automation Testing.
• Experience in writing CSS Selectors, XPath expressions to identify web elements using Selenium Web Driver.
• Experience in Black box testing with a complete QA Cycle - from testing, defect logging and validation of fixed bugs.
• Expertise Automation using Selenium Web Driver with Java.
• Extensive experience in preparing documentation on Testing metrics, change control, QA status Report, QA summary report, QA Test logs, issues Report and Defect control.
• Functional experience with concentration on Use Case modeling using UML, Business Process Modeling, Data Modeling, Technical Training, Software Development methodologies.
• Experience in Installation and configuration of JIRA on Linux distributions operating system.
• Solid Back End Testing experience by writing and executing SQL Queries
• Expertise in working in Agile (Scrum), Waterfall, Spiral methodologies
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling
• Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices
• Excellent hands-on exposure to SDLC lifecycle methodology involving Waterfall, Spiral, RUP, Agile Scrum & amp; Sprint techniques and thorough understanding of Application Life Cycle Management (ALM)
• Expertise in designing the test scenarios and scripting the test cases in order to test the application
• Expert in PERL, UNIX Shell Scripting & SQL writing for several technology needs
• Involved in Developing Data Marts for specific Business aspects like Marketing & Finance
• Creation of test data and Automation of test cases for system and analyzing bug tracking reports
• Expertise Shell Scripting experience on UNIX, Linux and Windows environment
• Good working experience inOracle, Unix ShellScripting
• Extensively strong on databases including Oracle, MS SQL Server, and Teradata
• Strong in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL
• Extensive Experience in Documentum system sizing, installation, upgrade and migration, administration, performance tuning, optimization, development for an enterprise Document Management System and web content management.
• Involved in generating Test Scripts using Quick Test Pro (QTP) for different transactions to execute Functional Testing, Regression Testing and Acceptance Testing
• Experience in testing and writing complex SQL, T-SQL and PL/SQL statements to validate the database systems and for backend database testing.

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, Java, Python, C/C++

Web Technologies: HTML, CSS, Bootstrap, JavaScript

Tools:, Databases & OS Oracle, MS SQL Server, MS Access, Teradata, TOAD, Windows, UNIX, Git, GitHub, MySQL, Android Studio, Docker, ServiceNow, MS-Office suite (Word, Excel, Project and Outlook)

Build Tools & Frameworks: Cucumber, Maven, Azure DevOps, Data Driven, Page Object Model

Testing Tools: Selenium, TestNG, API testing, Postman

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Sr. QA Engineer

RESPONSIBILITIES:

• Prepared test data based on data mapping document.
• Prepared test environment for QA Team to test the developed applications from end-to-end.
• Preparing and supporting the QA and UAT test environments.
• Performed functional testing to identify various critical points in the application and using Selenium Web-Driver with TestNG
• Created Test scripts using Selenium web driver tool.
• Used TOAD for data analysts and SQL Server Management Studio to query SQL Server.
• Used TOAD for Oracle for querying Oracle database tables.
• Have experience in validating the business transformations by writing complex SQL queries
• Expert in Waterfall Lifecycle, AGILE and Iterative project testing methodologies
• Provided Document Management process support for ITS business partners, such as uploading quality system documents to the Document Management System (EDMS).
• Followed the standard operating Procedure for Document Management System.
• Ran main frame JCL jobs to collect the data from Mainframe systems and load them into Oracle Tables.
• Validated out going XML message sagging its components, and monitoring the resulting executable versions.
• Worked on data modeling, data elements and produced data mapping and data definition documentation
• Performed Backend/SQL Test for Insert, Update, and Functions.
• Used Selenium IDE for open-source web testing
• Performed back-end testing and wrote SQL queries using validated functionalities. Creating automation script for backend testing using Selenium and Java.
• Utilize JIRA for maintaining the Test Plans, Test Cases, Test Execution, Defect Management, and Bug Reporting.
• Used JIRA for agile activities like issue management, task board and defect tracking Isolated, replicated, and reported defects and verified defect fixes using JIRA.
• Loaded data into Oracle using SQL loader and validated data
• Excellent knowledge on Agile Methodology.
• Performed the tests in both the SIT, QA and Contingency/backup environments.
• Document Test Plan or Test Cases & Estimates in Confluence.
• Identify high impact scenarios defects by debugging scripts and log those defects in JIRA/Confluence.
• Wrote many SQL/PLSQL scripts to verify data in the DB and verify consistency with application UI
• Written complex SQL Queries to validate the data movement between source 2 target.

ENVIRONMENT: Agile/Scrum Methodology, Selenium, XML, SQL, PL/SQL, TOAD, WinSQL, Oracle, MS SQL Server, Windows, JIRA/Confluence, TestNG.

Confidential, Cleveland, OH

QA Engineer

RESPONSIBILITIES:

• Update and maintain Business Requirements/ User Stories, Test Plan and Test Case in JIRA tools.
• Used JIRA for bug tracking and reporting, also followed up with development team to verify bug fixes and update bug status.
• Maintained all the logs and documents through a Document Management System, Documentum.
• Document Management System was utilized in the access control and management of the requirement specifications produced in this role.
• Perform Data Driven testing with multiple test data inputs with Selenium and MS-Excel.
• Responsible for designing Framework and executing automation scripts using Selenium.
• Ensuring onsite transitions, QA Processes and closure of problems issues.
• Promoted UNIX/Informatica Application releases from development to QA and to UAT environments.
• Prepared Execution procedure document format to prepare the Test cases based on mapping document.
• Ensured that the mappings are correct and Conducted data validation testing
• Managed and executed the test process, using Agile Methodology.
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning
• Tested several dashboards and deployed them across the organization to monitor the performance.
• Used SQL tools to run SQL queries and validate the data loaded in to the target tables
• Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS
• Involved in other test planning meetings and submitted test metrics daily to the management
• Used JIRA and Confluence to maintain documentation and defect logging and tuned performance of nightly ETL Process, improving jobs run time froom6 hours to 4 hours.
• Using various tools to follow processes along with agile methodologies like Confluence, Slack and TFS.
• Document Management in Confluence.
• Implementing Page Object Model (POM) Automation framework with selenium
• Used JIRA to raise defects and submit the tickets to the respective level.
• Acts application test lead in the quality assurance effort to test and implement the web-based billing and Document Management System.
• Performed Teradata SQL Queries, creating tables and views by following Teradata Best Practices.
• Tested the different sources such as flat files, Legacy, Flat files, SQL Server and Oracle to load into the Teradata data warehouse.
• Performed functional testing to identify various critical points in the application and using Selenium Web-Driver with TestNG.
• Design the automation framework for web UI in selenium Web Drive using TestNG

ENVIRONMENT: JIRA/Confluence, Selenium, TestNG, SQL Server, PL/SQL, T-SQL, SQL, Agile/Scrum Methodology, Oracle, Teradata, MS Access. Windows, MS Office.

Confidential, Cleveland, OH

QA Analyst/Tester

RESPONSIBILITIES:

• Created Test plan, Test strategy, Critical scenarios and Test Scripts and schedule for testing.
• Executed Regression test cases, documented test results and reported and tracked defects.
• Performed Smoke testing after the build deployment on a weekly basis after the defect fixes.
• Auditing business and functionality necessity documents and recognized test scenarios.
• Involved in Scrum type of agile methodology testing.
• Performed cross browser and cross platform web testing with Selenium Web Driver.
• Responsible for fixing and maintaining regression automation test scripts for end to end testing using Selenium Web Driver.
• Crested Performance Test plan, approach and strategy documents based on the scalablility scenarious that were given by the business users.
• Extensively involved with backend testing by writing complex SQL queries.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Performing data validation test by running SQL queries in DB2 and SQL Server.
• Performing Functional testing, exploratory testing, Integration testing, System testing, Regression testing, and End to End Testing.
• Proficient with testing REST APIs, Web & Database testing.
• Extensively used web services/API validation tools like RESTful, SOAPUI to validate.
• Expert in Waterfall Lifecycle, AGILE and Iterative project testing methodologies.
• Extensively used test management tool like TestRail and JIRA to develop test cases, test scripts, executing the scripts and tracking the defects, Logging the defects and reporting the defect bug.
• Creating Regression test sets for various test projects and updating the test set after each test cycle
• Excellent knowledge in Software Development Life Cycle SDLC and industry standard methodologies like Agile.
• Executed integration, sanity, white box, smoke, functionality, ad-hoc, regression and UAT testing for multiple products using variable browser/operating systems.
• Performed back - end testing using SQL queries.
• Responsible for customizing Selenium API to suit in testing environment.
• Performed Data driven (TDD) testing to validate the components displayed on the website using Selenium.
• Wrote complex SQL queries in Oracle to perform analysis and validation of data as per user requirement.
• Run the tracking reports, verification reports, and error logs.
• Maintained bug lists for critical issues using JIRA.
• Validated the data on the application against the source system Teradata.

ENVIRONMENT: Selenium, Agile/Scrum Methodologies, Rest API, SQL, Agile, Teradata, DB2, Manual Testing, Web Services Testing, Oracle, TestNG, JIRA/Confluence, XML.

Confidential

QA Analyst/Tester

RESPONSIBILITIES:

• Involved in analyzing system design specifications and developed Test Plans, Test Scenarios and Test Cases to cover overall quality assurance testing.
• Perform both manual and automation testing and created various test results to track the testing results.
• Followed up with standard software testing life cycle (STLC) to perform different types of testing for the projects.
• Participated in peer review meeting for created Test plan, test cases and analyzing various testing documents and process of testing life cycle.
• Responsible for performing manual testing and creating and executing the Selenium scripts and analyze the test results.
• Review manual and automation team work (UFT and Selenium tools) and suggest best practices and process improvements along with resource mentoring.
• Used Control-M for job scheduling.
• Create standard testing life cycle flow diagram for projects and presented to test team to follow testing process.
• Backend testing of the DB by writing SQL queries and PL/SQL scripts to test the integrity of the application and Oracle databases.
• Worked on creating Test strategy, test plan and test scenario for E2E testing.
• Wrote SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Used HP ALM/Quality Center for writing manual test cases and executed them.
• Detected, verified, prioritized, navigated and tracked defects using HP ALM in the software until they were fixed.
• Responsible for writing the test plans and test cases for data migration project.
• Performed UAT testing in the UAT environment prior to notify to the customer to start performing UAT testing.
• Executed E2E testing successfully handled responsibilities of co-ordination with offshore team, estimation, status reporting.
• Participated in defining and executing test strategies using agile methodology.
• Met with client to present future functionality of the application, gather information from them to know about their need and send this information to test manager.
• Worked closely with the application development and design and testing team to resolve technical issues and interacted with them to ensure overall quality of the software.

ENVIRONMENT: Agile (Scrum), HP/ALM Quality Center, Selenium, TestNG, E2E Testing, QTP, XML, HTML, Oracle, SQL, PL/SQL, TOAD, Windows.