QA analyst

VIJAY RAVOORI

Ph#:770-***-****(H), 678-***-****(cell)

*********@*****.***

Green Card holder

SUMMARY:

• Information Technology Professional with over Seven years of experience in Software systems analysis, development and Quality assurance especially in client/server and web based applications using Load Runner and Quality Center.

• Specialized in manual testing for various eCommerce, Telecom, Internet, Banking, Lottery Gaming applications.

• Experienced in developing Test plans, Test cases, Test case design, Test Reports for the specific business requirements and documentation of both Manual and automated tests.

• Expertise in testing GUI Objects, Functionality and System testing including Integration, Performance, Stress, Load, Backend and Regression Testing of Client/Server and web based applications

• Strong ability to understand Business and user Requirement.

• Extensively worked on database testing (Oracle, SQL Server, Essbase) and validating the application against the database

• Strong aptitude towards learning new technologies with a high degree of motivation.

• Good experience in defect tracking and reporting using Test Director/Quality Center.

• Experience in Load and Performance testing using Load Runner.

• Involved in backend testing (Data Validation Testing) by writing SQL queries.

• Executing, Maintaining Test Scripts and Updating as and when the business rules change.

• Superior work ethic with excellent communication and interpersonal skills

• Excellent Customer relationship management.

• Experienced in building test bed.

• Experienced in attending reviews and/or meetings.

• Good experience in performing User Acceptance Testing (UAT)

PROFESSIONAL EXPERIENCE:

Scientific Games Corporation (SGI). April ‘07 - Present

AEGIS System (Instant/Online Gaming applications)

QA Analyst

Description: Scientific Games Corporation (SGI) is a global marketing and technology leader and provider of comprehensive, end-to-end gaming solutions to the lottery and pari-mutuel racing industries. SGI is the leading integrated supplier of instant tickets, systems and services to lotteries worldwide, a leading supplier of server based gaming machines and systems, Amusement and Skill with Prize betting terminals, interactive sports betting terminals and systems, and wagering systems and services to pari-mutuel operators. Worked in the online lottery group’s software division. Primary function was to test SGI’s core Lottery software product (AEGIS) Advanced Entertainment Gaming & Information Systems. AEGIS encompasses all hardware and software from lottery terminals at the retailer’s sites, through the communications network to the central site. AEGIS consists of several components i.e. Lottery Terminals (Extrema), Transaction Engine (TXE) - "host system", Game Management System (GMS) - "web interface to the host system", Relational Database (RDB), Domain Controller (DC) and Communication Front End (CFE). SGI provides this software to various states in United States and countries around the world.

Online Raffle Game: The Raffle Game is designed to be turned on/off, throughout the year. The information for each Raffle draw will be entered into the system by SG Operations using a TXE script. Each Raffle draw will have a draw number associated with it. The sale date, draw close date and time of each Raffle Draw will be set, as determined by PREL, at the time the draw is created. Time interval between the on sale date and draw date will be a maximum of 90 days. There will be a minimum time of one (1) day between the end of one Raffle draw and the start of a new Raffle draw. The terminal icon will be automatically grayed out (disabled) on the screen the day after the end date for the Raffle draw. The icon will re-enable on the start date for subsequent Raffle draws. If the Raffle draw sells out in the middle of a day, any future Raffle ticket requests for that day will receive the following pop-up message and a Raffle ticket will not be produced. The cost of a Raffle ticket may vary from draw to draw, but each ticket for a Raffle specific draw will cost the same amount. The cost of a Raffle ticket and close time will be set, as determined by PREL, at the time the draw is created and will not be able to be changed after this moment. The cost of a raffle ticket can be set from $1.00 to $50.00 in even dollar amounts. First Raffle ticket price $10.00.

Each ticket will contain a single 8-digit number. Raffle numbers will be sold sequentially by the central system. However, a player who requests multiple tickets may not get an unbroken sequence of numbers. The starting (lowest) raffle number and number of tickets to be sold for a draw will be set, as determined by PREL at the time the draw is created. The central system will sell tickets sequentially from the starting number until the number issued is reached and sold. Raffle numbers less than the lowest Raffle number will not be sold. The highest Raffle number issued limit is 99,999,999. When the highest Raffle number issued for a draw is reached, the draw is sold out. Once the draw is sold out, a message will be sent to the TXE’s general log once. No duplicate raffle number will be issued for a specific raffle draw. A retailer may request from one up to a maximum of ten Raffle tickets at one time. All ten may not print if the pool has sold out. No number selection will be allowed. The next available sequential Raffle number will be selected by the central system. Raffle will not be considered a Quick Pick game for reporting purposes. Last Transaction re-printing is not allowed for Raffle or any other game in Puerto Rico.

