Josef Schermer - DevOps

Munich, Germany

Experience

Jan 2020 - Dec 2024

5 years

Munich, Germany

DevOps

Software house for an industrial company

Implementation, maintenance and operation of an ERP system and a document exchange platform for a corrugated cardboard manufacturer.
Tools and systems: Unix (Debian 6.x), C, SVN, Windows, C#, MS SQL Server, SCRUM.

Jan 2019 - Dec 2020

2 years

Munich, Germany

Consultant

Software house for an automaker's bank

Implementation and maintenance of ETL processes in the context of a company-wide data warehouse.
Tools and systems: Informatica PowerCenter 10, Oracle 12c, SQL, PL/SQL, C, Perl, SVN, UNIX, Windows.

Jan 2018 - Dec 2019

2 years

Munich, Germany

Consultant

Software house for an automotive manufacturer

Implementation and maintenance of ETL processes in the context of a data warehouse within a human resources project.
Tools and systems: Informatica PowerCenter 10, Oracle 12c, SQL, PL/SQL, UNIX, Windows, JIRA, SCRUM.

Jan 2017 - Dec 2018

2 years

Munich, Germany

Consultant

Software house for an automaker's bank

Implementation and maintenance of ETL processes in the context of a data warehouse for vehicle leasing.
Tools and systems: Informatica PowerCenter 10, Perl, Oracle 12c, SQL, PL/SQL, UNIX, Windows.

Jan 2016 - Dec 2017

2 years

Munich, Germany

Consultant

Software house for an automotive manufacturer

Testing within a Hadoop cluster and deployment of application packages within a Hadoop cluster within a Hadoop project.
Tools and systems: Hortonworks Hadoop cluster, Linux Bash shell, HDFS, Oozie, Hive, Pig, GIT, Postgres.

Jan 2016 - Dec 2016

1 year

Munich, Germany

Consulting

Software house for an automotive manufacturer

Implementation and maintenance of ETL processes in the context of a data warehouse within a human resources project.
Tools and systems: Informatica Powercenter 9.51, Oracle 11g, SQL, PL/SQL, SVN, UNIX, Windows.

Jan 2015 - Dec 2016

2 years

Munich, Germany

Consulting

Software house for a financial institution

Implementation of ETL processes for an interface in the context of a financial data warehouse.
Tools and systems: Informatica Powercenter 9.51, Oracle 11g, SQL, PL/SQL, UNIX, Windows.

Jan 2014 - Dec 2015

2 years

Munich, Germany

Consulting

Software house for an automotive manufacturer

Implementation and maintenance of ETL processes in the context of a data warehouse within a human resources project.
Tools and systems: Informatica Powercenter 9.51, Oracle 11g, SQL, PL/SQL, SVN, UNIX, Windows.

Jan 2012 - Dec 2014

3 years

Munich, Germany

Consulting

Telecommunications company

Implementation of ETL processes in the context of a data warehouse for a telecommunications company.
Tools and systems: Informatica Powercenter 9.5, Oracle 11g, SQL, PL/SQL, UNIX, Windows, SVN, Excel.

Jan 2010 - Dec 2012

3 years

Munich, Germany

Consulting

Software house

Implementation of ETL processes in the context of marketing processes within the automotive sector.
Migration of ETL processes from Informatica Powercenter 8.6 to Informatica Powercenter 9.1.
Design and implementation of ETL processes in the context of quality management processes within the automotive sector.
Implementation and configuration of a browser-based application for inventory management of telecommunications components. Using an SQL-centered framework to build the application modules. Interfaces from Excel to Oracle were provided with Perl and PL/SQL. Testing with SQL and Perl.
Implementation and configuration of browser-based applications to support rollout projects in the telecommunications sector. Based on SQL, interfaces and reports were provided in Excel and XML.
Maintenance of a tool for controlling telephone systems. Bug fixes, data cleanup, and tool enhancements using SQL and PL/SQL.
Tools and systems: UNIX, Windows, Oracle, SQL, PL/SQL, Informatica Powercenter 9.1/8.6, Perl, SVN, JavaScript, HTML, TWiki, XML, XLST.

Jan 2008 - Dec 2009

2 years

Munich, Germany

Consultant

Software House

Implementation and configuration of a browser-based order management tool in the telecom sector.
Implementation and configuration of a browser-based tool to support rollout projects in the telecom sector.
Tools and systems: UNIX, Windows, Oracle, SQL, PL/SQL, Perl, JavaScript, HTML, Excel.

