vijay kumar bandaru's Page

First Name:

vijay kumar

Last Name:

bandaru

I am currently:

Looking for a Job

Designation:

Quality Analyst

About Me:

Vijay Kumar Bandaru
E mail:bvkmr1@yahoo.com
Home: 770 919 8662
Cell : 770 862 0761
SUMMARY
Having 9 years of Quality Assurance experience and UAT that covered the requirements such as Gap analysis, testing process and procedures to maintain the Quality of the code which was delivered in the given project time line. Well expertise in design and execution of testing includes estimating the time for each task and leading the team for the completion of the QA process. Monitored and performed user acceptance testing.

HIGHLIGHTS
• Over 9 years of experience in Software Quality Assurance, in client server and web based applications.
• Worked as Test Lead .Expertise in maintaining the Quality of the Software delivered and delivering the code with in the Project time lines.
• Managed testing teams and handled multiple projects at the same time by maintaining well defined Project planning.
• Monitor and performed User Acceptance Testing on web-based applications with database validation.
• Managed and resolved test bugs by gathering critical information needed for problem classification, and retest within appropriate guidelines.
• Testing Expertise included requirement analysis, creating effective test plans, test scenarios and, test scripts.
• Testing expertise includes both Black Box testing and White Box testing.
• Prepared time and budget estimates for testing afford
• Expertise in Generating Test Matrices, Defect Tracing Matrices, Test Execution Matrices
• Well experienced in developing reusable automated test scenarios and executing Regression testing for cost effectiveness and time saving.
• Participated in all aspects of testing including functional, regression, system testing, Compatibility testing, Sanity testing ,Load testing, Stress testing and Performance testing,
• Having knowledge on Security testing, FIX protocols etc.,
• Well experienced in maintaining Defect tracking tool and test matrices. Maintained Test Director/Quality Center as repository for Test planning, Test Scripts, Defect Tracking and Generating reports.
• Also well experienced in verifying Data Integrity, Data Consistency and Validation Testing.
• Tested Data in XML files, NDM files, System generated Data extract files to down stream applications.
• Familiar with Rational Unified Process and 21 CFR part11 regulations.
• Experienced in Stress, Load and Performance testing.
• Extensive knowledge on UNIX, Batch Processing and SQL.
• Having good knowledge on Object Oriented Concepts
• Production support 24/7.



SKILL SET

Testing Skills : Win Runner with Java Add-in, QTP, Load Runner,
Quality Centre, Rational Clear Quest,SQA Robot, jtest, Data, XML Spy.
Language : Java, C#, TSL, SQL, PL/SQL,
Operating Systems : Windows , XP, UNIX, MS-DOS, VMS
Databases : Oracle 10I, SQL Server, DB2, Sybase, Access, FoxPro, dBase, Database
Administration, Informatica
GUI Tools : NET Framework, ASP.NET, Developer 2000, Visual Basic 5.0/6.0,
E-Commerce : D/HTML, Java Scripts, VBScript, BEA Web Logic, Web-Sphere,J2EE
Messaging, EJBs .SOA Architecture.
Configuration Tools : Clear case, Star Team, Continuous CM, Visual Source Café












WORK EXPERIENCE

AT&T Dec 2009 to tilldate
Business Analysis/Mgmt/UAT

Quota Execution for Sales Teams (Biz Comp 2009).Sales Compensation are for the sales employees and distributors. Sales Compensation will provide standardized data that feeds to downstream applications. The project tool that was developed will be available to sales management, sales management delegates, and sales compensation operations on the readiness calendar. This application has capability to generate various reports at various stages of application process.

• Formulated documents and executed test to verify accuracy of reported fixes, product enhancements and new products. These documents involve test planning and test cases/functional script creation
• Reviewed and analyzed validity of test output and functional script results to ensure tests are completed as expected
• Established, coordinated and controlled timely test activities for all implementations
• Monitor and performed User Acceptance Testing on web-based applications with database validation
• Managed and resolved test bugs by gathering critical information needed for problem classification, and retest within appropriate guidelines
• Utilized existing test process and procedures while recommending potential improvements as lessons learned or future improvements such as test automation
• Communicated effectively, created strong relationships, and worked closely with team and other management

Environments:- MS SQL server, Web Services, Rational Clear Quest. XML, Web Sphere, PL SQL , Oracle 8i/9i.TOAD,UNIX,Soap tool.



Hewlett Packard
QA Lead June 2007 to Nov 2009.

Quota Execution for Sales Teams (QuEST) capture sales employee information, assignment details and quota deployment decisions from sales managers. Sales letters will be generated and delivered through notification process . It will also provide standardized data feeds to downstream applications. The tool will be available to sales management, sales management delegates, Sales Compensation Operations, and Finance based on the Readiness calendar. This application has capability to generate various reports at various stages of application process.

