Datawarehouse Architect København, Danmark

Saattaa olla saatavilla

(Päivitetty 2023-10-23)

Datawarehouse Architect

København, Danmark

Äidinkieli Danish, English, Aloittelija German

  • ETL, Informatica, Datastage
  • MS SQL, DB2, Oracle DB, SAP ASE, SAP IQ
  • Datawarehouse
Ota yhteyttä

Taidot (36)

ETL

DB2

DATASTAGE

Informatica

PowerCenter

MS SQL Server

Data Analysis

MS WORD

Oracle DB

DATAMART

Confidential Data

MORTGAGE

SAP ASE

RECONCILIATION

MICROSOFT WORD

BUSINESS REQUIREMENTS

CUSTOMER SUPPORT

SAP IQ

DOCUMENTATION

Business Intelligence

XML

Power BI

ESTIMATION

STATISTICS

OPC

WORKFLOW

BI

VBA

SCANNING

JSON

MS OFFICE

GENERAL LEDGER

Corporate Finance

API

MICROSOFT OFFICE

Visual Basic

Yhteenveto

I am a technically oriented person, with a drive for making data
valuable for the Business. I like the double aspect of the data
warehouse environments, the fact that data needs to be handled in
one way for the environments to perform well, and at the end, having
the Business requirements as the ultimate goal.

I'm highly motivated seing the solution having a beneficial outcome for
the Business side aswell as seing a solution that works well when
delivered to the maintenance department after the project work has
finished.

I have worked In most areas of the development lifecycle, and tend to
be the one working with the business side, working on data analysis
and data investigation, at the end of the project.

Over the 20 years I've been in the industry, I have gained a lot of
experience in many aspects. Learning the vital need for respect of
everyone involved, and the importance for clear communications and
quality throughout the full lifecycle. Time has also showed me, that
different people and units, sees things differently, and to always have
that in mind.

Työkokemus

AIX and data warehouse consultant
SDC

2021-11 - 2023-10

SDC have replaced most of their old data warehouse to a new EDW solution. However, some parts of the system wasn't due for migration and the old solution was needed until it could be sunset.
Due to a sudden lack of key resources, SDC needed someone to maintain the solution, and I was hired and given full production responsibility.
Tasks during the assignment: incident handling, production monitoring, solution documentation, application- and data-analysis, migration tasks, vendor- and customer support.
SDC supports more than 100 financial institute in Scandinavia, they are all reliant on the DW.
Technologies used: Informatica Powercenter, DB2, AIX, MVS, OPC/TWS, Visual Studio
Data warehouse consultant
UFST

2021-03 - 2021-11

(Danish tax / government) UFST is implementing Next generation Digital Post in their overall system landscape and for that they needed a reporting solution.
I was hired as ETL developer on the data warehouse platform and was responsible for gathering source data from 6 different providers, modelling and loading these to the existing data warehouse platform and exposing them to the BI tools.
Data was delivered in a mix of XML and JSON formats using REST and SFTP as interfaces.
The main part of the project was handled remote but finished with a few weekly days on site.
Technologies used: Informatica Powercenter, SAP Adaptive Server Enterprise (SAP ASE), Python, Xml, Json, REST Api, DB Visualizer.
Data warehouse consultant
UFST

2020-11 - 2021-03

(Danish tax / government) Working in an end of year taskforce, implementing end of year changes and improving stability, performance and maintainability of their current solution.
Improving the design, so the end of year work can be done following a short design guide.
Also improved the daily batch load by several hours.
The project was done remote.
Did PoC on SAP IQ solution designs with their DBA.
Technologies used: Informatica Powercenter, SAP Adaptive Server Enterprise (SAP ASE), SAP IQ.
Data Warehouse Architect at Rigspolitiet
National police dept

2018-04 - 2020-03

Working as technical architect in the Data Management department with 12 employees + 5-10 Palantir consultants.
Their data warehouse solution was built in Informatica Powercenter and TSQL using SQL Server in an always on setup. Collecting data from various platforms, such as IBM mainframe, Oracle, SQL Server, Sharepoint, SAP BW and CSV files in a combination of delta and full loads.
Also had the role of defining the data pipeline from various source systems to the police analysis platform build on Palantir Gotham with 10.000+ users. Working as key person between Palantir's team of consultants and the IT departments.
Participating in project estimation teams, test data and testenvironment workshops. Have worked with various levels of retention rules, due to different legislations in source systems, analysis platform and state archive requirements Highly experienced with working at confidential data, defining access roles and auditing rules for these.
Was responsible for designing a geospatial solution for the organisation as well as an analysis platform for the regions.
Volunteer work at the local school
school (Swimming, English and Maths)

2016-01 - 2017-12

(Swimming, English and Maths).
Marathon training with the Danish Team Veteran.
Casual jobs (environment photographer, Regional food production, support and research for Danish import startup)
EDW and BI developer
Nykredit

2012-11 - 2015-12

2013-2015:
The EDW and the MFI3 Mart was combined into one team, and I continued with Development tasks in both areas as well as having production support for the MFI3 mart solution.
Technologies: Informatica Powercenter, Oracle Exadata, DB2, CSV flat files, AIX, TWS, Obiee and QualityCenter.


