AP- 248-***-****(Rahul)
Visa: Green Card Holder (Authorized to work for any Employer in USA)
Summary
. Over ten years of IT experience as QA Analyst and Software Testing
. QA Testing experience for fortune 100 companies.
. Strong understanding of various phases of Agile Methodology and Software
Development Life Cycle (SDLC) Methodology
. Educational background consisting of Masters in Computer Science
. Self motivated professional with excellent written and communication
skills
QA Analyst/QA Lead Analyst / Software Testing
. Experience in Manual testing and Automated Testing
. Experience with WinRunner, QTP and Test Director, Quality Center
. Proficient in preparing Test Plan, Test Case, Test Script, Execution of
Test Scripts
. Extensive experience in Functional Testing, Regression Testing, Defect
Testing
. Experience in manual testing in UNIX environments
. Defect Tracking Tool Experience: HP Quality Center, IBM Clear Quest,
JIRA, IPM, Jacktrack
. Experience with UNIX Shell scripting for automated testing
. Knowledge of Black Box, White Box, Functionality, Regression testing.
. Experience with SQL simple queries and complex queries
. Experience testing for Java Applications, XML Applications
. Experience working with offshore development team
. Experience with Business Process Testing (BPT Testing)
. Experience in User Acceptance Testing
. Experience with E-commerce Applications, Retail Applications, POS
Applications
Business Analyst and Data Analyst/SQL/Oracle
. Experience in preparing Business Requirement Document (BRD), Functional
Requirement Document and Requirement Traceability Matrix
. Experience in conducting Joint Application Development (JAD) sessions for
requirements gathering, analysis
. Experience in creating Data Flow Diagrams and Flowcharts using MS Visio
. Experience in writing complex SQL queries and generating various reports
Technical Skills
Testing Tools QTP, Win Runner, Load Runner, SQA Robert
Silk Test
Rational Tools Rational Clear Quest, MS Visio, Rational Rose,
Caliber RM
Defect Tracking HP Quality Center, Test Director, IBM Clear
Tool Quest, JIRA, Jack Track, IPM
Operating System MS Windows 98/2000/XP, UNIX, AIX
Database Oracle, DB2 UDB
Language SQL, HTML, Java, Java Script, PL/SQL, Shell
Scripting
Microsoft Tools MS Excel, Visual Basic, MS Access, MS Visio,
MS Word
DB2 Tools Control Center, Command Center
Oracle Tools SQL, SQL*PLUS, TOAD, ERWin, SQL*Loader
Reporting Tool HP Quality Center, Test Director
Education
> Masters in Computer Science at Iona College, New Rochelle, New York
PG Diploma in Computer Applications, NIIT, India
Masters of Arts in English Literature at Utkal University, India
Professional Training
> Extensive training on Automated Software Tools at ITM, Edison, New Jersey
> Training on Business Analysis and RUP methodology, ITM, New Jersey
> Oracle Database Management System, SQL, PL/SQL Training at SQL*STAR,
India
PROFESSIONAL EXPERIENCE
Verizon, DFW, TX
Nov 2009 - Present
Sr. QA Analyst/QA Lead
One Source Application: One Source is a seamless integration of CRM
(Customer Relationship Management), Pre-Sales Ordering and Activities and
Post-Sales Ordering and Activities enabling the customer a complete 360
view of the user
As a QA Lead Analyst, was responsible for:
> Reviewing BRD and SRS, HLD, Work Requests for this Project
> Working according to the Agile Methodology where we can change
specifications according to the end user's requirements and customer
satisfaction
> Reviewing the enhancements for new releases for the project with PM, BA,
Developers
> Reviewing the Test Plan, Test Cases, Test Scripts created by the testers
in the group in Mercury Quality Center
> As a Lead reviewing the defects opened by the testers and escalating the
defects accordingly
> Attending the group meetings with the testers to review the testing
status report
> Sending the status report to PM, BA and Managers on daily, weekly,
monthly and sending final report after the completion of the project
Affinity Token Validation Service: The application offers discounts on
services for the employees of specific partner companies. As Lead QA
Analyst, was responsible for:
> Reviewing BRD, HLD and SRS for this Project
> Working with QTP for Functional Testing, New Enhancement Testing,
Regression Testing and Data Driven Testing and reviewing the test cases
created by testers
> Reviewing the functionality test plan, test cases such as Token
Generation, Token Validation, Token Qualification for different
Applications like online DOTCOM Application, sales rep SPOT Application,
Social Service Media GUI Application and COFEE Application created by
testers
> Reviewing the issues and defects in the project the in Mercury Quality
Center at Verizon
> Responsible for reviewing and analyzing the requirements, test cases,
defects, reports in HP Quality Center.
> Verifying the issues and checking the re-test results of test scripts
again and checking that the test cases executed fine with proper response
as expected
> Reporting the final result of the test cases (Pass, Fail) to the group as
a Lead Test Analyst
> Certifying the product for production testing according to the due date
> Executing Pre-Production Testing, Production testing and Post Production
Testing in the War room till all the testing are completed successfully
> E-Commerce, Retail, and POS Experience in Verizon: (in the CRMM Automated
Tool): Worked on the CRMM (Customer Relationship Management Module) for
Coupon Generation, Validation, Qualification, and Token Generation
Validation, and Qualification in Verizon Project
Damage Claim Application (DCWeb): It is a Web Services Verizon application
to process the damage claims which is linked with their internal billing
system
> Reviewing BRD (Business Requirement Document) and SRS (Software
Requirement Specification) to understand functionality of the
application
> As a Lead Test Analyst conducting internal and external walk through
the DCWeb Application to ensure that the application functionality is
according to the requirement
> Working with DC Web which is Java based Web Enabled Application with
Billing System
> Reviewing the reports with screenshots of related screens for
pass/fail test case
> Reviewing the error details and screen shots in Mercury Quality Center
> Testing final validation of data using SQL simple and complex queries
> Using Quality Center for test plan, test cases, defects and reporting
the results
Environment: Windows 2000, HP Quality Center, Test Director, QTP, UNIX
AIX Oracle, and TOAD, Various Verizon Applications, DCWeb, IPM,, Java,
XML
AT&T, Richardson, TX Feb 2008 - July
2009
Sr QA Analyst/QA Lead
As consultant for Ciber Inc, worked on following AT&T projects:
One Point Universal System (OPUS): AT&T (POS) system enables employees to
effectively activate, assist customers with their mobile phone accounts,
and perform Point-of-Sale (POS) activities. The application is primarily
used in AT&T retail stores.
POS.com is a Web Services Activation System (POS) remote dealers use to
activate service and to maintain equipment information for AT&T Wireless
customers.
Phoenix: Web Services AT&T Activation System that is used to service
business customers. Phoenix can be used to do the transactions like:
activate phones for business accounts individually or in bulk, add mobiles
to existing accounts, migrate customers to AT&T, link to AT&T.com
information, View orders and check inventory.
> As QA lead, attended the weekly meetings with the Project Manager,
Business Analyst, Developer and Testers of the different Applications
which all are impacted
> Working in the Agile Environment where we were following methodology-
Strategy Goals, Release Plan, Iteration Review, Daily Acceptance,
Continuous Build
> Analyzed the HLD (High Level Requirement Document), BRD (Business
Requirement Document),SRS (Software Requirement Specification
Document) of the projects
> Analyzed the Testing Flow in detail by designing Data Flow Diagrams
for the Projects using MS Visio.
> Working with the Functional Testing tool QTP for Parameterization,
functional testing,
> With QTP testing added Synchronization point, Check point to compare
the actual value with the expected value
> Involved in testing the iPhone project for international calling for
the special uses with particular SOC, price plan and also experienced
with Blackberry phone with particular price plan for specific customer
according the required scenario.
> Reviewing in HP Quality center for Requirements, Test Plan, Test
Cases, Defects created by the testers
> Writing Reports to the whole group daily, weekly, final report
> Reviewed and performed the Functional Testing, Regression Testing,
End to End Testing according to the requirement
> OPUS, POS.COM, Phoenix are Web Enabled Consumer and Business Accounts
in Java Environment
> Reviewing the Test Plan and prepared Requirement Tractability Matrix
for testing of different applications. Responsible for sending daily,
weekly, final reports
> Tested Implementation Flow for any new enhancements
> As a Lead Test Analyst discussed with the testers regarding the detail
design and flow of testing
> Coordinated with different teams like Database Table team, Tech
Support Team, Integrated System Testing Support Team regarding the set
up of the database, different types of job run and other necessary set
up requirements
Environment: Windows 2000, HP Quality Center, Test Director, QTP, UNIX
AIX Oracle, and TOAD, Various AT&T applications,, Java, XML Applications
Intervoice, Richardson, TX Aug
2007 - Feb 2008
QA Lead/ QA Analyst
Intervoice operations and professional services personnel use State Control
Application to design and create custom actions. QF-Test is a professional
tool used by Intervoice for automating functional tests for Java
applications. Responsible for automating test cases for State Control
Application using QF-testing tool. As a QA Lead:
> Reviewing and Analyzing Software Functional Specifications and
reviewing test cases
> Reviewing the Automate GUI test cases using the QF-testing tool
created by testers
> Working according to the Agile Methodology where we were focusing on
Customer Satisfaction, daily cooperation between Business People and
Developers
> Used UNIX to check the data validation, for Data Preparation
> As a Lead Working with testers and Developing Team and reviewing the
defects
> Working as Lead for Regression Testing with the group of Testers for
Manual and Automated Test Cases with checking the data validation and
data verification
> Customizing XML-based client application scripts according to the
requirement
> Reviewing the Test Plan, Test Cases, Defects, Reports in Quality
Center
Environment: Windows 2000, HP Quality Center, Test Director, QTP, UNIX AIX
Oracle, TOAD, Java, XML Applications, Intervoice Applications
AT&T, Richardson, TX Aug 2006 -
Aug 2007
QA Lead/QA Analyst
Telegence is the software tool used by AT&T employees to provide services
for its wireless phone customers. Telegence is actually several systems and
databases combined into one dynamic tool. Telegence Customer Service
Management (CSM) application provides features to activate, suspend, and
cancel services, change, add, and delete services and so forth. As QA
analyst and lead QA tester for the Telegence CSM Application, was
responsible for the following QA activities:
Telegence Automation Testing
> Reviewing the modified WinRunner scripts and Test Scripts according to
the requirement created by testers for testing the different modules of
Telegence CSM application
> Reviewed the data preparation and arrangement of data in different
tables, different test cases
> Working in the Agile Environment throughout the life cycle of the project
with self organizing teams
> Using Toad software for executing different types of SQL queries to
retrieve data from Oracle database and to validate the data for testing
purpose
> Reviewed Test Director for test plan and defect created by testers and
reporting the results
Shakeout Automation Testing
> As a Lead Involved in Shakeout Testing/Release Testing in which different
environments are tested before a new Release. Tested the different
Releases of Telegence such as: 9.1, 9.2, 9.3, and 9.4. Performed detail
database testing where we test different data in the database according
to the requirement.
> Reviewing the Auto Population Tool to prepare data for Source, Input and
Query table
> Preparing SQL statements and run SQL scripts in Oracle database using
TOAD
> Responsible for Running of Telegence billing for different days and
collect Bill Image, and Invoice according to the requirement for data
verification, validations
> As a Lead Tester attended daily meetings to give updates and testing
status to the Tech Support Manager after completion of testing by testers
> Reviewing Test Director for Test Plan, Test Cases and Defects created by
testers and Reporting the results accordingly
Environment: Windows 2000, Win Runner, Test Director, Java Script, UNIX
AIX, Oracle, TOAD, Java, XML Applications, AT&T Applications
MISSAT Corporation, East Brunswick, NJ Nov 2005 - July
2006
QA Analyst / QA Tester
As a QA tester for consulting company, responsible for testing applications
software for in-house Telecom, Financial, Health Care Applications. Work
activity included:
. Testing in Unix Platform of various applications
. Testing of data using SQL simple and complex queries for data
validation
. Generating reports with screenshots of related screens for pass/fail
test cases
. Using Test Director for test plan, test cases and reporting the
results
Environment: Windows, Test Director, UNIX AIX, Oracle, TOAD, Java, XML
Verizon Telecommunication, White Plains, New York May 2004 - Oct 2005
QA Tester/ QA Analyst
Verizon Technicians use a system called IFAS (Intelligent Field Access
System) Gateway to communicate with backend systems to get jobs, complete
jobs, get line records, and fill timesheets and so forth. As a QA Analyst
for IFAS Gateway, I was for responsible for the following activities:
Middleware Testing
. Performed manual testing of IFAS middleware by sending various
transactions to the middleware and verifying that appropriate responses
are received.
. The platform in Verizon was UNIX. I was responsible for creating
different request transactions including AWAS in UNIX using VI editor.
Performed basic job submission, and navigation the file structure of the
UNIX server.
. Inspecting the log files to find any errors during transaction for
Validation
Web Services Testing and Common Services Gateway Testing
Web Services and Common Services Gateway are designed to provide web
services. I was Responsible for the following:
. Reviewing the requirement documents and software specifications to
understand XML transactions format for various services.
. Prepare appropriate input transaction files for various services as per
the specification of each transaction and service.
. Perform both pre-production and post-production testing to ensure
accuracy of back-end systems.
Environment: UNIX AIX (RISC 6000), UNIX Shell, Java, HTML, Win Runner, Test
Director, XML Applications, Verizon Applications
Mitra Systems, Montvale, New Jersey Jan 2000 -
April 2004
QA Tester / Business Analyst
As a Business Analyst and QA tester for IT consulting company,
responsible for testing applications software for various client companies.
Work activity included:
. Gathered requirements from BRD, SRS, HLD
. Used RUP/UML use cases for these projects.
. Used SQL simple and complex queries for Data Preparation and
Validation
. Used Test Director for test plan, test cases and generating reports
Environment: Windows 2000, Test Director, UNIX AIX, Oracle, TOAD, Java, XML
References: Available on request