Beta

Ashley Gregory

SQM Data

Specsavers

Technologies

My Portfolio Highlights

My New Course

Data Manipulation in SQL

My New Course

Data Manipulation in SQL

Innovative thinker, shaping the future through data intelligence.

My Work

Take a look at my latest work.

course

Data Manipulation in SQL

course

Intermediate SQL Queries

course

SQL for Joining Data

course

Data Manipulation in SQL

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

Python Institute [PCEP-30-02] PCEP – Certified Entry-Level Python Programmer

The Open University M813 Software development

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python

Intermediate SQL

Introduction to Python for Developers

Understanding Data Engineering

Courses

Introduction to Python

Intermediate SQL

Introduction to Python for Developers

Understanding Data Engineering

My Work Experience

Where I've interned and worked during my career.

Specsavers | Jan 2023 - Present

Senior Test Manager

N/A

NATS | May 2021 - Dec 2022

COM SG V&V Lead

N/A

NATS | Apr 2021 - May 2021

V&V Engineer

N/A

Specsavers | Aug 2020 - Apr 2021

Data Test Manager and Capability Lead

Implemented and managed Data Test as a Service, engaging different streams and managing QA resources for multiple development cells. Lead the Specsavers Data Capability, outlining good Data Practices and Processes. Lead, trained, and coached a team of Data Analysts/QA Engineers and assigned them to development cells. Performed Data ETL and migration testing utilising Azure Storage, Data Lake, Databricks, and Data Factory in the Global Data Space. Developed automated data analysis and error detection & reporting tool in Databricks with Python and SQL.

Specsavers | Mar 2020 - Aug 2020

Digital System and Data Test Lead

N/A

UKCloud Ltd | Feb 2020 - Mar 2020

Test Engineer

N/A

NATS | Jan 2019 - Feb 2020

Integration Validation and Verification Engineer

N/A

Lockheed Martin | Jan 2018 - Jan 2019

Senior Test Engineer

N/A

NATS | Nov 2016 - Jan 2018

Integration Validation and Verification Test Engineer

N/A

Carnival Corporation | Oct 2016 - Nov 2016

System IntegrationTest Engineer

SDLC: Waterfall. Role and Responsibilities: * Manual system integration, functional and non-functional testing. * Working in a fast pace environment with a quick turnaround required. * Created test cases from high level business requirements and functional specifications. * Executed test cases verifying that the webMethods/ESB scheduler invoked an extraction from the database via a bespoke interface. * Verified the XML data extraction was transformed into the required format and forwarded to the correct service - FTP server, staging database or API. * Created SQL scripts and interrogated the Microsoft SQL database. * Performed functional tests on the web/browser based front-end application. * Work closely with third party suppliers based inside and outside the UK.

Ordnance Survey | Apr 2015 - Oct 2016

Senior Integration Test Engineer

SDLC: Fully AGILE BDD. Role and Responsibilities: * Worked as part of a small integration test team fed by multiple projects and release streams. * Manual system integration, application, functional and regression testing. * Created and executed test cases in HP ALM and Test Manager. * Automated tests for browser based applications using Selenium and Firebug * Automated tests using SOAPUI, Javascript and GroovySQL to verify NFRs. * Generated complex XML/GML and interrogated the ORACLE Spatial database. * Communicated with customers and third party suppliers. * Mentored junior members of the team. * Managed story cards in Jira and created pages in Confluence. Key Achievement: Having been assigned the task of investigating the defective performance test harness which hadn't been used for several years; I took the components which were still working and coded multiple scripts in SOAPUI and AutoIT to replace the non-functioning parts. I proceeded to create a performance baseline and gathered and compared the statistics through multiple phases of the project, proving that the system had increased in performance through the development changes made.

Lockheed Martin | Oct 2011 - Apr 2015

Senior Integration and Verification Test Engineer/Lead

SDLC: Semi-AGILE. Role and Responsibilities: * Manual system integration testing across a complex system of windows servers, Unix servers and interfaces. * Composed functional, non-functional, regression and DR tests from technical design documentation and discussions with System Engineers and Software Developers. * Scripted complex 1D and 2D Barcode image reading tests. * Coordinated customer test reviews, actioned feedback and performed witnessed runs of those tests. * Created test cases and tracked defects in HP QC. * Developed SQL queries to verify the ORACLE database was correctly populated. * Lead the test effort on an ETL and data transfomation project. Key achievement: As part of large barcode reading and data extrapolation project, I constructed the barcode reading performance test using a combination of dos scripting, Unix shell scripting (bash) and AWK. This consisted of a large suite of bespoke data messages written for 4 different types of sorting machine. The data output for each machine was gathered and verified, and the metrics presented to all interested parties.

NATS | Oct 2006 - Oct 2011

Senior System Validation and Verification Engineer

SDLC: Waterfall. Role and Responsibilities: * Worked shifts as a System Infrastructure and Software tester in a large test team. * Reviewed the design documentation and discussed the technical solution as part of assigned Change Requests. * Worked closely with Safety and System Engineers to devise a Test Design. * Created Performance, Functional, Non-Functional, DR and regression test cases. * Tested the legacy system of Token Ring, Unix servers and command line applications. * Tested the integration of a new system including Ethernet network communications and front end applications for flight trajectory and prediction tools. * Performed packet data analysis and gathered defect evidence. * Test procedures were executed in a large Test lab environment with multiple systems configured to give a simulation of the real ATM environment. * Raised, tracked and retested defects found during Testing. * Mentored new starters. Key Achievement: I was assigned the task of verifying the NTP implementation as part of the Ethernet network infrastructure. I tested the stability of the NTP daemon against 3 different types of GPS clocks. I performed system failure and disaster recovery of various part of the NTP stratum. The results of system recovery, time slew and leap second testing were recorded and reported. In each case the NTP time feed was compared to the Time server serial feed Token Ring network.

Specsavers | Oct 2005 - Oct 2006

Senior Test Engineer and Team Lead

SDLC: Fully AGILE TDD. Role and Responsibilities: * Functional, Systems and Integration Testing for Specsavers’ Epos system: GUI client front end (incorporating barcode scanners and touch screen technology), and Red Hat Unix servers back end. * Created test procedures from technical and business discussions. * Executed new and regression test procedures, logged defects and retested. * Created Automated tests using an in-house test automation tool. * Lead a small team of developers and testers, working on story cards in weekly iterations.

Axxia Systems | Feb 2004 - Oct 2005

Senior Software Test Engineer

SDLC: V-Model Role and Responsibilities: * Tested browser based Accountancy and Finance products used by Law firms. * Created test procedures from functional and technical specifications in HP QC. * Executed new and regression test procedures, logged defects and retested. * Used SQL to interrogate, administrate and restore the SQL Database. * Produced Automated test scripts using Javascript in the Radview Webload test tool.

International Decision Systems | Dec 2001 - Feb 2004

Software Test Engineer

SDLC: Waterfall Role and Responsibilities: * Tested Finance and Accountancy applications used by car finance and leasing companies. * Created test procedures from functional and technical specifications in HP QC (Test Director). * Executed test cases on Windows desktop and Browsers based applications, logged defects and retested on multiple development streams. * Scripted SQL in TOAD to interrogate the ORACLE database.

My Education

Take a look at my formal education

Bachelor’s Degree, Computer ScienceUniversity of Portsmouth | 2001

Create Your Data Portfolio for Free