Leon Bambrick Brisbane, Qld. Australia. (Full contact details available by request. Email address available at http://www.geocities.com/leonbambrick/resume.html) Technical Skills o MS Visual Basic 3/4/5/6/.Net 4 years Including: COM, ActiveX, ADO, DAO, RDO, VBScript, OLE o MS SQL Server 6.5/7.0 3 years Including: Stored Procedures, Triggers, Views, Rules, DTS o MS Visual Basic for Applications 4 years Including: Excel, Word, Outlook, Powerpoint o MS Access 2/97/2000 4 years o Crystal Reports 5/6/7/8.5 4 years o Windows 95/98/NT 3/NT 4/NT 5/ME/2000 4 years o HTML 2.0/3.2/Javascript/Jscript/DHTML/SSI 2 years o MS Visual SourceSafe 6.0/PVCS 4 years o Shell/Batch Scripting 4 years o “.KIX” Scripting 1 year o MS IIS 1 year o ASP/MTS/MS Visual Interdev 1 year o C/C++/Visual C++ 6.0 6 months o Sybase 6 months o XML/DTD 6 months o CSS 6 months o IBM Team Connection 3 months o Unix (AIX, BASh, Linux) 3 months o Pascal Tertiary o Modula 2 Tertiary o AutoCAD Tertiary Qualifications BACHELOR OF ENGINEERING (COMPUTER SYSTEMS) o University of Queensland, Australia, January 1994 – August 1998 o Final Semester Grade Point Average: 5.2 (from a maximum of 7) o Thesis: “Lecture Timetabling Using Genetic Algorithms.” Grade: 7 (available at: http://www.elec.uq.edu.au/~reports/, coded in C++) o Course material included in-depth coverage of: - Structured and object-oriented programminng - Database design - Managerial and Documentation skills Employment History TSA SOFTWARE SOLUTIONS , BRISBANE (15/08/02 TO Present) Description of Company o A provider of Call Accounting and Billing software to thousands of Australian and international businesses. Position Held o Software Consultant Projects with TSA Systems Integration o Designed triggers to allow a contact management system to share data with a helpdesk system. o Skills: SQL Server T-SQL (Triggers, stored procedures), Visual Basic 6, Crystal Reports CAAB Managed Services o Authored components to provide versatile reporting features for a complex call accounting package. o Skills: Visual Basic 6 (ActiveX, COM), Crystal Reports THE CRESTA GROUP, LONDON (15/01/02 TO 21/06/02) Description of Company o A provider of niche computing services to European Banks and their multinational partners. Approximately 100 employees. o For more information see http://www.cresta.net Position Held o Senior Consultant - member of development team; provided restructure of systems division; interviewed and mentored new employees; DBA; intranet design/support. Projects with Cresta ASAP (Asset Securitisation Administration Program) o Provided development, support and design for a VB/SQL system which administers multi-billion dollar trade receivables asset securitisation deals. High pressure, fast turn around, extremely critical system. o Skillls: Visual Basic 5/6, Visual C++, ASP, IIS, FTP (SafeTP), Crystal Reports 6/7/8.5, MS Excel/VBA, PVCS Atriax TestBuilder o Providing GUI to an automated testing system for an online currency exchange o Skills: Mercury Winrunner, Mercury Test Director, Visual Basic 6 Changepoint o Creating Active Server Pages (ASP) and general DBA for the company's CRM/Workflow system o Skills: ASP, SQL Server 7 Cresta corporate website o Managed all technical and design aspects of complete redesign of the company website. o Skills: SSI (Apache servers), FTP, HTML, MS Photodraw, Javascript/JScript Rabobank Securitisation o Provided development and support of application used by leading bank for billion dollar securitisation deals. Extremely specialised technical skills and customer skills required. o Skills: Sybase, Visual Basic 6, MS Excel/VBA, Source Safe GF-X.COM, LONDON (28/08/01 TO 16/11/01) Description of Company o A neutral online exchange where shippers and airlines buy and sell freight space. o For more information see http://www.gf-x.com Position Held o Lead Application Developer Projects with GF-X.COM The Offline Tools o Excel VBA spreadsheets in conjunction with Unix scripts used for entering and validating Airline data to be imported/exported from/to an IBM DB2 database o Rapid troubleshooting and re-development of an ailing system involved the removal of over one hundred defects o Provided system documentation and authored VB coding standards documentation o Skills: Excel Visual Basic for Applications (VBA), FTP, IBM TeamConnection, IBM Unix (AIX) BERWIN LEIGHTON PAISNER, LONDON (03/07/00 TO 20/04/01) Description of Company o City of London Top 20 Law firm o For more information visit http://www.berwinleightonpaisner.com Position held o Analyst/Programmer, IT Support Department, Development Workgroup Projects with Berwin Leighton BLADE (Berwin Leighton Active Directory Engine) o Mission critical SQL Server 7 database of company personnel o COM object allows other applications to use BLADE data securely o Generates emails to key support staff when data changes o Acts as a workflow system for the support department o Consulted with user groups and provided feasibility reports before re-engineering the application o Provided staff training prior to roll-out o Skills: Visual Basic 6.0 (ADO and COM), SQL Server 7.0, Crystal Reports 7.0, MAPI BLADEMaps o Created “Hot Maps” for each floor of the building. Clicking on a desk location provides details of the occupant and links to other systems, including email, VNC, help desk, work flow, telephone system. o Information extracted from multiple sources, including security facilities o Also assisted in coding an ASP version for the company’s intranet o Skills: Visual Basic 6.0 (ADO and COM), SQL Server 7.0, ASP, VBScript BLAM! (Berwin Leighton Asset Management) o Extracts information from several 3rd party databases and compiles reports showing software licensing requirements o Skills: Visual Basic 6.0, SQL Server 6.5, MS Access 2000, Borland Interbase 6.0, Crystal Reports 7.0 ErrorLogger o Designed and implemented an ActiveX COM Object for automated trapping of VB runtime errors in all in-house applications o Error information is logged to a SQL Server 7.0 database o Skills: Visual Basic 6.0 COM, SQL Server 7.0 Various Other Projects o Maintained approximately twelve other Visual Basic 6.0 applications o Assisted with merger issues arising from changes to: company name; internet domain name; logos; structure of company; usage of computer resources o Experience with beta testing of Visual Basic “.Net” o Exposure to emerging web-based technologies including XML, XHTML and MTS TECHNISYST COMPUTING, BRISBANE, (10/02/98 TO 04/03/00) Description of Company o Rapidly growing provider of mobile computing solutions o For more information see http://www.technisyst.com Position held o Analyst/Programmer, Development Team Projects with Technisyst Computing Mobile File Transfer Utility o Transfers files to mobile computers using the Mobile Data Network o Responsible for the complete design and development o Skills: Visual Basic 6.0 (COM) Brisbane City Council - Water Department - Mobile Computing System Trial o Touch screen client/server application installed in six trucks o Provides work order allocation/processing and timesheets o Assisted in the development and management including site inspections o Skills: Visual Basic 6.0 (ADO), Access 97, SQL Server 6.5 Brisbane City Council - Development and Regulatory Services - FieldConX version 3.0 o Generic interface to allows existing client/server applications to be translated to a mobile environment without compromising performance o Used by over 300 Field Officers o Oracle and SQL Server backend databases o Designed and coded metadata communication layer using a format similar to XML o Provided all support documentation o Skills: Visual Basic 6.0 (ADO and COM), Access 97 DATA000 Demonstration Prototype o Touch-screen driven application to operate in police cars o Worked closely with the CEO to develop a demonstration version o Skills: Visual Basic 6.0, Access 97 Various Other Projects o Experience with use and development of an ISO 9000/9001 Quality Assurance System o Nation-wide travel to promote Technisyst products to potential clients References References will be provided on request. Leon Bambrick