SUMMARY

• Six years of experience in IT Industry on Senior Test Engineer in Manual and automated testing that covered waterfall, Agile/scrum process and validation of data base and repositories.
• Expertise in different types of testing like Automation testing, Manual testing, Integration testing, System testing, Smoke testing, Regression testing, Black box testing, Functional testing, Database testing, GUI testing, ETL Testing, Web/UI and (UAT)User Acceptance Testing.
• Extensive experience in ETL/ Data warehouse backend testing and BI Intelligence reports testing.
• Worked in all phases of SDLC and STLC
• Strong experience in testing specifications, test plan development and transforming the use cases into test cases and drafting test summary reports
• Proficient in Test case design, Test data design, Test execution.
• Specialize in Functional Testing, System testing, Integration Testing, Regression Testing and User Acceptance Testing of Web and Client - Server applications
• Performed the manual testing, regression testing, smoke testing, UAT testing, back end/data base testing using the SQL queries.
• Experience with Cross-Browser and Compatibility Testing to test whether the web applications are working as desired in different browsers and environments.
• Experienced in using Test Management tools such as HP ALM, JIRA, Bugzilla reporting tools to track test progress, execution and deliverables.
• Excellent experience in different Databases like Oracle, MS SQL Server, DB2 and Teradata.
• Experience in developing and running the automated scripts in QTP/UFT and selenium.
• Written SQL Queries to define, Identify and validate the code written for the data movement into the database tables
• Experience on Postman in posting and running requests to validate XML files for the integration of different systems
• Experienced in web services testing using SOAPUI tool for Soap and Rest Web services.
• Performed duties as an individual contributor and can manage multiple projects and tasks simultaneously. Excellent inter personal communication, analytical skills.
• Strong experience in closely working with developers during development of the requirements at component level in Agile Scrum Development Methodology with Test Driven Development process and achieved in delivering the deliverables on time and performed testing in system level end to end flow depends on the requirement.

TECHNICAL SKILLS

Methodologies: AGILE (SCRUM), WATERFALL, Iterative, SDLC, STLC

Testing tools: QTP, SOAPUI, Postman, Informatica, Selenium

Programming Languages: C, C++, Java

Databases: MYSQL, Oracle, SQL Server, Teradata

Markup Languages: HTML,CSS,XML

Operating Systems: WINDOWS, Unix, Linux

Frameworks: Keyword driven, Data driven

Markup & scripting lang: HTML, CSS

MS Office Tools: Outlook, MS Word, MS Excel, MS PowerPoint, MS Access

Other tools: Jira, Charles Proxy, Bugzilla

PROFESSIONAL EXPERIENCE

Confidential

Senior Test Engineer

Tools: QC, JIRA, Postman, Informatica, PL SQL developer

Responsibilities:

• Design the required Test Strategy in line with the scope and organization standards and Create the software Test Plan, get it reviewed and approved/ signed-off by the relevant stakeholders
• Analysis of technical specification documents, Business Requirement document and mapping documents.
• Assessed & analyzed user stories and participated in Sprint planning, Review Sessions & Scrum Meetings and developed Test scenarios, Test cases, Test data, Test procedures, Test reports.
• Create and Maintain RTM for keeping track of requirements and Reporting purpose.
• Perform test execution in master site and in different subsites.
• Perform testing on mobile devices and iPad/ tab.
• Validate the data processed through webservices.
• Edit the XML files based on mapping documents and post the request through Postman
• Validate the data processed through different integrated systems.
• Prepare SQL queries and execute to validate the ETL processed data in target database.
• Change the status in JIRA daily as per the execution status.
• Worked with developers to update the defects, resolve them and track their status using HP ALM.
• Experience in RDBMS, Microsoft SQL Server (T-SQL), Oracle (PL/SQL), MS Access and associated SQL Programming Knowledge.
• Extensive Working experience in applying Relational Database Concepts, Entity Relation diagrams and Normalization concepts.
• Collect the queries related to the requirements and get them resolved by the business person (e.g. the client, business analyst, product manager or project manager) assigned to the project
• Communicate with the client or on site/ offshore team members, as required.
• Review the test cases and test data generated by the Software Test Engineers and get them to address the review comments.
• Track the new/ updated requirements in the project and modify testing artifacts accordingly.
• As part of regression testing, used existing Hybrid framework in Selenium and added new functions to the existing code based on the new requirements.
• Generate the execution status reports daily/ bi-weekly and send to all the stakeholders.
• Participate in QA weekly meetings and various other meetings and discusses enhancement and modification request issues and defects in the application
• Prepare Test summary report/ sign-off document

