Freelancerprofil: -0132512

Entwickler, System Architect DWH, BI, ETL, SAP, SAS, SAP-SEM CO BW Data Modeling, Teradata, SQL, Git

IT-Erfahrung seit:
2017
Position:
IT Analyst / Architekt
IT Beratung / Consulting
IT Datenbankentwicklung
Software-Entwicklung / Programmierung
Projekte im Werdegang
03/2017 - SAS Software, ETL - Extract/Transform/Load, ETL - Extract/Transform/Load, SAS Software, SAP-SEM -Strategic Enterprise Management, SAP-CO - Controlling, SAP-BW - Business Information Warehouse, Data Mo
Data Integration REWE Systems ETL Developer Development of Data Warehouse ETL jobs with SAS and BTEQ Role Bilateral data integration o TM1 o SAP SEM-BCS o SAP CO o SAP BPS o SAP BW Data Modeling Consulting and support of Business Users and Business Analysts in agile development environment SAS Enterprise Guide 7.11 s: Teradata Studio 15.11 Teradata SQL Assistant, Putty, WinSCP, Jira, ZOC Terminal, git v2 SAS Developer,ETL Developer

01/2017 - Data Modeling, Teradata, Teradata, SQL
System Architect Assisting with the implementation of a DWH concept Role Transfer of expertise and best practices for Ab Initio Developing of, and tech support, for a DWH solution based on heavily customized Ab Initio MDWH and scheduling with Control Center and Conduct>It Data flow and data load performance optimization using parallelization Data Modeling Consulting and support of Business Users and Business Analysts during data integrity test and acceptance test phases Development of Teradata DDL deployment and migration packages for testing and prod environments Ab Initio GDE 3.2.7.2 s: Ab Initio Express>It 3.2.4.3, Ab Initio Co>Operating System 3.2.4.7 Ab Initio Control Center 3.2.7.2, Ab Initio Metadata-Driven Warehouse, Teradata SQL Assistant Ab Initio Developer,Coach,System Architect

05/2014 - 08/2014 ETL - Extract/Transform/Load, SQL, Data Modeling, MS SQL Server, ETL - Extract/Transform/Load, SQL, Cognos, ETL - Extract/Transform/Load, ETL - Extract/Transform/Load, MS SQL Server, SQL, Cognos
Smurfit Kappa Backend implementation of a data warehouse database for analysis and reporting May 2014 3 rd level Support Coordination und implementation of an ETL concept with SQL Role Server Integration Services Assistance in data modeling as well as in development in MS SQL-Server Development of ETL processes for the staging area and the data warehouse layer Implementation of data cleansing rules (part of the integration of various data sources) Building a special data layer via SQL logic to provide data for IBM Cognos reporting Integration of ETL processes in job scheduling Consulting and support of Business Users and Business Analysts during data integrity test and acceptance test phases Microsoft SQL-Server, SQL-Scripting, IBM Cognos Executive Viewer Tools Analyst,ETL Developer

12/2013 - 03/2014 ETL - Extract/Transform/Load, Unix Shell Script, ETL - Extract/Transform/Load, ETL - Extract/Transform/Load, Oracle, SQL, Unix Shell Script, Linux, SQL
Development of a production based DWH ETL-Developer, Ab Initio Support Assistance in development of a data warehouse for a consolidated companywide reporting platform Implementation of Ab Initio graphs for two subprojects as a part of the development process with GDE Implementation and optimization of different configuration files and generic graphs to secure and re-use ETL routines at different factories of the worldwide operating customer Implementation of Unix shell scripts for automation of the designed ETL processes Processing of Jira tickets within the test and the approval process Implementation of a broad range of QA test cases of the designed Ab Initio ETL paths Ab Initio GDE 3.1.5.3 (Co>Operating System 3.1.5.5), Oracle 11g, SQL, Unix Shell Scripting with Red Hat Enterprise Linux Server Release 5.3, SQL Developer 3.2.20.09, Jira-Project Management System Tools SQL Developer

