Management Test

Aruna Kandula

QA Analyst

469-***-**** aruna*kandula @gmail.com

US CITIZEN

SUMMARY:

* ***** ** ******* *********, Testing, Analysis and Development of Applications using Client Server Technologies and Web technologies

Very strong communication and judgment skills, team player, quick adaptability to the ever-changing technology and confidence are my strongest points.

Excellent knowledge and understanding of SDLC and Testing Methodologies.

Good Experience working in J2EE Environment and Microsoft Technologies.

Good knowledge in RDBMS concepts (Tables, Views, Stored Procedures, Triggers etc).

Experienced in SQL Server, SSRS and Oracle .

Expertise in designing and developing strategic Test Plans, Scripts, Scenarios, and generating Performance Reports and analysis.

Experienced in writing SQL queries for back-end testing.

Experienced in developing test plans for system testing using Quality Center.

Experienced in both Manual and Automated testing of web-based applications.

Experienced with running batch jobs on Mainframe and AS400 environments to test the batch reports and validate the backend process and interfaces to different applications.

Proficient in using Mercury/HP Quick Test Professional &Test Director for Quality Center.

Excellent experience in Defects Management.

Well versed in GUI, Database, Functional, Integration, System, and Regression Tests.

Extensively involved in Black-Box and Full Life Cycle Testing.

Extensively involved in tracking test coverage and Test Metrics document preparation.

Experience in Agile methodology.

Worked on Offshore (India) projects.

Well versed with all documentation process for testing related activity.

Worked closely with developers and other stake-holders of the team.

Experience of testing in Windows/UNIX environment.

Good knowledge of Web services with SOAP-UI, XML.

Excellent communication and interpersonal skills with problem solving abilities, effective in working independently and an exceptional team player.

Technical Skills

Testing Tools:

QTP, Test Director, and Mercury’s HP Quality Center, Clear Quest, Rally

Management Tools:

HP Performance Center, Test Director, Mercury Quality Center,

Operating Systems:

Windows NT 4.0/XP/2000/98/95, UNIX/LINUX

RDBMS:

MS SQL Server, MS Access, Oracle and DB2.

Web Technologies:

HTML, DHTML, XML, JSP, ASP, Servlets, JavaScript, and VBScript.

Test Scripting:

TSL, SQA Basic, VB Scripting

Application Servers:

Web Sphere, Application Server, and Web Logic

PROFESSIONAL EXPERIENCE:

AT&T, Dallas, TX July 2014 - Current

QA Test Specialist

Description: NISE (Network Inventory & Service Environment) platform offers AT&T an inventory management system that supports the Provisioning and Maintenance Processes. This system is used to design and develop a global architecture that accelerates the database of record of Network Inventory. This application provides an inventory of networks, circuits, cables, Offices, Terminals, switches and services. Provides a GUI for queries of the inventory and ability to issue orders to add, change, delete objects in the inventory while maintaining the integrity of the inventory.

Responsibilities:

Test the interfaces between NISE and other systems.

Create the inventory orders and make sure the database is correctly updated.

Write/ Execute test scripts for the IM (Inventory Management) module, OM (Order Management) module, DM (Design Management) module, EG (Equipment Generator), AM (automation Manager), RM (Request Manager).

Create/Execute test scripts for the XGUI – this is a work station based Client/Server front-end implemented in the HP-UX operating system using X-Motify.

Create/Execute test scripts for WEB GUI – Web tool designed to provide access to nearly all of the network information maintained in the Service.

Defect Management in both Clearquest and HP Application Lifecycle Management.

Coordinate with Offshore to for the test plan creation, execution of the test scripts and defect fixes.

Attend the project meetings and review the defects with the Project team.

Environment: UNIX, Clear quest, ALM QC, Putty, Oracle, MS Office, Windows, SQL, FTP.

Citigroup, Dallas, TX August 11– June14

QA Analyst

Project: Loan Path

Description: Loan Path is a collaborative business-to-business lease and credit management plat-form. It integrates all the tasks required from “bid-to-booking” of a lease/loan, and makes them available on one common interface. Using Loan Path you can set up and manage lease/loan entities such as Programs, Partners, Credit Applications, Contracts, Policies, and Reports.

Loan Path integrates with most standard external interfaces to price, credit-score, and manage

