Anupama Adusumilli
Email: abhj78@r.postjobfree.com
Cell: 408-***-****
SUMMARY
Over 12+ years of experience in Quality Control and Quality
Assurance of Enterprise Software Applications as a QA Lead, Test
Coordinator,
Sr. QA Analyst and Test Analyst across variety of projects and
environments with onsite-offshore coordination, leadership and
mentoring
roles in creation and execution of QA testing processes, test
strategies, test plans, bug tracking, documentation and automation
frame works.
. Experience includes on varied technologies such as Web based, Object
Oriented, Client-Server Multi tier Apps and ERP Applications.
. Expertise in Quality Analysis with strong understanding of Software
Development Life Cycle (SDLC) and object oriented methodologies.
. Expertise in Analysis, Writing test cases and interacting with Users
for Application Implementation, Upgrade, customizations and
Enhancements.
. Extensive experience in preparing test plans, test cases, and test
scenarios, test reports, performing Black Box Testing, Regression
Testing, Integration Testing, Smoke Testing, and User Acceptance
Testing.
. Expertise in preparing Test Strategy, Test Summary Reports, Test Cases
and Test Scripts for Automated and manual testing based on the User
Requirement Documents and System Requirement Documents.
. Experience in test management and defect tracking tools like Quality
Center, Test Director, Clear Quest and Jira.
. Experience in Database testing using TOAD and SQL Navigator
. Ability to understand Functional and Software Requirements
Specification documents
. Experience in writing the code for the automation scripts by using
QTP, Win Runner and Load Runner.
. Well versed in analyzing Results, Bug Tracking & Reporting, Detailed
status reporting.
. Experience in Business Process Testing (BPT).
. Experience working with UNIX, Shell scripting, SQL scripting, managed
version control software and defect tracking systems
. Experience in testing Windows based applications, Client/Server (2-
Tier), Multi-Tier, Communication Industry applications and Health care
applications
. Familiar with the SDLCs: Waterfall, Spiral, Agile and/or Scrum, V-
model and the effective integration of the quality assurance life-
cycle(QALC)
. Proficient in working with databases like Oracle, SQL Server on both
UNIX and Windows platforms, web technologies like HTML, XML
. Good team player with excellent communication, written and
presentation skills with strong aptitude towards learning new
technologies.
. Will actively participate in the overall enhancement of the software
product quality.
. Involved and Lead Test teams across varied scale of projects.
TECHNICAL SKILLS
Testing Tools Quick Test Pro, Win Runner, Load Runner, Business Process
Testing
Rational Tools Test Manager, Manual Test, Rational Clear Case, Rational
Clear Quest, Rational Data Test, Rational Requisite Pro,
Testing Mercury Quality Center, Test Director, Rational Test
Management Tools Manager, Jira
Programming C, C++, Java, C#, .Net
Languages
Scripting VBScript, Java Script, Shell Script
Language
Web Technologies Dream weaver, FrontPage, HTML, DHTML, IIS, JBOSS, XML, SQL
Databases Oracle, MS-Access, SQL Server, DB2, Toad, SQL Developer,
SQL Server Management Studio
Other Software MS Office Professional Suite, MS Project, MS Visio, Lotus
Notes, Same Connect, Netmeeting, Remedy, WebEx, Antivirus,
Adobe Acrobat reader (PDF), FTP client, Adobe Photoshop,
Macromedia Studio, Win Utilities, Putty, Crystal Reports,
WinSCP, XML Spy, Oracle Applications 11.5.10, R12
Operating Systems Windows 7, WINDOWS 98, XP, Vista, NT, 2003, 2005, MS-DOS,
UNIX, Linux
PROFESSIONAL EXPERIENCE
Client : Blockbuster Inc, Dallas, TX
Project Name : Website Redesign
Period : March 2011 - Present
Environment : Jira, Enterprise Tester, Oracle, SharePoint, MS
Excel Professional 2003 and 2007, VB Script, HP QTP, Java, SQL, Unix, Toad,
Windows XP, MS Visio, MS Project, Agile
Role: Lead QA Analyst
Blockbuster Inc., is a chain of DVD, Blu-ray and video game rental stores.
This project Website Redesign deals with the customizations done to the
existing blockbuster.com website. The customizations are delivered in
different builds following Agile methodology and existing as-is
functionalities are also being tested along with the new functionalities.
Responsibilities
. Created test plan for customizations to the new website.
. Co-ordinate on-site and off-shore QA Teams, to make sure that QA
deliverable are of high standards.
. Participate in the creation of the test execution schedule.
. Developed and tested the application in Agile Methodology.
. Manage Testing activities i.e., Write Test Cases, Execute the Test
Cases, Identify defects and track defects using Jira.
. Uploaded and executed test cases in Enterprise Tester.
. Attending scrum meetings on daily basis.
. Automated manually written test cases by using Quick Test Pro
. Performed Regression testing using QTP
. Analyzed and developed test reports using MS-Word and MS-Excel
Client : JCPenney, Plano, TX
Project Name : Project import - Merchandise Financial Planning
(MFP)
Period : March 2010 - Feb 2011
Environment : HP Quality Center, DB2, SharePoint, Unix, MS
Excel Professional 2003 and 2007, VB Script, BPT, HP QTP, XML, C++, VC++,
Java, .Net, Oracle, SQL Server, SQL, Unix, Toad, Windows XP, 2005, MS
Visio, MS Project, Intuit Quick Base, Agile
Role: QA Lead
J.C. Penney Corporation, Inc. is one of America's largest department store,
catalog and e-commerce retailers. JCPenney Catalog, including e-commerce,
is the nation's largest merchant of general merchandise, and JCPenney.com
is one of the largest apparel and home furnishings sites on the internet.
This Project is to Merge Merchandise Planner applications for Direct and
Stores in same application. Enterprise Assortment Planning Tool is used to
merge both Direct and Stores applications with Oracle as backend database.
Responsibilities
. Designed test design methodology and define naming standards.
. Created test plan for enhancements to the application as well as to the
new application.
. Create requirements and function coverage metrics.
. Co-ordinate on-site and off-shore QA Teams, to make sure that QA
deliverable are of high standards.
. Analyze test report, Produce test designs and Test Data strategy.
. Participate in the creation of the test execution schedule.
. Developed and tested the application in Agile Methodology.
. Identify potential data sources and gather basic candidate test data.
. Manage Testing activities i.e., Write Test Cases, Execute the Test
Cases, Identify defects and track defects using HP Quality Center.
. Performed Regression testing using QTP
. Used XML Spy to send request and response XML's and validate the data.
. Analyzed and developed test reports using MS-Word and MS-Excel
. Manage and Perform Data validation, System, Functional, Regression,
Interface and smoke testing on APT stores, CAMP, PDB and CIS
applications.
. Test standalone, client server and web based applications developed
using various technologies like C++, Java, .Net, DB2.
. Analyze test cases, create reusable business components and enter in
Quality Center.
. Ensure that products meet or exceed the quality standards by applying
knowledge of quality assurance standards and procedures set by ATC.
. Created Wiki Page for the application.
. Attended various Test Process, Requirements management process and
defect management process conducted by ATC.
. Mentoring team members, Developers and BAs on general testing
process/protocol and Tools.
. Worked directly with Business Analysts to understand requirements and
to modify and update requirements.
. Participated in the test environment setup and in ensuring that the
facilities, test tools and scripts are in place to successfully perform
the required testing effort by Regression Team.
. Conducted trainings on Business Process Testing.
. Created User training manuals for all applications.
Client : Dell, Round Rock, TX
Project Name : Global Quote to Cash (Q2C)
Period : April 2009 - Feb 2010
Environment : Oracle Apps 11i(Financial, SCM modules),
Windows XP, MS SQL Server, SQL Management Studio, MS Office, WebEx, VPN
Client, PDF, SOA, XML, HP Quality Center, Windows 2005, Mozilla, Rational
Unifying Platform, QTP, Web 2.0, Ajax, CSS, GWT, Ext JS, Agile
Role: Lead QA Analyst
The Global Quote to Cash (Q2C) program aims at implementing Dell solution
and processes for Sales quote through to Cash collection across all
Regions. The scope of the project extends to all areas impacting revenue
recognition, cost of goods sold, booking and collection of accounts
receivable. This is implemented in all operating units and segments across
the Us, Americas International, EMEA, Asia Pacific and Japan with all
products and services.
Responsibilities
. Developed the test scripts for both Financial and Supply chain modules
according to the MD050 documents.
. Developed the test scripts for all the business units.
. Involved in all phases of testing including pre-testing, unit testing,
smoke testing, Regression testing, Adhoc testing, functional testing,
Integration Testing, System Testing, UAT Testing.
. Developed Test Data, Test Design documents, Test cases, Test Plan,
Test Scripts, Test Results, Test Log, Test Strategies, supporting
documentation and Test Failures.
. Tracked the defects using defect management tool called Quality
center.
. Review of User Requirements, Design Documents and interact with
Business Analysts and end users to understand the technical
requirements.
. Involved in On-site and Off-shore co-ordination.
. Written database queries using TOAD and SQL to retrieve data depending
on the functionality.
. Interacted with the off shore team to meet the deadlines of the
execution.
. Used automation scripts for execution using Global Test Framework.
. Interacted with the functional and development team to resolve the
defects.
. Submitted status reports during test release cycles.
. Prepared the training guides for users on different applications.
Client : Brocade Communications, San Jose, CA
Project Name : Project Hilton
Period : Oct 2008 - March 2009
Environment : Oracle Applications 11i(Financial Modules),
Agile Methodology, XML, HTML, DHTML, MS Office, SQL server 2005, VB
script, MS Share point, HP Quality Center, Windows XP, QTP 9.2, Oracle,
Unix, MS Visio, MS Project.
Role: ERP Consultant
Project Hilton involves changing the Brocade's existing organization
structure for the primary purpose of realizing tax benefits that comes with
shifting the registration of the Swiss Entity to a different county in
Switzerland. Currently, Brocade maintains two distinct Sets of Books for
the Legal Entities and the reporting subsidiaries established in Geneva -
Switzerland, namely: Swiss-1 and Swiss-2. Products and Support &
Maintenance are sold from company Swiss-1 which acts as a principal company
whereas the professional service related sales are made in company Swiss-2.
The IP is owned by company Swiss-1.
Responsibilities
. Developed test scenarios for Financial and supply chain modules.
. Testing of modules during Integration testing.
. Written test cases for OM like Booking order, Shipping, Creating
Quote, Creating Transactions, Creating Invoices for the order and
closing the order.
. Coordinated with User community and create the testing plans
accordingly.
. Involved in all phases of end-to-end testing which includes pre-
testing, User Acceptance testing, Functionality testing, Regression
Testing, system testing, Integration Testing, Unit testing
. Wrote complex SQL queries and scripts extensively.
. Used SQL* Loader to load bulk data from flat files.
. Involved in creation of Test Design Documents, Test Data, Test
Scripts, Test Cases, Test Strategies, Test Log, Failures, Supporting
documentation.
. Validation of data as part of testing and reporting to Functional
team.
. Validate that any defects found are fixed prior to production install.
. Wrote various test scenario design documents by applying various
combinations on each business rule in the requirement documents.
. Trained technical and non-technical QA personnel in utilizing the
integrated testing environment, processes.
. Documented the testing process.
. Executed the test cases and tracked the defects using Quality Center.
. Involved in Offshore co-ordination team.
Client : Harvard Business Publishing, Watertown, MA
Period : April 2008 - Sep 2008
Environment : Oracle Apps 11i (OM, Inventory), Quality Center
9.0, QTP, Windows98/NT, UNIX, XML, Java, VBScript, Oracle, SQL, PL/SQL
Role: ERP Tester
The project is done to create a single view of the customers by generating
a unique customer id, which the legacy systems lacked. This involved
cleansing, consolidating and re-structuring of the data as part of the data
conversion and ongoing data integration processes.
Responsibilities
. Developed test scenarios for Financial and Supply chain modules.
. Coordinated with User community and create the testing plans
accordingly.
. Involved in all phases of end-to-end testing which includes Unit
Testing, Integration Testing, User Acceptance testing, Functionality
testing, Regression Testing, system testing.
. Developed Test Design Documents, Test Data, Test Cases, Test Scripts,
Test Strategies, Supporting documentation, Test Log, Test Failures.
. Validation of data as part of testing and reporting to Functional
team.
. Validate that any defects found are fixed prior to production install.
. Maintained Requirements Traceability Matrix in close coordination with
the business team using MS Excel sheet.
. Executed the database queries using SQL as a part of Data Validation.
. Experience in SQL* Loader for loading data from flat files into Oracle
tables.
. Documented the testing process.
. Updated the Scripts according to the enhancements of the application
and run the scripts in different environments to make sure the
application is stable.
. Executed the test cases and tracked the defects using Quality Center.
. Involved in Offshore co-ordination team.
Client : National City Mortgage Corporation, Ohio
Project Name : Conversion project
Period : Jan 2007 - Mar 2008
Environment : Windows XP, SUSE Linux, DB2, Java, J2EE, Quick Test Pro,
Mercury Quality Center, HTML, MS Office Suite
Role: QA Engineer
Future business model project was to provide testing services to this
client for the conversion of Mainframe based legacy system. The application
provides select information for customers to view via the internet
customers are also able to view policy, billing information. They are also
able to change basic information such as Phone Number, Address etc.
Responsibilities
. Involved in Development of Test Plans and Test Cases to test the Screens
and workflows for Quality Assurance
. Developed, executed and documented highly complex test plans and test
cases for Business-related application running on multi-tiered platforms
. Planned, coordinated, and monitored project levels of performance and
activities to ensure project completion before or On-Schedule
. Involved in both Manual and Automated testing
. Worked with team members to execute various functional and performance
test cases
. Analyzed the application and performed Black Box testing
. Configured testing environment including Site administration settings
with QA Lead for writing Test requirements, analysis, test reports,
defect tracking and reporting using Mercury Quality Center
. Participated in the test environment setup and in ensuring that the
facilities, test tools and scripts are in place to successfully perform
the required testing effort
. Performed automated testing of the application and reviewed Automated
Scripts using QTP developed by QA analyst
. Extensively involved in the Functionality and Regression testing of the
application
. Automated manually written test cases by using Quick Test Pro
. Set the shared Object repository in Quick Test Pro
. Developed baseline scripts and enhanced the scripts in Quick Test Pro
. Analyzed and developed technical reports while using MS-Word and MS-Excel
. Used actions, reusable actions and external actions to design the Quick
test professional scripts
. Database integrity testing by executing SQL statements
. Performed Regression testing using QTP
Client : Liberty Mutual, Indiana
Project Name : Funds project
Period : Oct 2005 - Dec 2006
Environment : Windows XP, Java, J2EE, Quick Test Pro, Mercury Quality
Center, HTML, MS Office Suite
Role: QA Engineer
Used for calculation of Daily, Monthly, Quarterly, Semi Annual and Annual
performance returns of Mutual funds and Variable Annuity products. Also
generates and distributes mutual funds business reports to various
destinations.
Responsibilities
. Developed Test Design Documents, Test plans, Test Data, Test Cases, Test
Scripts for the application.
. Planned, coordinated, and monitored project levels of performance and
activities to ensure project completion before or On-Schedule
. Involved in both Manual and Automated testing
. Identified the critical transactions for testing.
. Tested the data imported from different Business units from Legacy
systems.
. Participated in the test environment setup and in ensuring that the
facilities, test tools and scripts are in place to successfully perform
the required testing effort
. Written SQL Queries for backend validation.
. Extensively involved in the Functionality and Regression testing of the
application
. Automated manually written test cases by using Quick Test Pro.
. Trained users and prepared test documents for UAT Testing.
Client : Bearing Point, CA
Project Name : Kenan application
Period : Sep 2004 - Sep 2005
Environment : Java, Oracle, Windows XP, Java, J2EE, Visual Cafe, Mercury
Quality Center, HTML, MS Office Suite
Role: QA Engineer
Used for calculation of Daily, Monthly, Quarterly, Semi Annual and Annual
performance returns of Mutual funds and Variable Annuity products. Also
generates and distributes mutual funds business reports to various
destinations.
Responsibilities
. Involved in analyzing and designing manual test cases.
. As a team member I was involved in writing Test Design Documents, Test
plans, creating Test cases ensuring that the developed software
performs as detailed by the business requirements.
. Involved in manual testing.
. Involved in all phases of end-to-end testing which includes User
Acceptance testing, Functionality testing, Regression Testing, system
testing of the Application, its interfaces and Client-Server
Utilities.
. Involved in testing the application using multiple browsers (Cross
Browser Test).
. Developed SQL Queries to check the database Integrity.
. Tracked the defects found and send them to the Developer using Test
Director.
. To interface with development configuration and operation's team to
ensure the quality of software to user expectation.
. Created Virtual users and tested load on the Application using Load
Runner.
. Involved in performance testing and Stress Testing of the Application.
. Submitted status reports weekly.
Client : Cyber Competency Centre Framework, Hyderabad
Project Name : CCCF Application
Period : Mar 2002 - Aug 2004
Environment : Java, Oracle, Windows XP, Java, J2EE, Visual Cafe, Mercury
Quality Center, HTML, MS Office Suite
Role: QA Engineer
Cyber competency centre framework (CCCF) is a web-based integrated
information system that is used to plan, schedule and control the pre-sales
and post-sales activities in an organization. It 's a sort of CRM
application, which is intended for providing support and information to the
customers, Prospects, and Sales people for the various products developed
by an organization
Responsibilities
. Developed Test Design documents, Test Plans, Test cases, Test
scripts, Test Data, Test Log, Test Failures, documentation in Test
Director.
. Participated in Manual and Automation Testing.
. Created Test plan to test GUI, Security and Performance Testing
. Generated Test Cases for Functionality, system testing, integration
testing using win runner.
. Involved in checking hyperlinks of the application.
. Involved in execution of SQL Queries for data validation.
. Responsible in providing regular Test Reports to the management.
. To report the status of the software testing through an analysis of
reported defects.
. To interface with development configuration and operation's team to
ensure the quality of software to user expectation.
. Written defect and interacted with developers to help them in solving
the problems.
Client : General Star Systems, Hyderabad
Project Name : DMS Project
Period : Feb 2000 - Apr 2002
Environment : .Net, Oracle, Windows XP, Java, J2EE, Visual Cafe, Mercury
Quality Center, HTML, MS Office Suite
Role: QA Tester
Objective of the Regional Distributor Management System (DMS) project is to
develop and implement a uniform business application to manage distributor
operations in the areas of Purchase Order Planning, Sales Order Processing,
Accounts receivable and Inventory Management. This is fully a Web Oriented
Design and Development Life cycle. The same will be implemented in Phases
throughout East Asia Pacific. DMS will support distribution of Unilever's
HPC (Home and Personal Care) and Ice cream products to wholesalers and
retailers. The business areas covered will be Purchase order planning,
sales order processing, inventory, accounts receivable, cabinet control and
interface to external systems.
Responsibilities
. Developed Test Design documents, Test Plans, Test cases, Test
scripts, Test Data, Test Log, Test Failures, documentation in Test
Director.
. Participated in Manual and Automation Testing.
. Created Test plan to test GUI, Security and Performance Testing
. Generated Test Cases for Regression, Functionality, system testing,
End to End testing using win runner.
. Involved in checking hyperlinks of the application.
. Involved in execution of SQL Queries for data validation.
. Responsible in providing regular Test Reports to the management.
. To report the status of the software testing through an analysis of
reported defects.
. To interface with development configuration and operation's team to
ensure the quality of software to user expectation.
. Written defect and interacted with developers to help them in solving
the problems.
Client : Honda Music Systems, Thailand
Project Name : CSI Project
Period : Aug 1997 - Jan 2000
Environment : Oracle, Windows XP, UNIX, Visual Basic, Visual Studio,
Mercury Quality Center, HTML, MS Office Suite
Role: QA Tester
Application is done for migration of existing customer information from
mainframe system called 'CSI' into open systems to maintain Information and
allow Employees of all departments to access Information from anywhere in
the Network. This Information is pertaining to all Departments, which
includes Material Management and Library Information and Employees and
Resources of that Company. The Application is deployed on IIS, uses SQL
Server to store the data. Clients access the application using any Standard
Web Browser. User can search for any book of his interest in the Library
and he can search for particular item and material which existed or not,
but he needs to login before borrowing it.
Responsibilities
. Gathered information to be migrated from mainframe system over to the
new system and performed impact analysis.
. Extraction of selected mainframe customers information for every
migration phase.
. All the existing batch jobs and online transactions have been enhanced
to validate and bypass, if record has already migrated to the new
systems using JCL.
. Responsible in executing the Test Cases for various Testing stages
like Integration Testing, System Testing and Regression Testing.
. Performed Unit Testing and Integration Testing
. Created Test Data for System Testing.
. Involved in preparing the Test scenario's, Test cases for complete
application Testing
. Wrote Analyzed functional specifications and provided structured to
all phases of testing by setting test priorities
. Done debugging interface and checked SQL code line-by-line using TOAD
. Defined test procedures that incorporate multiple tests of the entire
system.
. Conducted Smoke, Security testing and Functional testing of the
application.
. Conducted regression and integration testing .
. Interacted with developers and other QA engineers to address quality
problem(s).
. Reported bugs using defect-tracking system.
. Involved in White Box Testing of the GUI application.
. Identified software errors and interacted with developers to resolve
technical issues.
. Prepared pre-conditioned data for testing the application.
. Responsible for weekly status updates showing progress of testing.
. Designed data for interpreting negative/positive results.
. Tested functional, GUI and performance requirements of the
application.
EDUCATION
. Bachelors in Science
Osmania University, Hyderabad, India