SUMMARY

• Senior ETL/Automation Quality Analyst 12+ years of experience in Software Testing across Telecom, Logistic, HealthCare, E - commerce, Travel & Transport, Airline, ERP, OMS and Finance domains (Insurance).
• Created automation framework in TestNG/BDD framework Cucumber in Eclipse IDE.
• Worked wif Jenkins and GitHub as devOps process.
• Integrated practice wif API automation using Rest Assured library.
• Well versed in implementing java Oops concepts like Object, Class, Abstraction, Encapsulation Inheritance and Polymorphism.
• Executed database testing and data warehouse testing wif ETL tools K2View, QuerySurge, Microsoft SSIS and Informatica.
• Expertise in testing SSIS ETL packages, SSRS reports, K2View Logical Units, Informatica Power Center.
• Access expertise in different databases like Oracle SQL Developer, MS SQL server, Cassandra, Hadoop.
• Experienced in data analysis, SQL functions of Datawarehouse applications.
• Involved in BI testing and testing SAP BO reports and Tableau reports.
• Automation Testing in JavaScript and Confidential Rational Functional Tester tool.
• Knowledge presence in Protractor testing wif Jasmine and node.js.
• Developed unit test cases in Mocha, Chai and Jasmine frameworks.
• Tested wif Joi for Json objects created in NoSQL.
• Experienced in testing web services in SOAUPUI, K2View Swagger and POSTMAN tools.
• Expert in developing test plans, test strategy, 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.
• Expertise in Black Box testing and aware of White Box 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 wif test automation.
• Extensive experience in testing of client/server, WEB Based, Stand-alone and database applications developed in Java, Node.js, Java Script, .Net, 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 wif Test and Defect management in ClearQuest/Quality Center (HP ALM)/Jira/ Confidential RTC and Confidential RQM.
• Experienced in working wif 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 wif the developer and the other testers to solve any technical and end user issues.

TECHNICAL SKILLS

Databases: Oracle 11g/10g, MS SQL Server 2012/2014, Confidential DB2, Teradata, SSIS, NoSQL ( Confidential Cloudant), Visual Studio 15

Languages: SQL, Visual Basic 5.0, Core JAVA, Java Scripting

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

Operating Systems: Windows, UNIX

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

Version Control Tools: VSS, SVN, GitHub, ZenHub, TFS

PROFESSIONAL EXPERIENCE

Confidential, Seattle, WA

ETL/API Quality Analyst

Responsibilities:

• Analyzing Schema in K2View fabric for understanding tables, relations and different sources.
• Designed LU schema and created tables.
• Unit testing and optimizing the performance.
• Analyzing the Java functions to understand data structure.
• Analyzing the business data in the SQL developer for different sources/clients to understand and validate Micro Services created in the Cassandra database.
• Analysing the user stories created in Jira for ETL validations.
• Validating Translations Data and table pop functions for Logical Unit.
• Design complex SQL queries for source data in Oracle SQL developer and K2View Fabric Studio based on the requirements using joins and advance SQL functions.
• Creating test data for different Verizon client validation.
• Preparing test cases in qTest tool.
• Execute queries in SQL developer and K2View Data Viewer to validate source to Confidential table data.
• Validating table structure for Logical Units.
• Validating lookup tables.
• Validating table execution performance for different clients.
• Running sql queries in Putty for different servers/environments as part of data validations.
• Validating data in fabric studio for different servers by updating Interfaces (Cassandra, oracle DB) in K2View
• Maintaining test results in Jira for respective user stories and updating sub tasks created for testing.
• Working in K2View Fabric Studio for Data Management and Integration.
• Validating Web Services/ API data using Postman, K2View Swagger and SoupUI tools.
• Create, Review and implement Automation and Functional Test Plans and Test Scenarios.
• Act as a technical leader wifin the team and serve as an SME and mentor.
• Review Non-Functional Requirements and related documents.
• Log Defects and generate Test Reports from Jira.
• Validating UI tool created for different client’s data as per products like Access, Non Access etc which is derived from API.
• Testing using Command Line Interface (CLI) for platform testing and data quality checks wif QuerySurge when porting the current text automation solution to a script-less test automation framework leveraging Winium and Python libraries.
• UI automation in Selenium WebDriver wif Java.
• Working wif third party tools PB (Prime Biller), CAMEO, OM+ (Order Management Plus), vPrice to validate Verizon business data.
• Active participation in daily stand-up meeting, and review, plan and retrospective.

Confidential, Raleigh, NC

ETL / Web Service Tester

Responsibilities:

