Tech, Oracle, user experience, coffee, design standards, and shameless ranting

SEPA Portfolio

River Invertebrate Classification System

RICT is a software tool that the environment agencies in the UK use to help monitor and classify the ecology of invertebrates throughout the UK river network

Technical architect and solution developer for this project. PL/SQL, XML, Oracle Apex, Web Services, JQUERY, CSS, RSS, Linux, Amazon AWS cloud computing, Amazon EBS, Security, load balancing and availability design. I wrote all the code and designed the interface and workflow as well as the major functional features of the software.

Working with statisticians to build complex analytical models into the software

Google Maps integration, KML, GML integration with ArcGIS and others.

Training staff in England, NI and Scotland.

Running numerous workshops to raise awareness of software

Board meetings, funding presentations, demo reels, documentation

FISH monitoring tool prototype

Wrote the protype Fish classification tool. This tool helps classify rivers according to their fish populations which in turn assist ecologists and environmental bodies in monitoring changes to these water bodies over time.

Technical architect and solution developer for this project. PL/SQL, XML, Oracle Apex, Web Services, JQUERY, CSS, RSS, Amazon AWS cloud computing

Graphing in APEX using custom javascript libraries (FLOT, jQuery)

Understanding of fish measuring techniques and statistical methods and translating these to technical specifications which I developed in oracle with APEX as a front end.

Creation of custom APEX templates, custom authorization and authentication routines.

GIS outputs, data visualization interactive reports

EU Water Framework Directive Classification Reporting

Working with statisticians and data owners to develop a classification system for EU reporting of water bodies in Scotland. Allowing SEPA to meet its duties to classify these water bodies using EU standard quality measures.

Developing Service Oriented Architecture (SOA) web services for offline communication between the SEPA LIMS database and the statistical analysis routines required for classification. Promoting the use of SOA thereby modularizing business processes in a loosely coupled way for ease of integration, and resulting in future development cost savings by an increase in code-reuse.

Creating XSD document interchange standards for inter-software communications.

Wrote numerous data conversion routines to handle field collected data in Excel, CSV and other custom formats.

Developing front-end Oracle Forms applications for administrator of the WFD classification software.

Extensive use of PL/SQL and JAVA stored procedures. Performance tuning. Object Oriented design. Materialized views.

Creation of intranet reporting software (using Oracle APEX) to monitor and compare classifications using key performance metrics.

Development of automated unit test software and general compliance with Agile software testing methodologies and ideals.

Laboratory Information Management System (LIMS)

Modification of NEMS (in-house LIMS system) Smalltalk routines that interface with RIVPACS software to correct errors in interface logic.

Integrated UK standard taxa conventions from the National Biodiversity Network (NBN) into NEMS. Developed a series of routines to map existing coding standards to universal NBN codes. Updating historical data to use the new NBN code and hierarchy.

Development of software routines for conversion of Geo-spatial information between various datum. For instance, the software converts between NGR references, Latitude/Longitude pairs and Northings / Eastings.

Creation and maintenance of various Crystal reports for use with water network planning and monitoring.

Performance tuning and monitoring

eXtensible Markup Language (XML) framework

Creating a framework for SEPA to take advantage of Oracle’s new XML features which were require for inter-software communications, and also for delivery of new governmental reporting requirements. Developing storage methodologies, and the beginnings of a searchable XML document repository for future meta-data purposes.

Water Information Systems for Europe (WISE) reporting

Producing XML/XSL reports for presentation of quality measures in a Europe Wide XML standard.

Development of Oracle XML routines to extract data from the working database and map to published schema definitions.

Contact model design

Development of standards for the storage of contacts in the SEPA corporate database.

Modification of existing Oracle software to comply with the new standards.

Working closely with legal department and data protection act guidelines to ensure full compliance when storing and retrieving personal contact information.

Share

You can follow any responses to this entry through the RSS 2.0 feed.

Switch to our mobile site