At multiple companies I have created internal administration systems, including completely bespoke intranet software.
Off-the-shelf tools
- Managed a private company wiki as a MediaWiki instance over many years.
- Installed and managed Roundcube web mail as an emergency backup for desktop IMAP applications.
- Set up customized instances of Request Tracker (RT) at several companies, integrating it with bespoke administration software and company email systems.
- Heavily customized the Bricolage content management system for a local council.
Bespoke admin software
Over many years I've built and maintained a complex internal administration system for a training company.
Along with various offline tools, I created a PHP and JavaScript web interface for users, allowing editing and access to the records in the MySQL database through many different views depending on use case.
Some things this involved are:
- Tracking live changes in JS to highlight unsaved changes
- Live client-side editing of records in tables
- Calendar display of upcoming schedule with status colours and icons, and links to records
- Popup alerts to highlight necessary actions
- Semi-automated email generation
- Creating standardized messages from templates
- Delivering outgoing messages through Request Tracker tickets
- Creating PDF documents such as invoices and including as attachments
- Online popup help buttons, visibility configurable by the user
Accountancy software
I've created software from scratch to track income and expenditures according to company needs.
- Recoding and editing of income, and when necessary whole or partial refunds
- Recording expenditures
- Tracking which expenditures are related to a sale in order to estimate profitability
- Using profitability to calculate profit-share due to contractors
- Logging and using ECB data to convert between pounds sterling (GBP) and Euro amounts based on the original transaction date
- Built in JS/canvas based graphing of analytics information recorded by the system
Training course scheduling software
I wrote a complete scheduling system for a training company.
- Following complex rules to decide when and where to schedule courses
- Fully configurable based on web-based user interface
- Publishing dates etc on appropriate web site pages