PRABHAKAR

QA Analyst

SUMMARY:

. * years of diverse IT experience as a Quality Analyst and Business

Analyst with Client/server, web based applications in Airlines,

Insurance, Utility, Pharma-Healthcare, and Banking and Telecom domains.

. Efficient in implementing QA Process, procedures and methodologies.

. Strong knowledge on Software Development Life Cycle(SDLC) and

methodologies

. Good understanding of Agile software development lifecycle

. Identify the Test Requirements based on User Requirements and Program

Specifications.

. Experience in preparing Test Scripts, Test Cases and Test Data.

. Prepared Test Plans, Test Cases for both positive and negative scenarios

for User Acceptance testing (UAT) and mapped the same to requirements in

Quality Center.

. Experience in the areas of GUI, Functional, Integration, System, Front-

end, Regression testing for Client Server and web applications.

. Strong skills in back-end testing using SQL queries on SQL Server and

Oracle.

. More than two years of professional experience in testing mainframe

system application and performance for billing related issues

. Extensive knowledge of testing mainframe systems, mainframe tools, and

mainframe testing environments

. Involved in the preparation of Requirement Traceability Matrix and

prioritize Test cases

. Excellent understanding and implementing skills in software methodologies

such as Agile, Waterfall models.

. Involved in testing web applications in Waterfall and Agile development

processes

. Actively Participated in Scrum meetings, reviews and developed test

scenarios

. Experience in project management and bug tracking by the tool JIRA

. Expertise in analysis of Problem severity, Defect tracking and Defects

reporting system.

. Experience in analyzing test results and submitting the bugs using Bug

Tracking Tool Quality Centre (QC) & Team Foundation Server (TFS)

. Involved in testing Web services and XML with tool called 'SOAP UI'

. Worked in manual creation of Leads in SFDC as part of Lead Management

. Involved in the testing of List Management activities in Sales Force

application

. Involved in testing Salesforce.com objects like Leads, Lists,

Opportunities, Reports Dashboards

. Excellent interpersonal skills and ability to work in a cross-functional

environment.

. Worked as onsite coordinator to mentoring for Offshore team, sending the

status report to my manager in my team, for critical issues communicated

with the developer and business

. Lead testing efforts with business analysts, customers, and offshore QA

testers

. Strong experience in interacting with business analysts and developers to

analyze the user requirements, functional specifications and system

specifications.

PROFESSIONAL EXPERIENCE:

Southwest Airlines

Apr 2013- Till

date

Dallas, TX

Sr. QA Analyst

Loyalty Management System is responsible for maintaining Rapid

Rewards2.0 points for the participating members and consumers. The Siebel

system helps in storing the member and their reward details at a

transaction level. The Siebel system is also responsible for being able to

merge the Airtran Credits into Southwest Rapid Rewards. The Customer

Loyalty and Communication Services handle all the individual consumer

requests from within Siebel. The transactional data is replicated to the

Oracle Analytics to support the Marketing team reporting needs.

Responsibilities:

. Analyzed the business requirements, use cases, TDD documents, and

translated them into test plans, and test cases.

. Created the test plan document that defines the test environment,

entrance and exit criteria. Planned resources required for a specific

release

. Designed and developed system test cases for different test scenarios

covering all aspects of project functionality and prepared Traceability

Matrix.

. Regularly participated in business, use case, and TDD review meetings of

different application activities in a business flow.

. Involved in leading the test management activities, initiated technical

discussions with developers, organized script review meetings, defect

review meetings and followed up with development to get the defects

resolved.

. Responsible for Training and leading the QA Team. Responsible for co-

coordinating the Functional and Automation Teams.

. Responsible for managing the offshore testing team and co-ordinate with

the Client business and development team.

. Responsible in providing all the technical details related to a defect to

the development to get a quick turnaround of defect.

. Performed gap analysis, created functional test cases, test conditions,

test data and performed integration, system, regression, positive,

negative, E2E, and UAT testing.

. Conducted interface testing of application with multiple external

systems.

. Worked with project management tool JIRA for various projects

. Responsible for securing the environment for all the required testing

phases.

. Involved in backend database testing, executed SQL queries to check if

data stored in IST and exported to external application tables is

according to the specifications.

. Reported and tracked all defects using Quality Center. Escalated testing

issues, interacted with business users/analysts, developers, external

teams to resolve the defects/issues.

. Worked with external vendor application development team. Participate and

organize scrum meetings. Responsible for Sprint planning.

. Validated functionality and preparing test data for Implementation

