PROFESSIONAL SUMMARY:

• 7 years of Experience in the IT industry with emphasis on Quality Assurance/Software Testing with exposure of both Manual and Automated testing tools.
• Expertise in validating and testing, Client - Server and Web-Based Applications in different environments and all the phases of Software Development Life Cycle.
• Experience in Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC)
• Experience in resolving on-going maintenance issues and bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in Data warehouse testing and ETL testing using several ETL tools and PL/SQL
• Developed stored procedures, Functions and Triggers, Complex SQL queries using Oracle PL/SQL
• Experience in managing testing lifecycle process using Waterfall, V-Model and Agile.
• Strong skills in implementing QA standards, and testing methodologies for Enterprise GUI, and WEB applications using Use case documents.
• Diversified experience in testing at every phase of the testing process: Functional, Integration, Regression, User- Acceptance, System, End-to-End and Black Box testing.
• Experience in developing and executing test plans and Created test plans and test scenarios to prove the compliance of the solutions.
• Experience as a Senior Software quality Engineer in Big Data, ETL, Functional, and API & Interface testing using Ascential Data Stage 7.5.2 Server edition, IBM Info Sphere Data Stage 8.7 Server & Parallel edition, Hadoop, Spark, UNIX, SQL, and Python.
• Expertise in ALM as a complete Test Management Tool for Management, Requirements, Test Plan, Test Lab, Defects and Dashboard.
• Experience in creating Requirements Traceability Matrix to ensure comprehensive test coverage of Business requirements.
• Knowledge in Business Intelligence tools like Business Objects, MSBI, Cognos and OBIEE.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/data mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Design & developed Data Driven Framework using QTP/UFT & VBScript to validate test case against different data set.
• Experienced in Back-End testing to ensure data consistency on front-end by writing and executing SQL queries on the relational databases.
• Worked extensively on RDBMS databases Oracle, SQL and MySQL.
• Experience with configuration and testing ETL Technologies (Data Extraction, Transformation and Loading)
• Worked on DataStage tools like DataStage Designer, DataStage Director and DataStage Administrator.
• Extensively used SOAP UI to test Web Service/Rest API.
• Ability to handle multiple tasks and work independently as well as in a team.
• Self-starter, quick learner. Schedule driven - Results focused. Attention to detail. Strong desire for quality.
• Good judgment skill to access high risk areas on which to focus testing efforts.

TECHNICAL SKILLS:

Processes/Technologies: Rational Unified Process (RUP), Waterfall, Agile (Scrum) ETL, Datastage

Operating Systems: Windows, UNIX, Linux, and Vista

Quality Assurance Tools: Quick Test Pro/UFT, Quality Center/ALM, Clear Quest, SOAPUI, Selenium IDE

Languages: SQL, PL/SQL and T-SQL, HTML, and XML, JAVA

Requirement Management: MS Office Suite (Word, Excel, Power Point, Visio), Share Point Portal

Databases: Oracle, MS Access, PL SQL and SQL server

PROFESSIONAL EXPERIENCE:

LEAD QA Automation Engineer

Confidential - St. Louis, MO

Responsibilities:

• Lead integration test execution efforts, requiring setup of test sets, monitor test execution progress, remove roadblocks for testers, defect reporting, tracking and calls to resolve defects. Report status and test metrics to management as required
• Extensive experience in Black Box testing of Functionality, Smoke, Regression and User Acceptance Tests
• Testing on multiple trading platforms simultaneously, keeping test data current and scripts up to date
• Experience testing in Agile and Waterfall environments
• Collaborate with developers on testing status, identifying and reporting defects, providing key details for reproducing defects, and maintaining detailed QA documentation and traceability of requirements
• Mentor other testers and project teams to create comprehensive test plans, gather test cases, and execute verification testing to accomplish milestones
• Act as key liaison to other associates on the use of HP UFT, QC and various testing techniques, especially in areas of SME on applications being tested
• Adhere to QA processes put in place, from creation of automated scripts, setup, execution, debugging, defect reporting and follow through via escalating defects to draw in necessary resources for defect resolution in order to move forward and avoid delays
• Working on Agile project, review stories in sprints to identify where automated scripts would benefit the project, develop the scripts and execute them as part of the Agile project testing
• Work with application development teams to review Applications and determine if any areas are candidates for testing via script automation, follow-up with appropriate script development
• Analyze and convert manual tests into automated tests where applicable
• Interpret business and functional requirements to develop comprehensive automated test scripts
• Setup framework for new tests in a manor so that additional tests can be added easily
• Develop Tests using VB Scripting, Reusable Actions, Functions and Descriptive Programming adhering to QA standards