data for front office operations in a leasing/loan environment.

Responsibilities:

Involved in the regression testing of the Loan Path application.

Conditioned and prepared regression test data to meet the testing requirements in SIT and UAT.

Keyed the data to create Business Loan applications in the test environments. Data was keyed in to test several queuing functionalities (Pending, Approved, Decline etc) .

Validated the application statuses per the Business Requirements.

Validated the Loan Path application to ensure that the system is correctly generating the loan related documents (Loan Application, Terms and Conditions, Letters etc) with the correct names, addresses, interest, late fees etc.

Created system documentation for the new testers.

Conducted Functional/Base Case, Integration, System, back-end, Re-test, Performance, End to End, Regression, Security and User-Acceptance (UAT) testing manually.

Ran batch jobs in Mainframe using JCL to validate letter generation process and periodic reports.

Worked with Offshore team to coordinate the assignment of the test defects.

Used Quality Center 10.0 for Defect Management.

Prepared Test plan & Test cases based on the business requirements.

Performed manual testing for all different kinds of test cases.

Environment: ALM Quality Center, J2EE, TSO/ISPF, Telnet, Oracle, DB2, SQL, Internet Explorer

Bank Of America, DALLAS, TX April 2011- August 2011

QA Analyst

Description (Mortgage): The Fee Management system requires too many manual processes and is the thereby not sustainable in the long term. As such, end-to-end business processes will be clearly defined and understood to enable the global deployment of standard technologies. Audit trial details will be included to provide traceability and enable clear adherence to compliance requirements.

Responsibilities:

I have worked on three different modules for this project. Loan Document Review (LDR), Notice of Sale (NOS), JRules and Segmentation.

LDR and NOS are upstream systems from which data is passed to the Fee Due System. I have created test data for these two feeds in .csv format. The data was prepared for both positive and negative test cases. I have FTPed the data from the local desktop the MST CSI folders using WinSCP tool. From here the data was picked up by the MQ. Once processed, I have logged on to the Iseries (AS400) tables and verified the data. Prepared Test Plans and Test Cases and executed Test Scripts.

JRules is an automated rule processing system that processes the outstanding fees in the Fee Due system using a pre defined set of rules. There are hundreds of rules in this system that had to be tested. I have tested about 50 rules in this system. The main component of this testing is to condition the existing data to meet the rule.

Segmentation is the process by which some of the outstanding fees are calculated within ISeries itself instead of going to JRules engine. I have tested one segment which involved writing test scripts for more than 30 scenarios. I have conditioned the existing test data to find the correct first loans and HELOC loans that fall into the different categories/segments for different FEE rules to calculate the Fees incurred on the loans .

Executed the tests and verified the data in the Iseries database tables.

Extensively used EQ tool (java based tool to access data on ISeries) to write SQL queries to condition data and also verify the data after executing the tests.

Used Quality Center for test plan and test lab. Manually ran the tests in test lab and documented the expected and actual results for each script. Attached screen shots to the defects wherever applicable.

Created defects in QC and participated in weekly defect calls with the project team.

Conducted Functional/Base Case, Integration, System, back-end, Re-test, Performance, End to End, Regression, Security and User-Acceptance (UAT) testing manually.

Prepared test data for the UAT as per the specifications of BRD.

Retested the defects and documented the results in QC

Environment: ISeries (AS400), DB2, MQ Series, WinSCP, Quality Center, EQ, SQL

State of Michigan, Lansing, Michigan July 2010 – March 2011

QA Analyst / Tester

Description : The Statewide Automated Child Welfare Information System (SACWIS) is a comprehensive automated case management tool that supports social workers' Foster Care, Child Protective Services, and Adoption/Medical Subsidy. Intake refers to the process performed by an agency to record and prioritize the receipt of reports and referrals to the agency.

Responsibilities:

Participated in different phases of Software Development Life Cycle (SDLC)

Participated in different testing methods (functional, regression, system, integration, performance, stress) based on the business requirements for an appropriate testing approach.

Requirement management with Rational Requisite Pro.

Prepared test scenario and review with Business Users according to Business requirement and use cases to cover business scenarios.

Used Rational Quality manager to write the test plans, test cases, analyzed the results.

Implemented defect tracking using Rational Clear Quest.

Create, debug and run the test scripts/procedures in Rational Robot.

