Marapalli Raghu

571-***-****

acpfyi@r.postjobfree.com

Summary

. 8 + Years of experience in IT industry as Senior Quality Analyst and

Automation Test Engineer

. Extensive experience in Client/Server and Web Based Applications.

. Proficient in Automated & Manual testing along with Integration

testing, and Functionality testing.

. Experience in installing, configuring and working on Mercury tools

like UFT with Quality center, Test Director, Load runner, IBM rational

tools like Rational robot, Clear Case and Clear quest .

. Experience in testing Web Applications for Load, Stress, Performance,

GUI based Applications and Databases.

. Experience with Quality Center in managing Requirements, Test case

designing,Execution and Defect tracking

. Extensive HP BPT automation development experience (Business and

Scripted components).

. Strong experience in developing Test Plans and Test cases based on

requirements and design documents.

. Worked for projects that followed various Software Development

Methodologies (SDLC) and QA Methodologies (Water fall, Agile, V-

Model).

. Extensive experience in the Analysis of Bug Severity, Bug tracking

system and Bug Reporting using Test Director, PVCS Tracker, Clear

Quest.

. Experience in implementation Testing Methodologies & Automation Tools

in projects.

. Created UFT Script for regression testing in Client/Server

application.

. Worked on Unified Functional Testing, Quality Center, Load Runner.

. Strong Oracle and SQL Server skills that include build/maintain tables

and indexes, build/maintain PL/SQL, SQL scripts, Stored Procedures,

Triggers and Functions.

. Expertise Test Automation Frameworks to leverage common functionality

and object structure

. Ability to interact with end users, Self-motivated, quick learner.

. Excellent analytical, programming, written and verbal communication

skills

. Enthusiastic in taking up the initiatives, challenges, own the tasks

and be productive in deliverables

. Good in decision making problem solving and generating reports, Good

in assigning tasks and making them clear to team and get the work done

with in time frame

Technical Skills

Operating Systems: Windows 95/98/2000/XP/7,UNIX,

Linux.

Web Technologies: MS FrontPage, HTML, Java,

ASP(JavaScript VBScript),XML

Databases: ORACLE 7.X/8.0/8i, Sybase

11, SQL SERVER 6.5/7.0, DB2

Requirement Management: Rational RequisitePro, MS Excel, MS

Word

Test Management: Rational Test Manager, Mercury

Test Manager

Functional Testing: Rational Robot, Mercury Win

Runner, Quick Test Professional, UFT11.50

Load/Performance Testing: Mercury Load Runner, Sitescope.

Defect/ Tracking Management: Rational Clear Case, Mercury Test

Director,QualityCenter,ALM

ETL Tools: Informatics 7.x, Ab

Initio 1.14/1.13, Data Stage 8.0/7.5.2

Education

Bachelor Degree in Computer science from Osmania University, India

Professional Experience

Health Care Service Corporation, Chicago IL

Aug 2014-

Dec 2014

UAT Tester

RSC (Retail Shopping Cart)

The application was concerned with RSC (Retail Shopping Cart) for 5 States,

where user/applicant can go to BCBS site and shop for insurance plan and

get a quote . RSC gives user flexibility to compare plans, Look for PCP

(Primary Care Provider), Search for the Agent who can help in shop for

Insurance plans. The project involves Individual and Family plans, Medicare

and Short Term plans available both on Web and Mobile Version.

Responsibilities:

. Documenting, implementation, monitoring, and enforce all processes and

procedures for testing is established as per standards defined by the

organization

. Formulated Test Plans, Test Scenarios, Test Cases, Expected results,

and test data for the Acceptance Testing of web application.

. Performed manual testing to verify the functionality of all the

required features

. Mapping of requirement with the corresponding test scripts to ensure

testing coverage

. Worked with BA's to modify complex requirements as per user

flexibility.

. Involve in Defect Calls to Verify the Severity and Priority of the

Defects with BA's.

. Identify any potential quality issues per defined process and escalate

potential quality issues immediately to management

. Analysed requirement updates and mapped them with the respective

manual Test Cases

. Performed UAT testing to Verify the functionality of the application

. Modified previously existing test cases that were driven by the manual

testing effort so that they are more appropriate for future automation

testing

. Retested defect successfully and closed in HP QC.

. Documented the defects in the HP Quality Center and helped developers

