Agile methodology,Waterfall method,SoapUi,Jira,Html/Xml,SQL,Toad,QC

Quality Assurance Analyst

Lakshmi

Phone: 614-***-**** Email: *****.******@*****.***

Objective:

To work in Dynamic, Professional and Enterprising environment which will provide me the potential for advancement and increased IT skills, decision-making responsibilities through consistent learning under the business and IT leaders.

Professional Skills:

Around 5 years of experience in IT Industry with emphasis on Quality Assurance & Software Testing.

Experienced and Involved in QA software testing processes like test planning, test case design, test environment set up, test data set up, defect management, test log, test results, test traceability matrix, test automation and User Acceptance testing.

Expert in testing multi-tier web applications.

Having in depth technical experience of Software Testing Life Cycle (STLC), Software Development Life Cycle (SDLC), Water Fall and Agile methodologies.

Involved in reviewing and analyzing business requirements and writing detailed test plans, test cases and test scripts.

Participated in bug meetings with developers to validate the severity of the bug. Manually retested the application for Smoke Testing and Regression Testing.

Extensive experience in manual as well as automation testing of web based application.

Hands on experience in Functional Testing, Integration Testing, Regression Testing, User Acceptance Testing, Performance Testing and Validation Testing.

Extensively worked with various teams and data architects from QA prospective to come up with processes in dev/QA/Prod for extraction, Transformation and loading data into the data marts. Hands on Experience in Data manipulation, defining components and in writing SQL Queries.

Experience in Cross functional mythologies Waterfall, Scrum, Spiral and Agile Scrum

Experience in manual testing and Automation with tools like Quick Test Pro (QTP), Win runner, Unified functional Testing(UFT) and Load runner.

Used Quick Test Pro and Unified Functional Testing to perform regression testing on the Applications.

Extensive use in Agile Management Tool Version One and Bug tracking Tools like Quality center and JIRA

Skilled in Validation and Testing complex scenarios for the maintenance of Quality standards in Projects.

Experience on backend testing and executed the queries using TOAD tool.

Strong knowledge in Writing and Executing SQL Queries to verify source-to-Target mapping and transformation rules (ETL Processing) in Data warehouse manually.

Working experience in a cross-functional team environment/ different geographical locations teams.

Knowledge in HP LoadRunner–VUGen, Controller and Analysis tools for performance Testing (Non-Functional Testing).

Also, familiar with automation tool like Selenium.

Experience in using SOAPUI for web service testing of WSDL and REST.

Experience in documentation for all aspects of computer system validation (CSV), installation qualification (IQ), Operation Qualification (OQ), Performance Qualification (PQ) and final validation reports in a regulated environment.

Affective team player, self-motivated, capable of adopting to new technologies, Strong problem solving and analytical skills and inter-personal communication skills, team skills.

Experience in working with QA teams comprising of on-site and Off-site teams.

Good Team Management and Leadership skills and adaptability to handle testing projects/ tasks from any stage.

Ability to work effectively in a fast-paced, high volume, Dead-line driven environment.

Ability to work hard to obtain a challenging and responsible position in the area of Software Testing where my knowledge, ability and dedication will be utilized.

Technical Expertise:

Functional Tools

QTP 10.0/9.5/9.2, UFT 11.5, Win runner 6.0

Performance Tools

LoadRunner

Bug Tracking Tools

QC 11.0/ 10.0/9.2, Test Director 7.2, Jira 7.0

Languages

HTML, DHTML, VB script, C, C++, Visual Basic

Methodologies

OOP, Client Server, Mainframe

Internet Technologies

VB Script, XML, HTML

Database Technologies

Oracle 10g/9i, MS SQL Server 2008, SSMS 2012/ 2008

Web Services

SOAP, REST, WSDL, JSON

Operating Systems

Windows 2010/2008/2007/2003, Unix, Linux

Web and App Servers

Apache Tomcat, Web sphere, Web logic server

MS Office