• Involved in analysis of Requirements and creation of Test Strategy , Test process , Test Plan .
• Testing schedules and resources allocation has done as per the project plan.
• Managed Testing group in developing test cases/plans and coordinating testing efforts with the development/configuration team. Communicating with Management to provide status and alert any critical bugs or showstoppers
• Created test scripts, test scenarios and maintained Test Scripts in Quality Center.
• Inbound batch process testing is performed .
• Test data prepared in the xml , csv and xl as per the inbound data feed.
• Performed load/stress/performance testing using Load Runner.
• Created Minimal Acceptance Scripts to run tests overnight to verify the builds, Release products.
• Involved in conducting regression/progression testing by using automated scripts.
• Tested data Consistency, data integration, and data validation.
• Used and maintained Quality Center as repository to store all the Test Plans/Scripts/Results.
• Involved in CRM process and Configuration Management process.
• Maintenance of Test Artifacts and Test execution reports

Environments:- MS SQL server, MS .NET Framework, IIS, Oracle , Putty,
Web Services, Quality Center, Load runner, Win Runner ,QTP, Toad . Hewlett Packard



Cox, Atlanta, GA Jun 2006 to May 2007
Project: Power Search 2
Quality Analyst
The mission of this project is to enhance the current Manheim.com website by creating a new portal website utilizing current UI standards and existing technologies. This new portal can be used as a prototype and standard for existing websites under Manheim umbrella. The goal is to surface simplicity and usability of Power Search so that the vehicle search experience remains Positive and friendly to users.

Project: Manheim Point

Manheim provides a variety of valuable services including reconditioning, wholesale inspections and certifications, and the Manheim Market Report, the industry’s most accurate and up-to-date pricing guide. Manheim Point is an inventory Optimization tool. Manheim point provides up to the moment, transaction-based market data so that dealers can make more-informed buying and selling decisions, Control, Optimize and streamline the inventory on a daily basis and quickly implement decisions to buy and sell through the world’s largest auction vehicle marketplace

Responsibilities:

• Analyzing Business Requirement and Software Requirements Specifications.
 Prepared time and budget estimates for testing of this application.
 Managed testing group in developing and executing test cases/plans and coordinating testing efforts with the development/configuration team. Communicating with Management to provide status and alert any critical bugs or showstoppers.
 Performed both Black Box testing White Box testing.
 Perform stress/load testing to monitor Process Performance and stability of application using Load Runner.
 Performed Stress test ,load test by creating VU users and systems capacity
 Responsible for creating Test Plans, test scenarios and test scripts. Documenting testing results, tracking bugs, executing System test, Integration testing, Functional testing.
 Performed data driven test and Data consistency and Data integrity.
 Perform Manual testing, regression testing using Automation tools like Win Runner.
 Test Automation included Data driven test scripts, Effective use of test scripts against different environments, Test scripts executions included navigating through different Users work list etc.
 Verified critical Data in System generated Data extract files for down stream Applications.
 Participated in Code review for Optimum Performance.
 Maintained Quality Center as repository for Test planning, Test Scripts, Defect Tracking tool and generating reports.
 Verifying the Data before sending it to Fedimax and Fenime through FIX protocols.
 All Services XML requests and Responses Schema verification, Data mapping, Verifying Service Archestration, Alternative flows for each service.
 Expertise in applications running on UNIX, Solaris and able to write and execute basic UNIX commands and scripts.
 Executing Batch Processing and Verifying expected outcome after batch processing.

Environment: JDK 1.4,Java Applets, BEA Web Logic Server 8.0, Struts Frame Work (1.0.2), EJB 1.1,Java Messaging ,XML Spy, Main Frames,, Apache Ant 1.5, SQA ROBOT ,Quality Centre ,QTP,Win Runner, Load Runner, UNIX

Equifax Inc, Alpharetta, GA Mar 2006 to May 2006
QA Lead
Secure mark is an interface to deliver digital certificates to customers. The interface communicates between two different verifying and certifying systems based in United Kingdom. Secure mark integrates fraud checks, digital requests, customer validation, customer’s trade-lines, and interactive corroboration. The system uses SOAP and XML for data transfer within the system
Responsibilities:
• Analyzing and writing test plan in accordance with business requirements
• Created Test plan and Test Design
• Implementation of Test cases as Manual and automated test scripts
• Identified Regression test scenarios and Automated these test scenarios with QTP.
• Formulate methods to perform Positive and Negative testing a gains requirements.
• Performed Manual Testing of the application Front-end and Functionality. Identified the critical test scripts to be automated
• Develop test cases and Automation test scripts based on business/functional specifications using SOAPUI
• (a soap tool)
• Perform Functional, Data Validation, Integration, System, and Regression testing using Win Runner.
• Used Mercury Test Director to report defects and test results.
• Writing SQL Queries to extract data from Oracle 9i database using TOAD client

