SUMMARY

• 9 + years of experience in performing Test Planning, Execution and Analysis of the Application Under Test using standard methodologies like Waterfall and Agile
• Experience in Software Quality Assurance and Testing, experienced in both manual and automated testing on web based, client server, Data Warehouse applications
• Experience in creating Detailed Test Plan, Functional Test Plan, Test Scenarios, Test Cases and Status reports
• Good experience in creating and executing Test Plans, Test Cases, QA Methodologies in both Manual and Automated Testing environments
• Possess specific experience performing testing including Backend, Frontend, Regression, Functional, System, Interface, Usability and Validation of End - to-end and User Acceptance Testing.
• Experienced in Agile Methodology. Proficient in Black Box and Testing methodologies. Possess specific experience performing Regression and Functional Testing using QTP, Rational Service Tester.
• Performed Automated Testing using QTP for Functional & Regression testing
• Strong skills in Implementing Quality Assurance Standards, and Testing Methodologies for Large Enterprise GUI, and WEB applications using Use Case Documents, Functional Specifications and Business Requirements
• Testing skills include Sanity, Black Box, User Acceptance, Smoke, System Integration, Backend Database, Performance, Stress, Regression, End to End, Security, Cross Browsers and Cross Platform Testing
• Have strong experience in using QTP, Quality Center, LoadRunner, Rational Quality Manager, Rational Service Tester
• Experience in handling applications in Ministry, Telecom, Banking and Oil and Gas
• Excellent interpersonal skills, proven team player with an analytical bent to problem solving and delivering under high stress environment with resource constraints
• Possess good analytical and troubleshooting skills and have proven ability to work efficiently in both independent and team oriented environments

TECHNICAL SKILLS

Operating Systems: UNIX, Linux, Windows 95/98/2000/XP/7/NT

Languages: VB Script, Java, JavaScript, Shell scripts, J2EE, JUNIT, PL/SQL, HTML, XML, SOAP, RESTful

Database: Oracle, SQL Server 2000, DB2, MS Access

Test Tools: QTP/UFT, QC/ALM, LoadRunner, Jira, Rational Quality Manager, Rational Service Tester, Worksoft Certify

ERP: SAP 4.6C, ECC 6.0, SD, MM

PROFESSIONAL EXPERIENCE

Confidential, Houston TX

Sr ETL Tester

Tools: QTP/UFT, QC/ALM, Rational Service Tester, LoadRunner, Oracle Data Integrator (Topology, Operator), BI, Oracle 8i, 11g, PL/SQL, SQL Developer, JDeveloper, SQL Loader, TSQL, Oracle Enterprise Manager, Stored Procedures, Triggers, Business Objects, SOAP UI, RHEL, Sparx Enterprise Architecture, SVN, Windows 7, NT, Microsoft Visio, Microsoft Project, Microsoft Sharepoint, Microsoft Office 2007/2010/2013 , Lotus Symphony

Responsibilities:

• Worked on all phases of data warehouse testing lifecycle, from gathering requirements, Preparing Test Data, testing, create test reports, support to other Pods including client in the integration project.
• Analyzed Business Requirements, Mapping Supplement documents and Identified documents required for system and functional testing efforts for all test scenarios.
• Provided Continual Process Improvement Initiatives & control project quality/cost by leading & organizing Test Project Plan, Phase Reviews, Code Walkthroughs & lessons-earned sessions.
• Worked on developing the data warehouse test strategies, test plans, and test cases.
• Analyzed & documented the contents of the Sparx Enterprise Architect repository.
• Hands on experience in using SVN version control tool for versioning automation components like automation scripts, environment files etc.
• Coordinated deployments across multiple Scrum teams and Deployment team for both Front-end and Back-end QA and Release builds to multiple QA environments including execution of Deployment jobs in Jenkins
• Have good experience in creating effective ETL data warehouse test cases and scenarios based on business and user requirements.
• Heavily used Test / Defect management tools like QTP, QC/ALM for managing test cases, executing and storing results and raising defects.
• Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
• Managed and conducted System testing, Integration testing and Functional testing.
• Used the Oracle Data Integrator Operator and its run-time scenarios to schedule the jobs, validating and debugging its components, and monitoring the resulting executable versions.
• Performed End to endtestingstarting from the source to the report
• Strong knowledge of SQL, XML and extraction/ transformation/ loading (ETL) process usingSQL, XML scripts.
• Developed and executed test cases for SOAP servicesusing SoapUI tool
• Developed groovy scripts for implementing database validations through JDBC connection to customize reports
• Worked with Data Warehousing developers who extensively used ODI, OSB to design mapping to move data from source to target database using Stages to do the functionality.
• Performed extensive Database Testing by writing complex PL/SQL Queries in TOAD to test different scenarios of the application
• Prepared status summary reports with details of executed, passed and failed test cases
• Interacted with developers, Business & Management Teams and End Users.
• ImplementedSQL scripts,stored procedures, triggersandindexes forvarious database operations.
• Extensively used Oracle Enterprise Manager to monitor the instances and Payloads of SOA services.
• Defining defects and carried out test reports using RQM as Defect tracking system.
• Testing of Web Services using web services client generated using SOAP UI to track request and response SOAP Messages.
• Responsible for API Testing, Web Service Testing using SOAPUI (Test Suite, Assertions and Mock services)
• Performed Back end Testing-using SQL queries, generating reports to ensure data integrity and validate the inserted and updated data.
• Extensively performed Functional testing manually and use of descriptive programming inUFT-Unified Functional Testing (UFT).
• Performed web based testing usingUFTfor checking page contents, broken links, web objects, frames and tables.
• Regularly followed up with Development Team to discuss discrepancies identified during testing and performance tuning.
• Participated in daily defect resolution status calls to discuss defects with vendors, project management, Developers and Users.
• Used Tealeaf to view the customer sessions for the issues they are encountering during UAT phase.
• Involved in retesting the fixed defects and keep track of defects through defect life cycle.
• Escalated testing issues, risks, dependencies, resources constraints to the Testing Team leadership.

