A portal for monitoring energy
consumption data
About the client
Santa Maria Comercializadora is a Brazilian firm specializing in energy trading and electric power management. Operating within the Brazilian energy market, the company offers services including energy trading, risk management, and consultancy.
Santa Maria Comercializadora prioritizes optimizing energy procurement with customized solutions tailored to meet the specific requirements of businesses and industries.
Emphasizing reliability, efficiency, and adherence to regulatory standards, the firm utilizes its expertise to navigate the intricacies of the energy market, delivering substantial value to its clientele.
Santa Maria Comercializadora prioritizes optimizing energy procurement with customized solutions tailored to meet the specific requirements of businesses and industries.
Emphasizing reliability, efficiency, and adherence to regulatory standards, the firm utilizes its expertise to navigate the intricacies of the energy market, delivering substantial value to its clientele.
Targeted Users
500+ enterprise clients (USD 1B+ under contract)
Project Duration
4 months
Maintenance
2023 – Present
Project overview
Santa Maria Comercializadora previously had a labor-intensive and time-consuming procedure for generating reports for their clients. These reports encompassed general consumption details, savings, and financial forecasts.
The process involved cross-referencing data from multiple systems, consolidating it in Excel, applying formulas to extract insights, and creating graphs before exporting the document to PDF for distribution. Waven devised a microservice to streamline this process.
The microservice fetches data from diverse sources via a scheduled routine, performs necessary calculations, and stores the information in a database, ensuring an auditable history. Subsequently, the solution generates graphs on a web portal for convenient client monitoring and automatically produces and sends PDF reports to each client.
The process involved cross-referencing data from multiple systems, consolidating it in Excel, applying formulas to extract insights, and creating graphs before exporting the document to PDF for distribution. Waven devised a microservice to streamline this process.
The microservice fetches data from diverse sources via a scheduled routine, performs necessary calculations, and stores the information in a database, ensuring an auditable history. Subsequently, the solution generates graphs on a web portal for convenient client monitoring and automatically produces and sends PDF reports to each client.
Key Technologies
- C#/
- .NET.
- Oracle
- Docker
- Windows Server
- Angular
Capabilities
- Automated retrieval of consumption data, savings figures, and financial projections sourced from various systems.
- Application of calculations and formulas to the gathered data to derive insights such as savings percentages, financial forecasts, and other pertinent metrics.
- Storage of processed data in a database to maintain a complete history of reports and calculations over time.
- A web-based portal enabling clients to monitor real-time or periodically updated graphs and visualizations of their consumption, savings, and financial projections.
- Automated creation of PDF reports summarizing findings, including graphs and key metrics, customized for each client.
- Automated distribution of generated PDF reports to each client via email or a secure portal.
Value Delivered
Waven successfully revamped Santa Maria Comercializadora’s reporting process, enhancing efficiency, accuracy, and client focus, while ensuring scalability and compliance with auditing standards.
- Substantially decreased the time and labor previously devoted to manual data collection, Excel consolidation, and report generation.
- Ensured data precision through automated data retrieval and consistent application of calculations and formulas across all reports.
- Clients received timely reports reflecting current consumption data, savings information, and financial projections.
- Enhanced client satisfaction with convenient access to real-time data via a user-friendly web portal and prompt delivery of comprehensive PDF reports.
- Developed a scalable solution capable of managing increased data volumes and expanding client requirements without compromising performance.
- Facilitated compliance with auditing requirements by maintaining a complete, auditable history of all reports and data transformations.
- Reduced costs associated with manual labor, errors in manual processes, and potential discrepancies in report generation.
