Category Archives for Oracle Projects
Supervisor Booking, OC Transpo (Oct 2003-Jul 2004)
Peter designed and developed the Supervisor Booking System, an in-house app used to book work shifts for transit supervisors at OC Transpo. His work spanned all phases of the system life cycle, from requirements analysis through to technical specification, system … Continue reading
Data Warehouse, FinTRAC (Mar 2002 – Aug 2003)
Peter designed and coded the PL/SQL portion of several systems and sub-systems on this ambitious Ministry of Finance data warehousing project. Working with DBAs and VB developers, he delivered search systems meeting three distinct sets of needs, and provided technical design … Continue reading
Equipment Master, OC Transpo (Nov2001 – Feb2002)
Peter did the initial analysis and design work for the Equipment Master application, an in-house Oracle Forms app at OC Transpo. He interviewed user groups, assisted the project lead in identifying and defining business requirements, identified business functions and designed processes … Continue reading
DMS Rehost, NavCanada (Oct 2000 – Oct 2001)
DMS is an in-house NavCanada application used in the Air Traffic control system. The goal of this project was to re-host DMS, migrating it from a character-based application hosted on a mainframe to an Oracle application with a graphical user interface including … Continue reading
AMR Repository, DND (Dec 1999 – Sep 2000)
AMR is an acronym for Aircraft Maintenance Records. As part of the team for this DND Y2K data warehousing project, Peter was tasked with the delivery of a critical module to migrate aircraft utilization statistical data from Air Force bases across … Continue reading
Web Grievance Prototype, CUPW (Oct – Nov 1999)
Peter was part of a small team that developed a Web-based version of CUPW’s Oracle Applications Custom Grievance module at a time when Oracle Applications was still a client-server system. This project was his first introduction to web-based development with Oracle including the dynamic creation … Continue reading
FARMM, Ottawa Hospital (Apr 1999 – Sep 1999)
Peter joined this project to add strength and experience to the Oracle Forms development team for the customized Accounts Receivable module on this Y2K implementation of Oracle Applications at Ottawa Hospital. He developed several major forms and PL/SQL using Developer/2000 (Forms … Continue reading
ADAM Release 4.1, DND (Dec 1998 – Mar 1999)
Peter joined the development and support team for Release 4.1 of this in-house DAEBM application which is used to maintain a history of preventive maintenance on several fleets of aircraft. This release of ADAM involved converting all the forms from … Continue reading
RCMA Replacement, DND (Oct 1997 – Dec 1998)
This ambitious Oracle project with Solvera Information Services involved the replacement of a legacy system with an entirely new system (a customized extension to an existing COTS Oracle-based application). This project was a huge learning curve for Peter. Although he was a … Continue reading
Omega Point of Maintenance (Oct 1996 – Sep 1997)
This was a query-only view of maintenance data intended for people working in the realm of preventive maintenance on large equipment systems. At the time Peter was employed by Omega Logistics of Canada Ltd, and this product was targetted to … Continue reading