Environment: Automation Test, HTML, XML WinRunner, Load Runner, Win 7 OS and MS Office WindowsXP, Oracle, UNIX and SQL, HPQuality Center 8.2/9.2, QTP, LoadRunner 8.2, VB Scripting Oracle, PL/SQL

Sr. QA Automation Engineer/ETL Tester

Confidential - Dublin, OH

Responsibilities:

• Analyzed the Business Requirements Document (BRD), developed Test cases and Test scripts for the application under test.
• Developed Test Scripts to implement Test Cases, Test Scenarios, and features for TDD (Test Driven Development), BDD (Behavior Driven Development) using Cucumber.
• Wrote BDD, UAT using Gherkin format and implemented the step definitions using Cucumber.
• Performed Data-Driven Tests by passing different sets of data and checked whether the information entered is updated into the database where we use Page Object Model as design pattern.
• Extensively used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using Informatica and designed data conversions from wide variety of source system.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
• Worked with Data Completeness, Data Transformation, Data Quality, Integration, UAT testing and Regression testing for ETL.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Highly proficient in creating data sources, data source views, dimensions, measures, measure groups, perspectives, partition aggregations.
• Configured Selenium Web Driver, Test-NG, Maven tool.
• Used Maven build tool to implement the framework dependency Jar files.
• Specialized in using Selenium Webdriver with TestNG frameworks in creating test scripts, test suites and HTML reports.
• Experienced in Apache POI Jar for reading Excel file using Java IO operations.
• Created Selenium automation scripts in java using TestNG.
• Used various TestNG annotations for executing group functions in XML.
• Validated database query results with test data.
• Used Firebug/ IE Developer Toolkit and validate CSS Locators, html ids to identify elements and also Selenium IDE to capture and run the test cases.
• Raised defects while doing System Integration Testing (SIT) and regression testing.
• Performed defect tracking and bug classification using tools like JIRA.
• Experience with cross browser and compatibility testing to test whether the web applications are working as desired in different browsers and environments using Selenium Grid.
• Experienced in SOAPUI/RESTful Web Services Testing. Validated request and response XML, SOAP and RESTFUL Web service calls.
• Performed browser compatibility testing on Windows.
• Developed Test Analysis reports and Master Test Plans for each testing effort.
• Performed hybrid mobile testing using Appium.
• Reviewed the testing conducted by the peer testers and gave necessary suggestions.
• Maintained Selenium & Java Automation Code and resources in source controls like GIT, Jenkins for improvements and new features.
• Involved in Unit Testing, Handled issues in System testing and UAT.
• Designed scenarios in JMeter to perform Load and Stress tests and to analyze results.
• Executed some test cases manually. Compared and analyzed actual results with expected results and reported the deviations to appropriate individuals for resolution.

Environment: Selenium Web driver, Eclipse, JMeter, JIRA, Java, JavaScript, HTML, X-path, Windows, Oracle, Fire bug, Fire Path, SQL query profiler, Sure Step Software, GIT, Informatica, Appium.

BIG DATA ETL TESTER

Confidential - Philadelphia, PA

Responsibilities:

• Responsible to perform Big Data testing as a tester.
• Responsible to identify the Scope of testing, Project Estimation and Resource planning for a project.
• Responsible to prepare the test strategy in Requirement gathering phase and maintain testing standards.
• Validated the Source tables data migrated into the Hive database.
• Responsible to validate the live data once the code is rolled out into production.
• Compared the UI and Backend outputs after the test execution is done using Hive queries.
• Worked extensively on Aginity workbench for pure data systems for Analytics to access Procedures and Diagnosis tables that are in Netezza.
• Proficient in writing complex Hive queries.
• Wrote complex SQL queries to test the data in Oracle using TOAD and validated the data.
• Proficient in using Hadoop commands to see the list of files, to take counts of the HDFS files.
• Responsible to support Business team on their Unit testing.
• Responsible to validate the data transferred through Sqoop between Oracle DB and HDFS.
• Determine milestone deliverables, Communicate changes to schedule, Determines impact of schedule changes on quality objectives, Coordinates schedule with dependent groups.
• Define Business Process, identify the risk, doing risk analysis and providing baseline acceptance criteria and deliverables.
• Participate with the Sprint Planning and sizing meeting and provide inputs on the testing efforts based on the user story complexity and dependency.
• Requirement analysis, co-ordination with cross functional teams, offshore co-ordination, Daily/Weekly status reports, Change request management, defect management and test review & sign-off.
• Verify different scenarios in all the stages of the Data Lake after loading the data from source database into the respective tables.
• Participate in the design and grooming sessions with the Product owner, development team to get the understanding of the user story business requirements.
• Create defects in Jira and retesting after the defect fix.
• Performed Smoke testing after code deployed before starting the detailed validation.
• Prepare Test Conclusion or the test summary report.
• Participate in the Sprint Retrospective meeting.

