Operational Automation Developer

Summary:

Looking for a Resource to automate the notification, collection and updates for project status using Microsoft SharePoint,

Required Qualifications:

Must have a minimum of three (3) years experience with the following

technologies: Microsoft Power BI, SharePoint and web development.

Responsibilities:

1.Offeror proposed resource(s) shall be responsible for the following:

1. Providing a repeatable process for notification, collection and updating of project

information.

1. Pre-populating existing information into a data collection template and properly associating

projects to project owners.

1. Providing transaction tracking for project updates.
2. Providing an archival process for project data.
3. Providing appropriate security ensuring edit capabilities are properly administered.
4. Creating a central repository for the operational plans.
5. Creating data visualization dashboards that can be updated dynamically for both the intranet

and internet sites.

1. Providing documentation for the implemented solution.
2. Providing Judiciary personnel with training and/or documentation that thoroughly details

(i.e., step-by-step) the process for updating the dashboards.

1. The Offeror proposed resource(s) shall use the following requirements to complete the required

deliverables:

1. Notification Process

(1) A list of project owners shall be created and be able to be maintained by the AOC.

(2) Ability to associate projects to the owner(s).

(3) Create a form template to be populated from a central repository, emailed (e.g.,

message or link) and easily populated.

(4) Ability to send bulk emails on a defined schedule.

(5) Transaction log for sending and receiving correspondence.

1. Update Collection Process

(1) Project owners shall easily be able to provide updates either in the email or via a link

to a form.

(2) The updates shall be able to be edited by the project owners.

(3) Project owners shall be able to access their projects and update when desired.

(4) Notification with a summary of updates will be provided to the project owner after

successful submission.

(5) Project owners can only update their projects.

(6) Project owners need the ability to create new projects and delete old projects.

(7) Data should be exportable into .csv or .xls.

1. Data Visualization and Reports

(1) Dashboards shall be designed and created for both the Judiciary internal (intranet)

and external (internet) facing websites.

(2) Dashboards shall be updated dynamically, upon source update.

(3) Create a series of canned reports that are exportable to .xls

1. The Judiciary reserves the right to review and/or suggest edits to process workflow, security and

dashboards prior to completion of work. The Offeror shall anticipate multiple revisions.

1. The Offeror shall submit completed work to Judiciary personnel for initial review on or before

August 29, 2025