• Analyze system requirements/ business requirements by exploring application and/use case document.
• Developed & executed detailed Test plan, Test Scenarios and Test cases.
• Writing SQL queries to validate data from web portal to backend.
• Used database to get different data like claims, member, benefits etc by firing sql queries.
• Involved in creating SQL queries for web service validation based on the requirements and validating database for updated service response in MS SQL Server 2016.
• Testing web services through SOAPUI tool and Test Harness Application.
• Worked in onsite and offshore model.
• Reviewing test cases and test scenarios designed by team.
• Execute test cases and log defects.
• Tracking the defects to closure and created test reports like defect summary, test summary.
• Involved in Demo session on completing user stories.
• Involved in Sprint Planning, Sprint Backlog refinement, Review and Retrospective.
• Creating tasks in Rally tool and updating status on daily basis for the team.
• Active participation in Agile stand up meeting.
• Document problems and appropriate fixes.
• Interacting wif clients on requirement gathering.
• Worked wif business team on UAT testing.
• Interacting wif Dev team on clarification if needed.
• Log Defects and generate Test Reports.
• Creating Claims in HSP MediTrac.
• Testing EDI claim 837.
• Experience in using MediTrac tool for search provider, member etc.

Confidential, GA

DW/ ETL QA Analyst/ QA Lead (SDET)

Responsibilities:

• Analyzed system requirements/ business requirements by exploring application and/use case document. Developed & executed detailed Test plan, Test Scenarios and Test cases.
• Coordinating wif project manager on resource allocation, providing test estimation.
• Worked closely wif business users on requirements and halping in UAT testing.
• Creating different test artifacts or project deliverables like test coverage, resource details, and defect summary to the client.
• Adding ETL packages to visual studio and analyzing the SSIS ETL packages, understanding the requirement and designing ETL test cases for data validation.
• Writing complex SQL queries for data warehouse table validation from the source and Confidential and transformation logic.
• Validating data in different stages of ETL like worktable, staging, Confidential load etc.
• Creating test cases (SQL Queries) for BI reports validation.
• Generating different reports from universes in SAP BO and adding filters and validating data.
• Testing SSRS reports.
• Validating data on daily/weekly/monthly basis jobs.
• Responsible for designing automation framework best suitable for the requirement.
• Assist team members on automation tools and requirements
• Worked closely wif project manager on getting automaton framework for the project.
• Plan, Create, Maintain and Review Automation script.
• Created automated test script in Java and Selenium WebDriver for java backend application.
• Reviewing test cases and test scenarios designed by offshore team.
• Execute test cases and log defects.
• Tracking the defects to closure and created test reports like defect summary, test summary.
• Involved in Sprint Planning, Sprint Backlog refinement, Review and Retrospective.
• Creating tasks in VersionOne tool and updating status on daily basis for the team.
• Allocating work to the team and status update to the scrum master.
• Interacting wif offshore team and getting work done.
• Documented defects in VersionOne and ALM tool.
• Active participation in Agile standup meeting.
• Worked in 2 teams RPM built for agents and BI team.
• Document problems and appropriate fixes.
• Interacting wif clients on requirement gathering.
• Interacting wif Dev team and providing clarification to QA team if needed.
• Creating CSRE and MTP before user story elevation to production server.
• Making sure Dev team TEMPhas unit tested before approving QA case for further elevation.
• Create Review and Implement Functional and ETL Test Plans and Test Scenarios.
• Monitor testing tools backend systems performance metrics to ensure optimization.
• Act as a technical leader wifin the team and serve as an SME and mentor.
• Review Functional Requirements and related documents.
• Log Defects and generate Test Reports.

Confidential, Durham, NC

Manual or Automation QA / QA Lead (SDET)

Responsibilities:

• Analyzed system requirements/ business requirements by exploring application and/BRD, developed & executed detailed Test plan, Test Scenarios and Test cases.
• Reviewing test cases and test scenarios.
• Execute test cases and log defects.
• Tracking the defects to closure and created test reports like defect summary, test summary.
• Involved in user story points meeting and preparing estimation report for the requirements.
• Created RTM and updating accordingly on daily basis status.
• Allocating work to the team and status update to the product owner.
• Involved in UAT testing and production defect validation.
• Interacting wif teams sitting in other countries and getting work done.
• Documented defects in Confidential RTC tool.
• Active participation in Agile stand up meeting, scrum meeting, retrospective, iteration planning etc.
• Creating user stories in RTC tool and updating acceptance criteria according product owner confirmation.
• Conduct studies pertaining to development of new information systems to meet current and projected needs.
• Implementing the scale down prototype initiation.
• 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/ web services in SOAP UI tool and POSTMAN.
• Created automation scripts in Protractor and Jasmine framework for JavaScript UI page.
• Created Automation Scripts in Rational Functional Tester Framework using Java, Java Scripting and Selenium WebDriver.
• Running the scripts through Confidential RQM in integration wif Jenkins.
• Involved in debug of automation scripts.
• Involved in creation of Master Test Data based as per cloudant database.
• Involved in maintaining Database backup and creating new Database.
• Execute NoSQL queries in Confidential Bluemix Cloud DB ( Confidential Cloudant) for data validation.
• Uploading user data from spreadsheet to Bluemix cloud DB in json format.
• Maintain databases in cloud database hosted on Confidential bluemix.
• Build deployment from bluemix pipeline from Dev to Test environments.
• Involved in halping 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 wif Travis/Jenkins in DevOps environment.
• Worked in Confidential Cloudant pipeline CI for build deployment.
• Involved in coordinating wif different teams sitting across different countries.
• Incorporating the intelligence for upgrade from an existing version to a later version, wif ability to foresee and effectively handle troubleshooting code.
• Document problems and appropriate fixes.
• Responsible for designing automation framework best suitable for the requirement.
• Assist team members on automation tools and requirements
• Worked closely wif test manager on getting automaton framework for the project.
• Plan, Create, Maintain and Review Automation script.
• Create, Review and Implement Functional Test Plans and Test Scenarios.
• Monitor testing tools backend systems performance metrics to ensure optimization.
• Act as a technical leader wifin the team and serve as an SME and mentor.
• Review Functional Requirements and related documents.
• Log Defects and generate Test Reports.

