Post Job Free

Resume

Sign in

Senior Management Sql Server

Location:
Prosper, TX
Posted:
April 22, 2024

Contact this candidate

Resume:

ANUSHA VANAM

ad46p0@r.postjobfree.com

www.linkedin.com/in/anusha-vanam-88705638

732-***-****

Visa status :US Citizenship

PROFESSIONAL SUMMARY:

oOver 15 plus years of experience in both Manual and Automation testing tools.

oComplete exposure to all stages of SDLC processes in Agile, Waterfall, DevOps & SAFE execution methodologies.

oStrong skills in writing Test plans, developing Test strategies including automation and Manual testing, Developing and Maintaining Test Cases, Test Scenarios using Quality Center & JIRA.

oHands on experience in various forms of Testing including Black Box testing, functional testing, GUI testing, system testing, regression testing, security testing, load and performance testing of Web and Client/Server based applications.

oExpert in analyzing and understanding to End user, Functional, Technical, and non-functional requirements and devising test cases while encompassing different complex scenarios.

oPrepare Monthly, Weekly and Daily QA Reports for facilitating discussions with the project stakeholders including Senior Management.

oCollaborate, Track and Report on defects using corporate defect tracking software Bug tracker, QC, JIRA, and Bugzilla.

oReview and Prepare Test Summary Reports for all the projects under the Account before sending across to Senior Management and external stake holders.

oResponsible for ensuring the continual improvement of QA related activities throughout the project lifecycle.

oHands on experience in automation tools like Silk performer, Load Runner Quick Test Pro, and Quality Center.

oWell versed in creating/recording the scripts, modeling real-world behavior, playback the script to ensure script execution, customization of form data from a csv file, configuring user types, baseline performance, select workload model and configuring the load test.

oExperience on Defining User Behavior, Running Load Test Scenarios, Monitoring the Performance Metrics, identifying the Bottlenecks and Analyzing Performance Test Results.

oExtensive experience in using TOAD, SQL Developer and SQL Server Management Studio for database testing.

oHands on experience in writing SQL queries for back-end testing and validate functional scenarios during early stages of development.

oStrong experience in testing RDBMS databases such as Oracle, DB2 and MS SQL Server.

oExpert in Web services testing including all three SOAP, REST and JSON service protocols.

oHand on experience in API testing using SOAP UI and POSTMAN.

oExposure on the tool automation tool for functional and regression testing of the applications for GUI, CLI (command line interface), integrated test management, and API. It contains the ready-to-use configuration for testing business application SAP and Siebel CRM.

oTosco helps the tester to design the test case by drag and drop the modules and inputting the values for validations. Test cases can be created, modified, and automated by non-technical users.

oExpertise in setting up and carrying out browser Compatibility testing with different browsers and versions of Internet Explorer, Netscape, Mozilla Firefox, Google Chrome, Safari on different Operating Systems like Windows and MAC.

oExperience in using HP QC and JIRA as test management tool in defining releases, writing test cases and mapping requirements with test cases, defect reporting and analyzing test results.

oParticipated in SCM audits and Process Audits. Maintained internal documentation library - knowledge base, providing / coordinating special documentation services, as required by PMO, test manager and for cross functional teams.

EMPLOYMENT HISTORY:

Employer

Duration

Bank of America

April 2023-June 2023

Merck

September2022 –March 2023

Aperia solutions

Feb 2020 -August 2022

Client Boeing

Feb 2019- Feb 2020

Augusta Hitech solutions (USA)/Office Depot

Sep 2018-Feb 2019

Info vision

July 2017 – Jan 2018

Cognizant Technology Solutions

Oct 2014 – July 2017

Qfund Technologies Ltd.

April 2013 – October 2014

ADP India Pvt Ltd.

July 2007 – October 2012

Virinchi Technologies Ltd.

Feb 2004 – July 2007

SKILL SET:

Skills

Last Used

Skills

Last Used

JIRA

2023

Oracle

2018

Agile

2023

PL/SQL

2022

