title>1989 - 1994

February 1989 - June 1994

Reported to: Manager
Computer Support Services
Telecom Network Engineering
171 Roma St
Brisbane
Queensland
Australia
Phone: +61 (7) 3837 5172
Responsibilities: Undertake as directed novel or complex assignments:
  • Research and studies of an advanced or pioneering nature into specific areas or functions relevant to communications and information processing.
  • For national and regional TNE systems, participate in, provide consultation and oversight various aspects of the system development life cycle.
  • Provide high level consultancy and support to client areas within TNE.
  • Participate in the formulation and implementation of information system strategies
  • Ensure all developments are in accordance with national standards.
  • Data and requirements' analysis of significant business areas in Telecom
  • Provide necessary day to day maintenance and support to ensure access to all applications and their associated data.

Major Projects:

June 1993 - June 1994: Site Information System (SIS)

Reported to: Anton Lane/Joe Catalano
System Project Manager/s
Brisbane
Queensland
Australia
Phone: +61 (7) 3837 9291
Description The SIS application provides a recording and reporting tool that allows Telecom Australia to manage the three billion dollar network transformation scheme known as Future Mode of Operation. It is anticipated that SIS will soon be used by all areas of Telecom as the preferred repository of network planning data.
Responsibilities:
  • System Design
  • Implementation Strategy
Environment: Initial Prototype (June 1993 - December 1993)
  • HP-835 running HP-UX 7
  • Oracle version 6 DBMS
  • Uniface version 5.1.e (character mode interface).
Server: Final system (December 1993 - present) is a client-server architecture
  • HP G50 running HP-UX 9
  • Oracle version 7 DBMS
Client:
  • IBM 386 clones running Windows3.1
  • Uniface version 5.2.f2
  • The communications between clients and server is provided by the Uniface PolyServer Product using the TCP/IP protocol.
Achievements:
  • Fast track methodology allowed the system to be developed in a period of four weeks. The working prototype comprised over 90 forms.
  • Designed the interfaces between SIS and other internal Telecom Information Systems. These interfaces were written using SQL*Loader and SQL*Plus scripts.
  • Benchmarked the relevant efficiencies of PolyServer versus SQL*Net whilst finalizing the client-server architecture.
  • Ported the product from Uniface version 5.1 with a version 6 Oracle DBMS to Uniface version 5.2f using an Oracle 7 DBMS.
  • Designed and implemented a batch processing system to allow reports and various Unix processes to be triggered from the client.
  • Responsible for the creation of all necessary Unix and Oracle scripts to support the application.

January 1993 - May 1993: Maintenance Phase

Reported to: Manager,
Computer Support Services.
Brisbane
Queensland
Australia
Phone: +61 (7) 3837 5172
Responsibilities: Maintained the Spectre, Casper and Radiopro applications using the following products
  • Oracle DBA,
  • SQL*Plus
  • Report*Writer
  • Uniface
Environment:
  • HP-835 running HP-UX 7
  • Oracle version 6 DBMS
  • Uniface version 5.1.e (character mode interface).
Achievements:
  • Provided analysis and design skills to several sections in the regions.
  • Produced tender for Uniface application to manage trunk radio systems and installations within Papua New Guinea.
  • Modified existing interface scripts to cope with changes in source Telecom Databases.
  • Produced small Uniface application to manage the Network Rearrangement until the Site Information System (SIS) came on-line.

April 1992 - December 1992: SATCC Project

Reported to: Manager,
Computer Support Services.
Brisbane
Queensland
Australia
Phone: +61 (7) 3837 5172
Responsibilities: To Design and Implement a system for SATCC (Southern Africa Transport and Communication Commission) that provided the following functionality:
  1. Licensing and Billing
  2. Frequency Assignments
  3. Frequency Allocations
  4. Frequency Allotments
  5. Equipment Approvals
  6. Provide training to the users of the system
Environment:
  • Amstrad 486SX IBM Clones running Windows 3.1
  • Uniface version 5.2d
  • DBase3 files were used to store the data
Achievements:
  • Produced the system as required
  • Provided the training (in Mozambique) to delegates from the 10 countries that are implementing the system

February 1991 - March 1992: Spectre, Casper and Radiopro Applications

Reported to: Manager,
Computer Support Services.
Brisbane
Queensland
Australia
Phone: +61 (7) 3837 5172
Description: The System Owner: John Hack +61 (7) 3837 4291
  • These three systems allowed the various Design Sections to track documents relating to the construction and design details for all equipment within Queensland south of Rockhampton. The yearly budget for this area of Queensland was in excess of $4 million per annum.
  • Spectre was initially implemented for the Transmission Design Section and proved so popular that the Switching Design and Customer Radio sections requested that Spectre be modified to handle their unique requirements.
  • Replacing the manual systems previously used allowed more precise tracking and scheduling of the necessary construction projects within each section and between the relevant sections.
Responsibilities:
  • System Analysis
  • Design
  • Implementation.
  • Maintenance
Environment:
  • HP-9000/835 running HP-UX 7
  • Oracle version 6 DBMS
  • Uniface version 5.1.e
Achievements: Analysis, Design and Implementation of:
  • Spectre
  • Casper
  • Radiopro

February 1989 - August 1992: Interface Design

Reported to: Manager,
Computer Support Services.
Brisbane
Queensland
Australia
Phone: +61 (7) 3837 5172
Responsibilities:
  • System Analysis
  • Design
  • Implementation.
  • Maintenance
Environment:
  • HP-9000/835 running HP-UX 7
  • Oracle version 6 DBMS
  • Uniface version 5.1.e
Achievements:
  • Designed and implemented various interfaces to extract data from Telecoms' mainframe Addabas Natural databases.
  • This data supported Spectre, Casper and Radiopro.
  • Provided ad hoc reporting to other sections within Telecom.
  • Extensive experience gained in the use of the Oracle Case toolkit to carry out Entity Relationship modeling and functional analysis of the requirements of the Trunk Network Engineering section of Telecom Australia.