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
• Strong experience in designing and developing automated scripts for Functional, Integration and Regression Testing using Selenium.
• Expert in performing Data Driven Testing to validate the components displayed on the website using Selenium Webdriver
• Experienced in developing Automation Frameworks using Selenium.
• Have strong experience in using QTP, Quality Center, Rational Quality Manager, Rational Service Tester
• Experience in handling applications in Ministry, Telecom, Banking and Oil and Confidential
• 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, Perl, J2EE, JUNIT, PL/SQL, HTML, XML, SOAP, RESTful

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

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

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

PROFESSIONAL EXPEREINCE:

Confidential,Troy, MI

ETL Tester

Technologies/Tools Used: Selenium Webdriver, Sikuli, TestNG, Java script, Eclipse, Jmeter, Oracle 11g, SQL Developer, Bamboo, Jenkins, SOLR, Rally Dev, Predix, Tortoise SVN, Git, Confluence, Rest Client, Postman, PostgreSQL 9.6, Windows 7, MS Office

Responsibilities:

• Identified and analyzed business and functional requirements using Confluence as knowledge and documentation management system
• Full Software Development Life Cycle (SDLC) experience including Analysis, Review and Planning of Business and Software Requirement Specifications
• Actively participating in Daily Scrum, Planning and Review meetings for each sprint
• Created and documented test plan, test cases, test scripts and test results in Rally Dev
• Used SQL Queries in performing data validation to ensure data accuracy and data integrity by testing back-end components of new data warehouse products
• Performed ETL Full/Incremental data load testing for Talend jobs
• Automation project setup and deployment in Jenkins for continuous Integration
• Performed Automation testing of the web applications using Selenium Webdriver and TestNG framework by writing scripts in Java language
• Developed and Build Data driven framework from scratch using Web driver, Eclipse, TestNG and Java for java based application to cut down regression and smoke testing time 
• Used Eclipse-juno version to write automation scripts using Java as language, check in the new, updated automation scripts into SVN repository, creating test suite, validating the test results from the Test Results output folder
• Involved in conducting Verification, Benchmark test, stress tests, Failover and volume tests against the application using Jmeter.
• Used Jmeter to generate realistic load on an application under test.
• Proficient in developing scripts using various samplers in Jmeter and executing them
• Used GitHub web based repository for test source code management
• Configured   Jenkins  build job for continuous Integration and for Regression Testing
• Validated Rest API services using Advanced RestApi client, Swagger, vRest (to automate the Google API services)
• Extensively used Sikuli integrated with webdriver to automate the google maps through image recognition feature
• Installed and configured Maven, Selenium, Sikuli, TestNG with GE Predix server as part of this project
• Invoked and monitored the scheduler jobs to perform Risk calculation and then to display the results in the UI
• Verified the calculated risk using specified formulas and ensured they are in sync with database, UI, Small World(API) service
• Performed Manual and Automated Integration testing as part of end to end testing of all the functionalities as part of IPS project
• Worked on multiple projects simultaneously for SA, RIL, BP on Java (AngularJS) based and Predix 2.0 based applications
• Extensively worked on tools like Postman to validate the Rest API’s (JSON) responses for Timeseries data, PostgreSQL for database comparison
• Proficient in using SOLR for importing data from different sources and querying to get results in XML or CSV format and compare those with Frontend application
• Procured good knowledge in Azure Virtual test environment during implementation of cloud infrastructure setup for BP project
• Have explored Reports section of Predix BP POA application that is developed on Salesforce
• Possess good knowledge on Salesforce reporting from the team developed on the user customization part
• Performed smoke/sanity/Failover testing in different environments to ensure that there are no major issues after the key environmental upgrades and updated to the project management accordingly

Confidential

ETL Tester/Data Analyst

