SUMMARY:

• Having 7 years of diverse experience in software Testing/Quality Assurance with strong analytical & excellent problem - solving skills and manual testing on web based, Client/Server and data warehousing applications. Experience in all phases of the Software Development Life Cycle ( SDLC ) and Software Testing Life Cycle ( STLC ).
• Experience in Web based applications like online banking, transactions applications.
• Experience in end-to-end ETL process including Data Extraction, Transformation and Loading from source systems.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica graphs.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica.
• Performed data validation testing writing SQL queries .
• Excellent working knowledge of designing and implementation of all QA test strategy plans and automated test solutions for client/server and Web applications with Mercury & HP Interactive Test Suite ( ALM, AGM, Load Runner, Quality Center ).
• Expertise in Test Case/Test Procedure Design, developing Requirement Traceability Matrix (RTM), Test Strategies, Test plans, Test Tool Usage, Test Case Execution, Defect Management and Defect Tracking, creating Test Scripts, reviewing Log files and Reports for delivering utmost Quality product.
• Excellent experience of Quality Assurance methodologies like Waterfall, Agile, Scrum Methodologies.
• Proficient in all phases of testing - Sanity testing, Functionality testing, System testing, Integration testing, GUI testing, Regression Testing, Performance Testing and UAT testing.
• Excellent knowledge and experience in working with open source tools like automation testing tool Selenium (Selenium IDE, Selenium RC, Selenium Web Driver and Selenium Grid), Web Services tools like SOAPUI, Ready API, Unit testing Frameworks such as JUnit, TestNG.
• Experience on Automation testing using Selenium Web Driver with Java and Load Runner to ensure proper business compliance. Have worked on Data-Driven and Keyword-Driven Framework.
• Hands on experience in using project building tools like MAVEN in adding dependencies by maintaining in pom.xml file and on version control tools like SVN, GIT.
• Good knowledge of testing the applications on multiple browsers (IE, Netscape, Firefox, Chrome, etc) for Cross-Browser testing.
• Experienced in performing Continuous Integration (CI) and Continuous Delivery (CD) automation using Jenkins tool for scheduling the jobs and expertize working on configuration management tool Subversion
• Hands-on experience in system design, analysis, implementation, testing, development and maintenance of business software applications with J2EE, Servlet, JSP with Custom tags, JDBC, XML, XSLT.
• Experience in cloud automation using AWS cloud formation templates.
• Integration of Maven, Jenkins, Urban Code Deploy with Patterns/Release, Git, Jira and cloud foundry.
• Developed and executed SQL queries to verify the proper insertion, deletion and updates into the oracle supporting tables.
• Conducted oracle database tests by executing SQL queries to ensure the data integrity by checking various kinds of constraints.
• Proficient writing test suite using Selenium RC.

TECHNICAL SKILLS:

Testing Tools: Selenium IDE, Selenium RC, WebDriver, Test Manager, ETL tool

Languages: JAVA, Java Script, HTML, XML

IDE: Eclipse, SQL Developer

Automation Framework: Data Driven Framework, Keyword driven Framework, Hybrid Framework

Unit Testing Frameworks: Junit, TestNG

Web Debugging Tool: Xpath, Firepath, Firebug, Web debugger

Databases: SQL Server, MS Access, MySQL, Oracle

Build Tool: Ant, Maven

Processes: Agile-Scrum, Waterfall

Bug Tracking Tools: JIRA, Quality Center (QC), Bugzilla

Operating Systems: Windows (XP, Vista & 7, 8) Linux, Mac

Browsers: Mozilla Firefox, Internet Explorer, Safari, Google Chrome, Opera

Application: Microsoft Office, Excel, PowerPoint, Outlook, IBM Lotus Note

Some Other Tools: Jenkins

PROFESSIONAL EXPERIENCE:

Automation Developer

Confidential - Sacramento, CA

Responsibilities:

• Validating the data files from source to make sure correct data has been captured to be loaded to target tables.
• Extensively used Informatica to load data from Flat Files to Teradata, Teradata to Flat Files and Teradata to Teradata.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Reviewed normalized/Denormalization schemas for effective and optimum performance tuning queries and data validations in OLTP and OLAP environments.
• Interacted with Client, Product Owner and Development team to understand the User stories and Acceptance Criteria and gathered Functional requirements for project release.
• Involved in Requirements gathering and reviewed Business Requirement Specification documentation and participated in preparing Test cases based on Product Backlogs.
• Involved in testing of application using the Scrum (Agile) methodology.
• Performed parameterization of the automated test scripts in Selenium to check how the application performs against multiple sets of data Contributed in developing Automation Framework that uses Java, Selenium WebDriver and TestNG.
• Selected the Test Cases to be automated and performed functional testing of the front end using Selenium (IDE and Web Driver) & created Data Driven framework using TestNG.
• Performed Functional Testing, Integration Testing, System Testing, Positive Testing, Negative Testing, GUI Testing, UAT Testing.
• Involved in Regression testing using Selenium and creation of automation scripts for web pages.
• Designed, developed and executed automated tests using Selenium WebDriver.
• Performed Unit testing by writing JUnit test scripts.
• Handled special mouse events and selected the options from the drop-down menu using Selenium Actions builder, mouse hover and synchronization.
• Performed Data-driven testing by using JDBC as a data source in SOAP UI and configured SQL queries to fetch data from the Oracle database.
• Maintained and executed Maven build files for running automated tests by adding dependencies.
• Performed and executed test suite automation scripts using Continuous Integration tool Jenkins.
• Verified the integration of various components in the application and executed end-to-end testing.
• Continuous Integration, Continuous Deployment, Release Management and cloud Implementations.
• Reported daily status of data creation and sent weekly status reports.
• Attended Bug Meetings and meetings with the QA Leads, Managers and Developers for query resolution.

Environment: Quality center, Selenium Web Driver, TestNG, Black box testing, Maven, Jenkins, ETL Tool, Data Driven and Key Word Driven Frameworks, Selenium Grid, SOAP UI, HTML5, XML, JIRA (Agile Management Tool).

QA Analyst

Confidential - Burr Ridge, IL

Responsibilities:

• Writing the test cases, executing the test scripts, logging the defects.
• Developed and Executed Manual test cases for Functional testing of various modules of the application and reporting the status on the projects.
• Performed manual testing of the application for GUI and functional validation.
• Formulated requirement traceability matrix using Quality Center.
• Maintained accurate tracking list of issues and enhancements and defect management using Quality Center.
• Experience in automating the functional & Regression scripts.
• Escalated defects to programmers/developers to resolve the issue to provide bug free product to the client.
• Prepared deliverables for the project like Functional Test Plan, Test Scripts, and End of Test Reports.
• Effective coordination between development team and testing team.
• Creation, enhancing and execution of test scripts using selenium IDE and Selenium RC (Java).
• Executed of Selenium Test Cases and Reporting Defects.
• Involved in Automation Infrastructure Development using Selenium.
• Involved in Regression Testing using Selenium.
• Responsible for assisting senior engineers in developing test estimation, scope and test plan for UAT.
• Perform the tasks of designing and developing test procedures to meet business requirements.
• Executed automation scripts on different browsers/environments & reported defects/results to the team.
• Involved in Sanity Testing, Functional Testing, Regression Testing, System testing, Usability Testing.
• Performed End to End testing to make sure that data is flowing properly from one application to another application.
• Executed all the test cases as per the priority, reported defects with Severity and Priority against each defect.
• Managed requirements, test cases and test scripts using Quality Center.
• Executed the Test Scripts and worked with development team for investigating the bugs.
• Performed compatibility testing to make sure that application is working fine on other external resources or interfaces such as OS, Mobile devices, Network, browser etc.
• Perform database testing by using SQL server to check the data integrity and data correctness.

Environment: Selenium, Selenium RC, Selenium Grid, Selenium Webdriver, TestNG, Rational Manual Tester, Legacy System, XML, SoapUI, SQL, JUnit, Java, Bugzilla, Ant ALM, HP QC, Agile model, UAT, SDLC, Black Box testing.

