PROFESSIONAL SUMMARY:

• Senior QA Engineer with over 12 years of experience in Manual and Automation Testing. Involved in writing and executing Test Plan, Test Methodology, Test Scenarios, Test Data, Test Summary Reports, Test Cases and Test Documents based on User requirements, System requirements and Use case documents. Well - versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC). Diversified experience in Manual Testing serving various domains such as Financial, Mortgage and Logistics domain applications.
• Complete understanding of Software Development Life Cycle (SDLC), Quality assurance concepts, manual and automated testing techniques.
• Strong knowledge in implementing Waterfall and Agile Methodology by analyzing requirement specifications and user stories.
• Experience in preparing and maintaining Automation Frameworks in Cucumber , Selenium , UFT.
• Extensive experience in ETL Informatica/ Enterprise Data warehouse backend testing and BI Intelligence reports testing.
• Performed Extraction of data using SQL queries from different database sources like Oracle, Netezza, Rapid SQL server for analysis.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Data Warehouse.
• Experience in preparing Test plan, Test scenarios, Test cases and Test summary reports for both automated and manual testing based on User requirements, System requirements, user stories and Use case documents.
• More proficient in communicating with Development, Design and other associated teams along with the stakeholders.
• Acted as a liaison between technical and business teams to ensure client needs are met in multiple projects.
• Accustomed with multitasking by handling testing, analysis and reporting at the same time.
• Dynamic and assertive team player with a strong inclination to improve and optimize process development and implementation.
• Adept at learning new tools & technologies in a very short span of time and applying those skills in projects.
• Participated in Stand-up meeting, walkthrough meeting, and weekly automation meeting with all other QA, weekly assessment meetings with developers.
• Identified and prioritized defects and then worked closely with the development team to resolve any issues.
• Experience in integrating Cucumber automation scripts on Continuous Integration and Continuous development (CICD) tools like Jenkins.
• Worked with Business users (Various departments) for Functional testing and UAT for different projects, Co-ordinated with users for Acceptance criteria.
• Expert in Data Visualization development using Tableau to create complex, and innovative dashboards, and publishing to the end users for executive level Business Decision. Notify admin team for changes in user, user groups, and scheduled instances for reports in Tableau reports.
• Extensive experience in leading functional, integration, regression, black box testing, white box testing, back-end testing, and browser compatibility testing.
• Good knowledge on Source Version Control tools like GIT and SVN.
• Good at defect-reporting and defect-tracking tools like JIRA, HP ALM.
• Strongly committed to timelines for deliverables, accuracy and quality of assignment, Worked Independently and big teams as well.
• Effective oral and written communication skills with more concentration on details of the project guidelines.

TECHNICAL SKILLS:

Databases: Oracle, MySQL, Rapid SQL, Netezza, TOAD

Testing Tools: HP ALM Win Runner, Rational Clear Case, Rational Test Manager, SharePoint

Automation Tools Cucumber:, Selenium, UFT (Formerly QTP), Ruby, eclipse, Jenkin, GIT

ETL Tools.: Informatica, Informatica Data replication, IDR, Golden Gate, MDM

B: ug Tracking Tools JIRA, HP ALM, Quality Centre

Operating system: Windows, Unix

Languages/Scripting: Jav a, HTML, XML, Restful, Soap, Java Script

WORK EXPERIENCE:

Confidential

Senior QA Analyst, Reston, VA

Responsibilities:

• Perform Requirement Analysis to make sure those serves business goal and appropriate enough for developer to implement.
• Developed end to end SQL queries to validate huge volume of data and validate all possible joins and lookups for business requirement.
• Extensively involved in business operation testing, User Acceptance testing (UAT), end-to-end Integration and Regression testing.
• Worked with cross team application for in-bound and outbound processing.
• Extensively supported Production Monthly close in terms of reconciliation, involved in supporting Auditors in terms of reconciliation and providing walkthroughs.
• Thorough analysis, unit testing and Integration testing with other applications of database objects & T-SQL statements before deployment to the production server.
• Performed data analysis and data profiling using complex SQL on various sources systems.
• Extensively involved with Infrastructure and Operation teams for deployments and availability of services in Continuous integration and continuous development (CICD)
• Work as SME on Business events and functional flow to build automation suite for real time scenarios.
• Executed regression automated monthly suite in Cucumber thru Jenkins and modify the feature code.
• Expert in reconciliation of Data Movement between Source vs. Datamart & Business Objects reports.
• Good knowledge in TIBCO EMS topic and queue.
• Performed transformation process which confirms the data to the target data model and applies the necessary derivation as per business rule.
• Involved in Data Quality Rules Validation. Performed Positive and Negative Business Scenarios & DQ Rules.
• Worked with ETL groups and Acquisition team and business analyst for understating mappings for dimensions and facts
• Extensively involved in data replication thru Informatica data replication (IDR)from oracle to data warehouse.
• Strong ability in developing SQL queries for validating the data from 3NF to fact and dimension and views, thru data mart.
• Build many Tableau reports using Bar Chart, side-by-side bars, stacked bars, maps, tree map, pie charts, line charts, interactive reports using Tableau Desktop and Dashboard.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Evaluated overall results of test execution, performed risk assessment, and reported status and recommendations for modifications to test plan and/or schedule based on findings.
• Actively participated in defect review meetings and created defect/test metrics/ dashboard reports.

Environment: Oracle, Netezza, Informatica, MDM IDR, TIBCO, IBM Door, Cucumber, Jenkin, CICD, Git Hub, Ruby mine 8.0, JIRA, WinSCP, Putty, Tableau.

Confidential

Senior QA Analyst, Mclean VA

Responsibilities:

• Developed complex SQL queries for querying data against different data bases for data verification process
• Thorough out the project in various iterations/Sprints - conducted system testing, integration testing, functional testing and integration testing.
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
• Extensively interacted with developers, business& management teams to understand the business requirements and ETL design document specifications.
• Participated in regular project status meetings and QA status meetings.
• Extensively used and developed SQL scripts/queries in backend testing of Databases.
• Written test cases to test the application in Quality Center 9.0 and 11.0(ALM)
• Defects identified in testing environment are communicated to the developers using Quality Center.
• Prepared daily status reports with details of executed, passed, and failed test cases and defect status.
• Tested several complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Setting up, monitoring and using Job Control System in Development/QA/Prod.
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to test the flat files data in the databases,
• Scheduling and automating jobs to be run in a Unix batch process.
• Performed Manual Testing and automated test scenarios for GUI, Functionality, Boundary, Security and Regression testing using UFT.
• Parameterized input fields manually and automated testing UFT.
• Worked on Web services thru UFT 10, created ACI, AI Ready and MISMO XML files through UFT.
• Testing the application using WebLogic Messaging system (JMS) to validate subsystem triggers in the WebLogic server.
• Responsible for verifying the application logs and report issues to the developers.

Environment: Informatica, UFT, HPALM, TOAD, Oracle, DB2, Rapid SQL, MS-Excel, MS-Visio, Rational Clear case, Doors, Putty, WINSCP, UNIX Web Services, SOAP, WSDL.

Confidential

Senior QA Engineer, Sterling, VA

Responsibilities:

• Reviewed requirements for testability and usability, consulted development team with regards to system functionality.
• Performed Backend Testing with SQL commands on Database and verified/validated the test results
• Involved in Positive Testing, Negative and End-to-End Testing.
• Extensively involved in Data and Format Validations prior to data upload for claims processing.
• Involved in Testing Methodologies which included Black Box, Functional, System, Regression and User Acceptance Testing.
• Involved in preparing Test Plan, Test Scripts and Test Cases based on the Functional Requirements and Business Rules and prepared test results after every test and Regression Test Cycle.
• Involved in Web Services testing of the application after the application was tested by the functional testing
• Involved in testing the Contract Creation Process in Oracle Applications- Service Contracts Module.
• Tested the Payments Lifecycle for the claims submitted in Oracle Applications- Accounts Payables Module.
• Involved in testing of the Upgrade Instance from Oracle 11.5.6 to 11.5.10.
• Executed parallel browser testing on various machines using Selenium Grid and performed cross browser testing.
• Executed parallel browser testing on various machines using Selenium Grid and performed cross browser testing.
• Enhanced the feature code in selenium to run regression suite.
• Tested SOAP and REST web services using the different assertions like HTTP assertion, security assertions, and XPath assertions in SOAPUI.
• Involved in testing the Adjudication Rules for the claims submitted by the service centers.
• Tested the claims data format before loading into Oracle by B2B workbench.
• Wrote SQL Queries to test Data validations and Consistency using TOAD.
• Involved in the entire Life Cycle of QA Methodologies starting from Planning, Capturing, Creating, and Executing, Reporting and Tracking the defects.
• Documented bugs with evidence and reported them with detailed information to the development team.
• Coordinated with developers to fix the problem and enhancing the application.
• User- Acceptance Test (UAT) with 100 % compliance and all end-to-end test specifications.

Environment: Oracle, Toad, Unix, Selenium WebDriver, Selenium Grid, Java, Jira, SoapUI, HTTP Client, Eclipse.

Confidential

QA Engineer, Secaucus, NJ

Responsibilities:

• Responsible for planning activities, creating test plan, requirements Traceability Matrix and standard templates (Daily status, defect status, defect process etc.)
• Analyze the requirement documents and creating test cases to cover all the possible scenarios
• Perform white box testing on the Informatica code that developers built and validate that against the system requirement documents
• Validate the ETL mappings and developed SQL queries for Big data to validate the data from the source to the target tables.
• Developed end to end SQL queries to validate huge volumes of data and validate all possible joins and lookups in system test environment
• Working with the development team to create a suite of test data (both input files and expected results) that fully exercises data validation and actual ETL functionality
• Extensive use of UNIX commands to move source files (XML and txt) and trigger files to ETL QA server.
• Using workflow manager to edit, validate and run workflows, worklets and tasks.
• Using workflow monitor to monitor the status of workflows and sessions.
• Test Aggregator, Sorter, Router, Filter, Joiner, Expression, Lookup and Update Strategy, Union, Sequence Generator transformations in Informatica
• Extensively worked with large number of complex transformations to validate marts and facts tables.
• Querying data from different database tables as per the requirement and executing the source queries from workflows.
• Using PL/SQL developer for generating SQL queries for checking the Data Transactions and Database Integrity
• Perform UAT testing to verify that user requirements are met.
• Responsible for verifying the session logs for all IDR workflow sessions and report issues to the developers.

Environment: JIRA, UNIX, Oracle, Informatica, TOAD, SQL Server Quality Center, HP ALM

Confidential

QA Engineer, Reston, VA

Responsibilities:

• Created test plan and test cases for manual and automated testing from the business requirements to match the project's initiatives.
• Perform test data set-up for testing and update changes based on the requirements.
• Create new build and database backups. Create and maintain test environment.
• Responsible for writing Test plans, Test scenarios and Test cases based on business and functional requirements.
• Creating test case and test sets, tracing them to requirements and executing them in Mercury Quality center.
• Involved in preparation of Requirement Traceability Metrics (RTM), Software Metrics, Defect Report, Weekly Status Reports and SQA Report using Test Director.
• Performed black box testing by designing and constructing test cases, test data and test execution.
• Verified defects and Perform database functional, integration and regression testing as needed to minimize defects.
• Executed test cases, identified products issues, wrote detailed bug reports and participated in bug review during the product development stages.
• Performed database validation by comparing the source to the target.
• Responsible for the requirements: ETL Analysis, ETL Testing and designing of the flow and logic for the Data warehouse project
• Created and executed SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD.

Environment: UNIX, Oracle, Pl/SQL Developer, Informatica, TOAD, SQL Server Quality Center, HP ALM