Patrick Drew

• ›Designed CloudFormation template and PowerShell DSC resources for creating a multi-subnet VPC and EC2 instances used to complete Secure Software Report of Validation.
• ›Created monitoring solution for build server instances using Lambda, CloudWatch Agent, Logs, Alarms, Synthetic Canaries and AWS CDK.
• ›Implemented custom patch management for EC2 instances using Systems Manager Automation and Run Commands, deployed and maintained with AWS CDK.

• ›Full stack development on an enterprise CRM, a centralised platfrom for fundraising, marketing and ticketing, licensed by 750+ leading arts organisations.
• ›Ported functionality from a legacy desktop application to a single page web application backed by a RESTful API.
• ›Implemented pandemic rapid response features for the Tessitura ecommerce platform, allowing 500+ member organisations to retain revenue and stay connected with customers.
• ›Responsible for database architecture, API design and Android client implementation of an access control / ticket scanning application.

• ›Technical lead for integrating Sisense analytics platform with Tessitura enterprise CRM.
• ›Developed single sign on solution between the two systems using ASP.NET and Angular.
• ›Built continuous integration pipelines in GoCD and implemented end to end tests with Selenium.
• ›Created custom visualisations using JavaScript, AngularJS, Highcharts, and D3.

• ›Completed 5 data conversion projects, migrating client data from legacy systems into Tessitura with a 100% success rate.
• ›Provided excellent support for users of Tessitura software, resolving impactful and time-sensitive issues with urgency.
• ›Built custom applications for clients using ASP.NET, JavaScript, SQL Server and WPF.

Resume website created with Next.js and Tailwind, hosted in S3. Visitor counter powered by Lambda, DynamoDB and DynamoDB Streams. Infrastructure deployed with AWS CDK, CI/CD managed with GitHub Actions.