Summary:

• QA professional with around 7 years of IT industry experience in Manual and automated testing of Web/Database/Standalone applications using Winrunner, Quick test professional and Quality Center serving clients in Banking, Pharmaceutical, Retail market and Mortgage Domains.
• Excellent skills in issue resolution and escalation of problems to management.
• Experience in developing Test Plans, Test Strategy, test scenarios and test cases from business, technical and functional requirements.
• Performed functional testing, black box testing, White box testing, GUI testing, back-end testing and browser compatibility testing for J2EE, .NET and Mainframe applications
• Managed and worked on all levels of testing like Integration Testing, System Integration Testing (SIT) and User Acceptance Testing (UAT).
• Extensively used automated testing tools WinRunner and Quick Test Professional for Functional and Regression Testing.
• Used Test Director and PVCS Tracker bug tracking tools.
• Worked with diverse database products: Oracle, SQL Server and DB2
• Working knowledge of TOAD and SQL Navigator to access databases
• Proficiency in writing SQL queries and PL/SQL.
• Hands on experience working in Mainframe and DB2 environment.
• Worked on application servers: Tomcat and Websphere.
• Used Microsoft Word, Excel, PowerPoint, Visio and MS Access extensively in projects
• Exposure to UNIX environment to access application logs and Database
• Participated in Peer Reviews and Walkthroughs for Requirements, Design, Code, Test Planning, Test case Specification artifacts.
• Excellent knowledge of full Software Development Life Cycle (SDLC).
• Experience on Agile/Scrum Methodologies.
• Knowledge on SAS tool and data sets

Technical Skills:

Testing Tools: Win Runner 7.5, QTP 6.5, and Quality Center 10, Selenium
Test Management Tools: Test Director 8.2, Quality Center 9.2 and Rational Clear Quest 7.0
Operating Systems:WindowsNT/Windows98/2000/XP, UNIX
Technical Skills:C, Java, .NET, SQL and VB Script.
Database: ORACLE 11g, DB2, TOAD and SQL Navigator
Web Server:Tomcat 4.0, IBM Web sphere (WAS)
Environment: Web based, Mainframes
Microsoft products: MS Word, MS Excel, MS Access, MS Project, Power Point
Domain: Banking, Investment, Mortgage, Pharmaceutical, Retail and Cable

Education:

• Bachelor of Engineering in Electrical and Electronics.
  

Professional Experience:

Confidential,West Chester, PA June 2011 Till date
Project: Xfinity home security application (XHS)
Role: QA Analyst

Project # 1 Amdocs and CSG Billing system updates
The XHS project, Xfinity Home Security, is a joint effort between Comcast and outside vendors to provide home security thru existing broadband connections. In the process, information is passed from Comcast to the external vendors related to changes in the customer’s orders.
Pick up New orders for XHS service on an hourly basis so the information can be passed down to the vendors, creating a shell account in the vendors systems. Any additional items will be picked up in the normal daily process.

Project # 2 Permit/License Management
The XHS Permit application will house the permit and licensing requirements to operate the home security business as well as those needed for the installation and operation of the platform at individual locations. This will be a metadata repository of the requirements, and applications it will only hold actual completed company based licenses. This repository is critical to the success of the home security product line as it will provide the mechanism to maintain the permit and license requirements in a central repository, which will facilitate more accurate orders and smother installations.

Project # 3 Grand Slam UI
Grand Slam will be enhanced to integrate XHS LOB to be able to lookup the crud level status of Customer Premise Equipment and troubleshoot XHS critical issues.
Functionality included will be an XHS health check on the Grand Slam home page as well as detailed troubleshooting tools, remote access tools, and CPE details on a dedicated XHS tab.

Project # 4 Order Management VIA WFM
WFM stands for Work Force Management which is used by Operation’s team, System Administrator and Technicians to perform different processes involved in Billing like assigning jobs to technician, checking the Technicians availability, complete the pending jobs like equipment installations, modem settings, cable connections etc. & confirming the job completion status to Customer Service Representative (CSR).

