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
|
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 |
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. |
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 |
|
|
|
and MySQL.
Much of the work involves content |
|
management systems such as Mojo
portal,
Joomla and |
|
|
|
|
|
. 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. |
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 |
|
|
|
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 |
|
|
|
PHP, Perl (exposure), Domain Name |
|
Administration websites for
friend |
|
NB
May 2007: Learn ASP.NET Framework/C#/SQL
Server/Cassini |
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 |
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’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 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. |
|
|
|
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. |
|
|
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. |
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. |
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. |
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. |