Automated Invoice Upload
Automated financial reports developed in response to the manual data generation problem following the implementation of a new system.
Objective:
To automate quarterly P&L and balance sheet reports, which were manually generated after the system transition and required several days of work.
Scope:
➤ Rebuilding the report by designing a custom data model and presentation layer in BI Publisher
➤ Adding a column to indicate whether a company belongs to the capital group
Challenges:
➤ Linking accounts with exceptions (e.g., 700 + 701 excluding 7010101)
➤ Creating three reports with identical layouts: comparative, calculation-based, and balance — each using different datasets
➤ Reproducing the visual layout of the previous system’s report due to audit requirements
➤ One report variant required cost center classification (account 5), which did not exist in the system — I solved this by identifying and using several low-level Oracle tables not accessible via standard reporting tools
Outcome:
➤ Reduced report preparation time from 3–5 days to just a few minutes
➤ Eliminated manual processing errors
➤ The report became a standard and was used across all group companies
Technologies:
Oracle BI Publisher, SQL, general ledger, internal Oracle tables
Year:
2022