Home Professional Travel Links
PGP Public Key
ICQ
Professional
Travel
Thailand
London
USA
Travel
Gregory D. Hawkes
Professional Resume (November 2001)
Address: PO Box 2716, Melbourne VIC 3001, Australia
E-mail: abo0pp@r.postjobfree.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-presentOakton 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-PresentBP AustraliaAnalyst/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 2001Telstra
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 2000BP AustraliaAnalyst/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 2000Telstra
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 1999Deakin UniversityReporting 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 1999BP (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 1998BP 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 1997BP AustraliaTechnical 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 1996OneLink Transit SystemsApplication 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 1996Victorian Electoral CommissionApplication 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 1995BP AustraliaApplication 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 1995Shell AustraliaProcedure 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 1995Rural Water CorporationApplication 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-1984Ballarat 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 c 1995-2001 by Gregory D. Hawkes . All rights reserved