Technologies/Tools Used: Rational Quality Manager, Rational Service Tester, Selenium Webdriver, Oracle Data Integrator (Topology, Operator), BI, Oracle 8i, 11g, PL/SQL, SQL Developer, JDeveloper, SQL Loader, TSQL, Java, J2EE, Python, Oracle Enterprise Manager, ESB, Jenkins, SOAP UI, RHEL, SVN, Windows 7, NT, Microsoft Visio, Microsoft Sharepoint, Sparx EA, Microsoft Office 2007/2010/2013 , Lotus Symphony

• 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.
• Experience in working with open source tool Selenium Web driver, TestNG, Eclipse and preparation of automation test framework. 
• 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
• Coordinated with test team in offshore to get daily test status updates during offshore hours
• 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.
• Experience in working with JIRA, J- Unit,   Jenkins and Maven. 
• 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 designing Framework and executing automation scripts using Selenium.
• Designing and developing test automation artifacts (scripts, scenarios, processes) for simple to complex automated testing using Selenium Webdriver
• Performed Mobile Automation (iOS) testing on Pipelink customer portal using Appium (XCode) on Apple iPads
• Strong knowledge of Extraction/ Transformation/ Loading (ETL) process flow.
• Worked with Data Warehousing developers who extensively used ODI, OSB, ESB to design mapping to move data from source to target database using Stages to do the functionality.
• Monitored the Enterprise Service Bus ( ESB) console for system integration and pre- production testing phases
• Extensive work in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading and knowledge in Data Modeling
• Prepared status summary reports with details of executed, passed and failed test cases
• Interacted with developers, Business & Management Teams and End Users.
• Implemented SQL scripts, stored procedures, triggers and indexes for various 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 extensive Manual testing of Services, Database and UI Integrated
• Responsible for API Testing, Web Service Testing using SOAPUI (Test Suite, Assertions and Mock services)
• Performed Manual Back End Testing-using SQL queries, generating reports to ensure data integrity and validate the inserted and updated data.
• Strong experience in Agile Scrum Methodology, Test Driven Development(TDD), Behavior Driven Development(BDD) and ATDD
• Performed cross browser and cross platform web testing with Selenium WebDriver.
• Developed and maintained automated regression test cases in Selenium using Java programming language 
• 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

ETL/Data Warehouse Tester

Technologies/Tools Used: Quality Center 9.0, QTP/UFT, Informatica (Power center Designer, Workflow), BI, Oracle 8i, PL/SQL, Teradata, SOAPUI, REST, TSQL, Stored Procedures, Triggers, Java, J2EE, JavaScript, Unix, Vbscript, Windows 7, NT, Microsoft Test Manager(MTM), Microsoft Office 2007/2010

• 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
• Responsible for testing the FCC Mortgage Point of Sale & Loan Origination system
• Gathered knowledge on Home Loans Point of Sale and Loan Origination system
• Analyzed Enterprise Architecture ( EA) artifacts in Sparx  Enterprise
• Validated Loan Payment System for any Fraud/Penetration activities
• Evaluate the   POS  application and identify any gaps or defects and worked with Dev Team for resolution 
• 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
• Through Manual and automated ways performed Test/Validation of Web Services, ESB based integrations & ETL data flows
• 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
• Understood the data model represented in logical and physical enterprise data warehouse schemas
• Designed and Developed data validation, load processes and test cases using PL/SQL, SQL
• Proficient in working with different Databases like Oracle, Teradata, MS SQL Server on tools like Toad, Oracle SQL Developer, SQL*Plus. 
• Experience in developing Selenium tests for Java applications using IDE's such as Eclipse
• Developed automation test scripts (Java and Vbscript) to test the database by retrieving the data from the tables using HP QTP/UFT.
• Created Automation scripts using VBScript to initiate UFT application and execute a specified number of scripts sequentially.
• Configured and connected HP ALM with UFT and stored all the automated test scripts into HP ALM. 
• Developed QA processes automation test scripts using Selenium to test Web based user interfaces for different type of browsers.
• Responsible for fixing and maintaining regression automation test scripts (Java) for end to end testing using Selenium Web Driver
• Extensively performed Web Services testing Manually for REST, SOAP, and WSDL based services.
• Involved in testing data mapping and conversion in a server based on Informatica data warehouse
• Regular monitor and track high Priority defects, write positive and negative test cases, improve traceability, to reduce project risk and increase the quality of the application 
• 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

