Koen Moerman Email & Phone Number

Utrecht Area, Netherlands

OneStream product owner & developer; realizing many reporting efficienciesImplemented OneStream EPM (mainly core data model and financial consolidation)Developed and implemented RPAs (Robotic Process Automation) with Python, Power Automate, UiPathDesigned, simplified, aligned and implemented ERP Chart of Accounts & reporting structuresImplementation merging of multiple ERPs into 1 OracleImplementing automatic interface/ETL of multiple ERPs into consolidated ERP with FDMEEMonthly reporting to 2 shareholders in their HFMs in USGAAP & IFRSAutomating Excel processes, reconciliations with Power Query, VBAProviding trainings on finance and technology topicsCompleted Data Analytics training program

The Netherlands, Schiphol-Rijk

Manage the GMR&A team. Manage HFM consolidation and planning & budget process for Liberty Global. Manage development of KPIs and financial analysis to improve capital allocation decision-making and results. Monitor reporting consistency and drive data quality improvements. Lead reporting process improvements that result in standardization, efficiencies and increased effectiveness.Significant accomplishments:- Set-up of completely new lean GMR&A team and smooth transition.- Developed standardised (CAR) reports for i.e. 1on1s group CFO with division CFOs.- Implementation of performance monitoring framework combining the new End-To-End functional view with procurement spend bucket view (by nature).- Set-up automated recurring analysis for: Labour, New Build, Growth Drivers, ARPU.- Implemented data warehouse for Long Range Plan and implemented in reporting framework, now directly visualising impact of current results on long term objectives.

Schiphol-Rijk

Developing and delivering group steering information regarding working capital and free cash flow (over $2bn). Implementing group management reporting optimizations. Significant accomplishments:- Implementation of working capital KPIs & dashboards and cash flow forecasting templates. This reduced complexity and realised significant efficiencies.- Set-up expense reporting for group-wide functional areas, procurement spend buckets and capex management reporting structure.

- Accurate and complete reporting of US GAAP financials, statistics, budgets and forecasts of UPC Nederland to Liberty Global under tight deadlines- Monthly reporting of key performance indicators to management- Creating clear visibility to management on cash flow performance and outlook, greatly improving the company’s ability to meet targets- Performing timely and accurate external Dutch GAAP and tax reporting- Improving the understanding and execution by the Financial Control & Accounting team of cash flow management by trainings, assistance and the implementation of processes and templates- Coordinate the forecasting and budgeting process- Acting as a point of contact to the Liberty Global reporting, tax and planning departments to answer questions and provide ad hoc analysis.Projects/accomplishments:- Set-up standalone IFRS & US GAAP reporting- Accounting implementation of complex lease, vendor financing and tax structures- Improvement of forecast and long range plan of customer premises equipment expenses- Implementation of fixed assets useful life analysis and new bad debt provisioning methodology- ERP migration with overhaul of chart of accounts and mapping to HFM reporting system, which led to substantial efficiency improvements in the monthly close process and reconciliation

Accounting of fixed assets, programming, payroll and departmental expenses and liabilities.Significant accomplishments:- Integration of Priority Telecom accounting department and systems into UPC Nederland- Set-up processes and documentation framework of Sarbanes-Oxley Act controls

Processing invoices into an annual report, preparing consolidations and cash flow statements for external reporting and auditing medium to large enterprises, including audits of internal controls.