Senior Consultant

Freelance IT Consultant

Grøndahl Consulting

2019-01 - Nykyhetki

Senior Consultant, UFST (SKAT)

Knowit Decisions Denmark A/S

2021-09 - 2023-03

Employed through Knowit Decisions Denmark A/S on a large property assessment data project. The tasks included a definition of a generic data entry model for DAF source data using SAS DI job. This to optimize the ETL process when loading and transferring data to new data warehouse on SQL Server.

Senior Consultant

Codan A/S

2021-04 - 2021-05

Employed through Rekrutteringsgruppen ApS on a large reporting project. The tasks include move of the data foundation for both internal and external customer reporting to new data warehouse on SQL Server with new ETL setup using SSIS.

Senior Consultant

Jyske Bank A/S

2020-03 - 2021-04

Employed through Rekrutteringsgruppen ApS on a large Credit Risk project (CRD Capital Requirements; Pillar I, Credit Risk). The project deals with methods for calculating credit risk and is anchored in the bank's "Credit Model Department". Coding of model data processing in SAS BASE.
Setup of Data Dictionary in SAS BASE and Excel based on Model code developed in SAS, T-SQL and R.
Preparation of model documentation. Data quality work on model data using SAS BASE.

Senior Consultant

Lowell A/S

2019-11 - 2020-02

Employed through ProData A/S on a major system consolidation project at Lowell A/S. Move current SAP BO (WEBI) reporting to SAS Base. The reports are both used as internal reports & as reports distributed to external parties. Contribute in creating a new MS SQL Datawarehouse for the new SAS reporting setup at Lowell A/S. Act as 1st. level support on SAS ETL flows around current legacy reporting and data transfers.

Senior Consultant

Ørsted A/S

2019-01 - 2019-06

Employed through Knowit Decisions Denmark A/S on a large Marked Abuse Regulation Surveillance (MAR) project at Ørsted A/S. The project was developed using SAS software connected to Oracle & MS SQL Databases. By utilizing my knowledge from Compliance & Accounting the data load (ETL) part of the solution was redesigned. The monitors (the key measure points) were completed according to the legal requirements. The system was made ready for go-live in production environment.

Freelance IT consultant and participating in online training

Initiating Grøndahl Consulting

2018-09 - 2018-12

He was looking for new opportunities as a Freelance IT consultant and participating in online training sessions.

BI Specialist

Lantmännen Unibake Holding A/S

2016-06 - 2018-08

As a part of the IT organisation, the consultant was the Solution Owner and the Business Process Manager for the BI systems in Lantmännen Unibake.
Achievements/work areas: Maintain old BI solution (QlikView) and develop the new BI solution based on Microsoft Power BI.
The tasks were handled in close corporation with the IT department in Lantmännen (the parent company), the Business Process Mangers and the Super users across the Unibake organisation. Make the transition happen from the old BI tool to the new BI based on MS Power BI and MS SQL Server 2016.
As BI Specialist in Lantmännen Unibake his responsibilities were; ● Ensuring consistent BI templates composed of standard reports, dashboards and tailored ad hoc reports both for Group functions and local users.
● Define and execute on the most suitable design and be responsible for deliveries.
● Support the companies joining the new BI solution in terms of function and design.
● Promote a BI super-user community across the group.
● Continuously adapt and improve training and communication materials.

Senior Consolidation Specialist

Arla Foods Amba

2014-12 - 2016-06

He worked in a specialist department as a part of the Global accounting department.
Achievements: Upgrade the consolidation system within timeframe at a significant lower cost than expected/forecasted. Increase the usage of system and providing better understanding of the functions in the system.
As Senior Consolidation Specialist in Arla Foods Amba my responsibilities were.
● Master and run the consolidation process in SAP BFC.
● Maintain and enhance the functionality of the system.
● Provide monthly and annual consolidation reporting.
● Perform Financial controlling of entities.

SAS Finance Specialist

Vestas Wind Systems A/S

2012-07 - 2014-12

