We provide IT Staff Augmentation Services!

Automation Test Specialist Resume

Durham, NC

PROFESSIONAL SUMMARY:

  • Senior Automation Quality Analyst with around 10 years of experience in Software Testing across Logistic, HealthCare, E - commerce, Travel & Transport, ERP and Finance domains.
  • Experience in Database testing and data warehouse testing with ETL tools Microsoft SSIS and Informatica.
  • Experience in Automation Testing with Selenium, Java and Confidential RFT tool.
  • Experience in Protractor testing with Jasmine and node.js.
  • Developed unit test cases in Mocha, Chai and Jasmine frameworks.
  • Experience in testing with Joi for Json objects created in NoSQL.
  • Expert in developing test plans, test cases, test data, test checklist, defect tracking and reporting.
  • Proficient in performing different kind of testing like Smoke Testing, Unit Testing, System Integration Testing (SIT), Integrated Functional Testing (IFT), Automation Testing, User Acceptance Testing (UAT), Functional Testing, Regression Testing, GUI Testing, Ad-hoc Testing, Database Testing, Exploratory Testing, Browser Compatibility Testing.
  • Extensively involved in gathering requirements, developing Test Plans and Test Cases using use case documents.
  • Good experience in User Interface Testing of client server & web based applications, Database and Data Warehouse Testing.
  • Worked on DevOps environment with test automation.
  • Extensive experience in testing of client/server, WEB Based, Stand-alone and database applications developed in Java, Node.js, Java Script, NoSQL DB, ORACLE and Windows etc.
  • Strong knowledge and experience in all phases of Software Development Life Cycle (SDLC), Agile Methodology and QA Life Cycle (STLC).
  • Experience in analyzing and understanding business requirements and functional specification documents.
  • Experience in Adhoc testing, Integration Testing, Retesting, Regression Testing, Positive and Negative Testing.
  • Functional Testing experience involves Test Planning, Test scenario creation, Test case writing, Test data creation using MS Excel and DB validation, Defect reporting with Test and Defect management in ClearQuest/Quality Center/Jira/ Confidential RTC and Confidential RQM.
  • Experienced in working with the Business Analyst to understand the business process and develop Test Strategy.
  • Expert in Test Case Execution, debugging and Daily status reporting to the manager and other project members.
  • Closely worked with the developer and the other testers to solve any technical and end user issues.

TECHNICAL SKILLS:

Databases: Oracle 11g/10g, MS SQL Server 2012, Confidential BD2, Teradata, SSIS, NoSQL ( Confidential Cloudant)

Languages: SQL, PL/SQL, Visual Basic 5.0, C#, Core JAVA, Java Scripting

Testing Tools: Selenium2.0, HP Quality center 9.2, Confidential Rational Clear Case 8.0, Confidential Rational Clear Quest 8.0, JIRA, Silverlight defect tracking tool, Confidential Rational Function Test, RQM, RTC

Operating Systems: Windows, UNIX, Linux, OS/400

Web Technologies: HTML, CSS, XML, Java Script.

Version Control Tools: VSS, SVN, GitHub, ZenHub

PROFESSIONAL EXPERIENCE:

Confidential, Durham, NC

Automation Test Specialist

