SUMMARY:

• A competent QA professional with 9 years of Manual and Automation Testing within Retail, Healthcare and Credit Card Banking domains. Expert in Test strategy design, Regression analysis and implementation, QA planning and execution within project lifecycle and Test Data Management.
• Proficient within Web and Mainframe based applications, Defect lifecycle management with tools (HP - ALM).
• Strong with Database concepts and SQL Queries, Manual testing on Client/Server and Web Services testing.
• Experience in reading the test data from XL spread sheets using Apache POI Jars and TestNG Data provider.
• Experience in ETL Testing/Data warehousing testing /Data Quality testing.
• Understanding and Analyzing the Application under Test in terms of Object Identification.
• Creating Test scenarios and Collecting Test Data.
• Identifying end to end scenarios and code modularity.
• Implementing JUnit or TestNG Test Automation framework and developing automation infrastructure.
• Creating and enhancing Test Cases (Test Scripts) using Element locators, WebDriver methods, Java programming concepts and TestNG Annotations.
• Creating Data driven Tests and Running through framework.
• Cross Browser Testing (Executing test cases against various browsers like Mozilla Firefox, Google chrome, IE and Safari, etc.).
• Parallel Test Execution. Defining and exporting Test Results.
• Analyzing Test Results and Reporting Defects.
• Tracking Defects and Select Test cases for Re & Regression Testing.
• Modifying Test Automation Resources and Maintenance of Resources.
• Solid understanding of ETL source to target data mappings and transformation rules.
• Exposure to Informatica/ETL development and monitoring environment (Designer, Workflow Manager and Workflow Monitor).
• Quality Assurance Analysis and End-to- end Testing (Functional, integration, Regression, API testing).
• Executed automation scripts on different browsers and reported defects/results to the team.
• Involved in developing Test Plans, Test Cases, Test Scripts, Traceability Matrix and Test Environments and analyzing Test Results.
• Experience in Testing Database Applications (ORACLE, DB2, MS SQL Server, Sybase and MS Access).
• Proficient in IBM Mainframe Technologies such as COBOL, CICS, JCL, DB2, VSAM, File-Aid, Spufi, QMF etc. in MVS, Z/OS environment.
• Experience in creating Test Cases, Test Plans, Technical Design
• Good understanding of data warehousing concepts and data analysis.
• Expertise in System Testing, UAT, Production Support and Maintenance Services.
• Strong knowledge of relational database design concepts.
• Working experience in Oracle, SQL Server, Teradata and IBM DB2.
• Excellent testing experience in all phases of Software Development Life Cycle (SDLC) and agile methodologies.
• Excellent SQL skills to build complex queries.
• Expertise in Project documentation, Testing and Quality audit reviews.

TECHNICAL SKILLS:

Programming Languages: Oracle PL/SQL, Shell Script, Java COBOL, JCL, CICSDatabases DB28.1, IMS/DB, SQL Server 2005, Oracle 7.x/8.0 9i

Defect Tracking Tools: HP Quality Center 10, HP ALM, Rally, Jira and Confluence

OS/Languages: MVS/ESA, OS/390, Z/OS, Windows, Windows 98/ME/XP, UNIX, C, C++, JAVA, SQL, VB 6.0 NT/2000/XP

Testing Tools: Mercury Interactive Win Runner 7.6/8.0, Load Runner7.8/8.0, Selenium, Quality Center 12.0, TestNG

Other Tools: Maven, Jenkins, SharePoint, Hogan, Lotus Notes, XML Spy

Hardware: IBM Mainframe

EXPERIENCE:

Confidential, WestChester, PA

Sr.QA Analyst

• Validated the lifecycle of Order processing, Demand management, Shipment status
• Validated the Extract File data on Mainframes.
• Involved in testing WebServices and XML with SOAP UI.
• Creating Process Flow Diagram, Context Diagram and Activity diagrams using UML.
• Worked on data modeling and produced data mapping and data definition documentation.
• Validated the Execution and Scheduling of Batch Jobs in Mainframes (JCL).
• Designed and developed Use Cases, Work flows and Activity Diagrams using UML.
• Assisted with design and development teams for missing functionality while designing and implementing.
• Used XML and SOAP to exchange structured and typed information with help of Web Service over internet.
• Validated the WebServices using SOAP UI to test the XML requests and the responses.
• Verified Log files, Data sets and Reports by logging into the Mainframes.
• Tested the database integrity by writing SQL Queries using QMF on Mainframes.
• Interacted with development and testing teams to improve the quality and functionality of the application.
• Used JIRA to document defects and Release tickets.
• Reviewed test plans, test cases for testing the project.
• Creating Jobs to run daily, weekly and monthly basis to process ETL Jobs using Informatica.
• Used the Informatica to schedule jobs, testing and debugging its components and monitoring of results
• Tested Informatica ETL data Validation.
• Performed Database testing (Data Warehouse/ETL) on ETL applications validating the data in Sources/Targets.
• Documented the mappings used in ETL processes.
• Created tasks and workflows in the Task Manager and Workflow Designer respectively provided with Workflow Manager of Informatica.
• Performed data validation testing after the ETL process using Informatica.
• Followed project milestones and created test data and executed test scripts and defining test plans from functional, regression, end to end and performance testing through acceptance for Web Services/APIs (SoapUI)
• Tested the CICS (Mainframe) Screens and TSO/ISPF Applications.
• Facilitated UAT (User Acceptance Testing) with Business Users.

