Passaic Valley Sewerage Commission

SUMMARY

PMWeb was implemented for a 10-year, $2.1 billion USD program of capital works from 2016 to 2026. AECOM was contracted by Passaic Valley Sewerage Commission to manage the program of works and AECOM selected PMWeb. This engagement also included an extensive migration of legacy hardcopy documents to digital files and data in PMWeb.

OVERVIEW

Established in 1902, the Passaic Valley Sewerage Commission (PVSC) began operation of the Newark Bay Treatment Plant in 1924 as a means to alleviate pollution in the Passaic River and its tributaries. Major expansions, upgrades, and renovations throughout the twentieth century have made the PVSC one of the largest wastewater treatment plants in the United States.

Since 1902, the PVSC has expanded its mission to enhance the viability, and environmental health and security of the 1.4 million residents in the 48 municipalities of Bergen, Essex, Hudson, Union and Passaic Counties of the Passaic Valley Service District.

PMWeb 7 Passaic-Valley-1

CHALLENGE

The Passaic Valley Sewerage Commission sustained more than $90 million in damages from Hurricane Sandy. The 140-acre plant, situated near the confluence of the Passaic River and Newark Bay, was entirely engulfed by floodwaters, which destroyed much of PVSC’s critical process equipment. PVSC needed a modern Program Management Information System (PMIS) to help manage their 10-year $2.1 billion USD Resiliency Program from 2016 to 2026.

SOLUTION

AECOM was been hired by Passaic Valley Sewerage Commission (PVSC) to provide program management services for their Resiliency program as part of renovation work from the aftereffects of Hurricane Sandy. PVSC has authorized AECOM to select a Program Management Information System (PMIS) software for managing this program.

PMWeb was selected and is being used to manage this program. PMWeb usage includes the following areas: Planning (Capital Planning Initiatives and Portfolios), Project Management (Drawings, Submittals, RFI, Correspondence, Meeting Minutes, Action Items, Transmittals, Budgets, Commitments, Changes, Progress Payments, Invoices, AP Payments), Workflow Document Routing, Asset Management, Scheduling, Integrations, Document Management, Risk Analysis, and Business Intelligence Dashboard and Reports.

As implementation proceeded, PVSC also raised the need to address its massive store of historical documents that were essential for future project work. This involved an extensive migration of hardcopy documents to digital.

RESULTS AND BENEFITS

PMWeb is a key tool for managing this program and provides a single centralized source for transparency, stakeholder collaboration, communication on all essential documents, records, and data. PMWeb Business Intelligence reporting provides powerful customizable dashboards and reports that give a current and accurate analysis of program status and performance. This empowers users to make informed choices with the best available data.

The following sections outline work to digitize PVSC records and integrate PMWeb with Oracle financials.

PVSC CURRENT LEGACY DATA

  • Convert Paper To Electronic Files
  • Scanning
  • Indexing
  • Preparing Tables for PMWeb
    • Large Engineering Records
    • Small Engineering Records
  • CreatingFoldersandAttributesinPMWeb

30,000 Large Engineering Drawings

  • D&E Size Flat Sheets
  • Sepias, Prints, As-Builts
  • Microfilm, Aperture Cards

250,000 Small Engineering Records

  • A, B, C Size
  • Contract documents
  • Shop Drawings, Submittals, Specifications
  • Photos, Purchase Records ,O&M Manuals
PMWeb 7 Passaic-Valley-2

PVSC’s need to digitize its records was supported by IDC surveys that indicated the average knowledge worker spends 20% of his/her time looking for information. This is exacerbated with aging hardcopy records – it’s hard work and it takes time.

To address this, business insight and value needs to be extracted from unstructured information. This process includes:

  • Add structured information to unstructured files and transfer to PMWeb
  • Deeper insight into the business value of existing unstructured information – i.e. work out what to keep
  • Prevention of accidental non-compliance with privacy regulations
  • Increased efficiency searching for business information – Facet or Topic based searching
PMWeb 7 Passaic-Valley-3
PMWeb 7 Passaic-Valley-4

NATURAL LANGUAGE PROCESSING is used to automatically extract metadata from each file, including image files using OCR – places, people, dates etc. Tagging information is built for files.

A starting point is a Business Taxonomy – the “DNA”:

  • Employees
  • Facilities
  • Suppliers
  • Projects
  • Document types
  • Products
  • Etc.

RELEVANCY PROCESSING is used to evaluate the importance of each file based upon the Business Taxonomy :

  • Filter files with no business value
  • Filter another ~30% to 40%with dynamic adjustment of relevancy per file over time.

EXCLUSION PROCESSING uses rules such a very old files; personal information; and duplicates.

JUNK PROCESSING filters out “junk” files – empty files; temp files; trivial files.

CONTENT TRANSFER is the final step: 

  • Re-organize files
  • Automatic Categorization
  • Move Files to PMWeb
  • Provide Searching
PMWeb 7 Passaic-Valley-5

“The Technical support team is excellent when needed and the turnaround time in returning your call is also excellent.”

James Tarabocchia
Supervisor CADD/GIS Operations
Passaic Valley Sewerage Commission

INTEGRATION

Two-way automation of transactions between PMWeb and Oracle eBusiness Suite was implemented. The PMWeb modules involved were:

  • Commitments (Contracts/Subcontracts)
  • Change Orders
  • Progress Invoices
  • A/P Payments
  • Companies
PMWeb 7 Passaic-Valley-6 Source Application Application  Module Target Application
PMWeb 7 Passaic-Valley-7 Oracle EBS

INTEGRATION OBJECT MAPPING

PMWeb 7 Passaic-Valley-8 Condition Direction Oracle EBS

CONFIGURATION CHANGES

Oracle EBS changes

  • Profile Options for Web Service URLs
  • Descriptive Flex-Field at Vendor to identify records that can be interfaced to PMWeb
  • Capture of the PMWeb Project ID’s in the corresponding tables in EBS to ensure matching of corresponding records between EBS and PMWeb

PMWeb changes

  • Added project level custom fields (Specifications) for EBS Project, Task, and Organization
  • Used to derive the corresponding EBS Project and Awards (source of money)

WEB SERVICES AND APIS USED

PMWeb 7 Passaic-Valley-9 web Service EBS API/Interface

PMWEB MODULES

  • Core Module with Business Intelligence, Reporting, Security
  • Planning, Prioritization, Estimating, Online Bidding
  • Cost/Contracts, Project Management, Forms, Budgets, Funding
  • Visual Workflow
  • Scheduling
  • Asset Management

PMWEB TOOLS

  • Document Manager
  • Stage Gates
  • Vendor Pre-qualification
  • Risk Management
  • IM and/or API
  • SharePoint integrationl