SUMMARY

• Experienced lead QA Analyst/Automation tester with 8 years’ experience
• Proficient in leading Functional, Regression, System Integration (SIT), Acceptance (UAT), Security, Browser compatibility, 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, Rest Assured

Database,BigData: SQL Server, MySQL, Oracle SQL Developer, Hive, Pig, Hadoop, Eclipse

ETL: SSIS, Informatica, DataStage,AbInitio, Pig Cognos, Hadoop,SSRS,Tableau,Microstrategy

Linux/Unix/Programming: Command line skills UNIX, Java, Junit, JSON, Hybrid Framework

Source Control: GIT, SVN, SharePoint, TFS

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

PROFESSIONAL EXPERIENCE

Confidential, Dallas TX

QA tester

Responsibilities:

• 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
• Lead the team and 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
• 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
• Worked in an Agile environment
• Verified various types of reports (matrix style, cross tab, parameterized) reports in report builder
• 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
• 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 framework for smoke and regression test suites (TestNG and Maven).
• Tested web services using REST Assured API (Parameterization with Data driven framework), SOAPUI, Postman

Confidential, Dallas TX

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.
• Web service testing using SOAPUI/Postman. Strong understanding of XML schema, tools that support testing web service interface, JSON
• 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.
• Created manual test cases, reviewed with different stakeholders to validate the functionality.
• Worked with SOA architecture which includes RestAssured,SOAPUI,POSTMAN,Web Service Testing

Confidential, Kansas City MO

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
• 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 sprint.
• Used Linux /Unix to check logs, query location/format etc on the server in Hadoop environment
• Followed Test Driven Development (TDD) in writing test cases using TestNG for every relevant class.
• Created test cases, test plans, tested API’s, wrote TestNG test cases, executed code coverage, wrote automation
• Used XPath and DOM to work with dynamic and static objects in Selenium.
• Performed Smoke, Functional, Regression and Integration testing.

Confidential, Topeka, KS

QA ETL tester

Responsibilities:

• 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
• Test case gap analysis. Participated in defect triage meeting.
• Performed Functional tests using Selenium WebDriver with data driven framework.
• Involved in testing SOA with RESTful/SOAP Web Services. Participated in creating architecture for backend testing internal and third party API using SOAP UI.
• Performed functional testing of Web services testing using SOAP UI.