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)BI-Konsult
Stockholms län, Sverige
Modersmål Svenska, English
- PowerBI
- Microsoft BI
- SAS BI
Kompetenser (35)
Power BI
SSRS
BI
SSIS
SAS
DATA WAREHOUSES
mdx
dax
Business Intelligence
T-SQL
SSAS
SQL Server
ENTERPRISE RESOURCE PLANNING
TRANSLATE
LIFE INSURANCE
WORD
RETAIL
MICROSOFT POWERPOINT
ERP
POWERPOINT
LOGISTICS
MAINTENANCE
STATISTICS
REBUILD
RED CROSS
TRANSLATING
DATA SOURCES
GENERAL LEDGER
EMPLOYEE RESOURCE GROUP
LOANS
PRICING
Serial Attached SCSI
STAD
ANNUITIES
MICROSOFT WORD
Sammanfattning
KONTAKT
TECHNOLOGY, METHODS, ROLES
Arne has worked with Data Warehousing, Business Intelligence and Analysis since 1992. He's mostly worked with Microsoft products (SSIS, SSRS, SQL Server, SSAS, Power BI and other), but he also has got many years of experience of working with SAS software. He's had roles as developer, analyst, architect, investigator, CRM Designer, information modeller, team leader, web analyst, and project manager. He has many years of experience of customer segmentation, price modelling KPI:s, CRM and market research.
Arne's experience spans from investigating and mapping information requirements, finding the relevant data within the production systems and building Data Warehouses to strategic analysis for upper management. He has vast knowledge of how to enhance analysis, models and reports with external data sources and market research.
He has long experience of translating business needs to terms that are interpretable for IT personnel, but also how to explain the technical possibilities to the business personnel.
Professionell bakgrund
Solver
2018-01 - Pågående
Product owner, project manager
Vattenfall
2019-01 - Pågående
Vattenfall is migrating all of its Qlik View applications to Power BI
PRODUCTS
Visual Studio, Azure Dev Ops, Management studio, Power BI
ERP SYSTEMS / DATA SOURCES
Data from all production systems within Vattenfall is read into the Data Warehouse.
ROLES AND METHODS
Arne's role as a Product owner/project manager was to lead the migration of the Vattenfall Power Production's Qlik View applications to Microsoft Power BI.
PRODUCTS
Visual Studio, Azure Dev Ops, Management studio, Power BI
ERP SYSTEMS / DATA SOURCES
Data from all production systems within Vattenfall is read into the Data Warehouse.
ROLES AND METHODS
Arne's role as a Product owner/project manager was to lead the migration of the Vattenfall Power Production's Qlik View applications to Microsoft Power BI.
DW architect, developer
Postnord
2018-01 - 2019-01
Postnord's Data Warehouse is APS based. It holds most of the data on the shipments processed by Postnord. It is continuously developed.
PRODUCTS
Visual Studio, SQL for APS, Management studio, Microsoft MDS, SSRS, Power BI
ERP SYSTEMS / DATA SOURCES
Data from all production systems within Postnord are read into the Data Warehouse.
ROLES AND METHODS
Arne's role as a DW-architect was to lead the transformation of the technical platform into a Cloud solution and take part in the development process.
PRODUCTS
Visual Studio, SQL for APS, Management studio, Microsoft MDS, SSRS, Power BI
ERP SYSTEMS / DATA SOURCES
Data from all production systems within Postnord are read into the Data Warehouse.
ROLES AND METHODS
Arne's role as a DW-architect was to lead the transformation of the technical platform into a Cloud solution and take part in the development process.
Developer
Elverket i Vallentuna
2015-01 - 2018-01
Elverket I Vallentuna had a Data Warehouse with simulation functionality but they had no inhouse competence to maintain or develop it.
PRODUCTS
SQL Server, SSIS, SSRS, SSAS
ERP SYSTEMS / DATA SOURCES
The production platform and external data.
ROLES AND METHODS
Arne was responsible for maintenance and development of the data warehouse.
PRODUCTS
SQL Server, SSIS, SSRS, SSAS
ERP SYSTEMS / DATA SOURCES
The production platform and external data.
ROLES AND METHODS
Arne was responsible for maintenance and development of the data warehouse.
SENIOR CONSULTANT
ADVANCED ANALYTICS
2015-01 - 2018-01
DW-architect, project manager, DW-developer
Nobina AB
2017-01 - 2018-01
Nobina, a large Swedish bus company, was replacing an older Data Warehouse with a new one. Focus was put on manageability and scalability.
PRODUCTS
SQL Server, Visual Studio, Team Foundation Server, Power BI, SSAS Tabular
ERP SYSTEMS / DATA SOURCES
Nobina had built a business system, OMS, containing 15 subsystems that covered all of their business, except for the general ledger that was managed in Agresso.
ROLES AND METHODS
Arne's role as architect was to design and document the data warehouse and see to that the design was implemented. Very soon Arne also was assigned the roles of project manager and supervisor of the development team.
PRODUCTS
SQL Server, Visual Studio, Team Foundation Server, Power BI, SSAS Tabular
ERP SYSTEMS / DATA SOURCES
Nobina had built a business system, OMS, containing 15 subsystems that covered all of their business, except for the general ledger that was managed in Agresso.
ROLES AND METHODS
Arne's role as architect was to design and document the data warehouse and see to that the design was implemented. Very soon Arne also was assigned the roles of project manager and supervisor of the development team.
Investigator
Catella AB
2018-01 - 2018-01
2018
Catella was to build a new Data Warehouse and ordered a pre-study on how it was to be built and what resources it would require.
PRODUCTS
Word, Visio, Powerpoint
ERP SYSTEMS / DATA SOURCES
Catella has multiple business systems of which most were to be incorporated in the new Data Warehouse.
ROLES AND METHODS
As one of two investigators Arne's role was to map the business' needs, the prerequisites and to produce a pre-study including a proposed technical design of the Data Warehouse.
Catella was to build a new Data Warehouse and ordered a pre-study on how it was to be built and what resources it would require.
PRODUCTS
Word, Visio, Powerpoint
ERP SYSTEMS / DATA SOURCES
Catella has multiple business systems of which most were to be incorporated in the new Data Warehouse.
ROLES AND METHODS
As one of two investigators Arne's role was to map the business' needs, the prerequisites and to produce a pre-study including a proposed technical design of the Data Warehouse.
Investigator, architect, developer, supervisor
Non-profit organisation
2016-01 - 2017-01
The Swedish Red Cross ordered a pre-study on whether it was possible to rebuild their data warehouse to fit their needs. The result was negative why the Red Cross built a new data warehouse.
PRODUCTS
SQL Server, Visual Studio, Team Foundation Server, Power BI
ERP SYSTEMS / DATA SOURCES
A CRM-system and Microsoft Dynamics.
ROLES AND METHODS
Arne made the pre-study and designed the new data warehouse. He was also lead programmer and supervisor of the development team that built the new data warehouse.
PRODUCTS
SQL Server, Visual Studio, Team Foundation Server, Power BI
ERP SYSTEMS / DATA SOURCES
A CRM-system and Microsoft Dynamics.
ROLES AND METHODS
Arne made the pre-study and designed the new data warehouse. He was also lead programmer and supervisor of the development team that built the new data warehouse.
Investigator
H&M
2016-01 - 2016-01
2016
H&M ordered a pre-study on how a data warehouse should be built using the latest available technology as a part of their new Internet strategy and as basis for their future data warehouse designs.
PRODUCTS
Visio, Powerpoint
ERP SYSTEMS / DATA SOURCES
H&M's new sales platform for Internet.
ROLES AND METHODS
As one of two investigators Arne analysed and documented the business needs and requirements and delivered a recommendation regarding the best technical solution.
H&M ordered a pre-study on how a data warehouse should be built using the latest available technology as a part of their new Internet strategy and as basis for their future data warehouse designs.
PRODUCTS
Visio, Powerpoint
ERP SYSTEMS / DATA SOURCES
H&M's new sales platform for Internet.
ROLES AND METHODS
As one of two investigators Arne analysed and documented the business needs and requirements and delivered a recommendation regarding the best technical solution.
data modeller, investigator
Banking&Finance
2016-01 - 2016-01
2016
To gain control of their IT development cost Nordea's IT-department (GFIT) ordered the development of new KPI's called Management Reporting Dashboard.
PRODUCTS
SQL Server
ERP SYSTEMS / DATA SOURCES
The Nordea Data Warehouse
ROLES AND METHODS
Arne was responsible for data modelling, data source analysis, and the quantification of the KPI:s.
To gain control of their IT development cost Nordea's IT-department (GFIT) ordered the development of new KPI's called Management Reporting Dashboard.
PRODUCTS
SQL Server
ERP SYSTEMS / DATA SOURCES
The Nordea Data Warehouse
ROLES AND METHODS
Arne was responsible for data modelling, data source analysis, and the quantification of the KPI:s.
developer, administrator, analyst, CRM-specialist
Bank&Insurance
2013-01 - 2015-01
Skandia had a large central Data Warehouse for CRM, customer base analysis and marketing. It also contained production data and financial data from all of Skandia's insurance systems.
PRODUCTS
SQL Server, SSIS, SSAS, SSAS Tabular, Team Foundation Server
ERP SYSTEMS / DATA SOURCES
All of Skandia's insurance systems, The CRM-system and external data.
ROLES AND METHODS
Arne was responsible for maintenance and development of the data warehouse. He was served as support for Skandia's customer analysis and CRM teams and served as a mediator between the IT-department and the business. From the autumn of 2014 he also had a role as requirements analyst, lead programmer and mediator between departments at Skandia when Skandia started the development of a new data warehouse to replace the by then outdated data warehouse.
SAS
PRODUCTS
SQL Server, SSIS, SSAS, SSAS Tabular, Team Foundation Server
ERP SYSTEMS / DATA SOURCES
All of Skandia's insurance systems, The CRM-system and external data.
ROLES AND METHODS
Arne was responsible for maintenance and development of the data warehouse. He was served as support for Skandia's customer analysis and CRM teams and served as a mediator between the IT-department and the business. From the autumn of 2014 he also had a role as requirements analyst, lead programmer and mediator between departments at Skandia when Skandia started the development of a new data warehouse to replace the by then outdated data warehouse.
SAS
DW-/BI-SPECIALIST
Skandia AB
2013-01 - 2015-01
CONSULTANT
Frontwalker
2013-01 - 2013-01
2013
Municipal administration
Stockholm town
2011-01 - 2013-01
Stockholms stad has a data warehouse that holds information on all of the municipal administration.
PRODUCTS
SQL Server, SSIS, SSAS, SSRS
ERP SYSTEMS / DATA SOURCES
All production systems of Stockholms stad.
ROLLER OCH METODER
Arne was a member of the team that developed and maintained the data warehouse of Stockholm's stad. Arne was also responsible for helping the customer to incorporate BI and analysis to get them get the most possible leverage out of their data warehouse.
SEB
Banking&Insurance
|developer, analyst, customer segmentation specialist,
investigator,CRM-specialist,
marketing intelligence
PRODUCTS
SQL Server, SSIS, SSAS, SSRS
ERP SYSTEMS / DATA SOURCES
All production systems of Stockholms stad.
ROLLER OCH METODER
Arne was a member of the team that developed and maintained the data warehouse of Stockholm's stad. Arne was also responsible for helping the customer to incorporate BI and analysis to get them get the most possible leverage out of their data warehouse.
SEB
Banking&Insurance
|developer, analyst, customer segmentation specialist,
investigator,CRM-specialist,
marketing intelligence
Investigator
Transport&Logistics
2013-01 - 2013-01
Due to a falling profit margin SAS decided to do an evaluation of the ABC-model that they had used for cost allocation and pricing for more than 30 years.
PRODUCTS
SQL Server
ERP SYSTEMS / DATA SOURCES
SAS Data Warehouse
ROLES AND METHODS
Arne was one out of two consultants that made an analysis and mapping of the functionality of the ABC-model and presented an action proposal.
PRODUCTS
SQL Server
ERP SYSTEMS / DATA SOURCES
SAS Data Warehouse
ROLES AND METHODS
Arne was one out of two consultants that made an analysis and mapping of the functionality of the ABC-model and presented an action proposal.
SENIOR CONSULTANT
Visma Consulting
2011-01 - 2013-01
SAS Base 9.2, SAS Enterprise Guide and other SAS products
SEB
2005-01 - 2011-01
had a large SAS based data warehouse that held about 60 percent of the company's data. It was the source of all SEB's customer base analysis, marketing, CRM and other customer communication.
PRODUCTS
SAS Base 9.2, SAS Enterprise Guide and other SAS products for analysis, reporting and statistics.
ERP SYSTEMS / DATA SOURCES
All of SEB's production systems and external data.
ROLES AND METHODS
Arne was supervisor for all assignments regarding life insurance, personal loans and mortgages. He interpreted the needs and requirements of the business and implemented them into the SAS data warehouse. He also worked with analysis, market research and was responsible for the training of junior analysts.
AMF Pension
Insurance
requirements analyst, analyst, customer segmentation specialist,
PRODUCTS
SAS Base 9.2, SAS Enterprise Guide and other SAS products for analysis, reporting and statistics.
ERP SYSTEMS / DATA SOURCES
All of SEB's production systems and external data.
ROLES AND METHODS
Arne was supervisor for all assignments regarding life insurance, personal loans and mortgages. He interpreted the needs and requirements of the business and implemented them into the SAS data warehouse. He also worked with analysis, market research and was responsible for the training of junior analysts.
AMF Pension
Insurance
requirements analyst, analyst, customer segmentation specialist,
SENIOR ANALYST
SEB
2005-01 - 2011-01
investigator, developer, CRM-specialist
Market research
1999-01 - 2005-01
In 1999 AMF Pension started to build their data warehouse. Over the years it came to hold nearly all the company's data regarding insurance policies as well as customer data, customer research data and external data.
PRODUCTS
SQL Server 2000/2005 and analysis and statistics software.
ERP SYSTEMS / DATA SOURCES
All of AMF Pension's production systems and external data.
ROLES AND METHODS
Arne was one out of three that did the pre-study for the data warehouse. He then took part in the development of the data warehouse. When it was in place Arne held the role as Super User and was also responsible for customer base analysis, customer segmentation and marketing research.
Sweden Post
ILogistics
Analyst, customer segmentation,
investigator, developer
market research
PRODUCTS
SQL Server 2000/2005 and analysis and statistics software.
ERP SYSTEMS / DATA SOURCES
All of AMF Pension's production systems and external data.
ROLES AND METHODS
Arne was one out of three that did the pre-study for the data warehouse. He then took part in the development of the data warehouse. When it was in place Arne held the role as Super User and was also responsible for customer base analysis, customer segmentation and marketing research.
Sweden Post
ILogistics
Analyst, customer segmentation,
investigator, developer
market research
SENIOR ANALYST
AMF Pension
1999-01 - 2005-01
Sweden Post
1997-01 - 1999-01
In the late 1990's Sweden Post began to lose business to email services. They set up a team to follow and analyse the long-term consequences.
PRODUCTS
SAS- and SQL-based software.
ERP SYSTEMS / DATA SOURCES
Sweden Post's production systems, market research and external data.
ROLES AND METHODS
Arne was a member of the team. He was also responsible for the maintenance and development of the team's analysis software.
PRODUCTS
SAS- and SQL-based software.
ERP SYSTEMS / DATA SOURCES
Sweden Post's production systems, market research and external data.
ROLES AND METHODS
Arne was a member of the team. He was also responsible for the maintenance and development of the team's analysis software.
MARKET ANALYST
Posten Brev AB
1998-01 - 1999-01
CONTROLLER ADB-TJÄNSTER
Postgirot Bank AB
1996-01 - 1998-01
investigator, requirements analyst, developer
Postgirot Bank AB
1996-01 - 1997-01
In 1996 Postgirot Bank AB didn't have a data warehouse holding their customers and production volumes. At the time they were Sweden's third largest producer of E-services why they decided to build a SAS based data warehouse for customer analysis and pricing.
PRODUCTS
SAS Base and SQL-based software.
ERP SYSTEMS / DATA SOURCES
All production systems within Postgirot Produktion.
ROLES AND METHODS
Arne was responsible for the pre-study, the requirements and ordering of the data warehouse. He also took part as a programmer in the implementation.
PRODUCTS
SAS Base and SQL-based software.
ERP SYSTEMS / DATA SOURCES
All production systems within Postgirot Produktion.
ROLES AND METHODS
Arne was responsible for the pre-study, the requirements and ordering of the data warehouse. He also took part as a programmer in the implementation.
statistician, investigator
UAS
1992-01 - 1996-01
As a large hospital focused on specialist care UAS was totally dependent on the income they got from the patients coming from other regions. At the same time they only had vague indications of how much the treatments cost.
PRODUCTS
SAS Base and SQL-based software.
ERP SYSTEMS / DATA SOURCES
The production systems, the general ledger and the salary system of UAS.
ROLES AND METHODS
Arne's role as a controller was to import data into a SAS based data warehouse that he built to be able to analyse the costs and income generated by the patients coming from other regions.
PRODUCTS
SAS Base and SQL-based software.
ERP SYSTEMS / DATA SOURCES
The production systems, the general ledger and the salary system of UAS.
ROLES AND METHODS
Arne's role as a controller was to import data into a SAS based data warehouse that he built to be able to analyse the costs and income generated by the patients coming from other regions.
CONTROLLER
Uppsala akademiska sjukhus
1992-01 - 1996-01
EMPLOYERS
SENIOR CONSULTANT
AKADEMIC EDUCATION
1987-01 - 1991-01