Calculating the global business plan for 5 years. Feasibility studies for product developments. Systems used: Excel, VBA, Powerpoint.
Accounting HGB & IFRS. PMO Systemmigration Datev to MS DYN BC 365. Finance & IT Interface. Process improvement. Systems used: Datev Kanzlei Rechnungswesen, MS DYN 365, Power BI, Excel, VBA, Powerpoint.
Finance Manager role based in Indianapolis, Indiana, USA. Systems used: SAP R3, BOARD, Power BI, Excel, VBA, Powerpoint.
Creating Segment Reporting in MS Excel. PMO Set-Up for ERP- & BI-TOOL ReSetUp. Finance & IT Interface. Process improvement. Project controlling new products & production site. Recalculation of discontinued production lines. Systems used: SAP R3, BOARD, Power BI, Excel, VBA, Powerpoint.
Install project plans. Project data. Set up folder structure. Finance & IT Interface. Process improvement. Systems used: SAP R4, Datev Kanzlei ReWe & Unternehmen Online, IDL KONSIS, Power BI, Excel, VBA, Powerpoint.
Head of Sales Controlling. Finance & IT Interface. Process improvement. Project controlling new products & production site. Feasibility studies for product developments. Systems used: SAP R4, SAP BW, S4HANA, Tagetik, Power BI, Excel, VBA, Powerpoint.
Install project plans. Project data. Set up folder structure. Finance & IT Interface. Process improvement. Systems used: SAP R4, SAP BW, SAP SAC, S4HANA, Power BI, Excel, VBA, Powerpoint.
SAP S4HANA Upgrade. Finance & IT Interface. Process improvement. Creating Excel Tools: Group P&L, Group Balance Sheet, Group Cash Flow, HGB & IFRS. Connect to SAP SAC & Power BI. Build-Up Sparring to all Divisions. Systems used: SAP R4, SAP BW, SAP SAC, Power BI, Excel, VBA, Powerpoint.
Navision & MS Dynamics Upgrade. Finance & IT Interface. Process improvement. Excel Tools: Group G&V, LE P&L, Group Balance sheet, Liquidity Planning, Budget. Implemented Global Sales Structure. Project controlling new products & production site. Feasibility studies for product developments. Systems used: NAV 2017, MS Dynamics 365 Business Central, Excel, VBA, Powerpoint.
Migration Project for the consolidation software Tagetik. Project Lead Preparation Global Finance Update. Finance & IT Interface. Process improvement. Systems used: SAP R3, SAP SEM BCS, Tagetik, Excel, VBA, Powerpoint.
Creating a financial model including production controlling. Feasibility studies for product developments. Finance & IT Interface. Process improvement. Systems used: SAP R3, SAP SEM BCS, Cubware, Excel, VBA, Powerpoint.
Migration Project for the new consolidation software Tagetik. Finance & IT Interface. Process improvement. Systems used: SAP R3, Tagetik, Excel, VBA, Powerpoint.
Restructuring of the Finance Division (Consulting for outsourcing to a Finance Shared Service Center). Finance & IT Interface. Process improvement. Setup of the item cost calculation in the inventory management system. Acquisition of new employees. Complete process documentation. Systems used: DS Datentechnik, Datev Mittelstandsfaktura, Datev Unternehmen Online, Excel, VBA, Powerpoint.
Migration Project for the new consolidation software Tagetik. Finance & IT Interface. Process improvement. Systems used: SAP R3, SAP SEM BCS, SAP BW, BPC, Tagetik, Excel, VBA, Powerpoint.
Migration Project for the new consolidation software Tagetik. Finance & IT Interface. Process improvement. Systems used: SAP R3, SAP SEM BCS, SAP BW, SAP BPC, Tagetik, Excel, VBA, Powerpoint.
Transfer Project Accounting. Relocation. Finance & IT Interface. Process improvement. Systems used: Own developed CMS, Excel, Powerpoint.
Restructuring of the Finance & Accounting department. Finance & IT Interface. Process improvement. Sales Controlling. Rebuilding the reporting. HGB & IFRS. Project controlling Vehicle construction. Systems used: SAP R3, Excel, OLAP, VBA, Powerpoint.
Restructuring of the Finance & Accounting department. Sales Controlling. Rebuilding the reporting. Project controlling transport processing. Finance & IT Interface. Process improvement. Systems used: MS Dynamics, Cognos Data Warehouse, Access, Excel, OLAP, VBA, Powerpoint.
Consultancy of the group service project. Review Global SLA vs. Country SLA for the IFMS. Internal review of the IFMS. Developing a reporting for the service units. Finance & IT Interface. Process improvement. Systems used: SAP Shape, SAP PEP, Excel, VBA, Powerpoint.
VAT Audit model in MS Excel. Oracle R12 Tax Engine. Support for the statutory reporting. Preparation for the implementation of the VAT model into Oracle R12 Tax Engine. Process improvement. Systems used: Oracle ERP R12, Oracle Tax Engine, Excel, VBA, Powerpoint.
Strategic consulting for the VP Corporate FP&A. HGB & IFRS. Reconciliation SAP CO / FI. Integration SAP BW and SAP BPC. Sales Margin Reports on line item level. Project controlling Telco city network setup. Systems used: SAP: CO, FI, MM, AA, PUR, SD, SPRO, SAP BW, SAP BPC, Excel, OLAP, VBA, Powerpoint.
Group reporting for 45 entity’s (Excel & SAP). Finance & IT Interface. Process improvement. HGB & IFRS. Recreation of the standard item cost calculation. Recreation of the SAP-Set up’s. Reorganisation of the finance department. Project controlling Telco city network setup & global technical & repair locations. Systems used: SAP: CO, FI, MM, AA, PUR, SD, SPRO, SAP BW, SAP BPC, Excel, OLAP, VBA, Powerpoint.
Creating a planning tool for 2 companies including consolidation in Excel. Finance & IT Interface. Process improvement. Project controlling mechanical engineering. Systems used: Excel, OLAP, VBA, Powerpoint.
Feasibility study for new product lines. New creation of the group reporting (HGB & IFRS). Core Team Lead Oracle ERP 11.5i. Key-User Oracle ERP 11.5i. Creating the margin analyses. Setup of the self-cost calculation. Restructured the standard costing. Setup of the calculation of overhead cost rates. Recreation of the Excess & Obsolete-Calculation. New construct of the sales Tool "MIK". Business partner for the business planning. Preparation of guidelines and instructions. Approval of special conditions for customers. Preparation of the Oracle user documentation. Process improvement. Systems used: Oracle ERP 11, Oracle Discoverer, Oracle Viewer, Excel, VBA, Powerpoint.
Group reporting (consolidation in Excel) HGB & IFRS. New creation of the margin analysis. Development of the WarehouseForecastTool. Monthly, quarterly, and yearly financial statements. Process improvement. Systems used: IDL consolidation tool, Access, Excel, OLAP, VBA, Powerpoint.
Liquidity planning. Weekly and monthly deviation analysis. Reporting to the headquarter in Sweden. Responsibility for applying the group guidelines. Weekly liquidity status & control of the payment runs. Financial analytics for the affiliated companies. Responsibility for all financial guarantees. Bank mandate. Administration responsibility for the technical facilities. Carrier Collection. Systems used: Cognos Controller, TM1, Datawarehouse, Access, Excel, OLAP, VBA, Powerpoint.
New setup of the cost accounting. Reporting for the Tele2 Billing GmbH (HGB & IFRS). Assistant to the Chief Accountant & the CFO. Reporting the business units. Investment Controlling (IP-Proposal). Introducing of the Sarbanes-Oxley-Act. Support during the tax audits and the internal audits. Contact for tax advisors & banks. Finance & IT Interface. Process improvement. Systems used: Cognos Controller, TM1, Datawarehouse, Excel, OLAP, VBA, Powerpoint.
Assisting the German Financial Manager. Successful implementation of the Sarbanes-Oxley-Act. Assisting the VAT tax group. Project assistant project controlling. Systems used: Hyperion Financial Management incl. Datawarehouse, Excel, OLAP, VBA, Powerpoint.
Group reporting US-GAAP. Accounts receivables and fixed assets. Leading the receivables management. Preparation of VAT returns. Overhead cost controlling. System training "SUN-Accounting". Finance & IT Interface. Process improvement. Systems used: SUN Accounting, Excel, Powerpoint.
Group Accounting IFRS for 5 countries. Cost accounting. Administration ERP Navision Attain. Finance & IT Interface. Contact for tax advisors & banks. Process improvement. Systems used: MS Attain, Excel, VBA, Powerpoint.
BU-Controller Storage Device Division. Monthly, half-year, and annual financial statements. Budget & Forecast. Finance & IT Interface. Systems used: Hyperion Enterprise incl. Datawarehouse, Excel, OLAP, VBA, Powerpoint.
Deputy head of accounting (20 FTE’s). Reporting for the management & group. Preparation Forecast & Budget. Check of the Budgets. Monthly and yearly reporting US-GAAP. Administration of fixed assets. Reconciliation management and intercompany accounts. Preparation of VAT returns. Supervising of the credit & collection department. Contact for tax advisors & banks. Migration of 5 ERP systems. Finance & IT Interface. Process improvement. Systems used: SUN Accounting, Access, Excel, OLAP, VBA, Powerpoint.
Audits for major companies. Audits of financial statements of liquidated companies. Year-end closing (tax, local gaap, IFRS & US-GAAP). Accounting & payroll accounting. Tax declarations for natural persons and legal entities. Review of tax assessments. Implementing the software "Datev", client side. Tax, HGB, IAS, US-GAAP. Construction cost wages. Construction cost controlling injection moulding machines. Excel Consolidation Tool für 85 rechtliche Einheiten. Finance & IT Interface. Process improvement. Systems used: Datev Kanzlei Rechnungswesen, Excel, Powerpoint.