The number of prize levels to be awarded for each Raffle will be set, as determined by PREL, at the time the draw is created and can not be changed after this. There will be up to 10 prize levels associated with a Raffle draw. Free tickets and merchandise prizes will not be allowed for any prize tier. All prize tiers must be a cash prize value only. All Raffle prize levels will be configured as fixed prizes. The central system will allow the entry of fixed prize amounts without regard to the percentage of sales. It will be the responsibility of PREL to calculate and set the prize amounts. Raffle tickets can be validated at any Extrema® terminal and will be subject to existing payout limitations for regular-selling retailers. It will be possible to pay winning tickets from all previous un-expired Raffle drawings, following the prize structures defined for that specific Raffle drawing.

Also tested the following other major releases - Draw Additions for Pega Games Player Activated Terminal (PAT), Matrix Change for Lotto Game / Multiplier Add-On for Lotto Game, Pega Games Approximation Promo a New Promotion Game for the Electronic Lottery, Scitrak Ultra Conversion

Responsibilities:

• Interacted with developers and users to analyze business requirements and functional specifications of the project.

• Involved in all aspects of the software development life cycle.

• Performed Regression testing, Functional testing, User Acceptance testing and Integration testing.

• Involved in backend testing (Data Validation Testing) by writing SQL queries.

• Executed test cases manually and verified actual results against expected results.

• Involved in Test case design and writing Test cases.

• Involved in preparing Test Data.

• Involved in root cause analysis of defects.

• Involved in running Day End process on TXE to close draws.

• Detected, Reported and Tracked bugs using Clear Quest/ Quality Center.

• Involved in balancing all related GMS/TXE and Terminal reports.

• Actively participated in team meetings to discuss the progress of testing.

• Involved in balancing TXE reports with Database tables.

• Performed user acceptance testing.

Environment: Manual Testing, dot net, C#, ASP, IIS 5.0, Visual Basic 6.0, HTML, Crystal Reports, Oracle, SQL Server, SQL Navigator, Quality Center, Windows XP, UNIX, Clear Quest , Linux.

Bank of America. Feb’06 – Mar’07

ATM Deposit Image – Generation 3.

QA Analyst

Description: Bank of America is one of the world's largest financial institutions, serving individual consumers, small and middle market businesses and large corporations with a full range of banking, investing, asset management and other financial and risk-management products and services. The existing project, ATM Deposit Image end to end 5.06 was broken down into ATM Deposit Image Gen2 and Gen3. Gen2 was completed vendor (NCR) related updates. Gen3 release of ATM Deposit Image will be built on Gen2 platform. As the Gen2 release/platform for Deposit Image is built on previous release of Aptra, the functionality for the previous releases and how they integrate with Gen2 and Gen3 are included in this project. This project has the following additional functionality: Cash back for check deposit, new features in all languages, cash deposit (no envelops), voice guidance support for blind people etc.

Responsibilities:

• Analyzed and reviewed the Requirements and Design documents and understood the system implementation.

• Involved in all aspects of the software development life cycle.

• Prepared Test Cases and developed Test Matrix for various scenarios.

• Executed test cases manually and verified actual results against expected results.

• Involved in Test case design.

• Performed Smoke testing and adhoc testing of the applications.

• Performed Stress Testing.

• Performed Regression testing, Functional testing and User Acceptance testing.

• Executed scripts to load the source files into the system using UNIX.

• Validated the data in the system & the source files using SQL queries.

• Attended daily status meetings, go no-go meetings.

• Created status reports.

• Identified defects and logged defect using Test Director/Quality Center.

• Attended defect meetings and tested production defects.

Environment: Manual Testing, Base24, Win6530, Quality Center, Java, Java script, web sphere, WebServices/Webmethods, XML, XSL, ESSBASE 7.1.3/6.5.3,web logic, HTML Oracle, SQL Server, DB2, SQL Navigator, TOAD, Windows XP, UNIX.

FI Transparency.

QA Analyst

