David Malcolm Email & Phone Number

Adelaide, South Australia, Australia

Design, construction, distribution of Shower Timers.showertimer.com.au

Melbourne, Australia

• Continuation of Software Design Engineer duties for Argent (Telstra EFTPOS system).• 2014 - Design and development of web application portal for McAfee Vulnerability Manager (MVM). The system allows vulnerability scans parameter entry and scheduling with various stages of approval and facilities for re-scanning and generation and retrieval of Vulnerability Reports. Front-end web application is Python and Django based residing on a RedHat 6 platform using a MySQL database and PhpMyAdmin. Backend is a complex Perl system that uses SOAP to interact with MVM and associated Microsoft SQL Server database. Currently (Mar – May 2016) enhancing this system and making modifications to improve performance and streamline the process in response to user-feedback.• Using Java – designed & wrote an SSL load testing system to determine if Argent systems can handle EFTPOS terminals that use SSL mutual authentication.• Using Java – wrote a SCEP (Simple Certificate Exchange Protocol) based system as a Proof Of Concept to allow Telstra to manage distribution of SSL Certifcates using a Public Key Infrastructure. Gained Knowledge and experience in PKI. Evaluated architectures and java frameworks for this task but settled on jscep and Windows Server 2008 R2.• Redevelopment of several Perl and bash shell scripts on the HP-UX based Argent Network Management System (NMS) as part of the project to replace the old Transaction Maangement Facility (TMF) with a new system named AM-Shared. These scripts are utilised to manage the interface between Argent NMS and AM-Shared in order to perform distribution of configuration files to Argent Servers and Merchant EFTPOS Terminals. Extensive interaction and testing in co-operation with the 3rd party developer was required. • Perl scripting and Systems Integration tasks for the Security Services Framework project which uses ArcSight and Service-Now.

Melbourne, Australia

Argent (Telstra EFTPOS system) – Software Design EngineerMember of development team involved in design, implementation, maintenance, testing and support of Java network software applications used in the Telstra Argent EFTPOS network. Java J2EE versions 5 and 6 with IntelliJ IDEA versions 6 thru 11. Technologies used include Ant, Spring, log4J, Hibernate, Oracle, ActiveMQ, JSP, Struts, bash shell and PERL scripting.. Platforms include Windows (XP, 2003 Server) and RedHat Linux. Applications developed included IPTX and Xanthos (specialised real-time concurrent networking applications that provide protocol conversion between TCP, UDP, SSL and QTP for financial transactions) AWR (a web based reporting package that allows real-time billing enquiries to be made by banks), AOS Collector (a system that collects RADIUS accounting files from AOS servers and processes them into format required by Telstra billing systems) and TPL (T-Pay Listener – a Management system for Telstra Manged Devices that uses SNMP).Traffica Filtering and Mediation Server (TFMS) – Developer, Integration Engineer and Product SpecialistMember of development team. TFMS is a mediation component for NSN Traffica OSS application (Serve @ Once). Mobile Phone Handover events are gathered from multiple Mobile Switching Centres, sorted, augmented with cell co-ordinate data and streamed to a 3rd party platform which manipulates the time-stamped events to determine the speed of vehicles travelling on roads. Java J2EE, IntelliJ IDEA, Ant, Spring, log4J. bash shell scripts and PERL scripting. Gained much expertise in installation and configuration of Traffica versions Z4 and Z5. Also gained valuable knowledge and experience with 2G and 3G mobile phone voice and data system hardware. Involved in installation, UAT and SIT of Optus Australia and Telefonica O2 Germany installations. Provide 24/7 support for Optus Traffic View production – fault diagnosis and resolution, development and testing of s/w fixes.

Adelaide, Australia

