Lavanya Gangisetty
Summary *********@*****.*** 614-***-****
Over 6+ years of experience in Manual & automated testing of Web and Client server IT applications,.Net, Java, CRM Applications, and mobile Device using Automation and Manual.
Work with Windows workstations and Windows servers, and Large-scale, multi-tiered applications
Extensively experienced in Manual, functional, system and automated testing, Data base Working in a software development .
Extensively worked on Banking, Health Care, Life Insurance, Retail, Hardware/firm ware Device (UPS, NMC, ISXC, and Net Botz), Finance, Telecom Domains.
Experience in Selenium with core java(OOPS,Inheritance,Interfaces,Test NG).
Expertise in working with Selenium IDE and Selenium Web Driver using TestNG.
Worked in Defect management tools are QC, BugZilla, JIRA, Version One, Mingle and Test Director Systems.
Expertise in designing and developing strategic Use case reviews, Test plans, Test Cases, Test Scenarios, design meetings, Test matrixes, Test Reports for both manual and automated tests.
Experience in Quality Assurance of GUI, Web, Mobile, Windows, Web services, Database, Mobile by using the automated testing tools like Selenium, QTP/UFT, Quality Center (QC), JIRA and manual testing as a part of job.
Skilled in Oracle, SQL, My Sql and MS-Access databases.
Excellent understanding of Software Testing Life Cycle (STLC) Software Development Life Cycle (SDLC) and Testing Methodologies from project definition to post-deployment documentation.
expertise in the System Testing, Regression Testing, in system integration, Black box testing, White box Testing, UAT, Integration Testing, Functional Testing, Non Functional Testing, Monkey Testing, Exploratory Testing, Load Testing, Sanity and smoke testing, cross browser testing and QA methodologies.
Experience with QTP - Object repository, Functions, regular expressions, parameterization, transactions, descriptive programming, Object spy, function library, Checkpoints and Actions.
Expert at using Microsoft Office Tools like MS Word, MS Excel and Power Point for Documentation, Reporting and Presentation.
Preparation of RTM(Requirement traceability Matrix)to validates the Requirements with Test cases
Expert of Agile, Water fall, V-Models.
Expert in Linux/Unix Operating systems.
Knowledge of informatica tool for ETL Testing.
Educational Qualification:
Bachelor of Science (1997 - 2000)
Masters of Science (2000 - 2003)
Visa Status: US Citizen
Skill
Automations Tools
Selenium, Quick Test Professional (QTP/UFT), QC, Win runner.
Testing Tools
ALM,Quality Center, Version one,Mingle,Jira,Test Director, Bugzilla,.
Programming Languages
Core Java, VB Script, JAVA Script,HTML,XML,TCP/IP,SNMP Visual Studio (VSTS), C#.
Data bases
SQL Server,Oracle,MS Access, My Sql.
Operating Systems
Windows XP, Vista, MS Office, Windows 7 UNIX/ Linux, Perl.
Programming Skills, App/Web servers
and other tools
Core java, Visual Basic, .NET,Web services, Soap UI, XML, SAP, Informatica,, (ETL, Data warehouse),LDAP.
Professional Experience
Professional Experience
Client: Bank of America (Infosys) Charlotte, NC June 2016 to Still
Role :Test Lead/Analyst
Project: ODD(Online Delivery document),DCS(deposit Combined Stmts):ODD is checks-files deliver from one application to another application and Record count is matching for all applications with some filtered conditions..
DCS checks Dormant acc and statement is visible in the online Banking..
Responsibilities:
Analyze the requirements and prepare Test plans and Test Scripts using ALM.
Automate Regression Test scripts using Selenium and Java.
Execute mainframes Batch Testing check and send the everyday Report.
Ingest the Exceptions using Soap ui on Web service and analyze exceptions Settle those Exceptions.
Analyze the Recon file and Report files using ETL Data stage/Informatica.
Attend every day Defect meeting and End to end Test calls.
Log the Defects in ALM and track the Defect status.
Write sql queries in the back end and get the data from Oracle.
Review Test plans and Take approvals from Team and sign off the project for every Release.
Environment: Mainframes(Batch testing),Soap UI,Rest Service(API Testing),ETL Data stage /Informatica,Selenium,ALM,MS Excel,Exel Macros,Linux,Unix,Oracle,Ms Office, RIT,Wease less tool,Java
Client: Ally Bank (Infosys) Charlotte, NC December 2015 To May2016
Role: Test Analyst
Project :TSG(Mobile Application) -This application customer Transfers, Check Deposits(RDC),Bill pay,PopMoney,Touch id functionalities using all Mobile devices(Ipad,Iphone,Android,windows,Tablet/Kindle).
Responsibilities:
Analyzed user requirements and documented test requirements, Test Plans, Test Cases using ALM.
Develop Test Scenarios,Test Plans and test cases in ALM/QC and Excel sheet.
concentrate on GUI, Installation, Interrupt,compatibility testing for different Mobile devices.
Reviewing the Test Reports using TestNG in Selenium.
Developed the Automation Test Scripts Using APPIUM and Selenium.
Import Data from Excel to Selenium Using Data driven Framework using Test NG Frame work.
Involved in writing the SQL queries and procedures to test the back end.
Tested application on different mobile devices(Android and IOS)using Device Anywhere.
Reported bugs on both mobile and desktop applications.
Testing the issues reported by users on different devices like Android phones, Android tablets, iPhones, iPads under different conditions like Wi-Fi, 3g, 4g, Hotspot, Downloading the latest Binaries and installing.
Conducted Unit Testing (Module Testing), system Integration Testing(SIT), Regression and Smoke,UAT Testing, in agile methodology
Attending morning Status Meeting and Discussed about our work Status and daily Triage Meeting discussed about Defects.
Report and log the Defects using Defect Tracking tool as ALM/QC.
Environment: Manual testing, Selenium, Appium, Core Java, Web Driver, ALM/QC, Oracle, MS office, MS Excel, Excel Macros, Mozilla Firefox, Google Chrome,Mobile Devices .
Client : Bank of America(TCS) Charlotte,NC August 2014 To December 2015
Role :Quality Analyst
Project :R3(GSS/Mobile dups/P3DDCN's/IR-IT/OECL) -This application Adjust and Settle the Customers financial exceptions, mobile dups,check images balance will be done as part of Memo/Hard posts.
Responsibilities:
Analyzed user Stories/Requirements done by SME's in Version one/Mingle.
prepared Test Scenarios' in Version one participates Every day morning Stand up Meeting discussed our daily Status.
Prepared Test Scenarios and Test Cases and test Plans in Excel and upload in to ALM(12.20) .
Prepared complex Sql scripts using Toad Oracle DB for Test data.
Using Unix/Linux commands retrieved the Server logs(file processing/R3) and analyses the Results.
Participating Grooming Meetings, Retro Meetings, Demos, bug review meetings with developers to understand the Business requirements and clarify our questions&suggetions,discuused our previous Iterations Stories, and Share Demo's with clients and so on..
Conducted Unit Testing (Module Testing), system Integration Testing(SIT), Regression and Smoke,UAT Testing, in agile methodology.
Preparation of RTM(Requirement traceability Matrix) to validates the Requirements with Test cases.
Developed VB scripts in Quick Test Pro to perform end to end testing and created a set of re-usable scripts.
Executing Regression Test Suit on every Month for every Release using Selenium.
Experience on Working with TestNG for Automation testing Reports.
Ingest the Exceptions using Soap ui on Web service and analyze exceptions Settle those Exceptions .
Participated data driven Frame work Using Soap ui pro and ingest many exceptions from Excel to Sop ui.
Analyze Back end Results using Main Frames.
Prepared and Execute QTP Data driven Test Scripts.
Environment: Manual testing, QTP/UFT,ALM/QC,Version one,Mingle,Java,Vb Scripts,Selenium,Web Driver, Core Java, Main Frames, Oracle, Linux/Unix,Tectia,WebService,Soap ui, MS office,MS Excel, Excel Macros, Mozilla Firefox, Google Chrome.
Client: Citizens bank (INFOSYS) Cranston,RI FEB 2013 To June 2014
Role Quality Analyst, finance
Bunker Teller Testing: using This application customers do different transactions like Deposits, with drawls(On us /off us),Transfers and ODP and balance will be done as part of the EOD(Memo post), balance will be on Hard Post updates.
Responsibilities:
Analyzed user requirements and documented test requirements, Test Plans, Test Cases using ALM.
Develop Test Scenarios,Test Plans and test cases in ALM/QC and Excel sheet.
concentrate on GUI, Installation, Interrupt,compatibility testing for different Mobile devices.
Reviewing the Test Reports using TestNG in Selenium.
Developing VB scripts in Quick Test Pro (QTP) to perform functional, regression, system and end to end testing.
Created and executed Manual test cases and Automation test scripts using QTP.
Reports Issues in JIRA and put some Comments in Existing Issues.
Prepared Test Cases for GUI application. Developed test scripts for Data driven testing using QTP.
parameterization in QTP by using Excel sheet for test data and Database Queries based on the functionality.
Developed VB scripts in Quick Test Pro to perform end to end testing and created a set of re-usable scripts.
Attending sprint plan meetings every two to four weeks to review the user stories.
Experienced with Iterative and Agile methodologies.
Conducted Unit Testing (Module Testing), system Integration Testing(SIT), Regression and Smoke,UAT Testing, in agile methodology
Check the status in Cross browsing/ different Browsers like Internet explorer, Mozilla Firefox, Google Chrome and Safari.
Participated in bug review meetings and resolving the issues related to the bugs.
Preparation of RTM(Requirement traceability Matrix) to validates the Requirements with Test cases.
finding the defects and logged in to ALM/QC.
Developing automated test cases based on end to end test cases
checked updated Status using Mainframes(Mainframes Testing)
Developed and executed SQL queries to verify data integrity.
Extensively used Informatica Workflow Manager to run the workflows.
Monitored the session logs/log files in Informatica Workflow Monitor.
Tested the ETL Informatica mappings and other ETL Processes (DW Testing).
Analyzed and tested Informatica Mappings with OLTP source data.
Environment: Manual testing,ALM/QC,Selenium,Webdriver,TestNG,QTP/UFT,UAT, VBScript,Java script, Web services, SoapUI, Retail,POS,JIRA, Unix/Linux,SqlServer,ETL,Informatica, Mainframes,Unix/Linux,,Informatica, MS Office, SSRS, android device(mobile),LDAP,RQM.
Client : North Western Mutual (INFOSYS) Milwaukee, WI Feb 2012 To DEC 2012
Role Quality Analyst,Insurance
NM Connect(Northwestern mutual Connect):NM is basically Financial Services, that includes life insurance, long-term care insurance, disability insurance, annuities, mutual funds, and employee benefit services etc
Responsibilities:
Attended Standup meetings/Scrum meetings every day morning with our Agile Team.
Reviewing the Test Reports using TestNG in Selenium.
Attended IPM(Iteration Planning Meetings),Showcase Meetings(Live Demo for previous Iterations).
Retrospective(Previous Issues and Issues),ready for estimations,number of story points in each user story with Agile team.
Under stranded the user stories/Requirements in Mingle.
Develop the Test Scenarios, Test Plans and test cases in QC and Excel sheet.
Experience on Working with TestNG for Automation testing Reports.
Developed and executed SQL queries,joins to verify data integrity.
Conducted system integration Testing, Regression and Smoke, Unit (Module),UAT Testing.
Check the status in cross browsing/ different Browsers like Internet explorer, Mozilla Firefox, Google Chrome and Safari.
Provided daily status report on the testing progress and other concerned issues.
Review of Test Scripts and Developed the Test Scripts using QTP (VB script), RUBY.
Developing and maintaining automated test scripts for all applications and services released by development using Selenium .
Executed VUGen scripts in Load Runner for Performance, Load and Stress Testing using Controller
in Load Runner and generated reports using Analysis tool in Load Runner.
Performed Smoke, Security, GUI, Regression and User Acceptance Testing.
Involved in web services testing using SOAPUI.
Reporting and tracking defects using the management tool (Mingle) and TFS.
Discuss and resolve defects and their priorities in daily QA meetings to resolve issues.
Developed and Executed Automated test Scripts using QTP (Quick test professional)..
SAP CRM Loyalty Management with expertise in customer segmentation, point management and partner management.
Data Driven Testing using parameterization in Quick Test Professional (QTP) to test the application with different sets of data .
Environment: Manual Testing, QTP/UFT, Mingle, Load Runner, MS Office, Unix, Seibel CRM, Selenium web Driver, JAVA, web services, Soap UI, XML, POS,QC, Rapid SQL, UAT,SAP, LDAP,SSRS,ETL, Informatica, TFS, VSTS,Mozilla Firefox, Google Chrome and Safari, Android.
Client Schneider Electric by APC, West Kingston, RI Dec 10 to Nov 11
Role Quality Analyst, CRM, Retail
NMC/PCBE/PCNS: NMC is using for Access and monitoring of a UPS Products, other APC Products. It Provides Notification and Data regarding the status of UPS and its Environments. Features included saving shopping cart, multiple shipping addresses, gift registry etc.
Roles and Responsibilities:
Understanding the Hard ware/Firm ware products(UPS,NMC,PCNS,PCBE,ISXC,Netbotz)
Analyzing the BRS document, Test Procedures in Excel sheet and some Products in QC using CRM APP.
Analyzed user requirements and documented test requirements and create Test Plans, Test Cases, test Reports in QC and Excel .
Report and log the Defects using Defect Tracking tool as TFS.
Review of Test Scripts and Developed the Test Scripts using QTP (VB script), Selenium(java).
Familiar with some of Hardware and software/Firmware products.
Performed White Box, Black Box testing including sanity testing, functional testing, UAT, System testing and regression testing.
Developing VB scripts in Quick Test Pro (QTP) to perform functional, regression, system and end to end testing.
Reports Issues in JIRA and put some Comments in Existing Issues.
Issuing command through CLI (command line interface), HyperTerminal.
Discuss and resolve defects and their priorities in daily QA meetings to resolve issues.
During the testing to Capture data in to these interfaces, SNMP, web, ISXC, Netbotz, Syslog, Email Server, Syslog and do compatibility Testing.
Execute test procedures using QC, Netbotz, and ISXC.
Check the status in different Browsers like Internet explorer, Mozilla Firefox, Google Chrome and Safari.
Developed and executed SQL queries to verify data integrity.
APC internal software simulators to simulate ups testing while NMC and Modbus.
Check the status in CMD using some Unix/Linux Commands.
Good knowledge of Network infrastructure products (SAN, NAS).
Preparation of RTM (Requirement traceability Matrix) to validates the Requirements with Test cases.
Environment: Manual testing, QC, QTP,UAT, VB Script, Java, HTML, SOAP UI, CSS, JIRA, Unix/Linux,,Sql Server, windows 7,CLI, MS Office Tools(Excel, word, Perl script, CRM (Seibel Applications),Mobile Applications,TFS, sap(ERP), IBM, E-Commerce.
Client Medical Mutual of OHIO,Healthcare Cleveland, OH Jan 10 - Nov 10
Role Quality Analyst
QRS is an online health insurance Quoting and Renewal system for Medical Mutual of OHIO.QRS for Group Insurance is a B2B application primarily used by brokers and representatives of MMO. QRS for Individual insurance is a B2C online application that can be accessed online. Testing with medical devices(Diabetes device), claim module.
Roles and Responsibilities:
Analyzed user requirements and documented test requirements, Test Plans, Test Cases using Quality Center.
Created and executed Manual test cases and execute Automation test scripts.
Performed Black Box testing, Unit Testing, and Gray box testing including sanity testing, functional testing, UAT, System testing, Monkey testing and regression testing.
Created and executed Manual test cases and Automation test scripts using QTP (Visual Basic).
Developed VB scripts in Quick Test Pro to perform end to end testing and created a set of re-usable scripts.
Used Data sheets in Quick Test Pro to import data from data tables for conducting the Data Driven Testing.
Identified and reported software defects using Quality Center.
Knowledge of WSDL code, SOAP in web service.
Reported the failed test cases, tracked the defects and verified the fixes in multiple environments.
Participated in bug review meetings and resolving the issues related to the bugs.
Developed and executed SQL queries to verify data integrity for back end Testing.
Preparation of RTM (Requirement traceability Matrix) to validates the Requirements with Test cases.
Write the Test Scripts using different kind of Methods, like using Descriptive programming, using Functions and using Actions.
Worked with Frame (Data driven, Modular, keyword driven) works.
Environment: QTP,ManualTesting,QualityCenter,VBSCRIPT,HIPPA,HIPAA PHI,HIPAA EDI, Oracle, UNIX,E-Commerce,,ICD-9,ICD-10 codes, SQL,MSOfficeTools, Visualstudio2010,.NET,web service,(SOAP,WSDL),XML,,SAPTesting, Seibel6.X,5,(CRM Industry,CTI).