CURRICULUM VITAENAME:METCALFE, Robert James

ADDRESS

HYPERLINK "http://www.ozemail.com.au/~mkuulma/House Pictures 030.jpg" \o "Our house, in the middle of our street" :136 Darley Street,

Newtown, Sydney NSW 2042

TELEPHONE (H):(02)95163479

HOME EMAIL:rmetcalfe15@gmail.com

DATE OF BIRTH:29th August 1959

HEALTH:

Good

REFEREES:

Mr. Colin Styles

Senior Analyst/Programmer

The Construction Site Multimedia Pty Ltd

Mobile: 0421174474

Mr. Maurice Hill

Integrated Services Manager

InvestmentLink Ltd

Telephone: (02)99685766

Ms. Kate Holz

Principal Partner

Adept Executive Solutions

Mobile: 0412 360 860

EDUCATION:TERTIARY: University of NSWBachelor of Surveying 1978-81

INTERESTS:Family, reading, music, walking, AFL

STRENGTHS:

C#, C, C++, Pro*C, VB.NET, ASP.NET, PHP, Python, HTML, CSS, JavaScript, TCL, Unix,

SQL Server, MySql, Oracle, PL/SQL, SQL, T-SQL, XML,

SAP Business One Webtools and Webservices

RECENT R&D:(NB Feb–May/09: Learn PHP MySQL TCL/C++ Apache Perl

DHTML ASP.NET/SQL Server ADO.NET OLE XML GIMP RDP

SQL Server 2008 course, Now: jQuery, AJAX, CRM, CMS) Vs…

CURRENT WORK:

PERSONAL WORK EXPERIENCE

WORK EXPERIENCE

Concept Paints

March 2011 to August 2012:

Date:

March 2011 to August 2012

Position:

Computer Analyst/Programmer

Technical

Environment:

.NET Framework 4.0, VB.NET, C#, PHP, Advantage,

SQLServer 2008,MySQL,JavaScript.Excel VBA,Winforms,

HTML/CSS, Ajax, Windows 7, MYOB, Google Graphs,

Microsoft Visual Studio 2010, X-Rite SpectroPhotometers

Description:

Concept Paints create, sell and export car paint to both domestic

and international markets.

Team

Environment:

Senior business analyst (offsite) and Technical Manager (onsite)

specify work for me to carry out and priorities to

keep. The Colour Matching work was done quite

autonomously, as this project required new research and

development the company required.

What I Do:

. design and create Colour Matching VB.Net and C# desktop

Windows Forms and Class Library DLL for desktop

Applications, as well as a prototype for Website use.

. maintain IT services such as PC/Laptop/Printer/Network/Software

setups.

RJM Programming

November 2010 – Now: Please refer to Personal Work ExperienceLateral Interactive Systems /The Construction Site Multimedia Pty Ltd

June 2009 to October 2010:

Date:

June 2009 to October 2010

Position:

Computer Programmer

Technical

Environment:

C#, ASP.NET, .NET Framework 2.1 & 3.5, VB.NET, PHP,

SQL Server 2005, MySQL, JavaScript. Word VBA,

Mojo portal, Joomla, TCS portal, Visual Source Safe,

SAP Business One Webtools & Webservices, XML, SOAP,

DCOM, Photoshop, HTML/CSS, Windows XP, UltraVNC,

Wampserver, Microsoft Visual Studio 2008/2005/2003, IIS

Description:

Lateral Interactive (and The Construction Site) design

and develop websites and multi-media solutions for

medium to large sized businesses. The websites

almost always have a CMS and often have an eCommerce

component.

Team

Environment:

Senior business analyst and/or senior analyst/programmer

specify work for me to carry out and priorities to

keep. The SAP work was done quite autonomously, as

the company employed me to handle this work.

What I Did:

. develop and maintain client web sites using

C#/ASP.NET, PHP, JavaScript with databases MS-SQL 2005

and MySQL. Much of the work involves content

management systems such as Mojo portal, Joomla and

TCS portal.

. setup SAP Business One Webtools/Zedtools

