Profilbild von Stefan Mayer Senior Consultant, Data Vault aus Hamburg

Stefan Mayer

verfügbar

Letztes Update: 10.07.2019

Senior Consultant, Data Vault

Abschluss: nicht angegeben
Stunden-/Tagessatz: anzeigen
Sprachkenntnisse: deutsch (Muttersprache) | englisch (verhandlungssicher)

Dateianlagen

profile 2 Mayer.docx

Skills

Oracle Solaris, JavaScript, PL/SQL, ETL, Data Vault, Unix , Eclipse 

Projekthistorie


Projects:

07/2018 - to date
  Client:                      Bank
  Position:                  Senior Consultant 
  • Conversion of a BI Service from MySQL to Oracle
  • Calculations using statistical methods 
  • Extension of the ETL processes
  • Code and performance analysis and tuning 

Technologies: Linux, Oracle Solaris, Ajax, Apache, Aqua Data Studio, bash, Confluence, Eclipse, HTML, JavaScript, jQuery incl. DataTables, JSON, Perl, PL/SQL, SQL Developer, SVN, XML


01/2018 - 07/2018
Client:                 Financial Service Company
Position:             Consultant 
  • 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

Technologies: Informatica Powercenter, IBM Infosphere Information Server, Oracle Data Integrator, Microsoft SSIS, Ab Initio, CloverETL


02/2017 - 01/2018
Client:                Telecommunications Company
Position:             Consultant 
  • 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

Technologies: APEX, Apache, Eclipse, EJB, Enterprise Architect, ETL, HTML, Java, Jenkins, JMS, JSP, J2EE, Mercury Quality Center, OCI, PL/SQL Developer, Ruby, SQL*Plus, SVN, XML, XMLBeans



09/2016 - 02/2017
Client:                 Telecommunications Company
Position:              DWH Expert
  • 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

Technologies: Informatica Powercenter 9.6.1, Oracle 12c, HORA, Data Vault 2.0, XML
12/2015 - 09/2016
Client:                    Financial Services Company
Position:                 Informatica Expert
  • 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

Technologies: Oracle 11g R2, Informatica Powercenter 9.1.0 und 9.6.1, SQL Developer, Unix, Shell scripting




12/2014 - 12/2015
Client:                  Automotive Company
Position:               Senior Informatica Developer
  • Conception and development of a new BI platform based on Informatica, Oracle and Business Objects 
  • Fault analysis  
  • Performance optimisation
  • Data modelling
  • Shell scripting

Technologies: Oracle 11g R2, Informatica Powercenter 9.1, SAP Business Objects XI 3.1, SQL Developer, Xcelsius 2008, Linux



08/2012 - 12/2014
Client:                  Insurance Company
Position:              Technical Solution Architect
  • 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

Technologies: Java (xtext, xtend), Eclipse, Oracle Exadata, Oracle SQL Developer




09/2011 - 08/2012
Client:                  Bank
Position:              Data Vault Developer
  • 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

Technologies: Oracle 12c, Oracle SQL Developer, Jira, Confluence




06/2009 - 09/2011
Client:                     Telecommunications Company
Position:                 Data Warehouse Developer
  • 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

Technologies: MS SQL 2008 R2, SSAS, Talend



11/2007 - 06/2009
Client:                       Energy Company
Position:                   Software Architect 
  • 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

Technologies: Lotus Notes, Oracle, XML, Informatica Powercenter, Pentaho, SQL



06/2005 - 11/2007
Client:                   Technologies Company
Position:                Software Developer 
  • 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 
Technologies: MS Excel, Lotus Notes, jQuery
 

Reisebereitschaft

Verfügbar in den Ländern Deutschland
Profilbild von Stefan Mayer Senior Consultant, Data Vault aus Hamburg Senior Consultant, Data Vault
Registrieren