Verification Process (IVP) in production environment.

Environment: HP Quality Center 10, Siebel CRM, Oracle Analytics, Oracle

Database, Java, .Net, XML, Agile testing, JIRA, Remedy, Rational Clear

quest, DB Visualizer, UNIX and Windows XP/7.

State Farm Insurance

Jan 2013- Mar-

2013

Bloomington, IL

Sr. QA Analyst

State Farm Insurance is a group of insurance and financial services

companies in the United States. The company also has operations in Canada.

The group's main business is State Farm Mutual Automobile Insurance

Company, a mutual insurance firm that also owns the other State Farm

companies.

Responsibilities:

. Involved in various activities of the project, like information

gathering, analyzing the information, documenting the functional and non

functional requirements.

. Lead planning meetings, JAD sessions, analysis development, test

inspections, and other project meetings throughout project life cycle

. Provide support, training, and mentoring to project team members.

. Worked in manual creation of Leads in Sales Force.Com as part of Lead

Management

. Involved in the testing of List Management activities in Sales Force

application

. Involved in testing Salesforce.com objects like Leads, Lists,

Opportunities, Reports Dashboards

. Participate in project and test team requirements reviews.

. Lead and coordinate integration testing activities

. Formally document test plans, test suite design and test cases

. Report testing status to test lead, project manager, development lead,

data team and developers.

. Responsible for assigning defects to other project team members

. Perform the role of a test lead and involved in peer review of test cases

. Worked as a onsite coordinator communicating with offshore team in

Bangalore

. Performed Black Box Testing, functional and regression testing to

guarantee high quality software end products

Environment: Sales Force, Quality Centre, QTP, SQL, Windows 2000 / NT,

DB2, Java, J2EE, Script, VBScript, UNIX shell Scripting, Web Sphere

Server.

Arizona Public Service Company

Feb 2012- Dec 2012

Phoenix, AZ

Sr. Quality Analyst

Arizona Public Service Company is the largest electric utility, and the

highest tax payer in Arizona, USA, and the principal subsidiary of publicly

traded S&P 500 member, Pinnacle West Capital Corporation. With 4,000 MW of

generating capacity, APS serves more than one million customers in 11

counties throughout the state. APS is mainly concentrated in northern and

central Arizona. APS is one of the two suppliers of electricity to

the Phoenix metropolitan area.

Responsibilities:

. Worked in Agile development environment with frequently changing

requirements and features set

. Working with Project team to understand requirements to plan and execute

Test Cases.

. Interacted with Business Analysts and Developers in requirements

analysis, design reviews, testing and documentation for application

developed in Agile environment

. Participating in the translation of Functional Requirement

Specifications, Business Requirement Specifications and Detail Design

Specifications into, Use Cases and Test Scripts

. Involving in Unit Testing, Functional Integration Testing, System testing

and Regression testing, and Performance Testing to guarantee high quality

software end products.

. Involved in testing of mainframe system application and performance for

billing related issues

. Handled the tasks of preparing test cases and defect tracking of

mainframe systems for a project called Home Energy Information

. Analyzing and developing test plans and assist with development,

implementation, and execution of new tests and test scripts for the

project Customer Production Meter (CPM) mandated by Arizona Corporation

Commission

. Worked in the environment of Agile methodology with regular sprint

meetings

. Working with established defect tracking process which will be shared and

reviewed with the project team.

. Worked with Customer Information System(CIS), Customer Care Express (CCE)

. Using Rational Clear Quest creating the defects which are related to

Service plans and Service plan Ids and managing the same

. Involved in testing Web services and XML with tool called 'SOAP UI'.

. Participating in the IT Kick Off meeting to set expectations base on

requirements and ensure a timely delivery

. Working closely with Business Analysts (BA) to determine and identify

contents and flow of various business processes.

. Communicating with offshore development team and coordination with

testing team to resolve various issues..

. Involving in reviews and documentation for reporting the status to the

project manager. Maintained Test Matrices and Traceability Matrix.

Environment: Mainframe, Rational Quality Manager, DB2, SQL 2008, Windows

2000 / NT, Java, QMF, Manual Testing, Rapid SQL, Quality Center, JIRA,

Agile, Load Runner, Win runner

Southern California Edison

Feb 2011- Jan 2012

La Palma, CA

Quality Analyst

Edison International is the parent company of Southern California Edison -

is a big utility company based in Southern California. Edison Smart Connect

program is to use advanced technology to enable new pricing plans and

energy-saving programs that will empower customers to manage their energy

