Services professionnels informatiques pour l'application IIS (Integrated Information Service).

Trade Agreement: CETA / WTO-AGP / NAFTA / CFTA / FTAs with Peru / Colombia / Panama / Korea
Tendering Procedures: Suppliers on permanent list or able to meet qualification requirements
Non-Competitive Procurement Strategy: Exclusive Rights
Comprehensive Land Claim Agreement: No
Vendor Name and Address:
IBM CANADA LIMITED/IBM CANADA LIMITÉE
3755 Riverside Drive
Ottawa Ontario
Canada
K1G4K9
Nature of Requirements:

1. Advance Contract Award Notice (ACAN)

An ACAN is a public notice indicating to the supplier community that a department or agency intends to award a contract for goods, services or construction to a pre-identified supplier, thereby allowing other suppliers to signal their interest in bidding, by submitting a statement of capabilities. If no supplier submits a statement of capabilities that meets the requirements set out in the ACAN, on or before the closing date stated in the ACAN, the contracting officer may then proceed with the award to the pre-identified supplier.

2. Definition of requirement

The Integrated Information Service (IIS) is a query tool designed to provide Royal Canadian Mounted Police (RCMP) operational members with the ability to search multiple data systems from a single point, including both structured and unstructured data. The underlying data infrastructure for the IIS Application has been developed using IBM’s DataStage and Change Data Capture/Change Data Delivery (CDC/CDD) software. Additionally, the IIS infrastructure is being leveraged to provide a feed to the Identity Insight software, which is an entity and association resolution tool. The RCMP’s Federal Policing Program, responsible for the IIS Application, requires professional services from industry to assist with the ongoing support and future development of the IIS Application.

The Royal Canadian Mounted Police has a requirement has a requirement for a team that consist of up to two Level 3 Application/Software Architects, one Level 2 Business Transformation Architect and up to four Level 1 Programmer/Analysts. The work will involve the following:
The Level 1 Programmer/Analyst must deliver the necessary changes and additions to the RCMP’s Extract, Transform and Load (ETL) solution by performing the following, but not limited to, tasks and deliverables:
Tasks

• Developing and implementing coding jobs based on extraction rules and specifications to extract data from various databases;
• Transforming data and store it in a DB2 database;
• Developing the transformation to write the data to the National Information Exchange Model (NIEM) compliant XML;
• Analyzing performance and modifying any coding as required;
• Assisting in preparing the Identity Insight Software (IIS) production environment for releases;
• Assisting in coordinating all IIS version changes with impacted stakeholders (such as RCMP’s database group, source data system support teams, etc);
• Supporting IIS development builds in test and pre-production environments;
• Providing problem debugging and resolution with ETL and Change Data Capture (CDC) jobs;
• Controlling and evaluating IIS ETL unit testing;
• Supporting and adhering to RCMP IT and security policies;
• Analyzing and developing functional system processes that are migrated from source legacy systems to various corporate target systems and documenting their data requirements;
• Analyzing functional requirements to identify information, procedures and decision flows; and
• Evaluating existing procedures and methods.

Deliverables

• Identifying and documenting database content, structure, and application sub-systems; and
• Documenting all coding jobs in MKS Integrity system for application lifecycle management, and IBM ClearQuest software for tracking software bugs and issues.

The Level 2 Business Transformation Architect must provide business analysis on the implementation and further customization of the Identity Insight software. This includes performing the following, but not limited to, tasks and deliverables:

Tasks

• Providing project recommendations on refining technical requirements, usability of source data fields, data quality issues, hardware questions, and configuration threshold for resolution, matching and alerts;
• Providing analysis and assistance on the installation of upgrades and new versions of the Identity Insight software;
• Providing analysis and assistance on the transformation and performance configurations for loading source data into the Identity Insight software;
• Identifying data model and required changes to data quality and Universal Message Format (UMF) file amendments for the Identity Insight resolution;
• Identifying and recommending the integration of COGNOS software for reporting within the Identity Insight implementation, and assisting in designing required COGNOS report templates; and
• Providing recommendations on the integration of i2 Analyst Notebook software with Identity Insight software and providing assistance with the development of RCMP-centric enhanced requirements for the integration of i2 Analyst’s Notebook software with the Identity Insight software.

Deliverables

