Niels Stig Hansen available

Niels Stig Hansen

Freelance Data Warehouse/ETL Specialist

available
Profileimage by NielsStig Hansen Freelance Data Warehouse/ETL Specialist from Vedbk
  • 2950 Vedbæk Freelancer in
  • Graduation: not provided
  • Hourly-/Daily rates: 100 €/hour 800 €/day
    exclusive VAT
  • Languages: Danish (Native or Bilingual) | German (Full Professional) | English (Full Professional)
  • Last update: 29.10.2015
KEYWORDS
PROFILE PICTURE
Profileimage by NielsStig Hansen Freelance Data Warehouse/ETL Specialist from Vedbk
SKILLS
Basic Account 

Data Warehousing, ETL, Database Design, Databases, PL/SQL, Business Intelligence, Data Modeling, DB2, Unix, SQL, Data Integration, Performance Tuning, Oracle Warehouse Builder, Data Warehouse Architecture, Data Analysis, Unix Shell Scripting, Requirements Analysis, Oracle SQL, Linux Database, XML, Physical Data Modeling, Linux, OLAP, AIX, Architecture, Systems Analysis, Testing, Programming, Database Administration, Agile Methodologies, Oracle OLAP, Shell Scripting, Data Mining, Fraud Analysis, SQL Tuning, Logical Data Modeling, Data Mapping, Distributed Systems, Software Development, C++, Java, Agile, Solution Architecture, Application Development, PostgreSQL, Data Vault, Python, R, Big Data, Pentaho
REFERENCES
The Missing Link Consulting ApS
Owner
03.1994 - today
Freelance Oracle/DB2/UNIX Administrator/Developer
Data Warehouse developer/architect
Information Technology and Services


Tryg
Freelance Data Warehouse Developer
07.2011 - 12.2013
Freelance Data Warehouse developer.
Part of a team, building a Data Warehouse based on the Data Vault model in relation to Solvency II.
Mapping data from source system to the Data Vault based EDW (Enterprise Data Warehouse) structure.
Planning, designing, implementing, testing, debugging and optimization of the ETL mappings in Oracle Warehouse Builder.
Optimizing the calculations of the monthly earned and unearned premium.
Insurance
1001-5000 employees

Sirius IT
Freelance IT-Consultant
09.2010 - 06.2011
Freelance Database developer and data analytic.
Worked with some of Pensam's Ingres/Linux based systems.
My primary concern was data quality analysis.
Information Technology and Services


Telenor DK
Freelance Data Warehouse Developer
04.2010 - 06.2010
Freelance Data Warehouse Specialist.
Worked with troubleshooting and error correcting the Data mart with data from the Data Warehouse. This involved deep insight concerning data from the Amdocs billing system NABS for Mobile telephony and analysis of ETL dataflows.
Telecommunications


Nordea Markets
Freelance Oracle consultant
01.2010 - 03.2010
Oracle PL/SQL developer.
The TCC database establishes a unified view from the national legacy systems.
Worked with debugging PL/SQL programs used for data integration and developed XQuery code for exchanging XML formatted data.
Banking


CSC
DB2 Data Warehouse Contractor
05.2009 - 10.2009
Development regarding TDC's (http://www.tdc.com) DB2 based Data Warehouse DAWIS.
The work requires an insight into TDC's various operational systems witch supply the DW with data.

Specialties includes.
- Specialist knowledge of data from the Amdocs made billing system NABS with focus on the complexity of Mobil traffic data (CDR).
- Innovation.
- Designing data flows of high quality while keeping the design simple.
- Data analysis regarding fraud exposure.
- A high degree of self management.
- Handling many concurrent tasks.

Work on many small and medium/large sized projects, on the small projects as a one man project team and on the medium/large sized as part of a team with at project manager.
Primary area of work was to deliver customer and/or traffic data from the DAWIS DB2 Data Warehouse. A VLDB at +45 TerraByte.
Witch involved the following tasks:
- Requirement analysis.
- Supporting the business with data analysis and requirement definition.
- Data flow design
- Data flow programming using the following tools as needed: SQL, UNIX Shell scripts, Java, SQL/PL, SSH, C or PERL.
- UNIT and System test.
- Deployment.
- Documentation.

