Database Analyst – Level 2, Programmer / Analyst – Level 2, Technical Writer – Level 3

NOTICE OF PROPOSED PROCUREMENT (NPP) For TASK BASED INFORMATICS PROFESSIONAL SERVICES (TBIPS) GSIN: D302A ADP SYSTEM DEVELOPMENT SERVICES Reference Number: 17-128902 Solicitation Number: 17-128902 Organization Name: Department of foreign Affairs, Trade and Development Solicitation Date: 2017-03-16 Closing Date: 2017-03-03 02:00 PM Eastern Daylight Saving Time EDT Anticipated Start Date: 2017-03-13 Estimated Delivery Date: 2017-03-13 Estimate Level of Effort:

Five hundred and twenty (520)days for initial period divided between three (3) resources

Contract Duration: The contract period will be for six (6) months from the date of contract with an irrevocable option to extend it for up to one (1) additional two (2)-month period Solicitation Method: Competitive Comprehensive Land Claim Agreement Applies: No Number of Contracts: Up to three (3) Applicable Trade Agreements:

World Trade Organization Agreement on Government Procurement (WTO-AGP),  the North American Free Trade Agreement (NAFTA),  the Canada-Chile Free Trade Agreement (CCFTA),  the Agreement on Internal Trade (AIT),  the Canada-Peru Free Trade Agreement (CPFTA),  the Canada-Columbia Free Trade Agreement (CColFTA), and  the Canada-Panama Free Trade Agreement (CPanFTA)

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) Database Analyst, Level 2 One (1) Programmer / Analyst, Level 2 One (1) Technical Writer, Level 3 The following SA Holders have been invited to submit a proposal: SUPPLIER LIST 2i Solutions Inc. 8si Inc. A Hundred Answers Inc. Adga Group Consultants Cache Computer Consulting Calian LTD. Confluence Consulting Inc. in Joint Venture with the Corporate Renaissance Group CSI Consulting Inc. Donna Cona Inc. I4C Information Technology Consulting Inc. IBM Canada Ltd. iFathom Corporation IT/Net – Ottawa Inc. Jumping Elephants incorporated Leverage technology Resources Inc. Farlance Systems Inc. In joint venture Lim Geomatics Inc. Maplesoft Consulting Inc. MDOS Consulting Inc. Microsoft Canada Newfound Recruiting Corporation KPMG LLP Prolity Corporation Protak Consulting Group Inc. Randstad Interim Incorporated S.I. Systems Ltd. Sierra Systems Group Inc. Spaghetti Logic Inc. Description of Work: DFATD is the custodian of a complex international portfolio of more than 2,000 crown-owned and leased properties, including 1,887 staff quarters, with a total replacement value estimated at more than $3 billion. This inventory of special use and complex structures must be frequently adjusted to successfully support Government priorities and strategies, a challenging goal given the fast changing nature of international relations, trade and development opportunities. This includes adequately accommodating and providing work space for over 2000 Canada based staff (CBS) and over 5,000 locally engaged staff (LES), working in over 174 missions in 107 foreign countries for 21 partners, comprised of other departments, agencies and sub-agencies, and 10 co-locators (e.g. Export Development Canada and various provincial governments).  The management of this complex real property portfolio is under the responsibility of two entities: one responsible for planning and the other for delivery. Properties are either leased or owned. For example, in 2014-2015, the capital budget was approximately $170.9M and the operating budget, which includes spending of all missions, was $332.3M. Each year, 90 major capital projects are managed and advice regarding the execution of 250-300 at missions. These major and minor projects include maintenance and repair projects as well as capital projects to extend the life of existing assets, replace real property assets at the end of their useful life or acquire new assets in response to government or departmental priorities. Interventions include divesting real property assets which no longer meet the operational requirements of the mission network or do not contribute to government, DFATD and other partners’ priorities. Starting in July 1993, the real property function was overseen by the Physical Resources bureau which operated as Special Operating Agency under DFATD’s International Platform Branch. Such a status is usually granted to service delivery units to increase management flexibility through selected authorities in return for agreed upon levels of performance and results. In 2012, physical security was added to roles and responsibilities which include advice and guidance on technical aspects of physical security safeguards, management of chancery electronic security systems, purchase and deployment of armored vehicles, lock and key service and coordination of international shipping and warehousing services. The management of the real property function is closely integrated with the Department in key reporting and management fields such as finance, contracting and human resources (HR), these services being channeled through the International Platform Branch or other departmental branches. Legal support, which is essential for an organization that executes dozens of contracts every year, is provided by Justice Canada. Although primary real property accountabilities rest with the entities responsible for the management of real property, missions and regional services centers play an essential complementary role. Property management for respective missions (e.g. approval of staff quarter (SQ) leases within rent ceilings and their allocation) is the responsibility of the Heads of Mission (HOM) with most property management functions being delegated to the Management/Consular Officer (MCO) or Property Officer under the direction of the MCO, such as: •Managing the inventory of SQs; •Developing real property strategies •Conducting regular real property inspections to forecast future repair and maintenance requirements; •Overseeing routine maintenance; and •Maintaining up-to-date paper and electronic records. On May 29, 2014, a decision was taken by Treasury Board (TB) to undertake an Independent Third Party Review of the Department of Foreign Affairs, Trade and Development (DFATD) real property function. A consultant was retained to undertake this work. A report with 9 recommendations was completed in May 2015. A related work plan was developed with 9 intervention streams and is being implemented since fall 2015. However, additional transformational interventions are required to reinforce real property management some of which include an information technology (IT) dimension. Real property management is done with help from a division (IT Services) which oversees the maintenance of portfolio supporting applications. These applications are offered on a wide variety of technologies, but have been, over time, consolidating to a single Structured Query Language (SQL) backend database and Component Scalable Logical Architecture (CSLA) Data Portal to serve data to applications. All new applications are being developed with these technologies. This work requires collaboration with the departmental IM-IT Bureau. IT maintenance mostly takes the form of overseeing custom built and supported software. Some of these applications are at end of life and can no longer be supported. Furthermore, others function in isolation; data sharing with each other or the GAC corporate data warehouse is also often insufficient.  As part of the efforts to transform the real property function, several business processes are being reviewed or must be added or redesigned for the purpose of improving performance. This optimization will enable the organization to be more efficient and more effective. Redesign of business processes includes both a work dimension and a technological dimension. These improvement efforts are expected to last three (3) years with the first year targeting tools and applications in crisis and developing a plan for the “way forward” for additional interventions. During all three (3) years, changes will be planned, designed and implemented; the development of tools and applications will also be planned, overseen and done. Incumbent Information: The Technical Writer work is currently being performed partially by Excel HR under contract (value $77,244.00). There are no incumbents in the Database Analyst or Programmer/Analyst roles. Security Requirement: Common PS SRCL #19 applies Minimum Corporate Security Required: SECRET Minimum Resource Security Required: SECRET Contract Authority Name: Nina Rejhon Phone Number: 343-203-5504 Email Address: nina.rejhon@international.gc.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 RCNMDAI.-NCRIMOS@pwgsc.gc.ca