SUMMARY:

• Excellent understanding of the Agile Software Development Life Cycle (SDLC), STLC and the role of Quality Assurance, RUP and Agile Methodologies, Agile PLM
• Technical knowledge and understanding of Data Warehousing, Data Validations, OLAP, SQL Server, Oracle and ETL.
• Expertise in using Testing tools SOAP UI, QTP, and ALM/QUALITY CENTER.
• Tested applications based on Service Oriented Architecture (SOA)
• Good experience working with Claims Processing ITS, Subscriber/Member enrollment, Billing and Provider applications in FACETS.
• Very strong hands on experience in Black Box and White Box testing techniques using manual and automation test process and tools.
• Experienced in developing Test Plans, Test Cases based upon the business requirements.
• Good understanding of Data warehousing, ETL in SSIS to perform Source to Target testing.
• Expert in working with JIRA, Microsoft Test Manage (MTM).
• Experience with Mobile application testing - iPhone, Android, Blackberry and feature phones using Simulator "Device anywhere" “Perfecto”.
• Experience in Functional Testing, GUI, Regression, Smoke, System, Integration, Sanity, Black Box, User Acceptance Testing (UAT), End to End testing and Cross Browser testing of Client/Server, Web based & Mobile applications.
• Basic automation testing experience using LoadRunner, QTP/UFT.
• Knowledge in Application Life cycle Management (ALM).
• Experience testing mobile applications on iOS, Android and BBOS.
• Experience with Mobile application testing - iPhone, Android, Blackberry and feature phones using Simulator.
• Experience in testing Web Services and IVR applications (Touch Town, Power Speech)
• Expertise in working with various mobile devices such as Android, Blackberry, IPhone, tablets to perform browser compatibility and configuration testing.
• Exclusive experience in testing and development in SharePoint 2010.
• Hands on experience in SQL Server new features in test environment.
• Strong working knowledge of Team Foundation Server (TFS) and Microsoft Test Manager (MTM)on Visual Studio Team Foundation (VSTF) in managing product lifecycle.
• Excellent in communication, presentation, and interpersonal skills. Good team player with the ability to lead, manage and work independently in a time sensitive environment.
• Extensive testing experience with AS400 Mainframe Technology.
• Expertise in Oracle table data manipulation using SQL queries and UNIX commands.
• Participated in design Walkthroughs and Inspection meetings to review Test scripts and results.
• Expert in review and analyze requirements, use cases, technical specifications and database designs.
• Experienced in validating source to target mappings, their implementations via ETL tools, and the testing processes involved in a data warehousing environment.
• Highly detail oriented, organized, analytical and efficient in approach

TECHNICAL SKILLS:

Testing Tools: UFT/QTP, Web Services, ITKO LISA, Selenium, Load Runner, SOPA UI, JIRA, TFS

Bug Reporting Tools: ALM/QUALITY CENTER, Bugzilla, JIRA, TestDirector.

Databases: SQL, SB2MS SQL Server, Oracle, MS Access, DB2

Languages: C, C++, SQL, PL/SQL, .Net, JAVA, J2EE, JUnit, HTML

Query Tools: TOAD, MS SQL Server, My SQL, SharePoint 2010 and 2013.

Other Tools: MS Office Suite (word, Excel, Power point, Visio)

Web Browser: Internet Explorer, Netscape Navigator, Mozilla Firefox

PROFESSIONAL EXPERIENCE:

Sr. QA Testing Analyst

Confidential, Richmond, VA

Responsibilities:

• Performed web specific testing like Link checking, Browser page testing, Application Testing and Security Testing.
• Performed UAT, End to End, System testing, and Smoke testing, Regression Testing and Performance Testing.
• Created and maintained detailed test cases to perform various types of testing in Test Plan module of ALM/QUALITY CENTER.
• Performed data driven testing by data driver wizard and parameterization in UFT/QTP for web based application.
• Writing Complex SQL queries and optimizing SQL Queries
• Prepared AS-IS PMS (Mainframe Policy Management System) and to identify current functionalities for Quote, Submit and Issuance of Insurance Policies and TO-BE documentation.
• Conducted Functionality testing during various phases of the application using UFT/QTP.
• Expert in writing test scripts manually.
• Perform both white box testing and Black Box testing.
• Created various Custom functions using VB scripting in UFT/QTP
• Worked in mainframe environment and used SQL to query various reporting databases
• Involved in validating SOAP XML specifications as per the standards.
• Developed and executed UAT test cases, UAT test Scenarios using Quality Center and followed-up defects using JIRA.
• Logged defects in UAT Environment using JIRA
• Executed test cases in ALM/QUALITY CENTER and reported defects in JIRA
• Detected, reported and tracked defects using ALM/QUALITY CENTER.
• Interacted with the developers to report and using ALM/QUALITY CENTER.
• Functionally validated Web services delivered in SOAP XML format as provided in specification document
• Experienced in Agile Development process for diverse requirements
• Used Quality Center to track and report system defects.
• Integration of e-Commerce web site into Store Retail Systems and Data processing
• Worked in an agile team to test the functionality of the Web based customer facing site
• Used ALM/QUALITY CENTER to store Test Plans, Test Cases, Test Scripts and for bug tracking.
• Identified software problems, wrote easy-to -follow bug reports, logged them into bug tracking tool ALM/QUALITY CENTER.

