Learning Management Support Services _Draft SOW.pdf

1 | P a g e

STATEMENT OF WORK

LEARNING MANAGEMENT SYSTEMS SUPPORT

SERVICES

FOR

U.S. DEPARTMENT OF COMMERCE

OFFICE OF THE SECRETARY

OFFICE OF HUMAN RESOURCES MANAGEMENT

OFFICE OF LEARNING AND DEVELOPMENT

REVISED: OCTOBER 31, 2024

2 | P a g e

1. Background

In accordance with the United States Department of Commerce’s (DOC) Department Administrative

Order 202.410, DOC is charged with maintaining federal employees’ training records and providing the ability to report federally mandated and funded training activities to the Office of Personnel Management

(OPM). The policy is to maximize employee competence through training and development programs. 5

U.S. Code § 4103 also allows for the establishment of training programs under the Government

Employees Training Act.

DOC consists of and supports the following bureaus:

• Bureau of Industry and Security

• Bureau of Economic Analysis

• Economic Development Administration

• International Trade Administration

• Minority Business Development Agency

• National Oceanic and Atmospheric Administration

• National Telecommunications and Information Administration

• Patent and Trademark Office

• National Institute of Standards and Technology

• National Technical Information Service

• Office of the Secretary

• United States Census Bureau

DOC provides a myriad of training programs and services to ensure that employees have the knowledge and expertise needed to be America’s business leaders. DOC is committed to continuing learning, developing new skills, and staying ahead of emerging trends and technologies through individual courses, career development programs, and distance learning.

A key component of DOC’s training services includes the management and procurement of technology related to department- and bureau-specific learning. Currently, DOC hosts a learning management system

(LMS) through a cloud instance of Cornerstone On-Demand (Cornerstone), a Software as a Service

(SaaS) procured through a Blanket Purchase Agreement (BPA) with an authorized reseller of the

Cornerstone OnDemand approved to provide services to the government. The current LMS annually serves nearly 80,000 employees and support contractors.

2. Objectives

The goal of this contracting action is to secure Cornerstone SaaS, system support services, annual end user licensing, system consulting capabilities, and operational support from a qualified vendor (Contactor) with DOC knowledge and experience. DOC is under significant pressure from the current Administration to aggressively support the business growth agenda of the United States. Reducing the risk of transition by working with a vendor familiar with DOC will achieve an important risk mitigation objective.

3. Scope

The intent of this contract is to acquire LMS support services from a Contractor to provide functional guidance, administrative programming, content development program support, and program management support and services to DOC’s Office of the Secretary (OS), Office of Human Resources Management

(OHRM), Office of Learning and Development (OL&D) in instances of the SaaS provided by

3 | P a g e

Cornerstone, Skillsoft/Percipio content, and eSkillz support services for its LMS which is internally as the

Commerce Learning Center (CLC).

DOC is seeking support for these same services and for the current instance of the CLC services, which would provide O&M licensing and LMS system administration for DOC bureaus.

4. Tasks

4.1 Cornerstone On Demand LMS – Human Capital Management System

Contractor must be able to resell, manage and optimize the LMS Cornerstone OnDemand platform

Human Capital Management (HMC) System. As such, the vendor should be an authorized reseller of an

LMS solution and be able to assist DOC with managing needed end-user and administrative-user licenses of the LMS. In addition, DOC should have the capability to leverage the LMS platform to potentially use the other HCM suite software module offerings available for purchase, as needed including but not limited to: Learning, Performance, Recruiting, Onboarding, and Succession Management.

Required License Types

Cornerstone Licenses (Gov and Contractor)

Cornerstone Named Care Admin Licenses

Cornerstone Named Care Admin Licenses in Premium Support

Cornerstone Online Content Hosting Licenses

Cornerstone Client Success Center Licenses

CSOD Premium Support (M)

CSOD Online Content Hosting (M)

CSOD Named Care Admin License

CSOD DKIM Services Annual

Web Services Licenses

4.2 SkillSoft E-learning Content Library Platform

DOC utilizes an off-the-shelf content library provided from SkillSoft for department wide user use to access 24/7/365 online learning content. As such, the vendor should be an authorized partner of the current product and be able to assist DOC with managing needed annual end-user and administrative-user licenses of the library currently including, but not limited to: Leadership Development, Business and