Achievements: Setup of and managing the SAS FM system used for all aspects of the internal & external reporting in the Vestas Group starting in March 2005 - the first reporting of 2005. Continued development and increased usage in a constantly evolving company, making sure that all reporting requirements were fulfilled.
● SAS Finance Specialist in Vestas SAS Group. SAS Group is a part of the Finance Systems in Vestas Global Finance. The manager of the department is referring to the SVP in Global Finance.
● SAS Team is responsible for Vestas SAS Installation. The installation is a SAS BI/DI installation with Analytics server & a Financial Management (FM) solution (approx.. 320 users). The Vestas SAS FM installation is one of the largest SAS FM installations around. The SAS FM system is used for of consolidation of; - Financial Reporting (monthly) & Budgets - Environmental reporting (monthly) - Currency exposure (monthly) - Cash flow reporting (weekly) ● SAS Specialist in the SAS Group - main tasks of group: - Keep SAS system running and in accordance with Vestas GAAP rules and regulations (IRFS standards).
- Development using ETL & Base SAS tools.
- Helpdesk all SAS applications including server monitoring, user training.
- Headmaster on MAPICS COA + COD (MRP system of production units)

Team Leader SAS Group

Vestas Wind Systems A/S

2004-11 - 2012-07

Team Leader SAS Group. SAS Group is a part of the Reporting & Compliance Group in Vestas Group Finance & Operations. My position was with direct reference to the SVP in Reporting & Compliance.
- Part of Leader Group in Reporting & Compliance Group - Personnel responsibilities for 2 persons.
- For other tasks and responsibilities please see above position as SAS Finance Specialist.

Project leader

SAS FM

2004-01 - 2005-01

since then main driver of the Vestas SAS FM and other specialized SAS developments/applications - Vestas SAS FM solution is situated atop SAP, SAP-BI and MAPICS/XA, other ERP systems and other database systems.

Controller

RBM A/S

2004-05 - 2004-11

RBM A/S a Danish owned sales and manufacturing Company producing furniture, office chairs, conference chairs and tables. www.rbmfurniture.dk The position was with reference to the Finance Manager (CFO).
Achievements: Creation and implementation of reporting structure and procedures. Increase the usage of ERP system and create more visibility in the production controlling.
As Controller at RBM A/S my responsibilities were; - Responsible for all communication to foreign subsidiary concerning financial issues.
- Creation of monthly accounting reporting for the Group and specific companies.
- Development of method and procedures in connection with foreign subsidiary.
- Controlling and reporting on actual figures against budget at Group-, company- and department/profit centre level.
- Participate in the work for the Year End accounts for the Group and the Parent company.
- Production controlling including stock control.
- Productions analyses including cost price re-calculation.
- Sales analyses.
- Participating in enhancing and developing internal workflows and procedures.
- Controlling of the Navision Attain system (ERP-system).
- Ad-hoc tasks for Financial Manager and the Board of Directors.

Budget Manager

Royal Greenland A/S

1999-04 - 2004-05

The position was with direct reference to the Group CFO.
Achievements: Creation and implementation of a reporting environment with clear flow data from SAP to consolidation in SAS CFO and TM/1. Setup of reporting structure and related data in SAP on profit centre level.
As Budget Manager at Royal Greenland A/S my areas of responsibilities were; - Group budget, including sales-, production-, stocks-, personnel-, cash flow- and investment budget both processes, method and actual creation.
- Backup for Group Chief Accountant on Consolidation of monthly, quarterly, half-year and year-end reporting and on procedures/guidelines and systems.
- Controlling and some reporting on actual figures against budget at Group-, company-, department-, profit centre and product level.
- Creation of forecasts/estimates based on internal monthly, quarterly half-year and year-end accounts.
- Production analyses including pricing on products.
- Sales analyses - Other cost analyses including alternative internal accounting principles for individual factories.
- System responsibility for group budget-, consolidation- and reporting systems. (TM/1, SAS CFO) including responsibility for data transfer from SAP to SAS CFO and further to TM/1. This included both maintenance of method/setup and actual running the flow.
- Super/"over" key-user on SAP R/3. Close co-operator with the SAP-team.
- Configuration and maintenance of SAP R/3 primarily regarding FI/CO/COPA/PCA configuration including error tracing, control of setup and defining reports.
- Ad-hoc concerning all tasks in the Group financial department (concerning, interests, stocks, assets, IPC-calculation etc.) - "Final station" for special tasks where data manipulation is needed for specific reporting purposes.

Royal Greenland Insurance Program

2002-02 - 2003-10

Programme setup and daily handling of cases.

Chief Accountant

Pfizer A/S

1998-02 - 1999-03