Automation Test Engineer

Confidential - Temple Terrace, FL

Responsibilities:

• Prepared Test Plan, Test cases, Test Scripts and Test Metrics for the application as well as for the database verification based on the functional requirements, portal redesigned and test specifications.
• Worked in Agile Environment, with an ability to accommodate and test the newly proposed changes at any point of time during the release.
• Evaluate and analyze business requirements, functional Specification documents.
• Developed and executed test plans, test cases and test metrics utilizing QA best practices and standards.
• Designed, developed and implemented MVC pattern based keyword Driven automation testing framework utilizing Java, Junit and Selenium WebDriver.
• Involved in designing and implementing of hybrid automation framework to be used with Selenium WebDriver.
• Created Test plan, High level scenarios, Test case construction and test estimates, resource estimates and weekly status reports.
• Used ANT for building the WebDriver project, integrated with continuous integration tools Jenkins for running test on nightly basis automatically.
• Used automated scripts and performed functionality testing during the various phases of the application development using Selenium.
• Used Selenium tool (Selenium IDE) to record and playback tests and then report the recorded test in other language (e.g., HTML, Java).
• Involved in Functional testing as Unit test, Method test, Test suite, Integration Testing using different Junit methods.
• Wrote ANT build scripts to automate the compilation and execution of Junit test cases/ scripts.
• Created automation scripts in SOAP UI for Web Services testing.
• Tested request and response XML’s based web services interfaces using SOAP UI.
• Performed automation for regression using Selenium WebDriver and Selenium Grid.
• Used Quality Center for bug tracking and reporting, also followed up with development team to verify bug fixes, and update bus status.
• Developed ad executed SQL queries to verify proper insertion, deletion and updates into the Oracle supporting tables and cubes.
• Prepared User documentation with screenshots for UAT (User Acceptance Testing).

Environment: Java, Selenium WebDriver, Selenium IDE, JUnit, Jenkins, SOAP UI, Agile, ANT, Firebug, Eclipse, Quality Center, Oracle10g, Windows 7.

J2EE Developer

Confidential - NC

Responsibilities:

• Developed the front-end web pages using HTML, JSP, JSTL, JavaScript, JQuery and Ajax for presentation layer and enriching the application with better user interface.
• Developed the Use Cases Activity, Sequence and Class diagrams using MS-Visio.
• Involved in creating a dynamic web based application using Java technology Servlets, JSP pages and Custom tags, deploying onto the Server, establishing database connectivity using Microsoft SQL Server 2005 database.
• Developed a module that the Trainee can apply for the course and view the View details page that would be facilitating the details based on the user logged in.
• Evaluated and worked with EJB’s mostly session beans & MD Beans to handle business logic, which will internally call business objects.
• Used JavaScript to perform checking and validations at client side.
• Created tables and SQL queries and procedures using PL/SQL required for the modules developed.
• Developed the Login Module of the portal which include user validation, Admin login and password validations using Java, JPA and JSF.
• Evaluated and worked with EJB’s mostly session beans & MD Beans to handle business logic, which will internally call business objects.
• Implemented Model View Controller (MVC) architecture and developed Form classes, Action classes for the entire application using JSF Framework.
• Designed and Developed automation script using Selenium and WebDriver
• Perform Black box and white box testing.
• Provided the Test status reports, Testing activities and documented issues to the QA Test lead and QA manager.
• Conducted meetings with developers, application team, and business team to analyze the defects and evaluate the test executions.
• Used Quality Center for Bug Reporting, Tracking.
• Used JDBC API programming to communicate with data base.
• Managed the code using SVN and used Log4j to monitor the errors.
• Used ANT Script to Build WAR and EAR files and deployed on to server.
• Responsible for the unit testing using as well as Integration testing of the modules.

Environment: J2EE 1.4, Java 1.5, JSP 2.0, Servlets 2.4, EJB 2.0, JDBC 2.0, JSF 1.2, JavaScript, Servlets, Oracle, HTML, SQL, ANT, Eclipse 3.5, SQL, Log4j, CVS, JUnit, Oracle 10g.