SAQMMA08R0244.pdf

SOLICITATION, OFFER, AND AWARD

1. THIS CONTRACT IS A RATED ORDER UNDER DPAS (15 CFR

700)

RATING

2. CONTRACT NUMBER 3. SOLICITATION NUMBER

SAQMMA08R0244 SEALED BID (IFB)

X NEGOTIATED (RFP)

4. TYPE OF SOLICITATION 5. DATE ISSUED

08/08/2008

6. REQUISITION/PURCHASE NUMBER

CODE: LMAQM

OFFICE OF ACQUISITION MANAGEMENT (A/LM/AQM)

PO BOX 9115, ROSSLYN STATION

US DEPARTMENT OF STATE

ARLINGTON, VA 22219

7. ISSUED BY

OFFICE OF ACQUISITION MANAGEMENT (A/LM/AQM)

PO BOX 9115, ROSSLYN STATION

US DEPARTMENT OF STATE

ARLINGTON, VA 22219

8. ADDRESS OFFER TO (If other than Item 7)

NOTE: In sealed bid solicitations "offer" and "offeror" mean "bid" and "bidder".

SOLICITATION

CAUTION - LATE Submissions, Modifications, and Withdrawals: See Section L, Provision No. 52.214-7 or 52.215-1. All offers are subject to all terms and conditions contained in this solicitation.

9. Sealed offers in original and ____ copies for furnishing the supplies or services in the Schedule will be received at the place specified in item 8, or if handcarried, in the depository located in __Room 200__ until __17:00:00__ local time __09/15/2008 __

10. FOR

INFORMATION

E-MAIL:

A. NAME

Deborah Carey 703-875-4229

B. TELEPHONE (NO COLLECT

CALLS)

C. E-MAIL ADDRESS

careyda@state.gov

11. TABLE OF CONTENTS (See Table of Contents on page 2)

(X) SEC. DESCRIPTION PAGE(S) (X) SEC. DESCRIPTION PAGE(S)

PART I - SCHEDULE PART II - CONTRACT CLAUSES

A SOLICITATION/CONTRACT FORM X I CONTRACT CLAUSES 31

X B SUPPLIES OR SERVICES AND PRICES/COSTS 4 PART III - LIST OF DOCUMENTS, EXHIBITS AND OTHER ATTACHMENTS

X C DESCRIPTION/SPECS./WORK STATEMENT 9 J LIST OF ATTACHMENTS

D PACKAGING AND MARKING PART IV - REPRESENTATIONS AND INSTRUCTIONS

E INSPECTION AND ACCEPTANCE X K REPRESENTATIONS CERTIFICATIONS AND OTHER

STATEMENTS OF OFFERORS

X F DELIVERIES OR PERFORMANCE 27

X L INSTRS., CONDS., AND NOTICES TO OFFERORS 43X G CONTRACT ADMINISTRATION DATA 28

X M EVALUATION FACTORS FOR AWARD 55X H SPECIAL CONTRACT REQUIREMENTS 30

OFFER (Must be fully completed by offeror)

NOTE: Item 12 does not apply if the solicitation includes the provisions at 52.214-16, Minimum Bid Acceptance Period.

In compliance with the above, the undersigned agrees, if this offer is accepted within __________ calendar days (60 calendar days unless a different period is inserted by the offeror) from the date for receipt of offers specified above, to furnish any or all items upon which prices are offered at the price set opposite each item, delivered at the designated point(s), within the time specified in the schedule.

12.

13. DISCOUNT FOR PROMPT PAYMENT (See Section I, Clause No.

52.232-8)

10 CALENDER DAYS(%)

0.00 %

20 CALENDER DAYS(%)

0.00 %

30 CALENDER DAYS(%)

0.00 %

0 CALENDER DAYS(%)

0.00 %

14. ACKNOWLEDGEMENT OF AMENDMENTS (The offeror acknowledges receipt of amendments to the SOLICITATION for offerors and related documents numbered and dated):

AMENDMENT NO. DATE AMENDMENT NO. DATE

15A. NAME AND

ADDRESS OF

OFFEROR

CONTACT: DUNS: 16. NAME AND TITLE OF PERSON AUTHORIZED TO SIGN OFFER (Type or Print)

15B. TELEPHONE NUMBER

15C. CHECK IF REMITTANCE ADDRESS IS DIFFERENT FROM

ABOVE - ENTER SUCH ADDRESS IN SCHEDULE.

17. SIGNATURE 18. OFFER DATE

AWARD (To be completed by Government)

19. ACCEPTED AS TO ITEMS NUMBERED 20. AMOUNT 21. ACCOUNTING AND APPROPRIATION

10 U.S.C. 2304(c) ( ) 41 U.S.C. 253(c) ( )

22. AUTHORITY FOR USING OTHER THAN FULL AND OPEN COMPETITION: 23. SUBMIT INVOICES TO ADDRESS SHOWN IN (4 copies unless otherwise specified)

ITEM

CODE:24. ADMINISTERED BY (if other than Item 7) CODE: RMGFO

GLOBAL FIN. SVCS (RM/GFS/ADO/FM) CHARLESTON, SOUTH

PO BOX 150008; Fax To: 1-866-483-3436

OFFICE OF CLAIMS (RM/GFS/F/C)

CHARLESTON, SC 29415-5008

25. PAYMENT WILL BE MADE BY

26. NAME OF CONTRACTING OFFICER (Type or print)

Reaver Clements

(Signature of Contracting Officer)

27. UNITED STATES OF AMERICA 28. DATE

08/08/2008

IMPORTANT - Award will be made on this Form, or on Standard Form 26, or by other authorized official written notice.

AUTHORIZED FOR LOCAL REPRODUCTION

Previous edition is unusable

STANDARD FORM 33 (REV. 9-97)

Prescribed by GSA - FAR (48 CFR) 53.214(c)

SAQMMA08R0244

Table of Contents

Section Description Page Number

B Supplies or Services and Prices/Costs B-008 Travel Costs (Time-and-Materials/Labor-Hour)

