SUMMARY:

• Over 8 years of experience as a QA Engineer involving in Software Development Life Cycle (SDLC) including analysis, requirement engineering, architecture design, development, enhancements, testing, deployment and maintenance of standalone, Multi - tier, web-based enterprise applications.
• Experienced in Software Quality Assurance in analysis, design of manual and automated testing (Black box, White box) of various applications for Client/Server and Web-Based environments.
• Experienced in writing test plans, test strategy, test data management and application enhancements, maintenance releases and defect fixes for various applications.
• Experienced in automation testing using Selenium, TestNG and using TestNG as Unit Test case framework.
• Extensively involved in Version Control Tool like GitHub and continuous integration tool like Jenkins.
• Experience in applying Testing Methodologies, creating Test Plans, Executing Test Scripts, Automation of Test Cases, Defect Tracking and report generation.
• Experience in working with open source tools such as Selenium (Selenium IDE, Selenium RC, Selenium web driver, Selenium Grid), Cucumber and Eclipse
• Expert in installing and configuring Automated Tools and setting QA Test Environment.
• Strong knowledge of Software Development Life Cycle (SDLC) methodologies such as Agile and Waterfall.
• Excellent experience in developing Test Scenarios, Test cases, Test Scripts and Test reports for Manual as well as Automated testing for various applications to ensure proper business compliance.
• Experience in performing the white box testing (Unit Testing), Black box testing, integration testing, Regression testing, Database testing, system testing, and supported user acceptance testing (UAT) with business users.
• Experience in performing software bug tracking using JIRA and HP ALM.
• Experience in understanding the code written in different programming languages Java, Java Script, PL/SQL and databases like Oracle, SQL Server.
• Strong in performing database backend testing in writing SQL queries for testing to ensure data integrity and validate business rules
• Experience in testing the applications Agile Methodology and Software Development Life Cycle testing methodologies including business requirement analysis, Regression, Functional, Usability, System and User acceptance testing debugging of existing ETL process in Informatica 9.x/8.x.
• Highly motivated team player with excellent communication, presentation and always willing to work in challenging and cross functional environment. strong analytical problem-solving skills and pay great attention to details

TECHNICAL SKILLS:

Testing Tools: Selenium Web Driver, Cucumber, TestNG, Maven, Jenkins, GIT,HP Quality Center 9.2, ALM (Application Lifecycle Management), JIRA

Web Services: Soap UI, REST

Environment: Windows, UNIX, MS DOS, RED HAT LINUX

BIDW tools: Informatica 9.x/8.6, Oracle Warehouse Builder/OWB 11g/10g, Business Objects, Micro Strategy, MS Excel 2007

Databases: Oracle 12c/11g/10g, Netezza, SQL Server, DB2, MS Access, TOAD, Aginity Workbench, SQL Developer, SQL Plus

Programming: Languages Java, JavaScript, HTML, XML, CSS Unix Shell Scripting, C, SQL, PL/SQL, HTML, and XML.

PROJECT EXPERIENCE:

Confidential, Washington, DC

Test Engineer

Responsibilities:

• Analyzed the business requirements, functional specifications and use case documents and created the test plans and test cases.
• Successfully evaluated use of apache http client for sending web service request over http and validate the response.
• Used SOAP UI tool to send REST Requests and validate the response.
• Created build acceptance test suites using apache http client java APIs that were seamlessly integrated with CI system (Jenkins).
• Developed Test Scripts to implement Test Cases, and features for BDD (Behavior Driven Development), TDD (Test Driven Development) using Cucumber in Gherkins format
• Highly efficient in keeping up the agile process in place for automation development and maintenance.
• Participated QA review and retrospective for continuous improvement in the Quality and release process.
• Created and executed automation test Scripts using Selenium Web Driver, TestNG and Maven.
• Interacted with development and product management teams on review and analysis of functional requirements, resolution of reported bugs and various technical issues.
• Involved in writing SQL queries for data validations and check constraints using DB visualize.
• Actively participated in Test case review meetings and all Sprint activities.
• Revise test plan and test cases to match any changes in document specification.
• Reported and tracked the bugs to closure using Jira.
• Used GIT for checking in the automated test scripts.

Environment: Selenium Webdriver, Java, TestNG, Eclipse, Cucumber, SQL, GIT, Jenkins, Rest API, Linux, XML, Jira, Firebug, Oracle 11G, Apache Tomcat, Apache http client.

Confidential, Hartford, CT

QA Analyst/ETL Tester

Responsibilities:

• Involved in requirement and understanding phase, test plan, test case preparation, reviews and system testing, user acceptance testing by validating the business acceptance criteria.
• Created bug report to log all defects encountered during manual validation and has worked with test management tool JIRA.
• Developed test cases for ETL coding and mapping standards based on design specifications document and warehouse metadata, naming standards.
• Created complex queries to test the data in Oracle and Netezza databases, designed sub-queries, inline views, multi table joins, with clause and outer joins as per the functional needs in the Business Requirements Document (BRD).
• Worked ETL scripts using Informatica and validating the data in the Oracle target database and created, optimized, reviewed, and executed SQL test queries to validate transformation rules.
• Worked on data validation of reports, user interphase application validation and ad-hoc reports validation, and preparing master test plan, test estimations
• Executed all Test cases in different phases of testing like Progression, Regression and Smoke testing of the application.
• Validated the Informatica workflows according to business requirement documents, used Informatica workflow monitor to run the workflow and verify their status and logs.
• Validated the data warehouse (DWH) Table structure part of ETL testing, tested all the rules implemented during ETL job and data move from source to target
• Participated and involved in the Peer Reviews and Walkthroughs on the Test Case, and Preliminary test approach, which contains high-level test conditions for verifying the software solution.
• Maintained and updated requirements traceability matrix (RTM) having Business Requirements, Technical Requirements, Test Scenarios and Test Cases for test completeness

Environment: Informatica 9.x,OWB 11g/10g, Oracle Database 12c/11g,Netezza, Business Objects, TOAD, SQL Developer, Aginity workbench, Business Objects, LINUX

Confidential, Washington, DC

QA Tester

Responsibilities:

• Performed various phases of testing to ensure an acceptable level of performance of the prudential product, phases included unit, regression, smoke, integration, system and acceptance testing.
• Involved in the preparation of test plan specifying an overview of testing approach, testing strategy, roles, and responsibilities and testing scope.
• Prepared SQL scripts for test data preparation for back end functionality testing and performing queries on the database to check successful transaction and to create particular test cases.
• Testing and Monitoring of load process of Informatica Jobs and performed UI validation for Plan view, test data Management by identifying various scenarios for Incremental execution
• Participated and involved in the Peer Reviews and Walkthroughs on the Test Case, and Preliminary test approach, which contains high-level test conditions for verifying the software solution.
• Involved in creating bench mark with the help of business User team to create Performance Base mark in writing, updating and executing functional and GUI Test cases, System Testing, User Acceptance Testing and Post Production Validation.
• Preparing Master Test plan, Test effort estimation, Test evaluation summary reports and created bug report to log all defects encountered during manual validation and has worked with test management tool Quality Center

Environment: Informatica 8.6.1, EBS R12/11.5.10, Oracle Database 11g/10g, UNIX, Windows XP, Xml, Oracle, Toad, Windows Server 2003