12/2013 - Employers Saracus Consulting

12/2010 - 11/2012

09/2009 - 11/2010 ARIS
Process optimization for increase of profitability and introduction of November 2010 clinical treatment pathways Project Coordinator Analysis of business processes and clinical treatment pathways ARIS Architect, Process optimization, Realization of studies , statistical analysis Tools Process Developer,Project Coordinator

09/2009 - 11/2010

01/2008 - Oracle, MS SQL Server, Teradata, Postgres SQL, Visual Studio, MS SQL Server, HTML/XHTML, XML, TeX/LaTeX, SQL, Mathematics, Eclipse, NetBeans, ARIS, Eclipse, Scrum
Databases: Oracle 11g, MSSQL, DB2, Teradata 14, PostgreSQL Data Integration and Data Ab Initio Co>Operating System 3 Warehouse Tools 2012 Other: HTML, XML, LaTeX, SQL Developer 3.2, Putty, Wolfram Mathematica, Eclipse, NetBeans, WinSCP, Notepad++, ARIS Architect, iMedOne, Eclipse, eVIEWS, Jira, Scrum, TortoiseCVS

 
Branche
  Medizintechnik
 
Kenntnisse
Hardware
Betriebssysteme
Linux
Unix
Programmiersprachen
Eclipse
HTML / XML
Java
PL/SQL
Python
SQL
Unix Shell Script
XML

Datenbanken
MS SQL Server
Oracle
Postgres SQL (psql)
Teradata

Datenkomm. / Netzwerk

Design / Entwicklung

SAP / ERP Module
SAP CO (Controlling)
SAP SEM -Strategic Enterprise Management

Software / Tools
ARIS
Cognos
Eclipse
GIT
NetBeans
Salesforce
SAS Software
Visual Studio

Standards / Prozesse
ETL - Extract/Transform/Load
Problem Management
SCRUM
 
Ausbildung & Zertifikate
k.A  
 
Sprachen
englisch
französisch (++++)
russisch


Sonstiges
 

für Freelancer

für Kunden

Kontakt

people4project GmbH
Lörenskogstr. 3
85748 Garching bei München
+49 (89) 55 29 39 - 40
Kontaktdaten anfordern
Image

Vereinbarung zur Verwendung von Cookies

Allgemeine Verwendung

Wir verwenden Cookies, Tracking Pixels und ähnliche Technologien auf unserer Website. Cookies sind kleine Dateien, die von uns erstellt und auf Ihrem Gerät gespeichert werden. Unsere Website verwendet Cookies, die von uns oder von Dritten zu verschiedenen Zwecken im Rahmen der Verwendung und Funktionalität einschließlich der Personalisierung unserer Website abgelegt werden. Es ist möglich, dass Cookies verwendet werden, um zu nachzuvollziehen, wie Sie die Website verwenden und so zielgerichtete Werbung anzuzeigen.

Dritt-Anbieter

Unsere Website nutzt verschiedene Dienste von Dritt-Anbietern. Wenn Sie auf unserer Website sind, können diese Dienste anonyme Cookies im Browser des Benutzers ablegen und diese Cookies mit in der Cookie-Datei des Besuchers speichern. Im folgenden eine Liste einiger derartiger Dienste: Google, Facebook, Twitter, Adroll, MailChimp, Sucuri, Intercom und andere soziale Netzwerke, Anzeigen-Agenturen, Sicherheits-Software wie z.B. Firewalls, Datenanalyse-Unternehmen und Anbieter von Internetzugängen. Diese Dienste sammeln möglicherweise auch anonyme Identifizierungsmerkmale wie die IP-Adresse, den HTTP-Referrer, die eindeutige Geräte-Kennung und andere nicht-persönliche Informationen zur Identifizierung sowie Server Logfiles.