MS Word, MS Excel, MS PowerPoint

EDUCATION:

Master of Computer Application(MCA) From Andhra University, Andhra Pradesh, INDIA

Bachelor of Science (BSc. Electronics) From Andhra University, Andhra Pradesh, INDIA

Professional Experience:

New York Financial Technology Partners (New York FTP) Mar’17 to Current

Mortgage Approval Process & Online Pay (MAAP)

QA Test Analyst

MAAP project developed based on the different phases of mortgage loan processing. The various modules are signup, sign-in, preapproval, amortization schedule, Loan submission, Loan approval, underwriting, closure, online payment etc. The application is a web based tool that would allow users to apply for a loan and the users within the organization to process the loan application. MAAP is integrated with multiple third-party applications like Credit Bureaus, Payment gateway.

Responsibilities:

Attended sprint plan meetings, Daily standup meetings, and Reviewed user stories in Agile Environment.

User stories were tracked using Jira.

Validated schedulers to make sure the mortgage account generated and reports are generated for each customer.

Validated CRON jobs executed as per the schedule.

Tested end to end application process including, signup, sign-in, amortization schedule, pre-approval letter, loan approval process, online payment and monthly statements.

Tracked the defects using JIRA

Developed Test Cases to test Web Services and Restful calls using SoapUI tool.

Validated Web Services and RESTful calls by comparing the data with Database and User Stories.

Executed SQL queries, Joins and Performed Backend testing and ensured the Retrieval of the Data from the Database. Validated Reports and statements.

Conducted Regression Testing on various builds of the application and reported the defects to the developer using JIRA.

Involved in complete Software QA Testing life cycle right from reviewing user stories, test plan, test cases, test data prep, smoke test, test case execution, defect tracking, regression testing, UAT, Integration testing, security testing and many more activities.

Involved in the documentation of Test Plan, Test cases, Test Data Document and RTM (Requirement Traceability Matrix).

Executed Shell scripts to start/stop web servers, web services, app servers on Linux based on the need.

Environment:

Java/J2EE, spring, Hibernate, JDBC, Apache Tomcat, MySQL, JSP, HTML, Linux, Jira, Rally, Toad, SQL Console, Web Services, SOAP, RESTful Services, XML, Jason, Shell Script.

BCBS, Detroit, MI April’16 to Feb’17

Digital Experience-Member portal

QA Analyst

New member portal: The main purpose of member portal is to provide transparency, clear and simple customer experience. New member portal-is a new site which combines three different portals (BCBSM, BCN and IKA) which allow members to view their Coverage, Claims Information and Explanation of Benefits, Copay Information for different plans under single login which will give transparency to member and allow them to take Health assessments, which will reduce premiums.

Responsibilities:

Participate in Requirement & Design document review session, Evaluate Requirement & Design docs from a quality test automation standpoint.

Worked on writing Test scenarios and Test Case Documents.

Managing requirements, Test cases and execution in Excel.

Designed Generic and goal oriented scenarios in the Microsoft Access from which test suites are ran in the SOAPUI.

Extensively worked on web-services testing using SOAPUI involving Multi-Services Test Scenarios execution.

Worked on Test strategy and Test plan documents as per the project guidelines.

Collaborated with the QA and Dev team in understanding of the user stories.

Involved in the Test data gathering and creating the mock up data manually.

Working Experience in Web-Services testing using SOAPUI by creating scenario based tests in WSDL and Excel files.

WSDL has the application to test in HTML/XML tag format and test data entered in those tags using SOAPUI was derived from the Requirements analysis document.

Performed Functional, Regression testing, UAT Testing on Member improvements, Mobile Application on IOS and Android devices.

Uploading test cases in internal web portal.

Conducted Backward Compatibility testing after upgrading software from release to release.

Provided management with analyzed test results and provided recommendation for performance improvements as needed in the Retrospective meetings.

Involved in developing Harnesses and Templates for automated test execution in SOAPUI.

Coordinating with various teams for test data and for defect resolution.

