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, Business Intelligence (BI), Informatica, UNIX and Mainframes 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, Integration Verification and Validation 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
• Extensive experience in testing Web Applications with J2EE, Java, XML, WebSphere, Oracle 8.x/9i and DB2
• 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
• Hands on 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: MS-DOS, UNIX, Linux, Windows 95/98/2000/XP/7/NT

Languages: C, C++, VC++, VB, VB Script, Java, Java Script, J2EE, JUNIT, EJB, JSP, ASP, ASP.NET, VB.NET, SQL, PL/SQL, HTML, XML, SOAP, REST,XHTML, Visual Basic, Perl, Python, Power Builder

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

Mainframes: IMS, CICS, TSO, DB2, JCL, File-Aid

Test Tools: QTP 8.0/9.2, LoadRunner 8.0/9.0, Quality Center 9.0/10, Bugzilla, Selenium, Jira, Rational Quality Manager, Rational Service Tester, Worksoft Certify

Servers: Web Logic, Web Sphere, IIS, PWS

ERP: SAP 4.6C, ECC 6.0, SD, MM, GRC, Crystal Reports

PROFESSIONAL EXPERIENCE

Confidential, Houston TX

Sr ETL Tester

Tools: Rational Quality Manager, Rational Portfolio Manager, Rational Service Tester, Oracle Data Integrator (Topology, Operator), BI, Oracle 8i, 11g, PL/SQL, Unix, SQL Developer, JDeveloper, SQL Loader, TSQL, Oracle Enterprise Manager, Stored Procedures, Triggers, Business Objects, SOAP UI, RHEL, Sparx Enterprise Architecture, 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.
• Composed test conditions, test scenarios, and data sheets in test director according to business requirements on DOORS requirements tool and intensively reviewed test plans.
• 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.
• 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 Rational Quality Manager, Rational Service tester, Rational Functional tester, Rational Clear Quest 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.
• Developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Responsible for designing Framework and executing automation scripts using QTP.
• Performed End to end testing starting from the source to the report
• Strong knowledge of SQL, XML and extraction/ transformation/ loading (ETL) process using SQL, XML scripts.
• 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.
• 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, triggers and indexes 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.
• Performed Back end Testing-using SQL queries, generating reports to ensure data integrity and validate the inserted and updated data.
• 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.
• Performed Web application performance testing manually and automated writing vbscripts
• 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, Integrity, Flat files, Oracle 8i, PL/SQL, SQL*Loader, SaaS, SOAPUI,TSQL, Stored Procedures, Triggers, Unix Shell Scripting, .Net, Java, JavaScript, Business Objects, Windows 7, NT, Microsoft Visio, Microsoft Project, IBM AIX 4.2, 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
• Responsible for Data mapping testing by writing complex SQL Queries using SQL Plus and Toad
• Developed automation test scripts totestthe database by retrieving the data from the tables using HP QTP and VB Scripting.
• Analyzed testcases forautomationand created scripts for regression testing using QTP 9.2
• Involved in testing data mapping and conversion in a server based on Informatica data warehouse
• Designed the LoadRunner scenarios with various user incremental loads in constant ratios, till the peakdata loadis achieved.
• Tested and validated SAAS (Software-As-A-Service) applications that are used by end users and executives.
• Involved in creating various Rewards transactions in the User Interface (UI) and then validate the data in TSYS
• Developed a Java-based test framework for testing web application built with HTML5 in different browsers and OS using Java, Selenium Web driver.
• Good experience in performing Asynchronous Web Services Testing using SOAP UI tool
• Good experience in Writingmacrosto automate mainframe application with websites
• 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: QTP 8.0, Quality Center 8.0, ALM, LoadRunner 8.0, Java, Java Script, SaaS, SOAP,MQ Series, UI.Net,J2EE, EJB, Jira, LINUX,UNIX,ISO 8583, TOAD, Oracle, SQL, File Aid, DB2, Web Sphere, Microsoft Visio, Microsoft Project, TFS and Visual Source Safe

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
• Validating Credit Card pricing, Rewards on the TSYS screen.
• Extensive experience in performing mobile automation(iOS,Android) testing using Perfecto Mobile
• 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
• Created test scenarios template based on IEEE standards.
• 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
• Created different set of test cases for both Equifax and TransUnion Bureaus by interacting with their Development and Testing Teams.
• Mapped the test data to a specific test case for execution purpose
• Created Macrosto execute the function automatically to schedule the file at a particular time.
• Performed Functional, System-Integration, End to End, Regression testing and User Acceptance Testing
• Extensively utilized Microsoft Visual Studio system team edition, QTP, Selenium for creating, implementing and executing automated, generic, manual, load, stress, ordered, unit and web tests.
• Responsible for Java/TestNG coding of automated Selenium tests scripts utilizing Firefox, Chrome, Safari, & Internet Explorer browsers
• Created Folder structure in MS Team Foundation Server (TFS) and uploaded Smoke Test Automationscripts and mid-level Test Automation scripts in related folder.
• 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 source SoapUI Tool
• Co-ordinated with the client BA’s and SME’s forLoad, stresstesting 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, Java Script,.Net, UNIX/XP/NT, Mainframe, JCL, Toad, SQL, SaaS, SOAP, XML, Junit, COTS, Guidewire, MS SharePoint, MS Content Management Server, MS Team Foundation Server, SAP 4.6C (SD, MM,FI,CO,HR),SAP ECC, SAP APO, QTP 8.0, ALM, Quality Center 9.0,LoadRunner, Silverlight

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
• Experience in Commercial Off-the-Shelf (COTS) software system integration and implementation.
• Used Salesforce (SaaS Application) for Billing System
• 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.
• Have good experience in testing Silverlight applications for interactive, Web-based data visualization.
• Involved in Manual and Automated Testing of Web based, Mainframes, Client/Server and testing applications using Smart Phones
• Createdmacrosin excel using vbscript and verified them.
• Responsible for writing automation test scripts using Visual Basic in QTP for different application features.
• Designing and implementing theHybrid AutomationFramework and its data
• Involved in translating the business requirements into a technical document by mapping each reporting element to Guidewire data dictionary.
• Review proposed data model changes with Guidewire Developers
• Actively worked on EDI transactions X12 270, 277 and on the reconciliation processes.
• Validated the file in Healthcare Management
• Coordinated Test Execution & Enterprise-Wide Testing of Quality E2E test environment supporting J2EE/J2ME Applications.
• Heavily used Test / Defect management tool Quality Center, QTP for managing test cases, executing and storing results and raising defects
• Developed the Performance test plan document, based on the types of test that needed to be executed, understanding the functionality of the application.
• Designed scenarios for Performance Testing, Generating scripts and handling Correlation as well as using LoadRunner VuGen, executed scenarios using Controller and analyzed the results using LoadRunner Analyzer.
• Performed Loadtest for up to 500 users
• PreparedloadTest analysis reports for disk, CPU Utilization, page breakdowns, Response Times, Web Server Monitor Counters, Captures, System Performance Counters and Database Performance Counters)
• Identified the test data based on the requirements and provided them to the DBA
• Analyzed existing processes and established industry standard process methodologies. Mentored QA teams in their efforts to implement process improvements.
• 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, Quality Center 9.1, Star Point, Bugzilla and 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: QTP 9.0,Quality Center 9.0, LoadRunner 8, 9.0, SAP 4.6C (SD, MM,FI,CO,HR),SAP ECC, SAP MD, Crystal Reports, SAP CRM, ECATT, Java, J2EE, EJB, Java Script, HTML, XML, SQL, SQL Plus, Toad, Oracle 10g, Web Sphere, Windows NT4.0/2000,UNIX and IBM Mainframes.

Responsibilities:

• Participated in business requirement, design walk through and analyzed business requirements
• Reviewed system use cases and functional specs with business and system analysts
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Data Conversion and Data Migration project
• 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 software testing of various application running in Mainframes, Unix and Client Server / Web based environments.
• 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 with Mobile application testing for iPhone (iOS), Android, Blackberry and featured phones using Simulators like Device anywhere and Perfecto
• Using LoadRunner executed multi-user performance tests, used online monitors, real time out put messages.
• Used Auto Correlation, Parameterization and Content Check features
• Designed the Manual and Goal oriented scenarios using LoadRunner Controller module
• Conducted regression testingafter hardware upgrade to identify the hardware for the optimal performance.
• Performed load testing with 100 Virtual users, based on the requirement.
• 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 and tested the reports developed in Crystal Reports are as per company standards
• 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