Scrum

2023

MS SQL Server

2018

HP Quality Center

2022

Load Runner

2018

SOAP

2019

Silk Performer

2017

REST

2022

DB2

2019

Postman

2022

ADO

2022

PROFESSIONAL EXPERIENCE:

Pyramid consulting April 2023-June 2023

Client: Bank of America (Plano, Texas)

Role: Sr. QA

Responsibilities:

oFunctional Validation of BOFA App. for features developed on live chat for agents and Erica feature for voice/ chat.(online banking AI assistance)

oHands on experience in using Jira/Zephyr plug-in tool for Writing, Design and Document Test cases for the user stories, as a test management tool in defining releases, documenting requirements and test cases and mapping requirements with test cases, defect reporting and analyzing test results.

oSubmit Test cases to Client team members for Peer-to-Peer Review.

oTest the user stories in latest release and execute Test cases in a/Zephyr plug-in tool.

oReview and Coordination of Test Case execution.

oTest UAT environment and sign off the builds.

oValidate CR and Production Defects.

oValidate version releases for different MDA options.

oPrepare Production certification and release note.

Primary Talent consultant September 2022 – March 2023

Client: Merck (Remote, New Jersey)

Role: Sr. QA/ UAT Tester

Responsibilities:

oExtensive experience in tracking User Stories, Issues and CR’s and generating Reports during the sprint execution.

oHands on experience in using Jira/Zephyr tool for Writing, Design and Document Test cases for the user stories, as a test management tool in defining releases, documenting requirements and test cases and mapping requirements with test cases, defect reporting and analyzing test results.

oSubmit Test cases to Client team members for Peer-to-Peer Review.

oTest the user stories in latest release and execute Test cases in Jira/Zephyr tool.

oReview and Coordination of Test Case execution.

oTest UAT environment and sign off the builds.

oValidate CR and Production Defects.

oValidate QRM workflow in UAT.

o

Aperia solutions (Onsite, Dallas-TX) Feb 2020 – August 2022

Role: QA Lead

Responsibilities:

oExtensive experience in tracking User Stories, Issues and CR’s and generating Reports during the sprint execution.

oWorked on CRM (dynamics365) application which is used to Manage, track, and store information related to potential customers using a centralized, data-driven software solution.

oCustomer relationship management (CRM) is a set of integrated, data-driven software solutions that help manage, track, and store information related to potential customers. By keeping this information in a centralized system, business teams have access to the insights they need, the moment they need them.

oUsed Power BI to connect disparate data sets, transform and clean the data into a data model and create charts or graphs to provide visuals of the data to clients and stakeholders.

oHands on experience in using Jira/Zephyr tool for Writing, Design and Document Test cases for the user stories, as a test management tool in defining releases, documenting requirements and test cases and mapping requirements with test cases, defect reporting and analyzing test results.

oSubmit Test cases to Client team members for Peer-to-Peer Review.

oTest the user stories in latest release and execute Test cases in Jira/zephyr tool.

oReview and Coordination of Test Case execution.

oValidate API request and responses using POSTMAN tool.

oCoordinate with Dev team and mentor the team members during SIT testing and bug fixes.

oDone SIT, Regression, and Compatibility testing (different browsers and mobile and mac machines and latest browser versions) in QA and UAT environments.

oHandle offshore team and QA deliverables.

oParticipate in scrum ceremonies.

oSign off the Build to UAT and send release notes to the clients and perform smoke test in UAT environments.

Dell Technologies Feb 2019 – Feb 2020

Client: Boeing (Plano, TX)

Role: Validation Tester

Responsibilities:

oExtensive experience in tracking User Stories, Issues and CR’s and generating Reports during the sprint execution.

oHands on experience in using ADO tool for Writing, Design and Document Test cases for the user stories, as a test management tool in defining releases, documenting requirements and test cases and mapping requirements with test cases, defect reporting and analyzing test results.

oSubmit Test cases to Client team members for Peer-to-Peer Review.

