Oct 1999 to present
|
Senior Consultant
James Bay Consulting Inc.
|
|
Ministry of Attorney General
– Data Architecture Group
October 2003 to present
- Designed and developed the Oracle Designer Metadata
Browser with Oracle Application Express. This application allows Designer
metadata to be easily viewed using only a web browser.
- Developed the DDL Audit Facility to automatically inform
the DA Group of changes made to objects in all Oracle databases.
- Developed custom Designer Repository Reports to verify
that logical data models and physical database designs followed Ministry
standards.
- Built custom Designer Repository Reports that identify
differences between two logical data models or two database designs.
- Built custom Repository Reports to display table and
domain definitions.
- Performed the migration from Designer 6i to 10g.
- Enhanced the Designer to Database Reconciliation utility.
- Gathered business requirements and built the logical
data model for the Quality Assurance Review (QAR) application.
- Designed and built the QAR application using (web-deployed)
Oracle Forms 6i and Reports 6i.
- Migrated the QAR application to the Forms and Reports
10g environment.
- Conducted data model QA reviews for the Family Search System
project.
|
|
Ministry of Transportation
- Application Services (DBA Group)
April 2001 to March 2006
- Provided consulting expertise on a variety of
Oracle products.
- Supported the Forms Services, Reports Services,
Designer and Discoverer products.
- Supplied technical support to developers on web
application issues.
- Performed the migration from Designer 6i to 10g.
- Performed the upgrade of Discoverer 4i to 10g.
- Developed best practices for migrating from Forms/Reports
6i to 10g.
- Developed best practices for the Reports 10g,
Forms 10g and Discoverer 10g products.
- Developed shared code for web-deployed Forms/Reports
applications.
- Developed an Oracle Designer to Database Reconciliation
utility.
- Developed database replication best practices
for highways location data.
|
|
Ministry of Advanced Education
- Industry Training Branch
May to September 2003
- Developed the Industry Training Self-Registration
(ITSR) web application using custom-built Web PL/SQL modules.
- Developed an administrative sub-system of ITSR
using web-deployed Forms and Reports 6i.
|
|
Ministry of Finance - Provincial
Treasury
April 2001 to January 2003
- Technical Leader of the Debt Management System (DMS) project.
- Designed the technical architecture for the DMS.
- Configured the development environment (Forms Server,
Reports Server, Headstart, Designer).
- Built a proof-of-concept prototype using Headstart.
- Performed Quality Assurance duties on data and function
models.
- Mentored Business Analysts on the use of Oracle Designer
and CDM RuleFrame.
|
|
Ministry of Transportation
and Highways - Application Services
June 2000 to March 2001
- Provided technical leadership to the Web-Enabled
Applications Project.
- Developed an evaluation application using Oracle
Designer WebServer Generator, with extensive use of PL/SQL, HTML and
JavaScript.
- Co-ordinated the development of three versions
of the evaluation application (Designer WSG, Forms Server and JDeveloper).
- Customized the installation of Forms Server 6i
and solved technical issues associated with porting a client-server
application to the web.
- Integrated reports into the WSG web application
using Reports Server 6i.
|
|
Ministry of Transportation
and Highways - Application Services (DBA Group)
April 2000 to March 2001
- Revised the Ministry’s Oracle database standards
and procedures based on the new features in Oracle 8.0, 8i and 8i
Release 2.
- Evaluated support for the new database features
in Designer/Developer 6.0 and 6i, Object Database Designer and JDeveloper.
- Provided recommendations for the future support
of the Oracle database, tools and web-based technologies.
- Installed, configured and evaluated Designer 6i
and planned the migration to Designer 6i.
|
|
Ministry of Transportation
and Highways - Business Services
Feb 2000 to March 2000
- Developed enhancements to the Property Acquisition
and Inventory Management System using Designer/2000, Forms 4.5 and
Reports 2.5.
|
|
Alberta Distance Learning
Centre (subcontractor for WIE Inc.)
Oct 1999 to Jan 2000
- Developed the Student Administration System.
- Designed and generated Forms 6.0 modules using
Oracle Designer.
|
May 1998 to Mar 1999
|
Senior Information Specialist
EDS Canada, Victoria BC
|
|
Elections BC, EIS Project
May 1998 to Mar 1999
- Participated in the writing of the Electoral Information
System (EIS) proposal, with a concentration on the business requirements.
- Acted as Business Systems Integration Manager.
- Gathered and documented high-level functional
requirements.
- Facilitated workshops in which requirements were
reviewed and refined.
- Researched, administered and attended four separate
object-oriented training courses for key project team members.
- Planned the analysis, training and user acceptance
activities to be conducted in Stages 1-3 of the project (April 1999
to October 2000).
|
Apr 1996 to May 1998
|
Senior Consultant
Stellar Systems Group, Victoria BC
- Participated in Stellar System’s marketing group.
- Prepared proposals for a wide variety of Oracle
projects.
- Involved in the recruiting and interviewing of
consulting staff.
- Organized and participated in strategic planning
sessions.
|
|
Ministry of Environment,
Lands and Parks, Crown Lands
Dec 1997 to Mar 1998
- Performed business analysis for the Tenure Billing
component of TANTALIS, an enhanced version of the Crown Lands Registry
System.
- Captured requirements in Designer/2000.
|
|
Ministry of Attorney General,
Court Services Branch
Sep to Dec 1997
- Gathered business requirements for the Jury Management
System.
- Facilitated JAD workshops and conducted interviews
with users.
- Developed data and function models using Designer/2000.
|
|
Ministry of Environment,
Lands and Parks, Fisheries Branch
Aug to Nov 1997
- Project Manager for the Bathymetric Maps Web Project.
|
|
Ministry of Transportation
and Highways, Customer Services Group
Apr 1997 to Mar 1998
- Provided general Oracle Designer/2000 and Developer/2000
consulting expertise to the Ministry.
- Managed Traffic Information System maintenance
activities.
- Mentored Ministry developers on the use of Oracle
tools.
- Developed and taught a one-day introductory course
on Designer/2000 and Developer/2000 for Ministry ISB staff.
|
|
Ministry of Environment,
Lands and Parks, Fisheries Branch
Apr 1997 to Mar 1998
- Performed project management duties for the Bathymetric
Maps Enhancement Project.
- Mentored a junior developer in Forms 4.5 generation
using Designer/2000.
|
|
Ministry of Transportation
and Highways - Business Services
Oct 1996 to Apr 1997
- Performed business analysis and project management
duties for the Property Acquisition and Inventory Management System
project.
- Facilitated both data and function-oriented JAD
workshops.
- Captured requirements in Designer/2000.
|
|
Ministry of Environment,
Lands and Parks - Geographic Names Unit
Apr 1996 to Sep 1996
- Project Leader of the BC Geographic Names Information
System project.
- Designed and developed the BCGNIS application using
Designer/2000.
- Generated Forms using Designer/2000.
- Performed many project management duties.
|
Sep 1991 to Mar 1996
|
Senior Consultant
Sierra Systems Consultants, Victoria BC
- Assisted in the preparation of proposals.
- Conducted technical interviews of prospective employees.
|
|
Ministry of Transportation
and Highways - Customer Services Group
Jan 1996 to Mar 1996
- Project Manager of the Rockfall Hazard Rating System
project.
|
|
Ministry of Transportation
and Highways - Customer Services Group
July 1994 to Mar 1996
- Performed Project Leader role on the PAMS project
and completed many project management tasks.
- Supervised four Oracle programmer/analysts during
development.
- Performed JAD facilitation during prototype review
sessions.
- Created the logical and physical database design
using Oracle CASE.
- Trained approximately 50 users in six regional
offices.
|
|
Ministry of Transportation
and Highways - Information Resource Services
July 1993 to July 1994
- Designed all Ministry standards and procedures
for the Oracle 7 DBMS.
- Developed Ministry standards and procedures for
application development using Oracle CASE, Forms 3.0 and ReportWriter
1.0.
- Evaluated the Forms 4 application development tool
for the Ministry.
- Provided on-going technical support for the Oracle
product suite.
|
|
Office of the Ombudsman
Jan 1993 to June 1993
- Designed and developed the Case Tracking System
using Oracle CASE.
- Generated Forms 3 modules with Oracle CASE generator.
- Performed project leader duties.
- Installed the Oracle DBMS and development tools.
- Performed all Oracle DBA duties during application
development.
|
|
Ministry of Health - MSP
Program Monitoring
Sep 1991 to Dec 1992
- Performed Business Analysis on Practitioner Monitoring
systems.
- Designed systems and created program specifications.
- Managed from one to three programmers during development.
|
May 1989 to Aug 1991
|
Senior Systems Analyst
McGill University, Montreal QC
- Evaluated 4GL and relational DBMS products from
Software AG.
- Installed new releases and fixes for Software AG
products.
- Reviewed ADABAS database designs with application
Analysts.
- Completed DBA duties for all corporate data stored
in ADABAS.
- Co-wrote a standards manual for ADABAS and NATURAL.
- Defined backup and recovery procedures.
- Designed, implemented and supported a source backup
system.
- Conducted seminars on the newly acquired tools.
|
Oct 1988 to May 1989
|
Consultant (Analyst)
Air Canada, Montreal QC
- Designed and programmed major system enhancements
for the Air-to-Ground Communication System.
|
May 1986 to Aug 1988
|
Senior Programmer/Analyst
The Mutual Group, Waterloo Ont.
Support Services Development Centre
- Provided technical support for application programmers.
- Taught courses and seminars for the Computer Systems
department.
- Designed and programmed various utilities and evaluated
software.
- Provided application and DBA support for the corporate
e-mail system.
|
