It looks like you are in United States. Would you like to go to https://onsiter.com/us/ instead?
Kan vara tillgänglig
(Uppdaterat 1+ år sedan)Sap Business Intelligence · Data Analyst
København, Denmark
Modersmål Danish, Flytande English, Mellan German
- ms sql
- power bi
- sap bi 10+ års erfaring
Kompetenser (43)
Master Data Management
SAP
BUSINESS CONSULTANT
PROCESS ANALYSIS
Data Analysis
DATA VALIDATION
Power BI
Business Intelligence
MS VISIO
WBS
STATISTICS
STANDARD COST
ANALYZER
BUDGET
ADJUSTMENTS
EMPLOYEE RESOURCE GROUP
GOVERNANCE
HANA
FICO
INTEGRATOR
SALES ORDERS
BUDGETS
VISIO
RECONCILIATION
METRICS
DIESEL
ERP
CRM
COST ACCOUNTING
ENTERPRISE RESOURCE PLANNING
MRP
MARKETING ANALYSIS
ABAP
GENERAL LEDGER
WORKFLOW
BUDGETING
ACCOUNTING
BI
INVOICE
INTEGRATION
SAS
PROCESS FLOW
LOGISTICS
Sammanfattning
Economist with a background as a Business Consultant, BI Report Developer, Data Analyst and Production Controller. I have 18 years of SAP ERP knowledge and more than 10 years deep knowledge within technical and practical BI report development. It is particularly in the field of IT, process analysis
combined with business knowledge I have my core competencies e.g. in the use of master data to
strengthen reporting processes.
Used Technologies
● SAP ECC/HANA: FICO, MM, SD, PP, PS / WBS, HR / HCM, queries and infosets (SQ01).
● SAP BO/BI/BW (frontend -very experienced): Query designer, webi and BEx Analyzer. SAP BI/BW
backend (general knowledge): Data workbench (RSA1), process chains, extractors and light ABAP
reading skills.
● MS Power Query, Power BI, MS Access, SQL, visio
Professionell bakgrund
MS Power BI Desktop
2019-01 - Pågående
Data Analyst
UNICEF Global Supply Division
2017-01 - 2019-01
(interim)
Process analysis of data dependencies, SAP MM data restructuring and development of BI validation
reports to ensure high quality of master data.
Responsibilities/Actions Were
● Analysing process flows between departments for Material Master, Finance, Warehouse, Quality and MRP. Setting up meetings, consultancy with business and further focusing on streamlining of processes.
● Data literacy building, warehouse, MRP and SAP MM.
● Identifying master data dependencies, defining rules for governance and validation metrics.
● Development and implementation of validation tools for SAP master data (Power BI, Power Query & SQL).
● Combine MS Power query with flat file data (backend design) to be used in Power BI frontend.
● Implementing magento CRM-platform as replacement for old SAP CRM catalogue.
● SAP HANA upgrade testing, support in data interpretation.
Used Technologies
SAP HANA: SAP MM. MS visio, MS Power query, MS Power BI, MS SQL, Sharepoint and Magento
CRM web catalog.
Process analysis of data dependencies, SAP MM data restructuring and development of BI validation
reports to ensure high quality of master data.
Responsibilities/Actions Were
● Analysing process flows between departments for Material Master, Finance, Warehouse, Quality and MRP. Setting up meetings, consultancy with business and further focusing on streamlining of processes.
● Data literacy building, warehouse, MRP and SAP MM.
● Identifying master data dependencies, defining rules for governance and validation metrics.
● Development and implementation of validation tools for SAP master data (Power BI, Power Query & SQL).
● Combine MS Power query with flat file data (backend design) to be used in Power BI frontend.
● Implementing magento CRM-platform as replacement for old SAP CRM catalogue.
● SAP HANA upgrade testing, support in data interpretation.
Used Technologies
SAP HANA: SAP MM. MS visio, MS Power query, MS Power BI, MS SQL, Sharepoint and Magento
CRM web catalog.
MS Power BI & Power Queries, UNICEF education center
2016-01 - 2018-01
HUB040; SAP Learning Hub, Business User Edition, 1 year, online access
ERP Implementation Consultant
Danish Refugee Council
2016-01 - 2017-01
(interim)
Participation in the preparation of requirement specifications and the selection of ERP supplier (MS Dynamics). Creation of master data overview.
Responsibilities/Actions Were
● Strategic inventory data analysis: decentralised vs centralised stock keeping, input to master data
requirements.
● Master data definition of data extracts, data reference validation tool for migration to MS Dynamics.
● Power BI report development and data analysis.
Used Technologies
MS Dynamics, Power BI og MS SQL.
Participation in the preparation of requirement specifications and the selection of ERP supplier (MS Dynamics). Creation of master data overview.
Responsibilities/Actions Were
● Strategic inventory data analysis: decentralised vs centralised stock keeping, input to master data
requirements.
● Master data definition of data extracts, data reference validation tool for migration to MS Dynamics.
● Power BI report development and data analysis.
Used Technologies
MS Dynamics, Power BI og MS SQL.
Business Consultant, DSB
2009-01 - 2016-01
Optimisation projects between finance and HR areas. SAP BI development of reports and metrics for
number of employees, wage statistics, budgeting of wage costs, validation tool for invoice flow, validation
tool for master data.
����������������������������������������������������������������/���������������������������� ����������������
● BI budget tool for wage costs which encompasses around 3,5 billion DKK for 9.500 employees. BI
development and implementation of reports showing statistics for wage costs.
● FTE-project: SAP BI definition of a multicube, development and implementation of SAP BI-reports for
mayor HR-reporting needs
● Realignment of the HR organisational hierarchy to the cost center hierarchy.
● Development of a report showing the (critical) evaluation paths in the organisational hierarchy for
supporting the approval processes and procuration limits in the invoice workflow.
● Master Data Management, development of ERP- and BI-queries for supporting the Data Governance
process.
● Validation and troubleshooting of SAP ERP and BI authorisations. Process flow analysis for SAP
HANA upgrade and GRC, identification of Separation of Duties.
● Definition of a multicube, development and implementation of BI-reports for user governance and validation of the correct authorisations.
● Reconciliations and definition of controls for data integration from external systems to SAP.
���������������� ������������������������������������������������
SAP ERP: HR/HCM, FICO and queries + infosets (SQ01). SAP BI (frontend -very experienced): Query
designer, WEBi & BEx analyzer. SAP BI (backend -general knowledge): Data workbench (RSA1),
process chains, extractors and light ABAP reading skills. MS visio, MS query & Excel VBA.
number of employees, wage statistics, budgeting of wage costs, validation tool for invoice flow, validation
tool for master data.
����������������������������������������������������������������/���������������������������� ����������������
● BI budget tool for wage costs which encompasses around 3,5 billion DKK for 9.500 employees. BI
development and implementation of reports showing statistics for wage costs.
● FTE-project: SAP BI definition of a multicube, development and implementation of SAP BI-reports for
mayor HR-reporting needs
● Realignment of the HR organisational hierarchy to the cost center hierarchy.
● Development of a report showing the (critical) evaluation paths in the organisational hierarchy for
supporting the approval processes and procuration limits in the invoice workflow.
● Master Data Management, development of ERP- and BI-queries for supporting the Data Governance
process.
● Validation and troubleshooting of SAP ERP and BI authorisations. Process flow analysis for SAP
HANA upgrade and GRC, identification of Separation of Duties.
● Definition of a multicube, development and implementation of BI-reports for user governance and validation of the correct authorisations.
● Reconciliations and definition of controls for data integration from external systems to SAP.
���������������� ������������������������������������������������
SAP ERP: HR/HCM, FICO and queries + infosets (SQ01). SAP BI (frontend -very experienced): Query
designer, WEBi & BEx analyzer. SAP BI (backend -general knowledge): Data workbench (RSA1),
process chains, extractors and light ABAP reading skills. MS visio, MS query & Excel VBA.
SAP BusinessObjects Web Intelligence
2012-01 - 2012-01
1 week, SAP Denmark
2012 - BOW320; SAP BusinessObjects, Advanced Report Design, 1 week, SAP Denmark
2010 - ERP-HR305; HR Master Data Configuration, 1 week, SAP Denmark
2010 - BW305; Enterprise Reporting, Query & Analysis, 1 week, SAP Denmark
2010 - BW310; Enterprise Data Warehousing, 1 week, SAP Denmark
2009 - ERP-BC407; Reporting: QuickViewer, SAP Infoset & Query, 2Cchange
2012 - BOW320; SAP BusinessObjects, Advanced Report Design, 1 week, SAP Denmark
2010 - ERP-HR305; HR Master Data Configuration, 1 week, SAP Denmark
2010 - BW305; Enterprise Reporting, Query & Analysis, 1 week, SAP Denmark
2010 - BW310; Enterprise Data Warehousing, 1 week, SAP Denmark
2009 - ERP-BC407; Reporting: QuickViewer, SAP Infoset & Query, 2Cchange
Implementation, SAP ERP and SAP BI, Project Manager, Würth
Cost and Profit centers
2007-01 - 2009-01
SAP ERP and SAP BI implementation, replacing 4 old ERP systems running on AS400.
Responsibilities/Actions Were
● SAP FICO setting up: Chart of Account - General Ledger, Cost and Profit centers.
● Building P&L, Balance, Cost & Profit centers hierarchies.
● COPA definition of reporting characteristics and value fields.
● Data migration and reconciliation of data from 4 old ERP systems to SAP.
● SAP BI Project Manager and implementation responsible.
● SAP BI frontend: Design and development of the major reporting tools consolidation model, budgeting
tool, sales- and purchase cockpit.
● SAP BI backend development and maintenance: Definition of BI cubes, process chains, uploading + activation of data.
Used Technologies
SAP ERP: FICO, SD and queries + infosets (SQ01). SAP BI (frontend -very experienced): query
designer and BEx analyzer. SAP BI (backend -general knowledge): data workbench (RSA1). Excel-VBA.
Responsibilities/Actions Were
● SAP FICO setting up: Chart of Account - General Ledger, Cost and Profit centers.
● Building P&L, Balance, Cost & Profit centers hierarchies.
● COPA definition of reporting characteristics and value fields.
● Data migration and reconciliation of data from 4 old ERP systems to SAP.
● SAP BI Project Manager and implementation responsible.
● SAP BI frontend: Design and development of the major reporting tools consolidation model, budgeting
tool, sales- and purchase cockpit.
● SAP BI backend development and maintenance: Definition of BI cubes, process chains, uploading + activation of data.
Used Technologies
SAP ERP: FICO, SD and queries + infosets (SQ01). SAP BI (frontend -very experienced): query
designer and BEx analyzer. SAP BI (backend -general knowledge): data workbench (RSA1). Excel-VBA.
Economist
Haldor Topsøe A/S
2006-01 - 2007-01
Monthly reporting. Optimising of reporting tools and processes. Validation of finance master data e.g.
hierarchies, internal orders, cost centre, WBS etc.
Responsibilities/Actions Were
● Periodic reporting, including elimination of intercompany transactions and consolidation. Development
of consolidation model with the use of SAP BI queries and BEx Analyser.
● Evaluation of investment plans, order backlog, allocation of fixed cost and coordination of the budget
process.
● FICO-module definition and validation of cost- & profit centers, internal orders, WBS, assessment / settlement cycles for expenses.
● Development of BI reports and introduction of BEx analyzer workbooks to users.
Used Technologies
SAP ERP: FICO, PS WBS and queries + infosets (SQ01). SAP BI (frontend -very experienced): Query
designer and BEx analyzer. MS access and MS excel-VBA.
hierarchies, internal orders, cost centre, WBS etc.
Responsibilities/Actions Were
● Periodic reporting, including elimination of intercompany transactions and consolidation. Development
of consolidation model with the use of SAP BI queries and BEx Analyser.
● Evaluation of investment plans, order backlog, allocation of fixed cost and coordination of the budget
process.
● FICO-module definition and validation of cost- & profit centers, internal orders, WBS, assessment / settlement cycles for expenses.
● Development of BI reports and introduction of BEx analyzer workbooks to users.
Used Technologies
SAP ERP: FICO, PS WBS and queries + infosets (SQ01). SAP BI (frontend -very experienced): Query
designer and BEx analyzer. MS access and MS excel-VBA.
Project Management
Mannaz
2007-01 - 2007-01
2007 - Management and Organizations of Teams, evening school, 1 term, Uni. of Copenhagen
2004 - Excel VBA-programming, 4 days, 4D-konsulenterne, Copenhagen
2004 - Excel VBA-programming, 4 days, 4D-konsulenterne, Copenhagen
Business Controller
DLG AMBA
2005-01 - 2006-01
Monthly reporting, budgeting and deviation explanations. Support category managers with price
analytics. Development of reporting tools.
Responsibilities/Actions Were
● Consolidation, analysis and commenting on monthly reporting.
● Preparation of budgets in cooperation with the sales organisation.
● Analysis of product prices and support category managers with price updates and trading patterns.
● Development SAP ERP query tool for optimising and validation of sales price conditions.
● SAP projects e.g. BasWare.com (invoice processing solution).
Used Technologies
SAP ERP: SD, FICO and queries + infosets (SQ01). SAP BI (frontend): query designer and BEx
analyzer. BasWare invoice solution. MS access and excel-VBA.
analytics. Development of reporting tools.
Responsibilities/Actions Were
● Consolidation, analysis and commenting on monthly reporting.
● Preparation of budgets in cooperation with the sales organisation.
● Analysis of product prices and support category managers with price updates and trading patterns.
● Development SAP ERP query tool for optimising and validation of sales price conditions.
● SAP projects e.g. BasWare.com (invoice processing solution).
Used Technologies
SAP ERP: SD, FICO and queries + infosets (SQ01). SAP BI (frontend): query designer and BEx
analyzer. BasWare invoice solution. MS access and excel-VBA.
Production Controller, MAN
Diesel A/S
2001-01 - 2005-01
(formerly Burmeister & Wain)
Operational controlling and support on production orders, BOMs and routings. Cost calculations on
materials for warehouse, purchase orders and sales orders.
Responsibilities/Actions Were
● Participated in the development of standard cost accounting, including analysis of variances as well as variance explanations for production and purchase orders.
● Analysis of the development, costing and physical appearance of warehouse inventories.
● Optimisation of organisational processes and workflows using and development of e.g. SAP ERP
queries.
● Master data validation using metrics developed in SAS.
● SAP-support for the purchase, production and sales departments.
Used Technologies
SAP ERP: PP, MM, SD, FICO and queries + infosets (SQ01). SAS and Excel-VBA.
IT - COURSES
Operational controlling and support on production orders, BOMs and routings. Cost calculations on
materials for warehouse, purchase orders and sales orders.
Responsibilities/Actions Were
● Participated in the development of standard cost accounting, including analysis of variances as well as variance explanations for production and purchase orders.
● Analysis of the development, costing and physical appearance of warehouse inventories.
● Optimisation of organisational processes and workflows using and development of e.g. SAP ERP
queries.
● Master data validation using metrics developed in SAS.
● SAP-support for the purchase, production and sales departments.
Used Technologies
SAP ERP: PP, MM, SD, FICO and queries + infosets (SQ01). SAS and Excel-VBA.
IT - COURSES
Akademisk bakgrund
MSc. in Business Administration
Aarhus University
2019-11 - 2001-01
High School, Business College Syd
High School, Business College Syd
2019-11 - 1991-01