Support of the daily production of the DAWIS Data Warehouse, which included the following tasks.
- Trouble shooting.
- Data Quality analysis and quality assurance of data.
- Fixing the ETL code when changes in a source system made it necessary.
- Performance tuning in a VLDB context.
- Colleague support.
- Design and development of tools for production support and control.
- And more.

At CSC I also worked with:
- Project foundation related tasks
- Troubleshooting and correction regarding cross platform data flows, that involved unknown and undocumented systems.
- Analysis and troubleshooting of SAS ETL programs.
- SQL Server troubleshooting.
Information Technology and Services


IBM
Freelance DB2 Data Warehouse Specialist
09.2005 - 04.2009
Development regarding TDC's (http://www.tdc.com) DB2 based Data Warehouse DAWIS.
The work requires an insight into TDC's various operational systems witch supply the DW with data.

Specialties includes.
- Specialist knowledge of data from the Amdocs made billing system NABS with focus on the complexity of Mobil traffic data (CDR).
- Innovation.
- Designing data flows of high quality while keeping the design simple.
- Data analysis regarding fraud exposure.
- A high degree of self management.
- Handling many concurrent tasks.

Work on many small and medium/large sized projects, on the small projects as a one man project team and on the medium/large sized as part of a team with at project manager.
Primary area of work was to deliver customer and/or traffic data from the DAWIS DB2 Data Warehouse. A VLDB at +45 TerraByte.
Witch involved the following tasks:
- Requirement analysis.
- Supporting the business with data analysis and requirement definition.
- Data flow design
- Data flow programming using the following tools as needed: SQL, UNIX Shell scripts, Java, SQL/PL, SSH, C or PERL.
- UNIT and System test.
- Deployment.
- Documentation.

Support of the daily production of the DAWIS Data Warehouse, which included the following tasks.
- Trouble shooting.
- Data Quality analysis and quality assurance of data.
- Fixing the ETL code when changes in a source system made it necessary.
- Performance tuning in a VLDB context.
- Colleague support.
- Design and development of tools for production support and control.
- And more.

A Cognos 8 demo project, which included:
- Cognos installation and configuration with SQL Server and Oracle at databases.
- Establishment of an ETL flow to load demo data and build a fact table with the relevant dimensions.
- Demonstration of Cognos as a data mining tool.
Information Technology and Services


IBM SDC (former DMdata)
Freelance DBA on DB2 UDB/AIX
06.2005 - 08.2005
Freelance DBA on DB2 UDB/AIX with focus on performance tuning.
Information Technology and Services
201-500 employees

SCR Consulting
Freelance konsulent
0.2005 - 0.2005
Freelance DB2 DBA
Computer Software


TDC Services A/S
Freelance DB2 Datawarehouse developer
01.2003 - 05.2005
DB2 Datawarehouse developer.
Telecommunications


