PROFESSIONAL SUMMARY:

• Senior Quality Assurance Professional over 8+ years of Manual Testing and Automation Testing experience in a wide variety of platforms including Client - Server and Web-based applications.
• Worked on projects with on site-offshore model and familiar with Agile (Scrum), RUP and Waterfall methodologies.
• Well Versed in Software Development Life Cycle(SDLC), Software Testing Life Cycle(STLC) and Defect Management Life Cycle(DMLC)
• Extensive experience in handling different projects such as Banking, Financial, Insurance, Brokerage, Investments, Healthcare, Telecom and Retail/e-Commerce domains.
• Skilled in design, developing, and implementing Test Automation Framework in HP UFT/QTP, Selenium WebDriver, IDE, HP ALM/Quality Center, LoadRunner, WinRunner
• Experience testing mobile applications on Android, Iphone, Ipad, Tablet and HTC
• Extensive experience in validating the SOAP UI responses by editing the XML in the backend database to get the expected result.
• Expertise in Java and OOPS concepts required for Selenium frameworks.
• Good experience on different EDI transactions like 834 for enrollment, 837 for claims.
• Worked on Pharmacy migration from Medco to OptumRx as the primary Pharmacy Benefit Manager (PBM).
• Worked HIPAA EDI 4010 and 5010 with ICD9 and ICD10, analysis & compliance experience from payers, providers and exchanges
• Experience in Functional Testing, Ad-hoc Testing, Integration Testing, System Testing, Black Box Testing, White Box Testing, Gray Box Testing, Regression Testing, Positive and Negative Testing on Trading Stocks, Options, Mutual Funds, Account Summary, Quotes, RDC and Transfers.
• Involved in ETL testing, executed SQL queries to validate the data in target database and familiarity with fact tables, dimension tables.
• Extensively used the Continuous integration tools such as Jenkins, Maven and TestNG.
• Proficiency with HTML 5, JAVA, Oracle, Weblogic, Apache, WebServices, SOAP UI, and APIs
• Good experience in User Interface (UI) testing of client server & web based applications.
• Extensive experience in testing of client/server, WEB Based, Stand-alone and database applications developed in Java, Oracle, UNIX and Windows etc.
• Expert in developing and maintaining test plans, test scenario, test cases, test data, test checklist, defect tracking and reporting.
• Experienced in using Test Management tools such as Rally, JIRA and Bugzilla to track test progress, execution and deliverables
• Performed BackEnd testing using SQL with RDBMS systems including Oracle, MS Access, MS SQL Server and DB2
• Ability to effectively communicate testing activities and findings in oral and written formats with Excellent Analytical skills.

TECHNICAL SKILLS:

Testing Tools: HP UFT/QTP, Selenium, HP ALM/Quality Center, LoadRunner, WinRunner, SOAP UI, API, Web Services, Rational Clear Case, Clear Quest, Visio

Web Technologies: ASP, ASP.NET, HTML, DHTML, Java Script, VB Script, XML

Languages: SQL, XML, HTML, DHTML, C, C++, ASP, Java, J2EE, Visual Basic

RDBMS: SQL server, MS Access, Oracle, DB2, Database, ETL, Informatica

Mobile Devices: Iphone, Ipad, HTC, Iphone, Blackberry, Windows

Bug Reporting Tools: HP ALM/Quality center, JIRA, Rational Clear Quest, Ab-Initio (ETL tool)

Business Applications: MS Office Suite - Word, Excel, PowerPoint, Outlook

Platforms: Windows, Linux, UNIX, Android, Iphone

PROFESSIONAL EXPERIENCE:

Confidential, Orlando, FL

Sr. QA Automation

Responsibilities:

• Analyzed and Created User Stories in JIRA, Reviewed business requirements, SDD documents, Process Flow diagrams and sequence diagrams to determine necessary testing scenarios and test cases for testing end to end functional testing.
• Worked as a Software Test Analyst for the Oracle based Mail Order Pharmacy, IRIS application
• Involved in optimizing the Regression Test Suite to be more nimble in order to be utilized in Agile sprints
• Effectively used the RxClaims (Mainframe systems for adjudication process) through IBM iSeries AS400 and TOAD to access the Oracle database, run SQL queries to verify test data corrective-ness throughout the application.
• Unified management of defects, stories, test cases, requirements, releases between JIRA and HP ALM/Quality Center.
• Developed Web Services scripts for a Web Service call sing SOAP UI
• Worked on claims processing through EDI 837 transactions and validated the data in facets and in the backend.
• Implemented POM (Page Object Model) automation framework using JAVA, Cucumber, Selenium WebDriver, Jenkins and J behave.
• Involved in automation testing with Selenium Webdriver, TestNG and Cucumber and Maven plug ins. Used JavaScript for Scripting.
• Analyzed mandatory and the situational fields and compared with the user manuals for EDI.
• Prepared web driver automation scripts for automating testing of UI features and cross browser compatibility.
• Involved in both Manual as well as Automated testing of the application.
• Developed and maintained automated test cases in Selenium WebDriver using Java programming language and J Behave Framework.
• Maintained the Java and selenium test source code and resources in the GitHub source control repository tool.
• Performed backend testing of database by writing SQL queries for both internal & external data interfaces.
• Worked on OptumRx vendor file loading and validation as per the mapping.
• Involved in managing test execution, writing test plan and test cases, load testing and performance testing
• Conducted Functional testing, Regression testing, System-level Integration testing, End-to-End testing and helped UAT team to achieve the final acceptance testing.
• Developed Keyword Driven and Data Driven frameworks to retrieve test actions, test data from Excel files and SQL Databases.
• Attended Tester Tech Scrum meetings, coordinate and support integrations testing meetings, business requirement meetings with business and team folks and applied the thoughts and ideas shared across the teams.
• Used Maven, Selenium Grid to execute Selenium automation suites on different platform
• Queried databases using SQL queries in TOAD and SQL Server Management Studio to validate the data loaded into target tables.
• Prepared project status report and management review reports and participated in project review, quality review and audit with the various stakeholders
• Generated the test execution report in Quality Center to be reviewed by the QA Manager and development team.
• Analyze SQL code to ensure business objects queries the correct data from the database

Environment: Java, J2EE, Selenium IDE/WebDriver/ GRID, Web Services, Cucumber, EDI, J Behave, JBoss, API SOAP UI, TestNG, HTML, JavaScript, CSS, AJAX, UNIX, HP ALM/Quality Center, ETL, Data Warehouse, Oracle, SQL, PL/SQL, Jenkins, Windows, HTML, JIRA

Confidential, Milwaukee, WI

Lead QA Tester

Responsibilities:

• Played a dual role in company transformation to lead a team of 7 engineers, a business analyst and a quality analyst to deploy, manage, maintain, as well as design new innovative store solutions.
• Worked the Agile team, provide accurate estimates for user stories and automation test plans for each sprint
• Designed complex SSIS packages with error handling as well as using various data transformations like conditional split, multi cast, data conversion, derived columns, Merge join
• Conducted backend Database testing using PL/SQL queries to validate Source to Target Data based on the conversion and reporting requirements
• Developed base line scripts for testing the future release of the application using UFT/QTP.
• Used SQL queries to test the backend tables using TOAD
• Supported the Retail Operations and Institutional Lending Operations areas of JPMC Home Mortgage through reporting and analysis of a variety of front-end applications.
• Worked on Mobile App Testing tools in Android Platform using Android Studio, Android Device Manager, SDK Manager, AVD Manager, UIAutomater and Appium
• Involved in validating request and response XML in SOAP UI Editor.
• Prepared test cases for the ETL application according to technical specification document and Extensively tested data extraction, transformations and loading processes
• Prepared documentation of the Prescription fulfillment and management module for management review and project presentations.
• Identified objects of Application using UIAutomator tool for Android and Appium Inspector for IOS.
• Utilized MSP (Mortgage Services Platform) to verify information displays correctly from MSP to the system screens.
• Prepared documentation for setting up Appium and Eclipse Environment on Local Work Spaces.
• Conducted Test Scenario walkthrough with Onsite/Offshore development team and with Business.
• Integrated UFT/QTP scripts with HP ALM/Quality Center and executing the same from Test Lab from HP ALM/Quality Center
• Performed Verification, Validation of Input data before loading into target database.
• Maintained Test data in Excel files and Imported Excel files from Resources module in HP ALM/Quality center to UFT/QTP data table and read the values based on the functional requirement.
• Used object oriented language, python and C++ in development of software and its testing.
• Extracted data from different department to flat files and load the data to the target Oracle and SQL server database.
• Involved in preparing the Automation Design document, identifying the test cases to be automated for Regression Testing using UFT/QTP.
• Developed SQL queries to pull retail and cost records from DB2 and Informix databases.
• Tested Web Services providing required input data to request XML and validated response XML.
• Created and prepared the test data and test scripts in UFT/QTP for Data Driven Testing.
• Participated in meeting with Release Management and coordinators to manage testing activity
• Retained information from Targeted and Non Targeted users for legal department and to meet the guidelines
• Provided support to offshore testing resources ensuring successful handoffs through clear communication

