John Hall Email & Phone Number

Perth Wa

Canberra, Australia

Senior Applications Developer (Contract)Redeveloping large (200+ pages), complex Oracle ADF Faces 10g application in Oracle ADF Faces 12c.- Reviewing existing (Oracle) and reverse-engineering critical segment to provide logical database design diagrams.- Reviewing and analysing ADF 10g artefacts - ADF BC definitions, pages, backing beans, etc. - to establish the behaviours implemented and to identify, in particular, deprecated ADF constructs and Java code.- Translating… Show more Senior Applications Developer (Contract)Redeveloping large (200+ pages), complex Oracle ADF Faces 10g application in Oracle ADF Faces 12c.- Reviewing existing (Oracle) and reverse-engineering critical segment to provide logical database design diagrams.- Reviewing and analysing ADF 10g artefacts - ADF BC definitions, pages, backing beans, etc. - to establish the behaviours implemented and to identify, in particular, deprecated ADF constructs and Java code.- Translating 10g syntax, conventions to 12c equivalents.- Redesigning 10g elements to take account of 10g/12c changes or to take advantage of new 12c features/capabilities.-Re-implementing JavaScript functionality using native 12c features. -Creating the 12c implementations of the 10g user-interface elements. Show less

Canberra, Australia

Developing new application to support bio-security operations – specifically, Fruit Fly incursions into Northern Queensland.- Created logical database design for requirements associated with plant pest surveillance.- Creating Oracle BPM task user-interface artefacts employing Oracle ADF Faces and Web Services (SOAP).- Creating and maintaining Oracle APEX 5 user interfaces.- Developing PL/SQL entity APIs and utilities.- Oracle 12c database design.- Creating REST-enabled… Show more Developing new application to support bio-security operations – specifically, Fruit Fly incursions into Northern Queensland.- Created logical database design for requirements associated with plant pest surveillance.- Creating Oracle BPM task user-interface artefacts employing Oracle ADF Faces and Web Services (SOAP).- Creating and maintaining Oracle APEX 5 user interfaces.- Developing PL/SQL entity APIs and utilities.- Oracle 12c database design.- Creating REST-enabled ADF BC services.- Created Oracle MAF 2.3 proof-of-concept mobile application.- Designed and developed data migration/take-on suite to migrate legacy data from delimited files and MS Access and SQL Server databases. Show less

Geelong, Victoria, Australia

Developing and maintaining Oracle ADF 11g application elements as part of a strategic transition from the Oracle Forms to the Oracle ADF Faces technology stack.- Creating and extending ADF BC Model-layer Entity and View components utilising legacy PL/SQL APIs;- Creating ADF Faces view-layer user interface components and applications;- Creating new PL/SQL API packages to implement business rules;- Supporting and maintaining ADF applications rolled out to clients - resolving… Show more Developing and maintaining Oracle ADF 11g application elements as part of a strategic transition from the Oracle Forms to the Oracle ADF Faces technology stack.- Creating and extending ADF BC Model-layer Entity and View components utilising legacy PL/SQL APIs;- Creating ADF Faces view-layer user interface components and applications;- Creating new PL/SQL API packages to implement business rules;- Supporting and maintaining ADF applications rolled out to clients - resolving issues identified by clients and assessing impact of solutions;- Supporting and maintaining Oracle Forms application elements;- Tuning ADF, PL/SQL and SQL application elements;- Creating standards and procedures to improve support and maintenance practice;- Software configuration management (Subversion) and release administration;- Conceived and created procedures to document internal Support protocols - "How-Tos"​.Leading the Senior Developers'​ Group - a forum tasked with pioneering ADF development best practice and conceiving new approaches and techniques;- Wrote paper to assist in developers'​ transition from Oracle Forms and PL/SQL to Oracle ADF Faces development;- Presenting advice, ideas and instruction to the wider Callista developer community;- Developing and refining user-interface concepts and standards - delivered as "Technology Chronicles"​.Designing and developing generic ADF applications to address common requirements.- Designed and created prototype generic ADF application to provide common user-interface for multiple (> 150) code-expansion tables (accomodating > 10 table signatures);- Designed and created generic, reusable ADF application component to support the maintenance of user-defined data.Designing and developing novel user-interface patterns.- Designed and created prototype ADF Faces tree-based UI to maintain hierarchical data - "record explorer/navigator". Show less

London, United Kingdom