C Descriptions/Specifications/Statement of Work STATEMENT OF WORK; PT. 1 "Project Management, Database Management, Operational Maintenance, Systems Architecture, Software Design and Development" STATEMENT OF WORK PT.2 "Project Management, Database Management, Operational Maintenance, Systems Architecture, Software Design and Development"

F Deliveries or Performance F-006 Period of Performance F-007 Place of Performance

G Contract Administration Data 01INV Invoice Instructions

H Special Contract Requirements H-1 Security Clearance Requirement

H-002 DEPARTMENT OF STATE PERSONAL IDENTIFICATION CARD ISSUANCE

PROCEDURES (AUG 2007)

H-004 CONTACT INFORMATION FOR SENSITIVE AND/OR OPERATIONAL POSITIONS

I Contract Clauses 52.202-1 Definitions 52.203-3 Gratuities (Apr 1984) 52.203-5 Covenant Against Contingent Fees (Apr 1984) 52.203-6 Restrictions On Subcontractor Sales To The Government (Sept 2006) 52.203-7 Anti-Kickback Procedures (Jul 1995) 52.203-8 Cancellation, Rescission, and Recovery of Funds for Illegal or Improper Activity (Jan 1997) 52.203-10 Price Or Fee Adjustment For Illegal Or Improper Activity (Jan 1997) 52.203-12 Limitation On Payments To Influence Certain Federal Transactions (Sept 2007) 52.204-4 Printed or Copied Double-Sided on Recycled Paper (Aug 2000) 52.204-7 Central Contractor Registration (Apr 2008) 52.204-9 Personal Identity Verification of Contractor Personnel. (Sept 2007) 52.208-8 Helium Requirement Forecast And Required Sources For Helium (Apr 2002) 52.209-6 Protecting the Government's Interest When Subcontracting With Contractors Debarred, Suspended, or Proposed for Debarment (Sept 2006) 52.215-2 Audit and Records--Negotiation (June 1999) 52.215-8 Order of Precedence--Uniform Contract Format (Oct 1997) 52.215-15 Pension Adjustments and Asset Reversions (Oct 2004) 52.215-18 Reversion or Adjustment of Plans for Postretirement Benefits (PRB) Other than Pensions (July 2005) 52.215-19 Notification of Ownership Changes (Oct 1997) 52.216-29 Time-and-Materials/Labor-Hour Proposal Requirements - Non-Commercial Item Acquisition With Adequate Price Competition (Feb 2007) 52.222-1 Notice to the Government of Labor Disputes (Feb 1997) 52.222-2 Payment for Overtime Premiums (July 1990) 52.222-3 Convict Labor (June 2003) 52.222-21 Prohibition of Segregated Facilities (Feb 1999) 52.222-26 Equal Opportunity (Mar 2007) 52.222-35 Equal Opportunity for Special Disabled Veterans, Veterans of the Vietnam Era and Other Eligible Veterans (Sept 2006) 52.222-36 Affirmative Action for Workers with Disabilities (June 1998) 52.222-37 Employment Reports on Special Disabled Veterans, Veterans of the Vietnam Era, and Other Eligible Veterans (Sept 2006) 52.222-39 Notification of Emlpoyee Rights Concerning Payment of Union Dues or Fees (Dec 2004) 52.222-41 Service Contract Act of 1965. (Nov 2007) 52.222-43 Fair Labor Standards Act and Service Contract Act - Price Adjustment (Multiple Year and Option) (Nov 2006) 52.222-44 Fair Labor Standards and Service Contract Act - Price Adjustment (Feb 2002) 52.222-50 Combating Trafficking in Persons (Aug 2007) 52.223-3 Hazardous Material Identification and Material Safety Data (Jan 1997)

52.223-5 Pollution Prevention and Right-to-Know Information (Aug 2003) 52.223-6 Drug Free Workplace (May 2001) 52.223-14 Toxic Chemical Release Reporting 52.224-1 Privacy Act Notification (Apr 1984) 52.224-2 Privacy Act (Apr 1984) 52.225-13 Restrictions on Certain Foreign Purchases (June 2008) 52.229-3 Federal, State and Local Taxes (Apr 2003) 52.229-4 Federal, State and Local Taxes (State and Local Adjustments) (Apr 2003) 52.232-1 Payments (Apr 1984) 52.232-17 Interest (June 1996) 52.232-23 Assignment Of Claims (Jan 1986) 52.232-25 Prompt Payment (Oct 2003) 52.232-33 Payment by Electronic Funds Transfer--Central Contractor Registration (Oct 2003) 52.233-1 Disputes (July 2002) 52.233-3 Protest after Award (Aug 1996) 52.233-4 Applicable Law for Breach of Contract Claim (Oct 2004) 52.237-3 Continuity Of Services (Jan 1991) 52.239-1 Privacy or Security Safeguards (Aug 1996) 52.242-13 Bankruptcy (July 1995) 52.243-3 Changes--Time-and-Material or Labor-Hours (Sept 2000) 52.244-2 Subcontracts (June 2007) 52.244-5 Competition In Subcontracting (Dec 1996) 52.244-6 Subcontracts for Commercial Items (Mar 2007) 52.249-6 Termination (Cost Reimbursement) (May 2004) 52.253-1 Computer Generated Forms (Jan 1991) 52.217-8 Option to Extend Services (Nov 1999) 52.217-9 Option to Extend the Term of the Contract (Mar 2000) 52.219-14 Limitations on Subcontracting (Dec 1996) 52.219-18 Notification of Competition Limited to Eligible 8 (A) Concerns (June 2003) 52.222-42 Statement of Equivalent Rates for Federal Hires (May 1989) 52.232-7 Payments under Time-and-Materials and Labor Hour Contracts (Feb 2007) 52.252-2 Clauses Incorporated by Reference (Feb 1998) 652.219-71 SECTION8(a) DIRECT AWARDS (AUG 1999) 652.237-72 Observance of Legal Holidays and Administrative Leave 652.242-70 Contracting Officer's Representative (COR)

