NOTICE OF PROPOSED PROCUREMENT (NPP) - Application/Software Architect, Technology Architect, Programmer Analyst

NOTICE OF PROPOSED PROCUREMENT (NPP) For TASK BASED INFORMATICS PROFESSIONAL SERVICES (TBIPS) GSIN: D302A ADP SYSTEM DEVELOPMENT SERVICES Reference Number: 87055-16-0105 Solicitation Number: 87055-16-0105 Organization Name: Canadian Nuclear Safety Commission Solicitation Date: 2016-06-28 Closing Date: 2016-07-13 02:00 PM Eastern Daylight Saving Time (EDT) Anticipated Start Date: 1 to 2 months from closing date Estimated Delivery Date: Estimate Level of Effort: 380 days (including Option Periods) Contract Duration: The contract period will be for 10 months from the date of contract with an irrevocable option to extend it for up to 1 additional 6 month period. Solicitation Method: Competitive Applicable Trade Agreements: WTO-AGP, NAFTA, AIT Comprehensive Land Claim Agreement Applies: No Number of Contracts: 1 Requirement Details Tendering Procedure: Selective Tendering This requirement is open only to those TBIPS Supply Arrangement Holders who qualified under Tier 1 for services in the National Capital Region for the following category: One (1) Level 3, A.1 Application/Software Architect One (1) Level 3, I.11 Technology Architect One (1) Level 3, A.7 Programmer Analyst The following SA Holders have been invited to submit a proposal: Access Corporate Technologies Inc. AMITA Corporation Bevertec CST Inc. Excel Human Resources Inc. Ibiska Telecom Inc. and CM Inc., as a contratual Joint Venture IBM Canada Ltd. Lumina IT inc. Maplesoft Consulting Inc. Modis Canada Inc Procom Consultants Group Ltd. S.i. Systems Ltd. Spectra FX Inc. TeraMach Technologies Inc. Thales Canada Inc. Trillys Systems inc. Veritaaq Technology House Inc. However, should an uninvited SA Holder wish to be invited, it may contact the Contracting Authority in writing to request an invitation at any time prior to five days before the published bid closing date, and an invitation will be made to that SA Holder. To ensure efficient operation of the procurement system, the Contracting Authority will invite no more than the first 10 SA Holders that request an invitation. In no circumstance will such an invitation require Canada to extend a bid closing date. Description of Work: 1.0 Objective CNSC requires professional services of a team made up of the following three (3) resources, on an as required basis, to carry out and deliver the implementation of IBM Cognos TM1 Enterprise Planning software for the forecasting and the cost allocation processes to support multiple lines of business. The main goal of the initiative is to design, implement, and deliver the end-to-end TM1 solution that support the CNSC’s use of IBM Cognos TM1 within an integrated environment including Cognos BI, DataMart, and applicable in house applications and databases. The solution must meet both functional and technical requirements driven by the CNSC plan for Enterprise Planning. Note: bidders must propose one candidate for each of the three (3) TBIPS categories shown below. 2.0 Scope The CNSC is in the process of implementing the enterprise planning solution using IBM Cognos TM1 in support of the forecasting and the cost allocation processes. A business process review and high level business requirements were documented during the business case stage as part of the business case development and approval process. The project initiation stage will begin in April 2016 with project duration of eighteen months. The analysis, design, configuration, testing, training, and deployment of the TM1 solution to meet the client’s business requirements are included in the scope of this contract. Other activities included in the scope of this contract include: migration from the existing Cognos Enterprise Planning (EP) tool; integration with existing Cognos BI and reporting DataMart; data migration and ETL efforts, migration work to move from one environment to another and additional TM1 activities not previously mentioned. The solution architecture for the CNSC involves a number of additional supportive services and 3rd party software tools to allow interoperability with the other CNSC systems and exchange of data. The design and implementation of those services/tools are also included in the scope of this contract. 3.0 Summary of Duties 3.1- One (1) Level 3 A.1 Application/Software Architect (TM1 Lead Architect) The TM1 Lead Architect will design the TM1 architecture in support of forecasting, planning and cost allocation business processes. He/she will clearly identify the delivery approach, the risks and outcomes; produce the technical documentation required and do the knowledge transfer to the CNSC staff. The TM1 Lead Architect will lead the deployment of the solution to the development / QA / Pre-Prod / Production environments. The TM1 Lead Architect will provide guidelines, framework and support to the project team to fulfill their responsibilities. He/she will support the CNSC project management team by providing input to the project schedules, cost estimates, resource requirements, and the project management plan. The TM1 Lead Architect will provide leadership and oversight to the contractor’s team in fulfilling the tasks and deliverables identified in the Statement of Work. He/she will be accountable to IMTD for status updates, resolution of issues and the completion of the contractor’s team deliverables. 3.2- One (1) Level 3 I.11 Technology Architect (TM1 Architect) The TM1 Architect will implement the TM1 architecture in support of forecasting and cost allocation business processes. The TM1 Architect will install, configure, and integrate TM1 with existing Cognos BI, under the direction of the CNSC technical lead. He/she will produce the technical documentation including but not limited to the installation guide, system configuration document, maintenance / operational documents and future growth opportunities and technical requirements to support the growth plan. 3.3- One (1) Level 3 A.7 Programmer Analyst (TM1 Developer) The TM1 Developer will be responsible for the development of the TM1 end-to-end solution, including prototype development and testing, interface specifications, integration with existing Cognos BI 10, creating BI / TM1 reports as required, integrating with SQL Server database/DataMart, ETL process, and performance testing. The TM1 Developer will provide the application documentation to support the development and testing activities. The TM1 Developer will provide knowledge transfer sessions to the CNSC staff throughout the duration of the project. He/she will provide support to the CNSC technical lead for training and transition to the steady state. 4.0 Technical Environment

