PROFESSIONAL SUMMARY:

• Over 7+ years of experience in Software Development, Unit testing and Automation testing
• Experience in developing Automation testing suite using Python and Robot Framework for feature testing.
• Experience in Test Scripts to implement Test Cases, Test Scenarios and features for BDD (Behavior Driven Development), TDD (Test Driven Development) using Cucumber.
• Expertise in exporting JUNIT scripts from Selenium IDE to EclipseJUNIT Test Suites, creating new JUNIT test cases, modifying the selenium scripts and writing test suites using JUNIT.
• Executed web services testing using SOAP UI tool for soap and Rest Web services.
• Performed Continuous Integration of code and scripts using Jenkins and triggered the Continuous Delivery process using Jenkins build jobs.
• Maintained the Selenium &JAVA automation code and resource in source controls like SVN, Github.
• Extensive experience in Software Development Life Cycle (SDLC) process following Agile and waterfall software development methodologies.
• Expertise in Planning, Preparation/Writing, Enhancement of Test Framework and Execution of Manual Test Cases and Automated Test Scripts using standard Testing procedures and methodologies.
• Experience with building Gherkin (Cucumber) user scenarios and ruby scripting for automated testing (Selenium/Ruby/Cucumber). Experienced on developing test scripts with Ruby - Selenium to automate browser & web applications under Cucumber (BDD) Framework.
• Expertise in automation testing of web-based applications using Selenium WebDriver, Selenium Grid, Junit, TestNG.
• Good Experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.
• Solid backend testing experience in writing and executing SQL queries.
• Strong Experience using SQL queries to retrieve data from the databases.
• Excellent understanding and knowledge of Business intelligence tools for various applications of ETL, Reporting, Data mining, Data Warehousing, and Analysis of data.
• Proven Experience in understanding various stages of Testing including Regression Testing, Functional, End-to-End and User Acceptance Testing (UAT).
• Good Experience in implementing Test automation framework in Page Object Model framework, Keyword driven framework, Data Driven framework and Hybrid driven framework.
• Extensive experience in UNIX shell Scripting, AWK, grep and file manipulation techniques
• Expertise skills in Java Multithreading, Exception Handling, Servlets, JSP, Custom Tag Libraries, Java Script, AJAX, CSS, HTML, JDBC, and XML related technologies.
• Exposure towards working with open source tools like Apache ANT and Apache Maven, Open Source Servers like Apache Tomcat.
• Experience and knowledge in working with Mobile Automation using Appium and Espresso for Android applications.
• Experience working with C# and .Net technologies.
• Experienced with bug reporting tools like HP Quality Center, DevTrack, JIRA, BugZilla
• Experience in Microservices and Spring Boot applications development
• Extensive experience in Guidewire Policy Center, Billing Center, Claim Center. knowledge in AWS services like EC2, S3, ELB, Auto scaling, IAM, Security Groups, Cloud watch, Cloud Trail and Redshift.
• Hands on experience in Insurance industry with extensive exposure in Quote, Policy bound, Rating, Underwriting, Billing, Agency Commission, Claim, Reserve and Payments.
• Experience with Cross-Browser and Compatibility Testing to test whether the web applications are working as desired in different browsers and environments.
• Experience in Parallel Execution of Multiple Tests at a time in different environments.
• Expertise in writing SQL Queries, SQL *PLUS, PLSQL stored procedures for databases like Oracle, MySQL, Netezza, DB2 on UNIX as well as Windows platforms.
• Ability to work fast paced, challenging environment with excellent debugging and problem solving skills, strong interpersonal skills, analytical ability, communication skills, and ability to quickly grasp and adapt to the rising technologies.

TECHNICAL SKILLS:

Languages: Java,C++,VB,PL/SQL

Technologies: J2EE, JSP, JDBC, HTML,CSS, JQuery, Java Script, SOAP, XML

QA Tools: SELENIUM IDE/RC/ Web Driver/ GRID, QTP, JUNIT 3/4, TEST NG, Firebug, FirePath, xpath, Maven, JSON, Jenkin, SVN, JXL

IDE & Frameworks: TestNG, Junit, Eclipse, Quality Centre, Hibernate, Spring, ATDD, BDD,TDD,Cucumber,Ruby Mine

Bug Tracking Tools: Quality Center HP ALM, Bugzilla, JIRA, Mantis, CQ, Pivotal tracker, github, Mercury/HP, Rational Clear Quest, Rally, Firebug, LoadRunner

Web Services: SOAP, RestFul, WSDL, SOAP UI

Operating System: Windows, MAC, DOS, Linux/ Unix

Database: Oracle, SQL Server, Netezza,MS Access, MY SQL

Web Servers: Tomcat, Web Sphere, Web Logic, IIS

