Portfolio – End‑to‑End Testing Project (Jira Workflow Simulation)
Welcome! I’m Sachi, a QA Tester passionate about structured testing and real‑world workflows.
I am ISTQB Foundation Level certified, which strengthens my approach to test design, traceability, and industry‑aligned QA practices.
This portfolio reflects my approach to quality: clear, detailed, and industry‑aligned.
This repository showcases a complete, end‑to‑end manual + hybrid QA workflow, designed to reflect how real companies structure their testing lifecycle using Jira, documentation standards, and traceability practices.
The project demonstrates my ability to:
- Analyse requirements
- Design test scenarios and test cases
- Execute tests and report defects
- Perform backend data validation using SQL
- Produce professional QA documentation
- Maintain traceability across the entire lifecycle
📁 Repository Structure
This portfolio is organised into four main folders:
1️⃣ /documentation – High‑Level QA Documents
These documents represent planning and strategy activities that apply to the entire project.
/documentation ├── Test-Plan.md ├── Test-Strategy.md ├── RTM.md ├── Risk-Analysis.md ├── Entry-Exit-Criteria.md ├── README.md
What this folder shows
- My ability to create structured, industry‑standard QA documentation
- Understanding of test planning, scope, risks, and strategy
- Ability to define traceability from requirements to test cases
2️⃣ /jira-workflow – Sprint‑Based Testing Workflow
This folder simulates a real Jira sprint cycle, including requirements, test design, execution, and defect management.
/jira-workflow ├── User-Stories.md ├── Acceptance-Criteria.md ├── Test-Scenarios.md ├── Test-Cases.md ├── Linked-Test-Cases.md ├── Test-Execution-Report.md ├── Defects.md ├── Test-Summary-Report.md ├── README.md
What this folder shows
- Ability to break down user stories into testable acceptance criteria
- Strong test case design skills (positive, negative, edge cases)
- Realistic defect reporting using Jira‑style formatting
- Clear execution reporting and sprint‑level summaries
-
End‑to‑end traceability and structured QA thinking
3️⃣/automation – Selenium + Java + TestNG Framework (Hybrid QA Section)
This folder contains a sample UI automation framework demonstrating hybrid QA capability.
automation
├── docs
│ ├── extent-reports.md
│ ├── maven-structure.md
│ ├── page-object-model.md
│ ├── sample-tests.md
│ └── testng-suite.md
└── framework
├── pom.xml
├── testng.xml
└── src
├── main/java/Practice
│ ├── DriverFactory1.java
│ ├── CommonActions.java
│ ├── Login.java
│ ├── utils
│ │ ├── DynamicLocators.java
│ │ └── DataProviders.java
│ └── reporting
│ ├── ExtentManager.java
│ └── ExtentTestManager.java
└── test/java/Practice
├── BaseTest.java
├── LoginTest.java
└── listeners
└── TestListener.java
What this folder shows
- Understanding of Java + Selenium WebDriver
- Page Object Model (POM) design
- TestNG suite structure
- ExtentReports integration
-
Ability to automate core UI flows
4️⃣ /api-testing – API Test Cases & Defect Reporting
This folder contains API test cases, defects, and supporting documentation for validating the Login API.
/api-testing
├── Login_API_Test_Cases.md
├── Login_API_Bug.md
├── README.md
What this folder shows
- Understanding of API request/response validation
- Positive, negative, and boundary API test cases
- API defect reporting with clear reproduction steps
- Ability to analyse API behaviour using status codes, payloads, and error messages
-
Hybrid QA capability beyond UI testing
5️⃣ /sql-testing – SQL Queries for Data Validation & Backend Verification
This folder contains SQL queries used for backend data validation, test data setup, and defect investigation. These queries support UI and API testing by ensuring that the application’s database behaves correctly and consistently with business rules.
/sql-testing
├── basic-queries.sql
├── joins-and-aggregations.sql
├── test-data-setup.sql
├── data-validation-queries.sql
├── bug-investigation-queries.sql
├── README.md
What this folder shows
- Ability to validate backend data using SQL
- Understanding of table relationships, joins, and aggregations
- Skill in preparing and cleaning test data for QA activities
- Experience verifying API/UI behaviour against database records
- Capability to investigate defects using SQL queries
- Strong hybrid QA approach combining UI, API, and DB validation
🔍 Project Overview
This project simulates a typical web application with core modules such as:
- Login
- Password Reset
- Profile Management
- Authentication API
- Backend Database (SQL)
The goal is to demonstrate a complete QA lifecycle, including:
- Requirement analysis
- Test design
- Test execution
- Defect logging
- Reporting
- Traceability
- API Validation
- Backend data validation (SQL)
Although this is a documentation‑focused portfolio, it reflects real‑world QA practices using:
- Jira (workflow simulation)
- Confluence‑style documentation
- Markdown for GitHub formatting
- Manual UI testing
- API testing concepts
- SQL for backend data validation & test data setup
- ISTQB‑aligned test design techniques
🎯 Key Skills Demonstrated
- Requirement analysis & decomposition
- Test scenario and test case design
- Boundary value & negative testing
- API validation concepts
- SQL queries for backend verification
- Defect reporting (Jira format)
- Sprint‑based QA workflow
- Traceability (RTM)
- Risk‑based testing
- Professional QA documentation
📌 How to Navigate This Portfolio
If you’re an employer or reviewer:
- Start with the documentation folder to understand the project scope, planning, and high‑level QA strategy.
- Move to the jira-workflow folder to see how I execute a real sprint, including user stories, acceptance criteria, test cases, defects, and summary reporting.
- Review the Test Execution Report, Defects, and Test Summary Report to assess my analytical skills, defect investigation, and reporting clarity.
- Check the RTM to see full traceability across requirements, test cases, and defects.
- Explore the automation folder to view my Selenium + Java + TestNG framework, including POM structure, reusable components, sample tests, and ExtentReports.
- Visit the api-testing folder to see API test cases, defect reporting, and my approach to validating API behaviour using positive, negative, and boundary scenarios.
- Finally, open the sql-testing folder to view SQL queries used for:
- Backend data validation
- Verifying API responses against database records
- Preparing and cleaning test data
- Investigating defects and data inconsistencies
This demonstrates a complete hybrid QA skillset across UI, API, and database layers.
👋 About Me
I am a Manual and Automation QA Tester. I hold a Master of Science in Information Technology and I am ISTQB Foundation Level certified.
This portfolio is part of my ongoing effort to demonstrate:
- Professional QA thinking
- Attention to detail
- Clear communication
- Realistic project simulation
- Continuous improvement
🎓 Certifications
- ISTQB Foundation Level Certified
-
Selenium WebDriver with Java – Basics to Advanced + Frameworks (Udemy, by Rahul Shetty Academy)
Name: Sachi Kayastha
Location: Staines / London (commutable)
Role: Manual and Automation QA Tester
📫 Connect with me
Email: sachi.kayastha@gmail.com
LinkedIn URL: https://www.linkedin.com/in/sachi-kayastha-108961315
Thank you for reviewing my portfolio.
I hope it gives you a clear picture of my QA mindset and practical approach.