oTest the user stories in latest release and execute Test cases in ADO tool.

oReview and Coordination of Test Case execution.

oCoordinate with offshore team and mentor the team members during SIT testing and bug fixes.

oDone SIT, Regression, and Compatibility testing (different browsers and mobile and mac machines and latest browser versions) in QA and UAT environments.

oTools used One note, ADO and SharePoint

Augusta Hitech solutions- USA

Client: Online Tech (Plano, TX)

Project Description: OT Portal gives the user a single window in which the user can view the environment with Online Tech. From here, the user can add resources to your existing cloud servers, monitor and change your bandwidth, view and answer support tickets, track your cloud expenses, test your DR plan, and more. The user can quickly add RAM, CPU, or storage to your servers, or spin them up or down depending on your needs. You can choose to add or reconfigure your resources on a self-serve basis or call.

Role: Sr. Quality Analyst

Responsibilities:

oAttended all the Scrum Ceremonies including Daily Standup, Release Planning, Sprint Planning and Sprint Retro.

oExtensive experience in tracking User Stories, Issues and CR’s and generating Reports during the sprint execution.

oHands on experience in using JIRA for Writing, Design and Document Test cases for the user stories, as a test management tool in defining releases, documenting requirements and test cases and mapping requirements with test cases, defect reporting and analyzing test results.

oTest suite generates dynamic and synthetic test data. It handles and executes not only manual and automated testing but also GUI as well as non-GUI tests. The tool provides rather detailed reports how the weak points of the system/application under test affect the fulfillment of specified requirements.

oSubmit Test cases to Client team members for Peer-to-Peer Review.

oTest the user stories in latest release and execute Test cases in QC.

oReview and Coordination of Test Case execution.

oSend Daily Status Report to the Client.

oTested API web services testing using Postman tool.

oPrepare release Notes and share with the stakeholders.

oTesting backend using the Database DB2

oHandling offshore team and mentor the team members during SIT testing and bug fixes.

oDone SIT, Regression, and Compatibility testing (different browsers and mobile and mac machines and latest browser versions) in QA and UAT environments.

oValidate the application over computers, tablets, or smartphones (Mobile Testing)

oPerformed browser testing (validating the application in Firefox/chrome/safari, Edge)

Client: Office Depot (Remote)

Project Description: Office Depot, Inc. is an American office supply retailer headquartered in Boca Raton, Florida. The company operates 1,400 retail stores in the United States under the Office Depot and OfficeMax brands, as well as e-commerce sites and a business-to-business sales organization. The Office depot is a leading provider of products and services through an integrated business-to-business (B2B) distribution platform and omnichannel presence, which includes world-class supply chain and distribution operations, dedicated sales professionals, a B2B digital procurement solution, online presence, and a network of Office Depot and OfficeMax retail stores. A POS system is a suite of technology, both hardware and software, used by retail owners to accept payments from customers, among other tasks. Both large and small businesses have use of a point of sale. With cloud-based servers, large and small business owners alike could start accessing their POS system by picking up any device with internet connectivity—whether a laptop, desktop, tablet or smartphone—and logging into their business portal. While the physical location of a business is still important, with a cloud-based POS, the management of that location can happen anywhere.

Role: Sr. Quality Analyst

Responsibilities:

oAttended all the Scrum Ceremonies including Daily Standup, Release Planning, Sprint Planning and Sprint Retro.

oExtensive experience in tracking User Stories, Issues and CR’s and generating Reports during the sprint execution.

oHands on experience in using JIRA/Zephyr plug-in for Writing, Design and Document Test cases for the user stories, as a test management tool in defining releases, documenting requirements and test cases and mapping requirements with test cases, defect reporting and analyzing test results.

oTest suite generates dynamic and synthetic test data. It handles and executes not only manual and automated testing but also GUI as well as non-GUI tests. The tool provides rather detailed reports how the weak points of the system/application under test affect the fulfillment of specified requirements.

oSubmit Test cases to Client team members for Peer-to-Peer Review.

