SUMMARY:

• To be a dynamic and key contributor in an advanced, progressive, challenging and stimulating work environment which will provide opportunities to enhance my technical skills and contribute to the growth of the organization.
• Testing professional with close to 10 years of experience in the field of Software Testing with specialization in ETL, Business Intelligence Reports testing
• Strong knowledge in writing SQL Queries for End to End Web application, ETL and BI Reports validation.
• Working experience with Confidential SSRS, Oracle BIEE, Tableau and Power BI reporting tools.
• Experience in working with Oracle Fusion Middleware Forms for creating and managing test data
• Working experience in with ETL tools like Informatica, SSIS and Ab Initio
• Good experience in working with UNIX commands and basic scripting for ETL jobs validation
• Basic knowledge in Hive and Python
• Leading and working in QA functional and automation teams at customer location for more than 4 years.
• Experience in working as a business analyst to analyze the requirements with core business team
• Good domain experience of automotive insurance, life insurance and manufacturing domains
• Deep dive knowledge in SAFE agile practice, implementation and working experience in waterfall methodologies.
• Involved in smoke testing, system testing, user acceptance testing, usability testing and regression testing
• Experienced in defining testing methodologies, test strategies, designing test plans, functional test scenarios/cases and test cases
• Proficient in all stages of software testing life cycle from requirement gathering, test planning to defect tracking and managing defect lifecycle.
• Experienced in working with relational databases like Confidential SQL server and Oracle databases.
• Extensive experience in coordinating testing effort, responsible for test deliverables, status reporting to management, dashboard preparation & issue escalations between different teams in different geographical locations
• Good interpersonal skills, hard working with a quest for knowledge and zeal to learn new things with an optimist attitude and undertake challenging tasks

TECHNICAL SKILLS:

Test Management Tools: ALM QC, JIRA, Visual Studio, Jenkins, GitHub

ETL Tools: SSIS, Informatica, Ab Initio

BI Reporting Tools: Oracle BIEE, SSRS, Tableau, Power BI

IDEs: Visual studio, Eclipse

Languages: .Net, Java, SQL

Databases: Confidential SQL server, Oracle SQL Developer

Domain: Automotive Insurance, Life Insurance, Manufacturing

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, Florida

Tools: SSRS, SSIS, Oracle SQL Developer, Confidential SQL Server, SQL Loader, QC, JIRA, Mainframe Focus Reflection

ETL BI Test Engineer

Responsibilities:

• Was involved in analyzing the requirement phase from beginning trying to understand the migration approach and key business scenarios with the business/ end user teams.
• Requirement Analysis, Test Plan, Scenario and Test Cases preparation, Test Data Identification
• Involved in writing SQL development queries to build up the look up functions.
• Involved in creating procedure for Insert, Update functions as per the requirement
• ETL Testing, Execution of ETL, Verification of Business Rules and Transformations
• Created SQL queries for validating file data into end to end reports
• Testing the migration functionalities to a web based application using SQL scripts
• Test Team Management, Environment Management, STLC Management
• Defect Management, Test Status Reporting, Onsite Coordination, Client Expectation Management
• Providing detailed estimations for Test Scope. Preparing Test strategy and Test plan and Requirement traceability matrix for the current Release.
• Conducting regular reviews with the test team, to ensure the quality of Test cases, Test Results and Defects
• End to End validation of data and transformation logic from Source System to Target System till Reporting
• Attending scrum rituals and working with product owners/scrum team to define better product backlog, sprint backlog, user stories to provide business value and improve quality of software
• Analyzing/enhancing the business requirements from product owners
• Test strategy/plan preparation
• Defect logging, tracking using JIRA
• Go Live activities as per the implementation plan and production install verification
• Onsite Offshore coordination for daily work allocation/sprint activities
• Providing demo to offshore for new technologies, best practices to enhance quality of our automation scripts and in turn products

Confidential, Northbrook, Illinois

Testing Approach: Migration testing, ETL and Reports

Tools: SSIS, Tableau, Oracle SQL Developer, JIRA

SDET, Test Analyst and Business Analyst

Responsibilities:

