Manager Project
Resume:
Prashanth R Palvai
*********@*****.***
[pic]
PROFESSIONAL SUMMARY
. Over 7+ years of experience in the software development life cycle (SDLC)
with roles involving Requirement & System Analysis, Design, Development
and QA of Mobile applications.
. Scalable knowledge in testing of Healthcare, Real Estate, Insurance,
Financial, Pharmaceutical, Utility billing applications in different
operating systems
. Experience in end to end testing of Internet/Intranet applications,
Client server applications, and database query applications using front
end technologies.
. Experience in Middle and Batch office security processing with
Mainframes, which includes automatically processing transactions,
covering different financial operations.
. Worked using and have a good knowledge of all the testing methodologies
like Agile, Waterfall method, Rational unified process etc
. Experience with writing documentation, providing user updates, chairing
status meetings, monitoring project timelines and deliverables, writing
and executing system test cases, tracking defect resolutions
. Experience in data warehouse testing, ETL tools like informatica. Testing
reports generated by Business objects, crystal reports and has a thorough
understanding of business intelligence solutions.
. Excellent experience with Oracle database, Sql server database,
DB2/Mainframes, proficient in querying databases with SQL queries and
also experience with manual functionality testing, black box testing in a
distributed environment.
. Experience in manual testing as well as automated testing by using test
management tool like Quality center and several automated tools like Win
Runner, Load Runner, Quick Test Professional, and all Rational Tools.
. Experience in Establishing QA Procedures to meet QA Standards, proficient
in writing Test Plans, Documenting the Testing Procedures and writing in-
depth Test Cases to meet the Testing life Cycle
[pic]
TECHNICAL SKILLS
Operating System Windows 9x/XP/NT/2003 Server
Web Technologies IIS6.0, ASP, ASP.NET, HTML, Java Script, VB
Script
Database Technologies SQL Server 2000/2005
Reporting SQL Reports, SSRS
[pic]
PROFESSIONAL EXPERIENCE
[pic]
PROJECT 01
Title Sr QA/Q.T.P Analyst
Client Citigroup Inc
Team Size 8
Environment Quick test professional 9.2,Multi test manager,
Quality center 9.0, IBM DB2, UNIX, Java, HTML, XML,
MS-Office, MS-Project.
Responsibiliti ?Acted as a lead role and strong manual testing
es experience in converting trading systems like Multi
funds, Transfer agency
?Acted as a lead role in writing test cases for all
Multi-funds suites including Equities, used Multi
test manager for batch run
?Exclusively used Q.T.P tool and programmed all the
Multi funds applications, also used Multi test
manager for batch run.
? Exclusively tested all the browser versions
including Internet explorer, Firefox and Safari etc
?Extensively worked on search technology applications
dealing with Foreign Equities, Regular equities,
Option on stocks etc.
?Exclusively recorded and analyzed tests, created
checkpoints, parameterized tests, created output
values, using regular expressions, divided tests into
multiple actions etc.
?Efficiently worked with object repositories,
exception handling by using recovery scenario
manager, automation object model etc
?Performed Data Driven Testing using QTP, database
testing with QTP and running SQL queries.
?Performed business process testing with QTP and also
with Quality center, involved in preparing test
scripts at the early stages.
?Performed descriptive programming of VBScript using
QTP, worked with excels objects using QTP
and validated text files using QTP.
? Used QTP for handling Active-X controls, running
QTP scripts from rational test manager, used
Documentum to report data.
? Tested data reports using QTP, called external
built-in functions using QTP etc.
( Developed data entry scripts using Quick test
professional 9.2, connected it to Project tracking
system used in Citigroup Inc
( Verify Actual results against Expected results
investigate discrepancies, written manual TSL Scripts
and report any defects in the Quality center
( Executed test scripts, participated and reported
any problems, automated test scripts using Q.T.P 9.2,
Troubleshoot new releases and production issues.
Duration August - 2008 to Present
PROJECT 02
Title SR QA Analyst
Client Jackson National Life Insurance
Team Size 5
Environment Quick test professional 9.2, Auto-sys, Quality center
9.0, T.S.O, IBM DB2, UNIX, Java, HTML, XML,
MS-Office, MS-Project.
Responsibiliti ( Acted as a Team lead in strong manual testing
es Vantage to Cyber life conversion project for all QA
release modules
( Involved in developing several regression scripts
for Mainframe applications connected to Cyber life
mainframe databases using Quick test professional
9.2.
? Excellent proficiency in testing applications using
Linux/Unix, tested Client server applications with
Ruby, Fitnesse
( Acted as Q.T.P programmer to script insurance
applications, also have performed batch running in
Service oriented architecture
( Accessed T.S.O (Mainframes) to view all the
database tables of Mainframes holding all the policy
information, downloaded several database tables to
prepare test data.
( Responsible for interpreting, developing and
implementing operations, tested operations using TSO
(Time sharing option) when multiple users are online,
executed SQL queries.
( As a Team lead in Vantage to Cyber life Conversion,
reviewed all the policy data in the Mainframes to
find out what tables from Mainframe database are used
for conversion.
?Exclusively performed data quality tasks for
business intelligence like using SQL skills,
implementing and maintaining the tools required for
data warehouse testing etc.,
( Involved in developing regression scripts using
Q.T.P 9.2 for Requirement management systems
connected to our new business desktops used by
Jackson National Customers.
? Exclusively used IBM Lotus notes to exchange server
E-mails, calendaring activities etc
( Actively participated and overseen SDETs testing
process in the individual sub-projects dealing with
core java framework.
( Acted as a UAT tester in implementing web
2.0-technology access to our insurance application
using service oriented architecture.
? Acted as a senior developer in correcting several
application script issues relating to Q.T.P, tested
their performance by using Load runner 9.0
? Used Load runner to execute software test plans,
maintain automated test tool scripts, utilities etc,
maintains the adherence to the standards.
Duration July - 2007 to July- 2008
PROJECT 03
Title SR QA/Performance Analyst
Client Progressive Insurance
Team Size 5
Environment Quick test Professional 9.0, Quality center 9.0, IBM
Lotus notes, IBM DB2, Rational functional tester,
Visual source safe, Load runner, ASP.NET, C#NET, Vb
script, UNIX, Java, HTML, XML, SQL Server
2005,MS-Office, MS-Project.
Responsibiliti Followed agile principles strictly to emphasize
es communication with our testing teams and project
managers, developers, business analysts for efficient
software development.
Communicated and compelled analysis with all the
members of the team including the developers,
business analysts using Spot fire professional.
Excellent proficiency in cross browser testing with
all the browser versions including IE, Firefox,
testing using Ruby and Fitnesse
Involved in testing regular builds and also the
builds which are in the form of XML files.
Exclusively used IBM Rational functional tester for
performing the functional testing activities for all
COBOL builds in mainframes containing policy data.
Extensively tested applications developed with C++
and C # for all insurance modules, executed T-SQL
Queries to view and validate the insurance data.
Executed all the test life cycle, documented the
successful or unsuccessful completion, defects raised
and each test condition in the Quality center 9.0
scripts Repository.
Carried out extensive testing with Quick Test
Professional 9.0 by using different test cases, which
reflects the various real time business situations.
Developed automated VU scripts using Load runner 9.0,
tested Internet/Intranet and Client server
applications.
Used Load runner 9.0 for managing, monitoring and
executing performance characteristics by simulating
the real users and creating some virtual users.
Acted as a senior developer in correcting several
application script issues relating to Q.T.P, tested
their performance by using Load runner 9.0
Used Load runner to execute software test plans,
maintain automated test tool scripts, utilities etc,
maintains the adherence to the standards.
Also acted as a UAT tester for all the insurance
modules integrated with the mainframes having
underlying policy data, deeply involved in project
management activities.
Integrated Load runner 9.0 with Mercury Interactive
Win Runner 9.2 for pulling scripts and performing
functional testing.
Duration May - 2006 to June- 2007
PROJECT 04
Title Sr QA/ETL Tester
Client Sutter Health Insurance
Team Size 6
Environment Q.T.P 9.0, Quality center 9.0, MS-Project,
MS-Office,Informatica, Java, PL/SQL, Microsoft SQL
Server, HTML, XML, Linux, Web Logic.
Responsibiliti Understood the responsibilities and importance of all
es the health care activities especially through testing
activities like health insurance modules, claims
transfers etc.
Extensively interacted with the managers, tested
payroll software, performed verification & validation
for application networks, tested Sutter health claims
software.
Excellent proficiency in testing applications using
Linux/Unix, Networking in Service oriented
architecture.
Exclusively followed the (RUP) adaptable framework,
also captured health care data using document capture
tool captiva.
Executed Test plans from requirements, functional &
technical specifications, performed manual testing,
and triggered testing errors of Sutter health systems
in Quality center 9.0.
Extensively involved in presentation program to
explain the functional features included in merging
ETL Informatica tool with Quick test professional.
As a QA Tester responsible for the creation and
execution of manual/automated test scripts using
Q.T.P 9.0, Oracle database testing and network
interface testing.
Used TOAD extensively for querying the Oracle
database, tested whether the data is accessed by
doing Client server testing.
Tested whether 'Doctors' can access all the
information from the SQL Server database, tested
modules dealing with chemicals.
Regularly used SSAS data sources in SSRS by dragging
and dropping data in OLTP databases and pulled it to
Excel sheets for analysis.
Exclusively worked on Cygwin software to test various
library functions.
Also involved in the roles of User acceptance testing
by keeping in mind the Sutter health business
requirements and verifying them.
Documented Defects found during test after performing
automation testing with Q.T.P 9.0 on the Quality
center and communicated recorded problems to the
responsible QA.
Duration Feb - 2005 to March- 2006
PROJECT 05
Title Data warehouse Tester
Client Wells fargo
Team Size 6
Environment Q.T.P 8.2, Win runner, Test director, Rational clear
case, Java, HTML, XML, MS-Office, Java Script, Oracle
9i and Windows 2003.
Responsibiliti As a team member I was involved in writing test
es plans, creating test cases ensuring that the
developed software performs as detailed by business.
Followed Agile principles strictly and all the
project implementation revolved around the agile
iterations, performed manual testing for all
applications.
Experience in testing accounting systems related to
taxes and debt-resolving applications in Service
oriented architecture.
Involved in conversion process for mortgage service
platform applications, good hands on knowledge in
testing mortgage apps.
Exclusively took part in testing underwriting
mortgage applications.
Efficiently involved in testing Mutual savings
systems and Treasury systems to initiate whether
efficient savings are invoked for Wells Fargo
customers.
Worked on various transformations like look up,
expression, update strategy, filter and router
transformation for various credit card data sources.
Extensively used Informatica to automate the
manipulation of the savings, checking accounts data
and used same to test the data in wells Fargo data
warehouse.
Extensively used the Data mining concepts in the
Wells Fargo to establish the relationships among the
Hedge funds, loans processing's, credit card
payments.
I have generated some transaction reports related to
Institutional Mortgage accounts using the Cognos,
compared with the reports generated on daily basis.
Performed Black box testing and White box testing and
logged the defects found while testing informatica
workflows with Q.T.P 8.2 in test director management
tool.
Prepared Test Data for Positive and Negative Testing
with Data Driven framework for some modules related
to consolidated Brokerage accounts.
Maintained and reviewed all versions of the
application by using the rational clear case, tracked
the defects found while testing Cognos reports using
Q.T.P 8.2 in Test director.
Verified the transactions occurring while submitting
the brokerage account details to the account
management system, tested the account management
system with Q.T.P.
Performed database testing and also used reporting
tool Cognos for verifying whether the pricing and
analytic reports are in proper order, executed SQL
queries for validation.
Analyzed user requirements, acted as a senior UAT
tester in all testing activities for ETL.
Attended the Walkthroughs with the Business Analysts,
interacted with the Developers and other Team Members
to proactively build up a good knowledge of
application.
Duration March - 2004 to Jan- 2005
PROJECT 06:
Title QA Tester /DB2 Mainframes
Client Home store, Inc
Team Size 6
Environment DB2/Mainframes, UNIX, Windows NT, Rational robot,
Clear Case, Clear Quest, ASP 2.0, VB6.0, Oracle 8,
PL/SQL, HTML, ADO, IIS 4.0, VB Script, Java Script,
Apple Mackintosh operating systems
Responsibiliti As a team member Involved extensively in Manual web
es testing, Black Box testing, Integration, System, Load
testing and Captured requirements.
Extensively done the system testing & testing
communication networks.
Exclusively tested on modules like SAP/R3 (MM, PP),
or other and also applications related to enterprise
content mgmt systems
Excellent proficiency in testing applications using
the web services and SOAP and also tested the layers
integrating them. .
Tested the Enterprise content applications programmed
with COBOL, which are developed to store Home store
customer details
Back end testing was done to verify and validate data
and Data verification for DB2/Mainframes; data
integration test was done using SQL queries.
Tested various text-hyperlinks, image-hyperlinks of
all pages and tested the functionality of different
screens in some e-commerce applications.
Performed extensive regression testing by using
rational robot, generated VU scripts by using the
rational robot for testing the performance issues.
Used rational requisite pro to provide detailed
traceability views and display accurate parent/child
relationships, maximized the informative value of
each requirement.
Participated in Walk through of test plans and test
cases and written day-to-day activities in
configuration management tool.
Consultation with end users and customers to develop
solutions to meet business needs and new business
requirements.
Duration Jan - 2003 to Feb - 2004
PROJECT 07:
Title QA Telecom Tester
Client At & t
Team Size 6
Environment Java, JSP, HTML, Apache, UNIX, Perl, Oracle, Windows
NT, Sybase, SQL, Bugzilla, Test Director 7.0, Load
Runner 8.1.
Responsibiliti Developed detailed Test Plan and Test Cases against
es the requirements for testing the telecom application,
tested the telecom billing.
Extensively tested some gaming devices used in
T-Mobile, also tested and verified chemical embedded
devices.
Extensively have IVR experience as a part of my
testing methodologies, tested Amdocs apps.
Involved in testing the various network & Ethernet
protocols, this forms the major part of Internet
protocol suite including SNMP, SMTP, participated in
firewall testing.
Performed cross browser testing for multiple
browsers, e.g., Netscape Navigator, Microsoft
Explorer, tested embedded devices.
Writing new and modify existing scripts/programs used
during the installation and testing processes for
different Servers and Gateway API's using shell
scripts in UNIX.
Defects were tracked, reviewed, analyzed & compared
for frame relay, SOA Architecture using Rational Test
Manager, tested applications integrated with audio &
video formats.
Have tested the modules integrated with people soft
CRM technologies and incorporated a bunch of Unix
commands in a shell script & executed it.
Involved in Load Test Planning using Task
Distribution Diagram and Transaction Profile
Documents, verified testing activities for IVR
Systems.
Created load scripts using the virtual user
generator, created Scenarios and virtual users using
Load Runner Controller.
Monitored various scenarios using Web Server
Resource, Web Application Server, Database Server and
Network Monitors.
Duration Jan - 2002 to Nov - 2002
EDUCATIONAL QUALIFICATIONS
[pic]
Graduated in B.E (Electricals & Electronics) from Madras University in 1999
[pic]
Contact this candidate