Enabling the transfer of MPS data to the new Police National Database. Designing and creating infrastructure to generate and transfer 40 million + XML documents.- Conceived and implemented architecture based around Oracle XMLDB and Oracle Streams AQ to permit initial development of XML interface services on interim technical environment.- Consulting with MPS officers to determine scope and business rules governing national data sharing via the Police National Database - Developing… Show more Enabling the transfer of MPS data to the new Police National Database. Designing and creating infrastructure to generate and transfer 40 million + XML documents.- Conceived and implemented architecture based around Oracle XMLDB and Oracle Streams AQ to permit initial development of XML interface services on interim technical environment.- Consulting with MPS officers to determine scope and business rules governing national data sharing via the Police National Database - Developing Java stored procedures to import and unzip archived XML datagrams- Designing and creating XML Schema definitions to validate source XML documents, using Altova XMLSpy 2011- Using Oracle Streams AQ to implement a high-throughput asynchronous, multi-threaded queue infrastructure - Developing XSLT stylesheets using Altova MapForce 2011- Using XML/SQL to generate XML documents directly from relational data- Designing and implementing management console using Oracle Apex 4.0- Designing and developing XML document management infrastructure using Java, PL/SQL, Oracle XML DB and Oracle 11gR2- Developing Java stored procedures to assemble individual XML datagrams into batches and output to file transfer infrastructure Show less

Welwyn Garden City, Hertfordshire, Uk

Facilitating the timely processing of CRB vetting requests.- Enhancing the CRB data consolidation repository to include suspect information and executing its migration to Oracle10gR2.- Developing a new interface using UTL_FILE to consume delimited files generated from additional source systems.- Enhancing a thin-client search application using Oracle Web PL/SQL.- Migrating the complete solution from Oracle8i to Oracle Database 10g R2.

Potters Bar, Hertfordshire, Uk

Re-engineering the core business applications suite.- Migrating business application interface components from the Oracle Forms technology stack to Oracle ADF Faces, pioneering the use of ADF Faces Rich Client.- Creating a business components layer based on existing database schema objects- Developing framework extension classes to provide common functionality and behaviours- Designing and implementing ADF Faces pages built upon the ADF BC model layer - initially with JDeveloper… Show more Re-engineering the core business applications suite.- Migrating business application interface components from the Oracle Forms technology stack to Oracle ADF Faces, pioneering the use of ADF Faces Rich Client.- Creating a business components layer based on existing database schema objects- Developing framework extension classes to provide common functionality and behaviours- Designing and implementing ADF Faces pages built upon the ADF BC model layer - initially with JDeveloper 11g TP4 - and subsequent migration to JDeveloper 11g Production Release- Using clear and flexible communication skills to transfer knowledge to the in-house team Show less

Birmingham, United Kingdom

Facilitating Campus-wide access to key HR Services.- Designing and developing secondary user-authentication regime for new Oracle ADF Faces intra/extranet-deployed HR application, based on a PL/SQL API verifying user credentials stored in one-way encrypted form in Oracle relational tables.- Designing complex "opt-in" security solutions with registration/activation protocol for new users and preparing design submission.- Designing and creating Oracle 10g database schema to support… Show more Facilitating Campus-wide access to key HR Services.- Designing and developing secondary user-authentication regime for new Oracle ADF Faces intra/extranet-deployed HR application, based on a PL/SQL API verifying user credentials stored in one-way encrypted form in Oracle relational tables.- Designing complex "opt-in" security solutions with registration/activation protocol for new users and preparing design submission.- Designing and creating Oracle 10g database schema to support the security mechanism.- Developing user-interface components employing ADF/BC and ADF Faces to manage account activation, sign in/out, PIN changes, etc. Show less

Nottingham, United Kingdom

Supporting the CapitalOne Card Infrastructure Strategy migration programme.- Designing and developing queuing infrastructure to support interfaces between the Affinium EMM suite, Teradata operational databases and third-party TSYS/TS2 card-processing services, requiring the design and creation of Oracle10g and Teradata schema objects, PL/SQL and Teradata SPL stored procedures.- Preparing the technical design submission for the Teradata/Oracle interface and queuing infrastructure.-… Show more Supporting the CapitalOne Card Infrastructure Strategy migration programme.- Designing and developing queuing infrastructure to support interfaces between the Affinium EMM suite, Teradata operational databases and third-party TSYS/TS2 card-processing services, requiring the design and creation of Oracle10g and Teradata schema objects, PL/SQL and Teradata SPL stored procedures.- Preparing the technical design submission for the Teradata/Oracle interface and queuing infrastructure.- Designing and implementing Oracle 10g database and Teradata schema.- Developing PL/SQL server-side data extract and transformation modules and "queuing engine".- Designing and developing Teradata SPL validation suite. Show less