Development Skill, and the Environmental, Health, and Safety (EH&S) training libraries.

Additionally, DOC seeks professional services on-demand, on an ongoing or ad-hoc basis for programmatic e-learning curation services to support strategic learning initiatives such as mentoring, upskilling, reskilling, and skill gap closure for occupation specific trainings over the course of the year.

Required License Types

SkillSoft Licenses (Gov and Contractor)

SkillSoft Leadership Development License

SkillSoft Employee Safety and Health (ES&H) License

SkillSoft Percipio License

SkillSoft Licenses (Expert) for Govt (M) and Contractor

SkillSoft Codecademy Enterprise

Web Services Licenses

4 | P a g e

4.3 Speexx Foreign Language Training Content Library

DOC utilizes a Speexx foreign language training content library platform as an optional to purchase at the bureau organizational level’s discretion. As such, the vendor should be an authorized partner of a foreign language training content library platform and be able to assist Commerce with managing needed end-user and administrative-user licenses.

Required License Types

Speexx User Licenses

4.4 Skillsoft Coaching Program Platform as a Service (PaaS)

Coaching programs are a resource-intensive manual process involving a series of complex tasks including, but not limited to, coach/client matching, session scheduling & tracking, assessments & surveys, and measuring engagement outcomes. As such, the vendor should be an authorized partner or reseller of the SkillSoft Coaching Program PaaS and be able to assist Commerce with enterprise-wide coaching program management and needed end-user and administrative-user license access.

4.5 End-user eSkillz Help Desk Support Solutions

Through the utilization of the DOC department wide LMS Cornerstone OnDemand, DOC needs access to a full online Live Support desk team to manage an on-demand live support solution. The help desk staff should be based in the U.S. and should be full time employees of the vendor providing support. All help desk staff should have a minimum of 3 years of experience supporting an LMS. The help desk staff should be made available 24 hours a day, 7 days a week for annual support except federal holidays. The help desk support solution should be able to manage Tier 1 and 2 support requests and have an integrated ticketing system for Tier 3 escalations and system issue triage. The help desk support solution should be customizable by the bureau and give the capability for each individual DOC bureau to maintain its own learning and development knowledge base. The help desk support solution should be chat-based with email and phone support available. Monthly reporting with utilization data and support trends should be included.

4.6 Operations and Management (O&M) consulting for Enterprise-Wide Management of the Learning Management System Initiatives

Through the utilization of the department wide LMS, DOC needs access to a management function that will assist in managing the system ownership of the DOC LMS and all included software and training tools. The management function will include educating and providing support to all DOC bureaus on the capabilities of the DOC wide LMS and the available training offerings. This will be managed for each of the 13 bureaus and the management should include support every month with the bureaus utilization of the system and of the licensing needs each renewal year.

4.7 Dedicated Full-Time LMS System Administrative Services

The contractor shall provide full-time dedicated LMS System Administrator(s) who will be responsible for managing the day-to-day maintenance, configuration and development of Commerce’s DOC wide

LMS. The dedicated LMS System Administrator should have LMS subject-matter expertise in accomplishing the following LMS configuration tasks:

• User account maintenance

5 | P a g e

• Dynamic group and permission management

• Security role management

• Portal management

• ILT management; course testing and upload

• ILT management; onsite class enrollment/registrations input and set up

• Proxy enrollment creation

• Communication creation and management

• Catalog development and organization

• Enrollment and Calendar management

• Assignment, Assessment and Credits creation or management

• Curriculum development

• Report management

4.8 LMS Special Project Services

The contractor shall provide resources and services around Learning Management System (LMS) program management to provide Commerce with resources to contribute to special projects, program endeavors and other learning and development (LD) and human capital management (HCM) initiatives.

The contractor should possess programming and project management expertise, proficiency in the LD and

HCM arenas and be able to offer best practices in program implementation and execution. A sample list of special project tasks is as follows:

• As needed System Administrator Support or project related correspondence (meeting scheduling and note taking)

• Management and execution of mandatory training, associated enrollments and communications and set up of compliance reporting and dashboards using Microsoft Office 365 tools (graphs and charts)

• Management of reporting and coordination across multiple bureaus for system use, system risk identifiers and planning of configuration and workflow fix schedule