Worked with the Development Team and Business Analysts in identifying problem areas.

Identified and logged defects based on user stories in JIRA.

Executed and maintained the Regression suite during the Regression Testing phase.

Share test execution, defect reports with scrum master and team lead on daily basis.

Assisting in UAT, Performance and Release testing.

Key participation in regular Agile meetings and development-QA meetings for clear status updates and immediate analysis of bugs found during execution phase.

Analyzed and Tested the screen reader accessibility issues in all the browsers for mobile, Tablet and mac; documented issues, reviewed the problems with the Development team to resolve the outstanding issues.

Working with cross-functional teams for End -to -End testing.

Environment: SAOPUI, JIRA, Mobile Devices, Windows, Toad, MS Excel.

MasterCard, St. Louis, MO Oct’14 to Mar’16

MasterCard Connect

QA Analyst

MasterCard is a technology company and payments industry leader. For more than four decades, it has been driving force at the heart of commerce, making the global economy safer, more efficient, more inclusive and more transparent for all. MasterCard Connect is a platform where MasterCard interacts with all of its clients which are banks through applications based PEGA. It is a crucial platform for business to MasterCard.

Responsibilities:

MasterCard Connect is a platform which involves integrating with many applications which consume MasterCard services, we as a team coordinated no less than 30 MasterCard teams.

We design and implemented a compelling, elegant, enterprise grade system platform used by MasterCard clients(banks) to access MasterCard services.

Connect is an ecommerce application where clients of MasterCard order applications of MasterCard through ‘Cart-Check out’ procedure.

Extensively worked on SoapUI for validated backend RESTful web services.

Worked as a key participant in integration testing applications on MasterCard Connect.

Worked in a team of twenty-five developers with five testers in agile methodology.

Involved in the requirement gathering sessions along with platform analyst and business owners and understand the functionality.

Learned application business requirements, technical specification and installation guidelines.

Hands on experience in testing components on multiple browsers like Firefox, Chrome,

IE 8, 9,10

Wrote and executed test cases for major program modules

Performed usability, GUI, Functionality and regression testing of the new builds

Identified application defects to minimize number of steps to reproduce the problem

Performed browser (IE, Firefox, Chrome, Safari) and platform (Windows 7/Vista/ XP) compatibility testing in virtual machine environment

Identified and isolated software defects and reported them via JIRA

Actively participated in QA team meetings and discussions

Very high interaction with developers throughout the sprint releases explaining the requirements given by business.

Experience working in Onsite - offshore model involving teams from Brazil and India.

Extensively worked in validating migration data, smoke testing of application during production 'Go - Live'.

Testing and logging bugs found as part of testing and having them assigned to developers.

Retest the logic immediately once fixed and closing the fixed issues.

Maintaining track of issues opened in JIRA and prioritizing them as we go through the release.

Fetching the data using queries in TOAD.

Provided management with analyzed test results and provided recommendation for performance improvements as needed in the Daily SCRUM meetings.

Executed Smoke Test at the end to ensure proper functionality of enhanced services.

Populated the data into the test scenarios and also created required data in TOAD.

Created Test cases, Test scripts as per the design documents (both Functional and Technical Designs).

Key participant in regular agile meetings and Development- QA meetings for clear status updates and immediate analysis of bugs found during execution phase.

Gave effective inputs in the retrospective meetings where we discuss on what went well, what didn’t go well and what better can be done.

Verified the back-end reflection in the database by establishing connection to the database and by executing SQL queries in the testing procedure.

Environment:

Soap UI, MS Visio 2010, TOAD, JIRA, QC 9.0, MS excel 2010

Supervalu Inc, Eden Prairie, Minnesota Apr’14 to Sep’15

WBBT (Web based Business tool)

QA Analyst

