SPICT - A.6 Programmeur / réalisateur de logiciel niveau 3 (APM)

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

Reference Number:
87055-17-0032
Solicitation Number:
87055-17-0032
Organization Name:
Canadian Nuclear Safety Commission
Solicitation Date:
2017-05-04
Closing Date:
2017-05-18 02:00 PM Eastern Daylight Time (EDT)
Anticipated Start Date:
1 to 2 months from closing date
Estimated Delivery Date:
Estimate Level of Effort:
260 days (including Option Period)
Contract Duration:
As and when required basis. Programmer/Software Developer for 130 days (over 10- month period), plus one 130-day irrevocable option (over 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.6 Programmer/Software Developer
The following SA Holders have been invited to submit a proposal:
1728193 ONTARIO INC., 6123937 CANADA INCORPORATED, IN JOINT VENTURE
4165047 Canada Inc.
7792395 Canada Inc.
A Hundred Answers Inc.
Action Personnel of Ottawa-Hull Ltd
Altis Human Resources (Ottawa) Inc., and Excel Human Resources Inc., in Joint Venture
Dare Human Resources Corporation
Equasion Business Technologies Consulting Inc and Watershed Information Technology Inc in CJV
Excel Human Resources Inc.
Gnostyx Research Inc.
IBM Canada Ltd.
Info-Electronics H.P. Systems Inc.
Lightning Tree Consulting, Burbek, and P.G. Rodier Consulting in Joint Venture
Metaflow Inc.
Newfound Recruiting Corporation
Nexus Systems Group Inc.
Symbiotic Group Inc.
The Barrington Consulting Group Inc.
Tiree Facility Solutions Inc.
Turtle Island Staffing 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.6 Programmer / Software Devloper (TM1 Developer)
The TM1 Developer will be responsible for the development of the complete end-to-end solution to be deployed in production using IBM COGNOS TM1, 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, maintenance and testing activities.
The TM1 Developer will provide knowledge transfer sessions to the CNSC staff throughout the duration of the project including guidance on future expansion of the TM1 solution (where applicable).  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.6 Programmer / Software Developer (TM1 Developer)

Reviews and analyses business and systems requirement documents and translates them into an efficient technical TM1 solution.
Document all aspects of the solution design/development, testing, implementation and detailed deployment instructions
Responsible for installing and configuring TM1 suite of applications in a distributed environment, including integration to the existing COGNOS BI
Build and deliver the successful technical solutions that involve all TM1 components and related COGNOS BI components/tools e.g.: cubes, dimensions, processes, rules, securities, workflows, applications, web deployments, Cognos insight, Framework manager etc.
Working with the TM1 architect in solution design alternatives and fostering best practices.
Develop and document complete TM1 installation and configuration procedure.
Design, develop, and implement COGNOS TM1 applications for Financial Planning and Budgeting models with complex rules and test all deliverables (including prototypes) in Development, Integration, QA and Production.
Designing and documenting TM1 users, roles and Security.
Fine-tune TM1 solution to maximize system performance and hardware utilization.
Working with the internal CNSC Tech lead to troubleshoot any TM1 incidents as necessary.
Review feedbacks, address requirements shift (if any)
Analyze and validate data to ensure data integrity
Document model design and data flow.
Design, test and implement user interfaces to the IBM COGNOS TM1/BI platforms (Customize interface if required using HTML/XML and/or editing/updating/customizing install files)
Build models and “what-if” analysis to simulate different scenarios. Provide best practices.
Perform analysis with the business client to ensure financial results are accurate and complete
Develop the complete end-to-end solution according to the business requirements using IBM COGNOS TM1, and integrate TM1 solution with existing COGNOS BI environment (eg: authentication, portal etc..), Data warehouse/DataMart, ETL Process, and other in-house applications/databases
Build and test automation processes
Document content / model/ Application movement between environments
Advise and assist with build issues
Work closely with key users to ensure that data entry, retrieval, change and delete functions meet business requirements for project completion.
Coordinate and work with the internal CNSC Tech lead.
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 including guidance on future expansion/enhancement
Create document on IBM COGNOS TM1 version upgrade/migration path/checklist
Prepare development best practices document
Contribute to the development and delivery of end-user training
Transfer knowledge to CNSC staff throughout the process

6.0 Deliverables

6.1  A.6 Programmer / Software Developer (TM1 Developer)

Document solution design/development and detailed deployment instructions
Provide detailed Installation/Configuration documentation

Provide Test plan documentation
Document model/application design and data flow
Document best practices identified in line with CNSC requirements
Document guidance on future TM1 model/application enhancement/modification/expansion
Document TM1 model/application migration/move from one environment to another environment
Document Any reporting requirements identified in section 8
Document Any IBM COGNOS TM1/ COGNOS BI reports developed

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