• Documenting of analysis and procedures for installations of new versions of Identity Insight;
• Documenting of transformation and performance configurations for loading source data into the Identity Insight software; and
• Providing all documentation, recommendations and insight in Microsoft Word.

The Level 3 Application/Software Architect - (DataStage/ETL) must assist in the oversight and guidance of the RCMP’s data in Extract, Transform and Load (ETL) process. The resource must perform the following, but not limited to, tasks and deliverables:

Tasks

• Identifying best methods for bulk loading data from multiple data sources;
• Recommending how the various DataStage ETL jobs should be broken down;
• Defining how the Change Data Capture (CDC) jobs should be designed to optimally process data updates in the source systems;
• Reviewing new data sources for inclusion into the Security Model used in IIS and identifying required changes (if necessary);
• Monitoring of ETL daily updates process for any issues or problems;
• Reinforcing the IIS established ETL standards across all coding jobs; and
• Reviewing the programming of the programmer/analysts (level 1) to ensure compliance with the IIS ETL standards and providing feedback;

Deliverables

• Developing and documenting both high-level and detailed data mapping requirements and schemas from Operational databases: PROS, PRIME, E&R, ACIIS, NCDB, and any future potential data sources;
• Producing and validating a comprehensive Work Breakdown Structure for the project plans, including effort estimates for all ETL development work.; and
• Providing progress reports and updates to the project authority.

The Level 3 Application/Software Architect - (Change Data Capture - CDC) must perform the following, but not limited to, tasks and deliverables:

Tasks

• Analyzing the current CDC environment and making recommendations for improvements and industry Best Practices in all environments described in section 4;
• Assisting in designing and implementing CDC coding based on these recommendations;
• Identifying best methods for bulk loading data from multiple data sources;
• Recommending how the various DataStage ETL jobs must be broken down;
• Defining how the CDC jobs must be designed to optimally process data updates in the source systems;
• Reviewing new data sources for inclusion into the IIS Security Model and identifying required changes (if necessary);
• Monitoring of ETL daily updates process for any issues or problems;
• Reviewing the programming of the programmer/ analysts (level 1) to ensure quality and provide feedback; and
• Reinforcing the established IIS ETL standards across all coding jobs.

Deliverables

• Creating CDC Best Practices documentation within the RCMP’s lifecycle management tool (MKS Integrity);
• Documenting CDC design based on implemented recommendations
• Developing and documenting both high and low-level data mapping requirements and schemas from current operational databases and any future potential data sources.; and
• Providing progress reports and updates to the project authority.

3. Applicability of the Trade Agreements to the Procurement

This procurement is subject to the following trade agreement(s):
Canadian Free Trade Agreement (CFTA)
World Trade Organization - Agreement on Government Procurement (WTO-AGP)
North American Free Trade Agreement (NAFTA)
Canada-Chile Free Trade Agreement (CCFTA)
Canada-Peru Free Trade Agreement (CPFTA)
Canada-Colombia Free Trade Agreement (CColFTAQ)
Canada-Panama Free Trade Agreement (CPanFTA)
Canada-European Union Comprehensive Economic and Trade Agreement (CETA)

4. Justification for the Pre-Identified Supplier

IBM lnfoSphere DataStage was competitively acquired as the RCMP's ETL tool. Additional professional services are required to support the data ETL requirements for IIS. IBM is the only known company able to provide the necessary expertise, years of experience and specialized support skills required.
IBM owns the IP rights for the ETL software used in the data acquisition portion of IIS. IBM owns the IP rights for the programmed code deployed into production at the RCMP for ongoing use. Since the IIS application is based on the use of IBM's DataStage and Change Data Capture/Change Data Delivery (CDC/CDD) software, IBM is the only supplier capable of performing the multitude of services needed on the contract, as defined in section 2.

5. Government Contracts Regulations Exception

The following exception(s) to the Government Contracts Regulations is (are) invoked for this procurement under subsection 6(d) - "only one person is capable of performing the work").

6. Exclusions and/or Limited Tendering Reasons

The following exclusion(s) and/or limited tendering reasons are invoked under the:

o Canadian Free Trade Agreement (CFTA) - Article 513 (b)
(ii) the protection of patents, copyrights, or other exclusive rights;