• Utilization of advanced system features (curriculums, proxy enrollments, dynamic groups, automated email notifications and reminders, widgets for recommended and featured training, workflow approvals)

• Management of platform quarterly system enhancement release schedule to include testing, outcome documentation and coordination for rollout to production

• Management of LMS work-around processes whereby Commerce identified a training need that is not executable by normal LMS configuration

4.9 Skillsoft E-learning Library Curation Development Services

The contractor shall provide full-time dedicated E-learning Library Curation Development Manager who will be responsible for managing the day-to-day support of programmatic e-learning curation services supporting strategic learning initiatives such as mentoring, upskilling, reskilling, and skill gap closure for occupation specific trainings over the course of the year.

• Program Strategy:

• Serve as the primary advisor of the E-learning Library Curation in areas of program strategy, implementation, and adoption. Define and refine the DOC’s e-learning and

6 | P a g e digital learning strategy to maximize value from learning investments. Coordinate cross-functional vendor support teams to ensure alignment with DOC learning goals and objectives.

• Project Portfolio Management:

• Collaborate to create short and long-term program plans reflecting priority initiatives, discrete learning projects, and recurring requirements. Employ best practices and project management methodologies.

• Engage with DOC stakeholders to research performance priorities and developmental needs. Lead change management activities, including curriculum planning and marketing.

Oversee the design and production of marketing activities and materials to support learning program adoption.

• Curriculum and Blended Learning Design:

• Produce content mappings and selective learning paths for global training initiatives.

• Respond to unit-level requests for content assets aligned with specific business topics.

• Identify opportunities for blended learning design within existing programs.

• Marketing and Communication:

• Plan and execute an annual strategy for awareness and targeted communication to end users and managers. Develop and implement a detailed marketing plan.

4.10 LMS User Experience (UX)/ User Interface (U/I) Customization Services

The contractor should have advanced knowledge of Learning Management (LMS) design and Graphic

User Interface (GUI) maintenance. The contractor should possess expertise around:

• Current web technologies such as HTML, CSS, and can create and edit HTML and CSS without the aid of a WYSIWYG editor

• Use of JavaScript and be able to either create and/or modify simple scripts used for animation, or interaction, to create an engaging experience for the user

• Optimize website assets, such as external stylesheets, or scripts

• Image optimization and the proper use of images and graphics in relation to page content. They should also have basic photo and graphic editing skills, using software such as Adobe Photoshop

• Working understanding of both UX and UI, as well as understanding the differences and how they work together to create a useful and engaging experience for the user while keeping the experience simple and pleasing to the user

• Design concepts and how they apply to web design, such as current design trends, color theory, flow, balance and proportion, spacing and the use of negative space

• Responsive web design and how web technologies work with different browsers and devices

• Expertise in 508 compliant designs

• Able to conceptualize ideas in the form of wireframes, comps or prototypes

4.11 E-Learning Course Instructional Design and Development Services

The contractor shall provide resources and support services for government specific course instructional design, development and maintenance. The Course Instructional Design and Development Services should have Instructional design subject-matter expertise in accomplishing the following tasks:

Course Development:

7 | P a g e

• Expert understanding of SCORM, AICC and CMI5 standards and LMS compatibility requirements.

• Best practices experience with creation of knowledge checks, assessments, surveys and final exams

• Instructional Design methodologies such as the five phase Analysis, Design, Development, Implementation, and Evaluation model (ADDIE)

• Expertise with and access to use current and emerging course authoring tools including: Lectora, Articulate360, Storyline 360, Articulate Studio, Adobe Captivate and Camtasia

• Experience and access to use with accessibility tools to confirm accessibility requirements are met;