Jan 2008 - Dec 2008

1 year

Munich, Germany

Consultant

Data Center

Implementation of data reconciliation between banks' full data sets and the data in an operator database. The reconciliation is implemented as a UNIX application in C/C++ with ESQL accesses to DB2.
Tools and systems: C/C++, UNIX, DB2 V9.

Jan 2007 - Dec 2007

1 year

Munich, Germany

Consultant

Bank

Implementation of migration for data provisioning for credit cards using Informatica workflows.
Testing data feeds from country subsidiaries into a central company-wide database.
Tools and systems: Informatica Powercenter, Oracle 10g/9i, SQL Navigator, UNIX.

Jan 2006 - Dec 2007

2 years

Munich, Germany

Consultant

Data Center

Implementation of data provisioning from banks' message files into an operator database according to legal requirements. For runtime optimization, implemented as a UNIX application in C/C++ with ESQL accesses to DB2.
Tools and systems: C++, ESQL, DB2 V9, UNIX.

Jan 2006 - Dec 2006

1 year

Munich, Germany

Consultant

Bank

Implementation of data provisioning from country subsidiaries into a central company-wide database using Informatica workflows.
Tools and systems: Informatica Powercenter, Oracle 9i, SQL Navigator, UNIX.

Jan 2005 - Dec 2006

2 years

Munich, Germany

Consulting

Industrial company

Designing and implementing document reception via web server.
Designing and implementing data exchange of freight invoices in EDIFACT format.
Implementing Windows services to receive and send data.
Integrating various communication partners and types and monitoring connections.
Designing and implementing data exchange in VDA format (call-offs, delivery notes, delivery schedules) and credit memos.
Tools and systems: C#, IIS, MS SQL Server, MS BizTalk Server 2004, Gedas RvsXp, Windows Server 2003.

Jan 2002 - Dec 2005

4 years

Munich, Germany

Consulting

Bank

Implementing data provisioning to the CRM system, external payment processing, and credit card system from the ODS.
Implementing data provisioning to the ODS from the leasing system.
Testing and implementing master data and account data between the legacy system, ODS, and the DWH staging area.
Maintaining legacy systems using Visual Basic.
Tools and systems: SQL, PL/SQL, ORACLE, Informatica, Windows XP/NT, UNIX, Shell, FTP, SFTP, SSH, ErWin, ConnectDirect.

Jan 1997 - Dec 2002

6 years

Munich, Germany

Consulting

Software company

Maintaining and enhancing a CRM system and providing technical project leadership.
Designing and implementing a customer contact service, considering existing data models.
Designing and implementing helper classes (DB access, GUI) within the servlet environment.
Optimizing a selection tool and a system for managing marketing campaigns.
Specifying and implementing an interface DLL between a credit processing application and a customer advisory system.
Integrating a data warehouse tool with a customer advisory system.
Developing credit advisory reports.
Implementing the euro conversion and authorization profiles.
Tools and systems: UML, Java, JDK 1.2, JRun, JDBC, SQL, Swing, C++, UDB/DB2, Oracle, ErWin, RTS-GUI, Windows NT/OS/2.

Jan 1990 - Dec 1997

8 years

Munich, Germany

Database development

Hardware and software manufacturer

Designing multithreading capabilities, replication, and ALTER TABLE functions within a relational database system.
Maintaining CREATE INDEX functions and authorization functions.
Designing and implementing transaction functionality for DDL statements and database buffering.
Designing and implementing a task framework for service tasks.
Tools and systems: C, Assembly, UNIX, Windows NT, BS2000.

Skills

Main Focus: Development/consulting In Dwh/bi And Database
Retrieval Languages: Sql, Pl/sql
Tools: Informatica Powercenter
Operating Systems: Windows, Unix/linux
Db Systems: Oracle, Ms Sql Server, Postgres
Project Execution: Project Planning, Effort Estimation, Product Maintenance And Support, Scrum
Programming Languages: C, Perl, Unix Shell
Design: Database Design, Data Modeling
Design: Uml, Gof, System Analysis, Oo Design
Programming Languages: C++, Java, Javascript, C#, Oozie, Pig, Python
Tools: Hdfs, Git, Jira, Svn, Visual .Net, Office Suites, Confluence
Gui: Html
Operating Systems: Bs2000, Mvs
Db Systems: Db2/udb, Hive, Informix, Sesam, Sql Anywhere