Environment: ALM/QUALITY CENTER, QTP/UFT, Manual Testing, Mainframe, Web Services, SOAP UI, XML, UAT, Emulator like Device Anywhere, JIRA, Java, J2EE, Java Scripting, VB Scripting, Selenium, MS SQL Server, MS SQL, MS project, MS Office etc.

Mobile POS Tester

Confidential, Salt Lake City, UT

Responsibilities:

• Used agile systems and strategies to provide quick and feasible solutions, based on agile system, to the organization
• Performed data driven testing and parameterization using QTP.
• Clearly documented and executed Test scripts in Microsoft Test manager
• Followed Agile Methodology to emphasize on real time communication over written documentation and to minimize risk by implementing software test effort in short time sprints or iterations.
• Work closely with members of the SCRUM team to translate the customers' business needs or Business Cases to a technical solution.
• Responsible for testing web services both on the back end and also the consumers of the web services.
• Performed manual testing based on the developed test plan and test cases with consideration both positive and negative scenarios.
• Worked in all phases of SDLC and software development methodologies like Agile/Scrum, Waterfall etc.
• Involved in Device Testing - Android- Samsung Tab Galaxy 10.1, Asus and Vizio, iOS- iPAD, iPhone and Nexus.
• Preparing ETL and SQL routines/code for performing ETL testing (system and integration testing) and Documenting the test results
• Done the API testing Using SOAP UI tool creating customers and Validate in Back end and front end systems
• Functionally validated Web Services delivered in SOAP XML format as provided in specification document
• Used Environmental variables to analyze the execution environment of QTP
• Experience with Microsoft Test Manager, Experience using Visual Studio Performance and Load testing tools.
• Involved in writing Test scenarios, Generic tests cases, detail Positive and negative test cases for ETL also Preparing ETL and SQL routines/code for performing ETL testing (system and integration testing) and Documenting the test results
• Involved in evaluation of the QA issue tracking tool TFS and manage it for the whole QA team.
• Worked on Team Foundation Server (TFS) and Microsoft Test Manager (MTM) to effectively manage the product life cycle.
• Involved in preparing Test Plan and Test Cases based on business requirements.
• Work with Team members to organize data for Testing Web Services for various Client Products.
• Modified and Edited the XML to validate the SOAP UI Services.
• Created the Traceability Matrix to ensure that all the user stories are being tested and covered in the testing plan.
• Validated the Web Services (SOAP) both Request and Respond Messages.
• Maintain the issues, QA logs and Follow up with Issue Owners to close the issues.
• Responsible for Daily Scrum/Standup meetings to discuss updates showing the progress of the testing effort and open issues to be resolved.
• Worked with ETL group for understating mappings for dimensions and facts
• Performed Database Validation Testing and manipulations using SQL quires.
• Responsible for gathering requirements, design and develop data warehousing ETL solutions and delivery reports
• Wrote SQL queries to retrieve data from DB2 databases after data migration.

Environment: Quality Center, QTP, ETL, Data Warehouse, Informatica, Cognos, DB2, Oracle, MS Office Suite, Java, UNIX, XML, SQL, J2EE, Lotus Notes, Restful Web Services, Etc

Sr. QA Engineer

Confidential

Responsibilities:

• Involved in running Mainframe based CIMS and SOA batch jobs daily to generate daily billing and Service order completion for energy spending of customer Conducted Validations for different FACETS modules Providers, Claims and Membership
• Reviewed the Business Requirement documents with the business and development team to understand the architecture and functionality of the application in an agile environment.
• Performed “UAT” for 5010 and ICD 10 codes.
• Performed Functional, System, Security, and Regression & User Interface testing of software applications.
• Participated in daily stand-up meetings to provide QA estimates, testing progress and status of deliverables for the sprint.
• Written SQL queries for checking the Data Transactions and Database Integrity in Oracle.
• Also developed SQL scripts to run complex data integrity test cases and to extract data from the tables.
• Undertook the QA process improvement initiative to move towards standardizing the testing process..
• Prepared SQL queries to retrieve data from the Mainframe database.
• Prepared Test plan and test case for EDI 834 - Members Enrollment.
• Involved in testing integration between .Net applications and SQL server where BizTalk being the integration layer
• Responsible for review of requirements from Business Functional Specifications and conducted code as well as application design walkthroughs with Business, development team and test team members respectively.
• Edit claims (EDI Claims) with UltraEdit.
• Tested the HIPAA EDI 837/834 transactions according to test scenarios and verify the data with FACETS on different modules.
• Good knowledge of ISO 9000, CMM Level standards, HL7 and ICD 9/10 code lists.
• Performed the functional testing of HL7 transaction XML format messages.
• Performed Sanity and Smoke Testing of the application manually after each build.
• Understand and develop Web Services test strategy for different services as part of SOA
• Worked with business users, business analysts and SMEs to understand different critical business processes.
• Tested HIPAA EDI Transactions and Code Sets Standards such as 820, 837/835, 270/271, 276/277 transactions.
• Created and Maintained Test Matrix and Requirement Traceability Matrix.
• Worked on FACETS User Interface Modernization and Claims enhancements like ICD-10 enhancements etc.
• Build and Manage a high performance team by hiring, training, mentoring and monitoring QA engineers .
• Gained an understanding of business requirements, current system operations/functionality and any proposed new requirements.
• Helping the Scrum Team understand the need for clear and concise Product Backlog items.
• Developed Test scenarios, Test Scripts and Test cases based on Requirements, Detail Specification Document’s and GAP documents using Rational Quality Manager.
• Used Test Lab module of Quality Center to perform test execution activities by creating various test sets.
• Facilitated all required Scrum Ceremonies while keeping projects on time and on budget Created and executed test plans and scripts to verify software functionality and adherence to business requirements.
• Documented and reported defects within established process and tracking systems using Quality Center.
• Developed Web Services scripts for a Web Service call sing SOAP
• Successfully created and executed complex SQL Queries on SQL Server Database using SQL Query Analyzer to verify and validate data.
• Responsible for testing backward compatibility on various proxies of web services
• Participate in various meeting and discussed Enhancement and Modification request.
• Manually test each and every module of the application and verify against expected results.
• Extensively utilized Requirements, Test Plan, Test Lab and Defects Modules of Quality Center during STLC.
• Coordinated with the developers on Defects Status on a regular basis.

Environment: Windows, Quality Center, SQL, QTP, Web logic, MS Office Suite, UNIX, Oracle, XML, Web Services, Etc

QA Analyst

Confidential

Responsibilities:

• Acted as point of contact from QA team to Project Management, Development, Business Analyst and Business User teams.
• Conducted a walkthrough session of the scope document to ensure that the project sponsors and stake holders understand the project scope and any associated constraints, risks and issues as early as possible.
• Created User Acceptance Test Cases based on new Business Processes that will be added to the existing application.
• Worked with clients to generate IVR Call Flow diagrams (VISIO), report needs and suggested improvements in order to build IVR test plan.
• Exported Manual test cases into Quality Center and maintained the same in the Test Plan module.
• Created and maintained Requirement Traceability Matrix(RTM) to ensure the requirement coverage
• Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Have good experience in Guidewire - Billing Center product
• Performed test case assignments in Test Lab modules of Quality Center.
• Worked on Guidewire’s Claim Center Application to identify claim process changes and enhancements.
• Created Detailed Test Plan, Test Approach, Test Matrix, Test Strategy documents based on the information gathered through business requirements and design/application walkthroughs.
• Prepared a package of Process Flow diagrams to document the existing system and used UML notations for Object Oriented Design and Documentation.
• Responsible for identifying gaps in the software between core functionality and user defined requirements.
• Used Quality Center bug tracking tool to analyze & capture bugs, track and manage dashboard any type of updates for project release.
• Assist and guide project teams to implement and document standards, procedures, artifacts, and plans consistent with QA and Test deliverables for the project team.
• Mentored QA Team by looking into different technical problems with development and helped them prioritize Testing tasks.
• Analyzed test progress and send weekly progress reports to the Project Manager
• Actively trained Business Users involved in User Acceptance Testing (UAT) and helped them understand UAT procedure.
• Detected, reported and tracked defects using Quality Center.
• Performed backend testing for data validation using SQL Queries.
• Functionally validated Web services delivered in SOAP XML format as provided in specification document
• Coordinated with Business Users and Development for setting up Test Environment, Test Data and Backend Interfaces.
• Reviewed extensive SQL Queries with complex multi-table joins and nested queries.
• Involved in reviewing complex SQL queries, views, functions and stored procedures and spotting issues