Environment: Win Runner 7.01, Test Director 7.0, Load Runner 7.6, QuickTest Professional 6.0/8.0, Internet Explorer 6.0 and Netscape Navigator 4.5 (front-end browsers), HTML, XML, Web Sphere, MS SQL 2000, Oracle 8i/9i.TOAD,UNIX,Soap tool.

Verizon Wholesale Systems, Irving, TX Mar 2005 – Feb 2006
QA Lead.

OASR (outbound Automated Service Requests):- OASR project is to mechanize the process of generating and sending ASRs to Local exchange providers, (CLECs, ISPs, and Cellular providers) to establish interconnecting trunks. OBASR users include both external and internal users. Users will submit notifications forms requests for additional truncking or facility capacities.

The request will trigger the generation of ASRs to be sent to Verizon to CLEC/Providers via NDM and Fax interfaces.
 Analyzing Business Requirements and Software Requirements Specifications.
 Prepared time and budget estimates for testing. Of this application.
 Managed Testing group in developing and executing test cases/plans and coordinating testing efforts with the development/configuration team. Communicating with Management to provide status and alert any critical bugs or showstoppers.
 Performed both Black Box testing White Box testing.
 Perform stress/load testing to monitor Process Performance and stability of application using Load Runner.
 Implemented CMM Practices for the application Development and maintenance.
 Performed Stress test ,load test by creating VU users and systems capacity for XML and NDM field generation.
 Responsible for creating Test Plans, test scenarios and test scripts. Documenting testing results, tracking bugs, executing System test, Integration testing, Functional testing.
 Performed data driven test and Data consistency and Data integrity.
 Perform Manual testing, regression testing using Automation tools like Win Runner.
 Test Automation included Data driven test scripts, Effective use of test scripts against different environments, Test scripts executions included navigating through different Users work list etc.
 Verified critical Data in System generated Data extract files for down stream Applications.
 Participated in Code review for Optimum Performance.
 Maintained Test Director as repository for Test planning, Test Scripts, Defect Tracking tool and Generating reports.
Environments:-This application is built on a Windows platform using MS SQL server, MS .NET Framework, IIS, MSMQ, IBM MQ, NDM and FTP.


USAA, San Antonio, TX July 2004 to Feb 2005
QA Analyst

Complete implementation of MasterCard’s Debit processing solution for USAA Federal Savings Bank. This solution combines the strength and experiences of two the dominant players in the EFT market - MasterCard and EFunds. MasterCard deliver excellent customer focused solutions including globally recognized brand/advertising. EFunds provide much of the behind the scenes state of the art EFT technology needed for a successful solution.

Responsibilities:
• Analyzed and Developed test plan in accordance with business requirements.
• Manual/Automated Test Design, Plan and Implementation
• Formulated methods to perform positive and negative testing against requirements
• Performed Manual Testing of application Front-end functionality
• Identified the critical test scripts to be automated
• Develop test cases and Automation test scripts using Win Runner - TSL
• Conducted performance, and stress testing using Load Runner.
• Enhancements of Functional, Regression tests using QTP
• Used Mercury Test Director to report defects and test results.
• Writing SQL Queries to extract data from SQL 2000 RDBMS to validate backend data
• Work closely with users and program developers to ensure application development meets to user’s expectations.
• Worked with BA’s to ensure feasibility of functionality changes
• Developed Test Plan and Test scenarios using UML and sequence diagrams

Environment: Win Runner 7.01, Test Director 7.0, Load Runner 7.6, QuickTest Professional 6.0/8.0, Internet Explorer 6.0 and Netscape Navigator 4.5 (front-end browsers), HTML, XML, Web Sphere, MS SQL 2000, Oracle 8i/9i.

United Health Group, NJ Nov 2003 to June 2004
TEST AUTOMATION ENGINEER

United Health Group is an innovative leader in the health and well-being industry serving close to 70 Million Americans and it is a national leader in offering comprehensive health management services through organized health systems and insurance products. The company also offers specialized health- care management services and products such as behavioral health services, workers compensation and disability services, utilization review services, specialized provider networks, employee assistance programs and knowledge and information services.
This program is the governance structure for the transformation project required to upgrade the claims processing system. Each project within this program is a component of a software solution factory setting that is focused on producing consistent delivery methodology that uses defined value levers measured through a set of targeted metrics.

