16. FA701424R0026 Task_Order_sPWS (Attachment 15).pdf

FA7014‐XX-X-XXXX

IDIQ LITIGATION SUPPORT CONTRACT

PERFORMANCE WORK STATEMENT

FOR

TASK ORDER #1

M365 SHAREPOINT DEVELOPER

TBD

1. INTRODUCTION

The Judge Advocate General’s Corps (AF/JA) provides a full range of legal services to the

Department of the Air Force and combatant commands. The AF/JA represents the interests of its clients in civil, administrative, and criminal justice processes involving a broad range of practice areas including military justice, environmental, aviation, international, tort, medical, civilian, and military personnel, administrative, third-party litigation, and acquisition law in various forums such as federal and state courts, and administrative boards. The IDIQ Litigation Support contract provides a wide range of professional legal support services to AF/JA, including Specialized

Professional Services under Section 1.1.17 (a) in the PWS.

1.1 PURPOSE

The purpose of this Task Order is to provide AF/JA with an M365 SharePoint developer to create customized SharePoint solutions for our organization.

1.2 SCOPE

The Contractor will provide an M365 SharePoint developer who will be responsible for advanced configuration and customization the Government’s SharePoint sites (on Government systems) according to the Program Manager’s specifications. The SharePoint developer will provide training and technical guidance for a variety of areas including systems design, systems development, systems testing and deployment, and support for quality assurance, configuration management, systems documentation, and continued SharePoint development maintenance.

This Task Order will address some the following concerns:

• Performing a current state assessment of workflows and documentation to streamline the overall user process (e.g., minimizing email traffic)

• Maximizing SharePoint features

• Implementing and managing security features (privacy concerns and permissions)

This Task Order will include, but is not limited to, tasks listed in the table below. The Program

Manager and Contractor will mutually agree on due dates for each task and the Contractor shall meet all deadlines within 100% of the time. Contractor will document due dates and status on all tasks in the Status and Management Reports.

Task Goal

Assess current SharePoint sites Perform assessment of current SharePoint sites and make suggestions on how to maximize SharePoint features.

Assess current SharePoint sites

Permission Groups

Perform assessment of current SharePoint sites permission groups and make suggestions on how to streamline groups to manage security concerns.

Utilize Power BI for reporting Utilize Power BI to generate reports and export from

SharePoint into a format that maintains the graphic dashboards.

Utilize Power Apps to create advanced SharePoint forms that

Utilize Power Apps to create advanced SharePoint forms that recognize users and automatically populates their recognize users Global Address List information once they open the form.

Assess existing forms and make suggestions on how to update them for maximum efficiency.

Utilize Power Apps to create advanced SharePoint forms with cascading sections

Utilize Power Apps to create advanced SharePoint forms with cascading lookup sections of information. Assess existing forms and make suggestions on how to update them for maximum efficiency.

Utilize Power Apps to consolidate information from multiple

SharePoint sites’ lists

Utilize Power Apps to pull information from multiple

SharePoint sites’ lists into one SharePoint site list for consolidation.

Utilize Power Automate to create advanced flows

Utilize Power Automate to create advanced automated cloud flows. Assess existing cloud flows and make suggestions on how to update them for maximum efficiency.

1.3 REQUIRED SKILLS (Knowledge, Skills, Abilities [KSAs])

The Contractor is responsible for providing personnel with the necessary level of experience to support the tasks. KSAs include but are not limited to:

• Three years of government or commercial development experience with M365 Office applications.

• Extensive knowledge of M365 SharePoint, Power Apps, Power Automate, and Power BI.

• Microsoft Certification in Power Platform or equivalent, required (ex: Power Platform

Developer; Power Automate Developer; Power BI Analyst).

• Proficiency with front-end programming languages, and the ability to solve complex software issues.

2 DELIVERABLES

The Contractor shall provide all deliverable(s) in the table listed below. All deliverables shall be submitted to the COR, unless otherwise agreed upon.

Sequence

Number Description

PWS

Paragraph(s)

DUE DATE

DELIVERY

A003 Transition Out Plan 4.8

At time of submission of its proposal and updated as required.

By email to the

COR and Program

Manager in MS

Word format

A004

Project Kick-off /

Planning Session

Meeting Minutes

1.2.4

Within five (5) business days of task order award

By email to the

COR and Program

Manager in MS

MEETING SCHEDULE

Meeting Type Frequency Audience

Project Kick-off/Planning Session Once Government (Program Manager, COR, Client team)/Contractor (Program/Project Manager, SharePoint developer)

Government/Contractor Weekly

Sync

Weekly

Conference Call

Government (Program Manager, Client team)/Contractor (Program/Project Manager, SharePoint developer)

Government/Contractor Monthly

Update Status Meeting

Monthly

Conference Call

Government (Program Manager, COR, Client

Rep)/Contractor (Program/Project Manager, SharePoint developer)

3. GOVERNMENT FURNISHED INFORMATION/PROPERTY

3.1 Government Furnished Property, Equipment, Material, Information, or Services:

The Government will provide access to relevant Government organizations, information, documentation, associated materials, and systems as required and available. The Government will not furnish property or services for this requirement.

4. GENERAL INFORMATION

4.1 Hours of Operation:

The Contractor is responsible for conducting business for their specific site or facility. Contractor shall be available during core hours of 8:00 AM to 5:00 PM EST, Monday thru Friday except

Federal holidays. The Contractor must always maintain an adequate workforce for the uninterrupted performance of all tasks defined within the PWS.

4.2 Place of Performance:

The Contractor should plan to provide accommodations for any personnel used to support this requirement.

4.3 Travel: None

Sequence

Number Description

PWS

Paragraph(s)

DUE DATE

DELIVERY

Word format

A011 Status and

Management Report 1.2.3

10th business day of each month

By email to the

COR and Program

Manager in MS

Word format