Rocode >> Contracting
Examples of my database development, networking installations and programming skills are detailed for a number of industry sectors.
Key Technical Skills
This is a legend for the icons used below.
|Screencast:||PowerPoint Slides:||Installer:||Audio Recording:|
Real examples of work from 1992 thru to 2015 have been uploaded to this website and are listed below.
CSIRO-Monash Superannuation Research Cluster - 2015
Written using MySQL, HeidiSQL, Pentaho Kettle, Microsoft Windows Server
Assembled a database to enable analyse of Australian and USA stock exchange data from the Sirca Australian Equities Database and Thomson Reuters Tick History Database. The terabyte MySQL database was hosted using the NeCTAR cloud with Microsoft Windows Server virtual machines.
Written using XAMPP, HeidiSQL, Pentaho Kettle, MySQL Enterprise Server, Red Hat Enterprise Linux
Stock Indexation and Portfolios - 2012
Fundamental Indexation of Stock Portfolios
Written using C++, GNU Scientific Library
Authored an applications suite built using C++, in Microsoft Visual Studio, that simulated using accounting fundamentals from the CRSP/Compustat Merged Database for portfolio indexation. The project was sponsored by an Australian Research Council (ARC) linkage grant. The suite consisted of console based applications and only used file input and output. CSV outputs were then imported to Microsoft Excel for tabulation and pivot charting.
Socially Responsible Investments
Maintained C++ software to replicate Fama and French factors on USA stocks and added SRI filtering.
Funded by The Australian Centre for Financial Studies (ACFS).
DNABuddy: A Microarray Database for Expression and SNP data - 2009
Written using C#, PhP, XAMPP, Windows Servers
Authored a repository built using a 3-teir architecture running on a Blade Cloud. The MySQL backend and PhP web tier were built on Microsoft Windows using Xampp. The repository stored published experimental data downloaded and imported from the USA governments Gene Expression Omnibus (GEO) or from in-house experimental data.
VetBasic: Veterinary Practise Management Software - 2005
Written using Microsoft Access (VBA), Firebird SQL
Authored a client server application using Microsoft Access as its graphical interface. It was used to manage the daily customer facing operations of the veterinary clinics. SQL queries where used to connect the graphical interface to a remote Firebird SQL backend. The application was written to support real time operation of two geographically separated clinics with two terminals at each location.
ENE: Elvin Router - 2001
Written using Portable C
This is a R&D application invented by the DSTC CRC. It is a publish and subscribe by content event router. The project received substantial funding from the USA governments Defense Advanced Research Projects Agency (DARPA). It was written in portable C but has since been rebuilt in open source Java.
Rolls Printing Medical Records Inventory Software - 1992
Written using Clipper, C
This was a final year project at Monash University. I was a team member to write the inventory application using Clipper and C.
I have collected a small number of industry training certificates.