identify the modules and code sections to be fixed by executing the

related scenarios with different combinations of data

. Involve in Production Testing to check the application Performance at

Release Time.

. Involve in Modifying the Existing suite of Automation regression

using UFT as per the changes done on application .

Environment : HP Quality Center 10.0, UAT 11.5, MS Office, Java, HTML,

SIT, SOAP UI, Windows, Java, Oracle, Web sphere 7.0, Perfecto

Walgreens, Deerfield IL

Senior Automation Engineer

Health Cloud (EHR)

Feb 2012 - July 2014

Health Cloud Program, an Electronic Health Record (EHR) application is

being developed to support Walgreens' strategy of becoming a health

destination and an integrated component of the health ecosystem. To enable

this strategy, integration testing between EMR and IC+ is needed. The

overall objective for the Health Cloud is to facilitate the high-touch

relationship required to fill specialty scripts while still allowing the

patient the convenience of having their medication fulfilled through the

retail pharmacy.

As Walgreens continues to execute its health services strategy to become

the premier retail healthcare platform in America, it has identified core

technology capabilities needed to transform from a retail drugstore to a

health and daily living destination. These Health Cloud capabilities will

be delivered across the Enterprise and built upon the One Walgreens

platform

Responsibilities:

. Involved in technical coordination with the automation team to ensure

minimal duplication of efforts through maximum reuse of defined

solutions

. Responsible for mentoring and training other automation staff

. Expertise in a fast moving environment and can provide spontaneous

productive decisions.

. Involved in Retail Core Pharmacy automation and responsible for

automating around 1600 test scripts

. Responsible in creating the CRAFT and IFrame setup for the new Health

Cloud Pharmacy project

. Hands on ALM 11.5 in migrating the Existing testcases from QC and also

got training from HP .

. Developed Manual and Automation Testing Framework for QC & UFT.

. Implemented Hybrid framework (CRAFT) using UFT.

. Extensively worked with all the Quality Center 11 modules Management,

Requirements, Test Plan, Test Lab, Defects and Dashboard.

. Performed manual functional testing with Mercury Quality Center and

regression testing with UFT.

. Created all types of test resources such as, function libraries, data

tables, shared repositories, environment variables and recovery

scenarios.

. Involved in creation of shared object repository responsible for the

maintenance of shared OR across the team.

. Developed huge number of library functions, which include restarting

remote servers, working with many applications remotely.

. Expertise in preparing and scheduling the test lab for both manual

test cases & automation test scripts

. Parameterized scripts with action parameters, data table parameters

and environment variables

. Involved in IFrame integration with CRAFT framework for the EHR

application

. Responsible in Creating the Business Flows, Using Functions and

Creating Automation Test cases with coding Standards.

. Executing the Automation Test case on Various EHR Builds and Hotfixes

based on Release Note Provided by Development Team

. Analysis Functional Area on EHR Application which are in scope for

automation and Provide ROM to higher level management

. Participle in Defect Meetings, and also in workshops to reproduce the

defect for development teams with trace log and screen shots

. Responsible in Maintaining the Automation code in SVN(Version Control)

. Participate in Daily Status Call and Weekly Status call to Provide the

Automation Execution Status, Development and Issues

. Maintaining the Support Libraries, Recovery Libraries, object

Repository by adding objects and Function.

Environment: UFT11.50, Quality Center 11.00,ALM11.5, Sitescope 10.10,

Silverlight 4.0,SQL Server Management Studio 2008, Tortoise SVN 1.7.0

Microsoft Office 2010, JIRA,.Net, Notepad ++.

Project: Intercom Plus(IC+)

08/10 - 01/12

Walgreens, Deerfield IL

Senior Automation Test Engineer

Intercom Plus (IC+) & Power is Walgreens proprietary pharmacy system. IC +

relies on satellite access and broadband connections to link the over 7541

Walgreens retail, mail service, and specialty pharmacies. IC+ Application

is an Interface for many applications. Used in Walgreens pharmacy for all

business activities related to pharmacy and pharmacy management. Power a

Web application which interacts with Intercom plus (IC+) where the

activities done in IC+ are done remotely. The goal of POWER applications is

to improve customer satisfaction and pharmacy efficiency by sharing the

workload on pharmacies.

Responsibilities:

. Responsible for ensuring the conceptual integrity of the system,

ensuring that the product and product architecture meet the technical

requirements defined

. Involved in technical coordination with the automation team to ensure

minimal duplication of efforts through maximum reuse of defined

solutions

. Responsible for ensuring that defined architectural and development

standards are followed by all the members of automation team

. Expertise in best practices of automation development efficiency,

maintainability and reusability

. Responsible for Assist in managing and improving the coding standards

decomposing requirements and developing test automation for high

complexity projects

. Expert in developing scripts according to the coding standards

. Responsible for providing accurate implementation level estimates

and delivers on them

. Expert in understanding software quality best practices, test strategy

and planning, test case development and execution, defect tracking.

. Responsible for mentoring and training other automation staff

. Expertise in a fast moving environment and can provide spontaneous

productive decisions.

. Involved in Retail Core Pharmacy automation and responsible for

automating around 1000 test scripts

. Responsible in creating the CRAFT and IFrame setup for the new

Speciality Pharmacy project

. Involved in drafting the automation system and regression test

plan.

. Developed Manual and Automation Testing Framework for QC & QTP.

. Implemented Hybrid framework (CRAFT) using QTP.

. Extensively worked with all the Quality Center 10 modules Management,

Requirements, Test Plan, Test Lab, Defects and Dashboard.

. Performed manual functional testing with Mercury Quality Center and

regression testing with QTP.

. Created all types of test resources such as, function libraries, data

tables, shared repositories, environment variables and recovery

scenarios.

. Developed huge number of library functions, which include restarting

remote servers, working with many applications remotely.

. Expertise in preparing and scheduling the test lab for both manual

test cases & automation test scripts

. Parameterized scripts with action parameters, data table parameters

and environment variables

. Involved in CRAFT framework implementation

. Involved in IFrame integration with CRAFT framework for the Power

and ICPlus applications

. Expertise and responsible for creating reusable business components

as function libraries in CRAFT framework

. Expertise and responsible for creating support libraries and

parameterized checkpoints in CRAFT

. Expertise and responsible for creating customized checkpoints and

recovery scenarios for CRAFT and IFrame integration.

. Expertise in implementation of descriptive programming from QTP

perspective with Centura Objects

. Expertise in troubleshooting QTP compatibility with the Retail Core

Pharmacy and Speciality Pharmacy

Environment: Quick Test Professional 9.2,JIRA, Microsoft Office Access

2007,Excel 2007,Oracle 9.4,SQL Developer. JAVA, Excel 2007.

Media Bank, Chicago IL

08/09-07/10

QA Engineer/Analyst

MBOX Presents the evolution of media buying - integrated, open, cross-

platform technology that maximizes intelligence and efficiency in the media

buying process. One technology platform, one database, one fantastic

solution across all media types. MBOX application maintains the history

interaction between vendor and client. It represents as Plan, Orders,

Invoices, and Billing etc.

Responsibilities:

. Involved in Executing Keyword Driven Frame work,Developed Test Plan,

Test Cases and Test Scripts for various application modules

. Decomposed the application into Minor Level to Create BPT's In

Microsoft office access.

. Create Test cases with BPT's and also maintained input data to run the

test cases and BPT's.

. Responsible for weekly status meetings showing progress and future

testing efforts to the QA Manager/management

. Created and maintained automated scripts and ran the scripts for

regression testing in successive iterations.

. Worked on Order Management system interfacing the orders into oracle

EBS.

. Developed Test Scripts for Integration of Impacted Systems with Oracle

r12 eg AS400, Vigo, GEMS etc

. Designed, Developed Test Scriots for Upgradation Oracle Applications

from 11i to r12

. Involved in loading the data into Multiple Instances using Data Load.

. Executed automated test cases in access with Keyword driven approach

in different environments (UAT,Staging, Active Staging)

. Hands on JIRA, to create, modify and closing the Defects which found

during the QTP Execution.

. Interactions with Developers, Business analyst, regarding the

requirement and Bugs

Environment: Quick Test Professional 9.2,JIRA, Microsoft Office Access

2007,Excel 2007,Oracle r12,SQL Developer. JAVA, Excel 2007.

Capital Group, Scottsdale, AZ

02/09 - 07/09

Senior Quality Analyst