oTest the user stories in latest release and execute Test cases in QC.

oReview and Coordination of Test Case execution.

oSend Daily Status Report to the Client.

oTested API web services testing using Postman tool.

oPrepare release Notes and share with the stakeholders.

oHandling offshore team and mentor the team members during SIT testing and bug fixes.

oDone SIT, Regression, and Compatibility testing (different browsers and mobile and mac machines and latest browser versions) in QA and UAT environments.

oValidate the application over computers, tablets, or smartphones (Mobile Testing)

oPerformed browser testing (validating the application in Firefox/chrome/safari, Edge)

INFO VISION – USA July 2017- Jan 2018

Client: Verizon, Richardson, TX

Project Description: The purpose of the project is to launch the new Wireless Prepaid services including Unlimited-call, Text, and Data services to US customers. The team would design, develop and execute the UAT and perform API Testing in UAT environment for features offered and certify the product from client perspective.

Role: Sr. QA (UAT Tester)

Responsibilities:

oFollowed agile process in the project implementation

oAttended Scrum meetings.

oExtensive experience in using JIRA tool for Writing, Design and Document Test cases for the user stories.

oSubmit Test cases to Client team members for Peer-to-Peer Review.

oTest the user stories in latest release and execute Test cases in QC.

oExtensive experience in using JIRA tool for tracking User Stories, Issues and CR’s and generate the Reports for each sprint.

oSend Daily Status Report to the Client.

oTested API web services testing using Postman tool.

oAutomating the test cases (functional and regression) using the selenium tool and execute the test scripts and log the defects with logs.

oValidate the application over computers, tablets, or smartphones (Mobile Testing)

oPerformed browser testing (validating the application in Firefox/chrome/safari, Edge)

COGNIZANT TECHNOLOGY SOLUTIONS (USA) Oct 2014 – July 2017

Client: Sabre (South Lake, TX) Jan 2017 – Aug 2017

Description: Interact is a GUI (Graphical User Interface) that sits over the Host (Native Sabre) creating some user-friendly windows-based Reservation and Check in application that is configurable for each carrier. In the past, the only way to make a reservation or check-in a passenger was command-line interface (known as Green Screen) where agents performed all their functions.

The idea came to put the same functionality in more user-friendly manner using a GUI. Interact asks for each piece of information needed for the host to respond and then formats the data correctly and sends to the host or web service.

Interact is a common application for all carriers which are hosted by Sabre. It has two modes: Reservation app and Check-In app. The Reservation app is used in carrier’s call centers to manage new bookings or existing ones and the Check-In application is used in airports at the ticket counter and the gates.

The carriers have codeshare agreement, sometimes simply codeshare, is an aviation business arrangement where two or more airlines share the same flight. Sharing, in this sense, means that each airline publishes and markets the flight under its own airline designator and flight number as part of its published timetable or schedule.

Role: QA Engineer

Responsibilities:

oFollowed agile process in the project implementation

oAttended Scrum meetings.

oExtensive experience in using Rally tool.

oWrite Design and Document Test cases for the user stories.

oSubmit Test cases to scrum team members for Peer-to-Peer Review.

oTest the user stories in latest release and execute Test cases in QC.

oExtensive experience in using JIRA tool for tracking User Stories, Issues and CR’s.

oSend Daily Status Report to the Client.

Client: U.S. Bank (Irving, TX) Sep 2015 - Dec 2016

Description: Minneapolis-based U.S. Bancorp ("USB"), with $422 billion in assets as of December 31, 2015, is the parent company of U.S. Bank National Association, the fifth largest commercial bank in the United States. The company operates 3,133 banking offices in 25 states and 4,936 ATMs and provides a comprehensive line of banking, investment, mortgage, and trust and payment services products to consumers, businesses, and institutions. Visit U.S. Bancorp on the web at www.usbank.com.

Role: Sr. Quality Analyst

Responsibilities:

oReview and Coordination of Test Case execution.

oAnalyze, Document, Report and Track the Bugs in test environment (Using QC)

