Webmaster for Ardis Books website, maintaining online books database and managing data migration to Amazon, ABE and eBay data formats.

Responsible for Technical Design Review of the Oracle based SEEBOARD Electricity Distribution Billing System running under Unix, billing around £20m per month. Specification of changes to the design of the Physical Database (on Designer 2000) to solve current performance problems caused by 200 million row table. Risk Analysis and Cost/Benefit comparison for implementing the changes, and a costed management plan and outline design. Assistance to the current support team in implementing these changes.

Troubleshooting current system implementation, including tracking down billing problems arising from errors in the data and process design.

DATA MANAGEMENT of a Corporate Logical Data Model on ORACLE DESIGNER 2000 V2.1.2, which contains all Tri-Service Pay and Personnel information. Analysis, design and RAPID PROTOTYPING using ORACLE7, FORMS 4.5 and REPORTS 2.3 of a bespoke mapping tool to cross-reference flat legacy data files to DESIGNER 2000 metadata, for DATA MIGRATION of legacy system data and to support new project databases and the development of a Tri-Service MIS. Production of sub-system specifications usign WORD97 and EXCEL97 under Windows NT.

Technical team leading of two staff in the Analysis and Design using ORACLE DESIGNER 2000 and ORACLE8 of a Reference Data Management System to support the centralised recording and distribution of static reference data to the many pay and manpower systems that require it. Interface to a MICROSOFT ACCESS database under Windows NT.

Setting to Work of a DATA WAREHOUSE application to store historic data for the Royal Navy. This was hosted on a UNIX platform using an INFORMIX database. Data was captured in a conventional database, and then transferred to a DATAMART view based on a star schema design which was used for MIS query access. Setting to Work involved intensive reworking of complex, undocumented SQL code. Use of UNIX (HP-UX) and VI to build C shells.

Development of data models on SSADM ENGINEER to support proposed Navy pay and personnel systems, including all aspects of pay, pensions and ledger accounting. Merging of these models with similar Army and RAF models into a single model developed on ORACLE DESIGNER 2000.

Concept Study for a central database to hold strategic data for the Navy and interact with existing legacy systems. Identification of Business System Options taking into account cost/benefits, and physical considerations such as referential integrity and timeliness.

Data Analysis of corporate reference data, followed by Analysis, Design and Development of required upload, maintenance and download processes in PL/SQL, FORMS 4, REPORTS 2 documented in WORD V6.0 specifications and interfacing to a MICROSOFT ACCESS database. Design of ORACLE database tables using CASE*DICTIONARY and CASE*DESIGNER. Data Manipulation using EXCEL V4, and loading using SQL*LOADER. Interrogation and manipulation of tables using SQLPLUS. Manipulation of flat data files using UNIX (HP-UX) on a SEQUENT computer with the VI editor.

Development using YOURDON of a Combat System Physical Model on TEAMWORK SA, RT and IM. Requirements Engineering and tracing using the ORACLE based Requirements Traceability Manager (RTM) and TEAMWORK. Data maintenance using ORACLE FORMS 3. Development of a Data Model of the entire Combat System to help define the detailed interface specifications.

Integration of TEAMWORK outputs into system specification documents using POSTSCRIPT, VAX DCL software and VISUAL BASIC to convert TEAMWORK outputs to a form suitable for WORD. Performance Analysis of processing threads using TEAMWORK SIM.

System Management of a client/server VAX cluster using VMS and OPEN VMS, and part-time ORACLE DBA. Advice to MOD on contractor use of CASE tools including persuading the Project Manager to drop the MOD-sponsored IME in favour of the commercially available TEAMWORK.

Design of the method for integrating the IPSYS HOOD (Hierarchical Object Oriented Design) toolset into the Eurofighter IPSE, a large VAX ADA suite for the configuration management of the Eurofighter software. Production of detailed formal specification, design and test documents, followed by assistance and supervision of two other staff in the implementation of the design.

Prototyping of the IPSE method on part of the proposed Type 23 Command System including analysis of existing documentation and interviewing Combat System experts. The Information Model (on AUTOMATE) was integrated with a VAX ORACLE data dictionary, a Process Model (using YOURDON on TEAMWORK), and OOD on a Sun Workstation.

Assistance in defining an Event List and Data Flow Diagrams cross referenced to the Information Model, and defining objects, classes, methods, high level objects and subsystems in OOD. Coding part of the system in ADA. Creation of method support tools using PRO FORTRAN and SQLPLUS to communicate with the VAX ORACLE data dictionary, REPORTWRITER to generate query reports, and ADA on an IBM AT compatible to process Automate Plus files.

Software management of the SEALECT Through Life Costing package hosted on a RAIR and written using FORTRAN and KNOWLEDGEMAN downloading to a PRIME 2655 mini computer for performing simulations. Configuration control and documentation using SSADM.

Project Management of several projects using SSADM, implemented in VAX FORTRAN and C, managing teams of three or four people, all completed under budget and meeting specifications.