Technologies/Tools Used: QTP 8.0, Quality Center, ALM, Java, Selenium, JavaScript, Vbscript, SOAP, J2EE, Jira, LINUX, UNIX, POS (Point of Sale), TOAD, Oracle, SQL, DB2, Web Sphere, Microsoft Visio, Microsoft Project, TFS, Microsoft Test Manager(MTM)

• 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
• Responsible for customizing Selenium API to suit in testing environment.
• Performed Data driven (TDD) testing to validate the components displayed on the website using Selenium
• 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 per the Business Rules and Business Strategies of the APPRO application
• Identified the test data by organizing multiple test data review meetings and created test data for specific Test Scenarios and Test Cases using SQL Insert scripts
• POS terminals testing in a Fully integrated PODS systems environment
• Forms, multimedia and other files loading into POS terminals and perform smoke, regression testing on touch and non- touch based POS terminals
• Performed credit card and CreditAPP fraud testing per zero tolerance fraud policy
• 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
• Responsible for performing Manual testing and creating and executing the selenium scripts and analyze the test results.
• Used Firebug to identify web elements using Xpath and CSS selectors
• Performed Manual and Automation testing of CreditAPP Mobile application (iOS and Android) using Appium
• Performed Functional, System-Integration, End to End, Regression testing and User Acceptance Testing Manually and Automated
• Verified the "fixes" for the reported defects by performed Regression testing using QTP and provided defect status reports to the management
• 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 for Load, stress testing of 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 daily

Confidential

Sr Quality Assurance Analyst

Technologies/Tools Used: Oracle, Java, JavaScript, Selenium RC, Toad, SQL, SOAP, XML, MS SharePoint, MS Team Foundation Server(TFS), Microsoft Test Manager(MTM), SAP 4.6C (SD, MM, FI, CO, HR), SAP ECC, QTP 8.0, Vbscript, ALM, Quality Center 9.0, Perfecto, LoadRunner

• Involved in the creation of System Test Plan which outlines Scope, Objective, Focus and Approach of the testing effort for this project
• Participated in the Requirements review meeting to better understand the project
• Created Test scenarios based on the SRS and Use Cases using Microsoft Test Manager(MTM)
• 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.
• Performed Testing on  Guidewire  Systems of Policy Center and Billing Center application 
• Involved in Manual and Automated Testing of Web based, Client/Server and mobile applications (iOS and Android)
• Involved in Manual and Automated Testing of SAP ECC6.0 and Client/Server based applications using SAP TAO and   Worksoft  Certify tool. 
• Responsible for writing automation test scripts in QTP for different application features. 
• Coordinated Test Execution & Enterprise-Wide Testing of Quality E2E test environment supporting J2EE/J2ME Applications.
• Heavily used Test / Defect management tool Quality Center/ALM, QTP for managing test cases, executing and storing results and raising defects
• Actively involved in SDLC and STLC process and used tools like ALM, Selenium RC, SOAP UI
• Automated the regression test cases using the Selenium & TestNG. 
• Automated the Test Cases using Selenium RC, Java Eclipse and JUnit.
• Performed mobile Automation testing on Android & IOS using Perfecto Mobile
• 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

Technologies/Tools Used: QTP 9.0, Vbscript, Quality Center 9.0, Selenium RC, LoadRunner, 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

• 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 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 Manual 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
• Experienced on Mobile Automation (Android & IOS) using Appium (Selenium)
• Have good Experience on testing regression suite by Net weaver portals across SAP Modules.
• Worked with business team to Manually 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