oMaintain internal documentation library - knowledge base, providing / coordinating special documentation services, as required by PMO, test manager and for cross functional teams.

oEnsure SDLC processes are followed in writing test plans, developing, and maintaining test cases, test scenarios

oPrepare QA Findings Reports and circulate Daily status reports to all stakeholders.

oInvolved in the preparation of Training documents.

Client: JC Penny (Dallas, TX) June 2015 – Sep 2015

Description: Retail Domain and creating a shopping experience that merges the intimacy of a traditional store with the digital conveniences of personal technology. Online retail models require a web presence from both physical and digital companies. E-commerce is the buying and selling of goods and services over the internet.

Role: Sr. Quality Analyst

Responsibilities:

oReview and Coordination of Test Case execution.

oPrepare and execute SQL Queries for Data base testing.

oAnalyze, Document, Report and Track the Bugs in test environment (Using QC)

oMaintain internal documentation library - knowledge base, providing / coordinating special documentation services, as required by PMO, test manager and for cross functional teams.

oFollowed agile process in the project.

oEnsure SDLC processes are followed in writing test plans, developing, and maintaining test cases, test scenarios

oEcommerce Business Model conducted over computers, tablets, or smartphones (Mobile Testing)

oPerformed browser testing (validating the application in Firefox/chrome/safari, Edge)

Client: Freddie Mac (Mclean, VA) October 2014 – May 2015

Description: Freddie Mac was chartered by Congress in 1970 to provide liquidity, stability, and affordability to the nation's housing market. Today Freddie Mac is making home possible for one in four homebuyers and is one of the largest sources of financing for multifamily housing. FM participates in the secondary mortgage market by purchasing mortgage loans and mortgage-related securities for investment and by issuing guaranteed mortgage-related securities, principally those we call PCs. The secondary mortgage market consists of institutions engaged in buying and selling mortgages in the form of whole loans (i.e., mortgages that have not been securitized) and mortgage-related securities. FM does not lend money directly to homeowners.

Role: Sr. Quality Analyst

Responsibilities:

oPrepare QA Findings Reports and circulate weekly status reports to all stakeholders.

oReview and Coordination of Test Case execution.

oPrepare and execute SQL Queries for Data base testing using DB2

oAnalyze, Document, Report and Track the Bugs in test environment (Using QC)

oMaintain internal documentation library - knowledge base, providing / coordinating special documentation services, as required by PMO, test manager and for cross functional teams.

oFollowed agile process in the project.

oEnsure SDLC processes are followed in writing test plans, developing, and maintaining test cases, test scenarios

QFUND TECHNOLOGIES: April 2013 – August 2014

Client: Allied Cash Advance Financial (ACA) (Atlanta) April 2013 – August 2014

Description: Allied Cash Advance Financial (www.alliedcash.com) is a Pay Day loan company based out of Miami, Florida. Qfund has signed a contract with ACA for the deployment of ‘QFund’ (www.qfund.net) – premier software for Payday, Installment and Tile loans industry. At Allied customers are offered with multiple short-term financing loans like Payday, Installment and Title Loans.

Allied Cash is an Industry Leader in Payday Loans. Payday loans are designed to help people cover short-term cash needs until their next payday. Sometimes referred to as cash advances, they can be a practical and quick way to tide over when out-of-the-blue expenses crop up. A payday loan typically ranges from $50 to $1,500, depending on the state. The amount borrowed, along with a small fee, is typically due on your next payday.

If the customer owns a vehicle, they may be eligible for a Title Loan. A Title loan is a short-term loan that can help get the cash by using vehicle as collateral. When the customer applies for a title loan with Allied Cash Advance, the vehicle will be appraised to determine its wholesale value. That value will help determine the maximum loan amount the customer may be eligible to obtain.

Role: Quality Analyst

Responsibilities:

oPrepare QA Findings Reports and circulate weekly status reports to all stakeholders.

oReview and Coordination of Test Case execution.

oPrepare and execute SQL Queries for Data base testing using DB2