• Was involved in analyzing the requirement phase from beginning trying to understand the migration approach and key business scenarios with the business/ end user teams.
• Requirement Analysis, Test Plan, Scenario and Test Cases preparation, Test Data Identification
• Involved in writing SQL development queries to build up the look up functions.
• Involved in creating procedure for Insert, Update functions as per the requirement
• ETL Testing, Execution of ETL, Verification of Business Rules and Transformations
• Created SQL queries for validating file data into end to end reports
• Testing the migration functionalities to a web based application using SQL scripts
• Test Team Management, Environment Management, STLC Management
• Defect Management, Test Status Reporting, Onsite Coordination, Client Expectation Management
• Providing detailed estimations for Test Scope. Preparing Test strategy and Test plan and Requirement traceability matrix for the current Release.
• Conducting regular reviews with the test team, to ensure the quality of Test cases, Test Results and Defects
• End to End validation of data and transformation logic from Source System to Target System till Reporting
• Attending scrum rituals and working with product owners/scrum team to define better product backlog, sprint backlog, user stories to provide business value and improve quality of software
• Analyzing/enhancing the business requirements from product owners
• Test strategy/plan preparation
• Defect logging, tracking using JIRA
• Go Live activities as per the implementation plan and production install verification
• Onsite Offshore coordination for daily work allocation/sprint activities
• Providing demo to offshore for new technologies, best practices to enhance quality of our automation scripts and in turn products

Confidential, Northbrook, Illinois

Testing Approach: Functional, End to End, ETL, Database and Reports Testing

Tools: AbInitio, Tableau,Oracle 12c, TOAD, Unix Putty, JIRA Zephyr

Test Analyst

Responsibilities:

• Worked closely with development team in technical design of the Business Intelligence requirements/CRs.
• Requirement Analysis, Test Plan, Scenario and Test Cases preparation, Test Data Identification, Building SQL Queries
• Business Intelligence Report Testing
• Writing Unix commands to do a basic check of source files data and then load the tables for ETL validation
• ETL Testing, Execution of ETL jobs, Verification of Business Rules and Transformations
• Test Team Management, Environment Management, STLC Management
• Defect Management, Test Status Reporting, Onsite Coordination, Client Expectation Management
• Preparing Test strategy and Test plan and Requirement traceability matrix for the current Release.
• Test Data Creation and creation of SQL Scripts
• Conducting regular reviews with the test team, to ensure the quality of Test cases, Test Results and Defects
• Preparing Daily Status report during execution, Weekly Status reports, Highlighting the blocking issues and risks. Participating triage meeting with Dev team along with the client project manager.
• Preparation of Metrics reports for the line of business

Confidential, Northbrook, Illinois

Testing Approach: Functional and Automation Smoke Testing - Web and mobile applications, Functional, regression, web service testing, ETL testing

Tools: SSRS,SSIS, Oracle SQL Developer, Toad, JIRA, Unix Putty, Eclipse, Jenkins, TestNg, Maven

QA Engineer - Test Analyst

Responsibilities:

• Requirement Analysis, Test Plan, Scenario and Test Cases preparation, Test Data Identification, Building SQL Queries
• ETL Testing, Execution of ETL, Verification of Business Rules and Transformations
• Executing Unix commands
• Testing the migration functionalities to a web based application using SQL scripts
• Test Team Management, Environment Management, STLC Management
• Defect Management, Test Status Reporting, Onsite Coordination, Client Expectation Management
• Providing detailed estimations for Test Scope. Preparing Test strategy and Test plan and Requirement traceability matrix for the current Release.
• Conducting regular reviews with the test team, to ensure the quality of Test cases, Test Results and Defects
• Good knowledge of creating SQL scripts for validating the data in reports using SQL Server
• End to End validation of data and transformation logic from Source System to Target System till Reporting
• Work with SOAP UI to test web services
• Automation Feasibility analysis, estimates
• Smoke automation script preparation/execution using selenium web driver, testNG.
• Version control of scripts using Git
• End to end testing/coordination with various teams
• Attending scrum rituals and working with product owners/scrum team to define better product backlog, sprint backlog, user stories to provide business value and improve quality of software
• Analyzing/enhancing the business requirements from product owners
• Test strategy/plan preparation
• Identification of functional test scenarios
• Defect logging, tracking using JIRA
• Go Live activities as per the implementation plan and production install verification
• Onsite Offshore coordination for daily work allocation/sprint activities
• Providing demo to offshore for new technologies, best practices to enhance quality of our automation scripts and in turn products

