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

Tag: 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 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

Tags

SaleforcexamppShadowsetsVisual Basic for ApplicationsNetfinityCommodoreiPhoneWSDLfreetdsX (Twitter) APIGitHub ActionsOpenVMSApacheBACSApp DevelopmentDECNettfsecPhoneGapVMSStored ProceduresManufacturingGamesTerraformVBAOpen SourceCGIT FlowGITBBC MicroUnixWordPress PluginsTCP/IP TracingFilesystemsTCP/IPHTMLGraphicsAWS RDSLAMPAWS S3PythonPostgreSQLSOAPLinuxPHPMyAdminNext.jsRAIDTrivyOOPApache CordovaDelphiGNUAnsible6502 AssemblyReportingObject PascalJiraVirtualBoxActive DirectoryTradingAndroidcron jobswamppDelphi PascalSlack APIFacebook APIJSONBootstrapWeb ServicesSMS GatewayAngularJSJavaScriptWooCommerceDSMExpert SystemEcommerceAWSKubernetesC++Raspberry PiCakePHPAWS LambdaCOBOLMS SQLbashPHPExcelRESTful APIMumpsSQLOllamaC#.NetClusteringOracleExcelE-CommerceAWS CloudWatchTransact SQLLarge Language Models (LLM)MessagingPluginsBASICAgileJenkinsCSSIBMPHPAdobe ColdFusionDCLXMLTerraform Cloud (TFC)Llama3Windows SDKBankingMySQLWordPress