Schlagwörter
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
Reisebereitschaft
Verfügbar in den Ländern
Deutschland