Responsibilities:

  • Analyzed system requirements by exploring application, developed & executed detailed Test plan, Test Scenarios and Test cases.
  • Code analyzation for Node.js and JavaScript for software application requirement gathering.
  • Created unit test cases in Chai, Mocha / Jasmine framework for JavaScript Node.js application.
  • Created Joi validation for Json objects validation.
  • Tested APIs in SOAPUI tool and POSTMAN.
  • Created automation scripts in Protractor and Jasmine framework for JavaScript UI page.
  • Created Automation Scripts in RFT Framework using Java, Java Scripting and Selenium WebDriver.
  • Running the scripts through Confidential RQM in integration with Jenkins.
  • Involved in debug of automation scripts.
  • Involved in created Master Test Data based as per cloudant database.
  • Involved in maintaining Database backup and creating new Database.
  • Execute NoSQL queries in Cloudant DB for data validation.
  • Involved in helping team members to understand application requirement.
  • Maintaining test artifacts in Confidential RTC tool and test scripts in RQM.
  • Maintain code in GitHub and push to Dev/Test Environment as required.
  • Working with Jenkins and Travis in DevOps environment.
  • Involved in coordinating with different teams sitting across different countries.
  • Documented defects in Confidential RTC tool.
  • Active participation in Agile stand up meeting, scrum meeting, retrospective, iteration planning etc.
  • Conduct studies pertaining to development of new information systems to meet current and projected needs.
  • Windows 7 or similar Operating Systems environment essential in quality software development and providing documentation to application development staff and customers with result information obtained from the research and development efforts.
  • Implementing the scale down prototype initiation.
  • Incorporating the intelligence for upgrade from an existing version to a later version, with ability to foresee and effectively handle troubleshooting code.
  • Document problems and appropriate fixes.
  • Plan, Create, Maintain and Review Automation script.
  • Create, Review and Implement Automation and Functional Test Plans and Test Scenarios.
  • Monitor testing tools backend systems performance metrics to ensure optimization.
  • Act as a technical leader within the team and serve as an SME and mentor.
  • Review Non-Functional Requirements and related documents.
  • Log Defects and generate Test Reports.

Tools: & Technologies: Selenium Web Driver, JAVA, RFT, Java Scripting, Windows, MS Office, XML editor, Fire Bug, Fire Path, Confidential Cloudant Database, NoSQL, Node.js

Confidential

Data warehouse ETL Test Analyst

Responsibilities:

  • Analyzed system requirements, developed & executed detailed Test plan, Test cases.
  • Participated in various meetings with Project Managers to discuss the status of the testing and decided the best suitable test process/procedure to be followed.
  • Followed and Implemented Agile development process methodology throughout application development and testing.
  • Designed and developed Requirement Traceability Matrix (RTM) to track overall tests Coverage for release work.
  • Created Test Cases for System Testing and Integration Testing.
  • Responsible for validation Confidential data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center also tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
  • Used Teradata queries to access and validate data from different database tables.
  • Worked on Teradata Server to access the database.
  • Involved with Business and Customers to understand the application.
  • Improved Quality Processes in software development by establishing a program of formal Technical Reviews resulting in increased deliverable quality and acceptance.
  • Interfaced with Business Users, Application Development Groups and Test Groups.
  • Coordinated the Capture, Review, Maintenance and Submission to regulators of all test artifacts.
  • Participated in daily Agile Meetings and capture, manage, and follow-up daily action items and Presented testing status to Internal and External Audiences
  • Developed Selenium Automation scripts in Selenium IDE, Selenium RC and Selenium WebDriver using JAVA
  • Developed ‘Data driven’ automation framework using Selenium WebDriver.
  • Used Junit for running automation scripts.
  • Configured Continuous Integration (CI) testing using Team Foundation Server (TFS)
  • Responsible for Web Services testing by validating the XML messages using SOAPUI.
  • Worked with Selenium Grid.
  • Involved in creating and executing Regression Test Suites using Selenium.
  • Responsible for creating the Defect Status Report.
  • Responsible for follow-up and coordinating changes to resolve incidents and problems.
  • Performed Acceptance, Usability, Cross-Platform and Regression Testing during different stages of the application development.
  • Performed System, Functional, Interface, and Integration Testing.
  • Responsible for performing various types of process evaluations during each phase of the Software Development Life Cycle, including Review, Walk Through and hands on system testing.

Tools: & Technologies: Teradata, Informatica, ClearQuest, UNIX SQL Server 2008, Selenium Web Driver, Selenium RC, JAVA, Windows, MS Office, XML editor, Selenium IDE, JUnit, SOAPUI, Team Foundation Server (TFS), Fire Bug, Fire Path