2012-2013: I was assigned to the MFI3 project and working with the development of the Datamart. The data was extracted from the newly designed EDW based on the IBM's Banking Data Warehouse. The solution was built using Informatica Powercenter for transformation, Oracle Exadata for storage and OBIEE for the reporting layer. The MFI3 report was using data from various source systems, so there was a very close cooperation with the business users to ensure implementation and testing at the same time.

Freelance DataStage developer at Nykredit
Banking and mortgage

2011-11 - 2012-10

lenders) I was working on project Sustainable mortgage credit, a project where the existing data warehouse should be extended to hold both Nykredit and Totalkredit mortgage arrangement. One of the requirements was also to implement as few changes to the existing solution as possible. The design and implementation was done in 4-5 months and in due time for the Projects go live. When the project finished, I was assigned to some minor tasks in the DWH area, implementing some extracts to corporate finance and Group corporate risk.
I made a DataMart for property collaterals (national online registration). I was also involved in as-is analysis of the existing DWH and how it would fit into the new EDW solution that Nykredit was working on, as well as data quality improvements related to the Nykredit customer solution.
Technologies: DataStage Server, DataStage Mainframe, Informatica Powercenter, DB2, QualityCenter, AIX, JCL, Oracle DB
Freelance ETL Consultant
Nordea (Banking)

2006-10 - 2011-02

2008-2011:
I was working as architect and technical lead with our offshore Development team
of 8-10 people in India. The role involved a lot of resource planning, change management and production
support. Through the period we developed some further reporting solutions and better maintainability features
such as sanity checks performance optimizations, load-prediction and -statistics. Technologies: DataStage, TSQL, MS SQL Server, HP Quality Center, AIX, TWS, MS Office, ClearCase.
2006-2008:
I was working as lead developer and architect on the Basel II solution in Nordea. When the system was put into production
I was solution responsible for some years. Using the data from the 100+ source systems there was a period of developing new reporting solutions on the existing data. Technologies: DataStage, TSQL, DTS, MS SQL Server,

ETL Architect
Nordea (Banking)

2005-01 - 2006-09

I had the role of ETL architect on the Basel II project. The task was to build a DWH for the 100+ source systems in Nordea and uniform them so they could be processed by SAP Bankanalyzer and SAP BW. Due to the source structure of the many systems, most of them was pre-processed and delivered as CSV or fixed format files on MVS, AIX or Windows platforms.
Initially my role was to design and build the transformation framework, and then to introduce it to the Development team. During the process i had the technical responsibility of the solution and did code reviews As well as Development work on the more complex deliveries. The ETL development team had 10 man onsite and 20 offshore resources in India.
Technologies: DataStage, TSQL, DTS, MS SQL Server, HP Quality Center, AIX, TWS, MS Office, ClearCase, IIS and ASP.
Senior System developer
Nordea (Banking)

1999-02 - 2005-12

2002-2005: I took part in one of the first cross-border Projects in Nordea, with the purpose of building a common Nordic general ledger solution in SAP R/3. I was involved in the Development of a master data solution on MS SQL server and building a common sourcing platform for the banks 100+ source systems that was delivering data to the general ledger - this was done using DataStage Server for AIX and MS SQL server. All deliveries had to be uniformed into a common data model before the data could be loaded to SAP R/3 and SAP BW. The load interface consisted of IDocs and flat files.
The transformation engine also included full reconciliation and online audit trail of all deliveries and transformations. The team was cross border, Development was mainly done in Denmark, but the business users from all 4 Nordic countries was involved, and the SAP department was in Sweden. I had the roles as developer and architect in the process, participating in a wide variety of tasks, including: System design System Development. Building the ETL framework. Performance optimization. Review of implementations.
Running proof of concept for DataStage PX Designing the scheduling of the solution. Change management and version control. Technical troubleshooting on the SAP interface in co-operation with Ascential Software (DataStage vendor). Technical responsible for the DataStage platform. Technical contact for the SAP teams.
Technologies: DataStage Server (AIX), TSQL, DTS, MS SQL Server, SAP R/3, SAP BW, TWS, AIX, MQ, Internet information server and ASP.
Senior system developer
Tryg, part of Unibank (now Nordea)

1999-02 - 2001-03

I was working as a developer in the life & pensions department, implementing the workflow system in Tryg. I had the responsibility of the front-end system, using Visual Basic and MS Word with embedded VBA creating the documents for the customers as well as the OCR solution for scanning and identifying the documents
from the customers.
Tools: Workflow from Bull (later Global360), Visual Basic, VBA and C++.

System developer
Alka Forsikring

1996-10 - 1999-01

(Insurance) .
I participated developing Alka's new life & pension system on the mainframe, using ObjectStar from Antares.
I participated on several roles from analysis, development and education. At the end, I also had the role of introducing Visual Basic in the organisation, doing method and strategy implementation.
Company size of 400 people and 30 in the IT department.

Koulutus

Datamatiker
Roskilde Handelsskole

1993-01 - 1995-01

Informatik assistent
Roskilde Handelsskole

1991-01 - 1993-01

EFG handel og kontor
Køge Handelsskole

1990-01 - 1991-01

Ota yhteyttä konsulttiin

/