SUMMARY

• Over 8+ years of experience in Web Application development and Test Automation
• Involved in various stages of Software Development Life Cycle (SDLC)
• Extensive experience with multiple automation Framework, with sound knowledge in Object oriented programming.
• Experienced in automation testing with tools such as Selenium (Web Driver/IDE), QTP and preparation of Automation Test framework.
• Expertise in editing and debugging tests using Selenium.
• Experienced in Functionality Testing, Integration Testing, Smoke Testing, System Testing, GUI Testing, Regression Testing, Positive, Negative, Data Base Testing and Web Services like REST and SOAP testing on various applications.
• Strong hands - on knowledge in software models: Agile (Scrum) Methodology, Waterfall and V Model.
• Experienced in using Jenkins to automate the compile or test cycle to validate the code changes.
• Experienced in writing manual test scripts, maintaining Requirements, Test Cases, Traceability and logging defects using HP-Quality Center, TFS, Bugzilla and JIRA.
• Strong automation development skills using Java/J2EE, C#, JavaScript and jQuery.
• Expertise in Performing Back-End testing by writing SQL queries.
• Experience in Web applications testing such as Insurance (Guidewire product), Mobile application.
• Performed the Mobile Testing for Mobile App, identify the Mobile Platform like IOS, Android by using Appium.
• Expertise in taking console and crash logs of IOS and Android devices using ADB and DDMS tools.
• Expertise in using various technologies in Hadoop ecosystems including Apache Spark, HBase, Hive, AWS EMR, Cloudera Altus, AWS Redshift, AWS Athena, AWS Lambda, AWS Cloud Formation, and AWS Step Functions.
• Good experienced on moving the data in and out of Hadoop RDBMS, No-SQL and UNIX from various systems using SQOOP and other traditional data movement technologies.
• Strong working experience in delivering Data Analytics solutions, which can drive business decisions, using AWS Cloud, Big Data and Hadoop ecosystems.
• Proficient in QA Testing Methodologies and Agile Software Development.
• Developed end-to-end composite RESTful Web Services by using SOA with CXF framework to use with different clients including Web & Mobile.
• Developed automation scripts of web applications and Native mobile apps using Selenium, QTP-UFT and Appium.
• Proficient in writing mobile automation scripts in JUnit and TestNG frameworks using Appium.
• A highly motivated with Strong communication skills, ability to interact with team members, developers, and users.
• Created ETL test data for all ETL mapping rules to test the functionality of the ETL process based on mapping document.
• Tested the ETL flow and other ETL Processes (Data Warehouse Testing)
• Experienced in writing test cases and involved in preparing test plan document.
• Experienced in using Application Lifecycle management (ALM) tool - Quality Center

TECHNICAL SKILLS

Automation Tools: Selenium Web Driver, Selenium Grid, Selenium IDE, Appium, Quick Test Professional QTP, Android studio, X- code

Test Management: HP- ALM-Quality Center, MS Office, Jira and TFS, SharePoint

Big data Technologies: YARN Pig, Hive, Sqoop, Oozie, HBase, Hadoop and MapReduce, HDFS, Spark, ZooKeeper, Flume.

Development Environment: Eclipse, Visual studio 10-12.

Operating Systems: Windows, UNIX, LINUX and Mac OS X

Languages: Java, C#, PL/SQL, VB Script, Groovy Script

Databases Tools: Sql Server 2005, MySQL, Sql Server 2008, Oracle and Ab Initio

Web: Asp.net, PHP, JavaScript, HTML, XML, HTML 5.0

Processes: Software Testing Life Cycle, Defect Life Cycle, Testing Methodologies, Black Box Testing Techniques, White Box Testing Techniques, Agile Process.

Web Services Testing: SOAP UI, REST, WSDL

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Sr. Automation Engineer & ETL Tester

Responsibilities:

