Initial Situation
A large energy utility company uses vendor software to generate IFRS 9 compliant accounting records for financial instruments. Performing quality assurance checks and subsequent corrections of these booking records partly requires considerable manual effort as input data is based on reports from different sources.
Project Scope
- Data standardisation for P&L calculation, risk calculation and accounting
- Design and implementation of a generic reporting engine based on the central valuation and risk database
- Implementation and integration of business requirements into the central reporting engine
- Automated generation of accounting records and reports compliant with accounting standards
- User interface and data management for specific configuration and accounting parameters
- Quality assurance and documentation of results
- Simplification of the data flow between the controlling department and the central accounting department
Our Contribution
- Designed and implemented a lean and flexible report engine (C#, Microsoft SQL Server) adapted to the customer’s needs
- Designed and implemented a graphical user interface for report configuration and generation
- Reproduced the status quo, i.e. generated all existing reports based on the new database and reporting engine
- Restructured the process for maintaining the database for accounting statements
- Documented code base and created user manuals for use by the end user
- Supported the implementation of new accounting, valuation and risk reports based on the new reporting engine
Customer Benefit
The client could reduce licensing and maintenance costs by standardising the data basis for P&L, risk, and accounting in the reporting engine. Moreover, the now more efficient accounting processes reduce associated operational risks significantly.
Relevant Skills/Tools
- Microsoft SQL Server
- C#
- Jira
- Confluence
- Jenkins
- Microsoft Excel