Environment: Guidewire Policy Center and Guidewire Claim Center SQL Server, MS Visio, QTP, Quality Center, SOAP UI, MS Excel, MS Access, UNIX, MS Office

QA Tester

Confidential, Atlanta, GA

Responsibilities:

• Created SQL queries to prepare data and validate data from databases. Understanding
• Experience using Agile software development methodologies, including experience creating and managing SCRUM artifacts (User Stories, Product Backlog, facilitating Scrum meetings)
• Creating Business Rules, User Interface Rules and Use Cases for functionalities captured within the Functional Requirement documents in preparation for HIPAA D.0 changes
• Validate and manipulate Database tables and data validation using SQL Queries.
• Developed Test Plans, Test Cases to test the Screens and workflows
• Ability to work using cross functional using agile Methodology.
• Converted Business Requirements and Design Documentation into Test Cases and Test Scripts.
• Edited the automatically generated scripts to customize testing. Involved in executing SQL queries for back-end testing.
• Knowledge and experience in creating requirements for HIPAA (EDIX12 Transactions)
• Daily-performed Test validations for HIPAA EDI 270/271 claims file format.
• Participated in conducting System testing and End to End testing manually.
• Conduct Agile Scrum meetings to discuss project progress and plan
• Preparation of Requirements Document, AGILE Storycards, etc
• Extensive UAT Testing Manually.
• Organized meetings to discuss outstanding issues with QA team and developers.
• Involved in User Acceptance Testing.
• Used ALM/QUALITY CENTER to store Test Plans, Test Cases, Test Scripts and for bug tracking.
• Categorized bugs based on the severity and interacted with developers to resolve them.
• Extensively used Microsoft Office Suite of products for documentation and data interpretation.
• Participated in Triage Meetings, weekly status meetings with IT and business people.
• Experience in working with Windows, Client-Server, Web based as well as Mainframe related applications.
• Used ALM/QUALITY CENTER Bug tracking tool to analyze & capture bugs, track and manage dashboard any type of updates for project release.
• Followed the Agile Methodology to emphasize on real time communication over written documentation.
• Used Agile Methodology to minimize risk by implementing software development in short time boxes or iterations.
• Performed backend testing for data validation using SQL Queries.

Environment: Manual Testing, ALM/QUALITY CENTER, HIPAA, SQL, MS Office Suite, Web Services, Etc

QA Analyst

Confidential, San Francisco, CA

Responsibilities:

• Developed Test Plans, Test Cases to test the Screens and workflows for Quality Assurance.
• Developed Test Scripts using Quick Test professional (HP QTP) for extensive functionality and regression testing.
• Created and managed system testing schedule.
• Performed Data Analysis & validation by writing complex join queries
• Performed product testing, user acceptance, remote user testing, usability standards validation, and performance testing; and resolved system defects.
• Created and maintained SQL Scripts to perform back-end testing on the oracle database.
• Performed Database testing using SQL queries
• Conducted GUI, Backend, Data Driven and Security Testing.
• Conducted regression testing on new builds/versions.
• Involved in data mapping of the project requirements, queried the database using SQL queries for data mining, data analysis and data modeling..
• Using Quality center to manage the requirements, test scripts and also defects
• Worked in Agile Testing and participated meetings every day in iterative environment Created and maintained detailed test cases to perform various types of testing in Test Plan module of Quality Center.
• Using Agile methodology and engage in an iterative workflow and incremental delivery of working software.
• Developed and executed SQL queries to verify the proper insertion, deletion and updates into the data Warehouse supporting tables and cubes.
• Extracted data from different department to flat files and load the data to the target Oracle and SQL server database.
• Reviewed extensive SQL Queries with complex multi-table joins and nested queries.
• Involved in reviewing complex SQL queries, views, functions and stored procedures and spotting issues before/during code migration.
• Followed Agile Methodologies and Software Quality Audits for all the Phases of SDLC.
• Tracked defects using ALM/QUALITY CENTER.
• Arranged weekly team meeting to assign testing tasks and acquisition of status reports from individual team members.
• Conducted Bug review meeting to discuss resolution of issues