• Involved in gathering requirements for the scope designed to perform data validation testing for data migration purpose.
• Worked in Agile environment as part of Sprint planning and define the testing scope.
• Involved in preparing the Test plans, Requirements Traceability Matrix (RTM) and defining the approach to perform Data Validation.
• Bank Information Stewardship data migration project validating the Members, Accounts and transactions in their Confidential Account and outside accounts.
• Created test scenarios and reviewed with development team to add any other critical scenarios for validation.
• Analyze the mapping documents and create testcases for the test scenarios designed.
• Prepared and executed the test cases manually to perform Integration testing, compared and analyzed actual with expected results and reported all mismatches in the values to the developers.
• Mapped requirements to the test cases by defining the planned start and end dates for execution.
• Involved in creating test strategies, testing plans and prepared detailed test cases for the applications using Selenium WebDriver, TestNG and Maven.
• Performed Regression Testing for every modification made in the application and new builds using Selenium Web Driver.
• Involved in extensiveDATAvalidation using SQL queries after running the Control-M jobs to load data from Source to Target database.
• For validating millions of records used MINUS queries to filter the data that has not migrated to the target database.
• Performed verification of UNIX logs using Putty while performing the testing.
• Extensively used IBM DataStage to monitor the scheduled job runs.
• Created SQL views to aggregate data before moving to targeted database from live legacy database to simulate results.
• Developed and executed SQL queries to validate the data migrated from DB2, Netezza MSSQL to Oracle database.
• Involved in featuring the Control-M sequences and designing the extract, transform and load jobs in Datastage and schedule timely runs daily.
• Used qTest Test Case management tool with the requirements, test cases and perform execution, also created defects based on the validation and assigned to developers by failing the test runs and link to the defects.
• Extensively worked onMapping Variables, Mapping Parameters, Workflow Variables and Session Parametersto extract only the additional data added during that period.
• Verified the CDC logic for each table once the delta loads are done and execute the testcases in qTest.
• Validated the Count of records loaded and column wise data in History, Initial load and Daily loads.
• Worked with Data Extraction, Transformation and Loading (ETL) tools and performed testing to validate the records migrated from source to target database.

Environment: Java, Protractor, Gherkin, Maven, Angular JS, Node JS, SQL, DataStage, qTest, RTC, Control-M, Oracle, SAS Enterprise, Eclipse IDE, TestNG, Selenium webDriver, POI, Chrome, IE, Windows, Linux.

Confidential, Indianapolis, IN

Sr Automation Engineer

Responsibilities:

• Detailed understanding of business and high-level requirements, providing solutions by applying Big Data concepts, elucidating the same to business and management personnel.
• To actively participate in Agile/Scrum events, to work with Business Analysts and help in requirements gathering, to analyses, design, develop and test Big Data pipelines implemented in both AWS cloud and On-Premise platforms.
• Independently designed, developed and implemented an end-to-end data pipeline using various technologies like Spark, Hive, HBase, Oracle, Map Reduce, HDFS, YARN
• Independently developed complex post-job data extraction systems that scan and extract data, and perform business related transitions using Spark, Hive, Python, Bash, and SMTP
• Performed unit tests and validations by developing scripts and custom test automation systems in HQL, PySpark, and Bash scripting.
• Scripted effective and highly performant programs in Java, Python, PySpark, Scala, SQL, Hive QL, Bash scripting
• Involved in Functionality, User Interface, and Regression testing during the various phases of development using Selenium/TestNG.
• Participated in scrum meetings to ensure that the business rules have been addressed properly.
• Performed Regression Testing for every modification made in the application and new builds using Selenium Web Driver.
• Configured Selenium WebDriver, TestNG, Maven tool and created selenium automationscripts in java using TestNG prior to agile release.
• Created/Tested REST API's under various methods POST and GET files which needed web services interface lists and registries using Firebug, Postman and other related tools.
• Worked on developing a Hadoop-Java application that interfaces HBase and Spark and performs real time and parallel transactions at scale.
• Automated jobs and data pipelines using AWS Step Functions, AWS Lambda, and AWS Cloud Trail
• Developed and Deployed secure authentication system for AWS Lambda to deploy and submits jobs on transient and Hybrid cloud clusters in Cloudera Altus.
• Successfully developed multi-platform logging Framework to normalize application logging across the data pipeline using Py4J Logging
• Designed, developed and implemented Dynamic Programming Algorithms to handle huge volumes of workloads and deploy CDH Altus clusters at scale to achieve maximum parallelism with high cost effectiveness.
• Successfully managed environment migrations and deployments using Bit Bucket, AWS Code Deploy, AWS Code Commit, and SonarQube, by following CI/CD methods.

