Sowjanya Devarapalli
Phone: 502-***-****
sowjeey@ gmail.com
SUMMARY: A seasoned professional with extensive experience in Analyzing
system functionality, Conceptualization, Design and
implementation of QA testing strategy for Web based and
Client/Server applications. Experience in testing software
applications based on the requirement specifications for
verifying the functionality and re-usability of the code using
automated testing tools. Proficient in using the following
automated test tools: Mercury Quality Center (QTP, Test
Director), Rational Suite 2003/2002, Selenium Tools (Selenium
IDE, Selenium Remote Control), WebLoad.
. Over 7 years of diversified experience in Quality assurance
testing. Skills include Manual & Automated Testing on Client/
Server & Web applications.
. Experience in testing of web applications developed using
ASP, Java, and J2EE on Internet Explorer, Fire Fox, and
Netscape Navigator.
. Full life cycle Software Development experience including
Requirements, Analysis/Design, Development and Testing as per
the Scrum, Agile and RUP's Iterative Software Development
Life Cycle process.
. Strong experience in developing Automation Scripts using TSL,
TCL HTML & VB.
. Experience developing High Level Test plans that specify
testing overview, approach, documentation, roles and
responsibilities. Developing Test requirements and Test
Scenarios and Executing test cases.
. Expertise in Validating Database Integrity and in developing
Batch and Data driven tests.
. Experience in Performing baseline, Assembly, Performance and
System testing.
. Responsible for Test cases, Test Plans, Test Reports,
Executing Test Cases and Test Scripts.
. Excellent knowledge of manual testing & Automation in
Client/Server and web based applications.
. Experience in Structured testing methodology.
. Experience in Black box and White box and Gray Box testing.
. Very good at Preparing documenting and implementing of test
procedures, test requirements and test cases for full life
cycle testing methodology.
. Experience in Regression, GUI Testing, Integration testing,
performance testing, Load/Stress testing, system testing,
Database Testing.
. Experience conducting meetings with the project managers to
discuss the outstanding issues.
. Excellent communication and interpersonal skills, an
effective team player and will make a valuable and dependable
member of any team.
SKILLS: TESTING TOOLS : Selenium Tools (Selenium Remote
Control, Selenium IDE),
Mercury tools 7.4, 7.5, 8.2 Mercury
Quality center 8.2.
LANGUAGES : C, C, C++, C#, Cobol, Cold
Fusion, VB, VB.NET.ASP, JAVA,
JSP, HTML, XML, SQL, PL/SQL, CGI,
TSL.
DATABASE : Oracle, DB2, SYBASE, MS-
Access, MySQL and SQL Server.
WEB /APPLICATION
SERVERS : IIS, IBM, Web
Sphere, Web Logic, JBoss
SCRIPT : Java Script, VB Script, PERL,
CGI, UNIX Shell Script.
GUI : Power
Builder, Visual Basic 5.0/6.0,Developer 2000.
VERSION CONTROL : Rational Clear case, PVCS, SVN AND
CVS
OPERATING SYSTEMS : WINDOWS NT 4.0 / 2000/2003 /
XP, Sun Solaris, UNIX,
Linux, MAC and CITRIX.
EDUCATION: Bachelor of Technology in Computer Science and Engineering.
EXPERIENCE:
TASC- MADISON, WI (Jun 07 - Current)
Sr. QA Analyst/Tester (Manual & Automation)
TASC (Total Administrative Services Corporation)
provides complete third-party administrative services
for nationally known products and services.
TASC's Microbusiness division offers tax saving services
such as AgriPlan and BizPlan (Section 105), as
well as planning services such as RetirEez (Ind 401k) and
Legacyguard (Estate Planning).TASC's group
division provides employee benefits administration,
offering products such as FlexSystem (Section
125 FSA), COBRAToday,ERISAEdge, DirectPay (HRA),
and RetireRite.
. Responsible for analysis of software requirements, review of
development documentation, creation and review of test
designs and procedures, and process improvements within the
QA department.
. Developed software quality plans, test design specifications,
and test cases for all MYTASC application www.tasconline.com
.
. Participated in risk management to help determine best use of
development and testing resources.
. Performed reviews of development documentation and test
procedures. Created process improvements by developing
document templates and implementing a formal documentation
strategy.
. Created Automation scripts by implementing the automation
framework using Selenium Tools for all
Products of TASC.
. Worked as QA lead for Financial Confidence project and
assisted all team members
. Ran test cases to find defects in Internet-based business
applications.
. Performed Regression testing for updated code and re-opened
Defects in Agile environment.
. Provided analysis, reports and status of all products in
test, bug trends, postponed bugs and milestone progress.
. Performed test planning for assigned areas; created test
cases; evaluated existing test case accuracy and coverage.
. Performed SQL data mining for new test data.
. Ensured test cases were updated with correct and appropriate
data, SQL queries and IDs.
. Participated in system testing and deployment validation.
. Conducted End-End testing manually.
. Provided sign-off for assigned functional areas.
. Logged defects in Bugzilla and worked proactively with the QA
Manager and developers to resolve any issues that inhibited
testing.
. Tracked outstanding defect reports and documented resolution
after successful testing.
. Identified regression test cases for future releases.
. Participated in Regression test case peer review and Authored
new "Regression-only" test cases
. Conducted mobile SMS notification testing for one of the TASC
product.
. Provided Daily and weekly written status reports to QA
Manager and Project Manager. Designed planning docs for
future use.
. Worked with customers to develop user acceptance tests for
Internet-based business applications.
. Conducted Integration, System, Functional, GUI, Regression,
Smoke, Database Integrity, User-Acceptance (UAT) and Adhoc
testing.
. Data verification was done extensively using MS Excel by
connecting to database.
. Conducted Performance testing to study the response times of
the application under stress.
. Updated the test build with lasted code on day to day basis.
Environment: Selenium IDE, Selenium Remote Control, Bromine,
WebLoad, HTML, Bugzilla, Java, JavaScript, JBoss, XML, MYSQL,
Windows XP Pro, MS Excel, MS Project, Visio, Core FTP, SVN.
Assurant Health, Milwaukee WI (Jun 06 - May 07)
Sr. QA Analyst / Tester
Assurant health is the leading source of health insurance for
individuals, families and small businesses. The system handles
complex health insurance information in an objective, user-
friendly format, enabling the research, analysis, comparison and
purchase of health insurance products that best meet consumers'
needs. It deals with a broad array of health insurance plans
with a selection of price and benefit options.
. Reviewed and analyzed SRS, HLD, LLD Specification.
. Developing and executing System Test plans and Test cases.
These Cases were developed after reviewing the business
requirements documents, and technical specifications
documents using Mercury Quality center.
. Performed Functional, Integration, System, Regression, smoke,
White and Black Box Testing by using Test Lab in Quality
center.
. Analyze and provided estimates for New Releases.
. Involved in writing UNIX shell scripts.
. Writing and testing complex SQL queries involving more than
three tables joins & getting explained to verify the SQL
performance and extensive use of TOAD.
. Checked the data flow and extensively used SQL Queries to
extract the data from the Database and used TOAD/ SQL
Navigator for verifying the tables in Database.
. Involved in writing SQL Queries using TOAD/ SQL Navigator to
validate the data.
. Verify and document defects/bugs using software-testing tool
Mercury Quality Center.
. Written Test Scripts using VB Script for automation of tests
using QTP
. Involved in data driven testing and regression testing using
QTP
. Tested and validated functionality of new screens for
customized applications.
. Experience in coordinating and leading the offshore team.
. Attended QA Walk through meetings with Team Member this
includes tech specs review, functional specs review and
defects tracking
. Generated test execution/defects reports from Test
Director/Quality Center and participated in weekly/daily test
execution status review meetings.
Environment: Mercury Tools (QTP 8.2, Quality Center 8.2),
Citrix, informatics, MS-Office, J2EE, Power Builder, VB,
VB.Net, Windows NT/Windows 2000/XP, Oracle, SAS, DB2, 3270 is
(Mainframe IBM), TOAD, WinSQL, SQL Navigator, Web Sphere, Unix.
Bank of America, DE(Jan 05 - May 06)
Manual Tester
Bank of America is a banking institution. BOA provides
customers with many options for managing
consumer credit card finances. Involved in various
projects like POE to DB2, BRAND, and MORE
(Marketing Optimization Revenue Engine). This Project
BOA Consumer card currently process on
SYS2 which provides unlimited balance categories at
the account level. In this project I involved various
applications like
POE (Product Offer Engine) - includes testing of
various modules like Cards, Sales, Plastics and Fees.
MBNAIS (Main Frame DB2) - Testing various modules like
Current activity, Statements, Standard &
Pricing, fee schedules, Promo Pricing.
E-Business - On Line Banking (OLB-
www.Bankofamerica.com) provides customers various options
like viewing Account activity, statements, Special
Offers, Bill pay choice, online disputes, Credit line
increase, Balance Transfers, Rewards and Year End
Summary (YES).
. Reviewed and analyzed SRS, HLD, LLD Specification.
. Developing and executing System Test plans and Test cases.
These Cases were developed after
reviewing the business requirements documents, and technical
specifications documents using
Mercury Quality center.
. Performed Functional, Integration, System, Regression, smoke,
White and Black Box Testing by
using Test Lab in Quality center.
. Create and Validate new Group codes, Associate banks, Source
codes for Major Credit cards
Amex, Visa, MC assign all the pricing, contracts and
Promotional offers using POE Application.
. Validates different screens Current activity, Statements,
Standard & Pricing, Fee schedules,
. Validates the welcome package for customers check letter,
letter only and disclosures for all the
Major credit Cards. I.e Amex, Visa, MC Accounts.
. Involves checking applications on various browsers (cross
Browser testing).
. Analyze and provided estimates for New Releases.
. Involved in writing UNIX shell scripts.
. Writing and testing complex SQL queries involving more than
three tables joins & getting
explained to verify the SQL performance and extensive use of
TOAD.
. Checked the data flow and extensively used SQL Queries to
extract the data from the Database
and used TOAD/ SQL Navigator for verifying the tables in
Database.
. Involved in writing SQL Queries using TOAD/ SQL Navigator to
validate the data.
. Verify and document defects/bugs using software-testing tool
Mercury Quality Center.
. Tested and validated functionality of new screens for
customized applications.
. Experience in coordinating and leading the offshore team.
. Attended QA Walk through meetings with Team Member this
includes tech specs review,
functional specs review and defects tracking
. Generated test execution/defects reports from Test
Director/Quality Center and participated in
weekly/daily test execution status review meetings.
Environment: Mercury Quality Center 8.2, Citrix, MS-
Office, J2EE, Power Builder,.Net,
Windows NT/Windows 2000/XP, Oracle, DB2,TOAD,SQL
Navigator,WebSphere, Unix.
State Farm Insurance, Bloomington, IL (Jun 04 - Dec 04)
Test Engineer
One of the US's largest personal lines property & casualty
company, State Farm offers a variety of insurance products for
individuals and businesses with its products ranging from
automotive, immovable assets, mechanical coverage, personal
lines, and commercial lines including reinsurance. Automotive
insurance forms a majority of State farms operation and revenue.
It involves maintenance of its customer information, policy
details, agent's information, premium tariffs, vehicle
information, history of their road accident, personal injury and
claims settlement including self and third party liability. The
application I tested provided users to access the State Farm
Mutual Funds and State Farm Insurance Products.
. Developed test plans, test cases, based on Business
Requirements, High Level Design, and Technical Specification
documents.
. Create QTP automated scripts for Quote, New Business,
Endorsements and submit to GTE (Global Test environment)
request for policy numbers.
. Review applications architecture and design of State Farm
Mutual Funds application.
. Performed System, Functional, and Regression tests.
. Developed data driven Automated Scripts and created reports
using Test Director
. Used WinRunner for GUI testing and to create user defined
functions to enhance test scripts
. Created several automated test scripts using WinRunner, which
includes data-driven tests and batch tests
. Design and execute the Automation scripts using QTP VB Script
based on the business scenario
. Developed and maintained Framework functions library using
VBScript.
. Create users, projects, defects, requirements using Quality
Center
. Upgrading WinRunner scripts to QTP VB Script
. Created functional interface Quick Test Script for State Farm
Mutual Funds and State farm insurance product modules.
. Designed, developed test cases and coded automation scripts
to test end-to-end applications as per Business Requirements
and complex product features using, WinRunner, Load Runner
and Quality Center for Functional Testing.
. Executed system, integration, end-to-end, and user acceptance
test (UAT) test cases for web-based and JAVA applications.
. Developed test execution plan describing important details
regarding how the test sets need to be conducted, organized,
and executed.
. Performed cross-browser testing using IE & Netscape.
. Performed Database Integrity testing using Oracle SQL*Plus to
ensure the data has been populated as intended and all
database events occurred properly.
. Participated in design walkthrough and review meetings.
Environment: Windows 2000, Quality Center, QTP 7.4/7.5,
WinRunner, LoadRunner, Java, XML, Web Applications, XML, MS
office, Oracle.