Hema Tulsiram Khatri

QA Engineer (Software Test Engineer) with 8+ years of experience in the IT industry, specializing in UI, System, Integration, Functional, Regression, Database, Sanity, ETL, and API testing.

• Strong expertise in Data Warehouse concepts and ETL processes, with hands-on experience in Informatica for System Integration Testing.
• Proficient in testing CRM and Salesforce cloud applications, including front-end and back-end validation using Apex Data Loader and Workbench.
• Skilled in test planning, scripting, and execution, ensuring alignment with business requirements, defect management, and requirement traceability.
• Experienced with industry-standard tools such as ALM, QC 10.0, JIRA, Oracle SQL Developer, and SoapUI for test management
• Expertise in ETL testing (Informatica), data validation, and source-to-target reconciliation for large-scale data migration and integration projects.
• Hands-on experience with Informatica , Oracle SQL Developer
• Adept at designing detailed test cases, procedures, and documentation to ensure compliance, repeatability, and knowledge retention.
• Strong collaborator with cross-functional teams (Dev, BA, QA) to troubleshoot issues, optimize testing efficiency, and drive continuous improvement.
• Effective communicator, providing clear feedback, defect analysis, and recommendations to enhance product quality.
• Proven track record in both Agile and Waterfall environments, adapting testing approaches to suit project methodologies

Project 6 :-

Domain: HEALTHCARE SERVICES | Application Type: Web Application

Testing Type: Database testing, ETL Testing, Functional testing, Black box testing, Regression testing, Retesting

Key Responsibilities:

• Analyzed business requirements and participated in functional application reviews
• Developed and contributed to comprehensive test plans
• Designed, reviewed, and executed test scripts with appropriate test data
• Managed ETL processes including workflow execution and data validation
• Developed and executed test plans, SQL scripts, and defect reports to verify ETL workflows, mappings, and job schedules.
• Performed extensive data verification through SQL queries on dimensional and fact tables
• Conducted source-to-target data mapping and validation
• Created and maintained test data sets for various testing scenarios
• Identified and documented test cases for regression testing
• Collaborated with Business Analysts and Development teams to resolve issues
• Tracked defects through QC tool and performed root cause analysis
• Prepared and presented daily testing status reports

Project 5 :-

Domain: HEALTHCARE SERVICES | Application Type: Cloud Web Application

Testing Type: Database testing, ETL Testing, Web Service testing, System Integration testing, Functional testing, Black box testing, Regression testing, Retesting

Key Responsibilities:

• Adopted the Agile way of working in Sprints
• Design test plans, procedures, scenarios, and scripts to accurately assess new change request or software updates according to customer requirements using the JIRA Tool.
• Preparing the environment and test data and execution of test scripts
• Back-end testing was the key role by writing the SQL quires to fetch and update the data in Oracle SQL database and other database activities.
• Various new Systems were integrated with the Application, experienced in testing the system integration testing of the cloud application.
• Also tested the Web services using the SOAP and Postman tools.
• Hands on Experience in using the Informatica tool for running the jobs to transfer the Data from Front end Application to Backend Database.
• Have worked for Cloud CRM projects
• Have Experience in using the CRM Workbench the backend application.
• Experience in using the Apex Data Loader (Sales force tool) to load the data into the Application.
• Used ALM for different types of activities like test case upload, execution, Defect Logging, ETC
• Knowledge on writing SQL Queries, oracle Database, informatica, ETL testing, CRM, System integration testing with different systems and used tools like Soap UI, Postman for webservice testing
• Identify, analyze and create detailed records of problems that appear during testing, such as software defects, bugs, functionality issues, and output errors, and work directly with software developers to find solutions and develop retesting procedures.
• Track problems, resolutions, and bug fixes throughout testing and create a comprehensive database of defects and successful mitigation techniques.

Project 4 :-

Domain: BANKING AND FINANCE | Application Type: Web Application.

Testing Type: Backend testing, Functional testing, Black box testing, Regression testing, Retesting

Key Responsibilities:

• Preparation of test Bed before the testing and Analyze the Change request in Jira and create the test scenarios and designing complex test cases.
• Involved to achieve test execution productivity, ensure defect management as per process and timely release of test dashboard.
• Attending the regular client meeting for updating the status of testing.
• Timely reporting the defect and test status.
• Involved in different types of testing such as Functional testing, Black box testing, Regression testing, Retesting.

Project 3 :-

Domain: Manufacturing | Application Type: Web application

Testing Type: System testing, regression testing, smoke testing, sanity testing

Key Responsibilities:

• Involved in providing inputs to prepare Test Plan and design complex test cases
• Review the test cases prepared by the junior team members and provide my inputs to correct team.
• Responsible to achieve test execution productivity, ensure defect management as per process and timely release of test dashboard.
• Ensured quality interaction with clients and timely response to stakeholders.
• Responsible for preparing traceability matrix.

Project 2 :-

Domain: Oil & Energy

Application Type: Web application | Testing Type: System Testing

Key Responsibilities:

• Analyzing and understanding the use cases from Functional requirement specification
• Develop test environments, test scenarios, test scripts based on the use cases
• Regular Interacting with BA team members to know more about the application and for clarification and review purpose
• Preparing Model based on the test scenario and generating Test cases using the MBT tool
• Executing the test cases and reporting the defects in Quality center.
• Retesting and continuous tracking the defects until it is closed.
• Providing the daily status for test execution and defect to the team lead.

Project 1 :-

Domain: Banking and finance | Application Type: Web application and Mainframe Application Testing Type: Regression Testing

Key Responsibilities:

• Develop test environments and test cases for work orders
• Estimation, planning, scheduling and tracking the test execution activities and also checking compatibility of application in different browsers
• Analyze test results, detect issues and track root causes and generate Test Execution and defect reports.
• Timely updating the status of WO (Work Order) of application in CQ -Clear Quest. And Weekly Status Report Generation.
• Regular interaction with the onsite co-coordinators by participating in Tel-Cons & email.

I hereby declare that the above-mentioned information is true to the best of my knowledge and belief.

Hema Tulsiram Khatri