• Job Access With Speech (JAWS,

• Non-Visual Desktop Access (NVDA),

• Color Contrast Checkers,

• Adobe Acrobat Pro, and

• Microsoft Word Accessibility Checker

• Experienced Voice-over production specialists

• Ability to convert existing documentation (PDFs; Word; PowerPoint files) to web-based content

4.12 Administrative Staff Training Services

The contractor shall provide resources, training and continuous education services on the Cornerstone

OnDemand SaaS and all purchased content libraries. The contractor should possess defined training methodology and subject-matter expertise in accomplishing the following LMS training tasks:

• Expert understanding of LMS configuration, maintenance and development

• Qualified LMS Trainers with a minimum of 3 years LMS training experience

• Ability to develop training curriculum across multiple administrative roles to include Super

Administrators; Basic Administrators; Training Coordinators; Supervisors and End-Users

• Capability to deploy training in multiple forums including onsite and virtual for 508 compliancy

• Expertise in virtual web-conferencing execution including webinar registration, enrollment management, day of Producer event support and post event reporting

• Ability to manage completion tracking utilizing multiple tools including webinar software and

LMS tracking

Training Materials

Contractor to create and provide all relevant training materials necessary to successfully complete each program. Training webinars shall be conducted using DOC virtual platform, recorded and archived for later viewing and made available for up to 12 months.

• Functional Documentation - Supporting documentation to guide Administrators on core LMS functionality to include step-by-step reference guides and interface screenshot informative aides.

• Web Coordinator / ILT and VILT Coordinator / Training Coordinator - Supporting documentation to guide LMS Entry coordinators with targeted LMS process workflows.

4.13 EHRI LMS Data Feed Management Services

8 | P a g e

The contractor shall provide resources and services around Learning Management System (LMS) data feed management. The contractor should possess defined HR/LMS mapping methodology and subject-matter expertise in accomplishing the following data feed management tasks:

• Expert understanding of LMS user account architecture including account properties, security roles and permission sets, supervisor relationships and dynamic groups

• Proficient understanding of HR solution and HR user account architecture

• Ability to execute data feed plans for round-tripping HR data from existing HR system into (and out) of the existing LMS

• Ability to perform data integrity audits on system data, files and output

• Demonstrated experience and advanced knowledge of Structured Query Language (SQL), including SQL server.

• Demonstrated advanced Microsoft Excel skills such as Vlookups, pivot tables, linking to external data sources and macros

• Demonstrated advanced Microsoft Access skills like building medium to complex queries using linked external databases (mostly using existing databases)

• Demonstrated advanced Microsoft Access skills like building medium to complex queries using linked external databases (mostly using existing databases)

• Demonstrated advanced Microsoft PowerBi skills like building medium to complex queries using linked external databases (mostly using existing databases)

• Ability to discuss technical issues and topics with non-technical parties

4.14 Information Security System Officer (ISSO)/ FedRAMP Authority to Operate

(ATO) Support Services

The Contractor shall provide resources and services around Learning Management System (LMS) IT

Security management and adhere to and follow all DOC Information Security practices, guidelines in accordance with all current government security policies.

The Contractor should have seasoned technical and solution architect qualifications with a minimum of 5 years of experience in managing ATO and POAM support monthly.

The contractor shall ensure the confidentiality, integrity, and availability of DOC information throughout the system development lifecycle and address the following of its information security controls and related information, including, but not limited to, the following:

• Information Security, Policies and Procedures.

• Logical Access controls;

• Segregation of Duties controls;

• System Monitoring and Incident Response/Handling controls;

• Personnel Security controls; and

• Continuous Monitoring

The Contractor shall remediate Plans of Actions and Milestones (POAMS) on prioritization of risk impact and risk mitigation resources in accordance with DOC policy. The Contactor shall update System security documentation and maintain in accordance with National Institute Standards and Technology (NIST)

Special Publication (SP) 800-53 Revision 5 and ensure the Continuous Monitoring Strategy is fully implemented in accordance with the DOC Enterprise Cybersecurity Policy (ECP) and NIST SP 800-137.

The contractor should possess a clear understanding of the LMS back-end, IT security standard operating procedures and subject-matter expertise in Federal Government IT Security requirements (i.e. NIST 800-

53), FedRAMP, and privacy requirements:

• Expert understanding in Federal IT system security controls, requirements, guidance and best

• practices, including a thorough understanding and the ability to implement NIST 800-53

9 | P a g e

• controls.

• Expert understanding of LMS IT security

• Proficient understanding of LMS IT security settings, complexities and best practices,

• including the ability to create workarounds when necessary

• Demonstrated hands-on experience in developing, maintaining and updating IT security and

• privacy documentation

• Demonstrated experience with continuous systems monitoring

• Ability to provide technical support for audits/reviews/renewals (i.e. walkthroughs,

• questionnaires, meetings, data requests, etc.)

• Ability to discuss technical issues and topics with technical and non-technical parties

4.15 External Training and SF-182 EHRI Data Management

The contractor shall provide resources and services around Cornerstone OnDemand EHRI coding, SF-182 management and external training management. The contractor should possess advanced knowledge of the SF-182 government process and associated EHRI data knowledge in accomplishing the following external training management tasks:

• Ability to review completed SF-182 documentation and assess quality assurance measures for auditing purposes

• Ability to convert manual SF-182 documentation into the LMS for system tracking

• Proficiency with SF-182 inherent configuration in the LMS

• Ability to code LMS learning objects including online courses and instructor-led training events and sessions with associated EHRI data

• Ability to produce custom reporting for OPM mandated EHRI reporting policies

4.16 Training Evaluation Assessment and Consultation Services

The contractor shall provide resources and services regarding assessing training program effectiveness and providing consultations regarding training industry standard best practices. The contractor should possess defined training methodology and subject-matter expertise in accomplishing the following training tasks:

• Qualified training program administrators with minimum of 3 years’ experience assessing the effectiveness of training programs

• Ability to develop training evaluation reports using data obtained from the LMS

• Expertise in training program assessment and evaluation using an LMS

• Ability to provide consultations regarding best practices to maximize training effectiveness and efficiencies using an LMS

4.17 Training Needs Analysis, Competency, 180-degree, and 360-degree Assessment

Development Services

The contractor shall provide resources and services regarding Training Needs Analysis, competency, 180-degree and 360-degree assessment development services to assist the Department and operating units with individual and organizational annual training needs analysis, to include individual user competency and skill-based assessment deployment and analysis and providing consultations regarding training industry assessment standard best practices. The contractor should possess defined training methodology and subject-matter expertise in accomplishing the following training tasks:

10 | P a g e

• Qualified industrial psychologist with minimum of 3 years’ experience developing assessments instruments for workforce development measurement to include:

• Training Needs Analysis processes and assessment instruments,

• Competency assessment instruments,

• 180-degree assessments instruments, and

• 360-degree assessment instruments

• Expertise in developing occupational competencies

• Expertise in developing occupational career mapping

• Ability to provide consultations regarding best practices to maximize workforce development initiatives effectiveness and efficiencies

• Ability to develop evaluation reports using data obtained from assessments instruments

5. Delivery and Milestones

The items listed below are considered essential to the successful completion of this contract and shall be provided by the Contractor on or before the due dates identified in the chart below:

Deliverable Description Quantity/Media* Date of Execution

1 Kick-off meeting with vendors 1 10 days after award

2 Quarterly reports of all procured licenses across the catalogs and services

Quarterly Quarterly

3 Security Continuous Monitoring Monthly Monthly at least 5 days prior to the end of each month covering the previous month.

4 LMS Cornerstone OnDemand System

Administrator Training

Monthly Monthly at least 5 days prior to the end of each month covering the previous month.

5 Monthly Progress Report Monthly Monthly by the 15th business day of each month covering the previous month

6 Integrated Project Schedule Monthly Monthly by the 15th business day of each

11 | P a g e month covering the previous month

7 POAM Closeout Packages Monthly At least 5 days prior to the due date defined in the CLC

POAM Listing

8 Monthly Billing Report Monthly Monthly by the 15th business day of each month covering the previous month

9 Estimated Bureau Licensing Costs

Estimates

Bi-Annually Bi-Annually

10 Final Bureau Licensing Costs Annually Annually

11 Validation of Licenses

Purchased

Annually Annually

12 Quarterly meetings with all procured software licenses POCs to discuss updates and enhancement

Quarterly Quarterly

13 Dedicated Full-Time LMS

Administrative Services by Bureaus and DOC consolidated

Monthly Monthly by the 15th business day of each month covering the previous month

14 End-user eSkillz Tier (Level 1) Help

Desk Support Solutions

Ongoing, as needed June 1, 2024

15 End-user eSkillz Tier (Level 2) Help

Desk Support Solutions

Ongoing, as needed June 1, 2024

16 End-user eSkillz Tier (Level 3) Help

Desk Support Solutions

Ongoing, as needed June 1, 2024

17 Quarterly meetings with all procured software licenses POCs

Quarterly Quarterly

18 LMS Special Project Services

Reporting

Weekly and Monthly Beginning mid-month June 2025

19 Skillsoft E-learning Library Curation

Development Services

Ongoing, as needed weekly and/or monthly as needed based on projects

Beginning mid-month June 2025

20 LMS User Experience (UX)/ User

Interface (U/I) Customization Services

Ongoing, as needed weekly and/or monthly as needed based on projects

Beginning mid-month June 2025

12 | P a g e

21 E-Learning Course Instructional

Design and Development Services

Ongoing, as needed weekly and/or monthly as needed based on projects

Beginning mid-month June 2025

22 Administrative Staff Training Services Ongoing, as needed

Weekly and/or monthly as needed based on projects

Beginning mid-month June 2025

23 External Training and SF-182 EHRI

Data Management

Weekly and/or monthly as needed based on projects

Beginning mid-month June 2025

24 Training Evaluation Assessment and

Consultation

Ongoing, as needed weekly and/or monthly as needed based on projects

Beginning mid-month June 2025

25 Training Needs Analysis, Competency, 180-degree, and 360-degree Assessment Development

Services

Ongoing, as needed weekly and/or monthly as needed based on projects

Beginning mid-month June 2025

6. Government-Furnished Property, Material, Equipment, or Information (GFP, GFM, GFE, or GFI)

The government shall provide GFE to all contractor support who directly support/have access to the HR data feed and/or end user data.

The Contractor is responsible for and shall ensure LMS staff are properly trained and hold the appropriate credentials as required for the services being performed.

The contractors will be provided with a DOC doc.gov email and will have limited access to DOC online training files and programs. Contractors may be provided with a basic U.S. Government security clearance, upon passing the DOC Office of Security’s (OSY) contractor background employment investigation.

7. Security

The Contractor shall provide resources and services around LMS IT Security management and adhere to and follow all DOC Information Security practices, guidelines in accordance with all current government security policies. The contractor shall ensure the confidentiality, integrity, and availability of DOC information throughout the system development lifecycle and address the following of its information security controls and related information, including, but not limited to, the following:

• Information Security, Policies and Procedures.

• Logical Access controls;

• Segregation of Duties controls;

• System Monitoring and Incident Response and Handling controls;

• Personnel Security controls; and

• Continuous Monitoring

13 | P a g e

The Contractor shall remediate POAMs on prioritization of risk impact and risk mitigation resources in accordance with DOC policy. The Contactor shall update system security documentation and maintain in accordance with National Institute Standards and Technology (NIST) Special Publication (SP) 800-53

Revision 5 and ensure the Continuous Monitoring Strategy is fully implemented in accordance with the

DOC Enterprise Cybersecurity Policy (ECP) and NIST SP 800-137.

The contractor should possess a clear understanding of the LMS back-end, IT security standard operating procedures and subject-matter expertise in Federal Government IT Security requirements (i.e. NIST 800-

53), FedRAMP, and privacy requirements:

• Expert understanding in Federal IT system security controls, requirements, guidance and best practices, including a thorough understanding and the ability to implement NIST 800-53 controls.

• Expert understanding of LMS IT security

• Proficient understanding of LMS IT security settings, complexities and best practices, including the ability to create workarounds when necessary

• Demonstrated hands-on experience in developing, maintaining and updating IT security and privacy documentation

• Demonstrated experience with continuous systems monitoring

• Ability to provide technical support for audits/reviews/renewals (i.e. walkthroughs, questionnaires, meetings, data requests, etc.)

• Ability to discuss technical issues and topics with technical and non-technical parties

7.1 Reporting/Support

The Contractor shall provide the following reports/support:

• Execute and document monthly continuous monitoring deliverables, including assessing LMS vendor’s FedRAMP documentation as specified by the client

• Other ad-hoc IT security deliverables as the request of the client

• At least annually, review and update IT security documentation and provide support to the annual

ATO review/renewals

• At least annually, update Privacy Threshold Analysis (PTA) and Privacy Impact Analysis (PIA) and provide support for reviews/renewals

• Provide ad-hoc support for audit requests (i.e. Agency, Office of the Inspector General (OIG), Congress, etc.)

• Assess and execute changes to IT security and related documentation (i.e. new guidance or requirements from NIST, the Office of Chief Information Officer (OCIO), Information System

Security Officer (ISSO), etc.) as directed by client

8. Reporting

The contractor shall provide resources and services around LMS data feed management.

The contractor should possess defined HR/LMS mapping methodology and subject-matter expertise in accomplishing the following data feed management tasks:

• Expert understanding of LMS user account architecture including account properties, security roles and permission sets, supervisor relationships and dynamic groups

• Proficient understanding of HR solution and HR user account architecture

• Ability to execute data feed plans for round-tripping HR data from existing HR system into (and out) of the existing LMS

14 | P a g e

• Ability to perform data integrity audits on system data, files and output

• Demonstrated experience and advanced knowledge of Structured Query Language (SQL), including SQL server

• Demonstrated advanced Microsoft Excel skills such as Vlookups, pivot tables, linking to external data sources and macros

• Demonstrated advanced Microsoft Access skills like building medium to complex queries using linked external databases (mostly using existing databases)

• Ability to discuss technical issues and topics with non-technical parties

• Not required but nice to have skills set: Programming languages such as HTML, JavaScript, VBA, Java, C/C++, PERL, and Drupal

The Contractor shall provide the following reports monthly: number and detail of requests, associated hours and status of open projects.

9. Travel and Invoicing for Travel

When authorized as part of the work scope of BPA Call and as approved by the Contracting Officer (CO), Contracting Officer’s Technical Representative (COTR), or Alternate COTR (ACTOR) in writing, travel expenses may be reimbursed in an amount no higher than that allowed by Federal Travel Regulations

(FTR) in effect at the time of travel. To be reimbursable, the travel expenses must be:

• Allowable under the FTR,

• Approved by the CO or COTR/ACTOR prior to travel expenditure, and

• Allocable and necessary to the services under contract.

Request for travel approval must be submitted to the COR in writing at least two (2) weeks prior to the time of the trip, and must identify:

• The name of the traveler,

• Destination (s) including itinerary,

• Purpose of the travel, and

• Estimated Cost breakdown.

Invoices for travel expenses must include original or legible copies of receipts as prescribed in the FTR including but not limited to:

• Actual airfare or other public conveyance expenses.

• Transportation including car rental expenses for each rental day.

• Lodging expenses.

• COTR approval documentation.

10. Place of Performance

The Contractor’s work should be performed virtually, unless noted by the CO or COTR/ACTOR. The primary onsite location with be at DOC’s headquarters at the Herbert C. Hoover Building (HCHB) located at 1401 Constitution Ave NW, Washington DC.

11. Period of Performance

15 | P a g e

This will be a five-year contract consisting of a base year and four option years.

• Base Year: June 1, 2025, to May 31, 2026

• Option Year 1: June 1, 2026, to May 31, 2027

• Option Year 2: June 1, 2027, to May 31, 2028

• Option Year 3: June 1, 2028, to May 31, 2029

• Option Year 4: June 1, 2029, to May 31, 2030

12. Requirements Breakdown

Estimates of the LMS Cornerstone On Demand licenses, e-learning content libraries licenses and system administrative support services for this requirement should be provided based on a twelve-month basis, where DOC bureaus can determine the number of licenses and support services required for each year contract year.

11. Conflicts of Interest

Contractor and subcontract personnel performing LMS work may receive, have access to, or participate in the development of proprietary or source selection information (e.g., cost or pricing information, budget information or analyses, specifications or work statements, etc.), or perform evaluation services which may create a current or subsequent Organizational Conflict of Interests (OCI) as defined in FAR Subpart

9.5. The Contractor shall notify the CO immediately whenever he/she becomes aware that such access or participation may result in any actual or potential OCI and may merit the submittal of a plan to the CO to avoid or mitigate any such OCI.

This mitigation plan would be determined to be acceptable solely at the discretion of the CO. In the event the CO unilaterally determines that any such OCI cannot be satisfactorily avoided or mitigated, the CO may employ other remedies as he or she deems necessary, including prohibiting the Contractor from participation in subsequent contracted requirements which may be affected by the OCI.

12. Attachments

DOC has identified the following requirements that the Contract must comply with in provision of a

LMS, and post-transition services (e.g., system administration, content development, etc.).

13. Technical Document - DOC LMS Requirements

See attached.