Uppala
PH: 503-***-****
VISA STATUS : EAD E-mail: ******.***@*****.***
7+ Years of IT experience involved in generating test plan, test design, test development and implementation of test procedures for client server and Web based applications.
My work has required coordinating with software developers, programmers and projects engineers on testing ,test automation design, tests implementation and execution level.
Experience in process based methodologies like Agile, Water Fall and V Model.
Good experience with Automation tools like QTP, Load runner.
Expert in automated test tools like Win Runner, Test Director, Quality Center and Quick Test Pro.
Extensive Experience in IE, Netscape Navigator and Mozilla Browsers.
Involved in Project Planning, Coordination and implementing various QA methodologies Like Agile, Water Fall and V Model.
Expert in performing different tests types, QA Methodologies: White Box, Black Box, Front-End and Back-End, Stress & Load, Regression, Configuration, Functional, Installation & Integration, Smoke, and User Acceptance Testing.
Documenting Test documents using MS Office tools- Word, Excel, PowerPoint and Quality Centre
In-depth participation in design reviews and requirement analysis with development team and the client.
Proven ability to support multiple projects, under tight deadlines, often with competing priorities and complexities.
Experience in testing SAP Applications Manually
Personal skills including Excellent Communication, strong sense of organization and effective time management and have the ability to work in a team as well as independently.
Strong in SQL, PL/SQL languages and Database concepts.
Educational Qualifications
Master in Computer Application Degree
Test Tools Win Runner, Load Runner, Test Director, Quick Test Professional (QTP), Quality Center,Test Complete, SOAPUI, JUnit, Rational Clear Quest, Track Record, Bugzilla, TrackMe
Scripting Languages XML, HTML, ASP, Shell Scripting, Perl, VB Script, JavaScript
RDBMS MS SQL Server 6.5/7.0/2000, Oracle 8i/9i, TOAD
Programming Languages C++, JAVA, SQL, PL/SQL, ASP.Net, VB.Net, Visual Basic
GUI ASP, Applet driven applications, JSP, Swing, AWT, JFC, .Net Windows & Web-based applications.
Operating Systems Windows 95/98/ NT/ 2000/ XP, UNIX, Linux, Mac2, MS-Dos.
MS-Suite MS-Word, MS Excel, MS-Project, MS Visio, MS Outlook.
Version Control Tools VSS, CVS, PVCS
Technical Skills
Professional Experience:
GSI Commerce, PA. July 07 - till date
Sr.QA Analyst
GSI Commerce is a leading provider of outsourced E-commerce solutions that enable retailers, branded manufacturers, entertainment companies and professional sports organizations to operate E-commerce businesses.
As a Sr. QA Test Analyst, I involved in multiple projects like Petsmart, Toysrus, Hershey’s and Roxy and used various tools like JDA, Epiphany, CMS, DASHBOARD and PROMOTIONAL tools.
Responsibilities
• Analyzed entire Business requirements and Specifications.
• Developed the Test plans, Test Scenarios and Data gathering and preparation of test data.
• Developed test cases and test scripts for Integration, system, regression and UAT testing.
• Involved in development and execution of Test Cases and scenarios for all the testing stages.
• Utilized HP Quality Center for tracking test requirements, test plans, defects and communicating them among the team members and developers.
• Involved in peer review of test case/test script documents.
• Scripting of test cases in Quality Center by analyzing the SRS, IAD and IDD documents.
• Performed System, Regression, Functional testing and Design performance tests to enhance existing tests.
• Involved in testing the database and data validation using SQL Queries.
• Performed Manual, Automation and Performance Testing.
• Good team player, effective in communicating, coordinating and proactive in learning new technologies and methodologies.
• Created test automation scripts using QTP. I Worked on VB Scripting extensively, while creating the automation scripts.
• Performed load testing for 6 different applications and collected various Statistics.
• Have taken several testing process initiatives and improvements.
• Participated in Walkthroughs and defect report meetings periodically.
• Developed SQL scripts using TOAD tool, to extract data from the target tables.
• Worked with PL/SQL procedures.
• Performed Regression testing of different stores to see that no existing functionality gets affected with new store launches.
• Involved in Performance Tuning of the application.
• Verified the CMS spots using CMS tool
• Created promotions using promotion management tool and verified on the web store.
• Involved in multitasking.
• Tested WebServices (SOA, Service Oriented Architecture)and SOAPUI.
• Evaluated QTP for automation & created various GUI checkpoints using QTP.
• Created test automation scripts using QTP. I Worked on VB Scripting extensively, while creating the automation scripts.
• Created Data driven scripts (DDT) for Functional testing & Regression testing along with customized test result facility in Excel
• Used JDA for various tasks.
• Written UNIX shell scripts to combine, compress, and FTP the compressed files to target system.
• Verified log files in the UNIX environment for different message in and out of applications.
• Defects were tracked and reported by using HP Quality Center.
Environment: Windows2000/XP/NT, Quality Center9.0, Toad, Oracle 9i,JAVA,javascript,Office XP, IE, Safari, Fire fox, UNIX, Unix shell script, HTML, JDA, CATMAN, Epiphany, CMS, XML and Dashboard, Load Runner, SOAPUI.
Fifth Third Bank, PA Aug06 - Jun 2007
Account Maintenance system
QA Consultant
Description : As a member of QA team, analyzed and tested Account Maintenance system. This WEB based application is designed to maintain customer accounts and support the business functions and financial transactions.
• Gathering the Business requirements and the High-level specifications from the Business Analyst.
• Preparation of Test Plans
• Analyze Project requirements and create test cases
• Coordinate with tech lead to make sure the build/installation is done and the test environment is ready
• Stood as a point of contact for environment support as well as resolving environmental issues as they arose.
• Involved in complete technical and functional aspects of testing of the applications modules.
• Performed system testing, regression testing and end to end testing
• Developed scope documents, design specifications, Test plans and Change Request documents.
• Developed & maintained the traceability matrix between requirements.
• Generated Project specific Weekly Status Report.
• Worked on automating Using Quick Test Professional and Quality Center’s business process testing.
• Involved in developing UNIX Korn Shell scripts to initialize variables, run jobs and perform error handling.
• Written automated scripts in QTP to implement the automated smoke test.
• Extensively used SQL for data integrity testing at the backend.
• Worked closely with the Project manager, Business Analyst and the development team.
• Effectively communicated with other teams to make modifications in the design of their Application so that system can be implemented effectively and timely.
• Developed the Training Handouts and Turnover documents.
• Generated the detailed Final Summary reports of the Bugs, Pass-Fail report.
• Worked with Quality Center to report and track the Defects .
• Developed Test Summary Reports and participated in GO / NO-GO meetings.
Environment: Manual, QTP, Windows NT/2000, UNIX, Java 2.0, EJB, JSP, JDBC, Servlets and Oracle.
Jackson National Life Insurance, Detroit, MI Jun 04 – Aug06
QA Consultant
Jackson National Life Insurance is the one of the major insurance companies in America. They provide Life insurance. This Application was developed to process various insurance requests, claims for Life Insurance. Call centers and field agents use this application. Data about insurance requests and claims would be collected from users and processing would be done to calculate premium and claim amounts. I was involved in Performance baseline testing to ensure the application performs at or above expected levels. This application was web-based which was developed in three-tier architecture.
Responsibilities:
Involved in gathering business requirements for the project by interacting with the end client and holding sessions with developers.
Helped QA Team to implement testing objectives
Studied and understood the functionality of the application under test.
Formulated Test plans from Business Requirements/Function Specifications documents.
Created several Test cases that cover the entire functionality of AUT.
Wrote and executed test scripts to verify most of the Test cases using WinRunner.
Created and enhanced numerous test scripts to handle changes in the objects, in the tested application’s GUI and in the testing environment using WinRunner.
Manually performed Functional testing that includes Security, Unit, System testing.
Back-End Testing, database table manipulations of relational database systems by writing complex SQL queries manually.
Version Control - used PVCS to check out the latest versions of the build for testing purposes, and check in the updated test cases, and test documentation periodically
Conducted Regression Testing using WinRunner.
Managed these tests in TestDirector.
Involved in setting up UNIX groups, defined UNIX user profiles and assigning privileges to users.
Executed UNIX shell scripts in background.
Written UNIX shell scripts to reduce test execution steps for different complex test cases.
Reported defects about any failures in the script with TestDirector.
Analyzed results of the tests by creating reports in TestDirector.
Actively participated in Status Reporting meetings.
Have attended class room sessions on LoadRunner and QTP tools.
Environment: TestDirector 6.0, PVCS,Winrunner7.5, SQL, Oracle 8i, Windows NT/2000, TSL, AS400,UNIX.
Merrill Lynch, Hopewell, NJ Sept 03 – May 04
Sr.QA Tester
Merrill Lynch is record Keeper for various companies stocks. This application is developed reduced call duration as the FA/REP/OPTIONEE [Financial Reporting Environment (FiRE)] will be able to process multiple exercises by entering only one transaction. Multiple Grants will be exercised seamlessly and the fees and commissions will be charged as if the exercises were entered on a one-by-one basis.
Responsibilities
Implemented Mercury interactive automated tools like Quality Center, WinRunner.
Extensively used Test Director to track the business requirements.
Developed Manual test cases, test scripts and test scenarios for AUT.
Extensively used functions while editing test scripts to minimize code redundancy and to improve the performance.
Compared and analyzed the Test Results for every release.
Performed Positive and Negative Testing on the application
Conducted Cross Browser testing with IE5.5, NS6
Conducted Functional and Regression testing using WinRunner during various phases of the application development
Performed System, Acceptance, Unit, Integration and Cross-Platform testing of various complex applications
Responsible for performing various types of process evaluations during each phase of the software development life cycle including, audit, review, walk through and hands on system testing.
I involved in Agile Methodology.
Performed White box, Black Box Testing, and Back end Testing.
Cross-Browser testing was performed on different versions of IE and Netscape.
Prepared Test Summary Reports for every release using the Test Director reporting tool.
Actively participated in enhancement meetings focused on making the application more effective.
Environment: C#, ASP.NET, HTML, VB Script, Java Script, XML, Oracle 9i,TOAD, Rational Tools, SAS, QTP, Test Director, WinRunner, Windows NT, Visual Basic, Oracle 8i, MS-Word, Ms-Excel, MS-Project.
Schering-Plough, New Jersey Nov 02 – Aug 03
QA Consultant
Schering-Plough is one of the Leading Pharmaceutical Industry in United States of America. We deliver innovative new medicines by adhering to the principles of a Customer-Centered Product Flow. Schering sells their products more than 120 countries in the world and a minimum of 32,000 people works for Schering activities including major and minor. BNDA-DMR [Building New Drug Application – Data Management and Reporting] Project for Design, development and testing of ETL routines for feeding the data into warehouse from Source Systems.
Responsibilities:
Responsible for writing the Test plan, writing Test cases, analyzing user requirements and Functional Design Specification documents .
Preparation of test data files for the negative and positive test cases.
Executed all Test cases, Test scripts according FRS, BRS documents. Also used Automated Testing tools like QTP. Mainly focused on Functionality of the application
Performed Smoke, Functionality, Integration, System, Regression tests based on Analysis, and requirements, non-functional specifications, and end-user needs
Produced timely Testing Metrics and Summary Reports for project management and the quality assurance manager throughout testing life cycle for use in gauging testing status and identifying any course corrections needed to ensure adequate coverage and quality.
Testing on Web interface and admin interface for UI Testing using SOA Test.
Created Intelligent Scripts those are capable of controlling the flow of automation based on external conditions.
Wrote SQL queries to check proper data population in application tables
Used Parameterization for using various data to test the application.
Participated in Walkthroughs.
Expertise in Mercury Quality Center 8.0 (Test Director 8.0) for defect tracking and reporting, also followed up with the development team to verify defect fixes and updated defect status.
Worked closely with Developers in resolving the issues and understanding the functionality.
Environment: Ab Initio (GDE 1.14.15 and 1.13.3, Co-Operating System 2.13.1), Oracle10g, Flat Files, AIX5.0, Shell Scripting, Windows NT/2000,Mercury Quality Center 9.0, Mercury QuickTest Professional , Load runner, VB Script, C/C++
Aster Teleservices Pvt Ltd, India. Mar 01 – June 02
Project : Aster Vehicle Locator
QA Consultant
The application aims to provide services to the Customer. An Aster vehicle locator (AVL) is a software that makes use of the Global Positioning System (GPS) to enable a business or agency to remotely track the location of its vehicle fleet by using the Internet ,combining a location-sensing device (such as a GPS receiver) with a wireless communications link to provide a home office or dispatcher with the location of a vehicle or mobile asset (such as a trailer or heavy machinery).This application combine GPS technology, cellular communications, street-level mapping, and an intuitive user interface, with the ostensible goal of improving fleet management and customer service. The vehicle's location can be quickly found and it could be rerouted to provide timely delivery to a nearby customer.
Responsibilities:
• Requirements Study, Understanding and Analysis.
• System, Integration, UI and Regression Testing.
• Defects were tracked and reported by using Bugzilla.
• Used Test Director for maintaining the test cases and Test scripts for the application
• Coordinated efforts with the development team to resolve the issues and bugs.
• Test Reporting, Defect Reporting and Tracking.
Environment : Visual Basic. Net 6.0, SQL Server 7.0, Windows NT 4.0, Win Runner 5.0, UNIX,
Bugzilla.
Project : ACME Home Solutions
.NET Developer
The Application will assist to automate all activities of Call Center Executives, Care Center Executives, Technicians and Administration Staff of ACME Home Solutions Pvt. Ltd. The Application has provision to Add New Technicians; Assign a call to Technician and gives easy tracking facility to Call Center and Care Center Executives to give accurate status of Customers Call and to add feedback of Technicians to Calls attended.
• Designed and developed ACME for Gymnasiums using VB.Net.
• Used ADO.NET for SQL Server database interaction using Data Adaptor, Data Reader, and Dataset.
• Used Grid controls to show the list.
• Involved in testing, debugging and implementation.
Environment: VB.NET, ASP.NET, ADO.NET, SQL Server 2000, MS Visual Studio .NET, Visual Source Safe, Microsoft Windows XP.
***********************************************************************************************