SUMMARY

• Having 7 years of experience in Software Test Services, worked in web based applications, client/server application associated with multiple client accounts.
• Highly efficient in Agile Scrum methodologies and the Process involved through out the deliver of the Product
• Experience in Selenium Automation Testing using WebDriver API’s and test Frameworks using TestNG/Junit, Maven build tools.
• Proficient in testing automation with BDD framework using Cucumber, Gherkin, Junit and Selenium WebDriver
• Experience in writing features and scenarios using Gherkin scripting language.
• Extensive experience on designing, developing andmaintaining TestSuite
• Proficient in creating automation scripts from scratch.
• Sound knowledge of developing different type of framework like Page Object Model, Module driven, Data driven, Behavior Driven Development (BDD) and Hybrid framework.
• Proficient in SDLC Models and STLC process (phases includes Analysis, Planning, Test Design, Execution, Defect Tracking and Test Reporting)
• Working closely with Scrum/Program team. Co - Ordination with Business Analyst/Product, Design Team and Technical team to ensure Gaps and Risks are identified and mitigating them in earlier stage of the Project development.
• Proficient in creating business based functional Test Scenarios, Test plans, Test cases, Test Scripts, Test Specifications and Traceability Matrix including both Manual and Automation testing of the applications.
• Excellent grasp of basic SQL queries with Oracle and SQL Server databases and experience in back end/database testing.
• Proficient in Web Services testing (testing XML requests and responses) using SOAPUI
• Designed and implemented test data repository (combination of database, excel workbooks and text files) for efficient storage organization and retrieval of test data.
• Strong experience in using test management tools HP ALM and Jira, Zephyr plugin.

TECHNICAL SKILLS

Tools: Selenium Web Driver, JUnit &TestNG,Cucumber,Appium

Database: Oracle, SQL Server

Methodologies: Agile, Waterfall

Management Tool: Quality Center-ALM, JIRA

IDE: Eclipse, IntelliJ

Bug Tracking Tools: JIRA

Web services: SOAP UI

Other skills: Maven, Jenkins, Git, SOAP-UI, Jira, SQL, HTML, Gherkin, SQL Developer, SQL Server Management studio, SAP BO, MS Office, Service Now, Salesforce.

PROFESSIONAL EXPERIENCE

Confidential - Deerfield, IL

Quality Engineer

Responsibilities:

• Attended Sprint planning, refinement, retrospective and daily standup meetings.
• Designed and Developed Test cases based on BRD and User Stories in Jira Zephyr test management tool.
• Executed different types of test cycles - Smoke Test, Integration test, Regression and End to End test cycles.
• Created and executed SQL queries for test data setup, data verification and for functionality verification.
• Created and tracked defects in JIRA
• Developed and executed test cases for Integration web services using SOAP UI.
• Prepared Cucumber Feature Files against the Requirements and Acceptance criteria
• Created automation scripts using Selenium Webdriver APIs and cucumber framework.
• Executed ETL scripts for initial data load and delta load.
• Executed automation test cycles and analyzed test failures.

Environment: Java 7, Oracle, Talend, Selenium, Cucumber Framework, Putty and WinScp

Confidential - Northbrook, IL

Automation Engineer

Responsibilities:

• Worked with Business Analysts and developers to understand and identify the business requirements for new developments and as well as enhancements
• Analyzed the requirements and manual test cases and defined automation scope by identifying potential candidates and functionalities for automation.
• Performed automation feasibility using Selenium and demonstrated proof of concept for aligning business and technology stakeholder for Selenium regression suit automation.
• Automated entire regression suite for Alliance quote application using Selenium Webdriver, Java and TestNG
• Built the framework by configuring and using Selenium WebDriver, TestNG by following the data driven and page object model design pattern which reduced the significant effort in overall testing automation.
• Involved in identifying automation test scenarios, set up the required reusable functions, repository, environment variables, test data and functions required for the automation scripts functionality.
• Identified test data and organized in excel files scenario wise for test inputs at run time.
• Created data provider methods to provide the test data for implementing data driven test suites.
• Created page object repositories by creating classes for individual pages.
• Used various element locator approaches to identify the elements in page object classes for implementing page factor and better re-use of identified web elements.
• Identified and developed business and generic re-usable methods to be used across the test scripts to enable single point of maintenance.
• Enhanced test cases using Java programming features and TestNG annotations.
• Performed Defect Tracking & Management in JIRA.
• Performed various Testing Techniques: Ad hoc, Functional Testing, Database Testing, UI Testing, Regression Testing, System Testing, End-to-End Testing.
• Worked in a highly dynamic AGILE environment and participated in scrum and sprint meetings.

Environment: Java, Selenium WebDriver, Maven, Jerkins, TestNG, XML, XPath, HTML, Internet Explorer, Google Chrome, Mozilla Firefox, MS Excel, Jira, SQL, Oracle, Windows, Eclipse, Android, BDD, Cucumber

Confidential - Richmond, VA

Automation Analyst

Responsibilities:

• Created Maven project and mapped with Page Object Model pattern.
• Created utility package with re-usable classes and methods.
• Created TestNG suite along with testng.xml to drive test execution.
• Created data driven framework to get the test data from excel workbook.
• Loaded all the required dependencies into POM.xml along with build configuration.
• Used Git repository as code management and version management tool.
• Created separate test scripts but re-using the same project setup for mobile device/emulator.
• Configured Jenkins with required plug-ins to run the Maven project using Jenkins.
• Participated in planning and developing test strategies and plans for Functional and regression test automation.
• Analyzed test results and prepared test/defect summary report for Sr. Management.
• Actively involved with SCRUM and sprint meetings, managing backlog, removing obstacles to progress, prioritizing and review milestones and accomplishments.
• Maintained knowledge base for recurring defects and resolutions and business comments for those defects.

Environment: SOAP UI, Java, Selenium WebDriver, Maven, Jerkins, TestNG, XML, XPath, HTML, Internet Explorer, Google Chrome, Mozilla Firefox, MS Excel, Jira, SQL, Oracle, Windows, Eclipse

Confidential - San Francisco, CA

Quality Analyst/SAP BO Report Tester

Responsibilities:

• Developed Test Plans, test scripts and executed the test scripts.
• Thorough out the project in various iterations/Sprints - conducted system testing, integration testing, functional testing and integration testing.
• Developed complex SQL queries for querying data against different data bases for data verification process.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
• Extensively interacted with developers, business& management teams to understand the project business requirements and ETL design document specifications.
• Participated in regular project status meetings and QA status meetings.
• Extensively used and developed SQL scripts/queries in backend testing of Databases.
• Written test cases to test the application in Quality Center.
• Defects identified in testing environment are communicated to the developers using Quality Center - Defects module.
• Prepared daily status reports with details of executed, passed, and failed test cases and defect status.
• Tested a number of complex ETL mappings and reusable transformations for daily data loads.
• Creating test cases for ETL mappings and design documents for production support
• Setting up, monitoring and using Job Control System in Development/QA/Prod
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to test the flat files data in the databases.
• Scheduling and automating jobs to be run in a batch process
• Effectively communicate testing activities and findings in oral and written formats
• Worked with ETL groups and business analyst for understating mappings for dimensions and facts
• Extracted data from various sources like Oracle, flat files.
• Worked on issues with migration of Data from development to QA-Test Environment
• Extensively tested several Business Objects Reports - Crystal’s reports and Dashboards to validate the reports the data and cosmetics of the report.

Environment: Unix, Ab initio, SQL Server, Oracle, SAP Business Objects, Internet Explorer, Google Chrome, Mozilla Firefox, MS Excel, HP Quality Center, Windows

Confidential - Chicago, IL

Quality Analyst /ETL Testing

Responsibilities:

• Attend the business requirements review meetings on the requirements and sign-off the requirements.
• Analyze the base lined requirements and create the test cases and the traceability of requirements using Quality Center
• Attend Design review meetings and update the test cases if required.
• Create the test strategy document for every release and review it with the stake holders
• Review the test cases and traceability with business.
• Execute the test cases prepared in the test / integration environment and report the defects through Quality center.
• Track the defects throughout the defect life cycle
• Retest the defects and close through quality center once the defects are fixed.
• Perform mock deploy and mock rollback testing in UAT environments.
• Provide the deployment support by running Build Validation Tests and Production Validation tests after the release.
• Perform regression testing, GUI validation, page navigations, content validation and functionality check with end to end scenario.
• Perform database validation using complex SQL Queries.
• Performed testing of ETL jobs for transformation, validation rules.
• Wrote and modified required UNIX scripts and other SQL validation scripts, and writing scripts in SQL to validate the outputs.
• Involved in writing Shell Scripts to load and extract information from files and tested the back-end for data integrity in UNIX.
• Providing testing support for the production support issues and projects.
• Conduct daily Defect review meetings.
• Create the test reports and metrics and share it with the team.
• Perform a QA Lead role for a project release.
• Create and share weekly / daily status report with the team.

Environment: HTML, HP Quality Center, MS Excel, SQL, Oracle, Windows, Unix, Ab initio

Confidential

Test Engineer

Responsibilities:

• Reviewed the business requirements and use cases to understand the requirements with the inputs from business analysts in order to efficiently participate in the testing life cycle of the project.
• Developed test plan consisting of scenarios based on the functional requirements
• Prepared scripts (SQL etc) to create test data as required and populated test data to ensure that test environment is setup in order to ensure commencement of test execution.
• Developed functional/non-functional/regression test cases based on the requirements.
• Prepared the requirements traceability matrix to track business requirements and to ensure test coverage completeness.
• Executes test cases, logged and tracked identified defects, and participated in defect triages.
• Performed go live activities such as production verification as per the implementation plan in order to ensure application is running in production without any issues.
• Anchored defect prevention activities and actioned defect prevention plan in order to ensure quality adherence.

Environment: Quality Center, MS Excel, Oracle, Windows, SQL