Miki Travel is a global travel services company, bringing large numbers of tourists from Japan and South East Asia to Britain and other European countries. To provide services to their clients, Miki Travel needs to book large numbers of hotel rooms, coach tours and restaurant tables.
Their project was to move the restaurant booking process from a fax/email driven procedure to one in which bookings would be sent to a web account which a restaurant owner/manager would be able to log into and see all their bookings from Miki Travel on a dashboard. This would include migration of data from an existing AS400 database to a MySql database, and synchronising the AS400 database with updated data from the web interface.
Fulfilment of the project involved:
- Writing scripts to cover the range of manual testing, functional testing, and regression testing based on requirements and Acceptance Criteria in BDD based User Stories. This also included identification of gaps in those User Stories and Acceptance Criteria.
- Execution of the tests across multiple browsers, and reporting of test findings.
- Use of database seeding scripts from Git repository to prepare the database for migration.
- Creation and insertion of test data to the database using SQL, Liquibase, or Postman REST services, as appropriate.
- Modification of test data to test different scenarios.
- Validation that the integration of new and legacy databases was implemented correctly, and also testing that two way communication between the two databases was handled as expected.
- Creation of dummy user accounts for testing User Registration, password reset, and communication processes.
- Testing that end-to-end processes from initial bookings through to final reconfirmations via amendments and holding confirmations, were behaving as expected.
- Testing that page load times met business requirements with increasing numbers of users.
- Deployment of new code releases to the test environment using Jenkins Continuous Integration tool.
- Raising defects with instructions for how to reproduce the issue, including screen shots or video recordings as appropriate, and demonstration of the defects to the relevant developer. Chasing defects where necessary to ensure that fixes were made in sufficient time for them to be retested within the sprint, ensuring that sprint commitments were kept.
- Demonstration of completed stories to the Product Owner and production of weekly and sprint end reports for the Scrum Master and Project Manager.
Technologies used in testing of the project included:
Agile, AS400, AWS, BDD, Confluence, Continuous Integration (Jenkins), CSS, DB2, GIT, HTML, Java, JavaScript, Liquibase, MySQL, Postman REST Services, Putty, SpiraTest, SQL, Squirrel, XML