MBNA America (a large credit card company) has merged with Bank of America during January 2006. FI Transparency is one the major projects in the process of merger. The scope of this project is to enhance the level of transparency for financial institutions customers will have when in contact with Bank of America Card Services, so wherever possible the customer will not know, they are being serviced by Bank of America. Put controls (T) in place so that data regarding Financial Institution customer accounts is not used to market other Bank of America products.

Responsibilities:

• Interacted with developers and users to analyze business requirements and functional specifications of the project.

• Performed Regression testing, Functional testing, User Acceptance testing and Integration testing.

• Involved in backend testing (Data Validation Testing) by writing SQL queries.

• Performed manual testing.

• Involved in writing Test cases.

• Involved in preparing Test Data.

• Involved in root cause analysis of defects.

• Analyzed user requirements and created Test Plan using Quality Center.

• Performed UAT testing.

• Detected, Reported and Tracked bugs using Quality Center.

• Familiarized all Customer satisfaction applications (Super Stations) - MSS, TSS, LPFA, LPW, OMNI and other related applications.

• Responsible for documenting all the tasks done.

• Used Test Net to update all the data and documents required for the testing team.

• Used DART Net tool to prepare test input data.

• Actively participated in team meetings to discuss the progress of testing.

• Experience in CS/TS/Lean and other banking centre processes.

• Performed user acceptance testing.

Environment: Manual Testing, Quality Center, Java, JavaScript, Power Builder, .Net, HTML, XML, XSL, JSP, UNIX, Test Net, DART Net, Windows 2000, Windows XP/NT, Mainframe, DB2, Oracle and SQL.

Publix, FL. Nov’04 – Jan’06

Evaluate and Certify TripleDES ATMs.

QA Tester

Description: Publix Super Markets is the largest and fastest-growing employee-owned supermarket chain in the United States, founded in 1930. Publix let its customers to make cash withdrawals from their financial institutions, make balance inquiries and transfer money between their accounts through its Presto! ATMs and the services are available to customers 24 hours a day, 7 days a week.

The Primary purpose of this project is to position the ATMs for TripleDES compliance. All ATMs must be TripleDES compliant by the end of this year to comply with the STAR network TripleDES mandate. The project will address the ATM hardware and software upgrades necessary to satisfy this mandate. Actual implementation of TripleDES will not be completed in this project due to the dependency upon the Base24 Release 6 upgrade project. Once TSS (POS) is implemented, end-to-end TripleDES encryption will be rolled out under the program office. In addition, this project will also implement Electronic Journaling at the ATM and will address various compliance issues such as TG-3, Payment Card industry standards (PCI) and ADA Audio support.

Responsibilities:

• Analyzed and reviewed the Requirements and Design documents and understood the system implementation.

• Involved in all aspects of the software development life cycle.

• Validated the data in the system & the source files using SQL queries.

• Prepared Test case design and Test Cases.

• Executed test cases manually and verified actual results against expected results.

• Performed Smoke testing of the applications.

• Performed Load Testing and Performance Testing using load Runner.

• Performed Regression testing, Functional testing and User Acceptance testing.

• Attended daily status meetings, go no-go meetings.

• Participated in walkthroughs and interacted with other development team members to better understand system functionality in order to improve testing quality

• Involved in ATM & POS (Point of Sale) testing.

• Identified defects and logged defect using Test Director.

• Verification of Audit files (SPDH, BOA, MPS, eFund, EBT).

• Familiarized the backend process (interfaces) - Presto! ISO, MPS, BOA, EBT, eFund etc.

• Verifying messages using Base24, Versa Test, and Win6530 etc.

Environment: Manual Testing, Base24, Versa Test, Win6530, dot net, C# ASP, IIS 5.0, Visual Basic 6.0, HTML Oracle, SQL Server, SQL Navigator , Essbase Windows XP, UNIX.

CNA SURETY, SD. May’03 - Oct’04

Internet bONdLINE.

QA Tester

Description: CNA Surety Corporation provides a full range of surety and fidelity bonds in all 50 states the District of Columbia, U.S. Territories, and many foreign countries. CNA Surety Corporation is the largest publicly traded surety company and is listed on the New York Stock Exchange. CNA Surety, as one of the nation’s largest providers of surety bonds, pledges to do its part in the reconstruction efforts to provide protection to taxpayers and consumers through its surety bonds.

