SPICT - A.1 Architecte d'applications et de logiciel de niveau 3 - APM

NOTICE OF PROPOSED PROCUREMENT (NPP)
For
TASK BASED INFORMATICS PROFESSIONAL SERVICES (TBIPS)
GSIN: D302A ADP SYSTEM DEVELOPMENT SERVICES

Reference Number:
87055-16-0298
Solicitation Number:
87055-16-0298
Organization Name:
Canadian Nuclear Safety Commission
Solicitation Date:
2016-12-21
Closing Date:
2017-01-19 02:00 PM Eastern Standard Time (EST)
Anticipated Start Date:
1 to 2 months from closing date
Estimated Delivery Date:
Estimate Level of Effort:
120 days (including Option Periods)
Contract Duration:
As and when required basis. Application/Software Architect for 90 days (over 10 months), plus one 30-day irrevocable option (over 6 months)
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
The following SA Holders have been invited to submit a proposal:
1728193 ONTARIO INC., 6123937 CANADA INCORPORATED, IN JOINT VENTURE
3902641 Canada Inc
4165047 Canada Inc.
4Plan Consulting Corp.
6362222 CANADA INC., doing business as the Createch Group
Attain Insight Solutions Inc.
CISTEL TECHNOLOGY INC, TECSIS CORPORATION IN JOINT VENTURE
ETICO SOFTWARE INC.
Excel Human Resources Inc.
IBISKA Telecom Inc.
IBM Canada Ltd.
Lightning Tree Consulting, Burbek, and P.G. Rodier Consulting in Joint Venture
Newfound Recruiting Corporation
Teambuilder Consulting Inc.
WorkDynamics Technologies 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. 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 on an as required basis, to carry out and deliver the implementation of IBM Cognos TM1 Performance management software for the CNSC Planning, Forecasting and Cost allocation processes to support multiple lines of business. The main goal of the initiative is to design/develop, implement, and deliver the complete end-to-end solution that includes the above goals using IBM Cognos TM1 that will support the CNSC’s use of IBM Cognos TM1 within an integrated environment with different technologies including IBM Cognos BI, Reporting DataMart on MS SQL Server, and applicable in house applications and databases. The solution must meet both functional and technical requirements driven by the CNSC plan for Enterprise Planning and performance management.
 2.0 Scope
The CNSC is in the process of implementing the enterprise planning solution to support planning, forecasting, and cost allocation process using IBM Cognos TM1 . 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 began in April 2016 with project duration of eighteen months.  The analysis, design/develop, configuration, testing, training, and deployment of the complete 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: Review of the existing Cognos Enterprise Planning model ; 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 model/application architecture in support of forecasting, planning and cost allocation business processes at CNSC. He/she will clearly identify the delivery approach, the risks and outcomes; best practices, and 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 and provide guidance/roadmap on TM1 integration with existing Cognos BI, reporting datamart, and other databases/applications.
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 assess CNSC requirements to provide recommendation on future enhancement/ expansion plan. He/she will produce the technical documentation including but not limited to the TM1 model/application design documents and future growth opportunities and technical requirements to support the growth plan.
The TM1 Lead Architect will provide leadership and oversight to the TM1 Developer 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.
 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 TM1 Developer in fulfilling the tasks and deliverables identified in the Statement of Work
Ensures technical architecture of the TM1 solution is aligned to the CNSC’s IT Strategy
Execute the completion of the TM1 architecture and support TM1 models through all stages in the project life cycle.
Provide guidance and roadmap on IBM COGNOS TM1 integration with existing COGNOS BI environment, reporting datamart, and other database/applications
Provide guidance on security model and contribute to governance model
Responsible for the technical readiness assessment and future growth sizing

Provide roadmap to future expansion

Provide hands-on, expert technical assistance to IMTD team
Accountable for status updates, progress reports, resolution of issues and the completion of the vendor’s deliverables
Review/Identify 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 model/application development process, 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
Design 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
6.0 Deliverables
6.1 A.1 Application/Software Architect (TM1 Lead Architect)

Provide detailed Installation/Configuration documentation
Provide detailed TM1 model/application design architecture of the solution
Evaluate and provide options and recommendations on the solution architecture to meet the business requirements for the TM1 implementation taking the interoperability and integration requirements into consideration.

Provide roadmap to future enhancement/ expansion including sizing
Provide migration/upgrade strategy
Provide integration strategy with COGNOS BI and other COTS applications and applications developed in-house
Provide index of all the documents created for the project with detailed descriptionProvide security model, recommendation on security model, and contribute to governance model with best practice recommendation

Incumbent:
The work has not been 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: Dan Simard
Phone Number: 613-996-6784
Email Address: d••••••••@••••••.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