Service Suite will be enhanced to allow the technician to up-sell XHS services and/or equipment via the mobile application (MA): collection of all required customer data, obtaining credit-card authorization codes, and enhancing the existing printed receipt to include this data.

Project # 5 Emergency Responder
DEMI the input stream for home security places a text file (the feed from CSG with BHS accounts/records) in the folder home security application instance called “demi”.

BHS has a global process called “Vantage Import” which runs on an interval every hour. This reads the feeds (files) and parses each line item (record). For each record, If there is a success then it sends a message to respective web services and If there is any failure then it work list’s the records details in common.

Responsibilities over the Project:

• Analysed Software and Business Requirements documents to get a better understanding of
• Comcast system from technical and business perspectives.
• Developed test plans in Quality Centre
• Involved in Design walkthroughs to understand the requirements
• Designed test scripts from System Requirements Specification and Design
• Preparation of test data
• Developed test cases based on Requirements Documents
• Reported and Tracked defects using Quality Centre
• Performed System Testing.
• Performed User Acceptance Testing (UAT).
• Performed Extensive E2E Testing
• Performed Regression testing for every modification in the application & new builds.
• Prepared and modify/edit data files using UNIX to support the test conditions.
• Prepared mock up files and dropped the files using filezilla for validating symphony op data base.
• Prepared test cases based on mobile requirements.
• Performedfunctional testing and end to end testing using mobile device.
• Wrote SQL Query’s to extract data from various database tables for testing purpose.
• Run the ETL jobs for validating order processing scenarios.
• Performed service testing using Soap ui.

Environment: .Net, Quality Center 10, Korn Shell/Bash shell, WFM, Amdocs Biller, CSG Biller, UNIX, MS Project, Visio, Power Point, DB2, MS Office, Power Builder

Confidential, Wilmington, DE Dec 2010 June 2011
Project: CAF (Chase Auto finance) IVR application
Role: QA Analyst

Retail Financial Services Application - ECCS IVR QA Group supporting IVR applications will participate in the IST testing events for IVR CAF Rewrite project. This includes but is not limited to the infrastructure implemented to facilitate information sharing, track and report progress, manage change and monitor project performance. The Test Plan that will be utilized to execute functional tests will include the following applications:

• Tests conducted in a self-contained environment constructed to isolate the IVR application from shared environmental resources such as network bandwidth, firewalls and legacy systems. This testing effort will make use of the developer’s simulator capability which will “stub out” or simulate backend capability for different transactions in IVR application. After the individual transactions are verified in Standalone testing, then the individual transactions will be verified in End-to-End testing environment with “real” back-end systems, such as RSI services that supports the different transactions.
• End to End Testing - IST will identify whether the application interfaces behave in a manner consistent with expected user test criteria. This includes Middleware functions to back end systems such, call routing with attached data in Webphone, data transfer to Webphone, screen-pop to CA, and ACR information to Webstats. This testing effort will make use of the “cycle testing” schedule, to verify backend functionality such as, payments, payoffs, statement processing, etc.
• IVR Application Level Testing - Assess IVR application code integrity through business functional performance (as opposed to environmental performance such as network latency, backend application response time, etc.) based on the user requirements. Whereas, End to End testing is focused on validating the communications between IVR and Back End systems, the IVR application level testing is focused on validating the IVR application, such as message prompts playing correctly, any calculations or processing in IVR, correct payment date processing, etc.

Different applications we used for testing call flows.

• IVR Interactive Voice Response Unit
• Genesys Call Routing
• Webphone Attached data based on Key Value Pairs
• Webstats Reports based on different variables such as: Script Location ID’s, event codes, etc. (call logs)

Responsibilities over the Project:

• Analyzed Business requirements, Functional Specification Documents and created Requirement hierarchy in Quality Center.
• Worked with Test Leads and development teams to outline projects Test strategies communicated project test strategy and received approvals from project manager and architects
• Attended design reviews, prepared test matrices, performed testing, and coordinated external dependencies.
• Created business components for the most re-usable functionalities of the application in Quality Center.
• Reviewed and executed IVR Spanish/English functional test cases
• Tested the IVR functionality and the skill based routing for the inbound calls, associating the DNIS with the campaigns.
• Conducted manual/functional testing on report generation for IVR/CAFapplications
• Executed Test Scripts and opened defects and communicated to Project leads.
• Worked closely with the vendor’s QA teams in helping them test the webservice
• Conducted and attended the meetings with the users and team members to discuss and resolve various issues during the testing process.
• Performed data conditioning using TSYS screens.
• Conditioning and let the Test Data Creation by using TSYS For the collection accounts
• Prepared communicated defect reports to project management, architects and team leads every week during the critical testing window.
• Performed UAT testing

Environment: JAVA, HTML, XML, SQL, Oracle, QC, WINDOWS /NT, Web logic, .Net interface, IVR, CAF and Quality Center 9.2.

Confidential,King Of Prussia, PA Aug 2009 NOV 2010
Project: SuRPAS (Shareholder and Retirement Plan Accounting System)
Role: QA Analyst

Investment Banking Mutual Funds and Share Holder Application - SuRPAS A Mainframe application for Shareholder and Retirement plan accounting system, used for wrap, sub accounting (supermarkets), and as a transfer agency. Enhance the existing application to include Service requests from the business users to improve the workflow. Service requests for the current release are adding option to discount today’s unconfirmed traders from OARS totals, add ability to assign new break suspense codes, recalculate break session codes and provide a consolidated summary report of certain generated rejects which will be used to next day to research and resolve rejects.

Responsibilities over the Project:

• Involved in Business Requirement Review’s and understanding the functional requirements.
• Design and Prepare test plans for the individual FTK’s and document management using WebFTk.
• Prepared data using DBMGR (Database Manager Menu) and modify/edit data files using UNIX to support the test conditions.
• Data Validation using SQL queries.
• Backup of tapes using SATS (sub accounting Automated Tape Solution) for test environment.
• Created test accounts (fund), settle funds, setting up parameters for executing Batch Process (Job).
• Reported and Tracked defects using Quality Center.
• Performed System Testing.
• Performed Backend Testing.
• Performed User Acceptance Testing (UAT).
• Worked in Agile Environment and used VersionOne for backlog and sprint assignments.

Environment: Mainframes, VB Script, Protran, UDMS, DBMGR, Rational Clear Quest 7.0, VersionOne.

Confidential,Mclean, VA Nov 2008 July 2009
Project: ADVANTAGE Single Family Line of Business
Role: QA Analyst

Mortgage Lending Portal - ADVANTAGE Advantage project is a portal for Mortgage lenders for the Single Family Line of Business. This Project involves Enhancements and migration the existing Midas application to portal framework. This release will allow Servicers to perform all of the servicing functions to support the requirement for reporting on loans participating in the Home Affordability Modification Program. The post purchase sourcing functions that servicers can perform today in Midanet are migrated to Portal framework. In addition this project includes providing both Freddie Mac and external users with a link to view the reports and functions currently available from Investor Account Management (IAM).

Responsibilities over the Project:

• Involved in preparation of test plans in Quality Centre
• Involved in Design walkthroughs to understand the requirements
• Designed test scripts from System Requirements Specification and Design
• Involved in preparation of test data
• Developed test cases based on Requirements Documents
• Reported and Tracked defects using Clear Quest
• Performed System Testing.
• Performed User Acceptance Testing (UAT).
• Performed Regression testing for every modification in the application & new builds using QTP.
• Performed data driven test-using QTP.
• Write SQL Query to extract data from various database tables for testing purpose.

