Alex Barrett Email & Phone Number

London, England, United Kingdom

• Led the transition of a data-heavy project to a client-server model, leveraging ClickHouse, Cube.js and Apollo GraphQL to greatly improve performance, reduce data transfer to the front-end, and provide a scalable foundation for future development.• Designed optimised ClickHouse database schemas to support fast aggregation and querying across a large 500M row dataset.• Developed a front-end using React and TypeScript, incorporating AG Grid for advanced data grid functionality, including SSRM (server-side row modelling), tree hierarchies for drilldowns, dynamic filtering, custom cell rendering and editing.• Collaborated extensively with data engineering teams and other stakeholders to ensure robust data flows between applications and services, utilizing Redis to publish messages for ingestion by other applications and microservices.• Acquired in-depth expertise in ClickHouse and Cube.js, providing technical guidance to the team and elevating the team’s ability to work with these technologies.

London, England, United Kingdom

• Led a two-person team to develop a PWA (Progressive Web Application) using React, MUI and service workers to deliver a compelling user experience with offline browsing and an offline-first data loading strategy, transforming a cumbersome 10-minute, report-based workflow into a streamlined, sub-second analysis process.• Developed an AWS-based, serverless application using Cassandra and ElasticSearch for sophisticated data modelling and fast keyword/faceted searches. Assumed ownership of specific architectural components: CSV data ingestion, hierarchical entity modelling, and a feature-rich image viewer with animated panning and zooming via Spring.js, as well as 3D model display with Three.js.• Developed a microfrontend in React and TypeScript, integrated within a company-wide web application framework and powered by a REST API built with Node.js and Express on the back-end, and using RxJS on the front-end as well as D3.js for custom data visualizations.• Authored clean, scalable, and well-tested code for multiple projects with a focus on high-performance applications and user-centred design.

Truro, England, United Kingdom

• Lead developer on successful projects using agile methodology. Involved in specification, architecture, implementation, deployment and maintenance; all phases of the SDLC. Planning with Jira and Pivotal Tracker.• Worked on-site with project stakeholders to detail project specifications and suggest workflow improvements.• Involved with projects for major clients including Timpson, GDS and a national law enforcement agency.• Developed a React application following Flux architecture with a supporting REST API and administration area.• Introduced automated builds and local environments via use of Jenkins, Vagrant and Docker to improve development practices.• Administered Linux servers running variations of Nginx, PHP-FPM, MySQL, Redis, Varnish Cache. Configured load-balanced servers using Lsyncd and Csync2.

Falmouth, England, United Kingdom

• Developed and maintained projects across a range of platforms including Drupal, WordPress, Ubercart, Drupal Commerce, Drupal Commons and Backbone.js. Often entrusted to be the sole developer on projects.• Operated in an agile environment, participating in daily stand-ups.• Collaborated with the design team to create pixel-perfect responsive websites and provide technical feedback into the design process.• Authored custom Drupal modules and themes providing clients with bespoke functionality and designs.• Developed a custom WPF theme using C# and XAML for a client in the financial sector.• Met with clients to translate business requirements into technical specifications

Truro, England, United Kingdom

• Developed and maintained a bespoke PHP application relied upon by the company to schedule, coordinate, quote and invoice all work as well as manage staff absences – replacing existing paper-based systems that amassed up to 30,000 pieces of paper per year• Designed and developed multiple additional applications that interfaced with the primary application, including a fully AJAX mobile client for Windows Mobile devices and a B2B web application exposing functionality to other companies in the sector.• Designed and developed a USB-based client-server authentication system using C#/WinForms and Python.• Designed custom SQL tables, views, stored procedures and indexes for the applications to model company processes.• Integrated heavily with external APIs and services including Google Maps, SMS and the Royal Mail PAF database.• Administered Linux servers with LAMP stack, FTP and backup services.• Company received the “Best Use of Technology” award at the Cornwall Business Awards 2011 for these applications.