SUMMARY

• Experienced in industry standard methodologies like Software Development Life Cycle (SDLC), Software Test Life Cycle (STLC) using Waterfall and Agile Model using SCRUM methodology and developing test automation solutions for Agile/SCRUM.
• Extensive experience in various Agile Ceremonies (Daily Scrum, Feature Walk, Story Elaboration, Story Pointing, Product Backlog Grooming, Sprint review, Sprint Retrospective).
• Strong working experience on Extraction, Transformation, and Load (ETL) of data from Legacy systems using Informatica, SSIS, SSRS.
• Extensive experience with Analysis, Test case plan designing, Metadata designing, designing Mapping sheet, ETL Designing, Testing, Bug Analysis, Bug Reporting and Re - Testing and UAT.
• Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion, and loading.
• Experience in maintaining Full and Incremental loads through ETL tools on different environments.
• Understanding of Data Models, Data Schema, ETL and created extensive store procedures, SQL queries to perform back-end data warehousing testing.
• Have experience working in Healthcare domain like Medical Claims, enrollment, and Benefit.
• Experience in analyzing the error caused to failure of the ETL load with reference to the log file and report them to the corresponding team to get it rectified.
• Extensive experience in ETL/ Data warehouse backend testing and Business Intelligence reports testing.
• Expertise in different types of testing like Manual testing, Functional, Integration, Smoke, Regression, Load, Database, End to End, Compatibility, and (UAT)User Acceptance Testing.
• Experience in Functional, Regression and System testing using Manual and Automated testing tools - Selenium WebDriver.
• Hands on experience in Oracle Warehouse Builder and informatica.
• Working experience with defect tracking tools like Jira and HP ALM/HP Quality Center (QC).
• Enthusiastic and aggressive to work as a self-starter with very minimal inputs as well as promising and good team player ability with highly organized efforts.
• Excellent Knowledge of Database Systems - SQL Server, DB2 and Data warehouse concepts.
• Excellent experience with source version control tools such as Git, TFS.
• Experience programming in Java, JavaScript, CSS, HTML, XML and SQL on Windows XP, Vista Operating Systems, LINUX, and UNIX environments.
• Proficient in SQL 2008/2010/2012 for testing database integrity.
• Resolved many Tech-Support Issues.
• Experience in designing Test Plans, Test Cases, Test Scenarios, Test Scripts and Test reports of manual and automated tests.
• Performed Database testing, and web-based testing on several test phases. Developed components for each transaction used in the test script or scenario by using Selenium.
• Configured Selenium WEBDRIVER and automated regression test cases using Selenium TestNG Java framework and Manual Testing.
• Experience in developing SQL scripts to validate the databases tables and reports data for backend database testing.
• Good analytical and communication skills and ability to work independently with minimal supervision and perform as part of a team.

TECHNICAL SKILLS

Methodologies: Agile/Scrum, Waterfall, SDLC, STLC

Testing Tools: Selenium WebDriver, TestNG, Cucumber, SOAP UI, Jenkins

ETL Tools: Informatica 8.1 and DataStage 7.0 and 8.0, SSIS

Reporting Tools: Business Objects, Crystal Reports, SSRS

Languages: Java, HTML, XML, CSS, SQL

Bug Tracking Tools: JIRA, HP ALM/Quality Center

Artifacts: Test Strategy, Test Cases, Test Plan, Requirement Traceability Matrix (RTM), Test Summary Report, Bug Report

IDE: Eclipse

Databases: MS SQL Server, MySQL, Oracle, MS Access, Teradata, DB2

MS Office Tools: Excel, Outlook, PowerPoint, and Word.

Browsers: Internet Explorer, Mozilla Firefox, Google Chrome, Safari.

Operating Systems: Windows XP/7/8/10, Mac OS, Linux, Unix

PROFESSIONAL EXPERIENCE

Confidential - Richmond, VA

Quality Analyst

Responsibilities:

• Complete understanding of Software Development Life Cycle (SDLC), Quality Assurance Concepts, Manual and Automated Testing techniques.
• Strong Knowledge in Implementing Agile Methodology by analyzing requirement and User Stories.
• Expertise in different types of testing like Manual Testing, Functional Testing, Integration testing, smoke testing and Regression Testing.
• Participated in different phases like PI Planning, Sprint Planning, Daily Scrum, Sprint Review and Retrospective.
• Worked with Provider data model, Claims data model and Member Data model.
• Experience in Database Testing using SQL Queries.
• Created new tables, wrote stored procedures for applications and some user defined functions. Created SQL scripts for tuning and scheduling.
• Worked with developers to create and update the defects, resolve, and track their status using Jira.
• Ability to interact with developers and product analysts regarding testing status and maintain detail QA documentation.
• Deliver the Test Results within timelines as independent tester and big teams as well.
• Performed User Acceptance Testing in the final phase of software development process to check the functionality of the software.
• Experience working with informatica power exchange integration with IICS to read data from condense files and load into SQL Datawarehouse Environment.
• Created and executed Test Complete automated Test Scripts.
• Extensive SQL querying on Staging, Datawarehouse and Data Marts .
• Strong in ETL data validation developed using Informatica / DataStage/ SSIS ETL environments.
• Used GitHub, Source code management tool.
• Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
• Tested and developed the mapping for extracting, cleansing, transforming, integrating, and loading data using Informatica.
• Determine test objectives and standards by studying Technical Requirement and written test scenarios, test cases and test Scripts.
• Actively Participated in requirements, design, and UI Specifications review meetings.
• Experience in SSRS & Tableau Report testing and validating the data.
• Responsible for Peer review of the documents like Test Plans, Test Cases written by team members.
• Used Record & Playback features of Test Complete to test application Functionalities.
• Responsible for complex SQL Joins, basic SQL function and Procedure executions.
• Co-ordinated with Offshore team and guided them with application functionality.
• Wrote SQL Queries to connect to the database and retrieve data for a specified set of test requirements.
• Used Tableau Tool to test the main dashboards and drill-down, to visually present the data according to the Client’s need.

Tools: Agile, Jira, SQL Server Management Studio 17, TFS, Test Complete, SSIS, SSRS Tableau, MS-Office, GitHub, MS SQL Server Reporting Services, MS SQL Server Integration Services, Informatica.

Confidential - Richmond, VA

Quality Analyst

Responsibilities:

• Analyzed Business Requirements Documents to get better understanding of the system both on technical and business perspectives.
• Performed agile testing, review the stories, and participated in Daily Scrum, Iteration Planning and Release Planning meeting.
• Develop and execute detailed ETL related functional, performance, integration and regression test cases, and documentation.
• Involved in the development of Test Plan, Test Scripts and Test cases.
• Used JIRA as the defect-tracking tool. Updated JIRA with all the changes made to the test case and closed it when all the requirements were met as specified.
• Interacted with the Development team and the Environment team in prioritizing the defect list and validating known bug fixes.
• Extensively used and developed SQL scripts/queries in backend testing of Database.
• Prepared the data to cover various scenarios and wrote SQL scripts to verify the database updates, inserts and deletion of the records.
• In Agile Process, Created QA Sprint tasks, plan and track the progress of sprints, evaluate the risk, and resolve the impediments in the sprints.
• Performed Data Analysis and developed Data Mapping documents for ETL (SSIS) projects.
• Performed Data Analysis, writing SQL Queries for Testing and Troubleshooting against Data Warehouse.
• Performed Functional, Regression, Smoke, User Acceptance with Positive, Negative Test cases.
• Having Experience in testing SSRS Reports, MicroStrategy, SharePoint Solutions, and testing web dashboards.
• Participated in the Weekly Status Updates showing the progress of the testing effort and open issues to be resolved.
• Coordinating QA, SIT and UAT sessions and executed UAT scenarios with end users for final approval and user signoff.
• Used SQL tools to run SQL queries and validate the data loaded into the target tables.
• Performed back-end testing along with the ETL and validated the source and target using the complex SQL queries.
• Working closely with project manager/QA Test Lead and Project team to learn about the project functionalities and provided testing timelines.
• Writing database test scenarios in JIRA.

Environment: SQL Server 2008, Service-Now, TFS, Micro Strategy, Agile, Jira, SSIS, SSRS Data warehouse.

Confidential - Charlotte, NC

ETL QA Engineer

Responsibilities:

• Involved in preparing Test Plans, QA metrics and mentoring the team in testing methodologies.
• Analyzed Functional Requirements and Business Specification as part of Static Testing on earliest stages of SDLC
• Involved in testing the application utilizing the Scrum (Agile) methodology.
• Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Tested the ETL process to automate the testing process and load the test data into the testing tables.
• Performed SQL Queries, creating Tables, and Views by following SQL Best Practices.
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Production reconciliation was performed before the deployment of the developed application to the production systems to ensure that the data is being processed efficiently and to test the correctness of the data.
• Written several complex SQL queries for validating Business Objects Reports.
• Tested all Business Objects Dashboards according to the requirement.
• Performed extensive Database Testing by writing complex SQL Queries in DB2 to test the different scenarios in the application.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases.
• Developed high level ETL test matrix based on business requirements, ETL functional and ETL technical specifications, and development standards for assigned projects/applications.
• Updated and maintained existing ETL test Matrix and ETL test cases based on code changes and enhancements to assigned applications.
• Developed UNIX scripts to validate the flat files and to automate the manual test cases.
• Involved in Test Case Preparation and Test Case Execution using both Manual and Automation techniques.
• Used JIRA as the defect-tracking tool. Updated JIRA with all the changes made to the test case and closed it when all the requirements were met as specified.
• Developed and executed SQL queries to verify the proper insertion, deletion and updates into the Oracle supporting tables and cubes.
• Used various SSIS tasks such as conditional split, derived column on the data retrieved, performed data validation checks during staging, and then loaded the data into the data warehouse.
• Responsible for execution, defect reporting and fix verification using manual and automated techniques to have test plans in place and executed according to our release schedules.
• Participated in Release Review/Requirement Analysis and Design review meetings.

