Randal McDonnell

Data Analytics Engineer/Modeller - Energy Industry

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.

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

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.

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.

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.

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

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.

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.

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.

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.

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.

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.

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