WBBT is a tool through which virtual shops can easily be ported within a short span of time. This remains as a platform and contains generalized concepts of Ecommerce. The following modules are part of the system which includes User module, Vendor Module, and Backend management module. Each module has an interface over which a site can be build. The product hierarchy consists of department categories, attribute names and attribute values. Vendor can log on and submit their products by choosing the options like adding/ modifying or deleting a product. Also, vendors can initiate sales on their product by submitting start and end time of the sale. Backend management has different users and administration. Access to the database is subject to user privileges. Backend user can confirm a vendor product or a sale depending upon their privileges. End user has to register with the site and they can browse the products through the hierarchy level or by search. They can add product to their cart or save and finally check it out for shipping. They will be informed via emails about their order details.

Responsibilities:

Participated in preparation of test plan and developed test cases for full requirement coverage.

Created requirements mapping to tests and test sets in QC and maintaining traceability matrix.

Backend validation using SQL Queries in SSMS.

Assisting production manages in script execution in different cycles of UAT.

Maintaining UAT documents in SharePoint.

Coordinating with QA team and Dev team for required Test setups and Data Setups in database.

Assigned Testing Tasks through QC and configured notification rules for test that scheduled manually to send emails throughout the release.

Involved in Automation test design, planning, development and maintenance of automated test suits.

Performed Smoke, Integration, System, Regression and End to End testing for the release before moving into production.

Used dashboard to create a report for status meetings for the project from requirements, test plan, test lab and defects report.

Tracked defects through defects module and associated them to test and test sets to trace and rerun whenever fixed by developers.

Worked with users in clarifying requirements and enhancements to the project in UAT testing Phase.

Experience in testing database applications of RDBMS in My SQL.

Extensively used SQL Server management studio to validate data in the Database.

Extensively prepared Weekly reports for all kinds of Testing done and for different integrations.

Attending conference calls with offshore team to discuss the testing status and to assign defects to the concerned developers.

Environment:

QC 10.0, QTP 9.5, Agile, SSMS, Windows 2008.

All STATE Insurance, Irving, TX. Sep’13 to Mar’14

All STATE Agency Gateway System

QA Analyst

All STATE agency gateway system is a centralized portal application used by Allstate agents and customers across the country to view, add and edit policy level information for customers. This centralized system interfaced with multiple all state systems including new business policies, claims, financial A/R and IVR system supporting 15000 agency users, Staff and associate members. System was built using IBM portal system with Oracle system using REST/WSDL web services System.

Responsibilities:

Prepared test cases and test plans for new functional modules.

Written white box and Black Box test cases based on the User and Business Requirements.

Actively involved in SDLC and STLC process and used tools like ALM, SOAPUI, SSMS.

Actively participated during functional and regression test cycles supported all major production releases.

Involved in setting up test environment and test infrastructure development in both manual and automation development.

Performed GUI Testing, Functional Testing, Regression Testing and Positive/Negative testing for system validations.

Participated in daily SCRUM meetings and gave the daily status of testing.

Worked in Agile Scrum methodology for frequent software delivery.

Participated in designing Tests using Keyword Driven methodology for selected Areas.

Involved in Regression testing using Quick Test.

Worked in Automation using QTP by developing scripts which are used to automate modules.

Developed test cases using WSDL, Schema files which defines web service request, response, methods or operations, end point of webservice to be tested.

Responsible for setting up webservices project using WSDL in SOAPUI and provided set up help to other team members.

Testing of webservices using webservices client generated using SOAPUI to track request and response of SOAP messages.

Extensively used SQL Queries for Back-End testing using TOAD.

Wrote SQL queries to test the application for data integrity and verified the contents of the Data table.

Extensively used SQL queries to check storage and accuracy of Data in Database table.

Strong ability in developing SQL queries to extract manipulate and/or calculate information to fulfill data and reporting requirements including identifying tables and columns from which data is extracted.

Execution of test plan and monitoring defect tracking process using QC.

Involved in Weekly and monthly status reports.

Environment:

QC 10.0, QTP 9.225, SOAPUI, TOAD, MS Office, MS Excel, Windows

Contact this candidate