FXT (Foreign Exchange Trading), CTS (Currency Trading System), ETP (Equity

Trading Platform) and SDS (Shared data services): Equity Trading Platform

Application enables users to trade the equity for U.S. market as well as

overseas financial market. The application was developed in .NET Framework

(using Sync fusion Development tool) with backend as Sybase/Oracle. ETP

interacts with two different applications (COPS for Order Processing and

Trade Information). Two simulators have been provided for the Testing(COG

Simulator enables user to insert Trade Order in ETP application and Aegis

Simulator takes care of Broker related activity).

Responsibilities:

. Managed and Mentored Test plan, Test schedule, Test Reports, Defect

reports.

. Documenting, implementation, monitoring, and enforce all processes and

procedures for testing is established as per standards defined by the

organization.

. Skilled in directing the QA process from beginning to end, overseeing

the testing process executed by employees in offshore and local

interns for major software release. Participate in functional

specification reviews and project planning.

. Prepared and presented status reports and capacity estimates of the

application to management

. Participate in functional specification reviews and project planning.

. Responsible for tracking and reporting testing activities, including

testing results, test case coverage, required resources, defects

discovered and their status, performance baselines, etc.

. Preparing the test bed standards and configuration to maintain

consistency throughout different releases.

. Testing Data quality to ensure that the ETL application correctly

rejects, substitutes default values, corrects or ignores and reports

invalid data.

. Developed trace ability matrix to map Business & Functional

requirements with test cases.

. Worked with QC OTA for integrating external applications, interact

with QC without GUI and interact with QC Databases

. Involved in functional testing of the application using QTP

. Created Business Components, Application Areas and Scripted Components

using QTP and Mercury Quality Center - "Business Components" module

for Business Process Testing - BPT.

. Responsible to provide production support for marketing and deployment

teams and also trouble shoot any customer related issues raised by

customer support.

. Performed daily walkthroughs of the test cases, bugs found and to

solve the issues with development manager and DBA.

. Extensively used SQL to perform Data integrity testing.

. Validated that each Web Service operation functions as stated; Web

Service returns results compliant with its definition ; sequence of

web service invocations fulfill a required business process and that

any of the above works as required with data input from external

sources .

. Tested all the web services using SOAP Scope tool.

. Validated the XML Schema, XML Queries and WSDL files using XML Spy.

. Developed scripts for performance testing of application and database

using different protocols like TCP/IP,HTTP/HTML, WEB-SERVICES and ODBC

using Load Runner.

. Added performance measurements before running the test in the

Controller for UNIX, Oracle, Web sphere servers in Load Runner

controller and monitored online transaction Response times, Web hits,

TCP/IP Connections, Throughput, CPU, Memory, Heap sizes, Various Http

requests etc

. Performed Gap Analysis of Load Runner and Web Avalanche working

towards the attainment of Load and Stress testing tools.

. Performed Load/Stress testing of the application and used different

monitors (database and server) to analyze the results and pin point

the performance issues.

. Tested Auto Sys jobs (On Demand equivalents of the jobs in production,

to be called manually as needed) for troubleshooting and handling

unexpected outages or delays.

Environment: QTP 9.5, Quality Center 9.5, Windows NT/2000, MS Office Tools,

XML, Rapid SQL 7.x, Sybase 12.5, UNIX, Informatica Power Center 8.6.0,

Power Exchange,Tibco, Business Objects XI, JAVA, JSP 2.0, Crystal Reports,

Tomcat 5.5.x, J2EE 1.4,TCP/IP,Oracle,SOAP Scope, ADDM Report, XML Spy, HP

Performance, HP BAC 6.9, HP SiteScope 8.9

Capital One, Richmond, VA

07/08-01/09

QA/Performance

Analyst

Capital One is a global diversified financial service provider, with

operations in U.S., Canada, and the United Kingdom and continues to add

innovative offerings to our current product range. OTS is the Inbound

Decisioning & Offer Management system which uses real time service that

retrieves available sales, Retrieve history, Updates the status and

Decision a list of offers to be presented to the customer.

Responsibilities:

. Developed test cases for Functionality and Stress Testing and Involved

in performance testing of the entire product and analyzed the test

results with the Customers. Used the features such as performance

monitors, runtime checks checking for the Disaster Recovery Exercise.

. Analysis of Business, System Requirements and Developed Performance

Test Scripts.