Confidential

Sr Quality Assurance Analyst

Tools: Quality Center 9.0, LoadRunner, QTP 9.2, ClearQuest, Doors, Informatica (Power center Designer, Workflow), BI, Oracle 8i, PL/SQL, SOAPUI, REST, TSQL, Stored Procedures, Triggers, Java, JavaScript, Windows 7, NT, Microsoft Office 2007/2010

Responsibilities:

• Involved in testing the data warehousing process of the FCC Loan Management System project
• Organized walkthrough and review session from BA, ETL developers and DBA to understand the business process
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Data Conversion and Data Migration project
• Worked with Data Extraction, Transformation and Loading (ETL)
• Tested the ETL process for both before data validation and after data validation process and tested the messages published by ETL tool and data loaded into Oracle databases
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Transformation Mapping
• Written several complex SQL queries for validating Business Objects Reports based on the data mapping requirements
• Designed and Developed data validation, load processes and test cases using PL/SQL, SQL
• Responsible for Data mapping testing by writing complex SQL Queries using SQL Plus and Toad
• Developedautomationtestscripts totestthe database by retrieving the data from the tables using HP QTP and VB Scripting.
• Analyzedtestcases forautomationand created scripts for regression testing using QTP 9.2
• Extensively performed Web Servicestesting for REST, SOAP, and WSDL.
• Involved in testing data mapping and conversion in a server based on Informatica data warehouse
• Gathered knowledge on Home Loans Point of Sale and Loan Origination system
• Responsible for testing theFCC Mortgage Point of Sale & Loan Origination system
• Good experience in performing Asynchronous Web Services Testing using SOAP UI tool
• Used Quality Center to create Test cases, Map the test cases to Test Plans and Requirements, create test sets and report defects
• Good experience in Analysis of Bug Severity, Bug Tracking system and Bug Reporting using Quality Center, ClearQuest.

Confidential

Sr Quality Assurance Analyst

Tools: Used: QTP 8.0, Quality Center 8.0, LoadRunner, ALM, Java, JavaScript, SOAP, J2EE, Jira, LINUX,UNIX, ISO 8583, TOAD, Oracle, SQL, DB2, Web Sphere, Microsoft Visio, Microsoft Project, TFS

Responsibilities:

• Worked as QA Analyst in testing CreditAPP application
• Gathered Project documents and performed gap analysis
• Organized brainstorming session with the Business Analyst for the detail understanding of the project and the application
• Reported gaps to the authors and ensured to the closure
• Identified what is In-scope and out-scope of the project based on Project Scope documents
• Drafted Master test plan after reviewing the project documents
• Provided Master test plan for sign off after detailed review sessions
• Mentored QA teams how to construct effective test plans, cases, and test reports
• Identified Test scenarios based on the Business and Functional requirements
• Created Test Scenarios for Business Rules and Business Process by creating both positive and negative test cases according to the Business Rules and Business Strategies of the APPRO application
• Identified the test data by organizing multiple test data review meetings and also created test data for specific Test Scenarios and Test Cases using SQL Insert scripts
• Created test data requirements document based on the test scenarios and provided to the DBA for test data purpose
• Created detailed test cases in Quality center and mapped to the requirements
• Mapped the test data to a specific test case for execution purpose
• Performed Functional, System-Integration, End to End, Regression testing and User Acceptance Testing
• Verified the "fixes" for the reported defects by performed Regression testing using QTP and provided defect status reports to the management
• Designed and Executed Vugen test scripts based on the business requirements using LoadRunner tool
• Regular interaction with developers and business analyst in resolving technical related issues
• Involved in testing web services of the application using an Open sourceSoapUI Tool
• Co-ordinated with the client BA’s and SME’s forLoad, stresstestingof UI and other functional requirements gathering.
• Participated in enhancements meeting to distinguish between bugs and enhancements
• Provided test matrices to the QA Lead and management on a daily basis

