Test Cases Quality
Resume:
Marapalli Raghu
*****.*********@*************.***
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