OBJECTIVE

• 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.

SUMMARY

• Testing professional with more than 12 Years of experience in the field of Software Testing with specialization in ETL, Reports, EDI, API testing (Rest API/Swagger), Automation
• Worked in Healthcare (QNXT), Education, Manufacturing domains.
• Working experience in ETL tools like Informatica, SSIS
• Excellent grasp of Selenium/C# scripting automation
• Run existing or new test automation scripts as needed and analyze/report results
• Build and integrate complex database queries to retrieve crucial data from DB for validation.
• Maintain QA environment, from ensuring the environment is up to date with the latest build deployments.
• Strong understanding and experience in working in a High Performing Agile/Scrum Team and utilizing one of the major Agile Lifecycle Management tools like, Jira.
• Effectively utilized testing methodologies such as white/black box, integration, system, regression, etc.
• Effectively utilized time management skills to work on multiple projects simultaneously.
• Leading sessions with business users to plan, coordinate and execute UAT testing
• Proactively worked with IT Manager, Business Analyst, Creative, User Experience and Development to define project requirements and estimate effort to deliver
• Manage communications at a program level with multiple stakeholders and actively communicate on overall program level testing status by working with multiple testing teams in the program.
• Onshore/offshore coordination

TECHNICAL SKILLS

Test Management Tools: ALM QC, JIRA, TFS, Jenkins, GitHub

Healthcare: QNXT workflow

ETL Tools: SSIS, Informatica,Selenium

BI Reporting Tools: Oracle BIEE

IDEs: Visual studio, Eclipse

Languages: .Net, Java, SQL

Databases: Confidential SQL server, Oracle SQL Developer

Domain: Health Care, Education and Manufacturing

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles

Technical Test Lead

Responsibilities:

• Work with the scrum team to understand requirements, user stories and acceptance criteria and translate them into test scenarios, test strategies, test plans and test cases.
• Performed 834 (Inbound),835 (Fixed length and EDI) files validation by referring cross walk documents
• Created test data in QNXT for Member and claims.
• Mocked various EDI 834, 835 files as per business requirements and performed Regression, End to end testing.
• ETL Testing, Execution of ETL, Verification of Business Rules and Transformations using Informatica tool
• Created SQL queries for validating file data into end - to-end reports
• Testing the migration functionalities to a web based application using SQL scripts
• Monitoring the scheduled jobs and following up with hosting team on failures.
• 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, Los Angeles

Technical Test Lead

Responsibilities:

• Test management: Test planning, test strategizing, effort estimation, scheduling, tracking, and reporting.
• Worked on API testing, Interface (SSIS Jobs), system Integration and integration testing with IODS and other external systems for the assigned projects along with test planning, test data set up.
• End to End validation of data and transformation logic from Source System to Target System till Reporting.
• Created SQL queries for validating file data into end to end reports
• Analysis of bug failures, follow up with external team to make sure bug has fixed and validated
• Providing test data support to UAT and automation and running the automation test scripts along with failure analysis.
• Play a role of experienced resource in Test Data Management to drive end to end testing of enterprise application.
• Participate in Design meetings, PMO meeting, code retrospective calls for Project planning's, Designs, and agile methodologies.
• Extensively involved in extracting, combining, analyzing, and interpreting data from various sources to provide meaningful information for decision making or support of overall project management
• Preparing DSR report, defect bifurcation report and complexity matrix for business review.
• 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

Confidential, Seattle(Washington)

QA onsite lead - Technical Test Lead

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

Test Consultant

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

Confidential

Software Engineer

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
• 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

Confidential

Software Engineer

Responsibilities:

• Developed web application using VB.NET
• Created SQL queries, Stored Procedures for Crystal report
• Involved in Integration and End to End testing
• Provided Demo to business users