mysql

Java Persistence API (JPA)

Webel employs the Java Persistence API (JPA) as the core database technology for Enterprise Java web application development in combination with JPA-compliant object-relational database mapping technologies (EclipseLink and Hibernate) for relational database management systems (MySQL, Oracle DB), as well as in combination with the JPA-compliant pure-object database ObjectDB. Core JavaServer Faces (JSF) and the PrimeFaces 3rd-party JSF GUI toolkit are used to create rich interactive web worksheets for Enterprise Java web applications from data and objects served via JPA and managed via Enterprise Java Beans employing Expert System strategies:

For demonstrations and examples, please visit the tutorial presentations and demonstration videos of the GreenDesk web application for modelling and environmental compliance tracking of office buildings, developed by Webel for GreenSoft.

Drupal CMS web site developer and administrator

When
03/03/2016 - 16/03/2016
Organisation(s)

Further development of the Research Ambassador & Mentoring Programme site for the Deutscher Akademischer Austauschdienst (DAAD) [German Academic Exchange Service] and Australian Association of von Humboldt Fellows. Included migration to a secure Virtual Private Server (VPS).

(The site was initially developed as a DAAD alumni community contribution by Webel IT Australia between 2013-2015, as Dr Darren was a DAAD scholar during his research into supernovae and astrophysics at the University of Heidelberg (Karls-Ruprecht Universität) in Germany from 1989 to 1990.)

IT Consultant: software architect, systems analyst, Enterprise Java web application developer, Drupal CMS web site developer

When
17/01/2011 - 09/02/2014
Organisation(s)
Role(s)
IT Consultant, Domain Analyst, Requirements Analyst, Drupal CMS Web Developer
Tasks

Developed a unique JavaEE web application GreenDesk for analysing and tracking the complex data and documentation required for preparing applications compliant with the Green Star Office sustainable building rating system of the Green Building Council of Australia (GBCA).

The system uses Expert System technology in Java as an intermediary between rich interactive web user interface worksheets and model views using JavaServer Faces (JSF), and an underlying Enterprise Java domain entity database model - the Building Project Model, created using Parsing Analysis technology to map the Green Star Office specifications to domain model elements and rules.

After initially using an MySQL database with object-relational Java Persistence API (JPA) mapping with EclipseLink, then an object-relational Oracle DB with EclipseLink, a major migration was made to a JPA-compliant pure-object database ObjectDB, with significant improvements.

The PrimeFaces toolkit for JavaServer Faces (JSF) was used to enhance the rich web user interface.

The software engineering included frequent use of graphical Unified Modeling Language (UML) for requirements and domain analysis, model-driven Java design, Java code refactoring, documentation, and even proved useful for freestyle graphics presentations for non-experts. The closely related Systems Modeling Language (SysML) heavily influenced the Building Project domain model.

Custom object-oriented PHP scripting was used to generate Enterprise Java database entity classes directly from a Drupal CMS web site entity-relational database model of the Green Star Office technical manual’s specification for the green office building rating system of the Green Building Council of Australia (GBCA). Such novel and advanced automation of coding is a speciality of Webel IT Australia.

Drupal CMS web site development: Developed a GreenSoft company web site, a web site for the GreenDesk product, and the GreenBase site for resources on global environmental rating schemes.

Prepared investor presentations and held pitch meeting demonstrations for potential investors. Demonstrations included screencast tutorial videos made using ScreenFlow.

Created 3D logos and animated 3D logos using Swift3D.

For demonstrations and examples, please visit the tutorial presentations and demonstration videos of the GreenDesk web application for modelling and environmental compliance tracking of office buildings, developed by Webel for GreenSoft Pty Ltd, Australia.

GreenSoft Pty Ltd, Australia

Type of organisation
Company
Where
Sydney, Australia
Role(s)
IT Consultant, Software Architect, Enterprise Java Developer, Web Developer, Domain Analyst, Requirements Analyst, Systems Analyst, Database Engineer
For demonstrations and examples, please visit the tutorial presentations and demonstration videos of the GreenDesk web application for modelling and environmental compliance tracking of office buildings, developed by Webel for GreenSoft.

