Bernard Bennetto's Curriculum Vitae
Assigment List - 1985 to Present
6..95 to 11.95 - 3S Intl Ltd - Systems Development - Analyst/Programmer
Analysis, design and development of a prototype to demonstrate the potential of a PFMS (public facing multi-media system) application using a GUI database application for a national video and game rental chain. The chain is currently using DOS xBase products.
A paramount criteria in GUI design was the engineering of usability so that it could be used by a casual, untrained customer.
IBM PC based Token Ring Network with WFWG, Powerbuilder and Watcom SQL
6..95 to 8.95 - T2 Ltd - Systems Development - Usability Engineering
Development of a GOMS based method for the formalised measurement and comparison of the learnability and the flexibility of the Apple Macintosh and the Microsoft Windows 3.1 graphical user interfaces and PFMSs.
GOMS, Apple Macintosh and Microsoft Windows 3.1
7.94 to 11.94 - T2 Ltd - Training - Technical Author
The development of both a formally presented and a tutorial based Powerbuilder training programme for environments which are client server, object and relational database oriented. It was pragmatically based on experienced gained in the development of a system for supporting equipment rental.
IBM PC based Token Ring Network with WFWG, Powerbuilder/Powermaker , Watcom SQL and dBase files.
11.93 to 2.94 - UPS, London - Distribution - Analyst/Programmer
Richmond on Thames
The design of an object oriented application involving the use of RAD tools (GUI/Windows based prototype using LAN client-server 4GL and relational database) for the development of a system to pre-alert sites of parcel deliveries. The application was to provide for enquiry on data locally updated data which had been downloaded from large central mainframe based DB2 databases.
IBM summit mainframes with MVS/ESA, CICS and DB2 and Watcom SQL and Powersoft products
9.93 to 10.93 - Borough of Lewisham - Local Authority - Consultant
A further assignment for Lewisham to provide independent advice on the supplier recommended procurement of an ICL Unix DRS 6000 based DIP system and upgrades to an ICL Series 39 system to run Document Capture and Retrieval and Housing Benefits Systems. This study also involved establishing the downgrading implications for their IBM compatible VM/VSE Comparex system.
ICL DRS 6000 w Unix, ICL Series 39 w VME, TPMS, IDMS and AM, Comparex w VM/VSE
10.92 to 2.93 - Royal Borough of Windsor & Maidenhead - Local Authority - Consultant
Contribution as technical consultant, with experience of IBM mainframes and DB2, to an IT Strategy Review. Essential element of future strategy was seen to be the use of client/server architectures with the use of GUI products such as those available from Gupta, Blyth and Admiral so as to make mainframe data available in a more local and user-friendly context. Detailed study of facilities offered by SQL*Windows, Omnis and Powerbuilder undertaken.
Hitachi EX50 w. MVS/ESA, CICs and DB2, Gupta SQL*Windows, Omnis and Powerbuilder
7.92 to 9.92 - NIG Skandia - Insurance - Consultant
Preparation of a report identifying problems of IT operation. The report covered the appropriateness of current hw and sw (IBM 9021/330 running MVS/ESA w IDEAL/DATACOM and CICS) and the current organisation structure, methods, procedures and tools employed. New software strategies, cost effective hardware upgrade options and revised organisation structure were recommended.
IBM 9021/330 w. MVS/ESA, CICS and IDEAL/DATACOM
5.92 to 6.92 - London Borough of Lewisham - Local Authority - Consultant
A subsequent assignment for Lewisham in 1992 to provide independent advice on the supplier recommended upgrade to an ICL Series 39 system (to run Council Tax and related systems).
ICL Series 39 w VME, TPMS, IDMS and AM
3.92 to 4.92 - Southampton City Council - Local Authority - Consultant
The preparation of a report for Southampton City Council identifying and recommending tuning options and/or an appropriate upgrade option for an IBM 3090/180 VM/VSE installation. Problems were caused by loads imposed by a VSAM based Community Charge System and a shortage of processing capacity.
IBM 3090/180 w VM/VSE, CICS and VSAM, PC Based Analysis
9.91 to Present - Suffolk College - Higher Education - Lecturer, Consultant & Tech Support
For CCU, the re-establishment, within a PC based Windows and ultimately Unix environment, of Powerbuilder/Powermaker, Watcom SQL and Gupta's SQL*Base (1.95 - 6.95).
486 & P5s w. DOS 6, Windows 3.1, SCO Unix, Gupta SQL*Base, Watcom SQL & Powersoft
For CCPU, the evaluation of a variety of 'open' solutions for the support of modular degree student tracking. This involved a survey of the wisdom of in-house developments as opposed to 'packaged' solutions. Target hardware/software for the solution involved an IBM RS6000 with AIX, Oracle and Uniface (2.94 - 5.94).
IBM RS 6000 w AIX v 3.2, Oracle v 7 and Uniface and PCs w Polyserver/DOS/Windows/Termite
For ISE, the selection, evaluation, testing, justification and procurement of a 4GL. This involved the customised development of a PC based Windows prototype using Powerbuilder and Gupta's SQL*Base as RAD tools for an application which provided GUI based maintenance and interrogation of database records and progressive, two way candidate matching (5.93 - 12.93).
IBM Compatible 486 w. DOS 5, Windows 3.1, Gupta SQL*Base and Powerbuilder
The development and presentation of courses on Human Factors, Software Engineering, Development Methodologies, Software Quality, Formal Methods using Z and Relational Database Technology.
SSADM, Prince, Z, Gupta SQL*Base, Powerbuilder, Unix and Windows NT, Novell and LAN Manager. PC products included Wordstar, Symphony, Supercalc, Paradox, xBase, Sage and Applause
2.90 to 4.90 - London Borough of Lewisham - Local Authority - Consultant
The preparation of recommendations concerning the need for upgrades to a dual machine (IBM 4300 and Comparex), shared DASD installation within a London Borough Council - Lewisham. This involved the collection of data for a capacity planning exercise and the use of analytical modelling to predict an appropriate upgrade.
IBM 4300 and Comparex w VM/VSE, CICS and VSAM, PC Based Exercise using Capacity Q
12.88 to 6.91 - BACS - Electronic Funds Transfer - Performance Modelling Consultant
My duties involved modelling the ICL Series 39 configuration requirements (CPUs, Disks, Cartridge Tape, Open Reel Tape and Memory) for and predicting the response times and batch elapsed times of online, batch, dump and recovery processes of a major replacement electronic funds transfer system using an IDMS database.
The duties involved the identification of significantly long running processes through benchmarking and liaison with the development design staff to provide COBOL source code and modelling input so as to predict of the CPU overheads and the conventional and physical I/Os involved in selected processes. Modelling used a mixture of VCSR, analytical and spreadsheet based techniques. The work involved use of the ICL Data Dictionary, holding variants of BIS metadata, to provide additional methodological data for modelling. The duties also involved project planning using PMW,
Other exercises included the 'baseline' modelling of VCSR's predictive capabilities, evaluation of alternative modelling products (Athene, Capacity Q, SCERT) for modelling ICL and Tandem systems.
I was also required to negotiate, establish and implement SLAs for the development configurations - defining a system for the translation of information on mainframe component utilisation into a form where it could be used as a basis for chargeout and analysing workload data so that it might be used as a basis for budgeting future computer charges.
ICL Series 39 w VME, TPMS, IDMS and AM, PC Based Modelling Packages and dBase Analysis
12.89 to 8.90 VHI - Medical Insurance - Data Warehousing Consultant
Abbey Street, Dublin
An assignment, involving an IEF based BAA data analysis review and the design of an Oracle database, running on VAX equipment to support a data warehousing MIS system, for the Irish health insurance company, VHI. With IEF running on a PC, the study required advising on what data would be warehoused, the performance implication for loading and maintenance, the meta data that should be stored within the IEF system. It also required training staff in its practical use and recommending what additional ORACLE based tools would be needed to overcome IEF shortcomings.
The work also involved performance prediction of the response times and batch elapsed times of online, batch, dump and recovery processes of MIS warehouse enquiries using alternative Oracles design strategies. The duties involved project planning, acquisition of modelling input, prediction of the conventional and physical I/Os and the identification of critical SQL queries. It involved spreadsheet based modelling techniques. The work involved use of IEF and the Oracle Meta-Data Dictionary to provide the methodological data for modelling.
The design involved surveying all planned applications and existing conventional files for potential data warehousing requirements and their data sources, constructing a corporate data model to resolve inconsistencies, mapping the data model for the warehouse to an 'efficient' set of Oracle tables, determining 'indexes', devising initial load and data maintenance strategies, predicting the principal elapsed run times for loads, updates and typical SQL enquiries, determining mass storage storage occupancy and constructing a plan for the database implementation. The exercise involved supervision of two additional consultants and teaching the VHI database administration staff how they might independently undertake a subsequent exercise.
6.88 to 10.88 - SPS Education - Lecturer and Technical Author
In view of a knowledge of performance issues and database issues, a commission to prepare a number of courses. These included a 3 day DB2 Internals course which covered the DB2 elements, the various SYS structures and their contents and purposes, relationships to VSAM, data and index page contents and structures, row and data type formats, row insertion and overflow procedures, index maintenance procedures, DDL and DCL, static and dynamic SQL, privileges, threads, binds and access path selection and the optimizer.
A second course involved a practical PC based training programme for performance modelling analysts in statstics techniques used in the monitoring, forecasting and presentation of data on computer performance.
4.87 to 5.88 - Morgan Grenfell - Merchant Banking - Perf Mgt & Capacity Planning Manager
Tabernacle St, London EC2
I assumed responsibility for the development of a section consisting of five people to carry out formal performance monitoring and capacity planning across ICL, Tandem, IBM and Stratus hardware. This also involved the development of service level agreements, software, standards and procedures. Specific duties undertaken or supervised during this period were:.
- the evaluation and selection of various analytical modelling packages
- the introduction and use of Capacity Q for modelling Tandem, IBM 4300 and Stratus machines
- procurement negotiations concerning suitable component upgrades with suppliers
- the specification of ITTs containing procurement requirements for suppliers.
- the initiation of management oriented, regular machine performance monitoring reports
- periodic capacity planning for systems reaching bottlenecks
These duties were undertaken across Tandem, IBM 4300 running VM, Stratus, ICL Series 39 and IBM 3090 running MVS.
The duties required the creation of a common, central IBM PC-based network of micros communicating with the bank's minis and mainframes. The system exploited the 'relational database' type capabilities of dBase III+ running on a network of PCs. This automatically interfaced with mainframe software (via Automator Mi) and built a performance database which was used to produce monthly graphical reports (via Logistix and Freelance) on mainframe performance.
11.84 to 2.87 - CCTA - Government Computer Agency - Internal Consultant
Riverwalk House, London
I returned to England to act as an internal consultant for government departments (notably the Department of Transport, Department of the Environment and Ministry of Defence). Projects were undertaken on IT strategy, system performance, database design, hardware/software selection and hardware procurement. These studies involved the preparation and collection of data for inclusion in Feasibility Studies, Full Study Reports and Operational Requirements. These assignments involved substantial and constant involvement with both the SSADM and PROMPT/PRINCE methodologies. I was normally vetted for the purpose of these assignments.
Specific projects are outlined below.
- A review of progress in the establishment of an IT strategy for the ICL systems at the Personnel Centre at RAF Innsworth. This involved the formation of a 'command' team (to control teams of some 50 staff), the supporting infrastructure for the collection and analysis of data, the establishment and justification of an appropriate strategy in the light of architectural and resource constraints and the formal presentation of the strategy to senior RAF personnel.
- An IT strategy and quality assurance review on the organisational, configuration, hardware/software, progress, planning and resource issues of a system for the support of the Vehicle Inspectorate, Bristol. This was conducted with a staff of some 6 to 12 people in the light of the completion a DTp wide strategy to cover Driver, Vehicle and Operator systems.
- The leadership of a team of DVLC system development personnel in the analysis and design of a DL/1 database for the support of an operational Vehicle Inspectorate database. The 2 gbyte DL/1 database was designed to support the annual testing and inspection of all heavy goods vehicles and public service vehicles by the Vehicle Inspectorate in Bristol. A major design criteria was to preserve upwards compatibility with relational database software (potentially Model 204 or DB2) and a comparision of the relative performance of the DL/1 and a DB2 design was undertaken. The JSD/JSP methodology underpinned this particular approach
- A performance management study for DVLC involving analysis of the existing performance and workloads of a major CICS/DL1 application and the preparation of recommendations concerning the adequacy of the database design and the need for upgrade to an IBM 3080.
- Two similar performance studies using capacity planning tools for ICL government installations (DNS and HMSO) of applications. They involved SCERT modelling software and resulted in recommendations for improvements as a means of forestalling machine upgrades. The HMSO performance review resulted in the preparation of recommendations for improving the reorganisability and recoverability of the IDMS supply system database.
- Procurement evaluation and selection studies of relational database software for the Ministry of Defence. Software evaluated covered Oracle, DL/1, DB2, Ingres and Rapport.
- A study into the nature, feasibility and requirements for a data warehousing facility to hold centralised register and database details concerning defence contractors using a common contractor coding scheme.
- During this period, in view of a continual involvement with SSADM and its lack of automated support, a comprehensive set of micro based data dictionary tools using Dbase III+ was evolved, designed and implemented. These various 'tools' were brought together at DVLC to actively support the database design process during the design of the Vehicle Inspectorate database.
Last Updated: 31st January 1996
Back to my home page
© Bernard W Bennetto 1996 - 1997