oReview and Monitor Silk Performer scripts.

oMonitor and Review the Data migration steps from the Client system to the proposed new Systems

oAnalyze, Document, Report and Track the Bugs in test environment (Using Bugzilla)

oPrepare demo data for client walkthrough and demo.

oInvolved in the preparation of Help Manuals.

oRecommend improvements in QA related activities and Lead the implementation of new processes as approved by Executive Committee.

oMaintain internal documentation library - knowledge base, providing / coordinating special documentation services, as required by PMO, test manager and for cross functional teams.

oFollowed agile process in the project.

oEnsure SDLC processes are followed in writing test plans, developing and maintaining test cases, test scenarios.

oDone performance testing using silk performer tool.

oAPI web services testing using SOAP UI. (Tested Web Services /XML /SOAP services using SoapUI tool.)

ADP INDIA PVT LTD: July 2007 - October 2012

Project: Performance Evaluation of ADP CRM application

Description: Automobile Dealers need a system to maintain relation with their customers. ADP CRM gives the dealer a fully integrated system that allows for quick entry of data; track the leads through closure; follow up with the customers; automated business development; automated campaign management; reporting; OEM integrations for managing leads. As it involves interacting with lot of users, the following issues need to be addressed using the performance evaluation:

1.How does the database react with existing or desired concurrent users?

2.Will the implemented application meet the end user performance requirements with respect to response time and throughput?

3.Is this implemented solution scalable?

Tools Used: Silk performer & Load Runner

Role: Sr. Quality Analyst

Responsibilities:

oPrepare QA Findings Reports and circulate weekly status reports to all stakeholders.

oReview and Coordination of Test Case execution.

oPrepare and execute SQL Queries for Data base testing using Oracle

oAnalyze, Document, Report and Track the Bugs in test environment (Using QC Tool)

oInvolved in the preparation of Help Manuals.

oTraining new QA resources in the project.

oLead QA activities in SCM and Process Audits.

oEnsure SDLC processes are followed in writing test plans, developing, and maintaining test cases, test scenarios.

oMaintain internal documentation library - knowledge base, providing / coordinating special documentation services, as required by PMO, test manager and for cross functional teams.

oDone performance testing using silk performer, Load Runner.

oFollowed agile process in the project.

VIRINCHI TECHNOLOGIES LTD, INDIA Feb 2004 - July 2007

Project: QFund POS Customization & Implementation

Description: Virinchi has pioneered a web-based application within the US short term industry covering various products. The application is internally developed and later customized to each client. Allied Cash Advance Financial is one such Pay Day loan company based out of Miami, Florida. Qfund has signed a contract with ACA for the deployment of ‘QFund’ (www.qfund.net) – premier software for payday loan industry.

Role: Sr. Quality Analyst

Responsibilities:

oPrepare QA Findings Reports and circulate weekly status reports to all stakeholders.

oReview and Coordination of Test Case execution.

oPrepare and execute SQL Queries for Data base testing using DB2.

oMonitor and Review the Data migration steps from the Client system to the proposed new Systems

oAnalyze, Document, Report and Track the Bugs in test environment (Using QC)

oPrepare demo data for client walkthrough and demo.

oTraining new QA resources in the project.

oRecommend improvements in QA related activities and Lead the implementation of new processes as approved by Executive Committee.

oMaintain internal documentation library - knowledge base, providing / coordinating special documentation services, as required by PMO, test manager and for cross functional teams.

oEnsure SDLC processes are followed in writing test plans, developing, and maintaining test cases, test scenarios.

oAPI web services testing using SOAP UI. (Tested Web Services /XML /SOAP services using SoapUI tool.)

ACADEMIC BACKGROUND

Level

Awarded

Institute / Board / University

Year

%

Bachelors

B Tech - ECE

VREC – Jawaharlal Nehru Technological University

2002

70%

Higher Secondary School

-

Board of Intermediate

1998

85%

Certified Tester

ISTQB Certification

Foundation level

2005



Contact this candidate