Harshitha B Nijaguna

• Experienced professional in ETL Tools, PL/SQL, SAP Hana WebIDE and Big Data Testing Environments (Hive, Impala, Py-Spark, and Oozie).
• Skilled in Talend 5.0 for extracting data from various source systems and loading them into data tables.
• Proficient in database testing, data verification, validation, and integration.
• Effective communicator with stakeholders, development teams, and senior management to ensure project goals align with testing efforts.
• Adheres to agile methodologies throughout project lifecycles. Strong skills in writing Hive queries for data analysis in Hive warehouse using HQL.
• Solid understanding of QA principles, processes, use cases, and Agile software development lifecycle.
• Oversees test activities such as strategy development, execution planning, debugging/troubleshooting, impact/gap analysis, resource management, status reporting, issue resolution coordination, and defect tracking/triage activities.
• Experience which includes exposure to SDLC, STLC, Bug Life Cycle analysis work, ETL Testing, End-to-End testing, System Integration testing, Regression testing, and Back-end testing.
• Thorough team contributor with strong organizational capabilities. Experienced in handling numerous projects at once while ensuring accuracy. Effective at prioritizing tasks and meeting deadlines.

Project #1

Client: Deloitte

Project Name: Summit O2E Dashboard

Project Description:  Using Salesforce Source systems like (Jupiter/Paradigm & SWIFT)  providing Customers Opportunity, Engagement and other details to visible in Dashboard application for End Users Verification.

Team Size: 6

Test Environments: Azure Devops Repository Tool, SAP Hana WebIDE Database, Salesforce Source Systems, Summit Client UI Application, Developer Tools, Hana Studio (Planviz)

Roles & Responsibilities:

* Requirement Analysis based on the customer requirements and stake holder meetings.

* Involved in setting up the testing environments and prepare test data for testing flows to validate and prove positive and negative cases. 

* Performed data validations between Landing Zone, Ingestion Zone, and Salesforce Source Systems. 

* Performed data preparation based on requirement in Source systems with help of respective teams.

* Performed Defect Reporting, Analyzing, Tracking, and Report Generation using Azure Devops Repository tool. 

* Participated in regular project status meetings and QA status meetings. 

* Validated and executed with Applied ETL Transformations using SAP Hana WebIDE Database Tool.

* Analysis of the use cases, drafting test cases according to business use cases and requirements.

* Test Case creation for ETL mappings, execution, defect logging and tracking.

* End to End ETL Test execution for all the Mapping. 

* Validating the source and target tables as per the transformation logic. 

* Review the test scenarios, Test cases before delivering to the customers. 

* Responsible for Smoke, Sanity test, System Integration test and Regression Test. 

* Performing UI Validation based on test scenarios as part of End to End activity.

* Involved in resolving bugs & clarifications as part of UAT activity with other testing teams.

Project #2

Client:  Deloitte

Project Name: Global Data Architecture (GDA)

Project Description: Data comes from different sources and also in various forms. Consolidate all the details from source systems like (Jupiter,SWIFT) and extract into reporting structure for end user verification 

Team Size: 8

Test Environments: Azure Devops Repository Tool, SAP Hana WebIDE Database, Salesforce Source Systems, Tableau Reporting Tool

Roles & Responsibilities:

*  Main tasks include Requirement Analysis

*  Involved in setting up the testing environments and prepare test data for testing flows to validate and prove positive and negative cases.

*  Performed data validations between source tables and extracted reports from tools before submitting to end users.

*  Performed Defect Reporting, Analyzing, Tracking, and Report Generation using ADO.

*  Participated in regular project status meetings and QA status meetings.

*  Analysis of the drafting test cases based on requirements which includes End to End, Negative, Regression, Functional and Mappings.

* Responsible for Smoke, Sanity test, System Integration test and Regression test.

* Raising defects appropriately and tracking them to closure.

* Validating the extract reports from tableau tool based on source system data.

* Validation of Performance tuning for the extracted report from tableau to avoid the time constraints for end user clients.

Project #3

Client:  Aaspire Pty Ltd

Project Name: Link - CRM CCP

Project Description: PEGA BAU included enhancements such as change requests to existing different applications (6 different PEGA applications) 

also included, delivery product enhancements and production bug fixes be performing end to end testing in monthly releases.

Team Size: 5

Test Environment: PEGA is BPM tool

Roles & Responsibilities:

* Analysis of the change requests.

* Drafting test cases according to business uses cases.

* Test Cases creation for the mapping & transformation logics, end to end, regression and negative.

* Execution of test cases and defects logging  using the JIRA tool.

* Tracking the defects to make closure with all evidence.

Project #4

Client:  Mindtree Ltd

Project Name: Everest Insights

Project Description: In this project we have implemented the ACG Automation for outbound and inbound response files using Snowflake, Matillion and Automate Scheduler. Everside has the Enterprise Data Warehouse (EDW) built on snowflake and hosted on AWS, to handle various datasets such as eligibility, medical claims, Rx Claims and Clinical datasets. With recent multiple acquisitions of similar business model, there is a need to load data from 300+ clients into their EDW.

Team Size: 3

Test Environment: Snowflake and Matillion & Technologies:ETL

Roles & Responsibilities:

* Analysis of the change requests.

* Drafting test cases according to business uses cases.

* Test Cases creation for the mapping & transformation logics, end to end, regression and negative for SIT and support to PROD

* Running the jobs/workflows for ETL process.

* Execution of test cases and defects logging  using the JIRA tool.

* Tracking the defects to make closure with all evidence.

• Received an award from Mindtree for exemplary contribution in team for completing the deliverables on time.