Lloyd Thomas (2011138) Lloyd Thomas

Automating Test Data Compilation for An Insurance Company

Project Abstract

For the academic year of 2022 – 2023 I completed a year in industry placement at Admiral insurance working as a Test Automator, in the pricing test team. In this role I was often asked to create data-sets for batch testing and found the process to be repetitive and time consuming. Upon completion of the year in industry placement my line manager offered me the opportunity to improve the batch data set compilation process. This project will speed up the process of creating large batches of data, allowing the Pricing Test Team time to work on other projects improving the test coverage within Admiral as a whole. The aim of this project is to create a system that can compile batches of test data programmatically and replace the current process of manually extracting and selecting data for the tests. The proposed solution to this problem is to create a SQL database that contains schema of searchable terms. Testers can then use a UI to select the relevant features they want in a dataset which will be used to query the database. The returned values will be compiled into a dataset and tests will automatically run and test results will be displayed. The finished product provides a ?��self-serve?�� style interface for dataset compilation that is much quicker than before and can be easily expanded upon to create more specific sets of test data containing niche criteria.

Keywords: Testing, Industry Project, Automation

 

 Conference Details

 

Session: Poster Session B at Poster Stand 26

Location: Sir Stanley Clarke Auditorium at Wednesday 8th 09:00 – 12:30

Markers: Markus Roggenbach, Giedre Sabaliauskaite (Siraj)

Course: BSc Computer Science FI, 3rd Year

Future Plans: I’m looking for work