London, England, United Kingdom
Built a Power BI system integrating therapist forms, patient data, and patient-completed forms for management and clinical purposes Developed and managed a centralised Power BI ‘golden dataset’ to prevent data siloing, ensuring consistent data across reports Migrated key ETL data processing operations to a scalable, automated cloud-based data warehouse Promoted educational initiatives for clinical management and operations teams Directed a project to enable automation of data integration with the NHS Digital Mental Health Services Data Set Led the development and execution of the data strategy in partnership with senior leadership Partnered with the CEO to identify and prioritize critical healthcare statistics for National Health Service reporting and external funders, driving the charity’s most successful fundraising efforts to date Provided dashboards and visualizations for the board of trustees
Proposed and implemented IT budget cuts that slashed tech spend by over 30% through renegotiating pricing and contracts with existing vendors, auditing AWS spend, controlling licensing, and eliminating unnecessary tools Designed and launched group sales system that is now accountable for 28% of ticket sales. Ensured compliance with the GDPR, including redesigning email opt-in to focus on consent, managing re-opt-in campaigns, ensuring our systems were private by design and creating policies for the right to erasure and acceptable use policies Directed development across three teams for new feature development and bug fixes for the CRM, CMS and a custom ticket registration platform and a timing and scoring platform Migrated systems from a managed Active Directory server to cloud Active Directory, migrated email from Exchange to Gmail Created a Business Intelligence platform using PowerBI to support data-driven decisions, using both the inbuilt Power Query formula language (M) and DAX and R-Lang, that included sales activity, YOY analysis, geographic heatmaps, performance of marketing campaigns. Cleaned data from legacy systems for analysis Integrated CRM with Mailchimp, developed automated marketing email campaigns for marketing and transactional emails. Ensured deliverability through both technical best practices (e.g. DKIM, SPF and DMARC) and ‘soft’ practices Migrated systems to SAML SSO and multifactor authentication. Led project to rationalise SSL certificates. Enhanced and streamlined IT off-boarding and on-boarding processes
Trained and coached fellow developers Wrote an invoicing, credit-control, payment and allocation system using the LAMP stack Migrated existing FileMaker database to MySQL Created bespoke customizations for SugarCRM, was responsible for maintaining and upgrading SugarCRM and ElasticSearch Debugged and refactored existing codebase Optimised build scripts, managed deployment and continuous integration