Confidential

Senior Engineer

Responsibilities:

  • Coordinated all QA activities and enhancements using Agile Methodology.
  • Conducted Smoke testing, Functional testing, Regression testing, Integration testing, and User Acceptance Testing (UAT) and Data validation testing.
  • Responsible for validation Confidential data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center also tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
  • Developed and maintained multiple project deliverables such as Test Plans and Test Cases.
  • Reviewed the Business Requirement Document to understand the process and write Test Plan and Test Cases.
  • Create Crystal Reports, which would facilitate decision-making. The Crystal Reports designed were complex and used formulas, parameters, selection criteria, sub reports etc.
  • Tested the performance bottle necks at sources, targets, mappings, and sessions and employed required measures.
  • Hands on experience in collecting several metrics and come up with corrective measure to be presented to senior management.
  • Created Integrated summary data from multiple Oracle tables to represent the business perspective of the top management executives
  • Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements from various cruise specialists and the business team.
  • Prepared scripts, running tests, Analyzing results in LoadRunner 9.1 for Performance testing.
  • Developed SQL queries to check the database automatically and checking the data integrity in accordance with business standards of the company.
  • Executed SQL queries for validation of data and used TOAD for SQL Server to write SQL queries for validating constraints, indexes.
  • Executed and managed test cases and reported bugs in Quality Center.
  • Used Clear Quest and Quality Center as the Defect Management Reporting tools.
  • Performed functional and load testing using SOAPUI.
  • Used Clear Case as the Version Control tool.
  • Created and executed automated tests for functional, and regression testing using Quick Test Professional using VB scripts.
  • Inserted various types of check points including text checkpoints, text area checkpoints and Image checkpoints.
  • Hands on experience in collecting several metrics and come up with corrective measure to be presented to senior management.
  • Good knowledge of Financial Products like Derivatives, Equities and Fixed Income.
  • Hands on work experience working with offsite team model; coordinate my own efforts with team members in the off- site team.
  • Participated in User Acceptance testing (UAT) and involved in UA test cases, executed test cases, Documenting Defects, resolved defects and Signed Off from Application.

Tools: & Technologies: HP Quality Center, Manual Testing, Saber Red App, GAME, Database Testing

Confidential

Senior Engineer

Responsibilities:

  • Analyzed Business Requirement Documents (BRD) and Functional Specification Document (FSD).
  • Followed and Implemented Agile development process methodology throughout application development and testing.
  • Followed the organization’s standard documentation format for developing test plan, test cases, test data, generated test report and coordinated with development team.
  • Attended regular project meetings, workshops with BA, Network Administrators and Developers.
  • Reviewed/ modified/ created test cases and test scenarios for different types of testing like Functional testing, System testing, Backend testing, Integration testing, Performance testing, Load testing and Regression testing as per the requirement.
  • Involved in performing regression testing as Build Coordinator for verification of daily builds of Code Release to SIT, IFT and UAT server.
  • Coordinated with data support team on test data and created various test scenarios.
  • Involved in validating batch jobs for the transactions with different business scenarios.
  • Constructed and executed SQL queries to create test data and validated tables.
  • Validated the web service request and response using Soap UI, verified the XML files and data quality.
  • Involved in keeping track of SharePoint site that is used to manage project document over legacy system.
  • Validated SQL Store procedures and triggers for backend functionality.
  • Designed and Implemented Automation Test components using Quick Test Professional (QTP) to handle the functionality and regression testing.
  • Created automation test script using shared repository and descriptive programming as well.
  • Automated the test scripts using QTP for the GUI, Functional, Data Driven, keyword driven and Regression testing.
  • Created Checkpoints using VB function and involved in Parameterization in QTP.
  • Used HP ALM extensively to log Defects encountered during the Test Cycle.
  • Involved in bug review sessions and coordinated with development team to keep track of bug.
  • Gathered test results and created test status reports.

