Graeme McAllister

Architected and maintained a 5th Normal Form SQL Server database schema (600+ tables) supporting CRM, insurance claims processing, financial accounting, and partner portals, serving over 1,000 users and millions of customers across multiple desktop, web, and mobile applications.

Optimized database performance by diagnosing and resolving locking, speed, and resource issues using SQL Server Query Store and execution plan analysis, achieving up to 300% performance gains in reporting workloads.

Developed and implemented a C#/.NET and ASP.Net driven motor insurance premium calculation engine with configurable weightings and rule ordering, enabling transparent and auditable quotation and referral decisions.

Led the migration and enhancement of a custom CRM system from Access/VBA to a WPF application with MVVM architecture, impacting 200+ employees and hundreds of thousands of customers, incorporating automated allocation and workflow validation.

Designed and implemented SQL and Python-driven JSON/XML API integrations with external systems (e.g., Adobe eSign, Google Maps) to automate workflows, facilitate secure data exchange, and ensure GDPR compliance.

Redeveloped and enhanced the SQL-driven custom Nominal Accounts package, managing approximately £50 million in annual turnover by automating month-end/year-end procedures, financial reporting, and banking API communications.

Implemented ChatGPT API automation using C# and a JSON RESTful API to streamline case note analysis and summarization, enhancing data processing efficiency.

Developed comprehensive SQL-driven reporting frameworks, including KPI dashboards and automated Python-based email reports, providing critical management information and data visualization using Matplotlib and Ploty.

Designed and maintained a high-performance MySQL database infrastructure, successfully powering and supporting a network of over 40 active websites.

Developed scalable Drupal/WordPress hybrid templates, standardizing deployment processes and enhancing efficiency across multiple site implementations.

Led a small development team in the successful implementation and rigorous testing of multi-site features, improving platform functionality and user experience.

Developed a comprehensive student careers portal utilizing ASP.NET and SQL Server, providing robust functionality for career guidance and resource access.

Delivered reliable back-end services, ensuring seamless data flow and integration with user-friendly front-end templates for an enhanced user experience.

Refined and optimized portal features through iterative stakeholder feedback and rigorous testing, ensuring alignment with user needs and institutional requirements.