Confidential

Sr Quality Assurance Analyst

Tools: Oracle, Java, JavaScript, Toad, SQL, SOAP, XML, MS SharePoint, MS Team Foundation Server, SAP 4.6C (SD, MM,FI,CO,HR),SAP ECC, WorkSoft Certify, ALM, Quality Center 9.0

Responsibilities:

• Involved in the creation of System Test Plan which outlines Scope, Objective, Focus and Approach of the testing effort for this particular project
• Participated in the Requirements review meeting to better understand the project
• Created Test scenarios based on the SRS and Use Cases in Quality Center
• Provided the Test scenarios to the BA for review and sign off
• Created detailed Test cases in Quality Center test plan module and mapped the test cases to the requirements and ensured the coverage
• Carried out End to End testing of Operations and supply chain consisting of MM, SD, FI, PP, APO modules for various scenarios and functionalities concerning the business flow.
• Involved in Manual and Automated Testing of Web based, Client/Server and mobile applications(iOS and Android)
• Responsible for writingautomationtest scripts in WorkSoft for different application features.
• Coordinated Test Execution & Enterprise-Wide Testing of Quality E2E test environment supporting J2EE/J2ME Applications.
• Designed scenarios for PerformanceTesting, Generating scripts and handling Correlation as well as usingLoadRunnerVuGen, executed scenarios using Controller and analyzed the results usingLoadRunnerAnalyzer.
• Heavily used Test / Defect management tool Quality Center/ALM, WorkSoft for managing test cases, executing and storing results and raising defects
• Identified the test data based on the requirements and provided them to the DBA
• Executed test cases on the application for Sanity, Functionality, Integration, Data mapping, Data integrity, Data validation and End to end testing.
• Having very good experience in using Defect Management tools / Bug Tracking tools like JIRA, QC/ALM, Rational Suite
• Performed backend testing on the Oracle database using SQL statements
• Involved in creating UAT test cases based on the end users input and performed UAT testing along with the users
• Reported defects to the development team with all the required details and participated in the defect triage meetings
• Provided status reports to the management for assigned tasks

Confidential

Quality Assurance Tester

Tools: Worksoft,Quality Center 9.0, LoadRunner 8, 9.0, SAP 4.6C (SD, MM,FI,CO,HR),SAP ECC, SAP MD, SAP CRM, ECATT, Java, J2EE, JavaScript, HTML, XML, SQL, SQL Plus, Toad, Oracle 10g,Windows NT4.0/2000

Responsibilities:

• Participated in business requirement, design walk through and analyzed business requirements
• Reviewed system use cases and functional specs with business and system analysts
• Used Quality Center to create Test cases, Map the test cases to requirements, create test sets and report defects
• Generated test plan, test case and defect metrics reports and published to the management on regular intervals
• Involved in testing the UI applications by performing field level, cross browser, functionality, system integration and end to end testing
• Involved in Security testing for different LDAP roles based on Security testing requirements
• Tested SAP order to cash process.
• Have very good experience in testing SAP Material Master Data (MM, MD)
• Involved in Creation of Quotation and Order management, Standard Sales Order.
• Involved in Pricing, Billing and Contract management.
• Involved in Functional Testing of the Sales order management, Third Party Order Processing, checking Availability of the products, Releasing the created sales order, Creating the invoice, creating the goods receipt
• Involved in Mobile apps testing which is integrated with SAP CRM (Mobile sales)
• Experience withMobileapplicationtestingfor iPhone (iOS), Android, Blackberry and featured phones using Simulators like Device anywhere and Perfecto
• UsingLoadRunner executed multi-userperformance tests, used online monitors, real time out put messages.
• Used Auto Correlation, Parameterization and Content Check features
• Designed the Manual and Goal oriented scenarios usingLoadRunnerController module
• Have good Experience on testing regression suite by Net weaver portals across SAP Modules.
• Worked with business team to test the reports developed in Crystal Reports.
• Used Quality Center to track and report system defects
• Written several complex SQL queries for validating Crystal Reports based on the data mapping requirements
• Provided status and progress reports to the management on regular intervals