Diamond State Data Services Database Pages

CV of Frederick W Myers

In the fourteen years since arriving in Australia, my work has been primarily the setup and development of applications for the CA-Ingres database products using both VMS and Unix operating systems. I have been involved with the conversion of a number of traditional applications to the CA-Ingres environment. I, through my firm, Diamond State Data Services, have been a CA-Ingres consulting partner, one of a very small number of such firms in Western Australia.

The strengths which support this position are the ability to quickly and accurately solve problems and master new situations combined with a background in the use of the CA-Ingres tools. The effective use of OpenRoad in a rapid application development has permitted me to create cost-effective business solutions.

The quality of my work can be seen in the long term relationships with clients which have held over a number of contracts (and years). I would like to develop a long-term relationship which would permit a combination of on-site and off-site development, though I understand the nature of workplace visibility.

Educational background:

1975-1977 Masters of Business Administration, Wharton School,
University of Pennsylvania, Philadelphia, PA, USA
1967-1968 no degree, Doctoral program in Chemistry,
Massachusetts Institute of Technology, Cambridge, MA, USA
1963-1967 Bachelor of Arts, Chemistry,
Middlebury College, Middlebury, VT, USA

Employment History

1992-date as/through Diamond State Data Services, contracted for the benefit of the following clients:

Feb 2001- date Western Australia Department of Education and Training , Perth, WA

Provide database administration support (Ingres/Solaris) for the department's Human Resource and student enrollment system, including performance monitoring and tuning.
Create intranet-based (html) system for the retrieval of human resource data from discontinued (archived) systems

Nov 1998- Dec 2000
Oct 2002 - date Alinta Gas, Perth, WA

Support a client(Win2000)/server(Solaris 8) application which collects, reviews and reports the natural gas usage by commercial customers in support of the billing system.

Database administration and support
Review and testing of existing CA-Ingres (Open Ingres 1.2 OpenRoad 3.5/03) application for Year 2000 compliance. Convert to Ingres 2.6 / OpenRoad 4.1.
Design and install an enhancement to provide the ability to report data on a hourly basis and support the reporting requirements under the "Open Access" legislation including reporting to multiple companies using the gas distribution network.
Design and implement the conversion of the gas monitoring system from SAS to CA-Ingres. The system records and verifies approximately 1,000,000 data points per month. Simplify the data verification procedures enabling more time to be spent analyzing the data and ensure strict daily deadlines are met.

Nov 1997- date Diamond State Data Services, Mount Barker, WA

Create the company's web site style, policies and design. The site became public in Feb 1999 and has been expanded from the intitial 3000 pages to more than 25,000 pages as of Oct 2000.

Convert the company's servers from SCO UNIX to Solaris-10 x86/a64
Design and code the CA-Ingres database programs (Ingres II OpenRoad 4.1 / Win2000 including conversion from OR 4.0) used to support the family history data presented on the site.
Implement the web pages as dynamic pages (OpenIngres 2.0 / SCO Unix) on the companies local LAN. Conversion to Ingres 3.0 / Solaris 10 x86 is in progress.

Apr 1996-date As subcontractor to Managment Information Systems (WA), Pty Ltd , Perth, WA

Development of reports for human resources applications with minimal documentation and direction.

Creation and continuing support for five W.A. government agencies with the interface between the clients' Empower payroll/human resources application and the Government Employees Superannuation Board data collection system. Conversion of CA-Ingres script driven system to an ESQL embedded C program in order to permit the creation of an interface file where Oracle databases are used.
One agency received additional support for their splitting of the agency into twelve new reporting divisions. This required the design and implementation of a solution for reporting this information prior to the actual splitting of the payroll system data.

Mar 2000- Mar 2003 Iluka Resources, Perth, WA

Database administration, maintenance and enhancement of the marketing administration system, a data entry and reporting system based on HP Unix and CA-Ingres ABF.

