It looks like you are in United States. Would you like to go to https://onsiter.com/us/ instead?
Kan være tilgængelig
(Opdateret 2023-02-06)Senior BI Consultant
Helsinge, Denmark
Modersmål Danish, English, Flydende Svenska, Øvet Norwegian, German
- +15 år med MS SQL , SAP BW/BO,
- +10 år med SSIS, SAP BODS
- +5 år med SAP ERP
Kvalifikationer (57)
MAPPING
Business Intelligence
BI
STORED PROCEDURES
PL/SQL
Data Analysis
SQL
Business Analysis
DATA SERVICES
FINANCIALS
ORACLE 10
BUSINESS REQUIREMENTS
TRANSACTIONAL DATA
ORACLE 11
Excel
FINANCIAL REPORTING
Risk Management
DBMS
MICROSOFT OFFICE
MARKETING ANALYSIS
REPLICATION
Project Management
Data Migration
MS EXCEL
SAP BW
SCHEDULING
Office 365
MICROSOFT POWERPOINT
INSTRUCTOR
ERP
DOCUMENTATION
TRADING
FINANCIAL SERVICES
MANAGING PROJECTS
OFFSHORE
SQL Server
TEACHING
Microsoft Office 365
MS SQL Server
SALES MANAGER
BUSINESS DEVELOPMENT
Oracle
SAP BODS
FINANCIAL MANAGEMENT
ORGANIZATIONAL DEVELOPMENT
Hadoop
Python
DB2
Microsoft Access
SYBASE
ORACLE 8
SAS
DATABASE
Access 97
Change Management
MICROSOFT EXCEL
SAP S 4/HANA
Professionel erfaring
Deployment Manager - Senior Consultant
Ministry of Education
2021-04 - Nuværende
* Managing load and deployment in a Data Warehouse (DWH) environment involves overseeing the process of moving data from various sources into the DWH, as well as ensuring that the data is properly loaded and integrated into the DWH structure.
* Developing or optimizing workflows for monthly flows in a DWH environment. The goal is to automate and optimize these processes, so that they can be executed efficiently and with minimal errors.
* Validating data during load is an important step in the data loading process. It involves checking the data for accuracy and completeness before it is loaded into the DWH.
* Creating Stored Procedures.
* Modelling the new table structure in a DWH involves the process of designing and defining the schema and layout of the tables within the DWH.
Tools: SQL Server 2019, MS SSIS, AZUR, GIT, Visual Studio 2019, PowerShell, Power BI, MS Excel, Teams, Share Points, Confluence, Jira
* Developing or optimizing workflows for monthly flows in a DWH environment. The goal is to automate and optimize these processes, so that they can be executed efficiently and with minimal errors.
* Validating data during load is an important step in the data loading process. It involves checking the data for accuracy and completeness before it is loaded into the DWH.
* Creating Stored Procedures.
* Modelling the new table structure in a DWH involves the process of designing and defining the schema and layout of the tables within the DWH.
Tools: SQL Server 2019, MS SSIS, AZUR, GIT, Visual Studio 2019, PowerShell, Power BI, MS Excel, Teams, Share Points, Confluence, Jira
Senior ETL
Udviklings- og Forenklingsstyrelsen, Education Ministry, DK
2020-11 - 2021-03
* Develop new optimized workflows for the year ending and the daily update of results.
* Develop an optimized automatic load of FTP-files from vendor.
* Validating data during load.
* Altering the SQL-server to run RLV or Parallel-loads for quicker load.
* Modelling the new table structure in DWH.
Tools: SAP ASE & IQ, SQL Server, Informatica PowerCenter, Python3.9.1, VS Code, GIT, MS Excel, Team, Share Points
* Develop an optimized automatic load of FTP-files from vendor.
* Validating data during load.
* Altering the SQL-server to run RLV or Parallel-loads for quicker load.
* Modelling the new table structure in DWH.
Tools: SAP ASE & IQ, SQL Server, Informatica PowerCenter, Python3.9.1, VS Code, GIT, MS Excel, Team, Share Points
Senior BI
Siemens Gamesa, Offshore, DK
2019-10 - 2020-07
* Develop Project Quotation Tool for Financial Services * Examine/mapping PQ Tool to PROseg * Map fields from Quotation Tabs - PROseq calculation for loading into SAP * Updating the new structure of WBS and PQ Tool including formula's etc.
* Handling Skype meetings with Business departments i.e., Tender Manager, CNS, Cost including Sales.
* Modelling the new table structure.
Tools: SAP S/4Hana, SQL Server, MS Excel, VBA, SharePoint Lists, HP, Oracle, Agile
* Handling Skype meetings with Business departments i.e., Tender Manager, CNS, Cost including Sales.
* Modelling the new table structure.
Tools: SAP S/4Hana, SQL Server, MS Excel, VBA, SharePoint Lists, HP, Oracle, Agile
Team Lead/Senior BI Consultant
VW Financial Services
2019-02 - 2019-07
* Modelling/Develop SAP BO Universes for Financial Services * Examine Composite- and Info-Provider * Map fields from SAP S4/ HANA/BW - SAP BO Universe from new DataMart Tools: SAP S/4HANA, SAP BW, SAP BODS, SAP BO, SAP IDS, Eclipse, Jira, HP, Oracle, Agile
Senior BA Consultant
BI Intelligence
2018-08 - 2019-01
* Examine the Data for a new Document handling Database * Modelling/Creating the DBMS for the Database Tools: SQL Server 2016, SQL Server Management Studio
Senior Lead for BI Optimization
Danfoss FL
2018-05 - 2018-08
* Examine and give optimization solutions on all the technical parts of the Master Data Migration (MDM) and Master Data Governance (MDG) of On ERP Project. (PP, QM, MM, BOM, SD, FI, CO etc.) * Examine SAP BO Data Services WF/DF / Information Steward * Examine LSMW/BAPI/I-Doc * Examine Interfaces Tools: SAP S/4HANA, SAP MDG, SAP Data Services (BODS) & SAP Information Steward, SAP Solution Manager, DRD's Reports
Senior BI Analyst
RSJ
2018-04 - 2018-06
* Modelling the Architecture of DWH * Design the Data Report and Dashboards in Power BI Tools: Pentaho ETL, Enterprise Architect EA, MS Power BI, MS Sql Server Management Studio, MS SQL Server
SPOC-and Senior BI Analyst
TRYG
2017-09 - 2018-03
* Analyzing the Insurance Data for the new Back-end Platform * Supporting the creation and execution of SIT and UAT * Communicating with Stakeholders on-shore and off-shore * Creating Workshops Tools: Oracle SOA, IBM IIB, Soap UI, Informatica PowerCenter, SharePoint, MS Sql Server, Scrum, Agile
Senior BI Architect
Swiss-Re
2017-04 - 2017-08
* Modelling the design for the MDM architectural plan over Orchestra Networks EBX5 for SAP HANA.
* Data analysis on MDM and MDG for SAP BW SAP 4HANA on MS Azure * Communicating with Stakeholders on-shore and off-shore * User Cases Tools: PowerPoint, SAP BW, SAP MDG, SAP S/4HANA, EBX5., Agile
* Data analysis on MDM and MDG for SAP BW SAP 4HANA on MS Azure * Communicating with Stakeholders on-shore and off-shore * User Cases Tools: PowerPoint, SAP BW, SAP MDG, SAP S/4HANA, EBX5., Agile
Senior BI/BW & SAP Data Services Consultant
Deloitte
2017-01 - 2017-03
* Data analysis on MDM data for SAP BW, SAP S/4HANA Azure * SDI replication tasks * Analyzed MDM and Data flows * Developed new global MDM and data Flows in BODS * Altered SAP BO Reports * Communicating with Stakeholders, Work Shops Tools: SAP S/4Hana, SAP BW, SAP BO 4.1, SAP Lumira, SQL-Server 2012/14, SAP Data Services 4.1, SAP Information Steward, Oracle 11
Oracle Developer
Infosys consulting, NL
2016-08 - 2017-01
* SAP BO development of Financial Reporting * Setup the Scheduling and Bursting of Reports * Dynamic recipients.
* Tuning of Server.
* Communicating with Stakeholders Tools: SAP BO Server incl. SAP Lumira, CMC, Crystal reports. Oracle Database.
* Tuning of Server.
* Communicating with Stakeholders Tools: SAP BO Server incl. SAP Lumira, CMC, Crystal reports. Oracle Database.
Senior BI Analyst & Senior SSIS/BODS Consultant
KMD
2016-08 - 2016-12
* Analysis of Master Data Management * Analysis of SAP Data Services, Data Flows.
* Migrating BODS Dataflows to SSIS scripts C#.
Tools: SAP Data Services, BMC Remedy, MS SSIS, MS SSAS, C# .Net, Oracle, Sql Server, Oracle SQL Designer
* Migrating BODS Dataflows to SSIS scripts C#.
Tools: SAP Data Services, BMC Remedy, MS SSIS, MS SSAS, C# .Net, Oracle, Sql Server, Oracle SQL Designer
Senior IT Analyst / Architect
Nordea Liv & Pension
2016-04 - 2016-07
* Analyzed the Master Data Management and Data Flows for Solvency II * Architected the ETL for Solvency II reporting * Automated the ETL for Solvency II Tools: SQL-Server 2012/14 Visual Studio 2012, SSDT BI for SSIS, MS SSAS, Oracle Developer, SQL Management Studio 2014. C# .Net.
Project Manager /Senior IT Architect
SDC A/S
2015-09 - 2016-02
* Analyzed the Data Flows for Core, COREP, FINREP, MFI including AML * Designed the Automated Architectural diagrams for the Management of Master Data Management Flows * Modelling the design for the Database of the Meta Data, Dependencies for the applications and Jobs.
* Designed the Import of data (ETL) for the Data Base Tools: OPC, Tera database, SQL Server 2010, Visio 2010, visual Studio, Excel VBA, Scrum
* Designed the Import of data (ETL) for the Data Base Tools: OPC, Tera database, SQL Server 2010, Visio 2010, visual Studio, Excel VBA, Scrum
Project Manager
Mediplus
2015-01 - 2015-08
Enabled the Reporting on the SAP Business Objects Platform and undertook business analysis of master data management.
Tools: SQL-Server Manager, SAP Business Objects, SAP IP.
Tools: SQL-Server Manager, SAP Business Objects, SAP IP.
Project Manager/Senior Business Intelligence Consultant/System Architect
CSC A/S
2013-12 - 2014-12
* Enabled relocation to the new SAP Business Objects Platform, served as System Architect for the new Data Warehouse and undertook business analysis of master data management.
* Taught SAP BO Enterprise and SAP Crystal Reports 2011.
Tools: SQL-Server Manager, SSIS, SAP Business Objects Enterprise. SAP Crystal Server, Remedy, Agile
* Taught SAP BO Enterprise and SAP Crystal Reports 2011.
Tools: SQL-Server Manager, SSIS, SAP Business Objects Enterprise. SAP Crystal Server, Remedy, Agile
Senior Business Intelligence Consultant
BEC A/S
2014-02 - 2014-06
Accountable for changing Universes to new Standard in Banking, facilitating rollout to multiple banks BIAR and enabling ETL using BODS.
Tools: Toad, Microsoft SQL-Server Manager, SAP Business Objects 4.0, Informatica PowerCenter, Microsoft Visio and Excel
Tools: Toad, Microsoft SQL-Server Manager, SAP Business Objects 4.0, Informatica PowerCenter, Microsoft Visio and Excel
Senior Business Intelligence Consultant/System Architect
Neas Energy
2013-10 - 2014-01
Responsible for silo analyzing CRM data.
Tools: Toad, Microsoft SQL-Server Manager, Green hopper, Microsoft Visio and Altova, Scrum, Agile
Tools: Toad, Microsoft SQL-Server Manager, Green hopper, Microsoft Visio and Altova, Scrum, Agile
Senior Business Intelligence Consultant/System Architect
UPM
2013-04 - 2013-09
Ensured Master data Management and address cleansing in BODS and BOIS, ETL of MDM and SAP CRM, analysis of system architecture and performance and development of industry best practices for apt auditing, analyzing and reporting of involved systems.
Tools: SAP BO CMC, SAP Data Services 4.0, SAP Information Steward 4.1, SAP NetWeaver 7.3, SAP IP, Toad, SQL Server and Oracle, Agile, Scrum
Tools: SAP BO CMC, SAP Data Services 4.0, SAP Information Steward 4.1, SAP NetWeaver 7.3, SAP IP, Toad, SQL Server and Oracle, Agile, Scrum
System Architect, Wholesale
Alimentacio Group
2012-12 - 2013-02
Assessed present system architecture of SAP HANA, SAP BW and SAP BO at the client.
Supermarket chains Suma, Miquel Alimentacio and SPAR.
* Created new system architecture including Hardware for optimal performance.
* Planned the RFP for the new Platform Tools: SAP Business Objects 4.0, SAP BW 7.3, SAP ECC, SAP HANA, Toad, Oracle 11
Supermarket chains Suma, Miquel Alimentacio and SPAR.
* Created new system architecture including Hardware for optimal performance.
* Planned the RFP for the new Platform Tools: SAP Business Objects 4.0, SAP BW 7.3, SAP ECC, SAP HANA, Toad, Oracle 11
Senior Consultant
Copenhagen University
2012-12 - 2012-12
- Dec 2012 * Accountable for fixing OWB Oracle version 10.2 bugs: i.e., Controller, steering installation of Oracle version 11.1 and test environment as well as configuring repositories.
Tools: Oracle 10.2. Oracle 11.1, Oracle OD, IOBIEE, Toad 9.1 and Citrix
Tools: Oracle 10.2. Oracle 11.1, Oracle OD, IOBIEE, Toad 9.1 and Citrix
Senior BI/BO Consultant Work
ERV
2012-10 - 2012-11
Ascertained Business Analysis - Development entailing optimization of SAP Business Object Reports for the insurance market; conducted business analysis of insurance source data and rules of the market.
Tools: SAP Business Objects XI 3.1, SAP Crystal Reports, SQL Management Studio 2008, MS SQL Server and SSRS
Tools: SAP Business Objects XI 3.1, SAP Crystal Reports, SQL Management Studio 2008, MS SQL Server and SSRS
Senior BI/BO Consultant/Project Management
PFA
2012-03 - 2012-10
Instrumental in Business Analysis - Development: Optimization Project - for the pension market; enabled business analysis of pension Master Data Management and rules of the market for the DataStage, Data vault and DataMart.
* Prepared Universes and Reports for a project, facilitated ETL using BODS on SAP CRM data along with documentation and project planning for the Modul I and Modul II.
Tools: SAP Business Objects XI, SAP Business Objects 4.0, SAP Data Services (BODS), SAP NetWeaver, SAP Data Services and SAP Webi including MS Project 2007, Management Studio 2008, Oracle.
* Prepared Universes and Reports for a project, facilitated ETL using BODS on SAP CRM data along with documentation and project planning for the Modul I and Modul II.
Tools: SAP Business Objects XI, SAP Business Objects 4.0, SAP Data Services (BODS), SAP NetWeaver, SAP Data Services and SAP Webi including MS Project 2007, Management Studio 2008, Oracle.
Project Manager
Mediplus
2011-12 - 2012-02
* Ensured optimization and version upgrade as well as tuning and development of MS Reporting Services.
* Responsible for tuning and development of SQL extension.
Tools: Microsoft Excel 2010, Microsoft Project 2007, SAP Business Objects XI, SAP Business Objects Data Services, MS SQL Server, Oracle and Toad
* Responsible for tuning and development of SQL extension.
Tools: Microsoft Excel 2010, Microsoft Project 2007, SAP Business Objects XI, SAP Business Objects Data Services, MS SQL Server, Oracle and Toad
Senior Consultant
Nordea A/S
2011-11 - 2011-12
Generated capital market reports; Generated Risk Management reports; Actively taught staff to be able to use SAP Business Objects XI.
Tools: SAP Business Objects (Info View, Web Intelligence Rich Client, SAP Xcelsius, Oracle 10 and Microsoft Excel 2010
Tools: SAP Business Objects (Info View, Web Intelligence Rich Client, SAP Xcelsius, Oracle 10 and Microsoft Excel 2010
Project Manager/Senior Consultant
Mediplus
2011-03 - 2011-10
Steered optimization and version upgrade of Business Objects system and tuning and development of SAP Business Objects reports and dashboards and SQL extension.
Tools: Microsoft Excel 2010, Microsoft Project 2007, Webi, SAP Business Objects, SAP Data Services, SAP Crystal Reports, SAP Xcelsius, Toad and Oracle 10.
Tools: Microsoft Excel 2010, Microsoft Project 2007, Webi, SAP Business Objects, SAP Data Services, SAP Crystal Reports, SAP Xcelsius, Toad and Oracle 10.
Project Manager
Danske Bank A/S
2010-10 - 2011-02
* Efficiently evaluated change management of the Data Warehouse including MDM for the project comprising of moving of reports and interfaces from DIMA to DC.
* Design and Analyze Data for Simcorp Dimension including Datawarehouse.
Tools: Simcorp Dimension, SAP Business Objects Webi, SAP BW, SAP BO Crystal Reports, Citrix, Toad, Oracle 10. Microsoft Excel 2010, Microsoft Project 2007, The Danish Bank's ITI, Scrum
* Design and Analyze Data for Simcorp Dimension including Datawarehouse.
Tools: Simcorp Dimension, SAP Business Objects Webi, SAP BW, SAP BO Crystal Reports, Citrix, Toad, Oracle 10. Microsoft Excel 2010, Microsoft Project 2007, The Danish Bank's ITI, Scrum
Senior BI Consultant
SDC A/S
2010-01 - 2010-07
Administered a project for company risk valuation of Norwegian and Faeroe Island banks; executed project tasks and managed necessary documentation and user diagnostic manual.
* Administered the Master Data Management of project.
Tools: SAP Business Objects 6.5, XI R2 Webi and Teradata base SAP Business Objects Designer, Universe, Scrum
* Administered the Master Data Management of project.
Tools: SAP Business Objects 6.5, XI R2 Webi and Teradata base SAP Business Objects Designer, Universe, Scrum
Project Manager/Senior Consultant
Mediplus
2008-11 - 2009-11
Formulated report solutions in SAP Business Objects XI R2 and SAP Xcelsius with Dashboards.
Tools: SAP Business Objects XI R2, SAP Crystal Reports 2008, SAP Xcelsius and Oracle Toad 9 10
Tools: SAP Business Objects XI R2, SAP Crystal Reports 2008, SAP Xcelsius and Oracle Toad 9 10
Senior Consultant
KMD A/S
2008-08 - 2008-10
Directed change of SAP Business Objects 6.5 to SAP BO XI R2 Webi and tuning as well as upgrading of reports and development of SAP Business Objects reports in Xcelsius.
* Oversaw upgrading of Universe, tuning and development of SQL statements and ETL using Business Objects Data Integrator.
Tools: SAP Business Objects 6.5 and XI, SAP Business Objects Data Integrator, SAP Business Objects Xcelsius, Business Objects Designer, Universe Builder, Oracle 10, Toad 9, Citrix and SQL Server
* Oversaw upgrading of Universe, tuning and development of SQL statements and ETL using Business Objects Data Integrator.
Tools: SAP Business Objects 6.5 and XI, SAP Business Objects Data Integrator, SAP Business Objects Xcelsius, Business Objects Designer, Universe Builder, Oracle 10, Toad 9, Citrix and SQL Server
Senior Consultant/Teacher
SATAIR A/S
2008-09 - 2008-09
- Sep 2008 * Responsible for teaching in SAP Business Objects XI R2 Level I, II and III.
Tools: SAP Business Objects XI R2, Crystal Reports 2008 and Oracle Toad 9 10
Tools: SAP Business Objects XI R2, Crystal Reports 2008 and Oracle Toad 9 10
Senior Consultant
Nordea A/S
2007-11 - 2008-07
Senior Consultant
Forstædernes Bank A/S
2007-07 - 2007-10
Senior Consultant
Nordea A/S
2007-03 - 2007-06
Project Manager Kaupthing Bank
Iceland Financial Management
2006-09 - 2007-02
Senior Consultant
PKA Financial Management
2006-10 - 2007-01
Use in the Bank Finance Management System
2004-10 - 2006-10
Teacher/Mentor
Skyyr HF
2006-03 - 2006-03
Mar 2006
Chief Consultant/Project Manager
The Danish Army
2003-06 - 2004-10
Chief Consultant/Project Manager
Post Denmark
2003-07 - 2004-08
Senior Consultant/Project Manager
2003-02 - 2004-06
Senior Consultant
The Danish National Police
2003-07 - 2004-02
Senior Consultant
Scandinavian IT Group Denmark A/S
1999-08 - 2003-01
Teacher/Course Writer, Lyngby Uddannelsescenter
Lyngby Educational Centre
1997-10 - 1999-07
Project Manager/Senior Consultant
Mediplus
1998-03 - 1998-11
Project Manager/Teacher
Copenhagen Business College
1998-01 - 1998-10
IT Teacher
Superfoss A/S
1998-03 - 1998-04
Teacher
Ideal Data A/S
1997-03 - 1997-08
Teacher
Dansk Teknologisk Institut
1997-03 - 1997-03
Mar 1997
Sales Manager
Cardiomedic Denmark
1995-06 - 1996-08
Managing Director/Project Manager
High-Tech Medical Ltd
1991-06 - 1994-08
Acting Managing Director
CB-Medico Ltd
1990-03 - 1991-06
Akademisk baggrund
Mefa Education Pharmaceutical High school of Copenhagen
Mefa Education Pharmaceutical High school of Copenhagen
1998-03 - 1998-10
Certificeringer
CSC
CMC