Background

The Department of Homeland Security Office of Chief Financial Officer (DHS OCFO) relies on its Purchase Request & Obligation Management SharePoint Site (PROMS) as an enabler of key workflows. DHS OCFO leverages PROMS to facilitate the review process for several types of financial purchase requests and obligations.

Highlights

1st DHS applications built on O365 using SharePoint Online, SPFx, and Power Automate

Financial managers from DHS Components submit financial requests for approval by financial certifiers and fund approvers within HQ OCFO. PROMS provides a central location to monitor, review, and report on all financial requests within DHS. Requests are often time-sensitive, and PROMS ensures they are completed quickly through a prompt notification system.

Challenge

PROMS was originally built over the course of several years using Microsoft SharePoint. When Definitive Logic (DL) inherited the legacy PROMS, it resided on-premises on SharePoint 2016. DHS sought a rapid modernization of PROMS, while simultaneously continuing to maintain and support the existing PROMS site.

Approach

In 3 months, DL re-designed and rebuilt PROMS entirely within the DHS Office 365 tenant, becoming the 1st DHS application deployed on that platform.

A key design principle was the use of a single generic process form to establish a robust backbone for PROMS that would be easier for OCFO to maintain. By leveraging SharePoint Online, SPFx, and Microsoft Power Automate, DL established an architecture for PROMS that would allow process, form, and approval routing updates to be made without writing code by the staff in OCFO.

Outcomes

DL’s modernization of PROMS granted DHS OCFO several benefits, including:

  • Reduced overall, maintenance and enhancements costs by ~80%.
  • Increased scalability due to a new structured approach to storage and permissioning.
  • Increased security due to migrating from fluid permissions to static permissions.

With this modern Microsoft architecture, PROMS has the groundwork to rapidly deploy additional workflows. Since the production release, DL has extended functionality several times, including the addition of a thorough “product checklist” for DHS OFO to manage Plant, Property and Equipment (PP&E) expenses.

Michael Conlin

Michael Conlin​

Chief Technology Officer​
Phone: (703) 216-5856​
michael.conlin@definitivelogic.com​

5 Anti-patterns for ethical digital

5 Anti-patterns for ethical digital

Grapple with ethics through ad-hoc discussions or on a per-offering basis Implant strict, imprecise, and overly broad policies that lead to false positives in risk identification, stymie output and discredit the program ​ Fail to consider the entire value-chain from...

read more
My data journey: 60 days as an intern At DL

My data journey: 60 days as an intern At DL

My name is Deron Banks and I’ve been an intern at Definitive Logic this summer. I am entering my final year at George Mason University as a Computer Science major. I’ve learned and experienced many new software programs and techniques during my time here. Postgres,...

read more