Contracted to modify and enhance the Police Check Management System (PCMS), PIMS Text DownLoad (PTDL) system and the Police Check UpLoad (PCUL) program. PCMS and PTDL were originally written in VB6 and use an Access database, while PCUL is an Excel based VBA program that is used to generate xml files for import into PCMS. I was originally responsible for the design and implementation of PCMS and PCUL and had also made extensive modifications to PTDL. The changes involved business analysis of changed processing requirements to add functionality for streamlining the processing of applications for National Police Certificates along with numerous other small changes. Unit test cases were writtten and I was involved in all stages of the development. After the modifications were completed I was asked to investigate ways to improve performance of PCMS and PTDL. The conclusion was that the best option was to convert the databases from Access to Oracle 10g and I am currently performing this conversion. This will also require extensive changes to the code. I am also involved in analysing the feasibility of conversion of these VB6 applications to Java, but have been informed that while this is a desirable long-term goal, there will be no funding available for this to commence in the foreseeable future.

Adelaide, Australia

Contracted as part of a team of two to design and develop a Java web based system to manage the process of investigating an offence and the interaction between Police and the Criminal Justice System in preparing a case for trial. WebLogic Workshop 8.1 was used as the development environment, with an Oracle database. Other tools used include CVS, Eclipse and TOAD along with several other packages. My initial role was as a Business Analyst and a great deal of interaction with Police and CJS staff, including weekly meetings was required to prepare and implement the design. After three months of analysis, design and writing a detailed system specification, I worked my way through a BEA course to became comfortable with WebLogic and spent two months programming. A Rational Unified Process with regular user feedback and frequent unit testing has continued throughout the development, resulting in changing requirements and expanded functionality, but I managed to keep the project under control, keeping all parties advised and included. ORMS contains about 200 screens, will ultimately be used by approximately 4000 Officers throughout the State and several months of further testing, refinement and changes are still anticipated before the final rollout on May 21st 2007.

Adelaide, Australia

Contracted to develop a VB and Access based system for use by Records Release Unit (RRU) to manage the production of National Police Certificates. The system was required to function in concert with the pre-existing PIMS Text Download program that allows SAPOL Criminal Histories to be downloaded from their mainframe systems. A large increase in the number of NPC requests received daily had created the need for a system that allowed SAPOL to automate the checking of applicant data using a facility in Canberra called Crimtrac which can check applicants against a National Names Index containing criminal history from all Australian jurisdictions. PCMS provides a screen for data entry of batches of individual NPC requests and a screen for importing PCUL xml batch files. Other screens provide the ability to export batches of data into xml files for upload to Crimtrac via the EAMS web portal and for import of Crimtrac result xml batch files downloaded from the EAMS portal. A bulk update screen allows printing of NPCs using Word Templates. VB6, Access, XML DOM, Word and VBA were used for the system. I was responsible for business analysis, system specification and design, database design, coding, testing, report design, installation, rollout, training and support. The system has been a great success that enabled a backlog of 5000 requests to be dealt with within a month and continues to provide a rapid turn-around time for the production of NPCs.

Adelaide, Australia

Contracted (solo) to develop a self-contained VBA Excel application for distribution to other organisations to streamline the entry of their employees’ details in order to obtain National Police Certificates (NPCs). The application provides a very user-friendly interface that allows speedy entry of the personal details of several employees into a batch which can be exported to an xml file that is then emailed to SAPOL. This xml file was designed to be imported by the soon to be developed Police Check Management System (PCMS) that would enable SAPOL to utilise the services of Crimtrac in Canberra to speed up the processing of an ever increasing number of requests for NPCs. An Excel application was used in order to allow the program to be distributed easily without any need for installation or support. Documentation and user manual was also written and analysis tasks included design of the procedures and a batch numbering system that ensured that each record had a unique identity regardless of when it was created or which organisation it came from.

Adelaide, Australia

