Skip to content

Crafted Systems

Portfolio of projects – please get in touch if you have a requirement

  • Availability
  • Download CV
  • Skills
    • .NET
    • 6502 Assembly
    • Active Directory
    • Adobe ColdFusion
    • Agile
    • AI
    • Android
    • Angular
    • Apache
    • Apache Cordova
    • AWS Cloudwatch
    • AWS Lambda
    • Banking
    • BASIC
    • Bootstrap
    • C
    • C#
    • C++
    • COBOL
    • DCL
    • Excel
    • GIT
    • GitHub Actions
    • iPhone
    • JavaScript
    • JSON
    • Large Language Models
    • Linux
    • MS SQL
    • Mumps
    • MySQL
    • Next.js
    • OpenVMS
    • Oracle
    • Pascal
    • PhoneGap
    • PHP
    • PostgreSQL
    • Project
    • Python
    • Terraform
    • Terraform Cloud (TFC)
    • tfsec
    • Trivy
    • Uncategorized
    • VBA
    • Visual Basic
    • WooCommerce
    • WordPress
    • XML

Category: MS SQL

NHS eAIMS project

I served as the sole developer on this project, constructing it as a C#.NET web application with Entity Framework utilised for database access. AngularJS was used for the front-end functionality of the application.

AngularJS, Bootstrap, C#.Net, CSS, JavaScript, JSON, MS SQL, PHP

NHS Live Wait Times Android and iPhone App

The app enables users to search for sites based on postcode, device location, or locality. In addition to waiting times, it provides details such as opening hours, available treatments, and parking information for each site. Relevant news feeds related to selected sites are also featured.

Android, Apache Cordova, App Development, iPhone, JavaScript, JSON, PhoneGap, PHP, PHPMyAdmin, RESTful API, Web Services

NHS UHNM Active Directory security in PHP

This project was another part of my role supporting the internal PHP systems at Royal Stoke Hospital.

Active Directory, MS SQL, PHP, wampp, xampp

HOPS Linux Server

HOPS required a reliable server to host essential business applications. This server was crucial for hosting the client portal, generating nightly management reports, and facilitating an authorisation API to the MS SQL server.

Apache, Linux, MS SQL, MySQL, PHP, RAID

HOPS Customer Portal

HOPS operated an MS SQL database on Microsoft Small Business Server which had fallen out of support. The database was overly complex, housing over 100 tables and more than 400 stored procedures and functions.

Apache, Linux, MS SQL, PHP, SQL, Stored Procedures, TCP/IP Tracing, Transact SQL

HOPS Nightly Excel Reports

Key personnel at HOPS rely on daily management reports to monitor daily operations, particularly as much of their work occurs off-site. To meet this need, they requested automated nightly generation and distribution of these reports to designated staff members via email.

cron jobs, Excel, MS SQL, PHP, PHPExcel, Reporting

HOPS Website

The HOPS website required modernisation to include specific legal compliance information. I proposed using WordPress to create a basic brochure site, utilising its CMS capabilities to empower existing staff to update the required pages.

Apache, freetds, Linux, MS SQL, MySQL, PHP, Plugins, WordPress Plugins

Incommunities Development Environment

This server became my primary development tool throughout my contract and was subsequently adopted by the resident development team.

Apache, GIT, LAMP, Linux, MySQL, PHP, PHPMyAdmin

Tags

Terraform Cloud (TFC)PHPPhoneGapWordPressX (Twitter) APIManufacturingE-CommerceGNUPHPExcelDCLWeb ServicesAndroidLarge Language Models (LLM)TerraformVirtualBoxRaspberry PiTCP/IP TracingNext.jsFacebook APIMessagingWSDLVisual Basic for ApplicationsOllamaAdobe ColdFusionMumpsLAMPAngularJSTransact SQLOOPAWS LambdaGIT FlowC#.NetOpenVMSDSMActive DirectoryJavaScriptUnixC++HTMLAWS RDSWordPress PluginsApache CordovaObject PascalTradingRESTful APIAWSBBC Microcron jobsAnsibleSOAPCwamppxamppShadowsetsGitHub ActionsMS SQLIBMbashOpen SourcePHPMyAdminAgileiPhoneBootstrapReportingCommodorePluginsDelphi PascalAWS S3Slack API6502 AssemblyPythonVBABACSKubernetesRAIDBASICGITEcommerceLinuxLlama3JenkinsSQLPostgreSQLNetfinityStored ProceduresCOBOLCSSApp DevelopmentSMS GatewayAWS CloudWatchGamesFilesystemsGraphicsWooCommercefreetdstfsecXMLSaleforceExcelDelphiVMSMySQLJiraBankingOracleTCP/IPExpert SystemTrivyJSONDECNetClusteringWindows SDKApacheCakePHP