Quality Assurance Customer Service

R icha Patel

Cell-661-***-****

r *********.***@*****.***

SUM MARY OF QUAL I F ICAT IONS :

Over 7 years of professional experience working as a Q uality Assurance Analyst i n diverse

i ndustries such as IT, Mortgage, Health Care, Insurance, Pharmaceuticals and Finance domains.

• Experience in the full Software Development Life Cycle (SDLC) using the Waterfall

M odel and R ational Unified Process (RUP) w ith a good understanding of Agile

Methodology.

• Extensive experience in implementing QA Methodologies, Test plans, Test strategies, Test

cases, Test scenarios, Test scripts and test deliverables.

• Created T est Plans, Test Cases, Test Scripts and maintenance of Test Mat rices.

• Extensively involved in B lack box testing, back end testing, regression testing,

f unctional testing a nd data driven testing using both manual techniques.

• Experienced in t racking, documenting, mitigating and resolving project Risks and Issues.

• Experienced in System/Integration/Regression/Smoke testing as well as Users

Acceptance Testing (UAT ). Experience in Manual and Automated Testing Strategies.

• Strong knowledge in creating and executing SQL queries for data validation and data

verification against various data bases.

• Wrote Modification Requests that showed severity of defects and the priori ty level that

needed to be addressed using tools Q uality Center, Test Di rector .

• Worked with Analysts, M anagers, and D evelopers for complex projects during the full

S DLC.

• Experience with different relational databases like I B M DB2, O racle 9i/10g, and MS SQL

Server 2005, Flat Files, Excel Sheets, XML.

• Knowledge of Six Sigma for conducting process analysis.

• Domain expertise including M ortgage, F inance, I nsurance, Health Care, and

B anking.

• Valuable experience in coordinating and managing resources and vendor

selection .

• Self-starter with exceptional t ime management, team building, leadership skills and ability

to multi task.

• Exceptional interpersonal skills, analytical skills with excellent verbal and writ ten

communication.

• Capable of quickly learning and delivering solutions as an individual and as a team player.

TECHN ICAL SKILLS :

Clear Quest, Clear case.

Business

M anagement

Tools

SDLC, R UP, RAD, J AD, Waterfall Model, Agile.

Methodologies

MS Office (Word, Excel, PPT), MS Project.

Application

P ackages

Windows 98/2000/NT/XP/Vista/7, MAC OSX Tiger/Leopard.

Operating

Systems

Oracle 8i/9i/10, DB2, MS Access.

Databases

SQL, HTM L, XML, C, C++, .NET.

Languages

Test Director, Quality Center, TOAD.

Tools

EDUCAT ION :

• Bachelor of Engineering (BE) in Computer Science, India.

PROFESSIONAL EXPER IENCE :

Client Wells Fargo, M inneapolis, M N

Duration November 2012 – Present

Role Quality Assurance Analyst

The US Equity Online Brokerage Application allows the customer to view

Summary

t he account status, asset allocation chart, order status, account holdings

and current market indices. The application also enables him/her to t rade

online.

Responsibilities:

• Planned, managed, implemented, and maintained information systems for business

p rocesses.

• Coordinated different testing environments and components to meet all criteria for

successful testing and launching the application

• Ut ilized project management tools like MS Project to maintain project and testing

schedules, t ime t racking, and to ensure effective personnel utilization

• Created T est Plan, Test Cases and T est Scripts f rom functional requirements, technical

specification based on use cases.

• Responsible for carrying out m anual testing d uring various phases of testing.

• Worked on change request tickets using C lear Quest .

• Created test case scenarios for both positive and negative system testing .

• Attended daily status meetings with Project management on testing update.

• Performed R egression and f unctionality testing against new builds using QTP

• Performed B ack End testing of the database by using SQL queries to make sure that the

database reflects the updates/change, to verify the database Integrity.

• Ut ilized Q uality Center for defect t racking and maintained defect repository and followed

defect life cycle until it was closed.

• Responsible for creating User Acceptance Testing ( UAT) and production releases.

• Assisted the team in obtaining the required permissions for the Project Migrations.

• Managed the Project and resources to successful completion of the Project.

Client Provident Bank, Warren NJ

Duration March 2011 – November 2012

Role Quality Assurance Analyst

Worked as a Business Analyst and was involved in implementing a

Summary

centralized web-based application infrastructure to save t ime, provide

online data access, reengineer the credit card process in order to expand

t he company’s business.

Responsibilities:

• Worked closely with production managers, technical managers and business managers in

p lanning, scheduling, developing, and executing performance tests.

• Prepared test plan and test strategies based on functional and system requirements.

• Developed T est cases based on use cases and design documents.