Environment: HP ALM/Quality Center, Product Studio, JAVA, JavaScript, Agile/Scrum, UFT/QTP, VB.NET, HTML, XML, HTTP, Rally, JIRA, Mobile Testing, Perfecto Mobile, VBScript, Oracle, IBM WebSphere, Windows, UNIX, SQL, PL/SQL, C#, MS Office, MS SharePoint

Confidential, McLean, VA

Sr. QA Tester

Responsibilities:

• Analyzed Business Requirement Document and Technical Specifications Document and scripted the test cases.
• Performed Database testing using SQL queries
• Prepared various test reports from HP ALM/Quality Center such as Test Execution Status, Test Execution Summary, Defect Summary/Details report.
• Performed Database Integrity Testing by executing SQL statements.
• Performed comparison of actual report with the expected values by querying the database
• Developed and Executed Test Scripts using Selenium WebDriver, TestNG, analyzed Test Results.
• Developed several utility functions in C language for optimizing and enhancing LR scripts.
• Created and executed join, union and other complex SQL queries for back-end database testing with MS SQL Server and MySQL.
• Created and tested scenarios using positive and negative test data.
• Used SoapUI and Rest API to Performed end to end functional API testing and web Services testing
• Performed Configuration and compatibility testing, verified the application on different operating systems.
• Created test cases for various modules in MS Excel and exported them to HP ALM/Quality Center for Test Case Management.
• Interacted with developers and team members for verification and validation aspects.
• Reviewed extensive SQL Queries with complex multi-table joins and nested queries.
• Performed Functional Testing, Smoke testing, Integration testing, UAT Testing, Backend Testing, Regression Testing, End to End Testing and System Testing

Environment: HP ALM/Quality Center, ASP.Net, JavaScript, MS SQL Server, MySQL, Windows, Data Warehouse, QTP, DB2, SQL, MS Office

Confidential, Philadelphia, PA

EDI Tester

Responsibilities:

• Attended modification request meetings and reflected those changes in test cases preparation and execution.
• Used HP ALM/Quality center to developed test cases in Test plan module and executed test cases in Test Lab Module and logged the defect in defect Module
• Tested the HIPPA EDI, 820, 834, 837/835 transactions according to test scenarios and verify the data with FACETS on different modules.
• Created automated test scripts and Performed Functionality testing in the multiple phases of the application and analyzed the results using QTP
• Involved in User acceptance testing (UAT) of the application.
• Extensively used HP Quality Center for test planning and Used Rational Clear Quest for bug tracking and reporting.
• Performed Shell Scripting and PL/SQL programming to resolve business problems of various natures.
• Used FireBug, FirePath to debug, edit and locate the objects based on ID, Name, XPath, CssSelector, Link, Partial Link, Attributes and Tags.
• Recommend on implementation of HIPAA 5010 (EDI X12 837,834, 820, 278,270,999) in the new System.
• Performed data driven testing and parameterization using QTP.
• Queried databases using SQL queries in TOAD and SQL Server Management Studio to validate the data loaded into target tables.
• Created and tested 834 transactions for 5010 and 4010 and mapped the changes according to ICD 9 and ICD 10.
• Created Automation scripts from End-To-End and regression testing Using QTP
• Conducted Validations for different FACETS modules Providers, Claims and Membership.
• Prepared RTM Document to ensure that all the requirements had sufficient coverage for through testing.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Developed complex level queries using FACETS Data Model to retrieve data from Backend.
• Performed shell Scripting and PL/SQL programming to resolve business problems of various nature
• Performed Database integrity testing by executing complex SQL Queries
• Documented Claims processing lifecycle and got good exposure of X12 834 transactions for HIPAA 4010.
• Development of SQL queries as per the request from the business team in SQL server.
• Responsible for testing of different Medicare Benefit terms and Programs according to Configuration library.
• Involved in Member creation using FACETS and assigning them to different Maine Medicaid Programs.
• Validate the date from EDI transaction in the front end as well as back end.