Browsers: IE, Firefox, Chrome, Safari

Configuration Tools: TOAD, SQL Navigator, SVN, Win SCP, Putty,GIT,Maven,Ant,Jenkins

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

QA Automation Engineer

Responsibilities:

• Responsible for testing and reviewing of ETL Informatica mapping and transformation specifications based on the business requirements from various teams and the business teams.
• Created test data in Policy, Billing, Claim Center as per test scenarios.
• Formulate methods to perform Positive and Negative testing against requirements.
• Testing of ETL jobs that are scheduled for file transfers from Operational Data Stores to designated file systems/directories.
• Tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
• Tested the performance bottle necks at sources, targets, mappings, and sessions and employed required measures.
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center.
• Written and executed complex SQL queries to validate accuracy of the reports.
• Participated in User Acceptance testing (UAT) and involved in UA test cases, Executed test cases, Documenting Defects, Resolved defects and Signed Off from Application.
• Provided weekly status report to the Project Manager and discuss issues related to quality and deadlines.
• Performed Policy and Billing Center Integration Testing on various Billing Instructions
• Created Selenium Test cases for automation using Selenium Web Driver and Java.
• Provided weekly status report to the Project Manager and discuss issues related to quality and deadlines.
• As part of Automation Testing, prepared regression test suite, designed test scripts in Selenium WebDriver using Java and Regression testing was performed after each build release of the application
• Used Maven for building the WebDriver project. Integrated with Continuous Integration tools Jenkins for running test on nightly basis automatically.
• Analyzed the automation test results, filed defects into internal bug tracking system.
• Used Unix in creating many automation scripts to speed up the testing design and execution process and reduce the overall manual efforts.

Environment: Selenium WebDriver, Java, TestNG, Agile,JIRA,SQL Server, Oracle11g, TOAD, Netezza, AWS Red shift, Informatica, MS Excel,Big data, PL/SQL Developer, LINUX/UNIX, Windows 7, DB2,Qlick sense, HP ALM Quality Center, SVN, Python, Robot Framework .

Confidential, Columbus, OH

Test Automation Developer

Responsibilities:

• Implemented test automation leveraging test automation frameworks while driving processes to reduce manual test coverage.
• Involved in automation framework design, enhancement, maintenance and execution.
• Wrote test scenarios and then test cases and created test data for testing the application.
• Implemented test automation leveraging test automation frameworks while driving processes to reduce manual test coverage.
• Involved in developing automation tests from acceptance test criteria requirements using Ruby Cucumber.
• Involved in the use of Cucumber Step Definition, Scenarios and Features.
• Wrote Gherkins/scenarios and generated step definitions and methods using ruby/ Cucumber, for different functionalities of the above applications.
• Executed automated test scripts using Selenium WebDriver, TestNG and Database as source of Test Data.
• Performed System, Integration, Smoke, Sanity, Functional, Back-end, Positive and Negative and monitored the behavior of the applications during different phases of testing using testing methodologies.
• Performed ETL data validation, testing functionality of mapping by preparing test data for all ETL mapping rules by loading data from various sources using Informatica power center.
• Performed data integration testing on extracted data from various sources like oracle, Netezza, flat files and SQL Server .
• Tested ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files to target tables
• Actively involved in functional, unit and integration testing in agile methodology.
• Executed all test cases and loaded the test results in QC
• Used SQL day to day for back end testing
• Created mapping using Informatica Data Quality to cleanse data and feed into tables again.
• Extensively used SQL and PL/SQL scripts to perform backend database testing and Tested Data Stage Mappings.
• Tracked defects using bug-logging with tools like JIRA and Bugzilla. knowledge in analysis of Bug severity, Bug tracking System and Bug reporting
• Tested /Found the defects in backend DWH staging tables, facts and front end cubes and reports
• LINUX/UNIX and Oracle were used to write Shell Scripts and SQL queries respectively .
• Prepared System, Integration, User Acceptance and Regression testing.

Environment: Selenium WebDriver, Ruby Mine Java, TestNG, Agile, SQL, DHTML, VBScript, Quality center HTML, Oracle11g, TOAD, Netezza, MS Excel, PL/SQL Developer, LINUX/UNIX, Windows 7, DB2, SQL, HP ALM Quality Center.

Confidential, TX

Software Development Engineer In Test (SDET)

Responsibilities:

