Mahendar Vennapu
Education
National Institute of Technology, Hyderabad, India
Bachelor of Engineering in Computer Science
Certifications
Brain Bench QA Certified
(http://www.brainbench.com/xml/bb/transcript/public/viewtranscript.xml?
pid=6715968)
Technical Skills
ERP: SAP SD, MM, HR, CRM, SRM, SCM and FICO.
Data Warehousing: SAP BW/BI7.0, Cognos, Business Objects and
Crystal Reports.
Testing Tools: Quality Center/Test Director, QTP, Win Runner, Load
Runner, Rational Clear Quest, eCATT, RequisetePro,
Test Manager
Data Base: Oracle, DB2, SQL Server, and MS-Access.
Language: Java, VB6.0, COBOL, ABAP/4.
Other Tools: PVCS, Clear Case, Microsoft Project and BugDB,
MS Visio.
O/s: UNIX, Win NT/XP/2000.
Professional Summary
SAP QA Analyst with over 11 years of Information Technology experience
in Systems Analysis, Development, Testing and Implementation of
Client/Server, ERP (SAP), CRM, and Web based applications; highlights
include:
. 10 years of testing of Database, ERP, CRM and Web based
applications like Oracle, SAP R/3, Siebel and Java using automated
tools such as Win Runner, QTP and Test Director/QC.
. Overall 8 years of SAP testing experience with different modules:
SAP-SD, SAP-HR, SAP-CRM, SAP-BW/BI and SAP-FI/CO modules.
. 5 years of Supporting/Testing in SAP BW/BI including upgrade
Testing.
. Extensive experience in creating Test Plan, Test Cases, and Testing
Methodology.
. Involved in different types of testing like Black Box, White Box,
Integration, Functional, Regression, System, Security, Web, Back
End, ERP, Data Ware House, Interface, UAT and Performance Testing.
. Wrote scripts using TSL on Win Runner and using VBScript on QTP.
. Extensively used Test Director/Quality Center for Test management
and Bug Management.
. Involved in Configuration Management, deadline and New release
Requirement Meeting.
Experience
HESS Inc., Woodbridge, NJ 12/2009 - 03/2010
SAP BW Tester (Contract)
. Created Test Plan, Test Strategy for Functional Testing and Smoke
Test Strategy and BAT Report
. Created different Test Cases for SAP BW/BI functionality Testing
. Prepared Estimates for SAP QA Testing.
. Executed Test Cases for different types of Testing like
Integration, System testing, regression and Security Testing.
. Involved in BW upgrade Testing and prepared upgrade Test Strategy
. Prepared Test Data and involved in testing environment preparation.
. Created End 2 End Test Cases and Tested End 2 End Scenarios as per
the requirements.
. Involved in creating positive, Negative test cases and Security
Test cases and testing.
. Data Extracted from SAP R/3 and other third parties to SAP BI
System.
. Created different Queries to test different reports in BI System.
. Data Quality and Data Reconciliation Testing done in BI System
against the Source Data(R/3 and Oracle).
. Data in DSOs, Info cubes and Reports Tested against Source Data as
per Requirements.
. Reports functionality, Dash board Reports, drill down, drill up,
Slice and dice properties were tested.
. Involved in Interface Testing between BI and SAP ECC Modules.
. Test Scripts were assigned by Quality Center to different Testers.
. Defects were created using Quality Center.
. Conducted Test Status Meetings, prepared test Status Reports,
meeting Agenda and send to status to Manager daily/weekly.
. Involved in test Management and QA Process improvement.
. Testing progress tracked, monitored and different Testing Reports
and Traceability Matrices were created using Quality Center.
. Responsible for daily status updates, monitor daily status and
prepared daily status Reports.
. Interacted and Coordinated between test team, dev and Functional
teams during testing process.
. Very good knowledge about BW functionality and involved in solving
BW issues.
. Very good communication skills and Leadership Skills.
Environment: ECC 6.0, SAP BI 7.0, SAP ECC6.0, SCM, APO, HR, SAP CRM,
ABAP/4, Quality Center, SQL Server, KRB, Hewitt, Win XP.
BP Inc., Houston, TX 8/2008 - 11/2009
SAP BW Tester (Contract)
. Created Test Plan, Test Strategy for Functional Testing and
Performance Testing.
. Created different Test Cases for SAP BW/BI functionality Testing.
. Prepared Estimates for SAP QA Testing.
. Managed Team of 4 Testers.
. Coordinated between Onsite and Offshore Testing Teams.
. Executed Test Cases for different types of Testing like
Integration, System testing, regression and Security Testing.
. Involved in BW upgrade Testing and prepared upgrade Test Strategy
. Prepared Test Data and involved in testing environment preparation.
. Created End 2 End Test Cases and Tested End 2 End Scenarios as per
the requirements.
. Involved in creating positive, Negative test cases and Security
Test cases and testing.
. Data Extracted from SAP R/3 and other third parties to SAP BI
System.
. Created different Queries to test different reports in BI System.
. Data Quality and Data Reconciliation Testing done in BI System
against the Source Data(R/3 and SQL Server).
. Data in DSOs, Info cubes and Reports Tested against Source Data as
per Requirements.
. Reports functionality, drill down and Slice and dice properties
were tested.
. Involved in Interface Testing between BI and SAP ECC Modules.
. Test Scripts were assigned by Quality Center to different Testers.
. Defects were created using Quality Center.
. Conducted Test Status Meetings, prepared test Status Reports,
meeting Agenda and send to status to Manager daily/weekly.
. Involved in test Management and QA Process improvement.
. Testing progress tracked, monitored and different Testing Reports
and Traceability Matrices were created using Quality Center.
. Responsible for daily status updates, monitor daily status and
prepared daily status Reports.
. Interacted and Coordinated between test team, dev and Functional
teams during testing process.
. Very good knowledge about BW functionality and involved in solving
BW issues.
. Very good communication skills and Leadership Skills.
Environment: ECC 6.0, SAP BI 7.0, SAP HR, SAP CRM, ABAP/4, Performance
Center(LoadRunner),Quality Center, SQL Server, KRB, Hewitt, Win XP.
SAP Labs Inc., San Jose, CA 12/2007 - 7/2008
SAP BI/BW Tester (Contract)
. Created Test Plan, Test Strategy and Different Test Cases for SAP
BW/BI Reports.
. Coordinated between Testing, Dev, Functional and other User teams
during Testing.
. Prepared Estimates for BW QA Testing.
. Executed Test Plan and Test Cases for different types of Testing
like Integration, System testing, regression and Security Testing.
. Involved in resource selection and prepared Test Estimates for the
Project.
. Created End 2 End Test Cases and Tested End 2 End Scenarios as per
the requirements.
. Involved creating positive and negative test cases and testing.
. Data Extracted from SAP R/3 and other third parties to SAP BI
System.
. Created different Queries to test different reports in BI System.
. Data Quality and Data Reconciliation Testing done in BI System
against the Source Data.
. Data in DSOs, Info cubes and Reports Tested against Source Data as
per Requirements.
. Reports functionality, drill down, Slice and dice, Export to Excel
properties were tested.
. Tested BI Content for SAP GRC Module.
. Worked with BPS reports.
. Quality Center Used for Creating Test Plan, Test Cases and Test
Execution.
. Conducted Automation regression analysis of various features for
internal release.
. Created Load and Performance Test Reports using LR Analyzer.
. Conducted Test Status Meetings, prepared test Status Reports,
meeting Agenda and send to status to Manager daily/weekly.
. Involved in test Management and QA Process improvement.
. Testing Progress tracked and defects created using Quality Center.
. Different Testing Reports and Traceability Matrices were created
using Quality Center.
. Responsible for daily status updates, monitor daily status and
prepared daily status Reports.
. Very good communication skills and Leadership Skills.
. Very good analytical and problem solving skills.
Environment: ECC 6.0, SAP BI 7.0, SAP SD, MM, GRC, SCM, LoadRunner,
Quality Center, TOAD, Win XP.
Tellabs, Chicago, IL 5/2007 - 11/2007
SAP BW Tester (Contract)
. As a SAP BW tester, worked on DOF (Distributed order fulfillment),
GCT Projects.
. Involved in team selection process, setting Testing Environment,
gathering test requirements, Test data and Testing Training.
. Developed Test Plan, Test Strategy and Testing Estimates from
functional requirements and SDD for BW reports Load Testing.
. Prepared estimates for the Test Case Preparation and Test
Execution.
. Involved in Team meetings and Functional review meetings.
. Involved in Test Design, Test Planning and Test Execution.
. Prepared Test Cases for Integration, System, Regression and
Security Testing.
. Prepared Test Cases for different Reports, data Extraction and data
loads for SD, HR and FICO Modules.
. Involved in interface testing between BW-FICO, BW-MM and BW-HR.
. Involved in Integration, System, Regression, End to End, and
Security Testing.
. Involved in executing Test Cases for BW Reports, Data Extraction
and security Testing.
. Involved in Data extraction from SAP R/3 and other thirty party
tools to SAP BW.
. Used Sampling Technique while testing reports in BW with Large
data.
. Compared BW Reports with BO Reports and R/3 reports.
. Created Test Plan, Test Scenarios, and Test Sets for every release
for Testing SAP Modules in Quality Center.
. Involved in Creating Test Data, Test Reports, and Traceability
Matrix.
. Monitored test Execution process and prepared Test Reports after
the Testing with Quality Center.
. Involved in Up gradation from SAP BW 3.X to SAP BI.
. Coordinated Testing Development, Testing Execution process for up
gradation process and different sap modules.
. Coordinated between End Users, Testers and Developers during UAT
and testing.
. Reports to Manager on weekly basis.
. Quality Center used for Test Management and Defect tracking.
. QTP used for automating manual Test Cases.
. Load Runner used for Load and Performance Testing.
. Prepared Test Scripts for Load Testing, Performance Testing and
executed them using LoadRunner for BW/BI Reports.
. Self starter, very good analytical knowledge and excellent
communication skills.
. Very good knowledge about SDLC, SQA methodologies, Change Control
process and release management.
. Involved in Risk Analysis and Go/No-Go decisions.
Environment: ECC6.0, SAP BW/BI 7.x, FICO, MM, SD, FICO, SCM, SRM, HR,
Tibco, ABAP/4, VB Script, Java Script, Quality Center, Load Runner,
Oracle, Clear Quest, WIN XP Prof.
T-Mobile, Bellevue, WA 1/2006 - 4/2007
SAP Tester/Lead (Contract)
. As SAP BW tester, worked on POS 360, ER and HR Data Mart projects.
. Involved in Writing Test Plan, Test Strategy and Test Cases for SAP
BW, HR Modules.
. Involved in team selection process, setting Testing Environment,
gathering test requirements and test data.
. Executed Integration and Regression Test Scripts for SAP BW, HR
Modules.
. Involved in Coordinate Testing Activities with different Testing
and Dev Teams.
. Coordinated Onsite and Offshore Test teams.
. Managed Team of 4 Testers.
. Test Director used for Test Management and Defect Management.
. Involved in Creating Test Cases, Test Sets and Test Status Reports
using Test Director.
. Involved in Functional Requirements Review and Test Case Review
meetings.
. Involved in End to End and Security Testing for BIW and HR Modules.
. Involved in Interface Testing between SAP-BW and POS DM SAP CRM,
SAP-BW and SAP R/3, BW and FI/CO, BW and HR Modules.
. Involved in Data Extraction from different Legacy Systems Sources
in to BW.
. Involved in validating different Info Cubes which should have Key
figures and Characteristics.
. After extraction Data, Tested different ODS Objects against Source
Systems.
. Created different queries to generate Reports and Tested different
Reports according to user requirements.
. Involved in BW Upgrade Testing from 4.7 to ECC5.0.
. Involved in Testing of different FI/CO and HR Reports in SAP BW.
. Load and Performance Test done by using LoadRunner.
. Generated Vuser Scripts and debugging the scripts to check that it
operates smoothly.
. Executed the Load scenarios by using the controller.
. Monitored the Vuser Logs, transaction response times and SAP server
response times when the System under Load for BW Reports and data
transfer.
. Created Vuser Scripts in Vugen. Parameterized and correlated
scripts to scale for 500 Virtual users.
. Created and executed scenarios in LoadRunner controller to analyze
system performance in LoadRunner Analyzer under load.
. Created different queries in BW and in Oracle 9i.
. Good Team member and Self starter.
Environment: SAP 4.7, SAP HR, SAP FI/CO, SAP CRM, SAP- BIW3.5/BI, BEx
Analyzer, BEx Browser, AWB, SAP - Point of Sale Data Management, SQL
Navigator, Cognos Reports, Tibco, IDOCS, ABAP/4, JavaScript, Oracle,
RUP, QTP and Test Director and LoadRunner.
Mylan Pharma, Morgantown, WV 5/2005 - 12/2005
SAP Tester (Contract)
. Involved in Writing Test Plan and Test Cases for different sub
modules of HR (PA, OM, TM, Benefits and Payroll) from the
functional requirements.
. Involved in Unit Testing, Integration Testing and Process Testing,
Administration Testing and UAT of SAP HR modules.
. Involved in RICEF's testing.
. Test Director used for Test Management and Defect Management.
. QTP 8.0 used for automating the Manual Test Cases for the HR.
. Involved in Functional Requirements Review and Test Case Review
meetings.
. Extensively interacted with Functional, Dev teams, Security teams
and End Users.
. Involved in End to End, Interface and Security Testing.
. Involved in Data extraction from SAP HR System to SAP BW.
. Created different Queries in SAP BW to test reports as per the
requirements.
. Involved in Creating Test Status Reports using Test Director.
. Very good communication skills.
. Very good SAP HR functional knowledge.
Environment: SAP 4.7 and ECC 5.0, SAP- HR, PA, OM, TM and Payroll,
Benefits, RICEF's, SAP BW, ABAP/4, Java, Test Director, Oracle, DB2,
Crystal reports, CATT and QTP.
Microsoft Corporation, Seattle, WV 1/2004 - 4/2005
SAP SD Tester (Contract)
. Worked in SAP-EAS team and as a Test Lead, took care of all SD, MM,
BW Modules and HRIT and XIT products. SAP-EAS was a Microsoft
internal project, which was used to run all Microsoft Corporation
sales, inventory, finance and HR activities.
. Conducted Team meetings and interacted with Dev, Functional Team
Leads and End Users.
. Allotted work to the Team members and monitored them during
Testing.
. Reported to my Manager and sent the Team status report on Weekly
basis.
. Involved in preparing the Estimates for the assigned work.
. Involved in Spec Review, Test Plan Review and Test Case Review
Meeting.
. Involved in writing Test Plan, Test Cases and Test Status Reports
for SAP Modules like
. SAP-SD, BW, HR and HRIT and XIT Projects.
. Involved in preparing Testing environment, Test Data Test Metrics.
. Involved in preparing the testing methodologies and testing
Process.
. Involved in the Integration testing, System testing and Regression
testing.
. Involved Data extraction from SAP SD and Sales Systems to SAP BW.
. Created different Reports in SAP Business Explorer and Tested as
per the requirements.
. Involved in Bug Life Cycle and PSS is used for Bug Management.
. Environment: SAP, Reports, PSS, SAP- SD, BW, GTS, CATT, ABAP/4,
Test Director, Microsoft Project and SQL Server 2000, VISIO.
Plumtree Tree Inc., San Francisco, CA 2/2003 - 12/2003
SAP Test/QA Lead (Contract)
Plumtree is one of the leading portal software. For integrating
Plumtree, with different Enterprise systems, they have developed
different Frame works.
. Involved in SAP Frame Work that developed port lets which were used
for displaying and updating the data on the portal page. Perforce
was used for version controlling and build development.
. Involved in modifying the existing Test Plane and Writing new test
Plane for next version of Plum tree.
. Involved in creating and executing the Test cases for SAP Frame
work 2.5.2 and 2.5.3 Application.
. Completed Testing on SAP FW 2.5.2 for the "Sea Glass
Certification."
. Involved in different types of testing on SAP FW like Installation
Testing on different.
. Application Servers, Functional Verification Testing, Product
Verification Testing.
. Involved in client support and enhancements of testing for
modifications.
. Involved in creating the Metrics for testing, creating bugs and
closing bugs.
. Involved in Interfacing Testing between SAP R/3 and Plumtree
Portal.
. Involved in creating queries for SQL Server 2000 database.
. As a Team lead involved in Resource monitoring, estimation for the
work, allocation of work to the Team members and Involved in
Project meetings and team meetings.
Environment: Java, J2EE, SAP, BAPIs, RFC's, IDOCS, SAP-SD, HR, FI/CO,
Tomcat, Web Logic App. Server, SAP Frame Work, Gadget Web Services,
Win Runner, Test Director, Bug DB, Perforce, Tunnel Tool, Oracle8i,
SQL Server 2000, Sun UNIX 11.0, Windows NT 4/XP.
Eli Lilly, Indianapolis, IN 6/2002 - 1/2003
SAP BW QA Consultant (Contract)
. Training at Eli and Lilly.
. Completed training for 21 CFR Part 11, cGMP and FDA.
. Very good exp in validation and cGMP practices.
. Test Scripts, Test Cases and Test sets were developed for testing
process.
. Manual System Testing, Regression Testing and Integration Testing
were done on different modules like SD, HR, MM, FI/CO and PP.
. Involved in developing the automated Test Scripts by using the QTP
for SAP SD, HR, MM, FI/CO and BW modules.
. Involved in Data loading from SAP R/3 to SAP BW database.
. Info packages for different modules were scheduled.
. Info Queries were tested to get reporting data from SAP BW.
. Data Targets and Info Objects in SAP BW were located for scheduling
and Monitoring.
. Involved in writing Test Cases and Testing of the Customer Service
Module and Internet Sales Module.
Environment: SAP R/3, SAP BW, SAP SD, HR, PP, CS, IS, ABAP/4, BEX
Analyzer, Administration Work bench, Oracle8i, Sun UNIX 11.0, Windows
NT 4, CATT, QTP and Test Director, RUP.
KPN Telecom, kpn.com, IL
6/2001 - 5/2002
QA Consultant (Contract)
KPN is the biggest telecom company in the Netherlands. The main aim of
the project was to develop an online retail store and to serve the
customer on line. This project contained several modules like customer
service, Alert and E-mail Module, Product Module, internal reporting
module.
. Involved in entire Testing life cycle.
. Used Test Director to create the Test plan, Test Cases and Test
Sets for Application Modules like Customer service, Alerts, Product
Module and Reporting Module.
. Prepared the Test plan, Test Cases and Test procedures for Content
Management Application Modules.
. Developed Win Runner User Defined functions as per requirements.
. Involved in setting up Testing environment, Creating Test Data for
different Modules.
. Extensively participated in black box Testing and White Box Testing
of JAVA Applications.
. Test Scripts were enhanced by TSL as per testing requirements.
. Worked closely with developers and Business Analysts.
. Involved in converting manual test scripts to automated test
scripts.
. Used Oracle to query the data to ensure data integrity &
referential integrity and Involved in writing complex SQL
statements and sub selects.
. Functionality and system testing was initially done manually for
compatibility of using multiple browsers and platforms.
. Performed the manual testing for acceptance, functional testing and
end-to-end testing.
. Conducted Web Testing for hyperlinks and navigation.
. Test Director did defect tracking and Defects were stored in the
Test Director repository.
. Environment: Broad Vision 5/6, Java, JSP, J2EE, Servlets, SAP,
Oracle8i, JavaScript, XML, XSL, Sun Unix 11.0, Windows NT 4., Clear
Case, Win Runner, Test Director, Load Runner.
Wal-Mart, samsclub.com, Bentonville, AR 2/2000 - 5/2001
QA Consultant (Contract)
This was a wide Range of E-Commerce B to C application, developed by
Wal-Mart. This project had several applications like Member service
application, customer service application, supplier service
application & Report application etc.
. In this project, was involved in automated and manual testing.
. Based on requirement, developed test plans, test cases and test
scripts.
. Involved in white box, black box testing and Back end Testing.
. Involved in Integration, System and Regression testing.
. Extensively interacted with the developers, Analysts and users to
dissolve the bugs.
. Interacted with end users to obtain specific system requirements.
. Involved in Team meetings and sending the weekly Status Report to
Manager.
. By using Win Runner new tests, batch tests and user defined
functions were created.
. Involved in Creating Test Strategy and testing Metrics.
. Test Director was used for the Test Management and defect Tracking.
. Used Load Runner for stress test and performance tests.
. Environment: Java, Servlets, JSP, EJB, Netscape Application Web
Server, Home Site 2.0, Informix, JavaScript, HP UNIX, Windows NT 4,
PVCS, Win Runner, Test Director, Load Runner.
PCOrder.com 8/1998 - 1/2000
QA Consultant (Contract)
. Environment: Java, JSP, Servlets, JDBC, JavaScript, UNIX, Windows
NT, Oracle, Test Director, Win Runner.