Home | Professional | Travel | Links  
Home
PGP Public Key
ICQ
Professional
Resume
Travel
Thailand
London
USA
Links

Travel

Gregory D. Hawkes
Professional Resume (November 2001)

Address: PO Box 2716, Melbourne VIC 3001, Australia
E-mail: rivergum@iname.com
Passport: Australian (Valid until February 2007)

Education

1985 Bachelor of Engineering (Electronics)
Ballarat College of Advanced Education (now University of Ballarat), Ballarat, Australia:
  • Received 1983 Josephine Brelaz Scholarship for outstanding performance in electronic engineering
  • Final year thesis: Local area networks, including review of OSI model and development of simple network hardware and software
1980 Higher School Certificate
Ballarat East High School (now Ballarat Secondary College, East Campus), Ballarat, Australia:
  • Passes in English, Pure and Applied Mathematics, Physics, and Chemistry

Training

Feb 1995 Training course: Upgrading to Microsoft Windows NT v3.5
Introduced experienced Windows NT operators and developers to the latest version of Windows NT.
Aug 1994 Training course: Operating Microsoft SQL Server v4.21
Installing, operating, and maintaining a SQL Server database installation.
Mar 1994 Training course: Managing Ingres Databases
Including installation, configuration and tuning, and using Ingres to manage distributed databases.
Jan-Feb 1991 Short course: Database Technology, Chisholm Institute of Technology
Including objectives of database technology, entity-relationship modelling, normalisation, relational databases, relational algebra, introduction to SQL, and hands-on experience with Oracle DBMS.
Jul-Oct 1989 Short course: Advanced C Programming, Chisholm Institute of Technology
Including data-driven programming, exception handling, file processing, advanced data structures, structuring large applications, abstract data types, generic functions, and encapsulation.

Industry Certification

Microsoft Certified Solution Developer

31 August 2001 Microsoft exam 70-176
Designing and Implementing Desktop Applications with Microsoft Visual Basic 6.0
17 August 2001 Microsoft exam 70-175
Designing and Implementing Distributed Applications with Microsoft Visual Basic 6.0
2 April 2001 Microsoft exam 70-100
Analysing Requirements and Defining Solutions Architectures
9 March 2001 Microsoft exam 70-029
Designing and Implementing Databases with Microsoft SQL Server 7.0

Work Experience

June 1993-present

Oakton Computing Pty. Ltd.
Senior Analyst/Programmer
Oakton are a consulting firm based in Hawthorn, in Melbourne, Australia. Since joining the company I have worked on projects for various clients, including:

Nov 2001-Present

BP Australia
Analyst/Programmer
Implemented a data warehouse and generated reports for BP's financials software. The warehouse was implemented using Oracle 8i:
  • Implemented data extract-transform-load using Informatica's PowerCenter/PowerMart software.
  • Implemented reports using Business Objects.

Dec 2000-Oct 2001

Telstra
Analyst/Programmer
I joined a team developing the Customer Product Inventory project. This application was written in Java, and used EJB's and an Oracle database to extend the functionality of a DB2 database running on a mainframe system. The project used IBM's Visual Age for Java development environment, running on NT workstations:
  • Designed object hierarchies, using Rational Rose software to create Unified Modelling Language diagrams.
  • Implemented object hierarchies to represent customer sales orders and maintenance service orders.

I later joined the team developing Telstra's new Internet Call Cost Calculator tool:

  • Designed an object hierarchy of extensible Java servlets to generate the user interface.
  • Implemented Java servlets to create prototype user interface for the Internet Call Cost Calculator tool.

Nov 2000

BP Australia
Analyst/Programmer

Developed a pilot project to test the feasibility of integrating  BusinessObjects "WebIntelligence" web interface, with the "Genesys" architecture adopted by BP worldwide, running on the IBM WebSphere application server.

  • Designed installation and configuration procedures for the IBM WebSphere application server
  • Designed installation and configuration procedures for the BusinessObjects "WebIntelligence" web interface
  • Developed libraries of Java classes to adapt WebIntelligence to the Genesys architecture

Dec 1999-Sep 2000

Telstra
Analyst/Programmer
Developed and maintained the SORD (Sydney Olympics Records Database) application.  This is a multi-tier application, in which a web-based front end communicates with an Oracle Server back end, via Microsoft COM objects within the Microsoft Transaction Server environment.

Developed and maintained the Soroban application. This tool is used by front-of-house staff to quickly evaluate various pricing plans whenever customers enquire about cheaper phone bills. This tool uses a web-based front end and communicates with Telstra's mainframe and a SQL Server database using Microsoft COM objects within the Microsoft Transaction Server Environment.

Apr 1999-Dec 1999

Deakin University
Reporting Team Leader
Deakin University implemented a software system to manage the University's operations, and to replace the existing, non-Y2K-compliant, system. I was part of the implementation project, leading a team of up to six developers to provide various reports.
  • Developed various reports using Oracle Report Writer v2.5 and Oracle Forms 4.5
  • Configured Oracle's Discoverer software to generate ad hoc reports from the database
  • Managed distribution of user requests for ad hoc reports to developers

