SUMMARY

• Experienced Data QA /Automation tester with close to 8+ years’ experience
• Proficient in leading Functional, Regression, System Integration (SIT), Acceptance (UAT), Security, Browser compatibility, Automation, Database testing.
• Strong knowledge Agile SDLC experience in defining and implementing the test process across the projects right from the initial phase
• Developed detailed test plans, test strategies, test cases, test estimates and defect reports.
• Extensive documentation skills and proficiency in diverse test management and defect tracking tools
• Tested Salesforce custom objects, fields,workflows,page layouts, custom tabs and components for Salesforce Application
• Experience testing in Sales Cloud/Service cloud - Salesforce applications on AWS
• Coached the team in manual mobile & API testing-Web Services (SOAP, Postman, WSDL, JSON, XML) in SOA architectural environment, validating various web services used in the application.
• Extensive experience in testing data warehouses, datamarts & business intelligence reports in SSRS, Micro strategy, Cognos, Tableau
• Experienced with SQL, Stored procedures, Joins, Analytic functions, hive queries
• Strong Experience in writing queries with RDBMS like Oracle, MySQL, SQL Server and non-traditional database systems
• Used Linux, UNIX skills to work with logs on the server
• Proficient in using test automation tools such as Selenium WebDriver, Quality Center to develop automation testing scripts for web and client server applications.
• Sound knowledge on Junit, TestNG framework for Unit testing, Maven for Project building tool, Jenkins for Continuous Integration, Git for code management
• Experience in the development of Data driven, and Hybrid Automation frameworks in Selenium.
• Good working experience on SOAP UI, Postman and REST Assured API (E2E testing using data driven framework) for testing and validating various web services used in the application.

TECHNICAL SKILLS

Test management and defect tracking: HP Quality Centre (QC), JIRA, Microsoft Test Manager (MTM), Selenium

Web, Web Services: HTML, CSS, XML, JSON, SOAPUI, POSTMAN

Database,BigData: SQL Server, MySQL, Oracle SQL Developer, Hive, Pig (Big data),Linux

ETL Data warehouse: SSIS, Informatica, DataStage,Talend, Pig, Cognos, SSRS,Tableau

Test Automation: Selenium Java, TestNG, Framework, Maven, Cucumber

Source Control: GIT, SVN, SharePoint, TFS

Operating System & Misc.: Salesforce, AWS,Windows,Linux

PROFESSIONAL EXPERIENCE

QA tester

Confidential

Responsibilities:

• Developed test plan, test cases, test scenarios based on Users Stories and product's design description to meet business requirements and technical specifications.
• Used HP ALM as a test management tool
• Performed ad hoc, functional, integration, regression, exploratory, data integration platform testing, backend ETL,UAT testing to certify the stability and usability of software systems
• Worked in an Agile environment
• Managed test coverage based on risk analysis
• Monitored deployment process to QA and UAT environment
• Actively participated in QA team meetings to discuss testing process, bug fixes, releases and strategy
• Generated test data, data ingestion and data quality checks with high volumes of data
• Validated target Data Warehouse and ETL workflows and transformations-Informatica as migration tools
• Performed testing on AWS cloud environment for a migration from Data warehouse to Data Lake (Hadoop oriented storage)
• Validated HDFS loads, Hive tables in Big Data setup
• Tested Hadoop Pig transformations
• Verified various types of reports (matrix style, cross tab, parameterized) reports in report builder
• Responsible for writing and maintain Selenium WebDriver scripts for regression and functional testing using data driven framework.
• Developed test code in Java language using Eclipse and TestNG framework.
• Setup the Automation framework using Selenium to run test cases in multiple browsers and platforms
• Responsible for identifying test cases for manual and Automation with Selenium WebDriver for Smoke Test, Functional and Regression Tests.
• Involved in design and implementation of Selenium WebDriver automation behavior driven framework for smoke and regression test suites (TestNG and Maven).
• Tested web service calls using Postman

Confidential

QA tester

Responsibilities:

• Analyzed business requirements and developed Test cases based on Use cases to evaluate the functionalities.
• Identified and assisted in preparation of Test Data
• Tested big data ETL workflows using Ab Initio including data from flat files and relational databases to Hadoop cluster
• Test environment consisted of Data Stage as migration tools with backend Oracle,DB2 databases
• Used JIRA as a test bug management tool
• Prepared Test Strategy, Test Scenarios, Test Evaluation Summary Reports, Test Cases and Test Scripts to perform Functional, System, and User Acceptance testing (UAT), Performance, Integration, Regression, and UAT, Security, Smoke/Sanity and Usability testing.
• Tested the look and feel as well data validation of Cognos reports
• Developed executed SQL queries, updated and tested stored procedures for testing the application backend by using TOAD tool.
• Verified aggregates totals by different dimensions for the reports
• Used Maven to build and run the Selenium automation framework. Once the script got over, framework used to send the automation reports over email.
• Involved in the Continuous Integration of the automation framework with Jenkins. Maintained code in Git
• Integrated the test suites to Jenkins to execute them automatically after every successful deployment.
• Used XPath and DOM to work with dynamic and static objects in Selenium.
• Used Git as code repository and Code Collaborator to manage code reviews.
• Contributed to the framework by creating utility classes with reusable functions and Page classes

Confidential

QA Selenium/Java

Responsibilities:

• Execute Test scripts to validation correct functionality of application.
• Managed test coverage based on risk analysis.
• Use SQL for back-end database validation.
• Tested ETL’s, data warehouses and datamarts
• Tested reports built from Hadoop environment
• Used Query Analyzer, Execution Plan to optimize SQL Queries
• Used Linux /Unix to check logs, query location/format etc on the server in Hadoop environment
• Worked in AWS environment with Informatica as Data Migration tool
• Validated dashboards & reports including line and pie charts, trend analysis and sub-reports
• Assured that all test artifacts are in compliance with corporate Policies and guidelines.
• Documented defects and evaluate priority of defect based on overall application functionality.
• Coordinate Test script Reviews with stakeholders are being held as appropriate.
• Involved in the creation of test plans, test cases and test strategy based on the functional and non-functional requirements and then linking them to maintain Requirement Traceability Matrix
• Created test status report after each Confidential .
• Followed Test Driven Development (TDD) in writing test cases using TestNG for every relevant class.
• Implemented report functionality in Selenium framework using Extent reports
• Used XPath and DOM to work with dynamic and static objects in Selenium.
• Performed Smoke, Functional, Regression testing

Confidential

QA tester

Responsibilities:

• Performed Functional tests using Selenium WebDriver with TestNG hybrid framework
• Utilized Page Object Design pattern to build framework
• Captured dynamic elements in the UI and wrote TestNG assertions to validate
• Test case gap analysis. Participated in defect triage meeting.
• Interacted with subject matter experts, developers, and process analysts to understand the business process, gather Business Requirements and identify enhancements
• Provided User Acceptance Test (UAT) scenarios for prospective users and trained them on the new features.
• Participated in sessions with management, vendors, users and other stakeholders for open and pending issues.
• Authored and reviewed test cases Execution of test cases and exploratory testing
• Preparation of Test Requirements Traceability Matrices and Test Summary Reports
• Identifying and collecting required test data.
• Validated target Data Warehouse and ETL workflows and transformation accomplished through migration tools AbInitio
• Tested dashboards and reports in Tableau. Tested hierarchical, geographical, cross tabs to display metrics and KPIs
• Utilized stored procedures and performed SQL queries to query backend data

Confidential

QA tester

Responsibilities:

• Performed functional testing of Web services testing using Postman. Performed parameterization in test cases
• Executed Selenium tests for automation testing of the web application using Selenium Web Driver.
• Used Maven to build and run the Selenium automation framework. Once the script got over, framework used to send the automation reports over email.
• Developed Maven Build scripts to run Sanity Test scripts developed in Selenium WebDriver.
• Used Maven for building the WebDriver project. Integrated with Continuous Integration tools Jenkins for running test on nightly basis automatically.
• Created Data Driven tests that randomized the test data for testing the AUT using Excel file.
• Participated in Stand-up meeting, walkthrough meeting, weekly automation meeting with all other QA, weekly assessment meetings with business analysts and developers.