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: Slack API

VPN Security Monitor at MyTutor

MyTutor use a high quality external VPN provider. But to ensure that key urls are hidden behind it, I built this simple monitor to test that a list of key URL’s remain unavailable when the VPN is not in use.

GitHub Actions, Python, Slack API

RDS User Monitor for MyTutor

At MyTutor, we aimed to ensure that the application database was accessed only by authorised user accounts for legitimate reasons. This project involved analysing AWS CloudWatch logs for the AWS RDS instances to extract relevant information. A list of users and their executed queries was compiled, excluding certain allowed users. The accounts that did not meet the criteria were then posted to a Slack channel for review.

AWS CloudWatch, AWS RDS, GitHub Actions, MySQL, Python, Slack API

Application Code Security Scanner for MyTutor

I implemented Trivy scanning for the MyTutor application code. Trivy scans for:

GIT, GitHub Actions, JSON, Python, Slack API, Trivy

Terraform Security Scanner for MyTutor

I took over a project from a previous DevOps engineer who had recently left MyTutor. The project involves scanning Terraform files for vulnerabilities using the tfsec utility. Initially, the scan results were uploaded as an HTML file to Slack, which required downloading to identify vulnerabilities.

GitHub Actions, Python, Slack API, Terraform, Terraform Cloud (TFC), tfsec

Tags

CakePHPRAIDCommodoreXMLGraphicsMySQLC#.NetMS SQLJenkinsExcelSlack APIBankingC++Facebook APITerraformOpenVMSBACSPostgreSQLActive DirectoryOpen SourceAWS RDSMessagingWordPress PluginsJSONLAMPGitHub ActionsTerraform Cloud (TFC)AWS LambdaIBMCxamppVBAPhoneGapX (Twitter) APIiPhoneManufacturingSMS GatewayShadowsetsWSDLTCP/IPAgileDECNetE-CommerceDelphi PascalVMSReportingAnsibleApache CordovaUnixAWS S3AngularJSTradingVisual Basic for ApplicationsMumpsSQLJiraRESTful APIOOPRaspberry PiWeb ServicesWordPressExpert SystemPHPLlama3Large Language Models (LLM)6502 AssemblyAdobe ColdFusionTrivycron jobsHTMLPHPExcelOracleKubernetesClusteringVirtualBoxOllamaNext.jsAWSGamesSOAPGNUBASICDCLLinuxDelphiSaleforceAndroidFilesystemsJavaScriptwamppNetfinityCOBOLbashDSMTransact SQLStored ProceduresApp DevelopmentWindows SDKAWS CloudWatchObject PascalApachePluginsGITEcommerceCSSGIT FlowtfsecBBC MicroBootstrapTCP/IP TracingWooCommercePythonfreetdsPHPMyAdmin