Feb 1998-Apr 1999

BP (Bitumen) Australia
Development Team Leader
BP's Bitumen business unit redeveloped their management systems, to make them Y2K-compliant and to streamline the business processes. My team created an application to provide for entry and tracking of orders, generating delivery dockets, and issuing customer invoices. It automatically maintained inventory levels, managed manufacturing processes, and generated reports from the operational data. The system transmitted accounting information to BP's Oracle Financials system.

I led a development team of up to six programmers, creating a web-based application based on the Oracle DBMS using Oracle's WebServer web interface. The application was designed as a user-friendly front-end for BP's Oracle Financials system.

  • Designed the Bitumen Operational System database using Oracle v7
  • Designed user interface and created mock-ups using Microsoft's FrontPage 98
  • Coordinated a team of up to six programmers as they developed the application
  • Designed data warehouse database and reports

Nov 1996-Jan 1998

BP Australia
Intranet Webmaster
BP are developing a global intranet to provide all staff with access to procedures, manuals, standards, and other documentation spread around the world. They are positioning the company to take advantage of Internet technology for communication both within BP and around the world.

I was the Australasian Webmaster for this intranet. The Australasian server maintains content developed for Australia, New Zealand, Papua New Guinea, and Fiji.

  • Responsible for day-to-day operation and maintenance of BP's Australasian intranet server, using Microsoft Internet Information Server v3.0 on a Compaq Prolinea running Microsoft Windows NT v4.0
  • Designed and implemented web pages using Microsoft FrontPage 97
  • Liaised with members of various departments to determine their development requirements
  • Designed and conducted introductory courses in Microsoft FrontPage 97 and the BP intranet publishing model
  • Represented Australian interests at BP Group web developers' conference, held in London 5-6 November 1997

Aug-Oct 1997

BP Australia
Technical Coordinator
BP Australia installed a local gateway to the Internet, to service the Australasian (Australia, New Zealand, Fiji, and Papua New Guinea) region. I was technical coordinator for the Australasian Internet gateway project.
  • Liaised with various technical teams within BP's IT department to ascertain requirements and investigate standards
  • Developed functional and technical specifications for Australasian Internet gateway
  • Coordinated installation and commissioning of Internet gateway hardware and software

Sep 1995-Nov 1996

OneLink Transit Systems
Application Developer
This company is responsible for the installation of the automatic ticketing system for the Melbourne public transport system.

I was responsible for development of the "Equipment Help Desk." This system receives fault and status notifications from ticketing equipment installed all over the city. It directs the operator to contact the appropriate maintenance contractor, and monitors the progress of the fault repair. It tracks the locations of spare parts, and stores availability data for each item of equipment.

  • Designed and implemented the Equipment Help Desk database, using SQL Server v6.0
  • Developed user interface applications for this database, using Visual Basic v3.0. These applications direct the different operators through the procedures for contacting the appropriate maintenance contractor, and monitoring the progress of each fault repair
  • Developed various reports, using Crystal Reports v4.0
  • Developed a Windows NT Service using C, to fetch fault notifications from a network socket and insert the data into the database using ODBC routines
  • Oversaw development of other modules by graduate programmers

I was also responsible for development of the "Performance Reporting System". This is an extension of the Equipment Help Desk. It determines how much time the automatic ticketing equipment was fully operational, compared to the time the equipment had a fault condition. It extracts the history of fault reports from the Equipment Help Desk database and calculated the performance of the equipment using the rules specified by OneLink. From this performance it calculates penalties and bonus payments applicable to OneLink for each financial period.

  • Designed and implemented the Performance Reporting System database, using SQL Server v6.0
  • Developed user interface applications for this database, using Visual Basic v3.0
  • Developed various reports, using Crystal Reports v4.0

Jul 1995-Apr 1996

Victorian Electoral Commission
Application Developer
The Victorian Electoral Commission (VEC) is responsible for the conduct of state elections, including collection of votes and distribution of results to the media. They had a PC-based application that collated votes at their returning offices. They required an application for their Sun workstations to capture this data and store it in an Ingres database.

This project involved very careful database design and tuning. The incoming files can update up to a thousand rows each; during election night about nine hundred such files will be received. This data must be processed and aggregated to calculate results for each candidate, electorate, and polling booth. At the same time the media and tally room reports fetch these results.

The state election was held on 30 March, 1996. On the night I was responsible for monitoring the vote processing software and responding to queries from the VEC Help Desk. I am pleased to say that all software functioned perfectly, and the disaster recovery plan was unnecessary.

All applications were developed in C, Ingres ABF, or Ingres Report Writer on a Sun Sparcstation 20.

  • Developed applications in C to:
    • capture incoming data files and store the votes in the database;
    • print up-to-date results to large (A3) pages to be posted to the tally board on election night;
    • regularly extract results for transmission to various media groups, and;
    • monitor the performance of incoming phone lines, and the progress of vote processing
  • Developed a new Ingres ABF application to provide manual data entry of vote results, as part of the disaster recovery plan
  • Maintained existing large Ingres ABF applications to manage election data

Apr 1995-Jul 1995

