Might be available(Updated 1+ year ago)
Sap Business Intelligence · Data Analyst
Native Danish, Fluent English, Intermediate German
- power bi
- sap bi 10+ års erfaring
- ms sql
Master Data Management
EMPLOYEE RESOURCE GROUP
ENTERPRISE RESOURCE PLANNING
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.
● 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
● MS Power Query, Power BI, MS Access, SQL, visio
2019-01 - Present
2017-01 - 2019-01
Process analysis of data dependencies, SAP MM data restructuring and development of BI validation
reports to ensure high quality of master data.
● 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.
SAP HANA: SAP MM. MS visio, MS Power query, MS Power BI, MS SQL, Sharepoint and Magento
CRM web catalog.
2016-01 - 2018-01
2016-01 - 2017-01
Participation in the preparation of requirement specifications and the selection of ERP supplier (MS Dynamics). Creation of master data overview.
● Strategic inventory data analysis: decentralised vs centralised stock keeping, input to master data
● Master data definition of data extracts, data reference validation tool for migration to MS Dynamics.
● Power BI report development and data analysis.
MS Dynamics, Power BI og MS SQL.
2009-01 - 2016-01
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
● 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.
2012-01 - 2012-01
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
2007-01 - 2009-01
● 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.
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.
2006-01 - 2007-01
hierarchies, internal orders, cost centre, WBS etc.
● 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
● 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.
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.
2007-01 - 2007-01
2004 - Excel VBA-programming, 4 days, 4D-konsulenterne, Copenhagen
2005-01 - 2006-01
analytics. Development of reporting tools.
● 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).
SAP ERP: SD, FICO and queries + infosets (SQ01). SAP BI (frontend): query designer and BEx
analyzer. BasWare invoice solution. MS access and excel-VBA.
2001-01 - 2005-01
Operational controlling and support on production orders, BOMs and routings. Cost calculations on
materials for warehouse, purchase orders and sales orders.
● 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
● Master data validation using metrics developed in SAS.
● SAP-support for the purchase, production and sales departments.
SAP ERP: PP, MM, SD, FICO and queries + infosets (SQ01). SAS and Excel-VBA.
IT - COURSES
2019-11 - 2001-01
2019-11 - 1991-01