St Neots, Cambridgeshire, Uk

Supporting brand new marketing initiatives, in particular those associated with Oracle-based products, solutions and services.Projects included:- For the MoD, designing new XML schema using Altova XMLSpy 2006 and developing PL/SQL server-side modules to generate conforming XML datagrams from database contents (Oracle10g).- For Mass Consultants, developing thick-client application utilising Oracle ADF JClient (JDeveloper 10.1.3.1) accessing highly generic Oracle10g schema structures… Show more Supporting brand new marketing initiatives, in particular those associated with Oracle-based products, solutions and services.Projects included:- For the MoD, designing new XML schema using Altova XMLSpy 2006 and developing PL/SQL server-side modules to generate conforming XML datagrams from database contents (Oracle10g).- For Mass Consultants, developing thick-client application utilising Oracle ADF JClient (JDeveloper 10.1.3.1) accessing highly generic Oracle10g schema structures via complex table function views and Instead-Of triggers.- For Mass Consultants, jointly architecting and designing database and user-interface for in-house product.- For a UK Police Force, designing and developing thin-client search application and associated data-consolidation database, drawing data from heterogeneous databases (Oracle, Reality, SQL Server) and employing Oracle Application Server 10g, mod-PL/SQL and Heterogeneous Connectivity services.- For the MoD, designing and developing Intranet-deployed Oracle Forms application to manage IT asset records.- For a UK Police Force, creating a highly secure client-server application to record covert intelligence material.- For BAe Systems, carrying out a scoping study to define support systems and technical architectures for aviation operations on the proposed RN Future Carrier Vehicles. Show less

London, United Kingdom

Head of Database Group- Establishing a new database team in advance of the migration from SQL Server-based to Oracle-based solutions.- Recruiting and managing the new staff members, clarifying role, ensuring adequate shared knowledge and directing the necessary database development work and generation of associated standards and utilities.- Determining appropriate architectures for Oracle-based site development.- Designing and creating Oracle 10g schema using ERWin.-… Show more Head of Database Group- Establishing a new database team in advance of the migration from SQL Server-based to Oracle-based solutions.- Recruiting and managing the new staff members, clarifying role, ensuring adequate shared knowledge and directing the necessary database development work and generation of associated standards and utilities.- Determining appropriate architectures for Oracle-based site development.- Designing and creating Oracle 10g schema using ERWin.- Developing PL/SQL, Java and T-SQL server-side code and assisting with the shift to Java/XML technologies. Show less

Cambridge, United Kingdom

The Y2K Examination Processing Systems redevelopment.- Project-managing the full development life cycle of the ad hoc payments tracking system, from initial scope through to final testing and support.- Designing and developing Oracle database schema, Oracle Forms modules, Oracle Reports, server-side business processes in PL/SQL and table API modules.

Brisbane, Australia

Creating the new Core Land Database and application.- Pioneering the use of Oracle Forms Generator.- Creating standards and templates to support the use of Oracle Forms Generator.- Designing and generating Oracle Forms (4.5) modules and associated PL/SQL API.- Designing and implemented "bridge-back" interface to legacy system employing bespoke asynchronous messaging protocol and dynamic PL/SQL procedure calls.

Brisbane, Australia

Creating development standards for the new RTA Reporting system.- Oracle Forms 4.5 and Oracle Reports 2.5 development- Server-side PL/SQL development- Oracle Designer standards development

Melbourne, Australia

Migrating the Trading application from SQL-Forms 3.0 to Oracle Forms 4.5.- Oracle Designer reverse-engineering- SQL-Forms 3.0 to Oracle Forms 4.5 migration- Oracle7 server-side PL/SQL development

Melbourne, Australia

SQL-Forms to Oracle Forms 4.0 Migration.- SQL-Forms 3.0 development- Oracle Forms 4.0 development- Oracle7 server-side PL/SQL development

Melbourne, Australia

Establishing and managing the Data Administration function.- Strategic systems planning and high-level business modelling.- SQL-Forms 3.0 and SQL-Menu 5.0development.- Oracle 5/6/7 schema design.- Oracle CASE-Dictionary and CASE-Generator development and administration.- SQR development.- Development standards authoring.

Graduate Diploma, Computing

Bsc, Biochemistry