Quality Assurance Resume
San Francisco, CA
Summary
- 7 years of work experience in requirements gathering, analysis, testing and maintenance of web based, e-commerce, .NET based and client/server based applications.
- Managed and performed User Acceptance Testing, System Testing, Integration Testing, Performance Testing and Regression Testing.
- Well versed in White Box, Black Box and Functional testing methodologies.
- Good knowledge and expertise in the usage of latest Test Automation tools in the market like Quick Test Pro, WinRunner and QARunner.
- Good at the descriptive programming approach of QTP which is one of QTP’s advanced concepts used in handling dyanamic objects.
- Strong in the Open Test Architecture ( OTA model ) of Quality Center which is one good feature of the tool for invoking and using it in non-gui mode.
- Conversant with the ability to integrate Quick Test Pro with Quality Center and run automated test scripts stored in QC by invoking QTP in the background.
- Expert in scheduling VBScripts in windows scheduler that trigger stored jobs in Quality Center at desired times.
- Hands on expertise in the usage of performance testing tool like LoadRunner
- Strong Oracle development experience mainly creating Stored Procedures, packages, functions, triggers and cursors for batch loading of data using PL/SQL.
- Knowledgeable in Telecommunications and Banking concepts.
- Highly motivated team player with excellent analytical & problem solving skills possessing the ability to effectively communicate with higher management and stake holders.
- Willing to relocate & work in a challenging work environment and serve by giving the best of self.
Certifications
- OCA – Oracle Certified Associate in PL/SQL Application Development which is a widely recognized Oracle 9i certification that showcases the expertise in SQL query building and advanced PL/SQL concepts used to write stored procedures and functions.
Computer Proficiency
Tools:
Quick Test Professional 9.5, Quality Center, WinRunner, LoadRunner, QARunner, Toad, Oracle SQL Developer, SQL*Plus, MS
Programming Languages:
SQL, PL/SQL, VBscript, Core Java
databases:
Oracle 9i, Oracle 10g, MS Access
Professional Experience
Confidential,san francisco, ca Sep ‘10 – till date
QTP Test Automation Lead
Confidential,
Confidential,is a diversified financial services company with operations around the world. Wells Fargo is the fourth largest bank in the US by assets and the second largest bank by market capitalization.Wells Fargo is the second largest bank in deposits, home mortgage servicing, and debit card.Wells Fargo in its present form is a result of an acquisition of California-based Wells Fargo & Company by Minneapolis-based Norwest Corporation in 1998. On October 3, 2008, Wachovia agreed to be bought by Wells Fargo for about $14.8B in an all-stock transaction. Wells Fargo operates stores and ATMs under Wells Fargo\'s and Wachovia\'s names. As of March 20, 2010 Wachovia Dealer Services became Wells Fargo Dealer Services.
This project is aimed at conversion of the Bill Pay Services from the Wachovia portfolio to Wells Fargo.This is a phased approach where-in conversion is done state wise.The customer’s bill pay accounts, payee information, recurring and pending payments, e-bills etc are converted from Bill Pay DBs from Wachovia side to that of Wells Fargo’s DB.
Roles And Responsibilities
- Played the role of a Test Automation Lead for a team of four members.
- Our team’s sole responsibility is to strive and achieve end to end automation of the testing of the Bill Pay Front End Application from both Wachovia and Wells Fargo perspective. QTP tool was used for the same.
- Added value to the team’s testing efforts by putting forth the idea of integrating QTP with Quality Center – a test management tool.
- In practice, we invoke QTP through Quality Center by installing required add-ins. Automated test scripts are stored in Quality Center server and run by invoking QTP in the background. Once the test scripts are run, the results are stored back in Quality Center tool. In this way we achieved accountability for test performed on every migrated customer from Wachovia to Wells Fargo.
- Conversant with Open Test Architecture (OTA) model of Quality Center which handles data retrieval in and out of QC database using vb scripting.
- Adept in Descriptive Programming approach of QTP whereby dynamic objects in the application are handled through scripting rather than the traditional object repository approach.
- Created test summary and defect reports out of Quality Center in order to provide a snapshot of testing to the clients. This helped in identifying the scenarios that needed immediate attention.
- Testing involved an equal amount of back-end database testing. Expertise in Oracle Pl/Sql helped me in developing queries to validate tables for accurate data population.
- Conversant with establishing Oracle Db connection using Vb scripting where-in sql queries can be embed in vbscript and executed against Oracle Database.
Technologies used:
Quality Center 9.0, Quick Test Pro 9.5, MS Sharepoint, Vbscript and Microsoft Office Suite.
Confidential,grapevine, tx Jan 09 – Sep ‘10
QTP Test Automation Lead
The Retail COFEE is a converged Ordering front end for consumer and small business customers.This integrates all/most of the ordering functionality from various Direct order entry systems.The application architecture is aimed at supporting high scalability requirement with low maintenance cost.
Roles And Responsibilities
- Played the role of a Test Automation Lead for a test automation team of five members.
- Our team was started with the objective to aid the manual system integration testing team by automating most of their regression test scenarios.
- Our sole responsibility was to strive and achieve end to end automation of order creation till submission with zero manual intervention in between. We made use of QTP tool for automation.
- Strived for value addition to the team’s testing efforts by putting forth the idea of integrating QTP with Quality Center – a test management tool. This proposal was accepted and given a go-ahead.
- Basically, we invoke QTP through Quality Center by installing required add-ins. Automated test scripts are stored in Quality Center server and run by invoking QTP in the background. Once the test script is run, the results (Order Numbers) are stored back in Quality Center tool. In this way we achieved accountability for each order placed in Cofee.
- Conversant with Open Test Architecture (OTA) model of Quality Center which eliminates the need of gui and handles data retrieval in and out of QC database using scripting techniques.
- Strong in Descriptive Programming approach in QTP whereby dynamic objects in the application are handled though scripting rather than the traditional object repository approach.
- Created test summary and defect reports out of Quality Center in order to provide a snapshot of testing to the clients. This helped in identifying the scenarios that needed immediate attention.
- Organized a seminar on vbscripting and QTP basics for the benefit of the entire team.
- Created many usable tools using vbscripting to aid the team in their testing efforts.Have scheduled many such vbscripts using windows scheduler to be run beyond office hours.
- Involved in recruitment of my team members.
Technologies used:
Quality Center 9.0, Quick Test Pro 9.5, MS Sharepoint, Vbscript and Microsoft Office Suite.
Confidential, Sep 04 – Dec 08
Confidential,irving, tx Sep 07 – Dec 08
QTP Lead
Confidential,is one of the eminent financial services company with some 200 million customer accounts in more than 100 countries. The Commercial Business Group (CBG) provides leasing, banking and real estate products and services to small and medium-sized enterprises across a broad range of industries.
CitiNait CBG is a diverse umbrella within Citi that encompasses various leasing applications like Infolease, Xpress Credit, Business Center, Recovery Management System etc. User Acceptance Testing for these applications was done by a third party vendor. Testing efforts on various leasing applications within Citi like were managed by our team. Implementation of many critical business applications within CBG rested in the signoff from UAT thereby making its presence important among the rest of the teams.
Roles And Responsibilities
- Played the role of a QA Lead for a UAT team of five members.
- Requirements gathering and formulation of test strategy by direct interaction with clients was one of my sole responsibilities.
- Formulated the Testing workflow for the initiatives using Microsoft Visio.
- Used my expertise in Unified Modeling Language-UML in building the artifacts for the testing initiatives that I undertook.
- Strived for value addition to the team’s testing efforts. I put forth the idea of using Quality Center tool for effective test management which was welcomed by my client manager.
- Successfully managed the testing efforts for three initiatives using the Quality Center tool for which I received appreciations from my Client manager in the form of emails and gift cards.
- Well versed in invoking QTP through Quality Center tool. I have put this functionality of Quality Center to best use in one of my testing project. QTP is added as a plug-in to QC and automated tests scripts are run in QTP and results of the same are recorded in QC.
- Performed Quality Center administration as well, setting up users and user groups with the required access privileges.
- Created requirements and test plans within QC to aid the team.
- Review test cases and test scripts written by the team both in Quality Center and QTP and suggest ways of improvement.
- Creating test summary reports and defect reports out of Quality Center on a regular basis so as to provide a snapshot of testing to the clients.
- Managed the testing documents and deliverables using MS Sharepoint.
- Organized a seminar on the usage of Quality Center for the benefit of our UAT group.
- Call handling, offshore status updates, hosting meetings and discussions with clients were some of my day to day activities that I performed with ease.
Technologies used:
Quality Center 9.0, Quick Test Pro 9.5, MS Sharepoint, Oracle, PL/SQL, Toad and Microsoft Office Suite.
Confidential,Watford,UK Jan 06 – Aug 07
Test Automation Lead
Order Management and Billing of Materials
Confidential,is one of the world\'s leading providers of communications solutions and services. Its principal activities include networked IT services, local, national and international telecommunications services, and higher-value broadband and internet products and services.
The main objective of this initiative is to support Global Solutions to achieve competitive advantage through cost leadership. Expedio Version 5.3 is an e-commerce application for end to end management of Proposition and Order Management processes which make the support to BT Global Solutions’ core business partners, customers and suppliers more efficient and effective. It is a mainly a maintenance/enhancement kind of project that involves the following activities:
- Request for products and services.
- Ordering and having products or services delivered.
- Fault Management or requirement changes to products and services.
Roles And Responsibilities
- As a Test Automation Lead, I managed a team of 7 members in testing the Expedio Order Management and the Billing of Materials application.
- Performed a feasibility analysis on the apt testing automation tool to be used. I chose QTP as it seemed very efficient with the application in hand.
- Created automation test suites using QTP.
- Good at recording and playback of scripts in QTP.
- Expert in designing apt checkpoints within QTP which is very much essential in catching minor bugs which may otherwise be missed as a part of manual testing.
- Performed parameterized tests using QTP.
- Performed tests with Regular expressions.
- Well versed in creating tests with multiple actions in QTP.
- Reported defects out of QTP using Test Director.
- Generated detailed reports of the Bugs, Pass-Fail report and comparison chart out of Test Director.
- Organized Centre level Knowledge Transitions and Demos on the usage of QTP tool.
Technologies used:
Quick Test Professional, Test Director, .NET, Oracle, SQL Navigator, SQA Basic and Microsoft Office Suite.
Confidential,Watford,UK Jul 05 – Dec 05
Test Analyst
Confidential,is a ticketing system that was developed within British Telecom that helps in tracking a defect from creation till closure. This is a web based system designed on the basis of the software testing life cycle. A ticket is created in FMS when a bug is reported by the tester. This system monitors this ticket as it goes from Open state to closed state.
Roles And Responsibilities
- Started my role as a Test Analyst, performing manual testing of this ticketing system.
- Automated the testing process out of my own interest using the QaRunner tool.
- This gave me good recognition among the clients. On evaluating this cost effective and efficient approach of using a tool, the clients funded the creation of a Test Automation team within British Telecom and I was made a part of the team.
- WinRunner tool was used for automation of the FMS.
- Created automation test scripts using WinRunner.
- Hands on experience in recording and playback of scripts in WinRunner.
- Expertise in creating checkpoints in WinRunner.
- Mastery in the Mercury Interactive’s Test Script Language – TSL which WinRunner generates. Have tailored scripts using TSL based on the application needs.
- Reported defects out of WinRunner using Microsoft Excel.
Technologies used:
WinRunner, QA Runner, Oracle, SQL Navigator, TSL and Microsoft Office Suite
Educational Qualifications:
Bachelor of Technology in Electronics Engineering
