SUMMARY:

• Over 8 years of IT experience in the area of Software Testing (Manual and Automation) - for Web applications, Desktop applications, Client-Server applications, Business Intelligence applications, Data Warehousing, Healthcare, eCommerce, Retail, Point-of-Sales Applications, Banking/Financial and Mortgage applications.
• Extensively worked in entire QA Life Cycle which includes analysis, design, develop and execution of the entire QA process.
• Experience on Functional Testing (Black Box Testing), System Testing, Regression Testing, Integration Testing, Automation Testing, System Integration Testing (SIT), Certification Testing, UAT (User Acceptance Testing), Security Testing, Load Testing and Performance Testing.
• Strong experience in Automating Web Application Testing using Selenium.
• Well versed with handling Elements in Selenium WebDriver.
• Expertise in TestNG Annotations and Assertions.
• Experience in designing Page object model (POM) and TestNG based Automation Framework using Selenium WebDriver, Java, Maven, Jenkins and Apache POI.
• Experience in using Selenium Grid to run parallel tests and managed test suites using TestNG.
• Experience in using GitHub to maintain test repository (tests and version controlling).
• Experience in validating the data ingestion, data preparation processes in Hadoop Data Lake.
• Experience in validating the data in Hadoop HDFS and working with different technologies including Spark, Hive, Map Reduce, Oozie, Sqoop, NoSQL etc.
• Have experience in preparing Requirement Traceability Matrix (RTMs), Defect Reports, Test Summary Reports, Story Burndown charts, QA Health Reports, and Weekly Status Reports.
• Have working experience in Methodologies like Agile, Scrum, Waterfall, V-Model and RUP.
• Good experience in writing Test Plans, Test Strategy, Test Scenarios and Test Cases/Test Scripts based on business requirements (User stories) and system requirements.
• Knowledge on different QA Test Automation frameworks such as Module Based Testing Framework, Data Driven Testing Framework, Keyword Driven Testing Framework and Behavior Driven Development Framework.
• Have hands-on experience in API (RESTful) and Webservices testing.
• Have experience in validating ERP integrations with in the e-Commerce applications.
• Have hands-on experience in Data Analysis, Database Validations, Data Migration projects and ETL Datawarehouse Testing.
• Expert in writing SQL queries to perform data validations.
• Have good experience in validating BI Reports including dashboards, summary reports, master detailed, drill down and score cards according to the report specification documents.
• Extensively worked on Autosys (Batch Scheduling Tool) to run and monitor scheduling jobs.
• Have experience working with Star Schema, Snowflake Schema, FACT, Dimension, Physical, Logical, Change Data Capture (CDC) and Slowly Changing Dimensions.
• Good at documentation, communication and interpersonal skills.
• Quick learner with an aptitude of taking responsibilities.

TECHNICAL SKILLS:

QA Automation Tools: Selenium WebDriver, Selenium RC, Selenium IDE,and Cucumber

Webservices Automation Tools: SOAP UI

Test Management Tools: Microsoft VSTS, VSO, Microsoft TFS, Microsoft MTMJira, Rally, HP Quality Center/ALM

Web Technologies: XML, HTML, HTML5, CSS

Mind Mapping Tools: (Test cases development)XMind, MindMeister

Hadoop Eco System: Cloudera Hadoop Distribution, Hadoop 2, HDFS, Hive, Spark, HQL, Oozie, Sqoop

Web Browsers: Microsoft Internet Explorer, Microsoft Edge, Google Chrome, Mozilla Firefox, Safari

Operating Systems: Microsoft Windows Family, Unix, Linux, Apple iOS

Programming Languages: Core Java, J2EE, C, C++, SQL

Scripting Languages: Java Script, VB Script, Unix Shell Scripting

Java IDEs: (Integrated Development Environment)Eclipse, NetBeans, IntelliJ IDEA

Build Tools: Maven, Ant

