It looks like you are in United States. Would you like to go to https://onsiter.com/us/ instead?
Kan vara tillgänglig
(Uppdaterat 2020-06-01)Data Management Consultant
Malmö, Sverige
Modersmål Bokmål, Svenska, English, Mellan Danish
- SQL Server
- Oracle
- Infomatica PowerCenter
Kompetenser (22)
Data Migration
INFORMATICA POWERCENTER
Microsoft SQL Server
MDM
MS SQL Server
SQL
SQL Server
DATA SERVICES
METADATA
Oracle
ORACLE 10G
EMPLOYEE RESOURCE GROUP
RETAIL SALES
CUSTOMER SERVICE
MySQL
CUSTOMER SERVICE ORIENTED
REALTIME
INDUSTRIAL ENGINEERING
ERP
FORECASTING
BUDGETING
CUSTOMER RELATIONS
Professionell bakgrund
Period of employment
Information Quality Sweden AB
2016-01 - Pågående
Consultant
Frebera AB
2014-01 - 2016-01
Informatica and SAP BO developer
2014-10 - 2015-03
Time period 2014-10 - 2015-03
Description Informatica PowerCenter, SAP BO, Data Warehousing
DSB wanted to increase the capacity of its data warehouse team.
Fredrik acted as Informatica and SAP BO developer in various smaller
data warehouse projects. He mostly worked with solutions related to customer relations and train workshop performance.
Customer benefits
Role ETL-developer, Report designer, Architect
Tools/methodology Informatica PowerCenter, Microsoft SQL Server, SAP Business Objects
WEBI, SAP Business Objects Universe Designer
Customer PostNord - Customer Master - MDM
Description Informatica PowerCenter, SAP BO, Data Warehousing
DSB wanted to increase the capacity of its data warehouse team.
Fredrik acted as Informatica and SAP BO developer in various smaller
data warehouse projects. He mostly worked with solutions related to customer relations and train workshop performance.
Customer benefits
Role ETL-developer, Report designer, Architect
Tools/methodology Informatica PowerCenter, Microsoft SQL Server, SAP Business Objects
WEBI, SAP Business Objects Universe Designer
Customer PostNord - Customer Master - MDM
Consultant Profile
2012-12 - 2014-06
http://www.infoq.se/
2020-06-01
Description Informatica PowerCenter, Data Migration, Master Data
Management, Data Quality
PostNord wanted to create an MDM solution for customers. The
project involved creating integrations with systems such as SAP ERP,
SAP BW and Salesforce. Unlike the previous project at PostNord, this
project had data quality as one of the primary components in the solution.
Fredrik acted as team leader for the PowerCenter team. He was
tasked with designing and implementing the solution.
Customer benefits
Role ETL-developer, Architect, Team leader
Tools/methodology Informatica PowerCenter, Informatica realtime (JMS), Informatica
Data Quality, Microsoft SQL Server, XML
Consultant Profile
http://www.infoq.se/
2020-06-01
Customer PostNord - Business Location Master - MDM
Time period 2012-04 - 2012-12
Description Informatica PowerCenter development, Data Migration, Master
Data Management
PostNord wanted to create an MDM solution for business locations.
As a part of the solution, PostNord requested that business location
data should be migrated from existing PostNord systems into the new
Business Location Master (BLOM).
Fredrik acted as team leader for the PowerCenter team. He was
tasked with designing and implementing a solution for the migration
jobs.
Customer benefits
Role ETL-developer, Architect, Team leader
Tools/methodology Informatica PowerCenter, Oracle 10g
2020-06-01
Description Informatica PowerCenter, Data Migration, Master Data
Management, Data Quality
PostNord wanted to create an MDM solution for customers. The
project involved creating integrations with systems such as SAP ERP,
SAP BW and Salesforce. Unlike the previous project at PostNord, this
project had data quality as one of the primary components in the solution.
Fredrik acted as team leader for the PowerCenter team. He was
tasked with designing and implementing the solution.
Customer benefits
Role ETL-developer, Architect, Team leader
Tools/methodology Informatica PowerCenter, Informatica realtime (JMS), Informatica
Data Quality, Microsoft SQL Server, XML
Consultant Profile
http://www.infoq.se/
2020-06-01
Customer PostNord - Business Location Master - MDM
Time period 2012-04 - 2012-12
Description Informatica PowerCenter development, Data Migration, Master
Data Management
PostNord wanted to create an MDM solution for business locations.
As a part of the solution, PostNord requested that business location
data should be migrated from existing PostNord systems into the new
Business Location Master (BLOM).
Fredrik acted as team leader for the PowerCenter team. He was
tasked with designing and implementing a solution for the migration
jobs.
Customer benefits
Role ETL-developer, Architect, Team leader
Tools/methodology Informatica PowerCenter, Oracle 10g
Consultant
ETL Solutions AB
2013-01 - 2014-01
Consultant
ETL Solutions AB
2012-01 - 2013-01
Customer Service Level
2011-10 - 2012-03
Description SAP BO Data Services development, Data Warehousing
Gambro wanted to bring orders and deliveries into the data
warehouse. These could then be compared in order to quantify
performance.
The task included acquiring data from various regional Gambro
divisions. The data resided in different forms depending on region.
These were: SAP/R3, SAP BW, Oracle 10g and MySQL.
Fredrik's task was to design and implement a solution that would
extract the data on a regular basis, transform it and then load it into
data marts.
Customer benefits
Role ETL-developer, Architect
Tools/methodology SAP BO Data Services, Microsoft SQL Server, SAP/R3, SAP BW
Consultant Profile
http://www.infoq.se/
2020-06-01
Customer Gambro - LSS - DWH
Time period 2011-09 - 2012-01
Description SAP BO Data Services development, Data Warehousing
Gambro wanted to create a data warehouse solution. Gambro as a
company is divided into several highly autonomous regional divisions.
This made global reporting difficult. At the time, most such reporting
was being done manually.
Fredrik's task was to design and create a data warehouse solution at Gambro. Inventory data (called LSS data at Gambro) was selected as the candidate for the first data marts.
The task included acquiring data from several different Gambro
regions, running their own systems and databases: SAP/R3, SAP BW,
Oracle 10g and MySQL
The task also included setting up various data warehousing related
items, such as naming conventions, best practices, logs, metadata etc.
Customer benefits
Role ETL-developer, Architect
Tools/methodology SAP BO Data Services, Microsoft SQL Server, SAP/R3, SAP BW
Consultant Profile
http://www.infoq.se/
2020-06-01
Gambro wanted to bring orders and deliveries into the data
warehouse. These could then be compared in order to quantify
performance.
The task included acquiring data from various regional Gambro
divisions. The data resided in different forms depending on region.
These were: SAP/R3, SAP BW, Oracle 10g and MySQL.
Fredrik's task was to design and implement a solution that would
extract the data on a regular basis, transform it and then load it into
data marts.
Customer benefits
Role ETL-developer, Architect
Tools/methodology SAP BO Data Services, Microsoft SQL Server, SAP/R3, SAP BW
Consultant Profile
http://www.infoq.se/
2020-06-01
Customer Gambro - LSS - DWH
Time period 2011-09 - 2012-01
Description SAP BO Data Services development, Data Warehousing
Gambro wanted to create a data warehouse solution. Gambro as a
company is divided into several highly autonomous regional divisions.
This made global reporting difficult. At the time, most such reporting
was being done manually.
Fredrik's task was to design and create a data warehouse solution at Gambro. Inventory data (called LSS data at Gambro) was selected as the candidate for the first data marts.
The task included acquiring data from several different Gambro
regions, running their own systems and databases: SAP/R3, SAP BW,
Oracle 10g and MySQL
The task also included setting up various data warehousing related
items, such as naming conventions, best practices, logs, metadata etc.
Customer benefits
Role ETL-developer, Architect
Tools/methodology SAP BO Data Services, Microsoft SQL Server, SAP/R3, SAP BW
Consultant Profile
http://www.infoq.se/
2020-06-01
Consultant
Affecto Sweden AB
2011-01 - 2012-01
ETL-developer, Data Quality developer, Architect
Port State Control - DWH
2011-08 - 2011-10
DQ
Time period 2011-08- 2011-10
Description Informatica PowerCenter development, Data Warehousing, Data
Quality
DNV wanted to bring data regarding port inspections into the data
warehouse. Each time a ship enters a port, there is a certain chance
that the port authorities will perform an inspection and possibly
detain the ship. DNV wanted to know more about the behavior of the different port authorities of the ports that their certified ships visit.
The main challenge was that data quality of the files delivered from the data provider was poor.
Fredrik's task was to design and implement a data quality solution.
This meant creating algorithms for fuzzy matching, as well as setting
up reference tables and procedures for manual correction.
Customer benefits
Role ETL-developer, Data Quality developer, Architect
Tools/methodology Informatica PowerCenter, Informatica Data Quality, Microsoft SQL
Server
Time period 2011-08- 2011-10
Description Informatica PowerCenter development, Data Warehousing, Data
Quality
DNV wanted to bring data regarding port inspections into the data
warehouse. Each time a ship enters a port, there is a certain chance
that the port authorities will perform an inspection and possibly
detain the ship. DNV wanted to know more about the behavior of the different port authorities of the ports that their certified ships visit.
The main challenge was that data quality of the files delivered from the data provider was poor.
Fredrik's task was to design and implement a data quality solution.
This meant creating algorithms for fuzzy matching, as well as setting
up reference tables and procedures for manual correction.
Customer benefits
Role ETL-developer, Data Quality developer, Architect
Tools/methodology Informatica PowerCenter, Informatica Data Quality, Microsoft SQL
Server
ETL-developer
Det Norske Veritas
2011-05 - 2011-09
Budgeting and forecasting - DWH
Time period 2011-05 - 2011-09
Description Informatica PowerCenter development, Data Warehousing
DNV had to remake its budgeting and forecasting data warehousing
solution. This was due to the fact that the old budgeting and forecasting system was being replaced with Cognos Planning.
Fredrik's task was to develop new ETL suited to Cognos Planning.
Customer benefits
Role ETL-developer
Tools/methodology Informatica PowerCenter, Microsoft SQL Server
Consultant Profile
http://www.infoq.se/
2020-06-01
Time period 2011-05 - 2011-09
Description Informatica PowerCenter development, Data Warehousing
DNV had to remake its budgeting and forecasting data warehousing
solution. This was due to the fact that the old budgeting and forecasting system was being replaced with Cognos Planning.
Fredrik's task was to develop new ETL suited to Cognos Planning.
Customer benefits
Role ETL-developer
Tools/methodology Informatica PowerCenter, Microsoft SQL Server
Consultant Profile
http://www.infoq.se/
2020-06-01
Analyst, ETL-developer
Det Norske Veritas
2011-03 - 2011-04
NPS upgrade - DWH
Time period 2011-03 - 2011-04
Description Informatica PowerCenter development, Impact Analysis, Data
Warehousing
DNV wanted to prepare the data warehouse for an upgrade of one of
DNV's most important systems, NPS. NPS is a system that is used to handle data about ships. NPS is also used as a source system for many of the data warehousing solutions at DNV.
Fredrik's task was to investigate the impact on the data warehouse in regards to the upcoming NPS upgrade. It was also his task to perform or delegate necessary changes that had to be made to the ETL.
Customer benefits
Role Analyst, ETL-developer
Tools/methodology Informatica PowerCenter, Microsoft SQL Server
Customer Norges Automobilforbund - KOS - DQ
Time period 2010-11 - 2011-01
Description Informatica Data Quality development, Informatica PowerCenter
development, Master Data Management
NAF wanted to create a solution that could protect its customer
master, KOS, from poor data quality.
Fredrik's task was to design and implement a solution. The idea was to restrict access to KOS by forcing all changes to be made through a
web service interface. The web service would then pass the data to
Informatica Data Quality that would then ensure that the data quality
was sufficient before letting the data reach KOS.
Customer benefits
Role Data Quality developer, ETL-developer
Tools/methodology Informatica PowerCenter, Informatica Data Quality, Informatica
PowerCenter Web Services, Microsoft SQL Server
Consultant Profile
http://www.infoq.se/
2020-06-01
Customer Lindorff - Basel II - DQ
Time period 2010-10 - 2010-12
Description Informatica Data Quality development
Lindorff wanted a review of the data quality of data that is delivered to its customers. The customers, mostly banks, use this data in their
financial models. It is very important that the input to these models is
correct, or the customers could find themselves breaking Basel II
rules.
Fredrik's task was to find possible errors in the data that was being
delivered to Lindorff's customers.
Customer benefits
Role Data Quality developer, Analyst
Tools/methodology Informatica Data Quality, Microsoft SQL Server
Customer Hafslund - DQ
Time period 2010-10 - 2010-12
Description Informatica Data Quality development
Hafslund wanted to assess the data quality of its data regarding
power measuring devices. The company had planned on replacing
550 000 such devices in 2014. They wanted to know if the data quality
of the data regarding these devices was good enough to enable
automatic generation of work orders that could then be distributed to its subcontractors.
Fredrik's task was to perform an analysis with the purpose of identifying missing and erroneous data.
Customer benefits
Role Data Quality developer, Analyst
Tools/methodology Informatica Data Quality, MySQL
Consultant Profile
http://www.infoq.se/
2020-06-01
Time period 2011-03 - 2011-04
Description Informatica PowerCenter development, Impact Analysis, Data
Warehousing
DNV wanted to prepare the data warehouse for an upgrade of one of
DNV's most important systems, NPS. NPS is a system that is used to handle data about ships. NPS is also used as a source system for many of the data warehousing solutions at DNV.
Fredrik's task was to investigate the impact on the data warehouse in regards to the upcoming NPS upgrade. It was also his task to perform or delegate necessary changes that had to be made to the ETL.
Customer benefits
Role Analyst, ETL-developer
Tools/methodology Informatica PowerCenter, Microsoft SQL Server
Customer Norges Automobilforbund - KOS - DQ
Time period 2010-11 - 2011-01
Description Informatica Data Quality development, Informatica PowerCenter
development, Master Data Management
NAF wanted to create a solution that could protect its customer
master, KOS, from poor data quality.
Fredrik's task was to design and implement a solution. The idea was to restrict access to KOS by forcing all changes to be made through a
web service interface. The web service would then pass the data to
Informatica Data Quality that would then ensure that the data quality
was sufficient before letting the data reach KOS.
Customer benefits
Role Data Quality developer, ETL-developer
Tools/methodology Informatica PowerCenter, Informatica Data Quality, Informatica
PowerCenter Web Services, Microsoft SQL Server
Consultant Profile
http://www.infoq.se/
2020-06-01
Customer Lindorff - Basel II - DQ
Time period 2010-10 - 2010-12
Description Informatica Data Quality development
Lindorff wanted a review of the data quality of data that is delivered to its customers. The customers, mostly banks, use this data in their
financial models. It is very important that the input to these models is
correct, or the customers could find themselves breaking Basel II
rules.
Fredrik's task was to find possible errors in the data that was being
delivered to Lindorff's customers.
Customer benefits
Role Data Quality developer, Analyst
Tools/methodology Informatica Data Quality, Microsoft SQL Server
Customer Hafslund - DQ
Time period 2010-10 - 2010-12
Description Informatica Data Quality development
Hafslund wanted to assess the data quality of its data regarding
power measuring devices. The company had planned on replacing
550 000 such devices in 2014. They wanted to know if the data quality
of the data regarding these devices was good enough to enable
automatic generation of work orders that could then be distributed to its subcontractors.
Fredrik's task was to perform an analysis with the purpose of identifying missing and erroneous data.
Customer benefits
Role Data Quality developer, Analyst
Tools/methodology Informatica Data Quality, MySQL
Consultant Profile
http://www.infoq.se/
2020-06-01
Consultant
Affecto Norway AS
2010-01 - 2011-01
Data Quality developer, Analyst
Telenor - PADDA - DQ
2010-05 - 2010-07
Time period 2010-05 - 2010-07
Description Informatica Data Quality development
Telenor wanted to assess the data quality of data regarding the
locations of mobile phone related equipment, such as receivers and transmitters. The purpose was to prepare this data for migration to a
new system.
Fredrik's task was to perform an analysis with the purpose of identifying missing and erroneous data.
Customer benefits
Role Data Quality developer, Analyst
Tools/methodology Informatica Data Quality, MySQL
Employer Capio Citykliniken - various - ASP.NET/C#
Time period 2009-03 - 2009-12
Description ASP.NET/C# development, Legacy development
Capio Citykliniken wanted a series of applications.
Fredrik spent his time at Capio Citykliniken developing various
applications. This meant developing several websites for the intranet, as well as applications for its legacy booking/journal system.
Customer benefits
Role ASP.NET/C# developer, OpenInsight Revelation developer, Architect
Tools/methodology ASP.NET/C#, Microsoft SQL Server, Javascript, JQuery, OpenInsight
Revelation
Consultant Profile
http://www.infoq.se/
2020-06-01
Employer Erisma - service reports - ASP.NET/C#
Description Informatica Data Quality development
Telenor wanted to assess the data quality of data regarding the
locations of mobile phone related equipment, such as receivers and transmitters. The purpose was to prepare this data for migration to a
new system.
Fredrik's task was to perform an analysis with the purpose of identifying missing and erroneous data.
Customer benefits
Role Data Quality developer, Analyst
Tools/methodology Informatica Data Quality, MySQL
Employer Capio Citykliniken - various - ASP.NET/C#
Time period 2009-03 - 2009-12
Description ASP.NET/C# development, Legacy development
Capio Citykliniken wanted a series of applications.
Fredrik spent his time at Capio Citykliniken developing various
applications. This meant developing several websites for the intranet, as well as applications for its legacy booking/journal system.
Customer benefits
Role ASP.NET/C# developer, OpenInsight Revelation developer, Architect
Tools/methodology ASP.NET/C#, Microsoft SQL Server, Javascript, JQuery, OpenInsight
Revelation
Consultant Profile
http://www.infoq.se/
2020-06-01
Employer Erisma - service reports - ASP.NET/C#
Capio Citykliniken AB
2009-01 - 2010-01
ASP.NET/C# developer
Erisma's UppdragNu
2008-08 - 2008-09
Time period 2008-08 - 2008-09
Description ASP.NET/C# development
Climat80 wanted a website where its customers could view its service
reports. Since Climat80 was using Erisma's UppdragNu (now called Mobigo), these reports could be fetched from UppdragNu and then
simply made available through a website.
Fredrik's task was to create the necessary connections to UppdragNu and then design and implement the website.
Customer benefits
Role ASP.NET/C# developer
Tools/methodology ASP.NET/C#, Microsoft SQL Server, Javascript, JQuery
Description ASP.NET/C# development
Climat80 wanted a website where its customers could view its service
reports. Since Climat80 was using Erisma's UppdragNu (now called Mobigo), these reports could be fetched from UppdragNu and then
simply made available through a website.
Fredrik's task was to create the necessary connections to UppdragNu and then design and implement the website.
Customer benefits
Role ASP.NET/C# developer
Tools/methodology ASP.NET/C#, Microsoft SQL Server, Javascript, JQuery
Consultant
Academic Work AB
2007-01 - 2008-01
Consultant Profile
http://www.infoq.se/
2020-06-01
Reference projects and assignments, Details
Customer PostNord - Geographical Information Master - MDM
Time period 2016-10 - 2020-06-01
Description Informatica PowerCenter, Master Data Management
PostNord wanted to create an MDM solution for geographical
information.
Fredrik was responsible for information/data modelling and building
ETL workflows.
Customer benefits
Role ETL-developer, Architect
Tools/methodology Informatica PowerCenter, Oracle 11g/12c, PowerShell, XML
Customer PostNord - Address Master - MDM
Time period 2015-04 - 2018-06
Description Informatica PowerCenter, Master Data Management
PostNord wanted to create an MDM solution for addresses, parties and recipients.
Fredrik was responsible for information/data modelling and building
ETL workflows.
Customer benefits
Role ETL-developer, Architect
Tools/methodology Informatica PowerCenter, Oracle 10g
Customer Danske Statsbaner - Data warehouse
http://www.infoq.se/
2020-06-01
Reference projects and assignments, Details
Customer PostNord - Geographical Information Master - MDM
Time period 2016-10 - 2020-06-01
Description Informatica PowerCenter, Master Data Management
PostNord wanted to create an MDM solution for geographical
information.
Fredrik was responsible for information/data modelling and building
ETL workflows.
Customer benefits
Role ETL-developer, Architect
Tools/methodology Informatica PowerCenter, Oracle 11g/12c, PowerShell, XML
Customer PostNord - Address Master - MDM
Time period 2015-04 - 2018-06
Description Informatica PowerCenter, Master Data Management
PostNord wanted to create an MDM solution for addresses, parties and recipients.
Fredrik was responsible for information/data modelling and building
ETL workflows.
Customer benefits
Role ETL-developer, Architect
Tools/methodology Informatica PowerCenter, Oracle 10g
Customer Danske Statsbaner - Data warehouse
Akademisk bakgrund
Master of Science in Computer
Lund University
2020-06 - 2009-01