VENKATA RAMA SATISH NYAYAPATI
*********@*****.***
PROFILE:
** *****’ Software Testing experience: manual as well as automated testing; more than 6 years’
experience in leading teams
Currently working as a Testing Lead for an Oil & Gas client
Sound knowledge of Software Development Life Cycle and Software Testing Life cycle.
Experience in various stages of software testing such as Requirement analysis, Test estimations, Test
planning, Execution, Defect reporting and tracking, reviewing test artifacts, UAT support
Experience in Automated Testing:
7 years’ experience in functional software automation testing tool Quick Test Professional, HP
Functional Testing which includes working on various applications like windows, web based,
client server and ERP applications SAP and BPCS and 1 year experience in Selenium using
C# using Page Object Model
3 years’ experience in creating unit tests with C# using Visual Studio using VSTS and nUnit
framework for .Net Applications and debugging the applications.
3 years’ experience each in software test management tools Microsoft Test Manager, Quality
Centre, Test Director.
3 years’ experience in defect management tools TFS, Quality Center, DevTrack, Test Track
Professional
Expertise in designing automation frameworks (Hybrid, Keyword or Data driven) for QTP
Expertise in test script design using Descriptive Programming
Good knowledge in the language C#
Expertise in developing and implementing requirements-based and business based test plans, test
strategies, test cases, and documentation of QA Procedures, methodologies.
Expertise in
applying Black Box Testing techniques, and also White Box testing
all levels of testing: Unit Testing, Component testing, Integration Testing, System Testing
different types of testing: Software Installation and Upgrades, Regression,
Regional/Localization testing, Smoke and Sanity testing
Good understanding of Non Functional testing and its concepts, performed Load testing and was also
involved in testing Memory Leak of Web application
-1-
Experience in Test environment setup and maintenance including installation of various software
products and applications e.g. database software Oracle, SQL Server and other client applications,
Hands on experience in writing and executing SQL queries to test the results of the application making use
of joins, sub queries and other DML and DDL operations.
Very good understanding and working experience in .Net Applications (Windows, Web), and operational
knowledge of other Client Server applications as well as ERP applications: SAP SD, BPCS
Remarkable ability to design test strategies to conduct back end testing
Experience in software scripting languages e.g. VBScript, HTML
Experience in leading automation and manual testing teams across onsite/offshore model.
Experience in working across multiple domains Oil and Gas, Healthcare, Futures and Derivatives.
Knowledge of WITSML standards and Real Time applications
Outstanding communication and self-organizing skills, assertive and committed team player,
experience in facing the clients.
Demonstrated excellent troubleshooting skills with minimum or no help from developers in case of any
errors/issues while performing the test execution
Good at multitasking and able to work well under tight deadlines with high efficiency, fast learner with
ability to understand and scale up to the business needs.
Efficient in adhering to QA methodologies and Processes
SKILLS:
Testing Tools Operating systems
Quick Test Professional 8.2/9.0/9.5, 10 Windows XP/Server 2003/7/Server 2008 R2
UFT 11.5
Languages
Quality Center 9.0
C#
Test Director 8.0
Test Track Professional Scripting Languages
Excel Macro programming VBScript
Microsoft Test Manager 2010 HTML
WinRunner
Visual Studio C#
Selenium Framework
Databases Database Query tools
SQL Server 2005 SQL Management Studio
DB2 Advanced Query Tool (AQT)
Oracle 11.2.0.3 Oracle SQL Plus
Oracle SQL Developer
-2-
Unit testing tools Profiling Tools
NUnit Perfmon
Visual Studio 2008, 2010, 2013 ANTS profiler
.NET Memory Profiler
ERP Others
SAP Sales and Distribution Excel Macros (VBA)
BPCS (AS400 application) VMWare Tools
TFS 2010
WITSML
Knowledge of TFS APIs
WORK EXPERIENCE:
Project Details:
1. Client: Kongsberg Oil and Gas Technologies, Houston(TX) Aug 2011 - Current
Testing Lead, Well Advisor
Well Advisor is a web based application (belonging to Discovery Web core application) dealing with the logs that are
collected by the logging companies. It takes real-time data from wellsites and transforms it into charts and graphs which are
easy to understand. It has the capability to import the logs, perform certain specific calculations and present it to the wellsite
engineers with beneficial information to complete their subsequent tasks. The underlying database is a SiteCom setup which
can be deployed on a SQL Server or Oracle database server. It communicates various helper services under the umbrella of
SiteCom suite of services. The project included testing consoles Pressure Testing and BlowOut Preventer. Pressure testing is
normally performed by pumping mud or other fluid into a targeted subsystem until a target pressure is reached and sustained
for a given period of time. Pressure Testing Console is designed for that purpose. BOP Console is designed to received alarms
and Events in OPC AE standards and display them on the specific widgets designed inside the Well Advisor framework to
alert the engineers. The Consoles are delivered in iterative model to the customer.
Application is designed on .Net Framework with C#. Team Foundation Server and Visual Studio 2010 is used for source code
storage, versioning, build management, Integrated Development Environment and as a complete Application Management
Lifecycle tool. Microsoft Test Manager is used for creating Test Plans, Cases, Environments and creating ground for
execution of test cases.
As a Console Test Lead, the responsibilities included:
Software Requirement analysis for testability, working with project management team, developers and
business unit in the requirements gathering process to determine effective test strategies and scenarios to
have effective requirement coverage for every Release
Test Planning and estimation, create and maintain the Test Plan document for every release incorporating
Change Requests and Enhancements in the Test Plan and revising the estimates and update the Project Plan
accordingly
Tasks distribution to the team and maintaining Work Breakdown structure using TFS using My Queries and
Team Queries
Test Case design in the identified test management tool (Microsoft Test Manager) and reviewing the Test
Cases of the team ensuring proper validation techniques being used e.g. data verification in the databases
Developing automation scripts for web application using Selenium using Page Object Model for Internet
Explorer with C#
-3-
Developing QTP using keyword (hybrid) driven framework and descriptive programming for Windows
application
Developing and executing Unit test cases in C# using NUnit Framework and Visual Studio
Collaborating with developers to analyze and track defects and determine root causes
Test environment and Data setup including Operating System, 3rd party software and internal software and
services (SiteCom and Discovery Web suite of) including Software products and applications installation
e.g. database software Oracle and SQL Server
Performing and managing Functional, System and Integration test execution of the Well Advisor
(Discovery Web and SiteCom) application ensuring proper process being followed during the test execution
Performing Smoke Testing for the application builds and proceed with the test execution
Manage Regression Testing before every Release
Maintaining Test execution summary reports for each level of testing and hand over the report to the project
management team.
Defect triage with the Development Lead and Project Manager and plan for retesting/regression ensuring
proper defects closure in TFS
Effective management of the test data to be used during the test execution
Some of the tasks also included the following:
Developed utility applications using C#, VBScript batch scripts, Excel Macros to assist in the team’s day to
day testing activities especially
• in generating different sets of test data from a given test data file,
• verification of charts,
• comparing the Application’s output with expected output for a large set of data etc.
• export bug from excel to TFS using TFS API and convert WITSML(XML) standard data to excel
Debugged application errors and tested server/application installation platforms which includes using
Visual studio tools in case of errors
Usage of WITSML standard tools and real time application framework
Observed the performance parameters of the application using Perfmon and keeping watch on prospective
Memory Leak.
Provided User Acceptance Testing support for the application being tested at the client side
Tools used: Microsoft Test Manager, TFS, Visual Studio, WITSML, Excel Macro, Perfmon, ANTS
2. Client: Weatherford, Houston(TX) Jun 2008 – Jul 2011
Testing Lead, QA Services
The client serves oil and natural gas exploration and production industry with equipment and services used for the drilling,
completion, and production of oil and natural gas wells in the United States and rest of the world. The project included testing
applications LOWIS, WPS, PVTFlex
LOWIS is a web-based suite of software tools designed to enhance the efficiency and effectiveness of well optimization
processes. Testing team was involved in the releases of LOWIS 5.0, 5.1, 5.2 to its customers. The application was tested
manually as well as using automation tool QTP. The application was built on csScript and involved multiple third party
controls. Well Performance Server was designed to analyze the performance of different wells and the behavior of petroleum
fuels in wells. It did not have a GUI. The fluid data is obtained from different applications and analyzed. The scope was to
test them automatically (without manual intervention) using a simulator which can be any automated test tool. Due to a large
number of manual test cases (related to different sets of data) and the fact that WPS was being continuously upgraded to cater
to increasing needs of other applications integrated, it was decided to automate the testing activity using VSTS and NUnit.
PVTFlex is a stand-alone windows application developed on C++. It had 3rd party controls like Infragistics and SyncFusion.
Scope was to automate the testing activity using QTP and test execution before every release.
-4-
As an offshore Test Lead, the responsibilities included:
Test strategizing, planning, scheduling, estimations including creating and maintaining Test Plans for
manual as well as automated testing for LOWIS and PVTFlex
Tasks assignment to the team and maintaining the Requirements Traceability Matrix
Developed Hybrid framework(mixture of Keyword and Data driven framework) for automation testing
using Quick Test Professional(QTP) and planning the automated tests and schedule
Prepared Coding principles documentation for the automated testing using QTP
Created and managed Test Library of functions for the automated tests
Created automated tests using the framework and reviewed the scripts of the team
Used Descriptive Programming to identify objects in the application for flexibility, scalability, and
efficiency.
Enhance Testing quality through inserted Standard Checkpoints, Bitmap checkpoints Database checkpoints
and Text checkpoints using QTP.
Maintained traceability of the manual test cases to the automated test scripts
Reviewing manual test cases and managing the test execution during the Functional and System testing
ensuring proper techniques were being followed
Maintaining Test execution summary reports for each level of testing and hand over the report to the project
management team
Manage Regression Testing for every release
Defect triage with the Development Lead and Project Manager and plan for retesting/regression ensuring
proper defects closure in DevTrack
Collected and maintained various test metrics at different stages of testing
Created Unit Test cases using VSTS 2008 on C# and executed on NUnit for Well Performance Server
Test Artifacts and deliverables review of the team
Defects reporting and tracking, Test Results Report design and Metrics collection and maintenance
Test environment maintenance by setting up the Test servers and ensuring the proper installation of
prerequisite software
Weekly Status Reporting to the client and the higher management
Tools used: Quick Test Professional, NUnit, VSTS 2008, Excel Macros
Developed excel macro tools to record daily and/or weekly test execution summary.
3. Client: GlaxoSmithKline (UK) Dec 2007 – Mar
2008
Testing Lead, CDR
The project was executed for a Healthcare client. Clinical Disclosure Reporting is a way of reporting for the Clinical IDs used
in the DCS IT department of GSK. The project is divided into 6 components DMU, CTSSII, CHCSLU, DTS, VCTR, and
GBR. Satyam was involved in the development and System Testing of the components DMU, CTSSII, CHCSLU and DTS.
The other two modules were developed by another vendor of GSK. Data to CTSSII (Datastage7.5 application) is taken from
grip database and excel sheets uploaded using web application developed by CHCSLU(VB .net application) .The output from
CTSSII is taken and given to a 3rd party (Veritas), through DTS (Unix shell scripts). The DMU module uses JavaScript for
extracting the data and sending it to 3rd party (Veritas).
As an offshore Test Lead, the responsibilities included:
Coordinating the testing activities of the offshore testing team of 5.
Consolidating the status of the testing deliverables on a daily basis and sharing it with the Project
Management.
-5-
Sending Weekly Status Report to the client.
Review the System Test Cases before sharing with the client for approval.
Preparation of System Test Plan.
Reviewing and revising the schedules in case it is required due to change requests in coordination with the
Project Manager.
Reviewing the Test Results and Test Report before sending them to the customer’s approval and sending
the report to the Project Manager.
4. Client: GlaxoSmithKline (UK) Jul 2007 – Nov
2007
Testing Lead, MDRIT
The project was executed for a Healthcare client. The client was seeking, for one of its divisions, the services of a project lead
for overlooking the deliverables for the project teams in UK. MDR IT is the IT division of Medicine Discovery & Research
arm of the client. The projects involved were from Biology and Chemistry domain. The applications were for internal use by
the scientists working for MDR IT. Keeping in mind the sensitiveness of the quality it was required to have a personnel based
in UK to overlook the projects from the site.
As an onsite Test Lead, the responsibilities included:
Onsite coordinator for 5 projects.
Involved in the project deliverable activities from Onsite.
Interacting with the Clients for different projects on a daily basis.
Leading the team from Onsite and taking care of the daily activities of the project.
Preparation and review of Test Plans
Review of Test Cases prepared by offshore team before delivering to client
Weekly Status Reporting
Responsible for all the deliverables to the client.
Opening and closing of the projects from the vendor side.
Tools used: Quality Center
5. Client: GlaxoSmithKline (UK) Jan 2007 – May
2007
Team Lead, BPCS Automated Testing
The project was executed for a Healthcare client. The client was seeking was seeking delivery of a test solution to develop
automated regression suite for “BPCS Regression Testing” using Mercury Tools QTP 8.0, TD. BPCS is an AS 400
Application used as an Enterprise Application and it is still being used and maintained. We used RUMBA 2000 to access the
Application and complete our Testing activities. The aim of the project was:
Development of automated regression test suite for the specified BPCS System Test Cases.
Test execution and reporting of the automated test scripts using TD
Automated Scripts were developed according to the System Test Cases provided by the appropriate Business
Analysts/Consultants. The Scripts were developed in such a manner so as to reuse them across environments. The Scripts
were run whenever certain settings have been changed.
As a Team Lead, the responsibilities included:
Involved in the project deliverable activities from Onsite.
Interacting and getting regular updates from the Client on a daily basis.
-6-
Leading the offshore team of 4 from Onsite and taking care of the daily activities of the project.
Development of automated Regression Test Suite for the Client to test the settings after each major release
of application.
Creation of Automated Test Scripts from the manual test cases using Quick Test Professional
Uploading of the Test Scripts in to Test Director
Running and Executing the Test Scripts in Test Director
Test Results report to client, Weekly Status Reporting
Tools used: Quick Test Professional, AS 400, Test Director
6. Client: GlaxoSmithKline (UK) Oct 2006 – Dec
2006
Module Lead, SARBOX Automated Testing
The project was executed for a Healthcare client. SARBOX Automated Testing involved verifying the Configuration Settings
for 3 different Servers. The scope of the project was to develop Automated Scripts which would check the various
Configuration settings for each of the SAP Application environments namely OPERA, MERPS and BEBOP. The
configuration settings of all the above said environments were updated according to the needs of the Business. After each
update, all the Configurations were to be verified. So there was a need to automate the testing. Automated Scripts were
developed according to the System Test Cases provided by the appropriate Business Analysts/Consultants. The Scripts were
developed in such a manner so as to reuse them across environments. The Scripts were run whenever certain settings have
been changed.
As a Module Lead, the responsibilities included:
Involved in the project deliverable activities
Leading the testers for the module from Offshore.
Coordinating the activities with the Onsite Lead and the Client
Development of Regression Test Suite for the Client to test the settings after each major release of
application.
Creation of Automated Test Scripts from the manual test cases
Uploading of the Test Scripts in to Test Director
Running and Executing the Test Scripts
Tools used: Quick Test Professional, Test Director, SAP Client
EARLIER PROJECTS:
7. MODULE LEAD, BEBOP SELF SUFFICIENCY, – [Aug 2006 – Sep 2006]
Healthcare Client, Automated testing, Tools used: Quick Test Professional, Test Director, SAP Client
8. TEAM MEMBER, MERPS2 PERFORMANCE TESTING, – [Jun 2006 – Jul 2006]
Healthcare Client, Automated testing, Tools used: Quick Test Professional, Test Director, SAP Client
9. TEAM MEMBER, BEBOP MARKET IMPLEMENTATION, – [Apr 2006 – May 2006]
Healthcare Client, Automated testing, Tools used: Quick Test Professional, Test Director, SAP Client
10. TEAM MEMBER, BEBOP LES SCRIPTING, – [Feb 2006 – Mar 2006]
Healthcare Client, Automated testing, Tools used: Quick Test Professional, Test Director, SAP Client
11. TEAM MEMBER, BEBOP AUTOMATED TESTING, – [Oct 2005 – Jan 2006]
-7-
Healthcare Client, Automated testing, Tools used: Quick Test Professional, Test Director, SAP Client
12. TEAM MEMBER, GLOBAL CLEARING SYSTEM, – [Mar 2004 – Aug 2005]
Banking Client, Manual testing, Tools used: Test Track Professional, DB2, AQT
13. TEAM MEMBER, CAIRO, – [Jan 2004 – Feb 2004]
Retail Client, Manual testing, Tools used: Test Track Professional, DB2, AQT
14. TEAM MEMBER, MERLIN OVC, – [Dec 2003 – Jan 2004]
Automobile Client, Manual testing, Tools used: SQL Server
Note: Detailed Project summary of the projects will be provided upon request.
Customer Profile:
Employer/Organization Customer Duration
Infosys Limited Kongsberg Oil & Gas Technologies Aug 2011 – Till date
Weatherford International(Houston) Jun 2008 – Jul 2011
Satyam Computer Services Ltd. GlaxoSmithKline Oct 2005 – Apr 2008
Macquarie Bank Limited Mar 2004 – Aug 2005
General Motors Dec 2003 – Feb 2004
EDUCATIONAL DETAILS:
Bachelors in Engineering, Utkal University (India)
-8-