SUMMARY

• 6+ years of QA experience in Automation, Manual and ETL/Datawarehouse testing of Web Apps and client with specializing in Software Quality Assurance Testing, QA Automation Engineer proficient in testing on Client/Server and Web based Applications.
• Experience in all phases of Software Testing Life Cycle (STLC), Software Development Life Cycle (SDLC), Bug life Cycle and Methods like Waterfall and Agile.
• Extended experience in systems testing, integration testing, UAT testing, positive and negative, functionality testing, and regression testing.
• Expertise in Manual Testing and Automation Testing and Service Oriented Architecture.
• Experienced in SQA (Software Quality Assurance) including Manual and Automated testing with tools such as HPE Unified Functional Testing,
• Experienced in Automation testing using Selenium and HPE Unified Functional Testing.
• Created and Maintained Server - side Integration Test using Python and Selenium Web driver.
• Experienced in using HP Interactive automated testing tools like HPE Unified Functional Testing.
• Experience in working with open source tools Selenium (Selenium IDE, Selenium RC, Selenium Web Driver), Eclipse and preparation of automation test framework.
• Extensive experience in using Automated tools like Ruby Cucumber test framework for Client/Server, Web and database applications
• Involved in setting of QA Test environment with simulated POS test environment.
• Knowledge of Agile methodology along with Automation Tools and Protractor.
• Exposure to web technologies like HTML, XML, CSS.
• Experience in Understanding the code written in different programming languages Java, Java Script, SQL, and databases like Oracle, SQL Server.
• Experience in writing test cases as per the Software requirement specifications.
• Experience in Back - end testing, data validation, Database testing using SQL queries.
• Executed automation test scripts using windows and Linux platforms for MFP products.
• Experience in writing and executing SQL queries to perform Data Validation and Back end testing of databases to check the integrity of data.
• Hands on experience in medical domain as well Worked with providers and Medicare or Medicaid entities to validate Internet portals.
• A resourceful team player with good Interpersonal, TEMPeffective problem solving and decision-
• Experience in Data Analysis, Data Validation, Data Verification, Data Cleansing, Data Verification and identifying data mismatch.
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Extensively worked on databases including Oracle, SQL Server.
• Tested the ETL flow and other ETL Processes (Data Warehouse Testing)
• Expert in writing SQL queries and TEMPhas expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Worked in both Agile Scrum and waterfall methodology
• Extensively written test scripts for back-end validations
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica
• Experience in testing the BI reports generated from different BI tools like Cognos and tableau
• Experience in testing source files and validating the data loaded to staging tables.
• Experience in testing and writing SQL statements.

TECHNICAL SKILLS

Testing Tools: HPE Unified Functional Testing, Selenium Web DriverLanguage/ Script VBScript (UFT), basic knowledge on (Python, Java, JavaScript, Shell Script)

Data Warehousing: Informatica, Data Stage

Reporting Tools: Tableau, Cognos, MicroStrategy

Bug Tracking Tools: HP ALM, JIRA

Databases Technologies: MS SQL Oracle PL/SQL, SQL*Plus, TOAD.

PROFESSIONAL EXPERIENCE

Confidential, Tennessee

Automation Test engineer

Responsibilities:

• Analyzed the Business Requirements Document, put input in Test Plan and prepared detailed Test Cases for new functionality.
• Associated with development team to understand technical design and architecture for test planning.
• Designed and developed Page Objects using Page Object Design Pattern and Selenium WebDriver.
• Develop automated acceptance tests using technologies such as: HPE Unified Functional Testing
• Developed HPE Unified Functional Testing
• Created and enhanced numerous test scripts to handle changes in the objects, in the tested application’s GUI and in the testing, environment using HPE Unified Functional Testing
• Developed Automation scripts for new enhancements using VBScript
• Used Selenium WebDriver using TestNG and Eclipse for automation in Hybrid model.
• Used VBScript framework for scripting.
• Tested request and response XML's based web services interfaces using SOAP UI.
• Performed Web Services Testing and XML validation by creating test case suite using SOAP UI.
• Created whole test framework using HPE Unified Functional Testing and execution.
• Regression test cases were written and automated.
• Tested compatibility of application for dynamic and static content under various cross browsers using HTML IDs and XPath in UFT.
• Involved in validation testing.
• Updated Test Plans and Test Cases periodically to manage changes in requirements.
• Uploaded test cases executed test cases and logged defects in HPALM.
• Connected to database to Query the database using SQL for data verification and validation.
• Performed back end testing on Oracle Database by writing SQL quarries.
• Followed Agile testing methodology, participated in daily SCRUM meetings and testing each SPRINT deliverables.
• Participated QA weekly meetings and various other meetings and discussed Enhancement and Modification Request issues and defects in the application.

Environment: HPE Unified Functional Testing, VBScript (UFT), HPALM, MS SQL, Oracle, TOAD UltraEdit, Unix.

Confidential, MO

Datawarehouse Tester

Responsibilities:

• Analyze the Business Requirements and closely work with the Business Team to get the clarifications addressed
• Review the Test Scenarios/Test Cases with Business Review Business requirement modules and provide Test estimation to project management
• Analysis of Business requirements & Design Specification Document to determine the functionality of the ETL Processes.
• Developed Test Cases for requirements, ETL Data Validation and Report testing
• Planning for Test Execution activities to accomplish tasks on daily/weekly basis
• Actively participate in review meeting including Functional Spec, Test Plan and Test Case
• Conducted test case reviews to ensure scenarios accurately capture business functionality.
• Used HP ALM to track and report system defects
• Worked on ETL tools Informatica.
• Tested ETL mappings dat transfer data from Oracle source systems to the Data Mart
• Worked with ETL Source System and Target System (ETL Mapping Document) for writing test cases and test scripts.
• Written several SQL statements to confirm successful data transfers between source and target.
• Executed SQL queries to perform back-end database testing and verify user data
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Working experience on daily status reporting & managed end to end testing

Environment: Informatica, Oracle, SQL, PL/SQL, MS Office Suite, HP ALM, SQL Server, Unix, Windows, Unix shell scripts, Cognos.

Confidential, NY

DWH/ETL Tester

Responsibilities:

• Was responsible for writingSQLqueries to pull data from database.
• Having Back - end testing experience in writing and executingSQLQueries on Oracle, DB2 andSQLServer databases.
• Involved in writing Test Cases by using Wireframes, Design docs and Acceptance criteria.
• Tested in multipleFacetUAT environments.
• Experience in writing complexSQLqueries in order to view successful transactions of data and for validating data.
• Performed UAT Testing Manually in coordination with UAT group to ensure correct business logic.
• Involved in new development, support, enhancement of application.
• Worked with business leaders to translate business requirements and processes into test cases according to Facets package requirements and subsequent TEMPeffective configuration.
• Written SQL queries for querying data against different data bases for data verification process.
• Involved in preparing the Test Plan and Testing Strategies for Data Warehousing Application.
• Preparation of technical specifications and Source to Target mappings.
• Written test cases to test the application manually in HPALM
• Tested the different sources such as Flat files, Legacy Flat Files, SQL server 2008 to load into the oracledata warehouse
• Created ETL test data for all ETL mapping rules to test the functionality of the ETL process based on mapping document.
• Tested different types of reports, like Master/Detail, Cross Tab
• Defects identified in testing environment where communicated to the developers using defect tracking tool HPALM
• Tested several complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Creating test cases for ETL mappings and design documents for production support.
• TEMPEffectively communicate testing activities and findings in oral and written formats.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Worked with ETL group for understating mappings for dimensions and facts.
• Worked on issues with migration from development to testing.
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic.

Environment: HP ALM/Quality Center, SQL Server, XML, APIs, SOAP UI, ETL, Claims, EDI, Windows.