Project 39
|
Project Name Roadmap application – Finance and Investment Group – CABL Process and Information mapping – Current State |
|
Client Export Development Canada – Financing and Investment Group |
|
Duration January to March 2015 [3 Months] |
|
Project Description |
|
Access to credit is vital for companies of all sizes. As a crown corporation, Export Development Canada (EDC) plays an important role in helping Canadian companies access credit and protect themselves against a variety of risks. The Finance and Investment (F&I) Group of EDC is planning a business transformation from it is current multiple database system into a modernized consolidated IT Solution. |
|
Scope and objective |
|
In the context of the Loan and Value Stream project, the scope of this mandate was to focus the application of roadmap applicable to the products and/or services under the Corporate Asset Backed Lending (CABL) Group that are currently supported by the Medium and Long Term Financial Services Business Centre Application (MBC). Recognizing that Export Development Canada is offering various Financial and Investment products under the following 3 categories being: 1. Financing Products 1.1 – Export Guarantee Program (EGP) 1.2 – Direct lending or Syndicated Lending for: 1.2.1 – Supplier Financing 1.2.2 – Foreign Buyer Financing 1.2.3 – Project Financing 1.3 – Investments (direct equity and funds) |
|
Dollar Value |
|
Information available withheld with client |
|
Contribution of the proposed resource to the project |
|
Business processes supporting the Financing and Investments activities and its administration will be developed, mapped and signed-off by business owner. Related Tables and Data Fields were documented in DataStar with the pertinent data profiling attributes. The specific functional business requirements were identified and validated with the key Business / Data Owner. Business rule requirements were documented. Some of these specifications were: > Current Process Mapping to establish, Data Ownership, Internal and/or external control; and Segregation of duties > Key Data Architecture Specification to ensure Data Integrity, to support Data migration and/or Retention strategy Real-time interface between proposed software solution and other active system > Identify data management weakness and propose implementation of corrective action to improve the data integrity support by a rigourous data governance structure with clear role and responsibility. > This mandate is supporting business process transformation and it requires expertise in assessment of organizational role and responsibility. |
|
Deliverables |
|
The key deliverable from this assignment were: > Process Mapping (Work Flow and Narrative) > Documentation of Data Profiling in DataStar > Data Migration and Retention Strategy Report > Data Modeling Specification for new platform |
|
References:
Justine Hendricks Vice-President Financing and Investments Group Export Development Canada (613) 598-6872 150 Slater Street Ottawa, Ontario | KIA 1K3
|
|
Technological platform leverage during this mandate |
|
|