| |
Personal Resume of [snip],
Bachelor of Information Technology
IT Consultant,
Systems Analyst, Developer, Trainer and Multimedia Specialist
Citizenship
Australian and
Italian (EU)
Curriculum Vitae
Summary
Paul has 10 years
of experience in the Information Technology industry. Having
completed the Bachelor of Information Technology with a credit
average, Paul first worked in a number of application
development roles at Macquarie Bank, a leading Australian
investment bank.
Since October 2000
Paul has worked with a variety of clients in the
telecommunications, media, finance and government sectors in
both Australia and the United Kingdom. Paul recently completed a
project at a new and growing business within Macquarie Bank.
An eye for detail
and an ability to generate creative and effective solutions make
Paul an ideal candidate for teams with demanding projects. He is
a high achiever, leaving high school with a NSW state ranking of
99.60 and having successfully worked on both high profile and
specialised projects. Paul has very strong SQL Server, Visual
Basic, data warehouse, Peoplesoft Financials and PowerBuilder
development and support skills.
Work Experience
Summary
More details are
available on the following pages.
|
2004 - 2005 |
[snip]Australia
Mortgage
Securitisation – Analyst, Developer, Consultant
Portfolio
Management – Analyst, Developer, Consultant |
Contract
6 months (current)
6 months
|
|
2003 |
Trinity
Mirror plc UK
Regional Newspapers Advertising
Data Warehouse – Developer, Trainer, Administrator |
Permanent
9 months |
|
2002 |
AAPT
Australia
Business Sales – MIS Developer |
Contract
1 month |
|
Fujitsu
Services UK,
on site at Lewisham Borough Council
Rollout Project - Manager and Support Analyst |
Contract
9 months |
|
Kyunet
Australia
Multimedia
application – [Video] Post-production |
Contract
1 month |
|
2001 |
Australian
Nuclear Science and Technology Organisation
Multimedia
presentation – Post-production and installation |
Contract
1 month |
|
PeopleDirect Australia
Procurement systems – Developer, Consultant |
Contract
3 months |
|
1995 - 2000 |
Macquarie
Bank Ltd Australia
PeopleSoft
Financials – Analyst, Developer+ (2 years)
Equities Research – Analyst, Developer+ (3½ years) |
Permanent
5½ years |
Technical Experience
|
Development Languages |
Years of
Involvement |
|
Visual Basic
ADODB,
ActiveX, GUI, COM |
10
|
|
Transact-SQL
/ SQL Server (Sybase, Microsoft)
Stored
Procedures, Triggers, etc |
7
|
|
Excel and
Access VBA |
7 |
|
PowerBuilder |
4 |
|
Word VBA |
2 |
|
VBScript |
1 |
|
HTML |
1 |
|
Java |
0.5 |
|
VB.NET |
0.5 |
|
C# |
0.5 |
|
XML |
0.5 |
|
JavaScript |
0.5 |
|
Relational Databases |
Years of
Involvement |
|
Sybase
SQL/Adaptive Server |
7 |
|
Microsoft
SQL Server |
4 |
|
Oracle |
1 |
|
Peoplesoft Technical |
Years of
Involvement |
|
PeopleTools,
PeopleCode |
2.5 |
|
SQR |
2.5 |
|
Crystal
Reports |
2 |
|
COBOL/Application Engine |
1 |
|
nVision |
1 |
|
Operating Systems |
Years of
Involvement |
|
Unix / SunOS
/ Solaris |
6 |
|
Windows
NT/2000/XP |
6 |
|
Windows
Other |
9 |
|
Novell
Netware |
3 |
|
Citrix
MetaFrame |
1 |
|
Applications/Utilities |
Years of
Involvement |
|
Microsoft
Office Suite |
10 |
|
PeopleSoft
Financials GL, AP, AM |
2.5 |
|
ABC
Flowcharter |
2.5 |
|
Business
Objects & BI Query (GQL) |
2 |
|
Microsoft
Exchange |
2 |
|
Microsoft
Project |
2 |
|
Adobe
Premiere |
2 |
|
Adobe
Photoshop |
2 |
|
Remedy
Action Request (Help desk) |
2 |
|
Rational
Rose (Object Modelling) |
1.5 |
|
Microsoft
IIS |
1 |
|
Symantec
Ghost (Cloning PC builds) |
1 |
|
Dimension
Insight Diver/Atlantis |
1 |
Work
Experience Details
Since October 2004,
Paul has been contracted to Macquarie Securitisation
Ltd/Macquarie Bank Ltd as an Analyst/Developer/Consultant. The
majority of this work relates to their core mortgage management
system. Further details are available upon request.
Company |
Macquarie Bank Ltd (Australia) |
|
Role |
I.T.
Consultant to Private Portfolio Management (MPPM)
Application Analyst and Developer (Full Lifecycle) |
|
Period |
6 months
(April to September 2004) |
|
Duties |
·
Development
of an automated portfolio optimisation and rebalancing
application for a Separately Managed Accounts,
discretionary trading business.
·
Requirements clarification, prototyping and
documentation.
·
Test
planning and coordination.
·
Technical
reference and user guide documentation.
·
General
technical, Excel spreadsheet and business process
consultation.
·
Development
in Microsoft Visual Basic and Sybase
Adaptive Server.
·
Integration
with IRESS Market Technologies and
in-house systems. |
Company |
Trinity Mirror plc, UK |
|
Role |
Project
Manager, Business Analyst, Lead Developer, Trainer
Data
Warehouse UK Rollout – Regional Newspapers, Advertising |
|
Period |
9 months
(May 2003 to January 2004) |
|
Duties |
·
Successful
end-to-end production and deployment of a nationwide
OLAP application and data warehouse for business
intelligence
(allowing bespoke analysis of group-wide advertising
sales data).
·
Evaluation
(including cost-benefit analysis) of alternative
suppliers.
·
Presentation of proposals to and consultation with local
management.
·
Liaising
with developers at regional sites performing ETL
operations.
·
Building of
a Microsoft SQL Server 2000 application
including an automated DTS solution with
VBScript, Excel and Access VBA
and Microsoft Visual Basic.
·
Assisting
developers and expert users with interfaces to source
and destination systems (including PBViews
Business Intelligence software).
·
Populating
the DI Diver OLAP application for end-user
bespoke reporting.
·
Formal
training of expert and secondary users.
·
Application
support of the MIS and other group products.
·
Consultation services to other MIS projects.
·
Purchasing
software and hardware for the local office.
·
General IT
support and consulting for the local office.
|
|
Company |
Trading as
Espresso Design in Australia and
Sybersolve Solutions in the United Kingdom |
|
Role |
Analyst,
Developer, Project Manager, Support and Multimedia
Specialist |
|
Period |
24 months
(November 2000 to November 2002) |
|
Duties |
·
IT infrastructure and business process consulting.
·
Full system development lifecycle, end-to-end
implementations.
·
Middleware and software implementation project
management.
·
Multimedia production including video post-production.
Clients
·
Combined Management Consultants Pty Ltd Australia
(2002)
Design and build of an application to calculate and
report commissions for sales staff at AAPT
Business Sales (a telecom) using Access
and Excel VBA, ActiveX,
Business Objects.
·
Kyunet Australia (2002)
Preparation of multimedia for web based language
training using Adobe Premiere.
·
Fujistu Services (formerly ICL), UK (2002)
On site at
London Borough of Lewisham (local government)
-
Integrating Lewisham Council and Fujitsu Services
networks via an
RSA Security Virtual Private Network (VPN)
and rollout of client software.
-
Rollout
and client support of financials software including
Oracle Financials 11i
and associated prerequisite software.
-
Support
of all council and sundry PC users across all
divisions and departments.
-
Establishment of a technical reference intranet
server for the team of support personnel using
Microsoft IIS 2000.
·
PeopleDirect Australia (2000 – 2001)
Integration of client’s MS SQL Server and
Visual Basic 6 based procurement system
with accounting software and reporting tools for
provision of services to Mayne Health Private Hospital
Catering.
·
ImplementationSoft Pty Ltd Australia (2000 – 2001)
Analysis of requirements and preparing upgrade
infrastructure proposals for a number of
PeopleSoft clients.
·
ANSTO (Australian Nuclear Science and Technology
Organisation, 2001)
Assembly of Open Day video display exhibit, video
editing and production, image editing and associated
slide preparation using Adobe Premiere,
Photoshop and MS Powerpoint.
|
Periods
between client engagements have been used for personal travel.
|
Company |
Macquarie Bank Ltd (Australia) |
|
Role |
Analyst
Programmer – PeopleSoft Technical |
|
Period |
2 years 3
months (Jul 1998 to Sep 2000) |
|
Duties |
·
Systems analysis, design and development.
·
Implementation,
QA, testing, change management
and upgrades.
·
Team player developing new and customised PeopleSoft
modules.
·
Overnight
processing and scheduling of batch processing.
Support and automated checking through HTML notification
alert scripts.
Functional
·
General
Ledger journal entry, validation, posting and
reconciliation.
·
Foreign
currency balancing processes.
·
Development
of interfaces to bank-wide systems.
·
Lead
development in Excel/Access VBA based
modules and SQL stored procedures for bulk data entry.
·
Sole
development of Visual Basic components for
generic Excel to Sybase SQL Server
connectivity.
·
Support and
enhancement of the GQL (now BI Query)
bespoke reporting tool.
·
Accounts
Payable and Asset Management customisation of supplier
entry, invoice entry and journal entry.
·
Remittance
processing including HTML messaging and Crystal
Reports.
·
Asset
depreciation expense journal entry.
|
|
Role |
Analyst
Programmer – Equities |
|
Period |
3 years 6
months (Jan 1995 to Jul 1998) |
|
Duties |
·
Full system development lifecycle of multiple
applications.
·
Project and
small development team management
Functional
·
Quantitative Financial Analysis and Equities Research
·
Development
of a platform processing market analysts’ forecasts
using Microsoft Excel and Access
VBA
and Visual
Basic,
Sybase SQL Server and PowerBuilder.
·
Consulting
to other development teams in Equities for multiple
projects including a CMS and a geared portfolio
management system. Also supported the Settlements and
Back Office reporting application incorporating
Fujitsu/Oracle Broker.
|
Professional Education
·
Dimensional Insight Diver, ProDiver, Atlantis/DiveLine,
Integrator
(an end-to-end data warehouse and MIS client software package)
·
Sybase System 10 (SQL Server)
conducted at the Sybase training centre in Sydney
Fast Track to
Sybase
Sybase Performance
and Tuning
·
Object-Oriented Modelling and Design
conducted by Class Technology in Sydney
·
Introduction to Java Programming
conducted by Class Technology in Sydney
·
PeopleSoft
conducted at the Peoplesoft training centre in Sydney
PeopleTools I and
II
PeopleCode
SQR
GL and AP
(conducted internally at Macquarie Bank)
·
Sybase PowerBuilder
conducted by Client Server Professionals at Macquarie Bank in
Sydney
Introduction to
PowerBuilder
Performance, Tuning
and Techniques
Managing
Performance in PowerBuilder V4.0
Mastering
Datawindows
Object Oriented
Design with PowerBuilder
Academic Background
·
Bachelor of Information Technology with Credit, 1994
University of Technology, Sydney (Australia)
Weighted Average Mark of 74.90
Core disciplines: Management, Finance, Analysis, Design,
Programming and Mathematics.
Industrial semesters at Macquarie Bank and Computer Sciences
Corporation
Development using
Visual Basic,
Excel
Visual Basic for Applications
and
Sybase SQL Server
·
Higher School Certificate, 1991
New
South Wales, Australia
Tertiary Entrance Rank of 99.60
Core studies: 4 Unit Mathematics, Physics, Chemistry, Computing
Studies and English
References
|