costs. The ultimate function of this program is to facilitate the

collection of interval data from all of SCE's electric meters.

Responsibilities:

. Involved in Defining, and Analyzing the Testing Requirements based on the

Application Functionality.

. Gathered test data requirements for data conditioning from Business Units

to test total application functionality.

. Conducted Test Plan walkthroughs and wrote test scripts for manual

testing.

. Develop, maintain and conduct smoke test cases for QA environments.

. Created test scenarios for System testing and Regression testing.

. Involved in Black Box, Functionality, User Acceptance Testing.

. Did regression, functional, integration, smoke, system, UAT testing.

. Involved in validation process by using Agile methodology and

participated in regular sprint meetings.

. Prepared Test Plans, Test Cases for both positive and negative scenarios

and mapped the same to requirements in Quality Center.

. Actively participated in Scrum meetings, reviews and developed detailed

test scenarios

. Prepared Traceability Matrix, Test Results Documents for manual and

automation testing.

. Involved in testing Web services and XML with tool called 'SOAP UI'.

. Working with WSDL file on internet, create Test cases, run them, do load

testing, security testing

. Preparing and running of Automated Test Scripts Using the Quality Center.

. Involved in the testing using Selenium Web Driver for automating testing

web applications

. Writing SQL to query the database to verify that the data on GUIs are

accurate

. Validate the transfer of data between Master Data Management Systems

(MDMS) and Customer Information System(CIS)

. Executed test scripts and analyzed the test results.

. Wrote SQL Statements to extract Data from Tables and to verify the output

Data of the reports

. Used Team Track tool for defect tracking, Rational Clear Quest.

Environment: Mainframe, MDM, Rational Quality Manager, Quality center, QTP,

Agile,DB2, SQL 2008, Rapid SQL, ALM, Windows 2000 / NT, IBM DB2,

Java, J2EE, JIRA, UNIX

Merck, Lebanon, NJ

Jul 10 - Jan 11

Business Analyst

Merck is one of the largest pharmaceutical companies in the world. The

headquarters of the company is located in Whitehouse Station, New Jersey,

it was established in 1891 as the united States subsidiary of the German

company now known as Merck KGaA.Merck & Co. or MSD describes itself as a "a

global research-driven pharmaceutical company.

Responsibilities:

. Analyzed business requirements, system requirement specifications and

responsible for documenting functional requirements.

. Involved in developing detailed test strategy, test plan, test cases and

test scripts for manual testing.

. Set up the test environment, defining detailed Test Requirements,

converting them into Test Cases and collected Test Metrics for analyzing

the Testing Effort.

. Coordinated and worked along with the development and business teams.

Controlled testing projects at every step of the quality cycle from test

planning through execution of defect management.

. Involved as part of automation team using QTP, Selenium, developed test

scripts.

. Develop, maintain and conduct smoke test cases for QA environments.

. Worked with development teams to investigate, prioritize and resolve

software bugs / defects based on the testing results.

. After successful release of projects, developed automation scripts using

QTP and integrated the script with master script.

. Did regression, functional, integration, smoke, system, UAT testing on

main application, prototypes created by Flex, Ajax.

. Developing and maintaining test scripts, analyzing bugs and interacting

with development team members in fixing the defects.

. Involved in the testing of application developed for Millipore Lab Water

systems according to 21 CFR Part 11 compliance

. Gained knowledge of GxP regulations for Pharmaceutical industries

. Attained knowledge and understanding of CFR and guidance procedures

followed by Food and Drug Administration

. Involved in the preparation of documents to ensure the compliance with

style guidelines and standards of Regulatory Authorities like FDA, EMA

. Agile methodology used for validation process.

. Responsible for analysis, reports and defect tracking.

. Prepared Traceability Matrix, Test Results Documents for manual and

automation testing.

. Actively attend meetings with fellow testers and other groups to evaluate

the progress and Performance of the application.

Environment: QTP, Selenium, Quality Center, Java, J2EE, JDBC, EJB, Jsp,

Struts, XML, XSLT, SQL 2008, ALM, PL/SQL, JavaScript, SoapUI, JMeter,

JUnit, UML, Agile, Oracle, Toad, MS SQL Server, Unix, Citrix.

Apollo Healthcare, Fitchburg, MA Jan 2009 to June 2010

Business Analyst

Apollo Healthcare is a part of the National Insurance network. It provides

a range of health care services including full range hospitals, family

clinics, physician services, home-based care and emergency services.

The Project was to redefine and rebuild a financials application to make it

