JOHNY A VATTATHARA |
| Certified Product Specialist(CPS)
-Mercury Interactive |
| Certified Quality Analyst(CQA) |
|
| vattathara@hotmail.com |
Summary
- Extensive experience in Automated testing tools. QA lead analyst with functional and
performance testing skills with the applications, using MS Windows, Oracle 7.3, Tuxedo,
WSD, Visual Basic, in client/server and UNIX environment. Experience in testing in CICS,
HP3000 with terminal emulators.
- Extensive experience in creating test plans and test cases with experience in
performance, unit, integration and regression testing with automated test tools like Rational
Suite, WinRunner, LoadRunner, QARun.
- Experience in Configuring test workstations, tool installation, maintenance and
mentoring.
- More than 7 (seven) years of IT experience in different organizations in Web, Client/Server,
Unix and Mainframe environments with clear understanding of Relational Database
Management Concepts.
- CPS,
Certified Product Specialist-From Mercury Interactive, Nov- 2000,
- CQA,
Certified Quality Analyst , from QAI Orlando Florida, year Nov-1999,
certification# 5589
- Received Performance recognition awards from various clients/companies.
___________________________________________________________________
| Present employer: |
· Spherion
Technology |
| |
|
| Years of experience: |
· Seven |
| |
|
| Industries: |
· Edward Jones(Banking
and Brokerage) |
|
· Tellabs
(Telecommunication ) |
|
·Blue Cross Blue
Shield(Health Care) · AOL(
ISP-Software ) |
|
· CIL ( Mining and
Exploration) |
|
· Monsanto
(Bio-Chemical) |
| |
|
| Applications: |
| ·Service Center |
·People Soft |
· AMISYS |
|
|
|
|
| · Titan5500 |
· LDAP |
· Tuxedo |
|
|
|
|
|
|
· AccountLink (on line
Billing, stock and portfolio) |
| |
|
| Operating Systems: |
| · Windows 95, 98 |
· UNIX , XENIX |
· Windows NT |
|
|
|
|
| · Windows 2000 |
· Windows XP |
|
|
|
|
| |
|
| Languages Known: |
|
|
| · SQL |
· PL/SQL |
· Visual Basic 4.0/5.0 |
|
|
|
| |
|
| Databases Tested: |
| · Oracle 7.3 |
· Sybase |
· Tandem |
|
|
|
|
|
| |
|
| Testing Tools used: |
· SQA
Suite6.0/Rational Suite 2001 |
|
| · WinRunner 6.02/7.0 |
· TestDirector 7i |
|
|
|
|
|
| · QARun 4.5.3 |
· LoadRunner6.5/7.02 |
|
|
|
|
|
|
|
· DataJunction |
| |
|
| Other Applications: |
| · MS Office Suite 97 |
· Business Objects4.0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Education
- Bachelor of Mechanical Engineering - University of Calicut -Kerala, India
- Post Graduate Diploma in Business Administration(PGDBA)- Annamali University, TN, India
- Diploma In Computer Application- Trichur Computer Center Pvt Ltd- Kerela- India
Professional Membership/Courses
- CPS, Certified Product Specialist- From Mercury Interactive Nov- 2000,
- CQA,
Certified Quality Analyst , from QAI Orlando Florida, year Nov-1999,
certification# 5589
- Vice President,
Toast Masters Club# 5705-8(Achievers), St.Louis, MO, USA
- Member,
St.Louis Quality Assurance Association (SLQAA)
- Member
, Institute of Engineers India (AMIE)
Project Experience (Last, First)
1 Monsanto – St.Louis Nov 2001 to Jan 2002
| Jump-started and lead the automated testing for their
Molbreed project and Successfully completed the automation of the "Snip Import
data" and "Snip Export" modules with Rational Robot. Molbreed project is an
application to enable the researchers (users) to import manipulate and analyze the
molecular breeding research information for their breeding projects. The application is
the build with Java applets, utilizes Corba Service and Oracle as the database. |
| |
- Identified system/tool/network/utilities and other supporting application requirements
related to the testing effort.
- Designed a Project test plan for the application
- Identified, defined and created test cases.
- Installed customized and maintained Rational Robot testing tools and other utilities
like Oracle Client, Toad, SQL/Plus etc
- Created number of Automated scripts for different modules.
- Created custom functions to work around tool limitations.
- Developed and implemented a general automation process and guide lines
|
Environment: Windows 2000, IE 5.0/5.5, Oracle 8.x, Corba, Java,
Tools used : Rational Suite Test Studio 2001A.04, teamtrak, SQL* Plus, TOAD
2- Edward Jones - St.Louis Nov ’99 to Nov 2001
- Received Performance recognition award from "Rich Melone" CTO of Edward Jones
- Received Performance recognition letter from Project manager of JIF Project.
| Actively involved in Functional and Performance testing of
various in house projects, at varying profiles. The testing environment consist of both
web and Mainframe . |
The list of the projects includes following:
|
1- Jones Communication Management System (JCMS) (Load
Test, Automated Functional Test), Lead the load testing effort of this application |
|
|
|
2-Service Request Web (Load Test), Lead the load testing
effort of this application |
|
|
|
3-TCA-Tarrot (Load Test) |
|
|
|
4-Canadian New Accounts (Load Test), lead the load testing
effort of this application. |
|
|
|
5-People Soft -Self Service (Load Test) |
|
|
|
6-Application - AccountLink, Bill Pay, (Automated
Functional test, Load Test) |
The level of involvement on above listed projects include following activities:
- Installed customized and maintained WinRunner, LoadRunner, TestDirector, operating
systems and other testing enabling utilities like, browsers, oracle client, Microsoft
office, etc.
- Designed and created a load test and functional test plans and helped building corporate
test plan templates.
- Identified the requirements, Designed and created test cases and helped in creating
corporate test case templates
- Designed multiple LoadRunner scripts (Vugen) with different protocols like Web, RTE,
Winsock for load testing different applications.
- Designed custom functions in ANSI-C to check the execution logs returned by the Vugen.
- Designed and executed a load test scenarios to analyze the application on different view
points, like maximum logins possible at a time, designed concurrent users, various
transactions response times under load.
- Documented the results, analyzed the different sets of runs and created reports.
- Created memory leak automated test script using WinRunner automation tool. By executing
the same scripts on different versions of the application, actual improvement in the
memory leak has been assessed.
- Designed an automated test suite for regression testing of AccountLink application,
created automated test scripts using WinRunner, and tested against each release.
- Created custom WinRunner functions to dynamically identify the web objects as a work
around for identification problems in the web GUI objects.
- Developed a compiled module for the purpose of keeping the user defined function for
easy use and maintenance
- Coordinated with application team to resolve and manage the testing issues and defects.
| Environment: |
Windows NT, IE 5.0/5.5, Netscape 4.5/ 4.7,CICS ,DB2,
Tuxedo, |
|
LDAP , JVM, telnet, Oracle 8x, People Soft |
| |
|
| Tools used : |
WinRunner6.02/7.0, TestDirector6.0/7.0,LoadRunner6.5,
DataJunction |
|
|
| |
|
3- Tellabs - Chicago Aug ’99 to Nov’ 99
Application - Titan5500/EMS-5500
- Received Performance recognition letter from Project manager of Tellabs,Titan5500
Project.
| Application is an telecommunication software called Titan5500, which has
got different features like Fault management, Configuration management, TL1 alarm
forwarding, Partitioning, Multilevel Security Management, Graphical multilevel topology
maps, Wizard utilities and dialog based bulk cross connection provisioning, with
distributed server architecture. |
| |
- Involved in Planning and automation of the Titan5500, application under test.
- Designed robust automated scripts for testing the above application with Winrunner5.5
and later with WinRunner 6.0
- Successfully scheduled the Automated unattended batch run through the TestDirector
- Automated and tested different conditions for managed objects( node, bay, shelf, card,
port, termination , cross-connection, etc.)
- Contributed 11 Automated scripts with WinRunner that covers 130 manual Test cases.
- Designed number of exception handlers to deal with special conditions and for work
around to cover WinRunner tool limitations.
|
| |
|
| Environment: |
Windows NT, MSSQL, Telnet, Titan5500 |
| |
|
| Tools used: |
WinRunner6.0, TestDirctor5.0 |
|
|
| |
|
4- BlueCross BlueShield Apr ’99 to Aug ‘99
Application -AMISYS
Involved in the Analysis, Planning, Design and test
execution for Y2K Compliance of the AMISYS application. This application consist of
different subsystems like: Provider, Provider Credentialing, Claims, Inquiry,
Correspondence Generator, Capitation, Phonelogs and Membership.
I was responsible for the testing of Provider, Provider Credentialing
and Correspondence Generator. These involves different activities like entering new
provider, Maintaining the provider affiliations through the Provider Credentialing
Subsystem and creating necessary correspondence through the Correspondence Generator
subsystem which help the organization by automating the letter generation and ID cards
through the Follow-up Subsystem. My testing responsibilities include of creating
following: |
| |
- Test Plan for the Subsystems
- Creating Date Inventory Spread Sheets
- Creating Test Matrix documents
- Creating the Test Coverage Document for the purpose of Sign-offs and Technical
Walkthroughs
- Developed customized Test Case Template for the Application under test
- Created Test Cases for all the business functions that are date related.
- Captured and created the Automated Test Scripts and modified the scripts for the
different interfaces for application with QARun and WinRunner.
- Used the PR-Tracker for reporting and documentation of the bugs and defects.
- Performed unit and integration test for the Subsystems
- Performed User Acceptance Test .
|
| |
| Environment: |
HP-3000,VT200 Emulator ,AMISYS |
| |
|
| Tools used: |
QARun, PR-Tracker, Suprtool. |
5- America On Line (AOL) July ‘98 to Apr ’99
Revenue Billing and Member systems
| Working as a Tester /Analyst for their Online Test System
for the Internet applications in different servers and Mainframes such as UNIX, Sybase,
Tandem, Stratus and Telnet for connection. The testing has been accomplished mainly using Manual
Testing , WebTrak. This is the system to test the total billing activities of
the AOL. As per the QAR (Quality Assurance Request) from the production, I have built the
QAR to the appropriate level in the test system according to its severity. Built the
scenarios, test plans test cases for testing. Reported the test result through Webtrak,
and clearing it for production. |
| |
- Performed testing for different Transactions and Modules
- Documented the Testing Procedures
- Designed the Test cases and Test Procedures for the module under test
- Performed Business Functionality testing which involves verification of business rules
- Performed Unit ,Integration and Acceptance Testing BUSY system
- Analyzed the defect found during testing
- Load testing for the performance of the servers and response time
- Coordinated with developers for fixing the bugs
- Modified the Scripts executed and created the new scripts as per the requirement of
testing
- Generated test reports on the application and modules tested
|
| |
|
| Environment: |
Unix, Sybase, Tandem, Stratus and Telnet |
| |
|
| Testing Tool: |
Manual Testing , Webtrak, WinRunner |
6-C I L ( Coal India Ltd ) May ‘94 to Dec. ’97
As a QA tester I was responsible for the quality and
reliability of various modules and applications, included in "INTEGRATED
MINE MANAGEMENT SYSTEMS (IMMS)"which involve Manual and Automated
Testing. The main modules tested are "Inventory Management and Purchase
Integration" |
| |
- Created Test Plans , Test Requirements, Project specifications and Test cases
- Created Shell Procedures and Test Suits
- Designed and executed the test strategy for checking the reliability of the software and
- user requirements Documented the testing results
- Involved in making and maintaining industry standards, Project Specifications and
- Test Requirements.
- Designed the Test cases, Test procedures and created the Shell Procedures.
- Performed the Unit , Integration , regression and Acceptance testing
- Analyzed ,tracked and made Reports on Application under test
- Coordinated with the developers for Bug fixing
|
| |
|
| Environment: |
Visual Basic 4.0, Oracle C/S, Windows NT, XENIX |
| |
|
| Testing Tools: |
SQA-suite, Windows NT, SQA-Manager |