K Representations, Certifications, and Other Statements of Offerors or Respondents 52.204-8 Annual Representations and Certifications (Jan 2006) 652.225-70 Arab League Boycott of Israel

L Instructions, Conditions, and Notices to Offerors and Respondents 52.204-6 Data Universal Numbering System (DUNS) Number (Apr 2008) 52.215-1 Instructions to Offerors--Competitive Acquisition (Jan 2004) 52.216-1 Type of Contract (Apr 1984) 52.233-2 Service of Protest (Sept 2006) 52.237-10 Identification of Uncompensated Overtime (Oct 1997) 52.252-1 Solicitation Provisions Incorporated by Reference (Feb 1998)

652.206-70 COMPETITION ADVOCATE/OMBUDSMAN

L-006 Questions Regarding Solicitation L-013 Communication Concerning Solicitation L-014 Instructions to Offerors L-015 Instructions to Offerors, part 2

M Evaluation Factors for Award 52.217-5 Evaluation of Options (July 1990) M-003 Basis for Award M-004 Evaluation Factors

001 PROGRAM MANAGER/PROJECT MANAGER (KEY

PERSON)

1,920.00 HR

Doc Ref No:

Delivery Date FOB:

Destination

002 SENIOR DATABASE ADMINISTRTOR (KEY PERSON) 1,920.00 HR

Doc Ref No:

Delivery Date FOB:

Destination

003 SENIOR DATABASE ARCHITECT/SYSTEMS

ARCHITECT (KEY PERSON)

1,920.00 HR

Doc Ref No:

Delivery Date FOB:

Destination

004 MID-LEVEL DATABASE ADMINISTRATOR 3,840.00 HR

Doc Ref No:

Delivery Date FOB:

Destination

005 JUNIOR DATABASE ADMINISTRATOR 1,920.00 HR

Doc Ref No:

Delivery Date FOB:

Destination

006 PEOPLESOFT DATABASE ADMINISTRATOR 1,920.00 HR

Doc Ref No:

Delivery Date FOB:

Destination

007 PROGRAMMER ANALYST 3,840.00 HR

Doc Ref No:

Delivery Date FOB:

Destination

008 TRAVEL (amount to be obligated will be determined prior to award)

0.00 LT

Doc Ref No:

Delivery Date FOB:

Destination

009 OTHER DIRECT COSTS (amount to be obligated will be determined prior to award)

0.00 LT

Doc Ref No:

Delivery Date FOB:

Destination

1001 PROGRAM MANAGER/PROJECT MANAGER (KEY

PERSON)

1,920.00 HR

Doc Ref No:

Delivery Date FOB:

1002 SENIOR DATABASE ADMINISTRATOR (KEY PERSON) 1,920.00

Doc Ref No:

Delivery Date FOB:

SAQMMA08R0244

Line Item Summary

Solicitation Number:

SAQMMA08R0244

Contract Number: Title: Date of Solicitation:

08/08/2008

Line Item No. Description Quantity Unit Unit Price Total Cost

1003 SENIOR DATABASE ARCHITECT/SYSTEMS

ARCHITECT (KEY PERSON)

1,920.00

Doc Ref No:

Delivery Date FOB:

1004 MID LEVEL DATABASE ADMINISTRATOR 3,840.00 HR

Doc Ref No:

Delivery Date FOB:

1005 JUNIOR DATABASE ADMINISTRATOR 1,920.00

Doc Ref No:

Delivery Date FOB:

1006 PEOPLESOFT DATABASE ADMINISTRATOR 1,920.00 HR

Doc Ref No:

Delivery Date FOB:

1007 PROGRAMMER ANALYST 3,840.00

Doc Ref No:

Delivery Date FOB:

1008 TRAVEL (amount to be obligated will be determined prior to award)

0.00

Doc Ref No:

Delivery Date FOB:

1009 OTHER DIRECT COSTS (amount to be obligated will be determined prior to award)

0.00

Doc Ref No:

Delivery Date FOB:

2001 PROGRAM MANAGER/PROJECT MANAGER (KEY

PERSON)

1,920.00 HR

Doc Ref No:

Delivery Date FOB:

2002 SENIOR DATABASE ADMINISTRATOR (KEY PERSON) 1,920.00 HR

Doc Ref No:

Delivery Date FOB:

2003 SENIOR DATABASE ARCHITECT/SYSTEMS

ARCHITECT (KEY PERSON)

1,920.00 HR

Doc Ref No:

Delivery Date FOB:

2004 MID LEVEL DATABASE ADMINISTRATOR 3,840.00 HR

Doc Ref No:

Delivery Date FOB:

2005 JUNIOR DATABASE ADMINISTRATOR 1,920.00 HR

Doc Ref No:

Delivery Date FOB:

SAQMMA08R0244

Line Item Summary

Solicitation Number:

SAQMMA08R0244

Contract Number: Title: Date of Solicitation:

08/08/2008

2006 PEOPLESOFT DATABASE ADMINISTRTOR 1,920.00 HR

Doc Ref No:

Delivery Date FOB:

2007 PROGRAMMER ANALYST 3,840.00 HR

Doc Ref No:

Delivery Date FOB:

2008 TRAVEL (amount to be obligated will be determined prior to award)

0.00 LT

Doc Ref No:

Delivery Date FOB:

2009 OTHER DIRECT COSTS (amount to be obligated will be determined prior to award)

0.00 LT

Doc Ref No:

Delivery Date FOB:

3001 PROGRAM MANAGER/PROJECT MANAGER (KEY

PERSON)

1,920.00 HR

Doc Ref No:

Delivery Date FOB:

3002 SENIOR DATABASE ADMINISTRATOR (KEY PERSON) 0.00 HR

Doc Ref No:

Delivery Date FOB:

3003 SENIOR DATABASE ARCHITECT/SYSTEMS

ARCHITECT (KEY PERSON)

1,920.00 HR

Doc Ref No:

Delivery Date FOB:

3004 MID LEVEL DATABASE ADMINISTRATOR 3,840.00 HR

Doc Ref No:

Delivery Date FOB:

3005 JUNIOR DATABASE ADMINISTRATOR 1,920.00 HR

Doc Ref No:

Delivery Date FOB:

3006 PEOPLESOFT DATABASE ADMINISTRATOR 1,920.00 HR

Doc Ref No:

Delivery Date FOB:

3007 PROGRAMMER ANALYST 3,840.00 HR

Doc Ref No:

Delivery Date FOB:

3008 TRAVEL (amount to be obligated will be determined prior to award)

0.00 LT

Doc Ref No:

Delivery Date FOB:

SAQMMA08R0244

Line Item Summary

Solicitation Number:

SAQMMA08R0244

Contract Number: Title: Date of Solicitation:

08/08/2008

3009 OTHER DIRECT COSTS (amount to be obligated will be determined prior to award)

0.00 LT

Doc Ref No:

Delivery Date FOB:

4001 PROGRAM MANAGER/PROJECT MANAGER (KEY

PERSON)

1,920.00 HR

Doc Ref No:

Delivery Date FOB:

4002 SENIOR DATABASE ADMINISTRATOR (KEY PERSON) 1,920.00 HR

Doc Ref No:

Delivery Date FOB:

4003 SENIOR DATABASE ARCHITECT/SYSTEMS

ARCHITECT (KEY PERSON)

1,920.00 HR

Doc Ref No:

Delivery Date FOB:

4004 MID LEVEL DATABASE ADMINISTRATOR 3,840.00 HR

Doc Ref No:

Delivery Date FOB:

4005 JUNIOR DATABASE ADMINISTRATOR 1,920.00 HR

Doc Ref No:

Delivery Date FOB:

4006 PEOPLESOFT DATABASE ADMINISTRATOR 1,920.00 HR

Doc Ref No:

Delivery Date FOB:

4007 PROGRAMMER ANALYST 3,840.00 HR

Doc Ref No:

Delivery Date FOB:

4008 TRAVEL (amount to be obligated will be determined prior to award)

0.00 LT

Doc Ref No:

Delivery Date FOB:

4009 OTHER DIRECT COSTS (amount to be obligated will be determined prior to award)

0.00 LT

Doc Ref No:

Delivery Date FOB:

B-008 Travel Costs (Time-and-Materials/Labor-Hour) 11/01/1996

(a) Except as otherwise provided herein, the Contractor shall be reimbursed for its reasonable actual travel costs in accordance with its usual accounting practices consistent with FAR Subpart 31.2, specifically FAR 31.205-46. Travel must be directly related to and required for performance of this contract, and authorized in advance and in writing by the Contracting Officer's Representative (COR). In no event shall costs associated with employee commuting be reimbursable as a direct cost under this contract.

SAQMMA08R0244

Line Item Summary

Solicitation Number:

SAQMMA08R0244

Contract Number: Title: Date of Solicitation:

08/08/2008

(b) Travel costs shall not be burdened with any indirect costs unless specifically allowable in accordance with the Contractor's usual accounting practices consistent with FAR Subpart 31.2. In no event shall travel costs be burdened with fee/profit.

(c) The Contractor shall include a breakout of all authorized travel expenses as an attachment to his invoices. Administrative support (coordination of travel arrangements, etc.) will be the responsibility of the Contractor.

(d) Should any Contractor personnel be requested to perform in any area which has been determined by the Department of State to be a hazardous duty area, hazardous duty premium pay will be payable at the same rate as would be given to Department of State direct-hire employees pursuant to Chapter 650 of the U.S. Department of State Standardized Regulations (Government Civilians, Foreign Areas). Each employee will be notified upon arrival at any hazardous duty area of the applicable rates, terms and conditions at the time of performance. Hazardous duty premium pay shall not be burdened with any indirect costs (e.g., overhead, G and A) or fee/profit.

(e) When local travel between the Contractor employee's regular place of performance and other locations is specifically authorized by the COR, transportation expenses shall be allowable costs under this contract. For the purposes of this clause, local travel means travel within a 50 mile radius of the Contractor employee's regular place of performance and does not include daily commuting or associated costs.

(f) For travel where use of a personal automobile has been specifically authorized by the COR, reimbursement shall be computed on the basis of actual miles traveled from starting point to destination. Other related miscellaneous expenses, such as tolls and parking fees, incurred in the performance of tasks authorized under this contract, will be reimbursed. Car rentals require advance approval by the COR and will be authorized only when consistent with good business practice. Allowable costs shall not exceed the actual cost of renting a compact automobile (a maximum of one for four Contractor personnel), unless extenuating circumstances (e.g., excess baggage) require other arrangements and subsequent COR approval is obtained.

(g) The Government will reimburse the Contractor for Contractor employee's travel time to or from other authorized work locations; except that for labor categories which are exempt from the Fair Labor Standards Act, a reimbursement will be allowed only for travel during the employee's regular working hours. The Contractor will not be reimbursed for time spent in stand down or temporary layovers for the convenience of the Contractor except as authorized by the Federal Travel Regulations.

(h) The Contractor shall be responsible for ensuring that all personnel who will be required to travel outside the United States have current and valid passports. The Contractor shall also be responsible for obtaining any visas required for travel to foreign countries under this contract. The Contractor shall make no direct labor charges for obtaining/maintaining passports and/or visas.

(end of clause)

Section C - Descriptions/Specifications/Statement of Work

STATEMENT

OF WORK; PT.

"Project Management, Database Management, Operational Maintenance, Systems Architecture, Software Design and Development"

07/30/2008

1. Introduction

The purpose of this statement of work (SOW) is to convey the requirements of the Department of State, Bureau of Human Resources Executive Office (HR/EX) to develop, implement, and support all information systems, plans, policies, and goals. The Systems Development Division (HR/EX/SDD) directs these elements. This section provides information that applies to the entire statement of work. The scope of work within this section provides the overall range of work to be performed. The later portion of the SOW provides specific requirements within the scope of work.

