(613) 614-9447 francis.pelletier@rogers.com123 Slater, 6th floor Ottawa On K1P 5H2 Canada
Select Page

Project 18

Project no 18

Project Name

Grant & Contribution monitoring program for the Centre of Expertise of the Contracting, Grants & Contributions Policy

Client

Natural Resources of Canada

Duration

February 2010 to June 2010 [5 months]

Project Description

Transfer payment (grant and contribution) programs at Natural Resources Canada (NRCan) represent approximately represents approximately 50% of total departmental spending. These funding programs are critical to the achievement of federal objectives in the area of sustainable development and use of Canada’s natural resources. Based on a statistical approach, a monitoring strategy was development and implemented to provide reasonable assurance that all the programs are manage as per Treasury Board Term and Condition and in compliance with NRCan policies within the boundaries of the Financial Administration Act.

Scope and objective

The goal of this initiative is to provide reasonable assurance to senior management that Grant and Contribution agreement are managed in agreement with the TBS Terms and Conditions, NRCan policies and FAA requirements by developing a Multi-Year Risk Based Audit Planning.

Dollar Value

~ $ 450M over ~1,500 agreements for 2009/2010

Contribution of the proposed resource to the project

Provided and documented a series of facilitation session to key members of the Centre of Expertise to established and agreed on mandate objectives. In consultation with the client, lead the developed a strategic plan to facilitate the communication and implementation of a monitoring program for NRCan’s transfer payment. Developed audit procedure and criteria aligned with Treasury Board’s management accountability framework and risk management framework.  Developed a series of mitigation strategies were introduced to facilitate the implementation of the monitoring program with day to day NRCan’s operation. Provided a series of informal coaching session to management in complement to some of the mitigation strategies. Review existing Oracle data architecture, supervised data extraction apply data cleansing strategy before report production. Propose implementation of corrective action at the data governance and management level to adress the data integrity weaknesses. Monitored and reported on mandate progress, with an interactive audit tool that was developed and implemented to ensure adherence to the audit process during the application of the monitoring program. Prepared and delivered a series of progress report presentations during weekly briefing session to senior management.

Assisted in the development and implementation of electronic spreadsheet to support the continuous monitoring and production of exception report for the management of the grant and contribution activities. This mandate is supporting business process transformation and it requires expertise in assessment of organizational role and responsibility.

Deliverables

Methodology and auditing tools were understood and applied by the resources of the Centre of Expertise’s to pursue the application of the monitoring program. The monitoring program provides to performed monthly, quarterly and annually testing procedures including a sampling calculator toolkit.

References:

Chris Szwarc

Director

(613) 995-2191

 

Kim Beckert

Manager

(613) 947-9528

Technological platform leverage during this mandate