Consultation/specification/design/implementation: Django integrations with CIFS, AD, MSSQL, Exact Globe, MailChimp, Dropbox, PHP+MySQL, etc.
Monitoring (plugin) design/transition/implementation: Nagios 3 to Icinga 2.
Created thousands of tickets as de facto project manager, often in cooperation with the de jure project manager and other IT parties as well as end-users and clients.
Consulted, implemented and managed many projects for Ytec's main customer Victron Energy, spanning numerous integrated applications and multiple auxilary IT suppliers. Most of these projects revolved around Victron's MSSQL installation in which data from multiple applicationsβoff-the-shelf applications such as Exact Globe, Slim4 and WATS as well as some custom applicationsβwas aggregated.
Transparent (invisible to the application) auto-versioning database-backend (for the AltiumComponents program), which produced HTML-formatted weekly change digests, all from within MSSQL.
MSSQL-centric infrastructure for monitoring the various applications, integrations and automations that were centralized in Victron Energy's SQL Server.
Created, simplified and extended many, often-complicated, automations for Victron Energy, making heavy use of MSSQL, SSRS, SSIS, C#, Django, and Python.
Developed a custom Django API + dashboard for realtime planning insights and predictions from Redmine data.
Mediated between colleagues, trained junior colleagues and helped streamline internal (HR) processes.
Developed a complicated Magento 2 extension to aggregate tire data from a large number of sources and select the best deals per EAN code, using advanced MySQL wizardry to sidestep Magento 2's abysmally malperformant APIs. Different data sources could be rated per attribute for their quality.
Set up 3 big, continuously deployed Magento 2 instances, surrounded by an assortment of custom Bash scripts and cron jobs for optimum ease of development, maintenance and upgrading.
Set up EDI interfaces to tire suppliers on one end and tire buyers on the other end.
A custom-tailored, light-weight PHP MVC / REST framework + MySQL for the backend.
Precise use of HTTP headers and a RESTful URL design to allow for efficient caching by a reverse HTTP proxy. Logins where taken care of without requiring the content served (and cached!) for each URL to change. (The Vary response header required very few references to other request headers.)
Built various version of www.sicirec.org,
the last version being based on
Drupal (with various (self-made) modules) and earlier versions on a pipeline that used
GNU Make and
XSLT to transform
XML and
XHTML to regular
HTML.
Built a complicated CRM system based on PostgreSQL for the back-end and Ruby on Rails for the front-end. The database (100+ tables) made heavy use of stored procedures, triggers and views. One of its components was a rating schema with automatic version management using an event model.
Built an LDAP gateway for said system to supply LDAP-powered auto-completion in e-mail clients and appliances such as a network printer.
Before the deployment of this system, built a user-friendly LDAP management tool in PHP.
Wrote a carbon footprint calculator using PHP.
Created the prototype of a reliable backup framework, requiring advanced Bash shell scripting.
Used Microsoft Excel to constructed a complicated financial planning model with support for multiple scenarios.
Implemented the full stack for a WordPress-based site for Aihato, based on a design contributed by Ytec. Features included: a custom theme, an advanced gallery that merged two jQuery plugins, an intuΓ―tive AJAX event editor, fighter profiles and more. I published detailed documentation about the 2010 development process. In 2022,before I relinguished the responsibility for the website, after maintaining it for 10+ years.
Set up and maintained 4 MediaWikiinstallations using the Semantic MediaWiki extension. Contributed my own dynamic image gallery extension on top of the Semantic MediaWiki extensions.