En vironment: SQL Server, Cucumber, Oracle, Jira, SSIS, UNIX Scripts, Data Warehouse, Manual testing, TFS, Business Objects.

Confidential

QA Engineer

Responsibilities:

• Performed user stories and participated in Sprint planning, Review Sessions & Scrum Meetings and developed Test scenarios, Test cases, Test data, Test procedures, Test reports.
• Performed Functional, Regression, Data Driven, Cross Browser, Black Box, White Box and Smoke testing at different test phases.
• Recorded and plays back test in Fire Fox using Selenium IDE.
• Developed test code in java language using Eclipse IDE.
• Created and enhanced numerous test scripts to handle changes in the objects, in the tested application's GUI and in the testing, environment using Selenium WebDriver.
• Developed Test Frameworks in Selenium for UI Regression Test Automation and when necessary and potentially execute Unit Test Automation (Java)
• Performed Regression testing on new builds, every modification in the application using Selenium Web driver
• Designed & Developed data driven framework using Selenium WebDriver. Involved in setting up configuring the testing environment with Eclipse, TestNG and Selenium WebDriver.
• Performed Application Screenshots and copied the images whenever exceptions occurred and at important checkpoints of application execution.
• Performed Firebug, Fire Path to debug, edit and locate the objects based on ID, Name, XPath, and CSS Selector.
• Involved in Web services testing using SOAPUI Tool. Validated request and response XML. Added assertions to validate the XML in Web services SOAP and RESTFUL service.
• Execution of daily smoke tests to ensure the deployment of each environment is stable.
• Performed automation for Functional and Regression Testing using Selenium WebDriver and Cucumber.
• Used Git for source code version control and integrated with Jenkins for CI/CD pipeline
• Experienced in writing Test cases using Element locators, WebDriver methods, Java programming features and TestNG Annotations .
• Used Jenkins as continuous integration (CI) server to run automated test suites.
• Used JMeter to test performance of the web application.
• Involved in testing compatibility of application for dynamic and static content under various cross browsers using HTML IDs and XPath in Selenium.
• Performed automation for Functional and Regression Testing using Selenium WebDriver and Cucumber.
• Regression testing was performed after each build release of the application and updated the Scripts by executing the Regression suites built using Selenium and approve for regression suite.
• Tracked defects and send them to the developer-using HP ALM and generated various query defects and defect reports.
• Created Test runs, Test cases, Mockups, Process Flow diagrams from the functional documents.
• Used Jenkins as continuous integration server to run automated test suites.
• Perform data validation and verification on Oracle Database.
• Base line and Regression tests were scheduled and performed on every Release and build and supported End-to-end testing.
• Participated QA weekly meetings and various other meetings and discussed Enhancement and Modification Request issues and defects in the application.

En vironment: Java 1.5, Selenium Web Driver, Selenium IDE, HP ALM, Java, Jenkins, SOAP, Oracle, Microsoft Excel, MS word, Microsoft outlook.

Confidential

QA Tester/ETL

Responsibilities:

• Reviewed the Business Requirement Specification Document and the technical specification of the application.
• Developed Test Objectives and Test Plans.
• Proficient in the manual testing of the Mainframe applications.
• Reviewed System Requirements to define testing scope for various levels of testing (Functional, System, Regression and UAT).
• Involved on testing the new functionalities based on test cases and coordinated with development team in fixing the issues.
• Created manual Test Cases and Test Scripts based on functional documents and user stories to perform Functional and Regression testing.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Worked with developers to communicate regarding issues in the application.
• Testing the ETL data movement from Oracle Data mart to SQL Data mart on an Incremental and full load basis.
• Involved in the error checking and testing of the ETL procedures.
• Responsible in testing Initial and daily loads of ETL jobs.
• Coordinated the testing effort towards End-to-End testing to verify the proper functioning.
• Scheduled and executed Manual Test Scripts through HP Quality Center.
• Tested ETL mappings to extract and load data from different databases such as Oracle, SQL Server and flat files and loaded them into Oracle.
• Involved in testing the ETL mappings, by validating whether the mapping adhere to the development standards and naming conventions, whether the mapping work correctly in relation to other processes in your data logistical flow.
• Prepared and participated in weekly status meetings, conducted walkthroughs, documented proceedings.
• Created Test input requirements and prepared the test data for data driven testing.
• Data validation and Database integrity testing done by executing SQL queries.
• Used Application Lifecycle Management (Quality Center) for tracking test requirements, references, test plans, defects and communicating them among the team members and developers.
• Participated in Weekly meetings, Walkthroughs, and inspections.
• Performed quality assurance reviews on all Software Development Life Cycle phases.

Environment: HP Quality Center, SQL, Windows, Oracle 8, Manual testing, MS-Office.