Software/Information Architect

Profile

Initially trained as a mining exploration geologist I started my career as a software engineer after the base metals market crash in 1997. I have worked in a variety of industries such as mining, engineering & construction, telecommunications, music & entertainment and e-commerce. I've been a programmer for 14 years and have exhaustive experience with data & knowledge management as well as web application development . I specialize in database and software architecture as well as large system implementations.

Areas of Expertise

Web & LAMP Stack Development • Database & Software Architecture • Enterprise Reporting

Systems Integration • Knowledge Management • SQL Optimization • E-commerce & Transactional Systems XML Processing • Web Service/API Implementations • Unit Testing & Automation

Work Experience

May 2010 - Oct 2011

RevenueWire Inc. • Victoria • B.C.

Senior Platform Developer

Part of the architecture team, I designed and implemented web platform and transaction processing infrastructure for SOA (Service Oriented Architecture) based e-commerce systems using LAMP. (Linux • Apache • MySQL • PHP)

Designed and implemented SOA system and software architecture using best practices via class diagrams (UML) and entity relationship diagrams (ERD).

Consulted and collaborated with project managers, product managers and other stakeholders collecting business requirements and refining user stories.

Designed and implemented an SOA Product service consumed by merchant affiliate catalogues and shopping cart style e-commerce interfaces.

Implemented a merchant product catalogue with product rating algorithms based on sales and volume metrics.

Collaborated on design and developed several SOA Services including Sequence ( page tracking/conversion ), Rendering ( template based site/page rendering) , and Transaction ( ledger based accounting ).

Developed UNIX shell scripts, utilities and code libraries to support SOA services and web platform infrastructure.

Consulted with database and data warehouse architects to define requirements and implement business intelligence and enterprise reporting systems.

Developed Unit Tests ( SimpleTest/PHPUnit ) and worked with QA, implementing functional tests (Selenium), load testing and test automation.

Trained and mentored team members and junior developers.

July 2009 - May 2010

PG Music Inc. • Victoria • B.C.

Senior Software Architect

Primarily a system architect and programmer, I developed mobile device, network and API ( Application Programming Interface ) based web architecture for this music software company.

Designed and implemented system and database architecture (PostgreSQL) supporting a subscription based, on-demand multimedia generation and distribution application.

Designed, implemented and administrated a Unix (FreeBSD) and windows (2008) media cluster.

Programmed and implemented network software load balancing using PHP/Nagios for routing and queuing requests from UNIX gateways to windows media servers.

Programmed and implemented a transaction based web API (Unix/Apache/PostgreSQL) supporting web, Delphi and mobile phone (iPhone) clients.

Developed and implemented auditing and transaction based API infrastructure to support Apple iTunes store in-app purchases.

Supported and collaborated with 3rd party (remote) mobile device programmers to develop and debug iPhone applications.

Designed and programmed web management applications and consumer facing websites using HTML, PHP, Javascript, and AJAX.

Sept 2007 - May 2009

Nettwerk Music Group • Vancouver • B.C.

Senior Software Architect

Primarily a database architect and programmer, I designed and implemented digital media management, payload packaging and xml based digital media distribution systems for this independent recording label

Performed requirements analysis and engaged in an enterprise database architectural redesign and implementation.

Developed and implemented an MVC style PHP API with custom MySQL/PostgreSQL database abstraction layer.

Designed and implemented digital media management systems and payload packaging tools using PHP and UNIX shell scripts.

Designed and implemented automated XML document generation interfaces for distributing digital media payloads using PHP.

Managed and maintained SVN repositories and designed and implemented software packaging and deployment tools.

Maintained and provided support for legacy Oracle based royalty systems and ported oracle database schemas to PostgreSQL.

Mentored and provided direction and instruction to junior developers.

June 2005 - Aug 2007

Digifonica Canada Ltd • Vancouver • B.C.

Senior Software Developer/Architect

Primarily as a PHP developer and database architect, I developed business critical systems and infrastructure for this start-up VOIP telecommunications company embracing a grass roots approach.

Designed and implemented a master/multi-slave MySQL database architecture to support a global VOIP ( Voice-Over-IP ) system deployment.