Environment: Postman, SOAP UI, MS Office Suite, Jira, CICS, WebSphere, IBM BPM Tool, SQL Server, Rally, Application Interface API, Rest Client, ETL, HP ALM, XML, DB2, JCL, TESTNG, Maven, Firebug, Firepath, Eclipse, Jenkins, GitHub, Web Based Applications, SQL, Jira.

Confidential, Cleveland, Ohio

Sr.QA Analyst

• Participated in BRD and Design Walkthroughs, provided Inputs during gathering/documenting requirements and defined and analyzed testing requirements based on the application functionality.
• Created traceability matrix between requirements and test cases.
• Involved in Defect Triage meeting and discussed with developer regarding Defect Status.
• Worked in Agile environment and participated in Scrum and Sprint meetings.
• Assisted the developers to perform the White Box testing in the Application.
• Tested the scenarios of Member enrollment module of Facets in UAT.
• Involved in preparation of Test Summary Report for test reporting metrics.
• Maintaining knowledge of Medicare and Medicaid rules and regulations pertaining to the Facets configuration and evaluating the impact of proposed changes in rules and regulations.
• Worked with ANSI X12/EDI 5010 transactions (270, 271, 276, 277, 278, 834, 837P, 837I, 837D, 835, 820) functional acknowledgement & transactions (TA1, 999, 277CA &TRN).
• Extensively worked on HP Quality Center, Test Director, Quick Test Pro, Load Runner and Rational Suite.
• Implemented test automation to handle Popups and Alerts using WebDriver and Alert interface class.
• Performed Smoke Tests after installation of each build on QA servers.
• Tested different modules of web based applications and the backend using tools like Oracle SQL Developer.
• Created Group, Subgroup, Class, Plan, Subscriber and Member through Subscriber/Family Application Screens and when needed it is used as a test data for testing purpose.
• Calculated co-pay, coinsurance, deductible added single tier, multi tier for different products with in a plan.
• Used HP QC to maintain Test Plans, Test Cases, Test Execution, Defect Management and Bug Reporting.
• Authored Test cases for HIPAA EDI Transactions 270/271, 276/277,837/835.
• Tested HIPAA Transactions and Code Sets Standards according to the test scenarios such as 270/271, 276/277,837/835 transactions.
• Used Jenkins for nightly build execution and sending status mail to QA team if build fails.
• Extensively worked with HP ALM, Rally for tracking and managing defects.

Environment: DB2, JCL, TESTNG, Maven, Firebug, Firepath, Eclipse, Jenkins, HP ALM, GitHub, Web Based Applications, SQL, Rally, Jira

Confidential, NJ

QA Analyst

• Created the test design and Requirement traceability and prepared Test Strategy and Test Plan.
• Performed Functionality testing and logged the defects in HP ALM.
• Performed all phases of end-to-end testing which includes Regression Testing, GUI testing, Black Box testing, Smoke testing, User Acceptance Testing and Negative Testing of the Application.
• Validated the Data on Mainframes using batch testing.
• Facilitated the defect triage meeting with different stake holders of the project.
• Understand the Change Requests and perform the impact analysis, update the test assets.
• Prepared the E2E business flows and conducted the System Integration Testing.
• Responsible for performing test data prep and manual testing of interface with Hogan systems on IBM Mainframe, tested changes to CICS screens.
• Tested and Validated SOAP Request and SOAP Response messages.
• Automated the Web Services using SOAP UI.
• Tracked software bugs using HP Quality Center and communicated the same to developers to resolve technical issues. Performed validations on the Mainframe using DB2, CICS, TSO, ISPF, File Aid etc.
• Bulk user creation service uses the above MQ Series API’s, gets user info from a 3rd party Single Signon app.
• Bulk user creation service uses the above MQ Series API’s, which gets user information
• Tested the SOA applications (Web Services, SOAP, WSDL)
• Track defects using HP Quality center and generate defect summary reports.
• Coordinated Web and Mainframe projects for schedules, requirements gatherings, timelines
• Worked in Agile environment and participated in Scrum and Sprint meetings.
• Closely interacted with development and production team when working on agile projects and updated Project Status in daily Scrum meetings.

Environment: JCL, CICS, DB2, VSAM, FILE-Aid, SPUFI, Quality Center, TestNG, SOAP UI, Maven, GitHub, Firebug, Fire path, Eclipse, SQL Developer.