Articles
| Open Access |
DOI: Automating the Capital General Rate Case Filing Process Using SAP HANA: A Digital Transformation Approach for Regulatory Compliance
Naveen Nischal Vaduguru , “SAP HANA Data Engineer” Missouri City, Texas, USAAbstract
A General Rate Case (GRC) is a formal regulatory process where a utility company requests approval from a regulatory body—such as the California Public Utilities Commission (CPUC)—to adjust customer rates based on projected costs and revenues. Utilities typically submit GRC filings every three years, presenting detailed financial, operational, and capital data. The goal is to justify rate changes needed to support infrastructure, operations, and returns for investors. The process includes public hearings, stakeholder input, and regulatory review before rates are approved, modified, or denied. GRC filings are complex and labour-intensive, often requiring manual data extraction, analysis, and documentation. Automation tools such as SAP HANA can significantly streamline this process by consolidating data from multiple sources, performing cost allocations, validating inputs, and generating regulatory reports. Automation reduces errors, saves time, and ensures better compliance. Key components of GRC preparation include capital data (financial, physical, human, and intellectual), budget codes for tracking expenditures, and workpaper groups that organize supporting documents. Witness areas define expert testimony topics, while special remaps update compliance programs. GRC tools facilitate risk assessment, policy management, and reporting, supporting both GRC-specific filings and broader utility compliance efforts. Automating GRC processes enhances transparency, accuracy, and regulatory responsiveness.
Keywords
GRC, SAP HANA, Regulatory Compliance, Automation
References
Rate Case Support
https://www.consultcelerity.com/case-studies/gas-electric-utilities/
Lessons Learned from the Rate Case Process: An analysis of utility rate case experiences, highlighting best practices and common challenges.
https://www.mcr-group.com/wp-content/uploads/2024/01/Rate-Case-Paper-Part-2-Lessons-Learned.pdf
SAP HANA XSA Migration Strategy
2025 General Rate Case Total Compensation Study: A study examining total compensation as part of Southern California Edison's GRC filing.
https://docs.cpuc.ca.gov/PublishedDocs/SupDoc/A2305010/6064/508571399.pdf
2025 GRC Study on Residential Disconnections: Assessment of how proposed rate increases may impact residential service disconnections.
https://docs.cpuc.ca.gov/PublishedDocs/SupDoc/A2305010/6065/508572055.pdf
PacifiCorp’s GRC Operations Report: Details on PacifiCorp's operational results and methodologies in their GRC filing.
https://docs.cpuc.ca.gov/PublishedDocs/SupDoc/A2205006/5704/500158375.pdf
Pacific Gas and Electric (PG&E) General Rate Case (GRC) Proceedings Overview
Technology Platforms Essential to Prove Need in Utility Rate Cases
Accelerating utility rate case filings with generative AI
Neudesic on GenAI Use Cases for GRC: Exploration of how Generative AI can assist in preparing and managing GRC filings.
https://www.neudesic.com/blog/genai-use-cases-general-rate-case/
Towards Multi-way Join Aware Optimizer in SAP HANA
Article Statistics
Copyright License
Copyright (c) 2025 Naveen Nischal Vaduguru
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors retain the copyright of their manuscripts, and all Open Access articles are disseminated under the terms of the Creative Commons Attribution License 4.0 (CC-BY), which licenses unrestricted use, distribution, and reproduction in any medium, provided that the original work is appropriately cited. The use of general descriptive names, trade names, trademarks, and so forth in this publication, even if not specifically identified, does not imply that these names are not protected by the relevant laws and regulations.