Experience

Perth

• Australia
• Retail
• 1 - 100 Employee

• Software Developer - Oracle APEX, Oracle Forms, Oracle Reports

  • 2019 - Present

  - Software development of mission critical / high availability systems for a large organisation using Agile for project and BAU work. - Oracle APEX - development of mobile and desktop applications, APEX framework design, best practises and development standards - Oracle Forms and Oracle Reports - TECHNOLOGIES - Oracle APEX 5.1 to 20.2, Oracle Forms, Oracle Reports, SQL, PLSQL - Software development of mission critical / high availability systems for a large organisation using Agile for project and BAU work. - Oracle APEX - development of mobile and desktop applications, APEX framework design, best practises and development standards - Oracle Forms and Oracle Reports - TECHNOLOGIES - Oracle APEX 5.1 to 20.2, Oracle Forms, Oracle Reports, SQL, PLSQL



OnCall DBA

• Australia
• Information Technology & Services
• 1 - 100 Employee

• Senior Developer - Oracle Specialist

  • 2009 - Jun 2022

  • Oracle software development using Oracle Forms, Oracle Reports, Oracle APEX) * Performance tuning, data architect & system reviews for OnCall DBA customers • Technical lead and solution architect for a data warehouse focused on financial data from Oracle eBusiness Suite • Development of internal system for task management and customer billing using Oracle Application Express (ApEx) and Delphi • Oracle Database Administrator Technologies: Oracle database 9-21, SQL, PL/SQL, Oracle Application Express (APEX ), Oracle Warehouse Builder, Enterprise Architect, Delphi, Drupal Show less



Enterprise software developer in Perth, Western Australia

• Perth Area, Australia

• Enterprise software developer - Oracle specialist

  • 2012 - 2019

  • Software development and level 3 support for university computer systems based on Oracle technology • Technical lead for research, publications, grants and Callista student management system • Data integration with third party systems • TECHNOLOGIES - Oracle databases 10 to 19c - Oracle SQL, PLSQL - Oracle Application Express (APEX) for development of desktop and mobile browser applications to manage data for research, grants, publications, exams and course acceptance workflow. Performance tuning of APEX systems to reduce query response times from 60 seconds to 1 second - Oracle Forms and Oracle Reports for student management system customizations - Oracle Discoverer and BI Publisher for business reporting - Callista student management system - administration, custom software development and data integration Show less



Department of Commerce

• Technical Lead (contract)

  • 2008 - 2009

  • Technical Lead and data architect for project to enhance the Consumer Licencing and Complaints System (CALS) • Technologies: Oracle database 10gr2, Oracle Forms, Oracle Reports, SQL, PLSQL. • Technical Lead and data architect for project to enhance the Consumer Licencing and Complaints System (CALS) • Technologies: Oracle database 10gr2, Oracle Forms, Oracle Reports, SQL, PLSQL.



Bankwest

• Australia
• Financial Services
• 700 & Above Employee

• Data Warehouse - Data modelling and Performance Tuning (contract)

  • 2008 - 2008

  • Data modelling and performance tuning of an Oracle data warehouse focused on financial and sales data • Improved data warehouse reports runtime from one hour down to 10 seconds using query optimization techniques, materialized view layers and partitioning • Design and implement secure reporting layer optimized for high performance • Technologies Oracle database 10gr2, SQL, PL/SQL, Oracle Discoverer • Data modelling and performance tuning of an Oracle data warehouse focused on financial and sales data • Improved data warehouse reports runtime from one hour down to 10 seconds using query optimization techniques, materialized view layers and partitioning • Design and implement secure reporting layer optimized for high performance • Technologies Oracle database 10gr2, SQL, PL/SQL, Oracle Discoverer



Uniscape / Seeristic

• Software Product Manager and Lead Developer

  • 1997 - 2008

  • Team lead for DesignAssist add-on software for Oracle Forms and Oracle Designer • Software development of DesignAssist, Guardian and PowerUser products • Develop sales management system and customer issue tracking system initially using Oracle Forms and reports. The systems were redeveloped in Oracle Application Express (ApEx) to provide external web browser access • Software sales and marketing • Database administrator - Oracle 7 to 9 • Technologies : Oracle Designer, Oracle Forms, Oracle Reports, Oracle Developer, SQL, PL/SQL SQL (stored procedures, functions, packages, triggers), mod_plsql, Oracle E-Business Suite, Oracle Application Server, HTML, Javascript, Delphi, Java, Oracle Web DB (Oracle Portal) Show less



Oracle

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Systems Consultant and Instructor

  • 1991 - 1996

  Senior Principal at Oracle world corporate headquarters, USA Consulting and education instructor Oracle USA and Oracle Australia Pre-sales and technical consultant, Oracle Australia • Software development using Oracle technologies • Education instructor • System reviews, troubleshoot and performance tuning of Oracle databases and custom applications • Developed techniques to improve performance of client-server systems and 100% generation from Oracle Designer. Scott’s techniques were showcased by Oracle in seminars in the USA, England, Australia and Thailand. • Advisor to Oracle's internal software development groups • Technologies : Oracle Database 6-8, Oracle Designer / Oracle CASE, Oracle Forms 2.3 to 5, Oracle Reports, Oracle Discoverer, SQL, PL/SQL, Oracle E-Business Suite Show less