My experiences within the domain of IT are quite varied and overlap with my engineering experiences. I worked as a consultant for the Government of South Australia within the Energy Division determining the efficiency of remote power generation sites. During both my time at university I worked as a freelance programming for both Topstairs and Aces performing various programming tasks in Visual Basic, C++, C#, PHP, SQL, CSS, Java and HTML
This programming project involved the creation of an access database that can view historical data of power generation sites. 10 different remote power generation sites can be compared in terms of period generation, load duration, fuel efficiency, phase loading and daily maximum and minimum. These Access forms were created using SQL statements and the data for each site is parsed and imported using custom Visual Basic programs. During the parsing phase of the data importation, extra values are derived such as power generation to ensure that he database runs quickly.
An example of some of the SQL statements created are:
If GraphResolutionCbo = "Minute(s)" Then
SQLString = "SELECT (Format([PC Time],'" & DateFormat1 & "')),Avg([Total Power]) AS [AvgOfTotal Power], Avg([Total Fuel Flow])" & _
"AS [AvgOfTotal Fuel Flow], Avg([INVFF]) As [AvgOf INVFF] " & _
"FROM " & SiteNameFuelPower & " GROUP BY (Int([PC Time]*1440)),(Format([PC Time],'" & DateFormat1 & "'));"
ElseIf GraphResolutionCbo = "Hour(s)" Then
SQLString = "SELECT (Format([PC Time],'" & DateFormat2 & "')),Avg([Total Power]) AS [AvgOfTotal Power], Avg([Total Fuel Flow])" & _
"AS [AvgOfTotal Fuel Flow], Avg([INVFF]) As [AvgOf INVFF] " & _
"FROM " & SiteNameFuelPower & " GROUP BY (Int([PC Time]*24)),(Format([PC Time],'" & DateFormat2 & "'));"
An example of some Access forms created are:
The Web Stairs Tracker is a program and web site that works in tandem to provide the customers of Topstairs the ability to view the progress of the clients stairs. The uploading program was written using C with a library called libcurl. The website was written using PHP.
The OpenGL Stair Renderer is a program that is above to draw a 3D representation of a set of stairs, given the coordinates or the corresponding triangles. This program includes the option of atomatically rotating the stairs for a multimedia display and the ability to change the background image. Art assets must still be created for it and it is capable of displaying any 3D shape. The program was written in C++.
The Bitmap to PDF is a command line driven program that is able to convert images to PDF format. This program interfaces with the free itextsharp library and will convert any given bitmap to a pdf file. This program was written with C#
The Java based prototype of bridge rendering was created to show a 3D representation of bridges. The program was written in Java.
The first program that I created was an Image Viewer. This program loads a set of images that can be scrolled through. It is also possible to print the images and the program automatically resizes the images displayed. This program was written in Visual Basic.