eCommerce functionality of a commercial website.

. designed and created SAP Business One 8.8 addon

and ZedTools Synch Manager plugin to interface

the accounting system with the website and its CMS.

. installed and used SAP Business One Webservices

to build ASP.Net websites that could read and write

to a SAP database, involved COM+/DCOM configuration,

SOAP protocols and XML.

MicroChannel Services Pty Ltd

June 2007 to January 2009:

Date:

June 2007 until January 2009

Position:

Computer Programmer/Analyst (full-time)

Technical

Environment:

VB.NET, C#, .NET Framework 2.1,

SQL Server, Transact-SQL, GoTo Meeting,

.NET Framework 2.0, Visual Source Safe,

SAP Business One SDK, Crystal Reports, VBA,

CRM, Visual Studio 2005, Windows XP,

Microsoft Office macro, EDI, UltraEdit,

ODBC data connections, Remote Desktop,

Cisco VPN, Virtual Machines, VB6, Word,

Excel, Access, Microsoft Groove, DOS Batch

Description:

MicroChannel Services Pty Ltd provide accounting

solutions for the SAP and Accpac suite of software

for small to medium sized businesses. MicroChannel

Services Pty Ltd sell, develop and support the

SAP Business One and Accpac suite for users and

other SAP and Accpac dealers.

Team

Environment:

Senior business analyst or senior analyst/programmer

specify work for me to carry out and priorities to

keep. There is an independent quality assurance

phase with inhouse consultants. The style of

programming & method used are largely left up to me.

What I Did:

. support and lots of extension to SAP Business One

add-ons in VB.NET and C# both as generic

products and client projects

. use MS-SQL to maintain test database to use for

unit testing SAP addons & EDI automation

projects can involve use of Stored Procedures

and Triggers

. unit tested applications prior to passing

applications on for QA testing

. maintain source code using Visual Source Safe and

Visual Studio 2005

. maintain environment where I can keep up to date

with project documents so as to raise my level

of self-autonomy and stay informed

. user guide & technical guide writing for software

products

. implementation of solutions at client sites via

client visits and via remote desktop access

talking through processes involved with clients

NB December 2008: Learn Publishing Web Sites via

Dreamweaver, Word, HTML, JavaScript,

PHP, Perl (exposure), Domain Name

Administration websites for friend

NB May 2007: Learn ASP.NET Framework/C#/SQL Server/Cassini

Goodman Fielder

November 2006 to April 2007:

Date:

November 2006 until April 2007

Position:

Computer Programmer/Analyst (5 month contract)

Technical

Environment:

Pro*C, Oracle 10g PL/SQL,

Visual Source Safe, Lotus Notes,

Unix AIX Korn Shell, Toad,

WRQ Reflection Macro, DOS Batch, Windows XP

Description:

Bakeries division of Goodman Fielder wants its

various regional databases centralized resulting

in big changes to its QBICS application used for

distribution, sales, invoicing, commissioning.

A front-end Visual Basic application sends commands

to an AIX server running Pro*C applications to

maintain the databases, automated by AIX Korn Shell.

Team

Environment:

A senior analyst/programmer specifies work for me

to carry out and priorities for me to keep to. The

style of programming and methods are left up to me.

What I Did:

. support and lots of extension to applications in

Pro*C and Korn Shell for Bakeries database of

commands from by Visual Basic GUI front-end

. used Toad and PL/SQL to maintain test database to

use for unit testing – wrote automation scripts

. unit tested applications/automations prior to

passing applications on for QA testing

. maintain source code using Visual Source Safe

. maintain environment where I can keep up to date

with project documents so as to raise my level

of self-autonomy and stay informed

Thomson Reuters

October 2006:

Date:

October 2006

Position:

Computer Programmer/Analyst (casual)

Technical

Environment:

Digital Mars C, XML, M’soft Visual C++ 2005

Description:

Program to create a table of cases in XML

format for Publishing/Printing application.

CPS Systems Pty Ltd

July 2000 to September 2006:

CPS’s InvestmentLink product provides Information

and Transacting Infrastructure to the Australian and

New Zealand wealth management industries.

Date:

July 2000 to September 2006

Position:

Senior Computer Analyst/Programmer

Technical

Environment:

Solaris cc/Linux gcc C, Pro*C, gdb, dbx, Microsoft C,

Visual Basic 6, Unix Korn Shell, Oracle 8&9i PL/SQL,

Oracle Forms, Powerbuilder, Python, Windows NT, PVCS,

Windows 2000, X-Windows, DOS Batch, (s)ftp, Word VBA

Description:

Application programming for database applications

in C and Pro*

HYPERLINK "http://www.ozemail.com.au/~mkuulma/ProC/CPS_MLCMasterkey.jpg" \o "another CPS Pro*C example" C, Unix Korn Shell scripts and PL/SQL

scripts for use with Oracle 8i and 9i.

Some user interface programming in Powerbuilder

for GUI applications in Windows. Automated Python

applications for both Unix and Windows platforms.

Training:

Self-arranged informal Java programming training

and installed and used RedHat Linux on home computer

Team

Environment:

In our unit a Business Manager writes out business

requirements for Value-Added functionality and/or

bugfixes. Amongst a team of three, which includes

me, the analysis and coding is undertaken.

Technical specifications are not written for every

piece of work, and in such cases the individual

programmer can design the program/interface. My

PowerBuilder GUI applications were a case in point.

What I Did:

. support and lots of extension to applications

in Pro*C and Korn Shell and (PL/)SQL script for

Consolidation Service database hub collecting

managed funds data supplied by Fund Managers

and distributed to Adviser Groups, allowing

multi-Fund-Manager-grouped individual

(e-)Portfolios to be displayed with a web

Application

. code and design Data Reconciliation suite using a

variety of Pro*C and Korn Shell and arrange for

Windows Word Reports via email and DOS Batch

Files and Word Visual Basic Macros

. design the automation of Breadth/Depth project

which allows new data flows from a variety of

new data sources downloaded from World Wide

Web sites through our Web Server to Windows

where Python programs would run under a menu

system in PowerBuilder and arrange hub database

updates via ftp to and from Unix box utilizing

crontab Korn Shell listeners and Pro*C programs

to handle database updates while email is used

for error handling scenarios

. do most of the coding and many of the design ideas

for archiving suite written in Pro*C with

embedded PL/SQL and supervised by crontab Korn

shell scripts

. have a close liaison with the Help Desk and

help out with client queries

. have a close liaison with Fund Managers with their

development work interfacing with the

InvestmentLink hub

. rostered production batch job online support

(12x6) requiring strong analysis skills

Smart Business Systems Pty Ltd

May 1997 to May 2000:

Smart Business Systems provide accounting solutions for the

Accpac suite of software. Smart Business Systems sell, develop

and support the Accpac suite for users and other Accpac dealers.

Date:

May 1997 to May 2000

Position:

Computer Analyst/Programmer

Technical

Environment:

Watcom C++, CA Realizer Basic,

CA Realizer CA-BLE, Accpac Macro, BTrieve,

CA-RET Report Designer, Wise Installs,

Smithware DDF, Microsoft Outlook, Windows 95,

Windows 98, Microsoft Visual C++, Crystal Report

Designer, Windows NT

Description:

Application programming for database views in C

and user interface programming in Realizer

Basic for first year and three quarters, then in

C++ lately, with analytical design input, for GUI

software products. There is also some C

programming in Accpac Plus (for DOS) applications.

Training:

No formal training

Team

Environment:

The coding is carried out almost exclusively

by me in the Accpac for Windows applications over

the first year and three quarters, then in a team

of two programmers when a C++ environment is used.

The coding is done in a team of 2 for the Accpac

Plus applications. GUI design in the Accpac for

Windows environment is occasionally collaborative

but mainly left to me. I report to the

Applications Development Manager, who is also the

joint Company Director.

Travel Industry Automated Systems

January 1995 to May 1997:

TIAS provide travel agents with electronic means of

creating bookings and making transactions, often involving

third-party vendors. TIAS provide services to aid the other

parties with communications as well as application programming.

Date:

January 1995 to May 1997

Position:

Computer Analyst/Programmer

Technical

Environment:

VAX/VMS C/DCL, Unix C/JavaScript, Windows 3.1,

Stratus

Description:

Application programming mainly in various forms of

C with respect to screen-driven travel agent

applications using X25 and TCP/IP protocols.

Training:

Introductory C++ (3 days)

Creative Thinking (3 days)

Introductory Unix (3 days)

Accelerated HTML Course (2 days)

Team

Environment:

The coding is carried out in teams of up to 4

programmers and general project matters involve

technical and commercial teams of about 10

people. I report to the Applications Development

Manager.

Illawarra CADD Professionals

November 1994 to December 1994:

Date:

November to December 1994

Contract:

MicroStation Development Language Consultancy

Position:

Computer Programmer/Analyst

Technical

Environment:

MicroStation, MDL C, C, GUI, Windows, DOS

Description:

Three data conversion applications in the mapping field.

MITS Ltd, Melbourne

October 1994:

Date:

October 1994

Contract:

MicroStation Development Language Consultancy

Position:

Computer Programmer/Analyst

Technical

Environment:

MicroStation, MDL C, GUI, DOS, RDBMS,

Informix, Unix, Clipper, Windows

Description:

Create a conversion application in the utilities

management field.

BHP Engineering, Wollongong

August 1990 to September 1994:

Date:

January 1993 to September 1994

Position:

Computer Programmer/Analyst

Position:

Computer Systems Co-ordinator (8/91 - 12/92)

Network:

Pathworks Network

Technical

Environment:

MicroStation, MDL C, M'soft C, GUI, Mac,

VAX/VMS, DOS, Pathworks, DECnet, DCL,

VAX FORTRAN, Microsoft FORTRAN, Windows

Training:

Intergraph MDL Programming Course (1 week)

Digital Pathworks for DOS Course (1 week)

Digital Pathworks for Mac Course (1 week)

Team

Environment:

I report to the Supervising Photogrammetrist

and consult with any members of staff having

difficulties with computer equipment or software,

or who have a programming requirement.

BKS Surveys (Coleraine, Northern Ireland and Brisbane, Qld) Pty Ltd

September 1985 -March 1986, October 1986 -June 1990 (Coleraine) January 1982 - August 1985 (Brisbane):

Date:

January 1982 to June 1990

Position:

Computer Programmer (9/85 – 6/90)

Position:

System Manager (2/84 - 8/85)

Position:

Graduate Surveyor (1/82 - 1/84)

Technical

Environment:

VAX/VMS, FORTRAN, DCL, Informap, DECnet,

DOS, Basic, Land Surveying

Team

Environment:

In the Coleraine Photogrammetry and Mapping

Head Office I report to the Computing Department

Manager and Data Processing Manager, who head a team

of 10 staff made up of 1 operator, 1 hardware

engineer and 6 programmer/analysts. Software request

forms come in from the production departments and

team meetings decide who should deal with the matter.

During the period of April 1986 to September 1986

visa issues to do with working in Northern Ireland

were resolved, and I was involved in Programming

activities in the Photogrammetric field in Brisbane.

During my time in the Brisbane subsidiary office I

started out as a Graduate Land Surveyor and grew into

the role of System Manager when the company

diversified into the digital mapping arena. I was

offered the Coleraine position when the worldwide

company centralized.

PERSONAL WORK EXPERIENCE

RJM Programming

November 2010 – Now:

Date:

November 2010 - Now

Position:

Computer Analyst/Programmer

Technical

Environment:

.Net 4.0, Visual Studio Express 2010, C#, ASP.Net, VB.Net, MS-SQL 2008 Express, Windows XP Home Edition Cassini Web Server, MAMP, Apache, PHP, MySql, iWeb, iMovie, GIMP, Grab, Preview, Paintbrush, Firefox+Firebug+Fireftp,BannerZest,Joomla,phpCMS,Android,Java, Pluck,Frog,Magento,osCommerce,VirtueMart,Drupal,Wordpress,vTiger,