Contracted (solo) to develop a web-based application to track the details of employment for several thousand police volunteers - such as those involved in Neighbourhood Watch and Blue light Discos. Analysis and design tasks were performed at the Information Systems and Technology Applications Branch located S.A. Police Headquarters. The development environment involved the use of Java 2, JavaServer Pages 2.0, Java Servlets 2.4 and JDBC under J2EE 1.4 using NetBeans 4, Tomcat 5, Apache Server, and Dreamweaver MX. The application involved the design of a MySQL Server 4.1 database and coding of Java classes, JavaBeans and HTML / JavaServer Pages using an MVC design pattern

Adelaide, Australia

Contracted to write and test modules using Visual Basic 6 under Windows XP with Access 2 for a “shrink-wrapped” software package called “Manage Your Own Property” (M.Y.O.P) that allows a landlord to manage his own rental properties. Developed user interface and designed, coded and tested software routines. Design and integration of reports using Crystal Reports. Implementation of a text parsing and processing system for a sophisticated software-driven token-based mail merge and letter generation system.

Adelaide, Australia

Contracted as an analyst/programmer to design modules using Visual Basic 6 under Windows NT with SQL Server 2000 for a system to automate the operations of fruit packing sheds in the Riverland of South Australia. Developed user interface and designed, coded and tested software routines. Designed database and wrote stored procedures and views using SQL Server 2000. Integrated reports using Crystal Reports 8

Adelaide, Australia

Part of team developing user interface in VB6 and software routines in C++ for Mayne Nicholas Pty Ltd. Responsible for ongoing support and extensive rework and maintenance of several internal software systems including Accounting Systems and the Monthly Financial Reporting Package using VB 6 and SQL 7 and Crystal Reports 7.Involved in design and development of Education and Training Administration System and the Web-based On-line Timesheet System using VB6, SQL7, Crystal Reports 7, HTML and Microsoft Outlook. This project involved use of Object Oriented programming techniques, design of class modules and the creation of ActiveX dll COM components were involved in the development of these two systems. Supervision, training and mentoring of young people as part of the new Programming Apprenticeship system.

Adelaide, Australia

Database design, administration, coding, testing, installation and documentation of the results recording and reporting system for the Australian Masters Games Results system. Also used Active Server Pages, HTML and JAVA to develop the Web based system (including web page design and content) that hosted and allowed the public to search for (Using several different criteria lists) and/or look up the results of any games participant. The system uses a Client-Server approach and allows recording of each participant’s results (12,500 participants, 4,500 events in 46 sports) using an MS SQL7 database with SQL7 stored procedures and Visual Basic 6. Reports are generated using the VB6 data reporter and participant certificates are produced by integration of MS Word 97 into the system. Additional administrative functions allow export of text files for the Advertiser Newspaper in their required format for inclusion in the daily sports result section. Extensive training was also provided to a large number of users

Adelaide, Australia

Member of the ASPECT team developing the Competitive Administrative Tool System (CAT) and the Public Relations Integrated Sponsorship Management System (PRISM). The CAT and PRISM systems run on a Novell network and use Access97 databases with Visual Basic 5 front ends, utilising SQL procedures to extract data. Reports for both systems were generated using Active Reports version 1.1. My responsibilities included programming in Visual Basic 5 with Access 97 and researching methods and implementing functionality to integrate MS Word 97 and MS Excel 97 into the CAT and PRISM systems. I was also responsible for researching available reporting tools and the final choice of Active Reports, which is an ActiveX report designer that integrates into the Visual Basic 5 development environment. I then designed and coded the methodologies and routines required to implement Active Reports as a reporting tool and was responsible for the design and coding of a large number of reports. In addition, I wrote a number of rich text format export and manipulation routines that enabled integration of Active Reports and Visual Basic 5 with MS Word97 to allow Royal Agricultural & Horticultural Society competition and show catalogues to be generated on the fly. I also undertook documentation, quality assurance procedures and administration tasks

Adelaide, Australia