The position was with direct reference to the CFO.
Achievements: Implementation of new ERP system.
As Chief Accountant at Pfizer A/S my responsibilities were; - Daily management of finance department.
- Responsible for implementing and the daily administration of new integrated ERP system.
- Responsible for group reporting to parent company.
- Monthly internal accounting reporting and deviation analysis on sales and costs.
- Responsible for internal procedures and guidelines.
- Budgeting; sales-, personnel-, cash flow budgets and controlling of these.
- Maintenance and enhancing the company reporting systems.
- Participate in the strategic work of the company.
- Personnel responsibilities for 4 persons.
- Participate in the work for the Year End accounts.
Job description - Division Controller Catalyst division Haldor Topsøe A/S, The Division Controller has the responsibility for the total financial controlling in the largest division of the company. The division is a combined production- and a sales unit.
Tasks in headlines; ● Accounting reporting, deviation analysts concerning production, sales and costs ● Budgeting, production-, sales-, personnel-, currency-, cash flow budgets and controlling on these.
● Investment analysts ● Project controlling ● Coordination of communication of financial issues with other divisions in the company ● Maintenance and enhancing the divisional reporting systems.
● Participate in the strategic work of the division.
● Personnel responsibilities for 1 person Participation with the work for the companies Year End accounts, the group budget and with investment analyses at Group level.

Division Controller

Service Division Brüel & Kjær A/S

1995-03 - 1995-12

The position was with direct reference to the Division Director.
Purpose: To ensure an accurate financial controlling and efficient administrative processes for the division management and the area of operation.
Responsibilities: The function is responsible for the economical controlling, the budgeting, and the reporting of the division, both internally in the division and to B&K Holding.
The responsibility covers the economical controlling guidelines for budgeting and the reporting and communication of these.
In addition to the above it is the responsibility of the function that the administrative procedures of the division and the cooperation with Production and Logistics are satisfactory for both the division and for Brüel & Kjær.
Furthermore, the controller has the operational responsibility for ensuring that the sales subsidiaries fulfil the agreed agreements concerning resource allocation and on pricing.
Tasks: ● Development of and maintenance of the necessary tools for controlling including; o Budget- and controlling models/procedures.
o Analyses of cost competitiveness.
o Methods for calculation of payback of investments.
o Price calculations.
● Collection of external economical information for the budget.
● Economical controlling and reporting including; o In cooperation with other divisional employees to evaluate the profitability of investments and process alternatives and the profitability of existing, new products and development projects.
o Represent the division when teaming up with the Group financial department in B&K Holding.
● Counselling to the division management on the possibilities for improving workflow / - processes.
● Monthly and quarterly reporting of the performance of the sales subsidiaries.
● Ensure and assisting in development of plans and decision documentation for tasks defined by the division management and follow-up on the same.

leader Group economy

Group economy

1992-12 - 1995-03

The position was with direct reference to the Group CFO.
Tasks: ● Monthly Group accounts.
● Year End Group accounts (internal accounts).
● Group budgets.
● Sale figures for the Interdan group.
● Internal monthly accounts for Interdan and for 3 subsidiaries.
● Daily management of finance department with 2 assistants and 1 trainee.
● Responsible for salary system for Interdan A/S and 3 subsidiaries in a in-house system.
● Assisting subsidiaries with their budgeting process and actual closing of monthly accounts for several subsidiaries.
● Ad-hoc tasks concerning accounting issues, both at Group and subsidiary level.
● Development of a completely integrated reporting system for the Interdan Group ● Advising for the Interdan Group on EDP concerning purchasing of and development strategies. This also included close contact with suppliers.
● Administration of a local area network (LAN) including education of the users at Interdan and 3 subsidiaries.

Group economy assistant

Thrige Agro A/S

1988-11 - 1992-12

The position was with direct reference to the Group CFO.
Job description as Group economy assistant Thrige Agro A/S ● Monthly Group accounts.
● Year End Group accounts (both internal and external accounts).
● Group budgets.
● Sales figures for the TA Group ● Including reporting to a Parent Company of the above.
● Assisting subsidiaries with their budgeting process.
● Ad-hoc tasks concerning accounting figures, both at Group and at subsidiary level.
● Development of reporting packages on PC's, i.e. a completely integrated reporting system for the TA Group.
● Including both implementation and education in the subsidiaries ● Advising for the TA Group on EDP concerning purchasing of and development strategy being a EDP-coordinator for the TA Group. This also included close contact with suppliers.
● Test and development of the EDP in the TA Group, including building EDP-communication between the companies. Exploration of the possibilities of the implementation of having one integrated cross border General Ledger system for the Group.
● Building and administering a local area network (LAN) including education of the users.

Senior Consultant

Taidot (40)

Työkokemus

Koulutus

Ota yhteyttä konsulttiin