Validate data lodes in Pre-prod/UAT environment before deployment to Users

Co-ordinate with the team to ensure and track total quality deliverables to satisfy business need.

Performed extensive Backend Testing by developing, modifying, and executing SQL queries for data validation and data verification on database.

Created Traceability Matrix for Requirements vs. Test Case Matrix

Participated in walk through meeting and created meeting minutes.

Environment: Oracle, Cobol, JAVA, Web Logic, Java Scripts, Site Scope,, Internet Explorer, Netscape, Quality Center, Perl, QTP, Agile methodology, Unix, SOAP, WSDL, Web Sphere, Shell, SQL, Windows XP, JCL.

SBC Communications, CT Nov 2009 – June 2010

QA Analyst

Description: SBC Communications is the largest provider of Phone line, Wireless and Internet services. SBC provides Dial and DSL internet services with Yahoo (SBC Yahoo!), implementing Micro Transaction Billing (MTB) to create its own branded payment network among online merchants.

Responsibilities:

Involved in both the Manual and Automated testing of the application

Prepared Test Plans and Test Cases and executed Test Scripts

Using Win Runner, conducted Regression Testing followed by the System Testing and Negative testing

Plan tests with Test Director (Design Steps and Run Tests)

Worked extensively with Test Director for defect reporting and tracking

Verify the status of submitted bugs, and participate in bug review/prioritization activities.

Conducted Functional/Base Case, Integration, System, back-end, Re-test, Performance, and End to End, Regression, Security and User-Acceptance (UAT) testing manually.

Prepared test data for the UAT as per the specifications of BRD.

Used SQL and tested the population of data in Oracle database.

Validated test results and document software problems

Involved in cross browser testing using Safari, Netscape and Internet Explorer

Involved in the testing performance of applications using multiple Browsers, connecting the application at different speeds.

Environment: Java 1.4, J2EE, Web Sphere 5.0.1, Oracle, QTP, UNIX, SQL Server, Crystal Reports, XML, HTTP, Test Director,Winrunner

Kaiser Permanante, Silver Spring, MD Jan 2009 – Nov 2009 QA Analyst

Description: Kaiser has affordable plans within their coverage areas and is worth considering. Worked on 2 different modules Health Connect-Medicare Modernization Act, MMA functional requirements impact two of MAS's operational areas, Health Plan Administration (HPA) and Pharmacy. KMATE's The Membership System (TMS) and Pharmacy Information Management System (PIMS) support these two operational areas and both systems will undergo significant enhancements to accommodate MMA. Moreover, interfaces within these two systems are impacted. These interfaces interact with other MAS applications, as well as third party applications. Medicare Modernization Act-Coordination of Benefits. The Medicare Modernization Act (MMA) Part D specifies the requirement for Kaiser to gather information about their membership's Other Insurance Coverage (OIC) and use it to reduce member liability wherever possible.

Responsibilities:

Worked on different Modules like Eligibility and Enrollment, Dues Calculation, Billing and Payments, Various Claim Submission includes Part D, Non-Part D, Mail Order, KP Online, VRU, COB, Rx OIC and Billing the Claims

Involved in preparing Test plan and wrote Test cases Using Test Director

Test Cases are written for scheduling and execution of tests, collection of test results and analyzing the data and prepare required test data to execute test cases and test execution on Scrum Servers in the Integrated Testing Environment

Performed negative and positive testing for the application

Developed Test scripts using Win Runner for Functional test and Regression test and modified the existing Test scripts to meet requirements

Written test scenarios and detailed test cases

Performed GUI, Functionality, Security, Positive and Negative testing

Involved in testing Facets / Membership and Claims applications.

Responsible for testing entire claims processing workflows as per business requirements .

Performed database testing by passing SQL queries to retrieve data

Participated in meetings to discuss Defects and like scenarios

Provide management with daily status reports Using Rational Clear Quest, which involves extensive web testing

Played major role in System testing, Workflow Integration testing (WIT), regression testing and involved in User Acceptance testing (UAT) Sessions

Environment: Test director, Win Runner, Java, J2EE, Java Script, SQL, UNIX, XML, Oracle,, Manual Testing, Winrunner, SOA, SOAP, Clear Quest, Visual Basic, SQL HTML, Windows NT

References:

References will be provided on request.

Contact this candidate