This project is a Forms Consolidation Project. This project will consolidate the different forms repositories into a single form repository. This specific part of the project converts Internet bONdLINE, as a pilot project, to use the new form server. Internet bONdLINE has agents booking and printing bonds via their internet connections. This pilot project is split into four iterations to enable the re-written Internet bONdLINE to use the new form server. This first iteration includes the creation of the Manage Forms application, the creation of the Administer Profiles application, and the part of Convert Forms.

Responsibilities:

• Analyzed and reviewed the Requirements and Design documents and understood the system implementation, including process flows and screen layouts.

• Involved in all aspects of the software development life cycle (SDLC).

• Prepared Test case design, Test Plan, Test Cases and developed Test Matrix for various scenarios.

• Performed manual testing.

• Involved in backend testing (Data Validation Testing) by writing SQL queries.

• Performed Smoke, Alpha sanity testing of the application.

• Performed Load Testing and Performance Testing using Load Runner.

• Performed Regression testing, Functional testing, User Acceptance testing and Integration testing.

• Involved in Onsite and Offshore coordination.

• Attending review meetings and release readiness meetings.

• Used Clear Quest for bug (defects) logging.

Environment: Manual Testing, Load Runner, Rational Requisite Pro, Rational Robot, Rational Clear Quest, Rational Test Manager, J2EE, JSP, EJB, XML, Web Sphere, Web logic, Mainframe,DB2, Oracle 8i, SQL Server, Toad, SQL, Unix, Windows 2000/NT

America online (AOL), NJ. Feb’02 - Apl’03

Low Cost Internet Service Provide (LCISP)

QA Tester

Description: LCISP is AOLs Low cost and high-speed dialup Internet service provider. Premium Services is the LCISP that includes both Base as well as Accelerated applications, providing the basic internet service and special services such as Web Accelerator, Advanced Spam Blocker, and Email Virus Scan. An enhancement to this is the Fiji client that comes with an additional feature, namely, Tool Bar. The Tool Bar provides contains links to Email, My Account, Search, and Home Page. Modal Popup: This project is migration of the user from America on Line/CompuServe to Netscape Internet Service Provider (NSISP). Module Popup provides a popup application, through which the user is to allow migrating to NSISP. Infrastructure SQ: This project involves maintaining the web server, database and resolving configuration issues. The other part is the Service Quality, which involves investigating the real-time issues faced in production.

Responsibilities:

• Analyzed and reviewed the Requirements and Design documents and understood the system implementation, including process flows and screen layouts.

• Involved in all aspects of the software development life cycle (SDLC).

• Prepared Test Plan, Test Cases and developed Test Matrix for various scenarios.

• Performed manual testing.

• Performed Smoke, Alpha sanity testing of the application.

• Performed Load Testing and Performance Testing using load Runner.

• Performed Data Driven test using test data from flat files and analyzed the test results.

• Performed Regression testing, Functional testing, User Acceptance testing and Integration testing.

• Involved in Onsite and Offshore coordination.

• Attending review meetings and release readiness meetings.

• Using Test Director for bug (defects) logging.

Environment: Java Script, ASP, IIS 5.0,Visual Basic 6.0, HTML, VB Script,J2EE, JSP, CES Server, PL/SQL, Oracle, Toad, SQL Server 2000, Unix, Windows NT, Manual Testing, Load Runner and Test Director/Quality Center and QTP.

Verizon Wireless, PA. Jun’01– Jan’02

AccOrd

QA Tester

Description: Verizon is one of the nation's largest telephone operations companies, providing local telephone services and Long distance services in America. Verizon provides telephone services for Residential and Business. It also provides wireless phone services and internet services within United States of America.

AccOrd is a web-based enhanced ASR (Access Service Request) processing tool compatible to other Verizon systems such as AVE, Livewire and Request Net. AccOrd processes orders automatically via flow-through, and route the ASRs to various departments and systems for data retrieval and validations.

Responsibilities:

• Document application requirements so that the Test Plans and cases can be associated directly with requirements.

• Verified that the ASR flows through successfully and the AccOrd System complies with the functional specifications and performs as required.

• Validated 850 and 855 EDI transactions like customer service enquiry, address validation etc according to Local Service Ordering guidelines (LSOG)

• Involved in Mapping data to and from the 850 and 855 EDI using beyond compare tools.

