Derek Diamond Email & Phone Number

City Of Johannesburg, Gauteng, South Africa

Created SpatialXL a complete spatial addin to Microsoft Excel.Created MineModeller a complete surveying addin to Bentley Microstation.Created MineDB the most advanced 3D mining spatial extension to Microsoft SQL Server.Created DesignXL ( minedesigner.com),GeologXL (geologxl.com),SamplingXL (samplingxl.com),SurvelXL (surveyxl.net)Co-developed a process test creation and management system for Microsoft Excel.Have our software installed in almost all major mining companies in South Africa

Created web programming component "Aspect".Created the first 3D spatial extension to Microsoft Excel.Created a Microsoft Excel compiler, that allowed excel spreadsheet calculation outside excel and in a SQL Server database at higher speeds than excel itself.Created a web mapping component for GIS on the web.Created a 3D spatial component for mining znd GISCreated a mining grsphics system for mining data manipulation together with data from other sources.Created a routing component that could also exdcute in a SQL Server database for logistics and other applications.Creating a component for 3D spatial printing and publishing.Created a powerful spatial ETL engine and scripting engine for all spatial formats and databases.

Developed a financial calculation engine to allow modelling huge financial systems.Developed various Excel addins for financial modelling in the Mining area

Developed a sampling system with integrated graphics display and full client server implementation.Developed a Histogram evaluation system for platinum ore bodies.Created a 3D graphics component to graphically enable the MRM system that was developed.Developed a mobile graphics component for handheld based mining systems.Developed a core logging system based on handheld devices integrating with an Oracle database.Developed a geological mapping tool also based on handheld devices.This system allowed offline capturing and editing of geological data.Developed various mine design tools using the graphics component I developed.

Johannesburg Area, South Africa

Consultant on the Ore Reserve Managment System.Developed a spatial statistical package integrating with the ORMS database. It allowed variogram calculations, variogram modelling, sichel-t calculations, QQ plots etcetera..Developed a graphic engine for working with Microstation design files together with mining data.

Pretoria Area, South Africa

Developed a systems management platform to perform similar jobs across DOS, Unix, OS/2 and Windows. I wrote a language and virtual machine much like java with a simple windowd UI that rand on all these systems from the same bytecode language. Then went on to a workflow and document management system. I adapted the language and made it able to transport accross networks with mesages and resume execution at each point it was received, thus allowing for dynamic workflow capabilities. I implemented it inside Microsoft Outlook as well for mesage based workflow management.

Doringkloof Pretoria

Designed and coded an educational system using C++. I needed to write a device driver for a video grabber that displayed graphics on a projected screen. I wrote the graphic editing and manipulation system for the tutorial designs.

Pretoria Area, South Africa

Consultant on a logistics management system. Worked on SCO Unix, Solaris, Oracle and Oracle Forms. Developed a general message passing and transaction managment system. Designed a general message definition tool where the message metadata was defined in the database. Messages could be serialized for transmission and then unpacked into transaction processing stored procedures. The message data was bound to the stored procedure automatically. The transaction stored procedures could be defined in an Oracle Forms user interface, and could be valiadted by auto binding trial parameter values. Since the system involved processing over 100 different message types I was able to save the company nearly a million rand of development time in those days.

Pretoria Area, South Africa

Using OS/2 was involved in the design and inplementation of a graphical voters roll system for the Pretoria City Council. I wrote the background map display system together with a ward management system where wards could be graphically digitized and validated for no overlap and complete coverage. We then geocoded voter locations from erf numbers and then finally calculated voters per ward using geometric inclusion tests, all of which I wrote myself. We used SQL Server for our database and our own custom graphics for display.

Doringkloof Pretoria

I was the graphics team leader. We worked on OS/2 systems using the C programming language. I designed and managed the development of the User Interface architecture and graphics manipulation. I wrote a tiling system for vector graphics to improve performance. To facilitate software development I wrote a build system that scanned the source code and only compiled source files that had out of date object files. It also maintained the build order and dependencies.

Johannesburg Area, South Africa

Went on the Intergraph 2D CAD course. Got my first taste for spatial. I wrote support scripts and programs for the CAD system which was running on DEC VAX hardware. I then went on to work on the IIS Image processing system which I helped procure. I wrote low level code to perform virtual image ratio processing and principal component image decomposition. We used and processed Landsat and SPOT images. Those days you needed special hardware to process and view such data!To assist me in all the geo processing utilities I wrote I created a forms and windowing system for parameter input and results display using the C programming language on VT100 screens! For the first time our users were entering data into fields and tabbing between fields, instead of using command lines!

Doringkloof Pretoria

Systems programming on Digital Equipment Corporation VAX equipment. I was involved in writing real time operating system extensions. The standard Operating System services were too slow for real time traffic control systems. We wrote our own high speed event queues, locks and memory sharing facilities. We use the RTL/2 programming language as well as Vax Macro Assembler. I also wrote a lexical parser and textual substitution system for preprocessing our source code.

Randburg

Wrote a device driver for an in-house developed graphics card for telecontrol. Wrote a device driver for a serial mouse also for telecontrol. Wrote an Ethernet communications system for communicating from a embedded system to the mainframe. We workd on Digital Equipment Corporation VAX 11/750 computers and embedded systems using the Intel IRMX Operating systems. It was here that I learnt the C programming language, becoming proficient in it in under two weeks!

Pretoria Area, South Africa

I did not want to get involved in military action so got transferred to the Signals Unit at 5 Signals Regiment. I worked on their computer systems and implemented a Direction Finding System that is probably still in use today. I was able to perform a better solution than two private companies and the CSIR! This system located radio transmission sources by triangulation from multi reciever locations. I developed a proprietey algorithm to get a good initial estimate of the location and then using a radical non continuous parameterization of the Globe was able to use a second order steepest descent search to calculate the result in seconds. We worked on Digital Equipment Corporation PDP 11 clones with a grand total of 2MB memory!!

Bsc(Hons), Mathematics

I received Herbert Le May Prize for Applied Mathematics and Computer Science Project. I was awarded the William Cullen medal for the most.

Matric, Maths, English, Afrikaans, Science, Latin, Geography

I Matriculated at the age of 14 after begging my mom and teachers to let me skip standard 8, and then standard 9 as well!