Cognos 10.2 BI installed on a distributed environment and integrated with Cognos 10.1 Enterprise Planning SQL Server 2008/2012 Data warehouse/DataMart using SQL Server C#, VisualBasic.Net (VB.Net), ActiveServerPages.Net (ASP.net),HTML, XML, .Net Frameworks 3.5, 4.0 & 4.5, Enterprise library 4.x and 5.x, Web Client Software Factory, Entity Framework 1 and 4

Microsoft Dynamics CRM 2015 Microsoft SharePoint 2007/2013

Team Foundation Server 2012 Windows 2008/2012 servers SQL Server 2012 Microsoft Windows 7 Microsoft Office 2010

5.0 Responsibilities/Tasks 5.1 A.1 Application/Software Architect (TM1 Lead Architect)

Provide leadership and oversight to the contractor’s team in fulfilling the tasks and deliverables identified in the Statement of Work Accountable for status updates, progress reports, resolution of issues and the completion of the vendor’s deliverables Review and analyze business and system requirements and processes

Translate business requirements into well-architected solutions that best leverage the IBM Cognos TM1 platform while allowing for future growth Provide input to the implementation plan, schedule and budget Collaborates with the Business Analyst to ensure deliverables are consistent with the TM1 end-state solution Lead design workshops and working sessions to discuss the system design Works with cross-functional areas to architect and document technical solutions that are aligned with client business objectives Manage the design, delivery of configuration, integrations, and data migration elements of a TM1 implementation Develop solutions and interfaces leveraging the Cognos BI platform and TM1 platform Manage the technical requirements in support of client expectations

Provide hands-on, expert technical assistance to developers Provide hands-on, expert technical assistance to DBA and ETL resources Establish and document best practices for the long-term implementation and sustainment of TM1 Provide advice and recommendations on program scope, delivery approach, model governance, schedule, and team structure Communicate impacts of TM1 technical constraints and dependencies on scope and business requirements Performs reviews and validation exercises during key milestones in the project May support business clients by establishing acceptance test criteria and providing clarifications / elaboration during user acceptance testing Transfer knowledge to CNSC staff throughout the process

5.2 I.11 Technology Architect (TM1 Architect)

Ensures technical architecture of the solution is aligned to the CNSC’s IT Strategy Responsible for installing and configuring TM1, including integration to the existing Cognos BI Provide installation documentation Responsible for the technical readiness assessment and future growth sizing Provide roadmap to future expansion

Provide input to the implementation plan, schedule and budget

Provide hands-on, expert technical assistance to IMTD team Transfer knowledge to CNSC staff throughout the process

5.3 A.7 Programmer Analyst (TM1 Developer)

Reviews business and systems requirements documents in order to develop end-to-end TM1 solutions and convert business requirements into technical design requirements Document solution design and detailed deployment instructions Design, develop, implement and test prototypes Conduct prototype demos Analyze and validate data to ensure data integrity Document model design and data flow Design, test and implement user interfaces to the TM1/BI platforms (Customize interface if required using HTML/XML) Build models and “what-if” studies to simulate different scenarios Perform analysis with the business client to ensure financial results are accurate and complete Develop the complete end-to-end TM1 solution according to the business requirements, and integrate TM1 solution with existing Cognos BI, Data warehouse/DataMart, ETL Process, and other in-house applications/databases Build and test automation processes Document content / model movement between environments Advise and assist with build issues Create and modify interfaces and reports (BI/TM1) Create/perform unit testing of the solution modules during development Respond to bug reports and fix issues in a timely fashion Provide hands-on, expert technical assistance to DBA and ETL resources Create application documentation Prepare development best practices document Contribute to the development and delivery of end-user training Transfer knowledge to CNSC staff throughout the process

Incumbent: The work is currently not being performed by a contracted resource in the last 12 months. Security Requirement: Common PS SRCL #6 applies Minimum Corporate Security Required: Designated Organization Screening (DOS) Minimum Resource Security Required: Reliability Status Clearance Contract Authority Name: Brian Roue Phone Number: 996-6724 Email Address: brian.roue@canada.ca Inquiries Inquiries regarding this RFP requirement must be submitted to the Contracting Authority named above. Request for Proposal (RFP) documents will be e-mailed directly from the Contracting Authority to the Qualified Supply Arrangement Holders who are being invited to bid on this requirement. BIDDERS ARE ADVISED THAT “BUYANDSELL.GC.CA” IS NOT RESPONSIBLE FOR THE DISTRIBUTION OF SOLICITATION DOCUMENTS. The Crown retains the right to negotiate with any supplier on any procurement. Documents may be submitted in either official language. NOTE: Task-Based Informatics Professional Services (TBIPS) Method of Supply is refreshed three (3) times per year.If you wish to find out how you can be a “Qualified SA Holder”, please contact RCNMDAI.-NCRIMOS@pwgsc.gc.ca