Tools: & Technologies: Java, Oracle, Manual Testing, Mainframe Testing, Automation Testing

Confidential

Senior Engineer

Responsibilities:

  • Analyzed the requirement documents and detailed design documents to prepare test plans.
  • Communicated with BA's for questions related to the requirements and use cases.
  • Initially performed White box testing with a limited number of test cases to the internal workings of software under test and in the remaining part takes Black Box approach in applying input and just observing outputs.
  • Tested the UNIX Shell Scripts of the ETL processes.
  • Worked in OLTP and OLAP environment that includes production, QA and development database in SQL Server.
  • Involved in Developing Test Strategy and Requirements Tractability Matrix (RTM) to ensure adequate test coverage.
  • Involved in Test Case Design with respect to Test Plan.
  • Executed Positive and Negative Test cases.
  • Involved in Test Execution and Bug Reporting using Test Director.
  • Performed GUI, Functional, Regression and compatibility Testing.
  • Used Joins like Inner join; Outer joins while testing from multiple tables.
  • Involved in performing various levels of testing like Unit Testing, System testing and Integration testing.
  • Develop parameter driven ETL process to map source systems to Confidential data warehouse with Informatica complete source system profiling.
  • Performed validation testing for each field in the application for different scenarios with the use of Mercury Test Director and HP QC.
  • Used Joins like Inner join; Outer joins while testing from multiple tables.
  • Tested PL/SQL procedures used in the ETL batch processes; used complex SQL queries to verify the data in the database tables.
  • Analyzed and validated the data stored in the data base by running SQL Queries using SQL Server 2005.
  • Involved in Test Reporting on daily/ weekly basis through company prescribed format.
  • Provide accurate and timely testing status reports to the QA Lead and Project Manager.
  • Participated in User Acceptance testing (UAT) and involved in UA test cases, executed test cases, Documenting Defects, resolved defects and Signed Off from Application.
  • Executed test cases through Iterative testing for testing the incremental functionality.
  • Responsible for communicating with Development Team, Technical Support, Business Support in to resolve the issues.

Tools: & Technologies: QC (HP-Quality center), Manual Testing, Database Testing, Agile Scrum

Confidential

Software Engineer

Responsibilities:

  • Involved in exploratory testing of application for requirement understanding.
  • Involved in test case scenario preparation.
  • Involved in test case design and test case execution.
  • Involved in writing SQL based on user requirement for front end report validation.
  • Involved in ETL testing using Microsoft SSIS.
  • Involved in defect logging and reporting, in JIRA.
  • Involved in preparing traceability metrics and test summary reports.
  • Involved in exploratory testing of MetaSolv application.
  • Involved in test plan document preparation.
  • Involved in client calls for clarifications and test documents walkthrough.

Tools: & Technologies: JIRA, SQL Server 2005, SSIS, ETL Testing, VSS, SVN

Confidential

Senior Engineer

Responsibilities:

  • Involved in automating the manual test cases (Data Preparation) in QC.
  • Involved in Functional testing of application for new requirements.
  • Involved in Regression Testing of Manual and Automation
  • Involved in Bug tracking and Reporting in QC 9.0
  • Performance testing on load runner
  • Involved in running automation script in QTP.

Tools: & Technologies: HP Quality Center, QTP 9.5, Manual Testing

Confidential

Senior Engineer

Responsibilities:

  • Involved in preparing Test Data.
  • Designed Test Cases/ Test Scenarios by going through the Use Cases.
  • Involved in the Functional and Regression Testing.
  • Involved in Bug tracking and reporting in JIRA.
  • Involved in preparing traceability matrix for requirements and test cases.

Tools: & Technologies: QC (HP-Quality center), Database Testing, Postgre SQL, UNIX, JIRA, SVN

Hire Now