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 of several major projects, including an electronic approval process for financial transactions and other types of transactions, and a project to rationalize and clean up the way ESDC manages key data related to legal entities. Both these projects involved significant extensions and modifications to the current data model as well as extensive redesign of the underlying PL/SQL code.
His technical contributions have included
- data modelling
- overall technical design for several new sub-systems
- design of core PL/SQL processes and redesign of existing processes
- troubleshooting of production issues