2. Background

The Executive Office of the Bureau of Human Resources (HR/EX) is responsible for the development and follow-on maintenance of application systems and the implementation of new technology in support of the Department’s global personnel requirements. The Bureau handles recruitment, assignment evaluation, promotion, discipline, career development, and retirement policies and programs for the Department's Foreign and Civil Service employees. HR/EX is responsible for help desk and network support, as well as web-based application development and maintenance. The Bureau supports over 1,000 local users in addition to providing technical support to multiple Department locations and posts worldwide, with a total population of approximately 25,000 employees.

The Department of State (DoS), Bureau of Human Resources (HR), has undertaken a strategic initiative to modernize its information systems and move to an open systems environment. This initiative has established the foundation for a modernized systems environment referred to as the Integrated Personnel Management System (IPMS), which currently runs on the Windows XP operating system and utilizes Oracle as its primary relational database management system. IPMS is the Bureau’s technical architecture that unifies disparate hardware platforms; eliminates redundant processes, duplicate data entry, and storage systems; and updates business applications in compliance with requirements needed to support the Department’s ability to cultivate a highly effective, flexible, diverse workforce. This program provides the Department and other federal agencies represented abroad to carry out its mission through effective utilization of its human resources, information assets, and cost-effective, well-maintained infrastructure and operations.

3. Purpose

The purpose of this SOW is to obtain the technical expertise for application development and maintenance to all components of the IPMS. Application development is defined as any and all new applications required to support the IPMS, as well as to provide those requirements approved by the government to enhance HR/EX’s overall functional areas. The contractor shall install configure and apply IPMS software/updates as specified in the SOW.

3.1 IPMS System Components

The Bureau of Human Resources, Systems Development Division is responsible for the development and follow-on maintenance of Human Resource Management (HRM) focused application systems and the implementation of new technology in support of the Department’s global personnel requirements, as well as database administration, help desk operations, and network infrastructure. The Bureau supports over 1,000 local users, in addition to providing technical support to multiple Department locations and posts worldwide, with a total population of approximately 25,000 direct hire employees.

The DoS Bureau of Human Resources (HR) has undertaken a strategic initiative to modernize its information systems and move to an open systems environment. This initiative has established the foundation for a modernized systems environment referred to as the Integrated Personnel Management System (IPMS). IPMS currently leverages the following technologies: Microsoft Windows XP client operating system; Microsoft Internet Explorer 6 and 7 internet browsers; Microsoft Windows 2003 servers; Oracle 9i and 10g; and Microsoft SQL Server 2000 and 2005. All of these environments operate in accordance with Department of State configuration guidelines.

IPMS provides the Bureau’s technical architecture that unifies disparate application architectures; eliminates redundant processes, duplicate data entry, and storage systems; and updates business applications in compliance with requirements needed to support the Department’s ability to cultivate a highly effective, flexible, diverse workforce. This program provides the Department and other federal agencies represented abroad with information technology solutions to carry out its mission through effective utilization of its human resources, information assets, and cost-effective, well-maintained infrastructure and operations (formally referred to as Diplomatic Readiness).

IPMS System Components

The IPMS program initiative is comprised of four major components: Global Employment Management System (GEMS), the HR Bureau Knowledge Center (HRKC), HR Online, and the Post Personnel System (PS).

GEMS

GEMS is the primary component of IPMS. It is a federalized commercial-off-the-shelf (COTS) Human Resource Management System (HRMS) purchased from PeopleSoft, which was implemented on April 19, 1999, to replace the Department's aging, non Year 2000 compliant mainframe personnel application, and provides internal and external interfaces (e.g., HR Online, Consolidated American Payroll Processing System (CAPPS), Student Training Management System (STMS), and the Knowledge Center). The DoS core PeopleSoft HRMS package consists of Human Resource Administration, Benefits, ePerformance, and a custom-built payroll interface module. The initial implementation of GEMS focused on replacement of legacy functionality to support personnel transaction processing for the Department’s direct-hire employee base.

The system rollout supports Department-wide executive and HR program offices, financial management/payroll offices, personnel security offices, etc., with an estimated customer base of 1,000 domestic users. GEMS is integrated with additional modules to support new appointment processing, workflow processing, automatic actions (within grade increases and COLAs), position management, employee maintenance, salary planning, and the OPM Central Personnel Data File (CPDF)/Enterprise Human Resources Integration (EHRI) reporting. The current version of GEMS in production is PeopleSoft 8.8.

GEMS is a vital component in the overall effort of the Department to recruit, develop, and retain the personnel necessary to accomplish its mission. The capabilities in the currently deployed modules are the foundation for future implementation and integration of additional human capital business functions, as well as other integrated custom modules made available through the use of the PeopleSoft toolkit. Key target functions include new legal requirements, enhanced performance evaluation processing, advanced processing for automated actions, security modeling, enhanced reporting and workflow, and system monitoring and measurement capabilities.

Additional PeopleSoft delivered HR components and required DoS personnel business processes will also be evaluated for inclusion in subsequent releases, e.g., eAPPs suite to include competency management, selection and recruitment, benefits administration, employee services, as well as archiving and data warehousing, etc.

The ultimate intent of the GEMS project is to strengthen DoS’s Human Resources processes and practices by adopting the best practices inherent in the PeopleSoft Human Capital Management (HCM) solution, thereby bringing DoS into compliance with DoS, OMB, OPM, and JFMIP requirements.

Bureau Knowledge Center

The HRKC is the Bureau’s data warehouse that is accessed using Business Objects, a COTS reporting tool, through an application client interface or a controlled web site on the Department’s intranet that provides users with general HR Bureau personnel data. The mission of the HRKC is to create a solid foundation for the HR Bureau Knowledge Management effort through collaboration and information sharing between the HR Bureau and DoS Knowledge Workers.

HR Online