Developed a PHP/PostgreSQL billing and invoicing system providing subscribers and resellers with statements and usage statistics.

Developed a PHP/PostgreSQL rates management system, which facilitated parsing, processing, and normalizing carrier data employing sophisticated statistical string matching algorithms.

Worked with marketing teams to develop business requirements and integrate corporate branding into product design.

Interacted with Quality Assurance management to develop testing strategies and generate functional specifications

Mentored and provided direction and instruction to junior developers.

Nov 1999 - May 2005

Kvaerner Chemetics ( Aker Solutions ) • Vancouver • B.C.

Programmer/Analyst

As part of an enterprise initiative to implement a Canadian data center for finance and reporting, I was commissioned to integrate existing systems and implement a distributed application and reporting environment.

Provide financial systems support for shared services clients across Canada

Developed enterprise reports and provided custom utilities for constantly evolving project based engineering and accounting requirements.

Interacted with project and department managers to gather project requirements and provide technical recommendations.

Developed and implemented an LDAP enabled enterprise portal utilizing Single-Sign-On (SSO) for distributed web applications and dynamically generated Oracle/SQR reports.

Developed a database driven web application to calculate point-in-time cash flows with automated parsing and processing of MS Excel applications and Oracle financial data.

Developed a program to migrate enterprise user mailboxes/project folders from HP OpenMail to MS Exchange.

Developed and implemented a web enabled database driven enterprise man-hour forecast application to aid in predicting project cash flows.

Developed an inventory review database and tracking system for our legal department to determine Y2K exposure for engineering projects.

Jan 1999 - Oct 1999

Steelhead Society Habitat Restoration Corporation • Vancouver • B.C.

Watershed Management Restoration Technician

As part of a project to improve and create off-channel salmon spawning habitat and over-wintering ponds, I was responsible for supervision of in-stream engineering and crews.

Performed stream channel surveys and produced maps and cross-sections.

Utilized backpack electro-fishing (Certified Crew Supervisor) to relocate salmon from areas of construction.

Hydrogeology and stream engineering.

Evaluated spawning habitats through watershed assessment procedures.

Provided assessment reports and wrote project proposals and budgets.

Interacted with stakeholders, First Nations, and Dept. of Fisheries & Oceans (DFO).

Jan 1996 - Nov 1998

Canamera Geological • Vancouver • B.C.

Mining Exploration Geologist

As a field geologist, I was responsible for geological mapping and sampling of potential geological resources primarily in the Canadian arctic and northern B.C. To identify and evaluate viable geological targets, I provided chemical analysis of assay and elemental data, geological and geochemical maps, drill cross-sections, and assessment reports.

Performed analysis of Landsat and airborne geomagnetic data to identify potential geological targets.

Provided detailed petrographic sample analysis (microscopy) for reports and project proposals

Maintained and developed a geochemical database application for mining exploration projects and drilling campaigns.

Participated in the evaluation and delineation of ore deposits and in the development of deposit models.

Produced geochemical and geological maps and drill cross-sections using AutoCad

Education

1992 - 1996

Queen’s University • Kingston • Ontario

Bachelor of Science, Geology

Skills

Databases: Oracle, MySQL, PostgreSQL, MS SQL Server, MS Access

Platforms: MicroSoft , Unix including HP-UX, FreeBSD & Sun; Linux including RedHat, Debian & Ubuntu

Languages: PHP, Python, HTML, XHTML, CSS, XML, SQL, SQR, Unix Shell Script, JavaScript, VBScript, VBA

Technology/Architectures: LAMP, AJAX, OOP, OAD, MVC, SOA, UML, ERD, OLAP, OTP, TCP/IP, HTTP, DNS, DHCP, IMAP, POP

Applications: Django, Apache, IIS, SVN (Subversion), BrioQuery/Hyperion Enterprise, Oracle Enterprise, Nagios, OpenLDAP, JIRA, BugZilla, AutoCAD, ArcInfo/GIS, MapInfo, Galaxy/Qinetix, MS Exchange, MS ActiveDirectory (ADO)

Contact this candidate