• Involved in implementation of 850 and 855 EDI transfers between Trading partners for Orders and Preorders

• Performed GUI Test, Functional testing, Regression testing, Unit testing, User Acceptance testing (UAT), System Integration testing, and Black and White box testing.

• Designed and developed Test Plan and Test cases for UAT (User Acceptance Test) testing.

• Developed the Test Plans, Test cases, and Test results and Development of automated test scripts for Regression.

• Involved in test case execution.

• Execute tests, report bugs/results using Test Director and track bugs(defects) through resolution

• Performed the Backend Testing, which was DB2, by developing and executing SQL queries.

Environment: Manual testing, TIRKS, CABS, EXACT, UNIX, .NET, Mainframes, HTML, Lotus Notes, XML, FTP, Oracle 8x, SQL, Windows NT/2000, Java, J2ee, DB2, Test Director/ Quality Center

Empire Health Choice (Empire BCBS), NY Feb’00– May’01

ECommerce (Online Member Service)

QA Analyst

Description: This project is a multi-tier application using Enterprise Java Beans on the Web sphere application server for Empire Health Choice, the leading health insurance and healthcare company in New York with 6500 employees and 4 million members. The application allows Members of the company to register at its website. All registered members can access the website and perform all the essential transactions like change of address, telephone, email, viewing their insurance plan documents, viewing insurance claims and their status etc. Registered members are also allowed to send emails to customer service representatives, to talk to customer service representatives using a click to talk facility. The replies to the emails can be viewed by the members when they logon at the website later. Non-members can browse the website and gain all essential information about the company, its insurance plans and various benefits offered by the company. Java Server Pages (JSPs) and servlets are used in the presentation layer. The Data layer is mainly a legacy system comprising IBM's IMS and CICS. Data from the legacy system is converted into XML and MQSeries is used to retrieve the XML. JAXP is used to parse the XML. The business logic layer consists of Java classes based on the builder pattern and Enterprise Java Beans.

Responsibilities:

• Analyzed and reviewed the Requirements and Design documents and understood the system implementation.

• Involved in all aspects of the software development life cycle.

• Prepared Test Cases and developed Test Matrix for various scenarios.

• Executed test cases manually and verified actual results against expected results.

• Performed Smoke testing and adhoc testing of the applications.

• Performed Stress Testing.

• Performed Regression testing, Functional testing and User Acceptance testing.

• Executed scripts to load the source files into the system using UNIX

• Validated the data in the system & the source files using SQL queries.

• Attended daily status meetings, go no-go meetings.

• Created status reports.

• Identified and logged defects using Test Director

• Attended defect meetings and tested production defects.

Environment: Web sphere, Visual Age for Java, Windows NT, EJB, JSP 1.0, UML, XML, servlets, JDBC, Allaire Homesite, Oracle, Rational Rose, Rational Clear Quest and Aix.

RBANMS Educational Trust.

Faculty

Description: RBANMS is a large and renewed educational institution started before independence with the aim to serve below poverty line people in the society.

Responsibilities:

• Served as faculty for under graduate and graduate courses.

TECHNOLOGIES:

Testing Tools: Win-Runner, Load-Runner, Test Director/Quality Center, Quick Test Pro, Rational Robot,

Test Manager, Clear Quest, Rational Requisite Pro, Silk Test, PVCS Tracker.

Operating System: Win XP/2000//NT 4.0/98 & 95, UNIX, Linux and DOS

Languages: C, SQL, PL/SQL, TSL.

Database: Oracle 7.3/8x, MS SQL Server 2000, ESSBASE 7.1.3/6.5.3, Teradata, MS-Access.

GUI: Developer 2000, Oracle Forms 4.5, Crystal Reports 7.0 and Visual Basic 5.0/6.0.

Packages: MS Office, MS Project, MS Word, MS Excel, PowerPoint.

Web Technologies: ASP, HTML, XML, VB Script, JavaScript

EDUCATION:

• MS, S.V.University, India.

• Post Graduate Diploma in Computer Applications, India.

• Training in Oracle and Oracle Applications, SQL Star International Limited, India.

• Diploma in Visual Basic 6, Oasis InfoTech Pvt. Ltd, India.

• Training in Testing Tools (Manual & Automation), India

• Training in SQL Server DBA, Divine Soft, India

REFERENCES: Available Upon Request.

Contact this candidate