HR Online is a suite of custom developed web-based applications that enforces business processes and captures personnel information that is not currently available in GEMS. It also allows employees access to their personnel data collected by the Department. It provides an automated user registration, single log on, and authentication. After log on, it controls user access to applications and application data based on roles assigned to the user. HR Online provides technical support staff with error logs to facilitate assisting HR users with system problems. Ultimately, HR Online will be the single access point for all HR web-based applications.

Post Personnel

The Post Personnel System (PS) is a custom-built application disseminated through the Post Administrative Software Suite (PASS) that provides personnel transaction processing of locally employed staff and tracking of U.S. government staff at posts and missions abroad. It is the HR system of record for employees hired at post.

Other Applications

HR/EX also develops and maintains applications used by other bureaus. Some of these applications were developed using Microsoft Access, and if feasible, will be migrated to the bureau’s standard Cold Fusion/Oracle environment under HR Online.

4. Scope of Work

The contractor shall provide the technical expertise for application development and maintenance for the Enterprise Systems Division (HR/EX/ESD) and the Systems Development Division (HR/EX/SDD).

Development is defined as any and all new applications required to support the Bureau’s overall mission, as well as to provide those requirements approved by the government to enhance HR/EX’s overall functional areas.

The Contractor shall provide database administration support, related development services and analysis to HR/EX/ESD, as described in this statement of work. The Contractor shall provide support logs, maintenance schedules and other documentation, as determined by the designated Government Project Manager (GPM). The contractor will coordinate applicable tasks with other staff members in HR/EX/SDD, HR/EX/ESD and Systems Oversight Division (HR/EX/SOD) as appropriate.

The following services (1 through 9) shall be requested of the contractor. Each service may include the listed subtasks, but are not limited to those listed.

1. Project Management

a. Receive and assign tasks

b. Manage team workload

c. Track and report progress against planned baseline project schedule

d. Level operations and development resources to maximize throughput

e. Facilitate site-level strategic planning

f. Coordinate site-level integration and deployment efforts

2. Database Administration

a. Install, configure and administer 30+ existing and unspecified number of new databases and components;

b. Review and upgrade database software versions as needed or required, including major version upgrades and Oracle patches;

c. Ongoing monitoring, tuning and management of resources across database environments

d. Ongoing operational support of all environments

e. Manage Backup and recovery solutions for databases

f. Secure database environments as required and documented by Diplomatic Security (DS)

g. Develop and maintain database management scripts as needed

h. Provide developer support with design, tuning and problem resolution

i. Provide administrative and configuration support of third-party components including:

- Quest Spotlight

- Symantec i3

- Veritas NetBackup

3. Informatica Administration

a. Schedule and monitor batch jobs

b. Provide administrative and troubleshooting support to developers

4. PeopleSoft Administration

a. Install, configure and administer PeopleSoft and components including:

• PeopleTools

• Application Servers

• Web Servers

• Batch Servers

b. Provide support in resolving PeopleSoft issues

c. Manage PeopleSoft development and test environments in support of the development and test teams

5. Site Architecture Management

a. Establish and document database environment standards

b. Recommend application development standards

c. Manage and maintain metadata supporting administration of environments

d. Design and document architecture

6. Software Configuration Management

a. Migrate HR application updates to test and production environments.

• Web Applications

• COTS Customizations

• Informatica

• PeopleSoft/GEMS

7. Software Design and Development

a. Provide full life cycle development and O and M support following established HR and DoS processes, procedures, and standards.

b. Provide support in the development and maintenance of existing and new internal and external interfaces.

c. Provide support in the development and maintenance of the Internal Data Broker (IDB) supporting 30+ applications.

8. Systems Security

a. Assess and implement directives of the department in support of Certification and Accreditation activities

9. Systems Administration

a. Support configuration and management of database and application servers

b. Provide monitoring and troubleshooting support for application-related issues

Relevant Experience:

The contractor shall provide resources with experience in an environment similar to HR/EX/SDD. Experience among project resources is also required in the software listed below.

• Dell, HP Servers, Compaq Servers

• EMC Symetrix Storage Arrays; EMC PowerPath and Solutions Enabler

• EMC Symmetrix Command Line Interface (CLI) scripting

• Windows 2000 Server and Windows Server 2003; Windows 2000/2003 Management

Interface (WMI) scripting

• Visual Basic scripting

• Oracle 9i/10g/11g Real Application Clusters (RAC) and higher

• Oracle Cluster File System (OCFS)

• Oracle SQL*Net Load Balancing with Failover

• Oracle SQL*Net Encryption

• Oracle SQL*Net multi-threaded server

• Oracle Advanced Queueing

• Oracle Partitioning

• Oracle FailSafe

• Oracle Recovery Manager

• Oracle Enterprise Manager

• Oracle Export/Import, SQL*Plus, SQL*Loader, XML Developer

• Oracle Data Guard

• Oracle Trace/tkprof

• Oracle PL/SQL

• Oracle Parallel Execution/Recovery

• Oracle Flashback

• Oracle Transportable Tablespaces

• Oracle Obfuscation Toolkit

• Oracle Heterogeneous Services

• Oracle ODBC

• Microsoft SQL Server 2000 and 2005 and higher

• Microsoft Access 2000 and higher

• F5 Big IP; EMC Storage Arrays

• Big IP/SQL*Net/PeopleSoft connection load balancing

• Veritas Netbackup

• Microsoft Internet Information Server

• Adobe ColdFusion 7 and higher

• Northrop Grumman ePower 6.4 and higher

• Microsoft Systems Management Console

• Domain Name Services (DNS)

• Windows 2003 Active Directory

• Windows 2003 Cluster Server

• Mail API

• Citrix Remote Console

• HP Lights Out Management Interface; Dell Remote Access Controller

• Microsoft Windows extended memory features

• Micosoft Powerpoint, Project, PWA, Visio

• Informatica 8.11 and higher

• Peoplesoft 8.8, PeopleTools 8.46 and higher

• Ultraedit

• Quest ERWin 4 and higher

• Quest Spotlight

• Veritas i3

• TOAD 8.5 and higher

