We provide IT Staff Augmentation Services!

Sr. Quality Analyst Resume

Milwaukee, WI

SUMMARY:

  • A Strong IT business professional with over nine years of diverse experience in Information Technology with an emphasis on Software Quality Assurance.
  • 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.
  • 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.
  • 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).
  • Exclusive experience in testing and development in SharePoint 2010.
  • Hands on experience in SQL Server new features in test 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
  • 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.

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. Quality Analyst

Confidential, Milwaukee, WI

Responsibilities:

  • Analyzed and reviewed BRD, SRS, FRS, TRS documents to design quality test cases.
  • Performed UAT, End to End, System testing, and Smoke testing, Regression Testing and Performance Testing.
  • Prepared AS-IS PMS (Mainframe Policy Management System) and to identify current functionalities for Quote, Submit and Issuance of Confidential Policies and TO-BE documentation.
  • Conducted Functionality testing during various phases of the application using UFT/QTP.
  • Created Test conditions, Test cases for Retail and point of sale (POS) functionalities.
  • 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
  • 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.
  • 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
  • Developed and executed UAT test cases, UAT test Scenarios using Quality Center and followed-up defects using JIRA.
  • Conducted database validation using SQL queries.
  • 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 using ALM/QUALITY CENTER.
  • 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.

Quality Analyst

Confidential, Sunnyvale, CA

Responsibilities:

  • Participating in the requirements analysis and design meetings with DEV, BIZ team for Review and facilitate in requirement freezing.
  • Involved in Daily Sprint standup meetings, Sprint Grooming, Sprint Planning, Sprint Review and Sprint Retrospective meetings.
  • Responsible for testing web services both on the back end and also the consumers of the web services.
  • Performed browser compatibility and configuration testing on various operating systems such as Blackberry OS, Android OS, iOS etc.
  • Web services Testing by SOAP UI tool.
  • Executing the test cases (manual and automated) and reporting the bugs in Mingle and QC/ALM.
  • Worked in all phases of SDLC and software development methodologies like Agile/Scrum, Waterfall etc.
  • Involved in System, Functional, End-to-End, Regression, Integration, Black Box, Ad-hoc, Risk based, Usability and accessibility testing.
  • 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.
  • 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.
  • 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.
  • Tested ASA app on different iOS versions.
  • Tested Buy Online and Pickup in Store (BOPIS) functionality.
  • Tested Credit, Gift Card tendering using cards stored in Passbook.
  • Tested Credit, Debit and Gift Card transactions.
  • Used SQL queries to access the database for Back-end testing.
  • Worked with ETL Confidential 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.
  • 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.

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

QA Tester

Confidential, Chicago, IL

Responsibilities:

  • Prepared Test Plan from the Business Requirements and Functional Specification.
  • Involved in reviewing and analyzing the functional requirement documents with the Business Analyst & stakeholders.
  • Developed test strategy & test plan and reviewed with all stakeholders, Development team, Infrastructure team and other teams.
  • Performed database testing by using SQL queries
  • Preparing daily status reports and defect reports.
  • Tested the outgoing links from all the web pages from specific domain.
  • Tested Mobile applications for iOS and Android devices.
  • Updated the status of the testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly.
  • Collaborate, Coordinating, communicate, create offshore onshore (onsite) day - to-day activities
  • Reported bugs and tracked defects using JIRA.
  • Managed and executed the test process, using Agile Methodology
  • Involved in Preparing the Status Reports Every Week, which includes Revision History, test case status, metrics, QA Issues and Defects.
  • Planned and worked flexibly to meet the dead lines.
  • Prepared Execution procedure document format to prepare the Test cases based on mapping document.
  • Worked closely with the Business Users while performing User Acceptance Testing (UAT) in staging

Environment: SQL, UAT, MS OFFICE, VISIO, SOAP UI, UNIX, UML, JIRA, Quality center, VISIO, Web Services, Agile, Mobile, iOS, etc.

Quality Analyst

Confidential, Chicago, IL

Responsibilities:

  • 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.
  • Maintained Requirement Traceability Matrix (RTM) to make sure that test plans were written for all the requirements.
  • 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.
  • 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.
  • 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.
  • Worked on FACETS User Interface Modernization and Claims enhancements like ICD-10 enhancements etc.
  • 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
  • Manually test each and every module of the application and verify against expected results.
  • 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.
  • 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.
  • 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.

Environment: Windows, Quality Center, SQL, QTP, Web logic, MS Office Suite, UNIX, Oracle, XML, FACETS, HL7, HIPAA, EDI, SOAP UI, UNIX, VISIO, SOA, Web Services, Etc.