DBMS (Relational Databases): Oracle 12c/11g/10g/9i, DB2, Microsoft AccessMicrosoft SQL Server 2016/2014/2012/2008

DBMS (SQL Query Editors) Tools: TOAD, Rapid SQL, Microsoft Management Studio,Oracle SQL Developer

Bug Tracking Tools: Clear Quest, Jira, Bugzilla

Version Control Tools: Clear Case, Requisite Pro, Microsoft Share Point, BOX

Incident/Change Mgmt. Tools: BMC Remedy, Ticket Tracker

Job Scheduling Tools: Autosys

ETL Tools: Informatica Power Center, Microsoft SSIS

BI/Reporting Tools: IBM Cognos Reports, Tableau, Microsoft SSRS

Application Servers: IBM WebSphere Application Server, Apache Tomcat,JBoss Enterprise Application Platform

Other Tools: Putty, WinSCP, SnagIt, XML Spy, Notepad++, GitHub

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Sr. QA Automation Engineer

Responsibilities:

• Involved in building Test Automation Framework from scratch using Selenium WebDriver, JAVA, TestNG, Cucumber, and Eclipse.
• Was also responsible for the Functional testing (prepared Test Catalogs/Scenarios, Test Cases/Scripts) for the entire application; and was also responsible for Regression testing.
• Involved in writing Test Cases based on User Stories defined in different Sprints.
• Actively participated in sprint meetings such as Daily Standup meetings, Sprint Planning, Backlog Grooming, Sprint Demos and Sprint Retro.
• Involved in end-to-end testing for the entire eCommerce application.
• Planned, executed and maintained test scripts and programs.
• Used Firebug to identify the Object's id, Name, XPath, link in the application.
• Run tests by using Selenium Web Driver in different browsers.
• Monitored Jenkins job execution results and logged the defects in VSO.
• Used MAVEN for build management, GitHub as source repository and Jenkins for Continuous Integration of the builds.
• Designed and built automation framework for LOT (web-based application) using POM Design (Page Object Model) for portability and maintenance.
• Involved in executing Selenium test scripts on different browsers and checked for the compatibility. Reviewed execution progress of test initiatives to trace negative impacts.
• Performed Regression testing after each build is released.
• Coordinated with agile developers to create new solutions and improve existing ones.
• Used GitHub as a code repository to check out project from it, make modifications, submit and commit changes to the local repository and then later to the central repository.
• Responsible to verify Web services API request, response data validations in REST, SOAP protocols. Performed API Testing with Postman and Swagger.
• Responsible for validating GET, POST, PUT API methods using Selenium Webdriver.
• Worked with transactions and validated the data by using SQL.
• Responsible for creating Test Environment for Web Services testing.
• Tested design documentation in terms of stated requirements.
• Maintained and updated reports on results of quality tests.
• Performed compatibility test using different browsers, tablets and mobiles.
• Created and reviewed test cases, conditions and scenarios. Developed estimates for all relevant test activities.
• Ensured its successful implementation of the test plans, design and test cases.
• Gathered and confirmed test data.
• Reported defects, and escalated issues.
• Validated ERP integrations in the e-Commerce application.
• Generated test logs, and documented & verified test results.
• Developed User-Acceptance Test cases and assisted Business users in conducting UAT.
• Created test scripts and supported business teams during UAT.
• Identified high priority functional areas for UAT and prepared Test Bed for UAT.
• Heavily involved in UI testing and written test cases for GUI validation for both positive and negative scenarios.
• Interacted with the Developers and BA for defects and problem resolution.

Environment: Selenium 2 (WebDriver, Grid), Java Script, Eclipse IDE, Firebug, Angular JS, GitHub, TestNG, Maven, Jenkins, Microsoft Access, SQL, Microsoft SQL Server 2016, JBoss Enterprise Application Platform, XMind, MindMeister, Microsoft Visual Studio, log4J, Microsoft Test Manager (MTM), XML Files, Web Services, Microsoft SharePoint, SOAP UI, API Testing with Postman and Swagger, Microsoft Azure API Management portal.