Environment: (On-Prem.): Cloudera Distribution 6.x, Apache Spark 2.x, YARN, HDFS, Stream Sets, Hive, HBase, Impala, Oracle, My SQL, SQL Server, RHEL, Control-M, Zoo Keeper, Oozie, SFTP, and Kerberos, (AWS): AWS S3, AWS Lambda, AWS Step Functions, AWS Cloud Formation, AWS SFTP, AWS Code Commit, AWS Storage Gateway, AWS Cloud Watch, Selenium Web Driver, Selenium Grid, Maven, TestNG, Java, Web Services, SOAP UI, Eclipse.

Confidential, Orlando, FL

Sr. Automation Engineer

Responsibilities:

• Followed Agile methodology as part of sprint planning and attended daily stand up meetings.
• Created framework using Page Object Model (POM) with Page Factory and page classes from scratch to represent web pages using Selenium WebDriver and TestNG.
• Gathered the critical scenarios and application requirements from the Business Managers, defined the scope for testing and developed the test cases.
• Involved in creating test strategies, testing plans and prepared detailed test cases for the applications using Selenium WebDriver, TestNG and Maven.
• Developed and implemented robust MVC Pattern base testing with Selenium WebDriver which cut down the script development time in half.
• Developed, enhanced and maintained a large and complex suite of both GUI and API based Automated Regression tests.
• Parameterized Unique and dynamic content in the application scripts for real time emulation. Data was queried from Data base and input data for data driven tests were kept in Excel Reader by using Apache POI repository.
• Create and review of Generic Object Identifiers using various mechanisms such as X path, CSS, id, name, class etc., used by Selenium WebDriver.
• Used Log4j API for providing logging information and Maven for Project Management and configuring dependencies needed for building testing and running code.
• Used Actions class of Selenium to handle Mouse hover events.
• Performed Backend testing by writing and executing SQL queries to validate the data is populated in appropriate tables and verify the correctness manually with the front-end values. Also performed data validation testing by writing the SQL queries.
• Involved in SOAP & REST based Web Services testing using SOAP UI testing tool.
• Tested request and response XML's based web services interfaces using SOAP UI by using Groovy Script to test the Web Services.
• Used Extent Reports reporting library to send the Automation reports in the form of Email. Captured the Screenshots of PASS or FAIL status of the automation and displayed in the Extent Reports.
• Performed various Cross Browser and Parallel testing on different platforms using Selenium Grid.
• Integrated Automation Scripts using Selenium Grid in Jenkins Continuous Integration configuration for batch process run of the Script in different platforms such as Windows and Linux.
• Performed the Mobile testing for mobile app of client, identify the mobile Platform like IOS, Android by using Appium.
• Created Requirement Traceability Matrix and Bug Tracking tool with certain changes in HP Quality Center (QC).
• Experienced in using TFS for the version control of the test automation scripts.
• Worked with SQL queries for data verifications in Oracle (10g/11g) database.

Environment: HP QC, TFS, Selenium Web Driver, Selenium Grid, Maven, TestNG, Java, Web Services, SOAP UI, Eclipse, Business Objects, Appium, Log4j, Apache POI, Jenkins, SQL, Chrome, IE, Windows, Linux.

Confidential, Olympia, WA

QA Tester

Responsibilities:

• Analyzed the functional specification document and Use stories for testing the application, as well as preparation and execution of Test Cases according to the business document specifications.
• Experience in Writing test plans, test cases, test procedures based on business requirements.
• Responsible for Regression Testing, Functional testing, Integration testing, Performance testing, UAT and end to end testing for web based application.
• Followed Agile Methodology (SCRUM) for this project.
• Involved in Functionality, User Interface, and Regression testing during the various phases of development using Selenium/TestNG.
• Participated in scrum meetings to ensure that the business rules have been addressed properly.
• Performed Regression Testing for every modification made in the application and new builds using Selenium Web Driver.
• Configured Selenium WebDriver, TestNG, Maven tool and created selenium automationscripts in java using TestNG prior to agile release.
• Handled and performed web service testing using Soap UI and created test data using XML.
• Involved in Testing and Virtualizing various types of SOA based services including Web Services -SOAP/HTTP(s), REST Services -XML/JSON.
• Performed End-to-End testing manually and automatically.
• Developed Test Cases for Deployment Verification, ETL Data Validation and Report testing, front end user interface testing.
• Wrote Test Cases for ETL to compare Source and Target database systems.
• Involved in backend testing for validation testing to check front-end and database systems using SQL commands.
• Created and updated defects using JIRA and interacted with Business/System analysts, Developers and QA team members in different defect raising situations
• Participated in User Acceptance Testing (UAT) with the business users.

