SQL

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.

SQL reference

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

Database Engineering reference

This content area is UNDER CONSTRUCTION or MIGRATION

A Webel reference zone on database technologies.

Tangram (Perl) OR-mapper

The content or the technology discussed here is HISTORICAL or ARCHIVAL

Java Data Objects (JDO)

JDO was the object-relational mapping system used for the Webel MOST radiotelescope information system project.

Hibernate

Webel offers Hibernate-driven object-relational persistence for Enterprise Java systems.

Syndicate content