Confidential, Northbrook, Illinois

Testing Approach: Functional and Automation Testing - Web and mobile applications, Functional, regression, web service testing

Tools: Oracle SQL Developer, Toad, JIRA, Appium, Eclipse, Jenkins, TestNg, Maven

QA Engineer - Test Analyst

Responsibilities:

• Requirement Analysis, Test Plan, Scenario and Test Cases preparation, Test Data Identification, Building SQL Queries
• Functional testing of mobile rescue applications to test end to end flow
• Created automated smoke test suites using Appium, Selenium and xml framework
• Test Team Management, Environment Management, STLC Management
• Defect Management, Test Status Reporting, Onsite Coordination, Client Expectation Management
• Providing detailed estimations for Test Scope. Preparing Test strategy and Test plan and Requirement traceability matrix for the current Release.
• Conducting regular reviews with the test team, to ensure the quality of Test cases, Test Results and Defects
• Good knowledge of creating SQL scripts for validating the data in reports using SQL Server
• Automation Feasibility analysis, estimates
• Functional/regression/smoke automation script preparation/execution using selenium web driver, testNG.
• Continuous integration, continuous deployment of builds using Jenkins
• Version control of scripts using Git
• End to end testing/coordination with various teams

Confidential, Seattle, Washington

Testing Approach: Functional, End to End, ETL, Database and Reports Testing

Tools: BI (SSIS, SSAS, SSRS), SQL Server 2012, Team Foundation Server, HP Quality Center, Confidential Team Management, SAP Net weaver

QA onsite lead - Test Analyst

Responsibilities:

• Worked closely with development team in technical design of the BI requirements and Change Requirements
• Requirement Analysis, Test Plan, Scenario and Test Cases preparation, Test Data Identification, Building SQL Queries
• Business Intelligence(BI) Report Testing using SQL Server
• ETL Testing, Execution of ETL, Verification of Business Rules and Transformations
• Test Team Management, Environment Management, STLC Management
• Defect Management, Test Status Reporting, Onsite Coordination, Client Expectation Management
• Providing detailed estimations for Test Scope. Preparing Test strategy and Test plan and Requirement traceability matrix for the current Release.
• Conducting regular reviews with the test team, to ensure the quality of Test cases, Test Results and Defects
• Create, validate the SSIS packages. Monitor the SQL Agent Jobs
• Good knowledge of creating SQL scripts for validating the data in reports using SQL Server
• End to End validation of data and transformation logic from Source System to Target System till Reporting
• Change Data Capture Testing between various databases and validation of data flow from Source to Target
• Coordination with test automation team for implementing data driven tests using Selenium Automation
• Was a key member of a weekly meeting called Script Review Meeting where we reviewed automation scripts of other projects and helped them with best practices, solution to their issues and more robust code
• Attending agile rituals, daily scrum, talk/negotiate with product owners/business to understand/enhance their requirements and to deliver better products using agile methodology
• Requirement analysis and test plan preparation
• Functional test scenarios and test case preparation
• Functional/regression test case execution and defect logging/tracking in TFS
• Onsite Offshore coordination for daily work allocation/sprint activities

Confidential, California

Testing Approach: Functional, End to End, ETL, Database and Reports Testing

Tools: HP Quality Center, Oracle, OBIEE, Informaticas

QA onsite lead - Test Analyst

Responsibilities:

• Worked closely with development team in technical design of the BI requirements/CRs.
• Requirement Analysis, Test Plan, Scenario and Test Cases preparation, Test Data Identification, Building SQL Queries
• Business Intelligence(BI) Report Testing using OBIEE.
• ETL Testing, Execution of ETL, Verification of Business Rules and Transformations
• Test Team Management, Environment Management, STLC Management
• Defect Management, Test Status Reporting, Onsite Coordination, Client Expectation Management
• Providing detailed estimations for Test Scope.
• Preparing Test strategy and Test plan and Requirement traceability matrix for the current Release.
• Test Data Creation and creation of SQL Scripts
• Conducting regular reviews with the test team, to ensure the quality of Test cases, Test Results and Defects