Driving Operational Efficiency in Finance, Grants and Procurement with DiLytics Insight Solutions

The client is a leading public agency dedicated to sustainability, transforming waste into valuable resources such as recycled water, energy, and materials. Serving more than 5.5 million residents, the agency oversees multiple large-scale projects and initiatives, making it a key pillar in regional environmental management.

Background

As Los Angeles County Sanitation Districts’ (LACSD) operations grew and it began managing multiple projects and services, the agency faced increasing challenges in consolidating and analyzing data across critical functions such as finance, procurement, and grant management​.​ Here are few key challenges faced by the client:

• Limited visibility into cash flow, journal line details, account balances, and account activities across departments 
• Difficulty in tracking payables and receivables, leading to delayed collections and missed early payment opportunities
• Lack of integrated visibility into procurement efficiency, supplier performance, and purchase price variances  
• Lack of transparency and control over grant performance, affecting financial accountability and compliance 

We deployed our prebuilt flagship solutions — DiLytics Financial Insight Solution, Procurement Insight Solution, and Grant Insight Solution — all approved by Oracle Corporation and available on Oracle Marketplace. Leveraging the rich prebuilt content of these solutions, DiLytics met LACSD’s diverse business requirements with minimal customization, ensuring a seamless fit across finance, procurement, and grant management functions. The solutions were deployed quickly, with Financial Insight in 3 months, Procurement Insight in 2 months, and Grant Insight in 2 months. In addition, DiLytics also implemented a Usage Metric Dashboard in Microsoft Power BI to help LACSD monitor user engagement and data accessibility. ​

DiLytics applied its proven 5-step methodology to ensure smooth integration into LACSD’s workflows,combining out-of-the-box capabilities with tailored enhancements aligned to the agency’s operational goals.​

With the DiLytics Financial Insight Solution, LACSD was able to track and analyze key business metrics across essential financial areas, including:

• General Ledger (GL): Activity, balance, and budget performance
• Accounts Payable (AP): Payment schedules, distributions, and overdue payments
• Accounts Receivable (AR): Outstanding invoices and customer balances

With the DiLytics Procurement Insight Solution, LACSD was able to track and analyze key business metricsacross essential procurement areas, including: 

• Purchase Requisitions: Requisition volumes, trends, detailed statuses, and supplier performance
• Purchase Orders: Order activity, purchasing trends, and supplier reliability and efficiency

With the DiLytics Grant Insight Solution, LACSD was able to track and analyze key business metrics acrossessential grant areas, including: 

• Grant Funding – Funding status, installments, balances, and project budget versions
• Grant Awards – Award budgeted, award actuals and encumbered amounts
• Grant Cost – Account and project costs, expense summaries and details

Results

The client achieved several improvements including:

• Strengthened financial control and accountability across departments 
• Improved utilization of public funds and operational resources 
• Increased transparency and trust among stakeholders 
• Reduced costs by tracking procurement trends and purchase patterns
• Tracked usage patterns to optimize reporting effectiveness
• Enhanced audit readiness with comprehensive and accurate financial records

Tech Stack Summary

Data Source: Oracle E-Business Suite and Oracle Primavera Unifier ​

Data Integration: Oracle Data Integrator ​

Data Warehouse: Oracle Autonomous Data Warehouse ​

Data Visualization Tool: Oracle Analytics Cloud and Microsoft Power BI ​