• Designs, develops, configures, Implements and maintains automated test frameworks and custom test solutions with a focus on regression, End to End, and functional testing.
• Automate Web based application with the help of Selenium Web driver, Serenity Framework using Java Programming.
• Following Agile methodology in software product development and testing.
• Actively involved in Daily Scrum, Iteration Planning, Release Planning meetings, review stories and retrospectives.
• Used JIRA as a bug tracking tool and to maintain/documenting the Test cases.
• Create and execute Automation scripts by developing Features, statements, steps, page objects and Runner files.
• Actively performed the Production validation tests runs through both manual and Automation runs.
• Generate Regression and smoke serenity test reports by running through Jenkins.
• Involved in meetings and coordinating the application release deployment in Production environments to assigned team.
• Used Git Hub, source Tree tools as a code repository/maintenance.
• Raising pull Requests to merge the code into Master Git repository via Bit Bucket tools.
• Participated in reviewing the pull requests of Co-Automation Engineers.
• Automated and performed webservice API Integration Testing using Postman and Swagger tools respectively.
• Using Grafana validate the request and response of the webservice calls of the application.
• Used Locust for viewing the performance of the Automation scripts.
• Actively involved in Deployment Testing exercises as needed.
• Communicate and report on the status of test automation activities.
• Collaborate with the Quality Assurance team and developers on application test automation.

Environment: Selenium WebDriver, Java, Agile, JIRA, IntelliJ, Eclipse, Git Hub, Source Tree, Bit Bucket, Grafana, Locust, Gherkin, Cucumber, BDD Serenity Framework, Swagger, Postman, Jenkins, Windows 7, Mac, Python, Robot Framework, ETL informatica.

Confidential, Raleigh, NC

ETL Automation Test Engineer

Responsibilities:

• Automated test cases using Selenium WebDriver with TestNG ofweb-portal used by citizens and the government caseworkers to apply for Healthcare benefits for the citizens.
• Worked on ETL Data Warehousing, database testing using Informatica for Workflow process.
• Involved in design and implementation of Selenium WebDriver automation framework for smoke and regression test suites (JUnit/ TestNG and ANT).
• Developed and implemented robust MVC Pattern base testing with Selenium RC and WebDriver which cut down the script development time in half.
• Executed Complex SQL queries within UNIX shell scripts in the UNIX environment.
• Identify, assess and intimate potential risks associated to testing scope, quality of the product and schedule
• Generated the detailed reports of the Bugs, go no go reports and comparison charts.
• Conducted Black Box - Functional, Regression and Data Driven. White box - Unit and Integration Testing (positive and negative scenarios)
• Tested several complex reports generated by Tableau including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Tested the reports developed in Tableau, SAP BO against the database
• Written SQL scripts to test the mappings and extensively used Tableau for report generation
• Tested graphical representation of reports such as Bar charts, Pie charts as per End user requirements.
• Tested SAP BO Desktop Intelligence and Web Intelligence reports.
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Defects tracking, review, analyze and compare results using Quality Center.
• Identified & presented effort estimations related to testing efforts to Project Management Team
• Ran workflows created in Informatica by developers then compared before and after transformation of data generated to ensure that transformation was successful.
• Using Import Wizard deploying the reports from Dev system to QA box.

Environment: Selenium WebDriver, Java, TestNG, Agile, SQL, DHTML, VBScript, Quality center HTML, Oracle11g, MSWord, MS Excel, PL/SQL Developer, UNIX, Windows 7, DB2, H2, Curam, C#, RSA, SQL DBx.

Confidential

Java Developer/QA Engineer

Responsibilities:

• Gathered business requirements from users and created designs for enhancements and to remedy defects.
• Actively participated in Business Process and Functional Requirements analysis, review of Project Documents and functional architect/design.
• Conducted Sanity, Functional, System, and Integration, Regression for the Applications.
• Involved in the preparation of Test Plan and Test Approach artifacts with resource requirements and time estimates along with the manager.
• Detected Defects, communicated to the developers using Bug Reporting Tool and Tracking the defects using Quality Center.
• Analyzed Use Case Scenarios and developed Test Cases for various Business Services/ Methods covering both positive and negative testing requirements.
• Performed End-to-End Manual Testing of web-based and client-server applications for web testing.
• Performed Backend Testing by writing queries in order to view successful transactions to validate the data using SQL queries in Oracle database.
• Created Test cases and Test matrix for integration and system testing.
• Involved in cross browser testing for the different website modules.
• Utilized Quality Center to Track, Report, and Manage defects and bugs throughout the defect life cycle.
• Reviewed the defects posted by the team members and suggested further modification or enhancements.
• Worked with requirements and test cases and reporting.
• Shared Daily Status Reports with all the team members, Team Leads, Managers and Clients.
• Attended weekly Project Status Meeting with Development team and QA Manager, and worked closely with QA Manager to define Test Scope, and analysis of Gap, Risks, Dependencies and Constraints.

Environment: ECLIPSE IDE, DB2, JAVA, J2EE, Selenium, TOMCAT, JIRA, Quality centre, HP ALM Quality center, Oracle, WINDOWS XP.