ANNEX “A”
STATEMENT OF WORK – TBIPS-SA 14-22019
A.6 Programmer/Software Developer Level-2
1.0 TITLE
NRC Electronic Work Environment (NEWE) Project
2.0 Background
NRC’s new mission to promote greater private sector innovation in Canada must be supported by a more efficient and effective information management (IM) framework that facilitates collaboration, promotes knowledge sharing, provides better business intelligence and increased business value. This dictates a need for the new NRC Electronic Work Environment that will support the new organizational structure and bring NRC into adherence with the TBS Directive on Recordkeeping. The project is being implemented by NRC Knowledge Management (KM) in collaboration with NRC Information Technology and Security Services (ITSS).
3.0 Objectives
- Establish modern electronic recordkeeping in key business areas (executive and management offices), extending the Electronic Records Management (a.k.a. eRecords) solution pilot implementation (achieved in an earlier project) with division and portfolio executive offices through SharePoint 2010 to all NRC business offices down to the management level through client engagement and information inventorying.
- Optimize SharePoint to support capturing, finding, sharing and management of business information by employees, the electronic records needs of NRC, the creation of new business information from raw data and allow all of NRC to operate in one shared electronic working environment.
- Work with SSC to upgrade the SharePoint 2010 infrastructure to meet NRC requirements.
- Enable SharePoint to integrate with other NRC platforms where NRC employees work and collaborate (e.g. business intelligence software, Zone Intranet, KM Collaborative Wiki, Email, NRC Customer Relations management System).
- Provide change management support to NRC employees using SharePoint 2010 through comprehensive education, training and support.
- Fulfil NRC business requirements for document and records management by conforming to TBS mandated requirements and implementing a Government approved electronic document and records management system linked to SharePoint 2010.
The objectives identified above and lack of intermediate-level SharePoint developer resources at NRC constitute an urgent requirement for one SharePoint 2010 Programmer to aid in the implementation of the NEWE project.
4.0 Description and Scope of Work
In the provision of service to NRC, the Contractor shall, on an "as and when required basis" and as described in a TA Form issued by NRC, provide (to the satisfaction of NRC Project Authority) the following Consultant services:
Tasks - SharePoint Programmer (SPP Level 2)
Working with SP developers of the joint KM and ITSS team at different levels, and under the direction of the NEWE Technical Lead, participate in SP 2010 solution development activities. The proposed resource must have proficiency in SP 2010 server side API, .NET 3.5, C#, ASP.NET, JavaScript and Windows PowerShell scripting; must have fluency with Site, Web and Library configuration settings and be able to create/deploy packaged SP 2010 work package solutions. The proposed resource must have experience with SP 2010 solution concept-proofing, prototyping and troubleshooting.
Specific deliverables and services requirements may include, but are not limited to, any combination of the following:
1. Perform technical analysis of business requirements and provide input on technical feasibility of each proposed solution:
- Identify problematic areas of each proposed implementation and help mitigate development risks.
- Provide SP 2010 technology-related recommendations based on gathered business requirements.
- Assist in designing, prototyping and developing solutions based on a NRC’s strategic business or technical requirements.
- Liaise with project technical lead and designated developer(s) to aid with workload estimates and other project planning issues.
2. Participate in solution prototyping, development, deployment and configuration:
- Take a consultative role in solution prototyping, integration and customizations as per the defined architecture and derived technical specifications.
- Aid the development team in creation and support of SP 2010 content type inheritance structures.
- Assist the development team with provisioning and maintenance of managed metadata columns.
- Provide assistance in Search configuration including faceting, search center and crawlers to index the searched content.
- Assist NRC developers with Content Type Hub publishing.
- Work with the NRC development team in user interface site customizations and definition creation of site and library templates definitions and instances.
- Create custom Web Parts as required for client-driven customizations.
- Create custom library forms, library document templates and workflows.
- Implement various Event Receivers and Feature Receivers.
- Assist the development team in implementation of the SharePoint Records Center and Content Organizer to further develop the NRC eRecords solution.
- Assist NRC developers in customizing SharePoint 2010 Server Ribbon user interface and on implementation of bilingual user interfaces.
- Create and troubleshoot custom timer jobs.
- Participate in periodic code walkthroughs with the development team.
- Assist developers with solution debugging using MS Visual Studio and provide consultations on errors detected by ULS viewer.
- Advise NRC SP developers on solution deployment procedures, help with deployment automation efforts and participate in deployment automation design and implementation. Troubleshoot issues with SP 2010 work packages and assist with deployment of solutions as server farm features.
- Participate in determining solution configurations ensuring alignment with NEWE objectives.
3. Help maintain a secure SP 2010 environment:
- Participate in definition of user roles and privileges.
- Assist the development team in programmatic implementation of security features.
- Check designs and solutions for potential security problems and suggest solutions to mitigate these problems.
4. Deliver scalable and extensible SP 2010 solutions to ensure optimal performance and availability:
- Aid in development and implementation of performance measuring tests to insure the continuous and reliable solution availability and response.
- Analyze various factors and parameters which may degrade performance of the proposed solutions.
- Assist in tuning SP 2010 internal parameters for best performance of the software.
5. Participate in SP software upgrades and migration to new releases:
- Provide input on impact SP software upgrades and patching may have on developed solutions.
- Participate in evaluation of SP migration tools and provide technological analysis of proposed tools, methodologies and processes to achieve SP 2010 to 2013 migration as required.
- Work with the project technical lead and the technical team to develop migration scenarios and, possibly, scripts when/if NRC adopts SP 2013.
- Provide assistance with evaluation of 3-rd party migration tools for SP 2013.
5.0 Deliverable(s)
Working under the direction of the Director, Information management Servicesproject manager, technical lead or their delegate(s):
1. Informal progress updates to the project technical lead or his/her designated delegate, as required (depending on work load and tasks). Format of reports to be in plain text (e-mail is acceptable).
a. Deliverables will be specified within the TA Form issued under the terms and conditions of the resulting TA Contract. The scope of work attached to the TA Form shall identify the particular deliverable(s), tasks, and other relevant areas of consideration that are required to be implemented by the Contractor in the provision of services. Typical deliverables include (but may not be limited to): code segments and scriptlets; written or verbal recommendations; prototypes implemented and ready for deployment in NRC Test environment unless meant to be incorporated in other solutions; debugging logs; technical specifications; written rationales for a particular technical specification; presentations, flowcharts representing solution logic; site topology diagrams, SP 2010 farm configuration suggestions; other technical tips and tricks related to SP 2010 development.
b. It is the responsibility of the Contractor to ensure that all written deliverables and services provided are in conformance with the NRC standard desktop software, currently Microsoft (MS) Office Suite (including Word, Excel, and PowerPoint) or compatibles, unless plain text or e-mail are specified as acceptable formats.
c. In meeting its obligations under the TA Contract and any resulting Task(s), the Contractor shall ensure that all Deliverables submitted and services rendered are in conformity with the instructions issued by NRC Project Authority as specified in the TA Form, and in accordance with Performance Standards and Reporting.
2. The Contractor shall submit all scheduled and requested deliverables, and required revisions thereto, to NRC Project Authority (or this person’s due designate) in accordance with the timing as set out in each Task. All text deliverables shall be delivered in both hard and electronic formats. All programming code deliverables will be delivered in accordance with standards and practices used by KM Business Applications.
6.0 Reporting
o The Contractor shall provide other ad hoc written or oral status updates upon request from the NRC Project Authority in relation to any and all TA Form(s) issued to the Contractor.
o The Contractor shall immediately report to the Project Authority any risks and issues which are affecting progress of the work and, in the opinion of the Contractor, require escalation to resolve.
o In addition to the provision of services as described in (Description and Scope of Work), the Contractor shall submit the following on an “as and when required” basis, to NRC Project Authority:
? Written progress and/or status reports relating to the delivery of specific services and completion of assigned tasks; and
? Copies of signed monthly time sheets for all assigned resources indicating actual hours worked. NRC will only accept costs for work actually performed, and in accordance with signed monthly time sheets.
o The timing and format of any other required reports will be specified within the TA Form.
•
7.0 Resources for NRC to support NEWE
- SharePoint Programmer (SPP Level 2) – (Intermediate Solution Support) – IM solution design, logic models, flowcharts, prototyping, solution implementation, debugging and troubleshooting, development of written guidelines, support to a variety of IM software implementation activities.
8.0 Timeframe & Resources
12 months, with one additional optional period of 12 months.
Spend limit for each 12 month period: $50,000. NRC intends to spend all allocated budget spreading it more or less evenly throughout each 12-month period.
9.0 Location and culture of work
NRC recognizes added value of flexible work schedules. In this spirit, the proposed resource will have to be able to work under minimal or no supervision at a workplace of his/her choice and on a timetable that allows most efficient productivity in view of the resource’s possible other ongoing duties and tasks.
NRC will strive to perform collaborative work as much as possible through video- and teleconferencing means and will offer a CloudShare account to provide code and ideas sharing virtual environment. The Contractor shall have to advise the project technical lead or his/her designated delegate on the expected number of work hours to complete each assignment. It is desirable to complete each assignment within a 1-week period since its receipt if the estimated workload is 8 hours or less, longer periods will be considered for longer assignments. There may be rare occasions when the proposed resource may have to be present in person at NRC Bldg. M-55, 1200 Montreal Road, Ottawa, ON for a stakeholders meeting or a brainstorming event.
The contractor will have building access to and a workstation at NRC Bldg. M-55, 1200 Montreal Road, Ottawa, ON, if the contractor chooses to work at NRC on site. Workstation space may be shared between consultants performing services in non-overlapping time periods.