Environment:: ETL Testing, Selenium, Web Services, SOAP UI, HTML, CSS, XML, JIRA, Quality Center, Oracle11g, MSWord, MS Excel, PL/SQL Developer, Agile/ Scrum Methodology, ecommerce, Teradata

Confidential

Senior Test Engineer

Tools: QC, JIRA, PL SQL developer

Responsibilities:

• In line with Migration, Provisioning Team and plan testing activities for the applications considered for each Migration Phase.
• Evaluate the need for Functional / Regression/ Database Testing.
• Understand application functionality and Critical Business processes.
• Interact with the customers for getting the KT of the applications and understand the functionality of the applications.
• Create Test Cases for each application and review of application test documentation with Application Owners and BU IT PMs.
• Create Test Cases - Prepare, Review and Approve Test cases for each application.
• Execute Test Cases - Execute, Review and Approve Test Results for each application.
• Perform Informal testing on one Non - production environment and Perform Formal Testing on one Non-production and Production environment.
• Perform Manual installations wherever required.
• Logged defects in JIRA and Reported defects to developer and discussed about the issues in weekly status meetings
• Re-test wherever required- Bug Fix Testing.
• Prepare, Review and Approve Test Summary Report or Sign Off document for each application.

Environment:: ALM/Quality Center, Web server, JIRA, BugZilla, Jenkins, Cmd, PL SQL, UNIX, Windows 7, Oracle.

Confidential

Test Engineer

Tools: IBM’s PSC tool, QC, QTP, PL SQL developer

Responsibilities:

• Attending KT sessions conducted by the client and discussed on the functionality of the application.
• Analysis of functional requirement specification documents.
• Designing test plan, test scenarios, test cases, test data and requirements traceability matrix (RTM).
• Performed GUI, Functional, Negative, Positive, Regression, Data validation and User Acceptance Testing.
• Used PL/SQL for data retrieving and analysis tests.
• Preparation of Test Data process the data to portal and validate the processed data against ilog rules.
• Used QTP to load the data to the Data Entry Portal tool.
• Built test driven framework and Used QTP Checkpoints and Regular Expressions for checking web pages, images, texts, and tables.
• Defect reporting, Analysis and Tracking using Quality Centre tool and prepare Test Report.
• Attend daily status calls with client and provided the status on Testing tasks and progress.
• Coordinated with developers and record defects in ALM to track until they are resolved.
• Maintained Test Matrix & Project Matrix using excel sheet to keep track of Project's schedule and status.
• Attended weekly status meetings with development and management Teams.
• Prepare handy documents on the project functionality.
• Involved in testing various business rules User/Customer functionalities, and Change Processes
• UAT support was given for some releases.
• Prepared user documentation with screenshots for UAT (User Acceptance testing).

Environment: Manual Testing, Automation Testing, Quick Test Professional(QTP)/UFT, Oracle, HP Quality Centre, PLSQL, Database Testing

Confidential

Test Engineer

Tools: QC, PL SQL developer, Informatica, Soap UI

Responsibilities:

• Understanding the Business Requirement documents and Source to target mapping documents.
• Involved in Integration, System, and Regression testing.
• Experience in writing and designing templates for the Test Plans and Test cases.
• Involved in Preparation of Test Scenarios and review of Test Cases.
• Involved in updating and executing test cases according to requirements.
• Wrote SQL Queries to connect to the database and retrieve data for a specified set of test requirements.
• Identified the Test Cases and documented them in Quality Center.
• Validate the data retrieved against mapping documents.
• Run the respective workflows in Informatica to push the date in different repositories.
• Edit the test data in Soap UI and verify in the application.
• Prepared various reports based on different stages of Testing.
• Updated Reports and dashboards to display the status of test coverage including the number of test cases passing, failing or pending.
• Interacted with developers, users and various members of the team to discuss issues, resolve defects and set priorities.
• Involved in Status calls with Clients and coordinated with them regarding project related issues and status of the project.
• Share Daily Status Report with all the team members, Team Leads, Managers and Clients.
• Worked in waterfall methodology.
• Involved in Managerial Meetings and attended various conference calls at different levels from QA, Developers and Clients.

Environment: HP Quality Centre, PLSQL, Database Testing, MS Excel, Waterfall, SOAP UI, Teradata