Confidential, GA

ETL/Sr. Manual Test Analyst

Responsibilities:

• Analyzed system requirements, developed & executed detailed Test plan, Test cases.
• Participated in various meetings wif 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.
• Used SQL queries to access and validate data from different database tables.
• Worked on MS SQL Server to access the database.
• Involved wif 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 wif 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
• Involved in creating and executing Regression Test Suites using Selenium.
• Responsible for creating the Defect Status Report.
• Responsible for maintaining RTM, requirement traceability matrix.
• 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/Manual, 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.

Confidential

ETL Test Analyst

Responsibilities:

• Analyzed system requirements, developed & executed detailed Test plan, Test cases.
• Participated in various meetings wif 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.
• Used SQL queries to access and validate data from different database tables.
• Executed test cases in Teradata.
• Validating data marts wif reference to source data.
• Worked on MS SQL Server to access the database.
• Created query pairs in QuerySurge tool to compare data from source to Confidential .
• Involved wif 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 wif 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
• Involved in creating and executing Regression Test Suites using Selenium.
• Responsible for creating the Defect Status Report.
• Responsible for maintaining RTM, requirement traceability matrix.
• 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/Manual, 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.

Confidential, AZ

ETL / Manual Test Engineer/ QA Lead

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.
• 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.
• Hands on experience in collecting several metrics and come up wif 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.
• Developed SQL queries to check the database automatically and checking the data integrity in accordance wif business standards of the company based on the requirement mapping and data model.
• Executed SQL queries for validation of data and used TOAD and 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 SOAP UI.
• Used Clear Case as the Version Control tool.
• Created and executed automated tests for functional, and regression testing using Selenium WebDriver in Java and Junit.
• Hands on experience in collecting several metrics and come up wif corrective measure to be presented to senior management.
• Involved in Developing Test Strategy and Requirements Tractability Matrix (RTM) to ensure adequate test coverage.
• Good knowledge of Financial Products like Derivatives, Equities and Fixed Income.
• Hands on work experience working wif offsite team model; coordinate my own efforts wif 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.

Confidential

Senior Test 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 wif development team.
• Attended regular project meetings, workshops wif 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 wif data support team on test data and created various test scenarios.
• Involved in validating batch jobs for the transactions wif different business scenarios.
• Constructed and executed SQL queries to create test data and validated tables from ETL mapping documents & data model.
• Validated the web service request and response using Soap UI, verified the XML files and data quality.
• Involved in keeping track of SharePoint site dat 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.
• Used HP ALM extensively to log Defects encountered during the Test Cycle.
• Involved in bug review sessions and coordinated wif development team to keep track of bug.
• Gatheird test results and created test status reports.

Confidential, MN

Senior Test Engineer

Responsibilities:

• Analyzed the requirement documents (use case, wireframes) and detailed design documents to prepare test plans.
• Communicated wif BA's for questions related to the requirements and use cases.
• Initially performed White box testing wif 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.
• Involved in Developing Test Strategy and Requirements Tractability Matrix (RTM) to ensure adequate test coverage.
• Involved in Test Case Design wif 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.
• Performed validation testing for each field in the application for different scenarios wif 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 wif Development Team, Technical Support, Business Support in to resolve the issues.
• OMS knowledge on oracle application.

Confidential

ETL Test Engineer/ Sr. Test 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.
• Involved in testing Oracle billing and customer care modules.

Confidential

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
• Running automated script in UFT tool.
• Performance testing on load runner
• Involved in running automation script in QTP.

Confidential

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 requirement traceability matrix (RTM) for requirements and test cases.