CURRICULUM VITAE

NAME:

METCALFE, Robert James

ADDRESS:

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

 

Ms. Maree Kuulma

Senior Legal Publishing Editor

Thomson Reuters

Telephone: (02)85877381

 

Ms. Kate Holz

Principal Partner

Adept Executive Solutions

Mobile: 0412 360 860

EDUCATION:

TERTIARY: University of NSW

Bachelor 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

 

 

 

PERSONAL WORK EXPERIENCE

 

RJM Programming

    November 2010 – Now:

                Date:

November 2010 - Now

                Position:

Computer Analyst/Programmer and Webmaster

 

            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

 

 

            What I Do:

        

                                 

. maintain http://www.rjmprogramming.com.au domain using Virtual Linux CentOS webserver

 

                   

.  undertake programming work for clients (eg. Thomson Reuters)

.  maintain personal blog with I.T. tutorials at Wordpress subdomain

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

.   maintain forum at Drupal subdomain

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

.   maintain

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

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

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

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

http://www.rjmprogramming.com.au/tikiwiki/tiki-index.php

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

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

.   CMS, eCommerce, eLearning advice regarding PHP/MySql products

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

.   face to face Computer Tuition

.   online Programming Learning website

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

.   Yahoo Answers Level 5

Yahoo Answers Account

.   Android Mobile Applications

                   https://play.google.com/store/apps/developer?id=RJM+Programming

.   LinkedIn marketing, sales, products

                   http://au.linkedin.com/company/rjm-programming

  

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.  

 

 

 

            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 Experience

 

Lateral 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*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.