AVIS DE PROJET DE MARCHÉ (APM) - Architecte d’applications et de logiciels, Architecte de technologie, Programmeur/ Analyste

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: b••••••••@••••••.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 R••••••••@•••••.••.ca