STATEMENT

OF WORK PT.2

"Project Management, Database Management, Operational Maintenance, Systems Architecture, Software Design and Development"

5. Contractor Qualifications and Constraints

The contractor shall provide personnel with clearances at the SECRET and TOP SECRET level, as appropriate for their position. The nature of the work allows direct, unsupervised access to data from multiple databases with possible exposure to classified material, as well as attendance at meetings at the Secret or Top Secret level.

For this reason, contractor and all contractor personnel involved in completing this scope of work for the DoS must be citizens of the USA. Offerors must ultimately possess a Defense Security Service (DSS) Top Secret Facility Clearance (FCL) for contract performance. Firms with an FCL at a lower level (Interim Secret or Final Secret) would be eligible for contract award but will be limited to competing on contract awards up to the Secret level only. The Bureau of Diplomatic Security will sponsor the selected offeror who is either uncleared or who only posses an Interim Secret or Final Secret FCL for a Top Secret FCL.

As contract performance is contingent upon issuance of an FCL, it is imperative that the offeror cooperate with all requirements and deadlines imposed by DSS. A time period of 90 days will be allotted for the issuance of an FCL. If the offeror does not have the requisite clearance within that timeframe, the Government reserves the right to award to the next qualified offeror. Other than U.S. government sponsorship for the FCL, the Department of State assumes no responsbility for clearance processing.

If an individual is only required to perform a task during an option period, their security clearance must be obtained prior to that option period being exercised. All contractor personnel will require security in-processing, including clearance in accordance with Homeland Security Presidential Directive 12, before access will be granted to the work site. Security clearances for all contractor personnel shall meet the below requirement:

• Top Secret clearances are required for all personnel that are participating in development or application operations and maintenance activities requiring administrative privileges to any and all servers within HR.

These positions are defined as Oracle database administrators (ODBA), project managers, and senior network analysts.

• Secret clearances are required for all other personnel assigned to this contract. These positions include, but are not limited to, application developers, analysts, testers, help desk support, WEB developers, and junior network analysts.

The determination of required clearance levels shall be made by the Chief of HR/EX/ESD, COR or the government project manager and will be based on the functional position.

6. Safeguarding Information

The contractor and its employees shall exercise the utmost discretion in regard to all matters relating to their duties and functions. They shall not communicate to any person any information known to them by reason of their performance of services under this contract, which has not been made public, except in the necessary performance of their duties or upon written authorization of the contracting officer. All documents and records (including photographs) generated during the performance of work under this contract shall be for the sole use of and become the exclusive property of the U.S. government. Furthermore, no data, database records, article, book, pamphlet, recording, broadcast, speech, television appearance, film or photograph concerning any aspect of work performed under this contract shall be published or disseminated through any media without the prior written authorization of the contracting officer. These obligations do not cease upon the expiration or termination of this contract. The contractor shall include the substance of this provision in all contracts of employment and in all subcontracts hereunder.

7. Travel

This contract does not require recurring travel. However, incidental travel may occur in order to execute related tasks and subtasks. In cases where travel is required, the contractor shall provide the Chief, HR/EX/ESD, COR, and/or GPM with estimated travel costs and receive approval prior to travel. Travel costs will be invoiced separately and documentation supporting the costs must be provided. All travel will be conducted in accordance with FAR 31.205-46 and the Federal Travel Regulation. The government WILL NOT incur any costs for travel not approved. See travel clause for any additional information required.

8. Training

The government shall not be charged any costs incurred by the contractor as a result of providing training to its personnel to meet or maintain the technical qualifications specified in this SOW. This includes any training required by the contractor to meet the technical skills for upgraded/new operating and application environments. This includes, but is not limited to, courses, books, and enrollment fees or staff hours.

9. Personnel

All proposed personnel must submit resumes and be accepted by the government project manager(s) prior to beginning work on this contract. Additionally, all personnel must have a current security clearance, commensurate with the requirements of the labor position to be filled.

9.1. Key Personnel

The contractor shall assign to this contract the following key personnel. See attachment one for key personnel chart to be completed for proposal submisison.

The contractor shall agree that a partial basis for award of the contract is the list of key personnel proposed at attachment one. Accordingly, the contractor agrees to assign to this contract those key personnel whose resumes were submitted with the proposal necessary to fulfill the requirements of the contract. No substitution shall be made without prior notification to and the concurrence of the government project manager and contracting officer representative. During the first ninety (90) days of performance, the contractor shall make no substitutions of key personnel unless the substitution is necessitated by illness, death, or termination of employment of the key personnel.

All proposed substitutes shall meet or exceed the qualifications of the person to be replaced. The chief of the respective division and the contracting officer representative shall be notified in writing of any proposed substitution at least forty-five (45), or ninety days (90) if a security clearance is required, in advance of the proposed substitution. The notification shall include the following.

• Explanation of the circumstances necessitating the change prior to the removal or substitution.

• A complete resume of the proposed substitute.

• Any other information requested by the government project manager to enable him/her to judge whether or not the contractor is maintaining the same high quality of personnel that provided the partial basis of award.

9.2. Additional Personnel Requirements

The contractor must submit in writing to the government project manager notification of any and all personnel, not considered as key personnel, being removed from this contract, at least 14 working days prior to departure date.

Such notification shall contain the same information as required in section 9.1 above. In the case of emergencies (illness, death, or termination of employment), where the 14-day notification requirement is not possible, substitute personnel shall be immediately proposed in accordance with the requirements of this statement of work.

The contractor must, at the time of the notification of the person being removed from the contract, submit the resume of projected replacement personnel to the respective division chief.

The contractor’s on-site project manager and/or government project manager must obtain the Department of State building pass from the departing individual and deliver it to the building pass coordinator, who shall notify Access Control to deactivate the badge.

Proposed substitutes for ALL personnel shall meet or exceed the desired qualifications requirements set forth in the contract and possess the appropriate security clearances. The government project manager shall receive, review, and approve the resumes of ALL replacement personnel proposed by the contractor. Interviews of proposed personnel are also required.

