Freelance analyst/programmer based in Berlin, Germany.
In addition to the work I have done for clients, I also have some projects I work on in my own time in order to practise my skills or learn new ones. All are publicly hosted and the web projects have live demonstrations. Please click the name of each project for screenshots and further information about it.
|businessConfig||Go application with an AdminLTE web frontend which is intended to be a tool for Product Managers. The live demo portrays a fictional library, but also uses some publicly available data from the website of the Chicago Public Libraries.||http://cpl.macinntech.com||Github|
|Investalot||Excel VBA / MS SQL Server financial application for a fictional investment company.||Github|
|Tech Club||PHP web application for a fictional IT learning club.
On the live demo, you can log in as email@example.com / Test11 to see the pages which require authentication.
|Tech Club PostgreSQL database||The PostgreSQL database of the above application. Makes extensive use of normalized design, views and functions.||Github|
|Toren's Tale||C# forms implementation of a 2D game engine.||Github|
When learning a new technique, I like to document the process for future reference. Here are some guides I have written about various technical subjects. They were almost all written around the same time as I developed the Tech Club web application (see above), so they mainly refer to web development and server deployment.
|Set up local development environment||Set up the local Ubuntu machine, including Apache, PHP and PostgreSQL.|
|Deploy an EC2 server||Deploy and secure an AWS EC2 virtual server running Ubuntu Linux and access it using SSH.|
|Configure the EC2 server||Configure the new EC2 server with Apache, PHP and PostgreSQL and show how port forwarding works.|
|Add an EBS volume||Move the database data onto a separate, specialized AWS data volume.|
|Automate backups||Use the EC2 API and cron to automate backups of the instance and data volume (assumes "Add an EBS volume" is done).|
|Deploy the site||Copy the application files to the new server using FileZilla, then show the necessary steps to get the site online.|
|Review of security||Review a list of possible security attacks, and how (or if) the application is protected from them.|
|Add SSL/TLS encryption||Encrypt traffic to and from the site with an SSL/TLS certificate.|
|Add the Wiki||Add a MediaWiki, configure it, and link to it from the site.|
|Prevent bot form submissions||Show measures to stop bots from submitting spam via public forms.|