XML, SpectroPhotometer Colour Matching Website , Linux

Hosted Website

(interactive websites created from scratch below)

HTML/CSS via iWeb:

http://www.rjmprogramming.com.au/

http://www.rjmprogramming.com.au/MyBusinessEins/

http://www.rjmprogramming.com.au/MyBusinessOne/

http://www.rjmprogramming.com.au/MyBusinessUno/

http://www.rjmprogramming.com.au/MyBusinessUnidad/

http://www.rjmprogramming.com.au/metcalfe/

Apache 2.0.55/

PHP 4.4-1.1:

http://members.ozemail.com.au/~mkuulma/public_html/rjmprogramming/

http://members.ozemail.com.au/~mkuulma/custom.htm

Apache 2.2.17/PHP 5.2.16/MySQL 4.1.22:

http://www.rjmprogramming.com.au/myfavourites/

HYPERLINK "http://www.rjmprogramming.com.au/wordpress" \o "PHP/MySql Blog"

http://www.rjmprogramming.com.au/wordpress/

HYPERLINK "http://www.rjmprogramming.com.au/vtigercrm/" \o "PHP/MySql CRM"

http://www.rjmprogramming.com.au/vtigercrm/

HYPERLINK "http://www.rjmprogramming.com.au/mycustomerportal/" \o "PHP/MySql CMS/CRM/eCommerce (experimental)"

http://www.rjmprogramming.com.au/mycustomerportal/

HYPERLINK "http://www.rjmprogramming.com.au/oscommerce/" \o "PHP/MySql eCommerce/Blog"

http://www.rjmprogramming.com.au/oscommerce/

http://www.rjmprogramming.com.au/magento/

http://www.rjmprogramming.com.au/drupal/

HYPERLINK "http://www.rjmprogramming.com.au/frog/" \o "PHP/MySql CMS (teams with iWeb)"

http://www.rjmprogramming.com.au/frog/

Apache 2.0.55/

PHP 4.4-1.1 via phpCMS, HTML/CSS of iWeb/Pluck:

http://members.ozemail.com.au/~mkuulma/phpcms/parser/parser.php?file=/demo-en/index.htm

http://members.ozemail.com.au/~mkuulma/pluck/

Localhost Website

(snapshots of websites created from scratch below)

.Net 4/ASP.Net/ C#/SQLServer 2008:

http://members.ozemail.com.au/~mkuulma/ASPNet/eWAY-Picture.JPG

Apache 2.0.63/PHP 5.3.2/MySQL 5.1.44:

http://members.ozemail.com.au/~mkuulma/CRM/VTigerCRM-HomePage.tiff

http://members.ozemail.com.au/~mkuulma/Joomla/Joomla-vTiger-CommunityBuilder-EarlyDays-CRMLead.jpg

HYPERLINK "http://members.ozemail.com.au/~mkuulma/Joomla/MyFavourites_Joomla_5-3.tiff" \o "PHP/MySql CMS"

http://members.ozemail.com.au/~mkuulma/Joomla/MyFavourites_Joomla_5-3.tiff

http://members.ozemail.com.au/~mkuulma/Drupal/

http://members.ozemail.com.au/~mkuulma/Magento/

http://members.ozemail.com.au/~mkuulma/osCommerce/

http://members.ozemail.com.au/~mkuulma/Pivot/

HYPERLINK "http://members.ozemail.com.au/~mkuulma/Wordpress/" \o "PHP/MySql Blog"

http://members.ozemail.com.au/~mkuulma/Wordpress/

HYPERLINK "http://members.ozemail.com.au/~mkuulma/Frog/" \o "PHP/MySql CMS"

http://members.ozemail.com.au/~mkuulma/Frog/

Robert James Metcalfe – Curriculum Vitae

Robert James Metcalfe – Work Experience

Robert James Metcalfe – Work Experience