SUMMARY:

• Over 5+ years of diverse experience in Manual and Automation Testing in both Client - Server and Web-based applications.
• Firm knowledge of different phases of Software Testing and Software Development Life Cycle (SDLC) including agile/scrum/Kanban Methodology and Waterfall.
• Experience with all phases of Software Testing Life Cycle (STLC).
• Strong Experienced on Messaging platform with various technologies KAFKA, WSO2 MB and RabbitMQ MB
• Strong experience on PrefChoice (Preference management system)
• Well versed in analyzing Business Requirements, Functional Specifications, Technical Specifications and Use Cases for preparing Test Plans, Test Scenarios, Test Cases, Test Scripts, Test Data and Test Reports.
• Experience in Test Management and Testing Lifecycle Methodologies Agile Models & Waterfall.
• Experience in interacting with Product Owner,business analysts, developers, technical support and help them in base line the requirement specifications.
• Good Team Player,Strong work Ethic and taking Ownership of Duties and Responsibilities
• Provided technical, validation and process related training to team members.
• Responsible to demo the automated scripts at the end of the sprint.Sometimes demo the product to the Clients with the assisting to Product Owner.
• Attended all the meeting related to Agile Process like Daily stand up, Retrorespective etc.
• Experienced in performing Smoke, Functional, Regression, Ad-Hoc, System and Negative tests.
• QA estimation of Functional and Regression testing and assist in the identification of testing environment needs
• Responsible for creating Test Cases in TestRail, reviewing Test cases with BA and prioritizing test cases and ensures test cases are approved by Product Management and Development Engineers
• Responsible for executing test cases and communicating the test issues and results to the team
• Experienced in identifying manual test cases that could be converted into automated test cases, defining test cases, developing and maintaining test scripts
• Developed Junit tests in Eclipse Run tests, REST API testing with SoapUI.
• Knowledge in QTP Automation tools using VB Scripts framework.
• Have extensive knowledge about ETL (Informatica PowerCenter, Informatica Data Quality), SQL and UNIX.
• Built Robot Framework rubust way also created customized library by using Python
• Wrote Test Scripts in Robot Framework using python,prepared automation test framework.
• Wrote Test Scripts by using Cucumber tool with TDD and BDD Framework using selenium in java and prepared automation test framework.
• Strong Experienceed to do Back End testing and End to End Testing with writing complex query for JSON object
• Done performance tests using Jmeter connecting to AWS
• Experience in validating the data by writing and executing SQL Queries in various data base’s including Oracle, SQL Server, PostgreSQL, Informix Database and My-SQL.
• Having excellent experience working with EDI HIPPA (834) X12 Transactions.
• Experience in SOAP Web Service Testing using SOAP UI tool.
• Extraordinary Testing exxperience with RESTful Services with JSON and XML format .
• Experience with RESTful Web Service Testing with JSON.
• Experience of back-end testing on UNIX to check the log files and permission etc
• Experience with various Bugs and defects tracking tools JIRA/Rally, Test HP ALM
• Good experience in Microsoft tools Word, PowerPoint, Excel and Access, IDE RIDE for Robot framework and Sublime as well notepad++
• Good Communication, Documentation, Interpersonal, Analytical and Problem Solving Skills

TECHNICAL SKILLS

Testing Tools: Robot Framework, RIDE, Postman,REST advanced Client,SoapUI,HP ALM, Jira, Jira Agile, Selenium WebDriver/Grid/TestNG/Cucumber BDD, JUnit, Jmeter, QTP/ TesRail/ SONAR CUBE/Perforce/SVN/Github

Operating Systems: Windows 95/98/2000, Unix, LINUX

Languages: Java, J2EE, SQL, JSON,Python,COBOL,HTML,XML, VB Scripts and Java Scripts

Database: Oracle 11i, Informix, PostgreSQL, SQL Server, SQL Developer, TOAD.

Methodologies: Agile/Scrum, Waterfall and Iterative, Kanban

Bug Tracking tools: JIRA, Rally, HP ALM, Clear Quest, TestRail

Web Technologies: Java/ Java Script, HTML,IIS, SOAP UI/Parasoft, JSON/SPARK, Tomcat, Jenkin, Kafka, WSO2 MB, RabbitMQ MB

Web Browsers: Internet Explorer , Mozilla Fire fox ,Chrome

EDI Standards: ANSI X12, EDI HIPPA(834)

ETL Tools: Informatica Power Center 9.5.1, Informatica Data Quality

PROFESSIONAL EXPERIENCE

Confidential , Omaha, Nebraska

QA Automation Engineer

Responsibilities:

• Reviewed Acceptance Criteria from User Stories from backlog, Requirement Documents, functional specification.Involved in developing testing scope, strategy, test requirements and necessary resources.Developed Test Cases to cover all AC .
• Review Test Cases with BA and Team and Update Testcases in TestRail
• Performed functional testing by using Postman tool sometimes do functional testing manually by using SOAP UI tool.
• Validate the messages in queues in RabbitMQ MB
• Validate the form of the message and different type of validations in backend DB
• Writing automation Scripts in RIDE IDE in Robot Framework
• Performed Automation testing in Robot Framework through CI Jenkin server
• Performed Back End Testing by writing complex SQL Query in PostgreSQL and Informix DB(OracleDB)
• Performed Regression Testing , Database testing configuring through Jenkins server
• Reviewed the test scripts written by others team members against the requirements and suggested any Corrections and enhancements required.
• Integrate Robot framework testcases to TestRail and create Dashboard
• Executed tests in TestRail through nightly build scheduled through Jenkins
• Reported bugs through JIRA and validated bug fixes. Presented bug reports on daily standup meeting and defect age reports in weekly team meetings.
• Performed Performance testing by using Jmeter as needed through command line and create graphical dashboard for Product management Personal.
• Done some POC for different Technologies , wrote CPD, swaggar, Technical Release notes
• Experience on installing Software and different tools by using Linux command in different environments

Environment: JIRA, UAT, XML, Window NT/XP, HTML, PostgreSQL, Excel, Informix(Oracle DB), LINUX, Oracle11i,Mongo DB,QA LAB, AWS, IE 10 /Windows, Tomcat , Jboss

Confidential , Lakewood, CO

ETL Tester/ QA Analyst

Responsibilities:

• Reviewed Requirement Documents, functional specification.Evolved in developing testing scope, strategy, test requirements and necessary resources.Developed Test Cases to cover overall quality assurance testing.
• Performed functional, Regression, Database testing. Performed reviews of the test scripts written by others team members against the requirements and suggested any enhancements required.
• Validated test cases through review meetings
• Worked on Agile Automation tool Selenium Webdriver using Java/Cucumber/JUNIT/TestNG BDD framework
• Executed tests in TestLab. Reported bugs through JIRA and validated bug fixes. Presented bug reports, defect age reports in weekly team meetings.
• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into ODS Confidential , Exchange, Carrier Recon etc databases.
• Extensively done ETL Testing by using SQL query.
• Involved in extracting the data from the EDI Inbound, EDI Outbound files and Relational databases into staging area.
• Tested Mappings, Sessions, Workflows, writing Source query to test data in database level
• Mappings, Sessions, Workflows from Dev to Test and then to UAT environment and Deployed to Production Environment.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Imported various heterogeneous files using Informatica Power Center 9.5.1 Source Analyzer.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Created Sessions and extracted data CDC to Staging Area and loading into ODS.
• Performed Unit Testing in TEST and UAT environment and deploy code to Production.

Environment:  JIRA, UAT, XML, Window NT/XP, HTML, DB2, Excel, SQL Server 2008 R2, UNIX, TOAD, Oracle11i,SQL Developer

Confidential, Denver, CO

QA Test Engineer

Responsibilities:

• Gathered specifications and requirements prior to testing. Test requirements were then documented in JIRA
• Worked on Agile/Scrum development environment with frequently changing requirements and features sets. Delivered well-designed and written test cases to the project. Meet daily with Business analysts, Product Staff and Development on Test Issue and Requirements.
• Worked with product designers, business analysts and developers at all stages to promote quality. Primary responsibility for identifying problems with the software and design, involves close interaction with the development and support team members
• Used the guidelines of Serenity framework and used Cucumber Framework to help to build BDD framework and Wrote the automation script from scratch using Java/Selenium WebDriver
• Worked simultaneously with multiple requirements/projects concurrently in a matrix managed environment. Plan and produce test case steps in Jira. Execute manual tests.
• Collaborated within and outside test team to achieve desired end result. Took part in delivery scope meeting and initiated testing process to deliver high quality product. Accountable for timely and quality test deliverables throughout the project life cycle.
• Produced and prioritized bug reports, reproduce bug reports using Jira. Coordinate with the development/support teams to ensure required test platforms are available. Prepared deliverables such as Test summary reports and Test metrics documents based on coverage. Write SQL queries to access data from the database tables and validated the result
• Run Smoke/sanity, Ad-hoc testing and also exploratory testing to the developers machine
• Performed regression, functionality, system, front-end, back-end, negative and positive tests. Validated database operations by executing SQL statements against the back-end database
• Participated in daily and weekly team and task and review meetings
• Interacted with the QA managers for the regular updated of projects

Environment: Java/J2EE, Oracle, SQL Server, DB2, AIX, Jira Agile, UNIX, J2EE, Jboss, WAS, Flex, IE10