Randal McDonnell

Basic

Freelancer/Self-employed, Oracle DBA Consultant, SAS Institute

Melbourne, Australia

Skills

Oracle
UNIX
PL/SQL
Talend ETL
Data warehousing
TKPROF
Oracle 11g
Pro*C
Perl
OWB (Oracle Warehouse Builder)
Oracle Retail - Retek
TOAD
LINUX
C++
Object Orientated
Architectural work
BI Publisher
Jenkins
DevOps

Timeline

Professional experience for Randal McDonnell

  • Current 5 years and 7 months, since Apr 2016

    Oracle DBA Consultant

    SAS Institute

    Database consultant for analytics implementation at Origin Energy

  • Current 6 years and 10 months, since Jan 2015

    Database Developer

    Experian

  • Current 26 years and 6 months, since May 1995

    Software Consultant

    Somerled

  • 8 months, Feb 2014 - Sep 2014

    Analyst Programmer

    Coles Australia

    Application software deployment and environment management. Environments include 1.Data warehouse applications and technologies such as Microstrategy, Narrowcast, EXADATA . 2.Logistics Applications, Transport management and optimization, Warehouse Management etc. 3.Retail Applications, such as Oracle Retail suite 4.Oracle databases.

  • 4 years and 9 months, Dec 2008 - Aug 2013

    Senior Developer

    Media-Saturn IT Services GmbH

    Responsibility for Design and Development of Conversion and Support to Oracle Retail. Utilsed Talend ETL software. Also Design, Support and Development of current Unix/Oracle Solid and Linux systems

  • 8 months, Nov 2007 - Jun 2008

    IT consultant (System Analyst Programmer)

    University of Melbourne

    Assist with the design and development of a new Data warehousing system to assist University understand their business better. Primarily technical and business design, code, performance, unit and system test of OWB(Oracle Warehouse Builder) mappings, PL/SQL & UNIX korn and bash shell code on Sun UNIX and Linux based environment on Oracle 10g. Involvement building all levels of ETL(Extract, Transform and Load). Understanding of Education administration systems including Themis.

  • 1 year and 10 months, Sep 2005 - Jun 2007

    Consultant - Senior Anlyst Programmer Conversion

    Myer Australia

    On mymerch project to design , development and successful implement of their new retail administration system, Oracle Retail - Retek at Myer (largest Australia based retailer) in Melbourne, Australia. Primarily large amounts of design, code, performance & unit test of both and PL/SQL, UNIX scripting, and Pro*C code on AIX UNIX based environment on Oracle 10g. Code was for conversion of existing Myer systems. Significantly involved with analysis and design. Involvement in conversion strategies and plan.

  • 5 months, May 2005 - Sep 2005

    IT Consultant - System Analyst Programmer

    SuperPartners, Melbourne

    Assist with the design and development of a new Data warehousing system to be sold to a Client. Primarily technical and business design, code, performance, unit and system test of PL/SQL & UNIX korn shell code on HP-UX UNIX based environment on Oracle 9i. Involvement building upload to SQL Server and then staging and loading within SQL Server. Understanding of SuperPartners administration system and Clearcase gained.

  • 8 months, May 2004 - Dec 2004

    Consultant Analyst Programmer

    Gen-i New Zealand

    Assist with the re-design and development of 3 Air New Zealand’s systems, working in Auckland, New Zealand. Primarily large amounts of technical design, code, performance, unit and system test of PL/SQL & UNIX korn shell code on SUN Solaris UNIX based environment on Oracle 8.1.7.4. Some involvement with implementation strategy. The three system were 1- the engine for online bookings which was adapted to handle partner airlines; 2- The rewards program administration; 3- The Agent Payroll system was revap

  • 9 months, Mar 2003 - Nov 2003

    Consultant Analyst Programmer

    Cap Gemini New Zealand

    Assist with the re-design and development of Air New Zealand’s data warehousing system working in Auckland, New Zealand. Primarily large amounts of architectural design, technical design, code, performance & unit test of PL/SQL & UNIX korn shell code on SUN Solaris UNIX based environment on Oracle 8.1.7.4. Also utilised Oracle Transportable Tablespaces and Infomatica tool. Significantly involved with implementation strategy.

  • 7 months, Aug 2002 - Feb 2003

    Consultant System Analyst Programmer

    Air New Zealand

    Assist with the re-design and development of Air New Zealand’s rewards program administration system, Air Points working in Auckland, New Zealand. Primarily large amounts of design, code, performance & unit test of PL/SQL code on SUN Solaris UNIX based environment on Oracle 7.3. Code was both for interfacing with Web based systems and enhancement/alterations of their in-house call centre system. Significantly involved with technical design.

  • 4 months, Sep 2001 - Dec 2001

    Consultant System Analyst Programmer

    JDA Australia

    Assist with the Grocery design and development of their retail administration system, ODBMS at Jusco/AEON (large Japan retailer) working in Tokyo, Japan. Primarily large amounts of design, code, performance & unit test of PL/SQL code on SUN Solaris UNIX based environment on Oracle 8i. Code was both for interfacing with existing Jusco (IBM based) systems and enhancement/alterations of ODBMS. Significantly involved with design.

  • 1 year, Oct 2000 - Sep 2001

    Consultant System Analyst Programmer

    JDA Australia

    Aassist with Phase 1 design and development of their retail administration system, ODBMS at Myer Grace Brothers (largest Australia based retailer) in Melbourne, Australia. Primarily large amounts of design, code, performance & unit test of both Pro*C and PL/SQL code on AIX UNIX based environment on Oracle 8i. Code was both for interfacing and conversion of existing MGB systems. Significantly involved with analysis and design. Involvement in conversion strategies and plan.

  • 3 months, Jul 2000 - Sep 2000

    System Analyst Programmer

    Scottish Power

    Assisted with on-going enhancements to de-regualtion system for Scottish Power in Glasgow, U.K. Primarily large amounts design, code and test of PL/SQL code on UNIX based environment. Significantly involved with analysis and design. Small exposure to Perl with Oracle links, Sqlloader and Designer 2000.

  • 3 months, Apr 2000 - Jun 2000

    IT Consultant

    iwant2be.com

    Rrecommend hardware and software strategies for short, medium, and long term. Liase with outsourcing, hosting, software and ISP companies as well as internal HTML programmers. Also wrote business functional and data design specifications for the first 3 web pages for initial release. Begin initial UML designs. On-going part-time consultancy.

  • 2 years and 3 months, Oct 1997 - Dec 1999

    IT Consultant - System Analyst Programmer

    PwC (San Francisco, USA)

    Maintain and enhance 3 similar Imaging systems on HP9000 Unix boxes. The system also belonged to State Compensation Insurance Fund(SCIF). Responsible for large amounts of coding in Pro*C, PL/SQL, database procedures/triggers and Reports in Developer 2000. I was also largely involved in design, project management and implementation strategies including the system upgrades from 7.3 to 8.04. The system was used for storage of claim and policy document images on optical disks. These systems utilised Plexus’ sof

Educational background for Randal McDonnell

  • 4 months, May 1995 - Aug 1995

    Monash University

Languages

  • English

    First language

  • German

    Fluent

  • Spanish

    Basic

Wants

Expanding Oracle
UNIX
PL/SQL
Tools
Data warehousing
Oracle Retail - Retek
LINUX
Architecture experience. Fun and results at work!

Interests

Sport
Cricket
Australian Football
Water Polo
Golf
Humour
Rock 'n' Roll
Playing Guitar

Browse over 18 million XING members