BP Australia
Application Developer
BP had developed an MIS application that downloaded departmental data from an Oracle database and loaded it into an SQL Server database. They needed someone to improve the response times of this application, and to perform additional development.

These applications were developed in Visual Basic, using SQL Server as the back-end database.

  • Maintained and extended MIS reporting application
  • Optimised the SQL Server database to improve performance. Redesigned table indexes and application queries to reduce execution times

Feb 1995-Apr 1995

Shell Australia
Procedure Writer
Shell had decided to standardise on SQL Server v4.21 as a departmental database. Before beginning serious development work they wanted to establish a set of standards and guidelines for developers.

This project did not involve software development. Instead, I discussed Shell's requirements with their development staff. The resulting documents were intended to assist workstation and mainframe operators and developers to make the switch to SQL Server.

The documents were written using Microsoft Word.

  • Developed a set of standards for developing applications using the SQL Server database
  • Developed a set of procedures for day-to-day maintenance and disaster recovery of SQL Server databases

Jun 1993-Feb 1995

Rural Water Corporation
Application Developer
This client used HP-Apollo 900/720 workstations running the Ingres DBMS and the X Window System to manage the allocation of irrigation water around Victoria. This was an extensive development that made full use of the features of Ingres. Farmers could telephone the RWC and order irrigation water using a fully automated voice-response system that interfaced to the database. Orders were propagated to the irrigation flow manager.

My development work was in C, using embedded SQL to access the Ingres database. It used the Sherrill-Lubinski Graphical Management System (SL-GMS) product to display the graphical interface to the user.

  • Developed a graphical irrigation network editor. This module formed the user's interface to the database to create and edit the irrigation network
  • Developed an irrigation flow manager. This module accepted order information from the database and displayed the requests graphically against the network. It calculated the volume of water flowing through channels and highlighted over- and under-capacity. It calculated pressure losses in pipes and highlighted low-pressure regions. The user could rearrange the orders to satisfy these restrictions
  • Developed a set of libraries upon which all other applications were built
  • Wrote user manuals for these and other applications using WordPerfect for the HP/720
  • Supported the DBA in day-to-day maintenance and backup of the Ingres database

1985-June 1993

Engsoft Computer and Engineering Consultants
Senior Software Engineer
Engsoft are a small (less than ten employees) company based in South Melbourne, Australia. They tapped a highly specialised niche market, developing and selling software tools for use by civil and structural engineers. The software was originally developed for IBM PC's; later it was ported to Sun 3 and IBM RS/6000 workstations.

In such a small company I gained experience in a variety of tasks.

  • Developed applications in C and C++ for IBM PC, IBM RS/6000, and Sun 3 computers. Developed major modules for suite of structural software, including a 3-D CAD program. Developed suite of libraries upon which all Engsoft's application software was built
  • Responsible for porting software from PC's to Unix workstations. Created user interfaces for the X Window System using Motif tools on Unix workstations. Established and maintained an NFS network so that all development machines shared the same source files
  • Established programming conventions used to ensure all modules could be compiled on multiple platforms
  • Used Borland C++ and Zortech C++ on PCs, and GNU and native compilers on Unix workstations for all software development
  • Oversaw development of other modules. Supervised structural engineers as they developed discipline-specific applications
  • Responsible for production of technical manuals, from page layout and typography to proofreading of finished product. Wrote manuals for several application modules, using WordPerfect and Ventura Publisher
  • Provided telephone and on-site technical support for Engsoft's customers
  • Responsible for day-to-day operation, maintenance, and backup of Sun 3, IBM RS/6000, and NEC Astra XL/8 workstations, and various IBM PC's all connected by NFS network
  • In May-December 1987 made several trips to Singapore, Thailand, Indonesia, Philippines, and Malaysia to install and conduct training courses for microelectronics design software developed by RMIT and University of NSW
  • Developed dBase IV application to manage Engsoft's client database, including update and maintenance schedules

1984-1985

Engsoft Computer and Engineering Consultants
(Part-time) Software Engineer
During the final year of my engineering degree I worked part-time for Engsoft.
  • Installed hardware and software at client's premises. Modified circuit boards and made interface cables. Assisted in production of application software
  • Developed dBase III+ application to manage client's manufacturing inventory
  • Developed and conducted training courses in AutoCAD and Ventura Publisher

1983-1984

Ballarat Electronics Supplies
(Part-time) Quality Control Inspector
Ballarat Electronics Supplies provides electronic components to the Ballarat area. They design and manufacture a range of battery chargers and 24-to-12 volt truck power converters, and assemble circuit boards.
  • Examined and tested circuit boards and power supply units assembled by production staff
  • Designed 24-to-12 volt converter for production

References

References are available upon request.

Other Interests

Have been an electronics enthusiast for a long time. Assembled a Z80 CP/M computer from scratch. Enjoy alpine and nordic skiing, camping and hiking, rock climbing, in-line skating, golf, squash, and general fitness.
Last updated Sunday, 18 November 2001
Copyright © 1995-2001 by Gregory D. Hawkes <rivergum@iname.com>. All rights reserved.
1