Environment: Windows, TriZetto Facets, HIPAA EDI, HP ALM/Quality center, SQL, PL/SQL, ICD 9-10, MS visual studio, MS SharePoint, Web service, SOA, ETL, Informatica, Data Warehouse

Confidential, Houston, TX

QA Analyst/ Mobile Tester

Responsibilities:

• Worked with POS System and involved in testing functionalities related to sales tracking, POS scanning, Store ISP, ordering forecast, adjustments, custom retail price and promotions in POS
• Review and understand requirements related to POS (Point Of Sales) systems designed by Third Party Vendors such as Retail Information System.
• Performed browser compatibility and configuration testing on various operating systems such as Blackberry OS, Android OS, and IOS etc.
• Validated ETL process and reports using SQL queries.
• Involved in writing test cases in MS Excel and uploaded into HP Quality Center
• Performed comparison of actual report with the expected values by querying the database.
• Involved in end-to-end business process on OMS (Order Management System) module and analyzed the performance of the systems involving many orders from OMS (Order Management System).
• Conducted Gap Analysis for the system considering AS IS and TO BE feature.
• Performed comparison of actual report with the expected values by querying the database
• Enhanced QTP script using recovery scenarios for error handling.
• Retrieved files using SQL statements and UNIX commands.
• Created test scripts for Security, Positive, Negative and User Acceptance Testing (UAT).
• Inserted Check Points to check the broken Links, Text, and standard properties of objects using QTP
• Involved in Integration, Regression, Functional and End-to-End testing on store and merchandising applications that interface with POS
• Designed and maintained test plan, test case, authored and ran tests using Test Manager
• Developed and executed test cases and test Scenarios and followed-up defects using TFS.
• Performed data driven testing and parameterization using VB script in QTP
• Functionally validated Web Services delivered in SOAP XML format as provided in specification document.

Environment: Windows, HP Quality Center, SQL, TFS, MTM, Rally, OMS, QTP, XML, UNIX, Linux, Soap UI, VBScript, Java, Agile, Oracle, Android, Mobile Devices for IOS, Blackberry, Perfecto Mobile

Confidential, Washington, DC

QA Tester

Responsibilities:

• Worked in a highly dynamic agile environment and participated in scrum and sprint meetings
• Reviewed extensive SQL Queries with complex multi-table joins and nested queries.
• Validated XML request and response with different sets of test data to perform web services payment validation.
• Wrote and modified required SQL validation scripts, and writing scripts in SQL to validate the outputs.
• Uncovered multiple issues related to the data population in the backend database using HP Quality Center
• Performed testing on the Web Services API's using protocols like HTTP, HTTPS, SOAP and WSDL using SoapUI tool and RestClient related with various interfaces.
• App-side testing for Android and iOS using emulator and real devices.
• Performed Back End testing by executing SQL queries on Window and UNIX platform.
• Used Selenium, Java, TestNG/Junit and Maven to perform end-to-end JUnit testing for all business requirements.
• Performed Defect Tracking & Management in JIRA. Generated automated daily reports using JIRA API.
• Involved in two projects same time for QA task and End to End functional and integration testing.
• Tested application on mobile platforms as iOS (Simulator) and Android (Emulator) and native devices
• Developed SQL Scripts for Backend Testing to ensure that data is updated as per the Business Rule0073
• Demonstrated ability to solve complex automation challenges involving AJAX, unexpected event handling.
• Performed rigorous manual testing such smoke testing, Integration testing, Regression Testing, End to End Testing and System Testing.
• Performed backend testing using SQL queries to validate data.
• Defined and tracked quality assurance metrics such as defects, defect counts, test results and test status using JIRA as defect tracking system
• Maintained Test Matrix& Project Matrix using excel sheet to keep track of Project's schedule and status.
• Facilitated weekly team status meetings and created reports related to end to end testing.

Environment: HP Quality Center, Windows, Oracle, XML, Java, HTTP, HTML, AJAX, Mobile, PL/SQL, API, SOAP UI, Agile, JIRA, SQL, UNIX, Toad, MS Office

Confidential, Huntsville, AL

QA Analyst

Responsibilities:

• Analyzed and Created User Stories in rally, Reviewed business requirements, Process Flow diagrams and sequence diagrams to determine necessary testing scenarios and test cases for testing end to end functional testing.
• Involved in writing complex SQL queries to check the data integrity
• Investigated software bugs and interacted with Dev team to resolve bug issues using HP Quality Center
• Used various aggregate functions through SQL queries in order to validate the data load in order to perform Backend Testing.
• Designed and developed various abstract classes, interfaces, classes to construct the business logic using C#.NET
• Checked the client side and server side validations. Tested the functionality of the application.
• Achieved Synchronization between test scripts execution and application using Implicit waits and Explicit waits.
• Created and Maintained Test Matrix and Requirement Traceability Matrix.
• Attended daily status calls with cross application teams.
• Used TFS for test documentation management and defect tracking.
• Created UNIX scripts for file transfer and file manipulation.
• Assisted in promotion of SQL Server Integration Services and UNIX Shell scripts from UAT to Production.
• Participated in conducting System testing and End to End testing manually.
• Created and maintained SQL Scripts and Unix Shell scripts to perform back-end testing on the oracle database.
• Identified, analyzed, and documented defects, errors, and inconsistencies in the application using HP Quality Center

Environment: HP Quality Center, JIRA, UAT, Dev, SQL, UNIX, JavaScript, Perl, Oracle, Toad, API, C#, XML, .Net

Confidential, New York, NY

QA Analyst

Responsibilities:

• Performed onsite-offshore coordination for multiple projects to perform test related activities.
• Involved in Development of Test cases and Test plan, Test Approach, Test Scope, Test Strategy documents.
• Reviewed business requirements and developed detailed Test Cases to ensure testing of the entire application.
• Submitted estimates to management based on evaluation of new requirements and develop and debug automated test scripts.
• Tested functionality of interest data issued and gained from different customers by the bank from the database for calculating net profit.
• Performed extensive manual testing on critical functionalities of the application
• Maintained Requirement Traceability Matrix (RTM) to make sure that test plans were written for all the requirements.
• Used QTP to perform Functional Testing and Regression Testing for monthly releases.
• Involved in testing the database and data validation using SQL queries, executed SQL queries to check the data table updates after test execution.
• Set-up the functional and load test environment using QTP and LoadRunner.
• Worked on UNIX Platform and experienced in back end testing by executing SQL Queries.
• Used HP Quality Center for test script and test result management and bug tracking.
• Performed Functional, Regression and Integration testing of various modules of the applications.
• Enhanced Test Scripts using various utilities provided in QTP like check points
• Performed back-end testing of the entire application to ensure data integrity.
• Interfaced with development team to point out bugs and retest fixed bugs.

Environment: HP Quality Center, QTP, LoadRunner MS Office, JIRA, WinRunner, Agile, SQL, MySQL, HTML, JavaScript, JAVA, XML, SQL server, Oracle, UNIX, Windows

Confidential, Chicago, IL

Associate QA Analyst

Responsibilities:

• Analyzed business requirements and module-specific functionalities to identify test requirement.
• Checked the data flow through the front-end to back-end and used SQL queries to extract the data from the database.
• Performed Web Services testing and Validated XML request/response data using SOAPUI.
• Conducted Back-End Testing for Oracle databases using complex SQL queries.
• Performed manual testing for the GUI functionality of the application.
• Modified and maintained test cases with changes in application interface and navigation flow.
• Prioritized testing priorities based on business risk, Access testing assets anytime; anywhere via a browser interface using TFS.
• Performed test case assignments in Test Lab modules of HP Quality Center.
• Coordinated with off-shore resources for test case development and test execution.
• Developed and executed test cases and test Scenarios and followed-up defects using TFS
• Ensure applicable Test and Defect management process and best practices are followed.
• Functionally validated Web Services delivered in SOAP XML format as provided in specification document.
• Extensively used SOAP UI in web services testing
• Prioritized and reported defects, presented documents and reports in weekly team meetings.
• Interacted with developers and team members for verification and validation aspects.
• Created and maintained SQL queries for back-end testing.
• Developed and maintained Requirement Traceability Matrix (RTM)
• Interacted with developers and team members for verification and validation aspects.

Environment: Windows, SQL, Rational Rose, Clear Quest, TFS, HP Quality Center, SQL Server, Java, UNIX, SOAP UI, Web Services, XML, HTTP, DB2, MS office, MS Visio