IT Consultant: software engineer, systems engineer, web developer

When
27/07/2010 - 16/02/2011
Organisation(s)
Role(s)
software engineer, systems engineer, web developer
Tasks

Performed domain analysis using UML Parsing Analysis (sentence-by-sentence mapping of technical text to UML relational and graphical models) of the Green Star Office v3 rating tool spreadsheets into an entity-relationship model and object-relational database representation, using a SysML-like model of domain elements: blocks, attributes, value types, quantities, parts, activities.

Developed a PHP-driven Drupal content management system as a Project Tracking CMS, including a relational parsing analysis of the GBCA Green Star Office v3 rating tool spreadsheets into a cross-navigable domain analysis entity-relationship model. Includes a representation of the credit groups of the Green Star process as activities allocated to human resources.

Performed demonstrations of the developmental ecoSmart web application concept to stakeholders, candidate users, and investors.

Consultant: Drupal CMS web site development and PHP scripting for systems engineering resources web site for international training organisation

When
04/09/2009 - 01/06/2010
Organisation(s)
Role(s)
IT Consultant, Drupal CMS and PHP web developer
Tasks

Large web site redevelopment project. Migrated old file-based web site to a new rich metadata-driven Drupal CMS web site, with 1000s of web pages of systems engineering and software engineering resources.

Developed dozens of custom PHP style templates for fine control over serving of custom Drupal page types.

Developed 100s of custom Drupal query views for presentation of linked metadata. Developed custom query views with filters for searches for documents, organisations, definitions, and people.

Cascading Style Sheet (CSS) styling of all aspects of the site, including the site container and formatting of query views.

MySQL database administration. Developed low-level SQL queries to automate administration tasks and data migration.

Developed substantial PHP scripts, employing fully object-oriented PHP technology, against Drupal's PHP node APIs to automate migration of data, and for administration tasks. Developed a PHP script for generation of a "static" offline version of the site directly from the online version.

Content processing: incorporated hundreds of systems engineering document into the developed Drupal CMS system, extracting document metadata, identifying engineering keywords, and creating linked relationships to other documents, authors, organisations, publishers, and journals.

Administration of the Drupal site, including implementation of fine-grained access controls for different user levels.

Developed an engineering glossary system with filtered search facilities.

Advised on use and integration of LDAP directory technology for managing existing legacy customer and client login data.

Developed educational screencasts demonstrating the sites features, including video and audio editing and voiceovers.

Dr Darren Kelly's online Web Technologies résumé

Please click here to download a printable PDF version of a concise Web Technologies résumé version of the full career Curriculum Vitae of Dr Darren R. C. Kelly, proprietor of Webel IT Australia, summarising his extensive professional experience as an expert consultant and developer in a wide range of web technologies - especially Drupal™-driven Content Management System (CMS) web sites.

This Drupal™ CMS-driven Web Technologies Résumé web page also offers many links to examples on this site and client sites, and descriptions of Webel services for web and internet:

An overview of some PHP-driven Drupal™ CMS sites developed by Webel is available online at:

- Service: Drupal-driven Content Management System (CMS) web sites by Webel

Good summaries of web-related technologies employed by Dr Darren and Webel are also available online at:

- Web and internet technologies

- Programming and scripting languages

- Computing and information technology skills


Other résumé and CV versions

For information on development of web applications using model-based software engineering and systems engineering using Enterprise Java, XML and graphical UML™ and SysML - as well as experience with semantic web technologies - please visit also this model-based engineering résumé version:

- Dr Darren Kelly's model-based software and systems engineering résumé

For a full-career biographical CV (intended as a reference only) please visit:

- Dr Darren Kelly's full-career Curriculum Vitae

SQL reference

A Webel reference zone on the Standard Query Language (SQL).

Syndicate content