Environment: J2EE, Flex, Web Portal 1.0, Oracle9i, Quality Center 9.2, Rational Clear Quest 7.0

Confidential,RIFeb 2008 Sept 2008
Project: Multi Factor Authentication, Online Banking
Role: Sr. QA Analyst

Personal Finance online Banking Application -- The purpose of this project is to enhance Online Line Banking application, so it meets the standards outlined in the FFIEC guidelines with respect to additional security requirements to address the increased risks associated with Internet Banking. As part of this all the customers are requested to enroll for secure login, which includes selecting a security image, phrase and challenge questions & answers. Each time the customer login to OLB, security image and phrase are displayed before entering the password, which gives him confidence, that he is on authentic Citizens site. System challenges the user when they login from a PC other than registered one before entering the site.

Responsibilities over the Project:

• Participated in design walkthroughs and reviews
• Designed and developed test scripts in Test Director
• Reviewed test scripts written by peers
• Performed System Testing and User Acceptance Testing (UAT)
• Performed extensive Regression testing
• Reported and Tracked defects using Test Director
• Developed automation scripts using Quick Test Professional for new functionality
• Enhanced existing QTP scripts to run with new functionality
• Maintained various versions of Test Scripts using Quality Center
• Executed QTP regression scripts as and when required
• Performed browser compatibility testing with different versions of IE, Netscape and Mozilla Firefox
• Performed OS compatibility testing on various versions of Windows and MAC systems
• Validated reports against DB2 database
• Worked in a Agile Environment.
• Trained on Selinium.

Environment: Quick Test Professional 8.2, Test Director 8.x, DB2, Mainframes.

Confidential,Buffalo, NYJan 2007 - Dec 2007
Project: HSBC PIB/BIB Automation
Role: QA Analyst

PIB/BIB PIB/BIB are personal Internet banking and business Internet banking applications. Any user with a valid checking, savings, mortgage, loan or loc can login into PIB website and can perform online transactions. The site provides the options like viewing accounts, registers, transers, pay bills, email, customer service and changing profile. The objective of this project is to build QTP Automation scripts from the existing manual test scripts and upon completion of this project the developed QTP Scripts will be utilized to ensure the quality of the PIB applications or in other words will be used to perform regression testing on future releases of the PIB application.

Responsibilities over the Project:

• Involved in analyzing existing manual test scripts for Automation
• Designed and Scripted using Quick Test Pro 6.5
• Conducted Regression, Functional and Performance Testing.
• Performed Data Driven test using test data from Excel files and also created different check points.
• Performed Regression testing for every modification in the application & new builds using QTP.
• Performed data driven test-using QTP.
• Write SQL Query to extract data from various database tables for testing purpose.
• Reported and Tracked Bugs using Test Management Tool Test Director.
• Identified regression tests and automated them using QTP
• Prepared test data sheets for data driven automation scripts
• Developed VB Script Libraries for reusable components & features
• Used QTP to generate numerous test data like accounts and transactions for manual testing team.
• Involved in System Integration Testing and UAT

Environment: J2EE, Mainframes, Quick Test Professional 6.5, Test Director, VB Scripting

Confidential,Lansdale, PA March 2006 Dec 2006
Project: MERCK VACCINES MODIFY ACCOUNT
Role: Test Engineer

The purpose of Merck Vaccines Modify Account project is to provide ability to Merck Vaccines customers to submit a request to modify their current account information, such as Billing Address, Shipping Address, etc. Providing the web as a way to submit these change requests, saves time and is more customer friendly, especially given the ability to let the customers electronically sign their online request, instead of the current process that involves a PDF download, print, complete and fax.

From Order Management Centre perspective New Account Team, the same benefits are provided to them for this project as were done with Online Account Application, including: data on requests will be complete, changes will be typed, not handwritten so they will be eligible to read, there will be no paper trail of faxes to track down and finally they will be able to process account update requests quicker by having the data come in electronically. This last point will directly impact their workload for New Account applications, given that they will have more time to spend on processing new account applications.