Awarded the " Aspect Team of the Year" for outstanding project achievement. Member of the ASPECT team developing a Rural Services Membership System (RSMS) and a Site Booking Management System (SBMS). The RSMS and SBMS systems run on a Novell network and use Access 97 databases with Visual Basic 5 front ends, utilising SQL procedures to extract data. Reports for both systems were generated using Crystal Reports version 4.2.My responsibilities included programming in VB5 with Access97, researching methods and implementing functionality to integrate MS Excel97 and MS Word97 into the RSMS and SBMS systems. I was the principal designer of a large number of Crystal Reports for use with the two systems and also undertook documentation, quality assurance procedures and administration tasks.

Adelaide, Australia

• Develop a multi-user system using Visual Basic and Access for entry, search, retrieval and storage of staff telephone numbers and location details.• Design and author a help system using RoboHelp and provide system documentation using Word• Allowing for feedback and resulting modifications, plan the testing, acceptance and network based installation and rollout of the application throughout the department.

Adelaide, Australia

Go Software designs and supports PC based custom business software packages in the areas of Real Estate, Accounting, Payroll, Mercantile, Conveyancing and Medical Clinic/Hospital. They also sell, install and support PC and network hardware and software. They provide these services to approximately 100 companies.• Development of multi user windows based business applications using Visual Basic 3, SQL and Access.• Analysis of customer requirements in the design, development and implementation of new applications.• Database design, development and administration using Microsoft Access versions 1.1, 2 and 95.• Involvement in other stages of program design including documentation, maintenance and modifications. • Provision of customer service, support and training over the telephone, modem and at customer sites.• Installation, configuration and board-level repair of computer hardware, peripherals and software.• Network installation, configuration and administration using Lantastic, Windows 3.11, 95 and NT.• Management and prioritisation of programming, administration and customer service tasks

Melbourne, Australia

• Customer service and electronic repair of CAD/CAM, plotter, sound card and electronic music equipment. • Network & computer configuration, hardware & software installation, troubleshooting & repair.• Billing, invoicing, receipt and administration of customer accounts and banking of funds.• Ordering of spare parts and scheduling of repairs in order to provide fastest possible return to the customer.• Evaluate and test new hardware and software products and peripherals.• Review service information bulletins and attend product briefings, promotions and demonstrations.• Liaise and provide services as required to authorised sales dealership staff and customers.

Adelaide, Australia

• Assisted the project manager and the design team in production planning and development of circuitry and software to allow the installation and interfacing of a telecom phonecard reader to existing vending machines• Design and code C and assembly language routines for automated testing of the interface circuitry.• Constructed and tested prototype electronic circuit and case assemblies.• Wrote technical documentation in MS Word.• Devised, documented and conducted environmental tests to AS 1099.• Project management tasks included coordination of personnel and resources, organising meetings and establishing plans / timetables (MS Project)

Melbourne, Australia

• Member of design team and was involved in all stages of production for Pascom’s Matrix Switch System. • C programming and hardware design for automated testing equipment and associated interface circuitry• Wrote technical documentation, user manuals, CAD produced circuit diagrams & pcb production masters.• Installation, test, repair and config of equipment. Provide technical assistance to staff and customers.

Melbourne, Australia

Second and Third year of degree study. Graduated with Distinction.

Melbourne, Australia

• Administrator of the Prime Series 50 based Stores and Inventory System.• Used Cobol, Fortran and 4GLs to write and maintain application programs.• Responsible for system operations, backups, maintenance and network admin.• Diagnosed and solved hardware and software problems.• Provided training, support and technical assistance to users and management.

Melbourne, Australia

First Year of B.Ap.Sc in Digital Technology

Melbourne, Australia

• Design and programming software applications using Clipper and dBase - III+.• Support and maintenance of PC and IBM Mainframe network and associated peripheral equipment.

Melbourne, Australia

• Operations under TSO, NetMaster and JES on IBM mainframe network• Operation of a 3275 Front End Processor.• Cable, patch panel, controller and terminal installations and maintenance.

Adelaide, Australia

• Data analysis of air force bomb and rocket trials using PL/1, Fortran and Cobol.• Travel to and assisting in recording of trials at Woomera.