o World Trade Organization - Agreement on Government Procurement (WTO-AGP) - Article XV
(b) when, for works of art or for reasons connected with protection of exclusive rights, such as patents or copyrights, or in the absence of competition for technical reasons, the products or services can be supplied only by a particular supplier and no reasonable alternative or substitute exists;

o North American Free Trade Agreement (NAFTA) - Article 1016 2.
(b) where, for works of art, or for reasons connected with the protection of patents, copyrights or other exclusive rights, or proprietary information or where there is an absence of competition for technical reasons, the goods or services can be supplied only by a particular supplier and no reasonable alternative or substitute exists

o Canada-European Union Comprehensive Economic and Trade Agreement (CETA) - Article 19.12 (b)
(ii) the protection of patents, copyrights or other exclusive rights.

7. Ownership of Intellectual Property.

Ownership of any Foreground Intellectual Property arising out of the proposed contract will vest in the Contractor.

8. Period of the proposed contract

The proposed contract is for a period of one year from contract award with two available option periods of one year each.

9. A cost estimate of the proposed contract

The estimated value of the contract, including options, is $4,500,000.00 (GST/HST extra).

10. Name and address of the pre-identified supplier

Name:
IBM Canada Limited
Address:
3755 Riverside Drive
Ottawa
Ontario
K1G4K9

11. Suppliers' right to submit a statement of capabilities

Suppliers who consider themselves fully qualified and available to provide the goods, services or construction services described in the ACAN, may submit a statement of capabilities in writing to the contact person identified in this notice on or before the closing date of this notice. The statement of capabilities must clearly demonstrate how the supplier meets the advertised requirements.

12. The closing date for a submission of a statement of capabilities.

The closing date and time for accepting statements of capabilities is August 1st, 2018 at 2:00 p.m. EDT

13. Inquiries and submission of statements of capabilities

Inquiries and statements of capabilities are to be directed to:

Jean-David Leblanc, Contracting Officer
10 Wellington Street, Gatineau, QC, K1A 0H4
Telephone: 613-720-7865
E-mail: J••••••••@••••••••.••.ca

Delivery Date: Above-mentioned

You are hereby notified that the government intends to negotiate with one firm only as identified above. Should you have any questions concerning this requirement, contact the contracting officer identified above.

An Advance Contract Award Notice (ACAN) allows departments and agencies to post a notice, for no less than fifteen (15) calendar days, indicating to the supplier community that it intends to award a good, service or construction contract to a pre-identified contractor. If no other supplier submits, on or before the closing date, a Statement of Capabilities that meets the requirements set out in the ACAN, the contracting authority may then proceed with the award. However, should a Statement of Capabilities be found to meet the requirements set out in the ACAN, then the contracting authority will proceed to a full tendering process.

Suppliers who consider themselves fully qualified and available to provide the services/goods described herein, may submit a statement of capabilities in writing to the contact person identified in this Notice on or before the closing date of this Notice. The statement of capabilities must clearly demonstrate how the supplier meets the advertised requirements.

The PWGSC file number, the contracting officer's name and the closing date of the ACAN must appear on the outside of the envelope in block letters on the covering page.

The Crown retains the right to negotiate with suppliers on any procurement.

Documents may be submitted in either official language of Canada.
Delivery Date: Above-mentioned

You are hereby notified that the government intends to negotiate with one firm only as identified above. Should you have any questions concerning this requirement, contact the contracting officer identified above.

An Advance Contract Award Notice (ACAN) allows departments and agencies to post a notice, for no less than fifteen (15) calendar days, indicating to the supplier community that it intends to award a good, service or construction contract to a pre-identified contractor. If no other supplier submits, on or before the closing date, a Statement of Capabilities that meets the requirements set out in the ACAN, the contracting authority may then proceed with the award. However, should a Statement of Capabilities be found to meet the requirements set out in the ACAN, then the contracting authority will proceed to a full tendering process.

Suppliers who consider themselves fully qualified and available to provide the services/goods described herein, may submit a statement of capabilities in writing to the contact person identified in this Notice on or before the closing date of this Notice. The statement of capabilities must clearly demonstrate how the supplier meets the advertised requirements.

The PWGSC file number, the contracting officer's name and the closing date of the ACAN must appear on the outside of the envelope in block letters or, in the case of a facsimile transmission, on the covering page.

The Crown retains the right to negotiate with suppliers on any procurement.

Documents may be submitted in either official language of Canada.