Jul 1996- Apr 1999 Wesfarmers Coal Limited, Collie, WA

Support and consulting for CA-Ingres database administration problems not able to be handled by regular staff (VMS)
Development of local applications which require an interface with Prophecy.
Upgrade of Prophecy from version 1.5 to version 2.0. Assistance in the conversion of supply system to Prophecy.
Assistance in the conversion of CA-Ingres installation from VAX/VMS (Ingres 6.4/06) to Digital UNIX (Open Ingres 1.2), including creation of shell scripts as well as conversion of database application code.
Discussion of financial policy as required to be implemented by Prophecy transactions.

1995-1996 Ingres Solutions Centre, Perth WA

Conversion and implementation of complex financial software (Prophecy) using ABF(UNIX-VMS). Installation of part at vendor main site (Prophecy International) in Adelaide. Conversion of local option code for interface to the WA government accounting system. Teaching of CA-Ingres ABF course.
In the case of the Prophecy software, the applications became part of the then shipping Prophecy Classic product.

Jan-Dec 1995 Government Employees Superannuation Board, Perth WA

System maintenance and minor project implementation using Windows 4GL(UNIX) Define specifications for the revised system interface with the new version of Framemaker (used for printing of complex documents with variable data supplied by the database)

Sep-Dec 1994 Sep-Dec 1993 Apr-Jun 1993 Jul-Nov 1992
Department of Planning & Development, Melbourne VIC (UNIX)

System conversion, maintenance and minor project implementation using ABF and ESQL/C
During the various contracts, I was given the responsibility for the maintenance and enhancements to the "batch processing" modules for the housing system as I was the most proficient in dealing with "C" code. In later contracts the more difficult maintenance requests were "reserved" for me.

Apr-Sep 1994 Computer Software Packages(WA), Perth WA

Development of complex financial software ( Prophecy ) using ABF(VMS). Although the general design was predicated by the user requirements and the general standards required by the vendor, my background in accounting led to many revisions.

Jan-Apr 1994 Brambles-Manford, Perth WA

Design, development and implementation of a replacement General Ledger system using ABF(UNIX).
Completed in nine weeks rather than the budgeted 13.

Aug 1977-Oct 1991 Arabian American Oil Company, Dhahran, Saudi Arabia

1987-1991 Project Leader, system design, development using ABF and ESQL/FORTRAN (VMS) During this period the main system was being prepared for conversion to Ingres. Responsible for development of documentation guidelines and disaster recovery plan as well as coding of many of the system global routines.
1982-1987 System development and maintenance using FORTRAN (VMS) Development and implementation of accounting and billing interface for the shipment of crude oil, including transfer documents and Bills of Lading.
1977-1982 Business systems analyst for the Finance organisation Responsible for the conversion of accounting requirements into requests for implementation by the data processing department. (i.e. no programming- large scale IBM systems)

1972-1977 Delaware Trust Company, Wilmington, DE, USA

1976-1977 Back office system design and development Investments Department
1972-1976 EDP Audit Examiner, Minor development using COBOL (IBM mainframe) Development of the review of the manually maintained CD system which caused a major external review by a Big 8 firm. Maintenance of account selection and verification system. Development of a liability ledger which was passed on to the data processing department for implemenation.

1969-1972 Delaware State College, Dover, DE, USA Director of Computer Center

Design, development and implementation of systems for all record keeping and reporting functions, converting existing manual systems using FORTRAN This was the initial conversion of college records to computers. After my departure a review found that the college was well placed in terms of computer capabilities when compared with colleges of similar size in the area.

Personal Detail

Birthdate: 13 Sep 1946
USA citizen, Permanent Australian residency
Married, one child
EMAIL: fred@dsdata.com.au
Telephone: International(++61) (4) 2887 7116 or within Australia 0428 877 116
Exposure to both the Russian and Spanish languages

 [DSData homepage]
 [DSData genealogy]
 [DSData olives]