Environment: ALM/QUALITY CENTER, Manual Testing Methods, Quality center, Functional Testing, Regression Testing, System Testing

QA Tester

Confidential, Elmhurst

Responsibilities:

• Created and managed system testing schedule.
• Provided test team status reports on weekly basis to the project manager.
• Created, updated and maintained the Traceability Matrix mapping the requirements
• Work in Agile, scrum, and sprint environment in order to change the requirements and features set.
• Used HP Service Test for XML based Web Methods testing
• Actively participated Agile and scrum meetings, review and developed test scenarios.
• Reviewed extensive SQL Queries with complex multi-table joins and nested queries.
• Involved in reviewing complex SQL queries, views, functions and stored procedures and spotting issues before/during code migration.
• Performing Multiple rounds of Test Execution using HP Service Test across various releases of services
• Implemented a uniform QA process for dev team, business members and test team to follow.
• Create Test related documents such as Test Plan, Test Scenario, and Test Cases throughout the STLC.
• Work in Agile, scrum, and sprint environment in order to change the requirements and features set.
• Participated in Business Analysis, Requirement review and Technical Specs Inspection.
• Developed Test Plans, Test Cases to test the Screens and workflows for Quality Assurance.
• Expert in writing test scripts manually.
• Conducted Functionality testing during various phases of the application using QTP.
• Performed Regression Testing by generating QTP scripts based on the business process.
• Created and maintained SQL Scripts to perform back-end testing on the oracle database.
• Participated in building automation test scripts based on BPT module of Quality Center.
• Performed Database testing using SQL queries
• Manually performed Backend testing of the application for SQL-Server perform ad-hoc tests to uncover defects and log them..
• Performed rigorous manual testing such smoke testing, Integration testing, Regression Testing, End to End Testing and System Testing.
• Performed Automation testing using QTP.
• Reported difference when confirmed as issues in Quality Center from SME’s.
• Performed backend testing using SQL queries to validate data.
• Detected, reported and tracked defects using Quality Center.
• Conducted the defect report in Quality Center.
• Used HP Service Test for WSDL files validation in Web Services testing
• Conducted regression testing on new builds/versions.
• Run all automated tests in TDD
• Active participant in defining the automation framework (keyword, hybrid) with business users.
• Performed Smoke testing of the application manually after each build.
• Performed rigorous manual testing before a release..
• Used input/output parameter in Web Service Method and operations on HP Service Test
• Conducted Bug review meeting to discuss resolution of issues
• Developed Test scenarios, Test Scripts and Test cases based on Requirements.
• Involved in coordinating with developers and business owners.
• Interacted with the developers to report and using Quality Center.

Environment: VB Scripting, Websphere, Quality Center, QTP, MS SQL Server, Java, Web Services, XML, SOAP UI, J2EE, XML, HTML, Etc

EDI Analyst

Confidential, Bellevue, WA

Responsibilities:

• Developed Test Plans, Test Cases to test the Screens and workflows for Quality Assurance.
• Involved in reviewing complex SQL queries, views, functions and stored procedures and spotting issues before/during code migration.
• Followed Agile (Scrum) environment.
• Developed Test Cases to cover overall quality assurance testing. Created and maintained SQL Scripts to perform back-end testing on the oracle database.
• Performed Database testing using SQL queries
• Expert in writing test scripts manually.
• Validated direct and indirect trading partner and client specific edits and guidelines.
• Monitor resources to identify performance bottlenecks, analyze test results and report the findings to the clients, and provide recommendation for performance improvements as needed.
• Involved in Black Box testing, Regression testing and also performed performance testing.
• Extensively worked on FACETS for medical claims processing.
• Reviewed extensive SQL Queries with complex multi-table joins and nested queries.
• Conducted GUI, Backend, Data Driven and Security Testing.
• Developed checklists to follow standard procedures while creating test data.
• Developed and executed test cases test Scenarios and followed-up defects using ALM/QUALITY CENTER.
• Tracked defects using ALM/QUALITY CENTER.
• Arranged weekly team meeting to assign testing tasks and acquisition of status reports from individual team members.
• Conducted Bug review meeting to discuss resolution of issues

Environment: QUALITY CENTER, Manual Testing Methods, QTP, Quality center, Functional Testing, Regression Testing, System Testing