Responsibilities over the Project:

• Involved in Design walkthroughs to understand the requirements
• Designed test scripts from System Requirements Specification and Design
• Involved in preparation of test data
• Involved in test case peer reviews
• Performed extensive Integration and System testing
• Reported and tracked defects using Test Director
• Performed browser compatibility testing with different versions of IE, Netscape and Firefox
• Did Backend database testing using SQL Queries
• Performed User Acceptance Testing (UAT) for the deliverables.

Environment: Windows XP, JDK1.4, HTML, XML, JavaScript, JSP, Apache Tomcat 4.0, Oracle 8i, Test Director

Confidential,Lansdale, PA June 2005 March 2006
Project: Merck Vaccines OAA
Role: Test Engineer

The purpose of Merck Vaccines OAA Project is to improve upon and streamline the OMC New Account process. With the introduction of new vaccine products in 2006, the Vaccine Division will be reaching new customer markets and potential increase in new accounts, which translates into an increased volume of new account applications to the Merck Vaccines Order Management Centre.
This project involves in developing the online application with the struts framework and integrating this project with the existing Order Management Application. Developed an application management tool to process the applications by the business people and integrating with external interface (Medpro) for validating the license information.

Responsibilities over the Project:

• Involved in Design walkthroughs to understand the requirements
• Designed test scripts from System Requirements Specification and Design
• Involved in preparation of test data
• Involved in test case peer reviews
• Performed extensive Integration and System testing
• Reported and tracked defects using Test Director
• Performed browser compatibility testing with different versions of IE, Netscape and Firefox
• Did Backend database testing using SQL Queries
• Performed User Acceptance Testing (UAT) for the deliverables.

Environment: Windows XP, JDK1.4, HTML, XML, JavaScript, JSP, Apache Tomcat 4.0, Oracle 8i, Test Director

Confidential,Hyderabad April 2004 March 2005
Confidential,Woodland Hills, CA
Project: Audit Track
Role: Test Engineer

Audit Track is a Web-based solution developed by VisualSoft Technologies for Zenith Corporation, a leader in US based Workers Compensation (WC) Insurance market. Audit Track has different modules like Assignments, Maintenance, Letters and Reports. Functionally the modules facilitate to perform various tasks involved in WC Insurance related activities enabling state of art Audit Tracking functions.

Responsibilities over the Project:

• Involved in Defect Analysis
• Designed test cases from Requirements and Design
• Performed extensive Integration and System testing
• Reported and tracked defects using Test Director
• Closely worked with developers to resolve the issues and defects
• Database testing for Backend operations using SQL

Environment: Windows XP, JDK1.4, HTML, XML, JavaScript, JSP, XSL, Apache Tomcat 4.0, Oracle 8i, Test Director

Confidential,Hyderabad
Client: Confidential,Santa Ana, CA August 2003 Mar 2004
Project: Store Fronts
Role: Software Tester

Ingram Micro currently supports multiple web-based storefronts, including VentureTech Network (VTN), Partnership America (PA) and Pipeline. This project was initiated to aid in consolidating to a single storefront solution. The goal is to improve the usability of VTN and add new features to the application.

The problems with the existing system are, all three of the interfaces present unique problems in terms of usability and/or flexibility, resulting in a less than desirable user base. There is also a significant problem with the level of maintenance inherent in continuing to preserve the three disparate systems. After completion of this phase, the existing and new customers from Partnership America and Pipeline are migrated to the single storefront solution.

Responsibilities over the Project:

• Involved in writing test scripts from System Requirements Specification and Detail design
• Performed extensive Integration and System testing manually
• Wrote SQL queries for testing Backend operations.
• Reported and tracked defects using Test Director

Environment: Windows XP, JDK1.4, HTML, XML, JavaScript, JSP, XSL, Apache Tomcat 4.0, Oracle 8i, Test Director