• Maintained requirements and created Traceability Mat r ix between requirements and Test

Cases.

• Performed M anual, Negative, Positive, I nterface and System Testing.

• Generated data driven scripts that access the backend database and used SQL queries to

verify the integrity of the database.

• Tracked software bugs using Q uality Center and communicated the same to developers to

resolve technical issues.

• Worked closely with users and program developers to ensure that the application

development met the user expectations and was also a part of User Acceptance Testing .

Client Blue Cross Blue Shield, Eagan, M N

Duration January 2010 – Ma rch 2011

Role Quality Assurance Analyst

Worked as QA Analyst in which I was a part of the system integration team

Summary

t esting the implementation of FACET 4.21. I was involved in functional and

back-end testing of various modules including Providers/ Subscribers and

membership.

Responsibilities:

• Defined and presented overall Testing Strategy for the project, including testing phases for

system, user acceptance, performance and end-to-end testing.

• Coordinated testing readiness effort, including creation of T est plans, Test cases and T est

scripts, for multiple testing phases.

• Documented Test cases corresponding to business rules and other operating Condition in

Q uality Center.

• Prepared detailed test execution schedule, including data setup and batch execution

dependencies.

• Coordinated reporting of defects and retesting of fixes with F acets Configuration and

development teams

• Involved in positive and n egative testing, Security, I ntegration, f unctional,

r egression t esting, and G U I t esting on each build and version of the application.

• Involved in UAT and End to end testing designed, scheduled and executed test plans

w ithin the predefined timeframe.

• Interacted with the users to ensure meaningful development of the scripts and simulated

real t ime business scenarios.

• Performed extensive Acceptance and System I ntegration Testing for all the F acets

E xtensions and Interfaces.

• Validated some of the reports, using complex SQL queries, generated during the process

using T OAD .

• Created and maintained T est M at r ix and T ractability Mat rix .

• Interfaced with developers to resolve technical issues and investigate software faults.

Client Farmers I nsurance, Los Angeles, CA

Duration March 2008 – December 2009

Role Quality Assurance Analyst

Farmers Insurance Company, based in CA is one of the leading insurance

Summary

companies. I t offers various insurance policies to customers. MA I is

designed for quote, new business and customer care models. The main

p urpose of Multi Access Integration (MAI) is to get the quote for auto

i nsurance through online.

Responsibilities:

• Involved in analyzing System specifications, design, development and execution of T est

P lans and T est C ases for manual testing and Automated testing.

• Reviewed the Business Requirements document with the business and development teams

to understand the architecture and functionality of the application.

• Created test scripts for all online leasing testing and classified sections for m anual t esting.

• Developed and wrote a suite of Test Scripts that included Acceptance, F unctional and

R egression t est cases using Q uality Center .

• Performed business Functionality testing and G U I testing.

• Executed the test scripts on different releases and validated the actual results against the

expected results.

• Tracked test results for management, categorizing issues and creating/distributing defect

reports and managing defect database using Q uality Center .

• Responsible for Creation and maintenance of Test Director Repository, Creation and

Customization of TD Projects.

• Wrote SQL queries to access the data from the database tables and crosscheck the results

using T OAD .

• Executed web tests across various platforms and browsers including NT, Windows 95,

W indows 98, IE 5.0 and Netscape 4.6.

• Documented bugs, questionable functions, errors, and inconsistencies in application

f unctions, outputs, and content.

Client PNC Financial Services, I rvine, CA

Duration January 2007 – February 2008

Role Quality Tester

PNC Bank Corporation is one of the largest diversified financial service

Summary

organizations in the US. I ts major businesses include Regional

Community Banking, Corporate Banking, Private Banking, Mortgage

Banking, Secured Lending, Asset Management and Mutual Fund

Servicing. Involved in Testing Application processing, Authorization,

T ransaction processing, Customer service, Card issuance, Fraud detection

and reporting and Activation and retention.

Responsibilities:

• Reviewed Functional/System requirement documents that are prepared by the business

analysts.

• Conducted Gap Analysis to identify modifications and business requirement.

• RUP p rocess model is used for the different phases of the application development.

• Designed and executed T est P lan and T est C ases, generate T est Scripts and T est

scenarios.

• Implemented the whole life cycle of QA methodology starting from planning, capturing,

creating, executing reporting and t racking the defects using T est Di rector .

• Performed Back-end testing by extensively using SQL commands to verify the database

i ntegrity using SQL Developer.

• Used Rational C lear C ase for version control, and C lear Q uest for t racking defects.

• Manually performed testing of G U I and Functionality of the application.

• Performed Sanity and Smoke t esting on the application manually.

• Involved in creation and maintenance of T est M at rix and T raceability M at rix .

Contact this candidate