Environment: Jira, Selenium Web Driver, TestNG, Java, Web Services, SOAP UI, Eclipse, Business Objects, Ab Initio, SQL, TFS, Firefox, Windows, IE, Unix.

Confidential, Hoffman Estates, IL

QA Tester

Responsibilities:

• Identified manual test cases for automation.
• Followed Agile methodology was part of sprint planning and attended daily stand up meetings.
• Analyzing Real Time End to End Business Scenarios and Designing test cases for Business requirement. Build Testing/ Regression Testing on a sprint-on-sprint basis
• Logging Defects and Tracking them to closure by using HP Quality Center as a test management tool.
• Coded applications primarily in Java programming.
• Highlight risks on deliverables on daily basis with clients during scrum
• Involved in Functionality, User Interface, and Regression testing during the various phases of development using Selenium WebDriver / TestNG test cases.
• Performed functional testing to identify various critical points in the application and automated it by using Selenium web driver.
• Wrote automated scripts in Cucumber using Gherkin behavior-driven development BDD and implement TDD practices using Java/Cucumber automation.
• Functionalities include writing code in HTML, CSS, JavaScript, JQuery, JSON, AngularJS, and Bootstrap with SQL database as the backend.
• Involved in writing automated scripts for angular JS application using protractor and Java scripts.
• Created/Tested REST API's under various methods POST and GET files which needed web services interface lists and registries using Firebug, Postman and other related tools.
• Validated Web services under Postman by sending response and logged defects for handling related issues.
• Work with Postman Interceptor tool for generating API request and analyze the response success and failures of interfaces.
• Good experience inmobile testing using APPIUM in both IOS and Android applications usingsimulator and emulator.
• Proficiency and Tested the application inMobile, Tablet and Desktop.
• Integrated Appium with Sauce Labs for distributing tests on the cloud, Integrated Appium with Continuous Integration tool- Jenkins.
• Worked on key word driven, Data Driven API and Behavior Data driven - Frameworks.
• Performing Functional, Regression, GUI, and usability testing using Selenium with Java and Page Object Model (POM) in Junit/TestNG framework and using Continuous Integration CI Jenkins to ensure web application is automatically tested via scripts on different browsers and checked for compatibility.
• Performing Cross-platform, Functional, Regression testing, UI testing for mobile app using Appium test automation framework.
• Perform database verifications using SQL queries to validate test data.

Environment: HP Quality Center, Java/J2EE, SQL Server, Web Services, Soap UI, Windows, IE, Selenium Web Driver, IDE, TestNG, Eclipse, Appium, MS Word, Excel, JSP, HTML, XML.

Confidential, New York, NY

QA Tester

Responsibilities:

• Involved in preparing the Test plan based on Business Requirement Document and User Stories.
• As test Engineer, involved in plan & perform testing, verification & validation, and quality assurance.
• Created Test Data for QA, UAT and filed and tracked the defects using Jira.
• Extensively used Selenium Web Driver to test the web applications and to perform Functional testing, regression testing and integration testing using java.
• Use Id, Name, Links, XPath and CSS locators to work with dynamic and static elements in application.
• Involved in creation of automation framework such as page object model (POM) in Selenium WebDriver using Java language.
• Run test cases in multiple browsers using Selenium Grid.
• Work with SoapUI for generating API request and analyze the response success and failures of interfaces.
• Updated WSDL file as needed for Endpoint, Tested request and response XML. Added Assertions to validate the response xml with database.
• Written and executed MYSQL queries and Joins, Group by clause, having clause etc. to validate the data.
• Developing test cases, test scenarios and user flows for various types of handheld devices covering iOS platform.
• Performing Functional and Exploratory Testing of Mobile app on iOS and Android platforms using Mobile Automation tool appium.
• Developedautomation script forMobileNative applications and Performed themobileTesting formobile App of Client, identify themobile Platform like IOS, Android by using Appium.
• Involved in Smoke Testing, Regression Testing and User Acceptance Testing.
• Along with validation on the front end, perform the backend log analysis in Java environments to make sure the interfaces yield the correct results/response to requests.
• Attend daily/ weekly standup meetings to give status reports on Test case execution, defects, RTM.

