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

WordPress PluginsAnsibleExpert SystemSQLE-CommerceUnixAWS RDSPythonOllamaReportingNext.jsLarge Language Models (LLM)6502 AssemblyTradingPostgreSQLCSSStored ProceduresCActive DirectoryDECNetNetfinityLinuxTCP/IP TracingTransact SQLDelphi PascalOOPHTMLAWS S3CakePHPShadowsetstfsecEcommercecron jobsJavaScriptGraphicsPHPExcelC#.NetxamppGNUSaleforceAWSObject PascalPHPMyAdminMumpsAdobe ColdFusionJiraIBMJenkinsRESTful APIOpen SourceExcelBankingAgileTerraformClusteringVBAAndroidTrivyCOBOLSMS GatewayPluginsBBC MicroMessagingbashX (Twitter) APIManufacturingDSMXMLApacheGitHub ActionsJSONMySQLC++OracleAngularJSVisual Basic for ApplicationsWooCommerceTCP/IPTerraform Cloud (TFC)Facebook APIDCLfreetdsPhoneGapwamppBASICAWS CloudWatchWindows SDKKubernetesLlama3PHPAWS LambdaGIT FlowBootstrapMS SQLWordPressLAMPFilesystemsWSDLGITiPhoneSlack APIApache CordovaWeb ServicesCommodoreApp DevelopmentDelphiRAIDVMSSOAPVirtualBoxOpenVMSGamesRaspberry PiBACS