Optimizing Grant Tracking and Reporting with DiLytics Grant Insight Solution on Oracle​

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 growing challenges in efficiently managing and tracking its grant-funded programs.​ Here are few key challenges faced by the client:

• Limited real-time visibility into grant funding, awards, expenditures, and project progress
• Difficulty tracking budgets, costs, and available balances across multiple active grants
• Fragmented data across departments leading to reporting delays and inconsistent insights
• Lack of transparency and control over grant performance, affecting financial accountability and compliance 

We deployed our prebuilt flagship solution, DiLytics Grant Insight Solution, approved by Oracle Corporation and available on Oracle Marketplace. Using its rich prebuilt content, DiLytics was able to address LACSD’s grant management needs with minimal customization, ensuring a seamless fit for their processes. The solution was implemented in just two months, providing rapid, end-to-end visibility into grant funding, awards,budgets, and expenditures. Following a proven 5-step methodology, DiLytics combined out-of-the-box capabilities with targeted adjustments to optimize grant tracking, reporting, and overall financial oversight.

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:

• Real-time visibility into grant funding, awards, and expenditures
• Accurate and timely reporting with reduced manual effort
• Streamlined tracking of active grant projects and task milestones
• Improved financial oversight and compliance​
• Centralized grant data for better decision-making
• Faster response to funding changes and project updates​

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 ​