Environment: HDFS, Oracle, Netezza, Toad for Oracle 12.1, Hue, Aginity workbench, Hive, MobaXterm, Jira.

Confidential, Detroit, MI

ETL Data warehouse Tester

Responsibilities:

• Performed different kind of testing such as Functional testing, Integration testing, and Regression testing.
• Extensively Queried through SQL to check the database record.
• Developed SQL scripts to perform Backend Testing.
• Developed several SQL queries for data retrieval from TERADATA and used every utility available in including MLOAD, FLOAD, FAST EXPORT, and BTEQ AND TPUMP.
• Converted SQL queries results into PERL variable and parsed the same for multiple reasons.
• Worked on Various SQL Server procedures for various Bugs, executed queries in test databases using SQL queries.
• Tested the HIPPA 837/835 transactions according to test scenarios and verify the data on different modules.
• Defect Reporting & Defect tracking using Quality Center.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Quality Center.
• Involved in Identifying of the unused test cases in the Test Plan in Quality Center and prepared a consolidated doc to delete the test cases.
• Involved in the modification of the existing scripts parameterization of the new as well as existing scripts.
• Assisted in System Test and UAT testing scenarios as required.
• Performed UAT testing.
• Responsible for creating manual test scripts to include Functional Test, Regression Test, UAT, Migration Test and Study Configuration Test.
• Performed UAT (User Acceptance Testing) and executed to verify requirements, look and feel of the applications.
• Manually performed GUI and Functionality testing of the Application front end.
• Attend weekly meeting with team leads, manager, and developers to discuss the issues found during the creation of the test cases/scripts.
• Used Test Director as the defect-tracking tool to enter defects regarding the issues found during testing.
• Performed Stress, load, and Performance testing using LoadRunner.
• Created DB Queries using SQL, manually tested them and documented them in the test plan for testing the Excel Based Application.
• Used Microsoft Excel sheets to create a Traceability Matrix and the Test Matrix, this gave us an accurate database of the bugs and helped estimate and analyze the development process.
• Used Test Director to analyze, track and report defects.
• Worked on uploading all the Test cases to the Test Director for the current and prior releases.

Environment: Test Director, HTML, XML WinRunner, Load Runner, Win 7 OS and MS Office WindowsXP, Oracle, UNIX and SQL, HPQuality Center 8.2/9.2, QTP, LoadRunner 8.2, VB Scripting Oracle, PL/SQL

Confidential, New York, NY

ETL Data Warehouse Tester

Responsibilities:

• Used Quest Software's Toad application to set up data, create, and execute SQL script on Oracle 9i database.
• Completely involved in Database Testing.
• Design and development of ETL processes using Data Stage ETL tool for dimension and fact file creation. Coordinating offshore team and making the offshore team work smoothly and getting the quality work from offshore on time.
• Validating the complete source to target mappings along with transformation rules.
• Created and executed detailed test cases with step by step procedure and expected result Experience in ETL Data Warehousing, database testing using Data Stage for Workflow process.
• Profound insight to determine priorities, schedule work, and meet critical deadlines within budget guidelines.
• Experience in working independently and multi task without negative impact to timelines or quality.
• Strong Knowledge on the phases of Software Development Life Cycle (SDLC) Methodology.
• Experience in preparing the traceability matrix, test scenarios and test cases.
• Involved in preparation of Requirement Traceability Metrics (RTM), Software Metrics, Defect Report, Weekly Status Reports and SQA Report using Test Director.
• Perform black box testing by designing and constructing test cases, test data and test execution.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Review the test cases written based on the Change Request document. Testing has been done based on Change Requests and Defect Requests.
• Preparation of System Test Results after Test case execution.
• Experienced in writing UNIX script.
• Extensively used PL/SQL features such as procedures, functions, packages & database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• Tested data migration to ensure that integrity of data was not compromised.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Review the test cases written based on the Change Request document. Testing has been done based on Change Requests and Defect Requests.
• Preparation of System Test Results after Test case execution. Created database objects such as tables, views, synonyms, indexes and sequences as well as custom packages tailored to business requirements.
• Created Indexes and partitioned the tables to improve the performance of the queries.
• Designed and Developed partition exchange process to minimize user access downtime to the warehouse. Developed SQL* loader scripts to load the data into the custom tables.
• Involved in debugging and tuning the PL/SQL code, tuning queries, optimization for the Oracle database and wrote Unix Korn Shell Scripts to schedule the business process.

Environment: Ascential DataStage 7.x/6.x, (Designer, Director, Manager), Erwin, Oracle 9i, TOAD, XML, XSLT, XML Spy 2008, SQL Server 2000, DB2, MS-Access, XML files, PL/SQL, UNIX, Shell, Windows NT