Informatiker
- Verfügbarkeit einsehen
- 0 Referenzen
- 100€/Stunde
- 20359 Hamburg
- Weltweit
- de | en
- 12.07.2019
Kurzvorstellung
Qualifikationen
Projekt‐ & Berufserfahrung
7/2018 – offen
Tätigkeitsbeschreibung
Konvertierung eines BI-Service von MySQL nach Oracle
Berechnungen mit statistischen Methoden
Erweiterung der ETL-Prozesse
Code- und Performance-Analyse und -Tuning
Business Intelligence (BI), Data Warehousing, Microsoft SQL Server Analysis Services (SSAS), Oracle Business Intelligence (BI), Datenbankentwicklung, ETL
1/2018 – 7/2018
Tätigkeitsbeschreibung
Develop ETL solutions
Mobilize data into a core data warehouse
Populate downstream marts
Portfolio performance calculation
Asset static analysis
Anti money laundering trade query analysis
Portfolio rebalancing
Data Warehousing
2/2017 – 1/2018
Tätigkeitsbeschreibung
Concept and realization of a line research and preorder - design and implementation of the service-oriented architecture
Optimization of existing services
Code review and static code analysis from offshore projects
DV-Concepts and further Development J2EE Application BL-T
Performance measurement and tuning in the area of Oracle RDBMS and Java
Big Data, Oracle Database
9/2016 – 2/2017
Tätigkeitsbeschreibung
Establishment of a group-wide enterprise Data Warehouse based on Oracle and Informatica Powercenter
Implementation of interfaces from the sources into the staging area
Design and implementation of ETL routes from staging into the Raw Vault
Design and implementation of ETL routes from Raw Vault to Business Vault
Consulting in the area of best practices and performance optimization
Data Warehousing
12/2015 – 9/2016
Tätigkeitsbeschreibung
Analysis of requirements and specifications
Technical Documentation
Implementation of various incoming and outgoing interfaces
Implementation of workflows according to internal standards and best practices
Testing the developed mappings and workflows
Endeca
12/2014 – 12/2015
Tätigkeitsbeschreibung
Conception and development of a new BI platform based on Informatica, Oracle and Business Objects
Fault analysis
Performance optimisation
Data modelling
Shell scripting
Informatica, Microsoft SQL-Server (MS SQL)
8/2012 – 12/2014
Tätigkeitsbeschreibung
Concept, design and implementation of the Business Data Vault Layer
Raw Data Vault Modeling support
Java implementation of 'Domain Specific Language' for Raw and Business Data Vault objects
PL/SQL development of ETL routines
Solaris, Java Architecture for XML Binding (JAXB)
9/2011 – 8/2012
Tätigkeitsbeschreibung
Modeling the Data Vault 2.0 Environment (Raw Data Vault, Business Data Vault, Information Mart)
Coordination with the department about Business Keys and requirements
Data Vault training for ETL developers
Planning, estimation and implementation of ETL requirements
Release implementation of developed ETL processes
Documentation of the ETL implementation
Vault data management software (Autodesk)
6/2009 – 9/2011
Tätigkeitsbeschreibung
Maintenance of the existing DWH/BI-landscape
ETL and Cube development troubleshooting
Performance and Query Optimization (DBA)
Determination of the requirements of the departments
Connection of financial accounting system to DWH
Rollout of extended Cube systems
Big Data, Data Mining
6/2009 – 9/2011
Tätigkeitsbeschreibung
Maintenance of the existing DWH/BI-landscape
ETL and Cube development troubleshooting
Performance and Query Optimization (DBA)
Determination of the requirements of the departments
Connection of financial accounting system to DWH
Rollout of extended Cube systems
Big Data, Data Mining
11/2007 – 6/2009
Tätigkeitsbeschreibung
Implementation of a data migration project
Analysis of the source and target application with regard to the data to be transferred
Execution of requirements analysis for the target system
Scheduling the migration from Lotus Notes to Oracle
Conception and development of a migration application using an XML interface
Implementation of the migration
Lotus Notes Domino, Lotus Notes Script
6/2005 – 11/2007
Tätigkeitsbeschreibung
Development of an interface between Lotus Notes and MS Excel
Support in creating reports in MS Excel using migrated data
Support and extension of an application for the processing of credit applications
Software Architecture
Zertifikate
Ausbildung
Berlin
Weitere Kenntnisse
Persönliche Daten
- Deutsch (Muttersprache)
- Englisch (Fließend)
- Europäische Union
- Schweiz
Kontaktdaten
Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.
Jetzt Mitglied werden