The government project manager shall review the resumes of all personnel, including sub-contractors and consultants that are proposed by the contractor, and shall approve the individuals prior to performance under this contract. All such individuals shall have the appropriate security clearances.

Personnel Qualifications are as follows:

Sr Database Administrator (x1) Minimum Experience: Five (5) years database administration in specific or related environment including team leadership and two (2) years operating systems administrative support.

Functional Responsibility: Provide strategic design, administrative, tuning and recovery support for database systems. Lead teams in the deployment and administration of database solutions. Develop procedures and standards. Specify, configure, manage and monitor host server operating systems and database-related network components. Evaluate, make recommendations, implement solutions and upgrades. Tune, monitor and maintain environments. Provide architectural guidance and support for administrative and development staff.

Develop and maintain MS project plans. Provide application release support. Provide administrative support in PeopleSoft utilities, tools and databases. Monitor file systems, performance and benchmark system thresholds in an n-tier environment. Coordinate work with administrators or project teams for system maintenance.

Perform day to day maintenance and support of PeopleSoft n-tier environments. Specify, configure, manage and monitor host server operating systems and database-related network components. Provide lead support during Oracle, PeopleSoft application and PeopleTools upgrades. Develop enterprise-level architecture solutions. Coordinate work with administrators or project teams for system maintenance.

Minimum Education: BS Degree in Computer Science/Information Systems or related discipline or commercial training in the specific database product.

Mid-Level Database Administrator (x2)

Minimum Experience: Three (3) years database administration in specific or related environment including team leadership and two (1) year operating systems administrative support.

Functional Responsibility: Provide administrative, tuning and recovery support for database systems.

Establish, monitor and maintain environments. Independently manage sites of moderate size. Configure, manage and monitor host server operating systems and database-related network components. Conduct evaluations, make recommendations and implement upgrades. Develop site-level architecture solutions.

Provide support for users, development staff and junior administrators. Coordinate work with administrators or project teams for system maintenance.

Minimum Education: BS Degree in Computer Science/Information Systems or related discipline or commercial training in the specific database product.

Jr Database Administrator (x1)

Minimum Experience: One (1) year database administration in specific or related environment.

Functional Responsibility: Provide administrative, tuning and recovery support for database systems.

Establish, monitor and maintain environments. Configure, manage and monitor host server operating systems and database-related network components. Conduct evaluations, make recommendations and implement upgrades. Provide support for users, development staff and other administrators. Coordinate work with administrators or project teams for system maintenance.

Minimum Education: BS Degree in Computer Science/Information Systems or related discipline or commercial training in the specific database product.

Senior Database Architect/Systems Architect (x1)

Minimum Experience: Seven (7) years database administration, Five (5) years Systems Architecture, Five (5) years Windows Administration, Three (3) years Oracle RAC, Three (3) SAN and two (2) years network administration.

Functional Responsibility: Provide leadership in enterprise-level application integration and interface methods.

Provide strategic design, administrative, tuning and recovery support for database systems. Specify and/or establish core database infrastructure including SAN configuration and Oracle/RAC. Coordinate infrastructure updates among development teams. Design and implement methods to maintain metadata not managed directly by site applications. Document standards and brief development teams and management to ensure consistency in application design and development. Review development processes and recommend changes to improve integration. Develop and maintain MS project plans. Provide application release support.

Minimum Education: BS Degree in Computer Science/Information Systems or related discipline and commercial training in related product.

PeopleSoft DBA (x1) Minimum Experience: Three (3) years database administration and three (3) years PeopleSoft administration

(HRMS).

Functional Responsibility: Provide administrative and development support in PeopleSoft utilities, tools and databases. Develop enterprise-level architecture solutions. Monitor file systems, performance and benchmark system thresholds in an n-tier environment. Provide on-going capacity analysis and planning to determine future projections of hardware requirements. Perform PeopleSoft application and PeopleTools upgrades in coordination with the development team. Coordinate work with administrators or project teams for system maintenance.

Minimum Education: BS Degree in Computer Science/Information Systems or related discipline or commercial training in PeopleSoft.

Programmer/Analyst (x2)

Minimum Experience: Five (5) years in analysis/design/development including team leadership.

Functional Responsibility: Provide leadership in analysis, design and development projects of any size. Plan and manage projects involving teams of analysts and developers. Direct and supervise team leaders on projects of sufficient size. Design system architectures and standards. Review designs and implementations. Assume responsibility for overall schedule and major deliveries. Coordinate with external agencies on new interfaces.

Develop background jobs in support IDB real-time data. Collaborate with other teams on IDB usage. Report status to project management and client representatives. Develop and maintain MS project plans.

Minimum Education: BS Degree in Computer Science/Information Systems or related discipline or commercial training in specific or related product.

Program Manager/Project Manager (x1)

Minimum Experience: Three (3) years management or leadership and five (5) years in any technical role with similar IT projects.

Functional Responsibility: Provide primary corporate point of contact for client representatives. Receive, assign and track tasks. Direct resources to accomplish tasks. Report progress and resolve issues. Assure compliance with contract performance requirements and advise corporate management on contracts and related issues. Review employee and subcontractor performance. Develop and maintain MS project plans.

Minimum Education: BS Degree in related discipline or equivalent experience.

10. Other Pertinent Information or Special Considerations

The purpose of this SOW is to ensure that the Bureau of Human Resources applications and operational requirements have been completely and properly identified and to ensure that there is a mutual understanding between HR/EX and the contractor regarding these requirements. Other pertinent information regarding this SOW follows:

The contractor shall offer only those services that conform to this contract.

The contractor must make available all documentation and notes the at request of the government project manager (GPM) or contracting officer representative (COR). Such documents include, but are not limited to:

project plans, system design, database design and schema, data dictionary, data flow charts, test plans, and lessons learned. All deliverables shall require interim approval from the government project manager during the course of the project.

The contractor shall notify the GPM or COR, if the GPM is not available, of all scheduled meetings…