. Tested Performance of Web Application & Real Time Messaging and

Generated Automation Test scripts using Load Runner.

. Created performance testing requirements on Disaster Recovery by

scaling down the transaction volume for the certification environment

based on the production expected usage trends.

. Analyzed the Load Runner results to measure the Average CPU usage,

Response time, Transactions per second.

. Analyzed graphs such as Response time, Running Vusers, Throughput,

Hits per Second and Web Page Breakdown Graphs.

. Executed Stress test by 500 Virtual users using Controller.

. Used Performance Center for creating scenarios and running load tests.

. Used Site Scope to monitor the system Performance.

Environment: HP Blade Server/Linux, Web Logic Integrator, MS- SQL Server,

OS/390, MVS XA/ESA, Load Runner 9.0, XML, Web Services, Shell Scripts,

Quality Center 9.0, Teradata, DB2, Site Scope.

JP Morgan Chase, Jackson, MS

03/07-06/08

Senior QA Analyst/Lead

The project involved different aspects of student loan funding. There were

two different application processes. One involved funding directly to the

consumer called as Direct to Client (DTC) and other was funded directly to

the school by process called certification (CERT). A borrower can apply for

a loan either by calling the chase sales representative or by doing it

online. I was involved in testing both the website and also the internal

site. The internal site has three modules namely Sales, Processing and

Customer service. I was involved in the project from Design phase to the

Release phase.

Responsibilities:

. Extensively used Quality Center 9.2 for Managing Software

Requirements, Test case designing and construction, building tests

sets in test plan, execution and result maintenance based on versions,

and defect reporting and tracking.

. Worked on Various Application parts of the Project Simultaneously Based

on Project Requirements

. Followed standard Waterfall model in GPS application, Read through the

requirements, designed test cases, executed the test cases in build

iterations along with random testing.

. Involved in Document, Implement, Monitor and enforce all processes

and Procedures for testing is established as per standards defined by

the Organization

. Worked with development, users and support groups to understand the

application architecture and acted as a liaison Between Development

and Testing teams for Iterations, Testing and Deployment Activities

. Developed scenarios for Regression/Functional testing which covers

more than 90% of the Critical scenarios for the application.

. Experience in Integration Testing of different modules in the project

and dataflow between different modules

. Followed agile methodology for PULSE application. Participated in

Daily scrum and sprint meetings for the status and deliverables

. Generated Automation Scripts and Test Scripts using QTP for Regression

Testing and the additional scripts are generated for each version

. Extensively used Test Director for the earlier versions of some

applications.

. Worked with multiple applications like APPRO, APPWORKS, BIZTALK, TIL

as part of system flow.

. Involved In testing the values are correctly stored in

Database(SmarclientIII-SQA) under the respective tables using

Microsoft SQL Server 2005

. Writing the SQL Query to Pull up the data from different tables using

joins and unions to validate the values for that particular

application

. Used Load Runner for Performance Testing for web application,

Generated Automated Script using Virtual User Generator. Inserted

Rendezvous Points and user defined functions to enhance the Script and

executed the Test Scenarios using Load Runner Controller

. Performed Data driven testing and script enhancement.

. Involved in Testing at release time for Hot fixes

. Generated Test data for various types of testing to valid data,

Invalid data, Partial data, bad data Testing

. Interacted with developers to resolve for the defects, which would

affect income generating functionality in Production

. Co-Ordinate the Test cases(End-To-End) In QC for UAT according to the

Scenarios Provided by Business analyst

. Involved in UAT testing environment, that Include System,Integration

and UAT Test plan Implementation

. Worked exclusively on Kofax Ascent capture for Document Processing and

Validation

. Detected Defects, Analyzed and Reported the Defects to the Developers

using Quality Center and Test Director.

. Participated in review of requirements and interacted with business

analysts for clarification of doubts and also participated in defect

review meetings.

. Involved in Post- Production support

Environment: Quality Center 9.2, QTP 9.2 with BPT, Test Director 8.0, Load

runner 9.0, Clear quest, Kofax Ascent Capture and Manual Testing.

Environment: Win XP, .net, C#, UNIX, COBAL, DB2, CICS, Web logic, Web

Sphere, FIXML, VBScript, SQL Server and Mainframes- File Aid, XPEDITER,

Endeavor

Contact this candidate