Sr. QA Automation Tester

Responsibilities:

• Worked as a QA Automaton Tester and prepared Test Plan, Test Strategy, Test Catalog, Test Cases/Scripts according to User stories.
• Responsible for implementation of Data Driven Automation Framework build using Selenium Web Driver, Selenium Grid, TestNG, IntelliJ IDEA, Page Object Model (POM) and Maven technologies under Java platform.
• Involved in Defect Triage Process within the Scrum Team (Agile).
• Validated the data ingestion, data preparation and data egress processes in Hadoop big data eco system.
• Updated QA Test Status to senior management, cross-functional Business Teams across the organization.
• Used Fire Bug, Fire Path to debug, edit and locate the objects based on ID, Name, XPath, CSS Selector, Link, Partial Link, Attributes and Tags.
• Involved in both Front-End and Back-End QA processes.
• Analyzed root cause investigation for the broken links.
• Execution of Selenium Test cases and Reporting defects.
• Validated UI screens, GUI objects, GUI events, GUI representations according to the business requirements documents and systems requirements.
• Used MAVEN for build management, SVN as source repository and Jenkins for Continuous Integration of the builds.
• Integrated Automation scripts in Continuous Integration tools (Jenkins) for nightly consignment run of the Script.
• Validated the data on screens against the database.
• Tested Web Services: i.e. validated Request and Response times, SOAP Calls, RESTful calls and WSDL using SOAP UI tool.
• Performed functional testing of Web Services using SOAP UI.
• Performed System Testing, Database Verification testing and Regression testing and Smoke Test execution after every new build.
• Validated Web Services request and response XML using SOAPUI tool.
• Created SQL Queries to retrieve the data from different tables to perform Back End testing on database.
• Created automated Load test scripts using Load UI.
• Conducted UAT & Demo sessions with users after successful resolution of major defects for each release.
• Tested and Reported Bugs/Defects in product releases and performed the Root Cause Analysis for the Defects raised.
• Coordinated test execution efforts such as test data and support team provision, defect tracking and management, ensuring resolution of testing issues.
• Conducted backend testing by querying databases.
• Prepared Weekly, Monthly QA status and QA metric reports.

Environment: Selenium 2, Java, IntelliJ IDEA, Jenkins, MAVEN, TestNG, Agile Scrum, UAT, HP ALM, Jira, SOAP UI, LOAD UI, XML Spy, Web Services, XML Files, Hadoop 2, Hive, HDFS, Oozie, Sqoop, NoSQL, Oracle 11g, EDI Transactions, log4J, HTML 5, CSS3, REST, Rally, TOAD, UNIX, Tableau Dashboards, Tableau Reports, FTP client, TextPad, Clear case, Clear Quest, Microsoft SQL Server 2012.

ETL QA Tester / BI Reports Tester

Responsibilities:

• Generated Bug Reports and Test case coverage reports for status meeting and also involved in resource planning for test cases coverage
• Involved in Bug Review meetings and participated in weekly meetings with management team.
• Performed regression testing by repeated execution of test cases in each build by logging defects using Jira.
• Involved in writing SQL Queries using TOAD to validate the backend data.
• Involved in validating ETL jobs according to the data mapping requirements.
• Involved in validating BI Report and Dashboards according to the report specification documents.
• Validated the data on web screens against the data points and database.
• Maintained Metrics participated in weekly status updates showing the progress of the testing effort and open issues to be resolved.
• Perform end-end testing of Web Services.
• Provided test results, test summary reports and weekly status reports to QA Manager.

Environment: Informatica Power Center, IBM Cognos Reports, SQL, TOAD, Oracle 10g, HP Quality Center, XML Files, Rally, Agile/Scrum.

ETL QA Tester / Functional QA Tester

Responsibilities:

• Developed and conducted a wide range of tests and analysis to ensure that software, systems, and services meet minimum company standards and defined end-user and system requirements.
• Evaluated business requirements and technical specification documents to craft test strategies and LOE assessments which would account for durations, constraints, assumptions, etc. that are required to accomplish test objectives.
• Involved in high and detail level design reviews to ensure requirement traceability and to determine application/component functional readiness requirements.
• Involved in obtaining Test requirements from the Business Users for new change requirements and enhancement request.
• Being part of the test team, responsibilities involved writing complex queries using SQL to generate data based on the complex derivations for each attribute.
• Complex SQL queries were written to compare data generated by the application against the expected results generated based on mapping requirements for each interface.
• Participated in Project discussions with analyst, developer & testing teams.
• Exclusively involved in execution of Autosys jobs, PL/SQL batch programs and responsible for reporting the defects to development team.
• Validating the data passed to downstream systems.
• Worked with the development team to create a suite of test data (Input files, Expected results), that fully exercises data validation (detecting, rejecting bad data) to test ETL functionality (properly processing).
• Tracked and executed the User Acceptance Test (UAT) Cases with respect to the requirements to determine the feature coverage.
• Responsible for testing Initial and daily loads of ETL jobs.
• Involved in testing the batch programs by using the Autosys tool.
• Responsible for preparing test cases and scenarios for System testing and UAT testing.
• Involved in creating various data scenarios and validating them before and after running the respective Autosys batches.
• Executed all tests as test sets from Test Lab module (QC) and implemented Traceability Matrix by associating and tracking the test cases and defects from Defects module.
• Developed UNIX scripts for file archiving, file transfers and file management.
• Involved in Database Validations, Writing Test scripts (Including the related SQL Statements by joining various tables) depending on Requirements for both Positive and Negative Scenarios.
• Automating the Data and Validating in various builds, using QTP and Quality Center.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Prepared RTM, defect density reports, project QA health reports, test summary reports for each release and updated them to QA Leads/Managers.

Environment: Informatica Power Center, Oracle 11g, SQL, PL/SQL, Toad, Autosys, IBM DB2 V8, RapidSQL, BOXI Reports, Rational Clear Quest, Rational Clear Case, DOORS, Oracle SQL Developer, HP Quality Center 10, QTP 10.0, VBScript, UNIX, Putty, XML, XSD, XSLT, WinSCP, Leech FTP, Remedy, Windows XP/NT, Agile/Scrum.

QA Tester

Responsibilities:

• Analyzed business requirements and module-specific functionalities to identify test requirements and formulate test catalog.
• Supported test activities associated with Product Point of Sales.
• Validated the point of sale functionality tracking the reward points for the customer and reward points redemption.
• Developed and executed test cases in Quality Center.
• Tested Web services using SOAP UI tool, validated request and response XML.
• Actively involved in UI, functional, database and Integration testing of the applications.
• Extensively performed smoke and sanity testing.
• Validated the campaign feature and discount options in the POS.
• Extensively used Quality Center for test management.
• Created & executed SQL Queries to validate the data
• Extensively performed end to end to ensure data flow.
• Created and executed detailed test cases for the assigned area.
• Prepared test data for positive and negative test scenarios for Functional testing.
• Executed test cases manually to verify actual results against expected results.
• Defect Reporting, Analyzing, Tracking and Report Generation using HP QC.
• Tracked progress of defects through to resolution.
• Used Toad to write/execute SQL queries for back-end testing.

Environment: Windows XP, Java, Selenium, Java Script, Oracle 9i, SQL, SoapUI, Web Services, XML, Quality Center, Toad.

MCA Internship

Responsibilities:

• Analyzed the business requirements, system requirements and prepared test cases accordingly with validation steps (expected results)
• Tested databases for accuracy of data according to the functional requirements.
• Participated in daily status meeting with project management of defect and issues found.
• Reported daily and on weekly basis to QA Lead and Project Manager.

Environment: Windows XP, Java, J2EE, Microsoft SQL Server 2008, MS Access, SQL, Manual testing, HTML, Excel.