SUMMARY:

• To obtain a Software QA Automation Developer/Engineer/Analyst position with extensively experienced in IT field Software Testing Manual, Automation, Backend, ETL/Database testing.
• Software QA Professional with 6+ years of core expertise on Automation, Manual and Backend /DB/ETL/BI/Data Warehouse testing as well as Client - Server/Web N-Tier and Desktop application .
• Very good Exposure in Object Oriented Concepts in Java, XML, HTML, JS, VBScript and SQL.
• Extensive experienced in online/Investment Banking, Financial, Capital Market, Insurance and Healthcare Domains tested Front-Back office application with strong Business knowledge.
• Attended in requirement review meetings, analysis requirements and developed, executed Test Plan and Test Cases, STLC , Requirement Traceability Matrix, Defect Life Cycle in HP ALM.
• Strong Experienced with analyzing application, Test cases, Planning, Coding, Enhancing, Maintaining and Executing automation scripts using Selenium Web Driver, TestNG, and Maven by developing Page Object Model Framework, TDD and ATDD Environment to perform Functional, Regression testing through Continuous Integration (CI) tool such as Jenkin for Web application.
• Strong Experienced to perform data validation by writing - executing SQL queries in order to retrieve data from DB using JDBC API in Selenium WebDriver automation suites.
• Experienced in performing Data Driven Testing by Excels spreadsheet, Environment variable, Oracle database using ADODB object with using Data Driven Framework in UFT/QTP.
• Extensive hands on experienced on planning, designing, developing and highly scalable and maintainable custom automation frameworks such as Data Driven and Key Word Driven in UFT.
• Strong experienced in writing SQL queries to perform Back end, Data Base & ETL testing.
• Extremely efficient in Agile, Scrum, DevOps Onshore-Offshore, Dynamic project environments.
• Excellent Analytical highly motivated team player, Interpersonal and communication skills.

SKILLS MATRIX:

Automation Tools: Platforms

Languages/Environment: Databases

Web Servers: QTP/UFT,ALM, JIRA, TDD

SQL Developer, Selenium WebDriver, ANT, TestNG, Maven, Rally.: Windows, Unix and

Linux.: VB, VB Script, Java

SQL, HTML, XML,HTTP: My SQL, Python

Oracle, SQL Server, MySQL.: IIS, Apache

PROFESSIONAL EXPERIENCE

Confidential, NYC, NY

QA Automation Developer

Responsibilities:

• Reviewing Business Requirement, User stories, designing test plan, test scenarios, design test cases, collecting test data to perform Black box testing such as Smoke, functional & System test.
• Developing test scripts using Java in order to perform black box testing using by developing Page Object Model design pattern by creating dynamic web elements locator values using various locators such as Xpath, ID, Name so on in Selenium WebDriver Eclipse IDE, TestNG.
• Performing Data Driven testing using Data provider annotation following TDD approach in TestNG, drive data from various sources such as excel file using Apache POI and text file.
• Performing test validation using various methods such as Hard Assertion, Soft Assertion and data validation by writing, executing SQL queries in order to retrieve data from DB using JDBC API.
• Enhancing test scripts using object oriented programming features in Java, Junit, TestNG annotation and handling dependency using Maven POM xml in Selenium WebDriver
• Working with continuous execution in order to perform regression test through Continuous Integration (CI) tool such as Jenkins, GitHub in DevOps, Release Branch and UAT environment.
• Analyzing the TestNG and Extent Reports after executing the selenium WebDriver automation suites through Jenkins, TestNG and preparing daily and release level automation status reports.
• Discovering the defect and reporting defects and retest it after fixing the defects using JIRA.
• Communicating, Contributing and closely working with Agile (DevOps)-Scrum team members such as Developer, Business Analyst and Products owner so on.

Environment: Windows, Agile (DevOps), JIRA, Java, Selenium, TestNG, Jenkins, Putty -Oracle.

Confidential, Boston, MA

Software QA Automation Analyst

Responsibilities:

• Reviewed Business logic, analyzing the existing manual test cases, Collecting, Creating and Maintaining test data by executing SQL Queries for automated functional, regression testing.
• Performed ETL test design, Execution and data loading from source to target through running ETL jobs through Putty, verify status in Autosys and validating data by executing SQL queries.
• Analyzed application, Planning, Coding, Enhancing, Debugging, Maintaining and Executing automation scripts using Selenium Web Driver, TestNG Framework and Maven by developing Page Object Model Framework, TestNG Annotations using Java to perform Functional, Regression test through Continuous Integration (CI) tool such as Jenkin for Web application.
• Performed test validation using various methods such as Hard Assertion, Soft Assertion and data validation by writing, executing SQL queries in order to retrieve data from DB using JDBC API.
• Analyzed TestNG as well as Extent reports once regression test execution done through Jenkin.
• Analyzed application, Planning, Coding, Enhancing, Debugging, Maintaining and Executing UFT scripts in Keyword Driven Framework and validating data from Oracle DB by SQL in HP UFT.
• Attended daily scrum, Iteration planning and pre-planning meeting during Iteration in Agile.

Environment: Agile, ALM, UFT, Autosys, WinScp, VB Script, Java, MS Office, Putty, RTC, Oracle.

Confidential, NYC, NY

Sr. QA Analyst

Responsibilities:

• Reviewed, Understood Business Requirements, Use Case, Developed and Executed Test Plan, Business Test Scenarios and Test Design in order to perform Black box testing such as Smoke.
• Involved in ETL testing activities such as Data Loading and validation from Source and Target.
• Closely worked with Product Owner, Business, and Dev and attended sprint planning, daily scrum meeting.
• Developed, Executed and Maintained automation scripts using Data Driven Framework in QTP/UFT.
• Developed Enhanced, Debugged, and Executed and Maintained automation scripts by using descriptive programming, VB Scripts in daily basis activities and analyzed the test results.
• Developed automation test scripts, Reusable Functions used Descriptive Programming, VBScript and validating data from Oracle DB by writing, executing SQL using ADODB objects in HP UFT.
• Created Automation scripts using VB Script in QTP to perform functional and regression testing for Web.
• Integrated HPQTP scripts with HP ALM to manage the entire Automation testing process.

Environment: Agile, ALM, QTP, Java Script, MS Office, Windows, Putty, WinScp, Oracle, SQL.

Confidential, Washington, DC

Test Automation Analyst

Responsibilities:

• Reviewed Understood Functional requirements and wrote test cases to perform system testing.
• Wrote the Test Scripts and analyzed Test Scripts to check if it has covered the functionalities of the User Login and Account Information and validating data from DB using QTP.
• Developed automation scripts used Descriptive Programming, SOR, Ordinal Identifier and Regular Expressions to identify dynamic Objects, Exception/Error Handling, and VBScript QTP.
• Developed, maintained and executed Automation test scripts, Test Conditions, Test Data and Expected results for Functional and Regression Tests using Keyword Driven Framework in QTP.
• Performed automation regression testing in release level, analyzed the test results, Log defects.
• Attended and contributed daily scrum and weekly meetings with QA and the development team.
• Integrated QTP with QC and executed automation scripts from QC to performed regression test.

Environment: Agile, Quality Center/ALM, HP QTP, Windows, Oracle, VB Script.