Environment: Selenium Web Driver, Java, jQuery, Java Script, Appium, Jira, HTML, SoapUI, MYSQL, VBScript, Scratch, XML, Web Services, Eclipse.

Confidential, Cincinnati, OH

QA Tester

Responsibilities:

• Feasibility analysis and test effort estimation of automating the test using Selenium WebDriver using JAVA and JUnit for Web Application.
• Developing automation framework (Data-Driven) using Selenium.
• Developing Test Plan and Test scripts
• Test Data preparation and work with interfacing applications for data needs
• Test Execution in SIT and UAT environments and managing the test scripts and test results and Bugs report in HP-Quality center.
• Arrange meetings and work with Dev team & Business Analysts for defect triage
• Work in transition to use Agile (Scrum) Methodology
• Participate in Biweekly Agile Sprint Planning meetings, Daily Scrum meetings
• Allocation of work among the testing team both at onsite and offshore
• Tested ETL mappings that transfer data from Oracle source systems to the Data Mart
• Experience with testing Mainframes and XML data
• Good working experience in automation tools like selenium WebDriver, selenium IDE to develop automation testing scripts for web, Mobile and client server applications.
• Designed, developed and implemented POM basedautomationtesting framework utilizing Java, TestNG and Selenium WebDriver.
• Involved in testing of web services using Soap UI and Broken links for enhancements.
• Generating Test and Defect Metrics for client manager and release management.

Environment: HP- Quality Center, Windows, Java, Appium, Oracle, Selenium WebDriver/IDE, TestNG, Junit, Eclipse.

Confidential

QA Tester

Responsibilities:

• Functional Test Requirement Analysis using Business Requirements Document and Design documents
• Developing Test Plan, Test scripts and Test Execution in SIT environment.
• Test Data preparation and work with interfacing applications for data needs
• Preparation of Test Summary Report and execute End to End Testing.
• Arrange meetings and work with Dev team & Business Analysts for defect triage
• HP Managing the test scripts and test results in HP QC
• Interacting with multiple onsite client teams to resolve technical related issues
• Automated test cases to perform regression testing using Java, selenium web driver and eclipse IDE
• Involved in Smoke Testing, Regression Testing and User Acceptance Testing.
• Responsible in executing test scripts on different browsers and checked for compatibility
• Managing multiple initiative projects concurrently
• Generating Test and Defect Metrics for client manager and release management
• Preparing reports for client & employer engagement managers

Environment: Java, Selenium Web Driver, Eclipse, Windows 2007, Unix, HP Quality Center.

Confidential

QA Tester

Responsibilities:

• Design and Execute Test Cases.
• Preliminary discussions of the Project with the Core Team.
• Find the bugs in application.
• Implemented properties files to read configurations and XPath of elements in the application for better readability of the code.
• Integrated TestNG with Selenium using Visual studio to generate test execution result.
• Involved in review meetings and weekly status meetings.
• Involved in Functional, Regression testing and GUI testing.
• Written queries in the SQL to validate the output in the database.
• Extensively performed Functional Testing and End to End Testing.
• Ensure that all Functional requirements are tested.
• Managed, executed test cases and logs and defects reporting tool using Test director.
• Responsible for Backend testing by writing andexecuting SQL query statements.
• Involved in writing Test cases depends on test scenarios.
• Writing test automation scripts using Selenium and execute tests.

Environment: Test Director, Manual Testing, Selenium, VB Script, SQL server, Visual studio, IE, VSS, Microsoft Office.