Responsibilities:
• Analyze the business requirements and involve in the review discussions.
• Participating in high level design sessions.
• Participating in the QA activities for various releases in the Project.
• Responsible for doing Black Box and integration testing.
• Drafted test cases based on Functional Specifications and System Specifications.
• Preparation of Test Plan and analyze integration system impacts.
• Involved in Manual Testing of the application for negative and positive scenarios.
• Identified Regression test scenarios and Automated these test scenarios with QTP.
• Mentoring the team members with business functionality.
• Performed the Regression Testing to make sure that the bug has been fixed and the application is running properly.
• Executing, analyzing, and verifying test results and worked with developers to resolve issues.
• SQLs are written using QMF to query the DB2 database on mainframe environment.
• Communicate project business issues to appropriate business leadership groups and lead resolution or escalation of issues as necessary.
• Wrote SQL Statements to extract Data from Tables to verify the output Data of the reports.
• Coordinating with the programmers to find the application flow.
• Debugging the application in Xpediter/TSO and made changes to the values according to Test Cases such as Test condition and Expected results
• Preparing Requirement Traceability Matrix (RTM) to establish traceability between requirements and test cases.
• Modified and maintained test cases due to changes in the requirements.
• Detected, reported and classified bugs.
• Used Test Director for managing test execution and defect tracking of all issues.
• Conducting internal and external reviews as well as formal walkthroughs, and participated in status meetings.
• Assisting the QA Manager with Project Planning/Scheduling using MS Project.
• Following the Capability Maturity Model (CMM) throughout the testing process.
Environment: Manual Testing (90%),.Net, Mainframe, TSO, ISPF, JCL, DB2, VSAM, QTP 8.2, Test Director 8.2, Quality Center,




Morgan Stanley Dean Witter Online, San Francisco, CA May 2001 to Oct 2003
QA Tester

MSDW Online is an online trading company, part of Morgan Stanley Dean Witter family, dealing with Stocks, Mutual funds, and Bonds etc. Registered Clients can trade stocks online, get real-time quotes, stock charts, view their account balance, etc. It also provides up-to-date news, research tools, Money Market Services, Tax Center. The international projects like IPCG Spain; IPCG London Projects are also in progress

Responsibilities:
• Analysis of requirement specifications for migration project and international projects.
• Developed Test Scenarios, Test scripts, analyzed data criteria selection, data mining, and data summarization.
• Executed several testing categories such as smoke test, integration testing, system testing, functionality testing, end to end testing manually and also using silk test, E test.
• Involved in performance and load testing using silk performer and E-load.
• Reported problem areas and tracked software and business procedural incident bugs and managed their resolution using Clear Quest.
• Conducted regression testing by developing test scripts in silk test.
• Fail over testing for dual site functionality.

Environment: Java, EJB, Web logic server, JSP, DB2, Sun Solaris, Silk test, Silk performer,
E tester, E load, J test, Clear case, Clear Quest.

State Bank of Hyderabad, INDIA Jan 1998 to Apr2001
Software Programmer /Quality Analyst
Involved in Testing of customer personal information system, used at customer service desk. This system kept track information such as when an Account was opened, how many types of account a person had and whether he/she had a Savings Bank Account, Checking Account and Term Deposit. The system also maintained the customer’s Deposits, withdrawal. This system also tracks information of the Deposit Account and to provide advance Eligibility credit era for future loans, Business account and requirement eligibility and its potentiality etc.
And also Performance & Statistic’s of Bank Branches and Head Office Currency chest Daily deposit and withdrawal in the client /server Platforms to reports Generation and its requirement.

Responsibilities:
• Involved in analysis of Requirements and creating Test Plans from the Requirements.
• Created many test scripts, test scenarios from test plans using Win Runner’s TSL Script.
• Developed automation testing using Win Runner for several testing scenarios, Modifying Orders, Verification of Telephone Numbers, etc
• Performed load/stress/performance testing using Load Runner.
• Created Minimal Acceptance Scripts to run tests overnight to verify the builds, Release products.
• Involved in conducting regression/progression testing by using automated scripts.
• Tested data Consistency, data integration, and data validation.
• Used Test-Director repository to store all the Test Plans/Scripts/Results.
• Expertise in applications running on UNIX, Solaris and able to write and execute basic UNIX commands and scripts.

Environment: Win Runner, Test Director, Cobol, JAVA, JSP 2.0, EJB, J2EE, JDBC, Servlets, ANT, JavaScript, VB Script, Oracle, Windows, UNIX .

EDUCATION

• Master’s In Business Administration
• B. com
• Oracle 8.0 with Developer/2000, Forms 4.5 & Report 2.5, C and C++.
• Cobol Programming, dBase III + and Lotus 1-2-3
• Auto coder Computer Programming for IBM 1401-1410-1460