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

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.
• Responsible for designingFrameworkand executingautomationscripts using QTP.
• Designed theLoadRunnerscenarios with various user incremental loads in constant ratios, till the peakdata loadis achieved.
• 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

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

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

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

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