Maersk Data
Freelance Oracle Developer
0.2001 - 0.2001
Configuration of a server for Oracle Advanced Queue (OAQ) at a Maersk Logistics warehouse in the Lyon area in France.
Programming of a PL/SQL module for translation between message format used by SAP at Lego A/S (http://www.lego.com) and the control tables used by Exceed database. To allow the SAP system at Lego to control the operations at the warehouse and the Exceed database.
Design of a OAQ  infrastructure with a central OAQ server that communicates with Lego and local OAQ servers at several warehouses run by Maersk Logistics for Lego.
Information Technology and Services
1001-5000 employees

Organisator A/S
Freelance Consultant
0.2001 - 0.2001
Specification of the Oracle DBA part of a tender to a potential Facility Management customer of Organisator A/S.
Computer Software


IT support
Freelance IT Consultant
0.1996 - 12.1999
Part of a team, that is building a Data Warehouse based on the Data Vault model in relation to Solvency II.
Mapping data from source system to the Data Vault based EDW (Enterprise Data Warehouse) structure.
Planning, designing, implementing, testing, debugging and optimization of the ETL mappings in Oracle Warehouse Builder.
Optimizing the calculations of the monthly earned and unearned premium.
Computer Software


Responsor (hos Post Danmark)
Freelance Konsulent
0.1996 - 0.1996
HACMP-Consultant.
Configuration and testing of a IBM HACMP (High Availability Clustering Multi Processor) cluster running an Oracle database on AIX for Post Danmark (http://www.postdanmark.dk).
Computer Software


Hewlett-Packard
Freelance UNIX konsulent
0.1995 - 0.1995
Freelance UNIX konsulent
Information Technology and Services


Tom Pedersen International
Oracle Consultat
12.1992 - 12.1992
Oracle Consultant
Computer Software


Teknologisk Institut
IT Consultant
01.1990 - 07.1991
IT Consultant
Design and programming a system for documentation and assurance of the quality of how buildings are maintained. It was programmed in C on as dde SuperMax (UNIX System 5) and was based on a Oracle database version 5.
 
The complete enterprise of design, programming, deployment and support of a system to support the consultants of the 8 TIC (Technological Information Centers) in Jutland. The System was based on a Oracle database, Oracle SQL*Forms, Xenix (a version of UNIX) and integration from ORACLE to WordPerfect. It all ran on one PS/2 computer with VT100 terminals.
 
Design and Development a system, based Oracle database, to support marketing.
 
Responsible for the technical part of the joint venture project with New Jersey Institute of Technology (worked for 3 weeks at NJIT in 1989). The goal was to make at system for computerized communication and conferencing and was based on a distributed smalltalk, developed by NJIT in C, and ran on HP-UX.  It can be viewed as something like Lotus Notes.
 
General administrator, developer and supporter Oracle databases and UNIX.
 
I made many small project based on a combination of ORACLE RDBMS, ORACLE SQL*PLUS, ORACLE PRO*C; ORACLE SQL*FORMS 2.3, C/C++, LISP, AutoCad, Xenix, HP-UX, dde SuperMax, VAX VMS, DEC PCSA, DECnet, X.25, HP9000, MS Windows, MS/DOS, Ultrix, SUN-OS, TCP/IP, NFS and LISP.
Information Technology and Services
501-1000 employees

Jysk Teknologisk
UNIX/Oracle Developer
01.1987 - 12.1990
IT Consultant
Design and programming a system for documentation and assurance of the quality of how buildings are maintained. It was programmed in C on as dde SuperMax (UNIX System 5) and was based on a Oracle database version 5.
 
The complete enterprise of design, programming, deployment and support of a system to support the consultants of the 8 TIC (Technological Information Centers) in Jutland. The System was based on a Oracle database, Oracle SQL*Forms, Xenix (a version of UNIX) and integration from ORACLE to WordPerfect. It all ran on one PS/2 computer with VT100 terminals.
 
Design and Development a system, based Oracle database, to support marketing.
 
Responsible for the technical part of the joint venture project with New Jersey Institute of Technology (worked for 3 weeks at NJIT in 1989). The goal was to make at system for computerized communication and conferencing and was based on a distributed smalltalk, developed by NJIT in C, and ran on HP-UX.  It can be viewed as something like Lotus Notes.
 
General administrator, developer and supporter Oracle databases and UNIX.
 
I made many small project based on a combination of ORACLE RDBMS, ORACLE SQL*PLUS, ORACLE PRO*C; ORACLE SQL*FORMS 2.3, C/C++, LISP, AutoCad, Xenix, HP-UX, dde SuperMax, VAX VMS, DEC PCSA, DECnet, X.25, HP9000, MS Windows, MS/DOS, Ultrix, SUN-OS, TCP/IP, NFS and LISP.
Computer Software


Jysk Telefon A/S
Software Developer
07.1985 - 12.1986
Algol8 Software Developer on RC 8000
Telecommunications
5001-10,000 employees
TIME AND SPATIAL FLEXIBILITY
available
GET IN TOUCH

I accept the Conditions

I accept the terms of the privacy policy

Note: sending your contact request is free of charge