Priyanka Bhupathiraju
Mobile: 408-***-****,
acf8wa@r.postjobfree.com
[pic]
CAREER SUMMARY:
o A Passionate QA Tester with over 6 years of experience, Specialized in
Software Quality Assurance and Implementation of QA Methodologies on
SOA, Client-Server and Datawarehousing Applications and extensively
worked in Mortgage, Banking and Healthcare domains.
o Experience with the Software Development Life Cycle (SDLC) and Software
Testing Life Cycle (STLC) in both Manual testing and Automation
testing.
o Experience in analyzing the Software Requirement Specifications,
development and execution of Test Plans, Test Scenarios, Test Cases,
Test Scripts and result analysis.
o Extensive experience in Smoke, Black Box, Grey Box, Functional, System,
End-to-End, Regression, GUI, Back-end, Browser Compatibility, Load,
Stress and Usability testing of the applications.
o Experienced in the use of Quality Center, Test Director, Clear Quest
for writing test cases, test execution, defect management, defect
tracking and Reporting.
o Proficient in using both Manual and Automated testing tools such as HP
Quick Test Professional, Load Runner and Test Director/HP Quality
Center/Application Life Cycle Management (ALM).
o Experienced in creating Requirement Traceability Matrix (RTM) to ensure
comprehensive test coverage of requirements and Test Summary Reports.
o Good understanding of UNIX file system and Shell Scripting.
o Involved in Backend testing, writing and executing SQL Queries.
o Experience working in Webservices testing using Service Oriented
Architecture tools like SOAP UI Pro.
o Experience in Data Warehousing/ETL Testing within the environment of
Oracle, SQL Server, Informatica PowerCentre 8.6 (Repository Manager,
Mapping Designer, Workflow Manager, Workflow Monitor).
o Working knowledge in RALLY, JAWS and 508 Complaince.
o A Strong believer in Process, When I joined WebLabs Technologies, I saw
the work was ad-hock and there wasn't any standard software testing
process. I took initiative building a standard software testing process
that fits our project needs. By this streamlined process we managed our
time effectively and started concentrating more on main software
testing tasks.
o Serve as a Value adding member in the team.
o Enjoy learning new tools and technologies.
TECHNICAL SKILLS:
Testing Tools: Application Life Cycle Management(ALM), Quality Center 9,
Loadrunner 9, Quick Test Pro 10, SoapUI Pro 3.6.1, Test
Director, Rational Test Manager, Clear Case, Clear Quest,
Rational Quality Manager, Microsoft TFS, JIRA, Altova
XMLSpy 2008.
Reporting Tools: Microstrategy, MS Word, MS Excel, Informatica 8.6.
Operating Systems: Windows (XP, 2007, 2008), Unix, Linux.
Languages: C/C++, Java, VBScript, HTML, XML, C#, Ruby, Python.
Databases: Oracle, MS SQL Server.
Browsers: Mozilla Firefox, Microsoft Internet Explorer, Safari.
Methodologies: Agile, Waterfall, V-Model, Scrum.
Industries: Mortgage, Financial, Healthcare, CRM.
Other Tools: MS Visio, RALLY, DOORS, Visual Source Safe, Rational
Requisite Pro.
PROFESSIONAL EXPERIENCE
Client: Bank of America, Charlotte, NC
November 2013 - Present
Role: QA Analyst
Project: Community Reinvestment Act Reporting and Monitoring (CRAMR)
The Banks are expected to lend under the CRA to meets the
needs of the community (including low and moderate income neighborhoods).
The bank is required to provide the information of the lending done by them
under CRA to the regulator. This should be in a standard format and clearly
state the loans granted by them for community development and home mortgage
lending. The regulatory authority is required to apply Lending, Investment
and Service test to evaluate the performance of the Bank. Each of these
tests is designed to assess the performance of the bank in different
areas.
Responsibilities:
o Created Test plan and effort estimation based on the scope and
schedule of the project.
o Worked in Agile-SCRUM model, involved in the Daily SCRUM meeting,
KANBAN and other Processes.
o Analyzed User Requirements and Functional Specifications to create
Test cases and procedures for System Testing.
o Prepared ETL test cases with SQL Queries and executed the same in
TOAD.
o Prepared Micro Strategy report test cases for format and data
verifications.
o Extensively used Quality Center to write Test Cases, build Test Labs
and for reporting defects, all the Scripts were maintained using
Quality Center.
o Performed System, Functional, Integration, Smoke, Database,
Performance and User Acceptance Testing.
o Performed all phases of End to End Testing which includes Regression
Testing, Black Box testing .
o Executed various UNIX Shell Scripts for scheduling various data
cleansing scripts and loading process.
o Performed Verification, Validation and Transformation on the Input
data (Text files, XML files)in the Landing database before
transforming, loading data into target database.
o Ran the Extraction, Loading processes and monitored sessions using
Informatica Power Centre Workflow Manager and Workflow Monitor.
o Responsible for the validation of Target data in Datawarehouse and
Data Marts which are transformed and loaded using Informatica Power
Center using the Mapping document.
o Reports are tested by validating the Layout, data in the report and
calculations.
o Compared the report data against the Data retrieved from the data
base.
o Compared the format of the report against Report Format Guidelines
given by CRA.
o Maintained the Requirement Traceability Matrix and ensured the
coverage of the test cases.
o Ensured all the test artifacts are uploaded in the Visual Source Safe,
a Configuration Management Tool.
o Created and updated the Test Execution Matrix and Defect Matrix.
o Involved in Test status meetings to get the regular updates from the
team.
o Provided regular status updates to Project Manager on high priority
issues and testing progress.
Environment: Quality Center, Load Runner, TOAD, Informatica, Micro
Strategy, Visual Source Safe, UNIX, SQL Windows XP/NT, Oracle, Java, HTML,
JavaScript, Servlets, MS Office, Autosys, XML.
Client: LendingTree, Charlotte, NC
April 2013 - October 2013
Role: QA Analyst
Project: Loan Refinancing Calculator Application
LendingTree's mortgage refinance calculator was created to help the
customers compare their current mortgage to available rates and programs.
It's a way to find out if refinancing today can help them achieve their
goal-whether it's a lower monthly payment, a faster loan payoff or trading
an ARM for a fixed loan.
Responsibilities:
o Analysed requirements and prepared Test Plan and high level Test
Scenarios.
o Involved in SCRUM meetings with the development team and SME to
understand the Business Requirement Document Workflow of the application
and created test data for various test cases.
o Wrote test cases for Functional test, User Acceptance test and created
performance test plan for performance testing.
o Executed Manual Test cases as a part of Regression suite in Mercury
Quality Centre.
o Validated Request and Response XML using SOAP UI Tool.
o Created Test Suite, added assertions in SoapUI tool to validate the
response XML.
o Performed Data Validation testing using SQL queries.
o Checked the data flow through the Front-end and Back-end and extensively
used SQL queries to extract the data from the database.
o Used QTP for Functional and Regression testing.
o Created Automation Scripts (VBScript) in the sprints and stored them in
the Test-Plan module of Quality center.
o Performed extensive Negative Testing to determine the stability of the
application.
o Involved in extensive interaction with users to define acceptance
criteria.
o Adopted Data Driven Methodology to test the application with different
sets of data
o Supported Capacity and Performance test automation specializing in front-
end (UI), webservices(middleware) and back-end (batch/data transfer)
performance testing approaches.
o Created Vugen scripts for Load and Performance testing to verify
Throughput, Capacity to ensure that performance meets or exceeds previous
performance benchmarks using Load Runner.
o Used Load Runner Analysis tool to analyze the response times of the
business transactions under load.
o Configured Run-time settings for VUser Generator, Controller, Run-time
settings for Action / Think-time into LoadRunner.
Environment: HP Quality Center 9, HP Quicktest Professional 10, PVCS, SQL,
UNIX, HP Load Runner 9, Altova XMLSpy, Performance JVM, Java, SOAP UI Pro,
JDBC, ASP.NET, SQL Server, UNIX, Tomcat Apache, HTTP, Weblogic and Windows
2007
Client: State Farm Insurance, Chevy Chase, MD
June 2012 - March 2013
Role: QA Analyst
Project: Online Customer Access Application
This is an online Web Based Application providing Insurance and Financial
Services to the customers. This application has several modules like
Homeowners, Life, Claims and Auto Insurance modules. My involvement in the
project was testing the Auto Insurance Model. This online application
enables customers to register online, access their accounts to Pay
insurance bills, view their insurance policies and quotes. With this
application a potential customer can also get a quote without being
required to register.
Responsibilities:
o Wrote detailed Test Cases based on Project Artifacts such as Business
requirements, Functional Specifications and Mock -Ups.
o Extensively used Quality Center to write Test Cases, build Test Labs and
for reporting defects, all the Scripts were maintained using Quality
Center.
o Extensively used QTP as the Automation tool for Functional and
Regression testing.
o Participated in the identification and prioritization of the Test cases
for automation.
o Wrote Automated Test Scripts for Regression Testing using Quick Test Pro.
o Defined test automation framework including Data Driven automation,
Keyword Driven automation, User interface and non-UI based automated
testing.
o Developed Automation scripts in Quick Test Professional to perform end-to-
end testing and created a set of re-usable scripts.
o Used Synchronization point using Quick Test Pro to synchronize QTP with
the application.
o Enhanced Scripts using Checkpoints namely Text Checkpoints, Standared
Checkpoints, Database Checkpoints and Parameterization and implemented
Data Driven Testing with QuickTest Professional to test application with
different sets of data imported from the external Excel Sheets.
o Captured certain table elements using the WebTable Class in QTP.
o Performed Functional testing using Quicktest Professional to leverage
Descriptive programming skills and there by attaining increased
productivity.
o Ran the Automation Scripts in the Batch for the Smoke and End-to-End
Regression testing using the Record and Playback options.
o Used the Recovery Scenario in Quick Test Pro.
o Performed extensive Negative Testing to determine the stability of the
application.
o Executed the developed tests both before and after defect fixes as a part
of regression testing.
o Conducted meetings with the end-users in order to establish guidelines
for UAT. Guidelines included specification of necessary screen
components, appropriate message boxes and proper use of colors.
o Performed the Browser compatibility testing using different browsers
using Browserstack.com.
o Performed Data Validation testing using SQL queries.
Environment HP Quick Test Professional 10, HP Quality Center, Oracle, SQL,
Win NT, VB Scripting, Load Runner, MS Excel, HTML, HTTP, HTTPS, C#, .Net,
IE, Firefox, Safari, SQL Server.
Company: Client Network Services INC
June 2011 - May 2012
Role: QA Analyst
Project: Washington State Medicaid Management Information System.
Washington State Medicaid Management Information System is a Web based
Medicaid system for the Department of Social and Health Services (DSHS) of
the State of Washington. It is a Claims Processing Web application that has
complex numerous subsystems that are interfaced together to work
coherently. MMIS system as a whole has Provider, Claims, Financials,
Payroll, Drug Rebate, Reference, Prior Authorization, etc as subsystems in
DATAWAREHOUSE ENVIRONMENT, where it is for different types of Providers to
enroll themselves and DSHS worker will have access to them to verify and
approve the records.
Responsibilities:
o Involved in specifying test requirements from User Acceptance Criteria
and User story, converting requirements to tests, designing test steps
and generating test templates.
o Used DOORS as the Requirement Management tool to optimize requirements
communication, collaboration and verification throughout the
organization.
o Created Test Plans, Test Cases and Test Specification Document for the
application under test (AUT). Created test data for testing specific
billing functionalities.
o Validated the Data loading to the landing Database through the
Incremental Loads.
o Wrote SQL Queries to extract data from various database tables for
testing purpose in TOAD.
o Extensively worked on VBscripts in analyzing the business processes and
created ?automation scripts for Claim Processing and Void Claims,
Resurrect and Resolve claims Modules.
o Used automated scripts and performed functionality testing during the
various phases of the application and analyzed the results using QTP.
o Wrote VB Script, developed Custom Functions, Dictionary Objects and used
Descriptive Programming by QTP.
o Performed data driven testing, designed Text Output Value check points to
validate the data.
o Executed automated or manual tests, documented results and updated defect
tracking systems.
o Used Clear Quest for repository, reporting bugs, tracking bugs and
updating the resolved bugs.
o Developed Traceability Matrix and Test Coverage reports.
o Managed and conducted System testing, Integration testing and Functional
testing.
o Worked on SQL scripts to load data in the tables.
o Worked on Mainframe files. Used Mainframes for the daily data from the
production to Target environments.
o Validated the data movement and transformations are done correctly.
o Prepared Status Summary reports with details of executed, passed and
failed test cases.
o Participated in regular project status meetings related to testing.
o Used Clear Case for Version Control. Each version of the application is
stored in Clear Case and necessary modifications, updates and analysis
has been done.
o Text checks and Image checks were written for correct responses. Created
Data Driven tests by using CSV Indexed files. Generated Data Driven
scripts that access the backend database.
o Regression Testing is performed and the additional scripts are generated
for each version.
o Extracted Files from Mainframes (flat files) using Shell script in Unix
Server (Putty), and was also involved in FTP process.
o Analyzed data mapping documents for data coming from different database.
Tested interfaces for data loading from source systems. ?
o Performed Smoke Test for validation of results in Target Tables.
Environment: Quick Test Professional, Rational Clear Case, Rational Clear
Quest, XML, IBM CDC, ?Unix Shell Scripting, UNIX AIX 5.3, Autosys 4.0,
Rapid SQL Navigator, ?Windows XP, Informatica 8.6, Mainframes OS, WINSCP,
TOAD, DOORS, MS Excel, MS Word.
Client: Citibank, New York, NY
November 2010 - May 2011
Role: QA Analyst
Project: Orbit Lending System
The Orbit Lending System was a complete Web-Based Application to track and
manage Citibank Mortgage products. The major functions included giving
customers access to their current mortgage status, taking and managing
mortgage payments, late payment alerts and notifications, and direct-
deposit options. ?
Responsibilities:
o Involved in review meetings with the Project Managers, Business
Associates and developers for Test Planning, Coordination and
implementing various QA Methodologies.
o Performed analysis of Technical Specifications and Business
Specifications and created Test Plan and Test Cases for the application
in Quality Center.
o Participated in Design review, code reviews and test review meetings to
identify bottlenecks in the system.
o Stored test requirements and test cases in Quality Center.
o Manually executed the test cases to perform functional testing of the
application.
o Tested the functionality of each scenario like positive and negative
testing to monitor proper navigation flow of the application.
o Conducted Manual testing for checking functionality, security and
performance during various phases of the development of the online
application.
o Performed Front-end Integration testing with back-end Oracle database by
passing SQL queries.
o Involved in creating Requirement Tracebility Matrix (RTM) upon reviewing
Business requirement Documents, Technical Specifications and Test Cases.
o Logged the defects and tracked the status and reported using Quality
Center.
o Interacted with developers to report software bugs and re-tested the
fixed issues.
o Performed Browser Compatability testing for the application.
o Developed and submitted the Test status reports to the QA Manager.
o Prepared and documented the Test Artifacts.
?
Environment: HP Quality Center 10, Window NT/2000, SQL, Oracle 8i, TOAD,
UNIX, Java/J2EE, JSP, Java Script, HTML, MS Excel.
WebLabs Technologies, Hyderabad, India May 2008 - October
2010
QA Tester.
WebLabs Technologies is a Web Designing Company in India. I was completely
responsible for the testing activities in the Web Design Vertical.
Responsibilities:
o Reviewed and verified the Business / Functional requirements and
identified the Test scenarios as per the requirements.
o Created Test Cases as per the requirements and Use cases in MS Excel.
o Test Cases are prepared based on the Boundary value analysis and
Equivalence Class Partitioning.
o Performed manual testing and maintained documentation on different types
of testing like Positive and Negative testing.
o Extensively involved in Smoke, Functional, System and Regression testing.
o Collaborated with the clients for clarifications and worked very closely
with development teams on issue resolution.
o Performed User Acceptance testing in the final phase of software
development process to check the functionality of the software.
o Tested the application on different browsers as a part of the
compatibility testing to maintain Cross- Browser functionality.
o Prepared Defect Reports and responsible for assigning the defects to
developer.
o Served as the point of contact for the entire test related activities.
o Ensured smooth delivery of the project.
Environment: Window NT/2000, SQL, Oracle 8i, TOAD, UNIX, Java/J2EE, JSP,
Java Script, HTML, CSS, MS Excel.
EDUCATIONAL DETAILS:
Bachelor of Technology in Electronics and Communications - Jawaharlal Nehru
Technological University, India.
Masters in Business Administration in Human Resources and Marketing -
Pondicherry University, India.
[pic][pic][pic]