30 years experience programming in many computer languages
Experienced automating the execution of embarrassingly parallel SQL scripts running within a Dell PowerEdge server hosted on the NeCTAR research cloud.
This includes using a number of MySQL components:
- Data Imports
- MyISAM and InnoDB Storage Engines
- Transaction Control
- Clustered and Secondary Indexes
- Stored Procedures
- LOOP Block
- Multiple Table Joins
- Sub Queries
- Auto-Increment Fields
- User Defined Variables
- Prepared Statements
- Running Totals
- Lagged Variables
Developer of a FireBird SQL database backend with Microsoft Access frontend used in Veterinary retail.
This includes using a number of Firebird SQL components:
At Monash University developed the DBRealTime Visual C# GUI program to show the progress of embarrassingly parallel SQL queries.
This includes using a number of C# components:
- Windows Forms
- MySQL .NET Connector
- Microsoft Office API Objects
- Exception Handling
- Icon Manifest
At Peter Mac Implemented C# .NET services for background processing of queries generated using a web frontend.
Developed a Visual C# installer using InstallAnywhere and added custom Visual C# GUI forms.
At Monash University implemented a suite of C++ programs for research in to Fundamental Indexation.
This includes using a number of C++ components:
Used the GNU Scientific Library (GSL) to add regression functionality to the C++ code.
A utility program named Aggro was written to support the generation of tables in our journal publications.
The AggRo application is available for download with source code.
In the subjects BFC3540 Modelling In Finance and BFC5936 Financial Modelling have taught, using Microsoft Excel, programming concepts including:
- Data Types
- Variable Declaration
- Conditional Statements
- Conditional Operators
- Looping Constructs
We also teach how to use a number of Excel features including:
- Absolute and Relative Addressing
- Aggregate Functions
- Data Tables
- Goal Seek
PowerPoints: BFC3540 Modelling In Finance
Used the Java Compiler Compiler (JavaCC) to add annotation syntax to the Java language.