Category Archives for Oracle Projects
ESDC, Grants and Contributions (April 2016 – present)
In April 2016, Peter accepted an assignment as a senior analyst, PL/SQL designer and developer for the Project Life Cycle module of the ESDC Grants and Contributions program. He has played an integral role in the technical design and implementation … Continue reading
Statistics Canada, Census2016 MIS (Dec 2013-March 2016)
Towards the end of 2013, Peter joined the development team for an MIS Reporting system related to the 2016 Census as a senior PL/SQL technical resource. The main data source for this system is the ICOS Collection Management Portal, a … Continue reading
HRSDC, Grants and Contributions (Oct – Nov 2013)
Concurrently with his work at CDSP, Peter joined the HRSDC Grants and Contributions batch process development/maintenance team for a few weeks to assist with the development of an interface with SAP. He contributed several fixes to specific programs as well … Continue reading
CDSP AHA System, HRSDC (Jan – Nov 2013)
In January 2013, Peter returned to CDSP (which had been migrated to an Oracle 11g R2 database platform) as the systems analysis, design and development lead for the PL/SQL portion of a new subsystem, called AHA, the purpose of which is … Continue reading
CDSP and CESG, HRSDC (Jan 2009 – Mar 2012)
The CDSP (Canadian Disability Savings Program) was introduced in the 2006 Federal budget, and Phase 2b of the batch process to process transactions is currently under development. Phase One of the CDSP went into production in January 2009, and Peter was … Continue reading
Canada Student Loans SoR, HRSDC (Aug – Dec 2008)
This project involved designing, building and populating a data warehouse with transactional data regarding the Canada Student Loans program. Peter was brought on board to design and develop new error reporting features, to add business logic for tracking and reporting … Continue reading
Abacus Upgrade, DFO (Jan – July 2008)
From January to July 2008, Peter was part of the implementation team for the Abacus upgrade at the Department of Fisheries and Oceans in Ottawa. Abacus is a customized implementation of the Oracle eBusiness Suite and was upgraded from 11.5.9 … Continue reading
NVizn upgrade, Cognos (Apr 2007 – Jan 2008)
Peter was part of a team that provided technical support, maintenance and enhancements to users of NVizn, Cognos’ customized implementation of the Oracle eBusiness Suite. He was brought on to provide extra support during upgrades of the Oracle database (9.2.0.7.0 => 10.2.0.20) and the Oracle … Continue reading
DesignPlus, CIPO (Apr 2006 – Apr 2007)
DesignPlus is an in-house application used by the Canadian Intellectual Property Office in processing applications to register industrial designs. This is a concept similar to a trademark or a copyright, but it applies specifically in the domain of proprietary designs … Continue reading
Oracle eBusiness Suite, CUPW (Oct 2004 – Mar 2006)
While at CUPW (October 2004-March 2006), Peter’s role was to provide ongoing enhancements to custom apps within the framework of the Oracle e-Business Suite, specifically within the Receivables, Payables, HR, and custom Grievance modules. He also delivered a total overhaul … Continue reading