TBIPS- A.7 Programmer / Analyst - Level 2

Requirement DetailsTendering Procedure: Selective TenderingThis 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 2 Programmer / Analyst The following SA Holders have been invited to submit a proposal:Accenture Inc.ADGA Group Consultants Inc.Adhartas Consulting GroupConfluence Consulting Inc.Coradix Technology Consulting Ltd.EmerionExcel Human Resources Inc.IT/NET – Ottawa Inc.Maplesoft Consulting Inc.Mindwire Systems Ltd.MNP LLPRobina and Biban Associates Inc.Sierra Systems Group Inc.Sundiata White Group – Intellistaff Ltd.Unisys Canada Inc.1. MANDATEIndustry Canada (IC) works with Canadians in all areas of the economy and in all parts of the country to improve conditions for investment, enhance Canada's innovation performance, increase Canada's share of global trade and build a fair, efficient and competitive marketplace.This includes managing Canada's airwaves and overseeing its bankruptcy, incorporation, intellectual property and measurement systems; providing financing and industry research tools to help businesses develop, import and export; encouraging scientific research; and protecting and promoting the interests of Canadian consumers.2. ORGANIZATIONThe Chief Information Office (CIO) is mandated to maximize Industry Canada's business performance through modern and progressive management of information management (IM) and information technology (IT) services, policies, and resources. The CIO Branch is specifically responsible for:Establishing IM/IT strategies and policies that support the overall mandate of the Department and are consistent with established funding envelopes;Aligning IM/IT resources with departmental priorities and IM/IT plans through a practical governance structure;Providing high-quality, affordable IM/IT services to departmental business partners;Providing high-quality and responsive support to departmental IM/IT users; andEstablishing department-wide technology standards and architecture to maximize opportunities for horizontal investments in IM/IT across the department.The Business Services Branch (BSB) is responsible for the development of solutions and applications as well as the maintenance of existing systems to support Industry Canada enterprise and business units.Services are delivered through four organizational directoratesBusiness SolutionsIT ModernizationEnterprise SolutionsSITT & CIPO Development and SupportThe SITT & CIPO Development and Support Directorate are responsible for the following:Support of existing systemsCIPO specific middlewareCIPO mainframe database and data administrationThis requirement will fall under the support of existing systems which includes the following:Responsible for the maintenance and upkeep of business unit specific existing applications;Works closely with the business units to understand their needs and technical requirements;Manages dispensation of sun-setting application and/or technologies; andWorks closely with the development teams building replacement systems in order to ensure proper migration of data, effective integration and compatibility with the existing system during the release and roll-out.3. PROJECT OVERVIEW - CIPO IT IMPLEMENTATION OF BILLS C-31 AND C-8 FOR TRADE-MARKSMajor changes to the main Trade-marks system are required to allow the new Nice Classification, business process changes due to the Singapore Treaty as well as the compliance to the Madrid Protocol. The Nice Classification is an international agreement on classifying goods and services in relation to trade-marks. As a result system changes are required to enable applicants to select the Nice classes of trade-marks with their application. The implementation of the Nice Agreement will require changes to the electronic commerce filing system which accounts for 96% of new trade-marks applications as well as changes to the trade-marks processing system to handle the individual Nice classes.The Singapore Treaty harmonizes the processing of trademark applications among member countries. In the case of Canadian trade-marks, Singapore has significant impact on a number of processes/rules. In addition, other process changes were introduced in Bill C-31 and C-8 that impact the trade-mark processing system.The Madrid Protocol is an international agreement to allow the filing of a trade-marks application in one member country and then designate other member states for protection. The processing of these international applications requires additional workflow steps to the Canadian trade-mark filing process. In addition to these processing steps there is a requirement to transfer the international application/registration between CIPO and World Intellectual Property Organization (WIPO).Project tasks are centered around the analysis design, development, implementation and support of Team Developer applications based on specifications and requirements according to IC’s standards and guidelines and legislative requirements.4. SCOPE OF WORK There is a requirement for a Programmer Analyst level 2 to assist the CIPO IT Implementation of Bills C-31 and C-8 for the Trade-Marks project team providing expertise in Team Developer (also known as Centura/SQL Windows).4.1 TASKS AND KEY ACTIVITIESDuties and key activities may include the following:Requirements analysis;Meet with stakeholders/clients to validate or gather requirementsSystems design;Present demos to stakeholdersApplications development;Create and modify Team Developer code (screens, functions, Active X call, etc.)Set up data in Oracle RDBMSCreate and modify Word documents (including Word macros)Create and modify PL/SQL stored proceduresCreate and modify Oracle tables and columnsPerform unit testingCreation/execution of performance, scalability, system, functional and integration test plans;Create test scriptsApplications maintenance;Documentation development and updatesDesign documentsTechnical documentsCollaborate with team members including Project Manager, Team Lead and application developers;Provide updates/status reporting to project team management.Complete and submit project timesheets for weekly approval using internal project tracking system4.2 DELIVERABLESDeliverables may include the following:Requirements analysis;Demos to stakeholdersSystems design;Applications development;Test scripts, test plansApplications maintenance;Documentation development and updatesMeetings with team members including Project Manager, Team Lead and application developers;Reports (status, tracking tools, etc…)Documentation (Forms, manuals, designs, technical process guides, etc…)5. MANAGEMENT OF PROJECTThis resource reports to a project manager within the SITT & CIPO development and Support Directorate who is responsible for the CIPO Team Developer applications.6. WORK LOCATIONThe contractor will carry out the work on Industry Canada premises located at 235 Queen Street, Ottawa, Ontario.Security Requirement: PWGSC FILE # Common PS SRCL #2 applies Minimum Corporate Security Required: FSC - Reliability Minimum Resource Security Required: ReliabilityContract AuthorityName: Stephanie ClerouxPhone Number: 343-291-1358Email Address: stephanie.cleroux@ic.gc.caInquiriesInquiries 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