easier for workers to complete expense reports for reimbursements. This

included gathering and documenting the user requirements, analyzing the

existing system, performing a gap analysis and coming up with the target

system.

Responsibilities:

. Analyzed the Business Requirement Documents, Functional Specification

document to Prepare Test Cases in Quality Center.

. Developed and reviewed the Test plan.

. Documented and formatted the test data using Excel.

. Created and Executed Automation Test Scripts for Functional and

Regression Testing using Quick Test Professional (QTP).

. Divided the Test Scenario into Multiple Actions and converted the Actions

into Reusable actions.

. Performed Black box, Smoke Testing, functional testing, integration

testing, regression and System testing.

. Performed End-to-End testing manually and was associated with User

Acceptance Testing.

. Reported bugs in Quality Center. Actively participated in preparing the

Defect Report and getting resolution for the Defect.

. Agile Methodology used for validation process.

. Performed on UNIX server like copying, removing, viewing the data and

transferring the files to the local file system.

. Version control tool was Visual Source safe.

. Validated the back-end data by using SQL and PL/SQL extensively.

. Worked with UNIX Shell Scripts to automate the tasks.

. Validated the ETL Process by using Unix Shell Scripts.

. Connected to database to Query the database using Toad for Data

Verification and Validation of the data in the back end.

. Performed data integrity testing by executing SQL statements.

Environment: Rational Requisite Pro, XML, Ms Project, PL/SQL, Oracle, MS

SQL Server, MS Access, Ms Excel, Windows NT, Windows 2000, Toad,

Sierra Atlantic, India

March 06- Dec 08

Bank of America

QA Analyst

Bank of America Credit Care provides a diverse and comprehensive array of

services designed to advance improved. The Common Front End (CFE) system is

the centralized system for viewing and processing all Credit Card

transactions. CFE is used by approximately 3500 CSR's (Customer Service

Representatives) who respond to potential, existing and prior customer

inquires once fully deployed. CFE is also integrated with other existing

systems on mainframes.

Responsibilities:

. Involved in Defining, and Analyzing the Testing Requirements based on the

Application Functionality.

. Gathered test data requirements for data conditioning from Business Units

to test total application functionality.

. Conducted Test Plan walkthroughs and wrote test scripts for manual

testing.

. Created test scenarios for System testing and Regression testing.

. Performed Cross browser testing.

. Prepared Test Plans, Test Cases for both positive and negative scenarios

and mapped the same to requirements in Quality Center.

. Executed test scripts and analyzed the test results.

. Used Team Track tool for defect tracking.

. Tested Automobile, Homeowners, and Dwelling Fire and Workers Compensation

applications finally checking the accord (pdf) applications.

. Worked on Insurance Modules pertaining to Commercial and Personal lines.

. Involved in testing the Property and Casualty Insurance pertaining to

Small Business, Large Business.

. Worked on Electronic Bill Payment applications when select the Electronic

Bill Payment as the Payment type in the Pay Plan.

Environment: Win Runner 7.0, Test Director 7.6, Oracle7, Windows NT 4.5,

PL/SQL, Oracle, SQL Server 2000, UNIX.

British Telecomm, INDIA

Mar 05 - Jan 07

QA Analyst

The CSAM-D system will be used to configure call servers, NGS and Media

Gateways to provide voice service in 21C network. CSAM-D will use

information provided by NRS to achieve this. Media Gateway (MGW) that

performs the conversion of media signals between circuits and packets, and

at least one Signaling Gateway (SG) when connected to the PSTN.

Responsibilities:

. Did task planning for each iteration, for the team

. Prepared test cases and test scripts for functional testing

. Involved in test cases execution and debugging.

. Attending daily Stand-up and Weekly team meetings with team to discuss

the Testing status and issues.

. Ensuring the Build is acceptable for testing by verifying the associated

documentation and

. Checklists from the Development team.

. Executed the scripts with various test data and reported the defects.

. Detecting bugs and Classifying them based on the severity.

. Functionality testing, Regression testing, System testing

. Interaction with onsite team to get project requirements

. Developing Build on the machines (applications)

. Actively Participated in retrospective meetings

. Detecting bugs and updating the functionality in the Wiki page.

Environment: Manual testing, Java, Servlets, JSP, XML, XSL, OMS, ASAP, BEA

Web logic, PL/SQL, Oracle, SQL Server 2000, Toad

Educational Qualifications:

Master of Science, Jawaharlal Nehru Technological University, India, 2004

Bachelor of Science, Osmania University, India, 2000

Contact this candidate