QA Analyst

Confidential, Chicago, IL

Responsibilities:

  • Developed Test Plans, Test Cases to test the Screens and workflows for Quality Center.
  • Prepared the test scripts for the Regression test cases using QTP
  • Worked with XML/SOAP UI (web services) Using agile methodology and engage in an iterative workflow and incremental delivery of working software.
  • End to End testing of Financial Products such as Certificate of Deposits, Checking Accounts, Trading Accounts, etc.
  • Participated in flash meetings between QA & Development team.
  • Responsible for Manual Testing and Automation Testing.
  • Analyzed, documented and maintained Test Results and Test Logs.
  • Performed Web testing to check for broken links in a page.
  • Analyzed Ecommerce needs and recommended web site structure and basic design guidelines
  • Validated database operations by executing SQL statements and compared actual database with new results to assure there is no data missing.
  • Reviewed extensive SQL Queries with complex multi-table joins and nested queries.
  • Rigorously tested SQL’s implementation of existing code.
  • Performed backend testing for data validation using SQL Queries.
  • Involved performing end to end testing of Ecommerce applications
  • Created data driven tests using QTP by adding statements to already existing scripts so that test scripts could be run with multiple sets of data.
  • Configuring and implementing stubs simulating actual web services
  • Performed Acceptance, Usability, Cross-Platform and Regression Testing during different stages of the application development.
  • Participated in daily Scrum meetings and sprint reviews and Implement AGILE QA processes and practices for efficient test and defect management.
  • Used 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 Quality Center.
  • Reported the defects to the developers using Jira defect reporting tool.
  • Use Fiddler as web debugging tool which logs all HTTP(S) traffic
  • Have knowledge of the SQL queries for testing the database.
  • Bug Reporting using Quality Center.
  • Interacted with the developers to report and using Quality Center.
  • Involved in troubleshooting various build and configuration issues.
  • Participated in Triage Meetings, weekly status meetings with IT and business people

Environment: Windows, Quality Center, SQL, MS Office Suite, QTP, Web Services, Etc

QA Analyst

Confidential - Dorchester, MA

Responsibilities:

  • Acted as point of contact from QA team to Project Management, Development, Business Analyst and Business User teams.
  • Created ETL Test Plans, Test Strategies and Test Cases.
  • Coordinated with Business Users to understand business needs and implement the same into a functional Data warehouse design.
  • Extensive testing on the Performance of the Stored Procedures in PL/SQL.
  • 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.
  • Involved in Usability Testing and coordinating with end users for giving Training on Web Based application.
  • 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.
  • 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.
  • Tested the web pages, user login pages according to the user security roles and requirements.
  • 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
  • Assist and guide project teams to implement and document standards, procedures, artifacts, and plans consistent with QA and Test deliverables for the project team.
  • 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.

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

QA Tester

Confidential, Elkridge, MD

Responsibilities:

  • 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.
  • 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.
  • 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.
  • 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.
  • 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.

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

QA Tester

Confidential - Rochester, MN

Responsibilities:

  • 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.
  • Wrote SQL scripts and PL/SQL queries using TOAD and Oracle SQL Developer to query DBs and analyzed the results.
  • 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.
  • Reviewed Functional and Integration requirements.
  • 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
  • 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..
  • 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.
  • 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.
  • 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, TOAD, J2EE, XML, HTML, Etc

QA Tester

Confidential, NJ

Responsibilities:

  • Wrote Test Plan and Test Cases according to business requirement.
  • Responsible in validating the Enhancements made to Interfaces
  • Performed data driven testing by data driver wizard and parameterization.
  • Responsible for developing various test scenarios, test cases based on business requirements and functional specifications.
  • Creating and updating test cases based on new and/or /updated functional or interface requirements
  • Performed requirement traceability by setting automatic alerts for tracing changes in the requirements and system maintenance
  • Manually performed functional testing based on the specification documents.
  • Responsible for validating HL7 messages for various interfaces.
  • Constantly tested SQL for joins and contexts for new object creation.
  • Responsible in doing Data mapping testing.
  • Used Test Director in executing test cases, defect tracking, and the complete test management
  • Participated in weekly meeting with the management team and walkthroughs
  • Tested applications and documented results and bugs including documentation of information useful in the debugging process
  • Generated the test execution report in Test Director to be reviewed by the QA Manager and development team.
  • Attended weekly defect report meetings and presented progress update status.
  • Participated in walkthroughs and meetings with business analyst, developers, team lead and QA manager on regular basis.
  • Performed Backend Testing using SQL queries to validate the data in the Oracle database.

Hire Now