Josef Schermer

Devop

Munich, Germany

Experience

Jan 2020 - Jul 2024
4 years 7 months

Devop

Softwarehaus

  • Implementation, maintenance and operation of an ERP system and a document exchange platform for a corrugated board manufacturer.
  • Systems and technologies used: Unix (Debian 6.x), C, SVN, Windows, C#, MS SQL Server, SCRUM.
Jan 2019 - Sep 2020
1 year 9 months

Consulting

Softwarehaus

  • Implementation and maintenance of ETL processes within an enterprise-wide data warehouse for a car manufacturer’s bank.
  • Systems and technologies used: Informatica Powercenter 10, Oracle 12c, SQL, PL/SQL, C, Perl, SVN, UNIX, Windows.
Jan 2018 - Sep 2019
1 year 9 months

Consulting

Softwarehaus

  • Implementation and maintenance of ETL processes within a data warehouse as part of a human resources project for an automotive manufacturer.
  • Systems and technologies used: Informatica Powercenter 10, Oracle 12c, SQL, PL/SQL, UNIX, Windows, JIRA, SCRUM.
Jan 2016 - Mar 2018
1 year 3 months

Consulting

Softwarehaus

  • Implementation and maintenance of ETL processes within a vehicle leasing data warehouse for a car manufacturer’s bank.
  • Systems and technologies used: Informatica Powercenter 10, Perl, Oracle 12c, SQL, PL/SQL, UNIX, Windows.
Jan 2016 - Apr 2017
4 months

Consulting

Softwarehaus

  • Testing within a Hadoop cluster and deployment of application packages as part of a Hadoop project for an automotive manufacturer.
  • Systems and technologies used: Hortonworks Hadoop cluster, Linux Bash shell, HDFS, Oozie, Hive, Pig, GIT, Postgres.
Jan 2015 - Jun 2016
6 months

Consulting

Softwarehaus

  • Testing within a Hadoop cluster and deployment of application packages as part of a Hadoop project for an automotive manufacturer.
  • Systems and technologies used: Hortonworks Hadoop cluster, Linux Bash shell, HDFS, Oozie, Hive, Pig, GIT, Postgres.
Jan 2015 - Mar 2016
3 months

Consulting

Softwarehaus

  • Implementation and maintenance of ETL processes within a data warehouse as part of a human resources project for an automotive manufacturer.
  • Systems and technologies used: Informatica Powercenter 9.51, Oracle 11g, SQL, PL/SQL, SVN, UNIX, Windows.
Jan 2015 - Mar 2016
1 year 3 months

Consulting

Softwarehaus

  • Implementation of ETL processes for an interface within a financial data warehouse for a financial institution.
  • Systems and technologies used: Informatica Powercenter 9.51, Oracle 11g, SQL, PL/SQL, UNIX, Windows.
Jan 2014 - Oct 2015
1 year 10 months

Consulting

Softwarehaus

  • Implementation of ETL processes within a data warehouse as part of a human resources project for an automotive manufacturer.
  • Systems and technologies used: Informatica Powercenter 9.51, Oracle 11g, SQL, PL/SQL, UNIX, Windows.
Jan 2011 - Feb 2014
2 years 2 months

Consulting

Telecommunications company

  • Implementation of ETL processes within a data warehouse for a telecommunications company.
  • Systems and technologies used: Informatica Powercenter 9.5, Oracle 11g, SQL, PL/SQL, UNIX, Windows, SVN, Excel.
Jan 2011 - Mar 2012
3 months

Consulting

Softwarehaus

  • Implementation of ETL processes within marketing processes in the automotive sector.
  • Systems and technologies used: UNIX, Windows, Oracle, SQL, PL/SQL, Informatica Powercenter 9.1, Perl, SVN.
Jan 2011 - Mar 2012
3 months

Consulting

Softwarehaus

  • Implementation of ETL processes within marketing processes in the automotive sector.
  • Systems and technologies used: UNIX, Windows, Oracle, SQL, PL/SQL, Informatica Powercenter 8.6, Perl, SVN.
Jan 2011 - Jan 2012
1 month

Consulting

Softwarehaus

  • Migration of ETL processes from Informatica Powercenter 8.6 to Informatica Powercenter 9.1.
  • Systems and technologies used: UNIX, Windows, Oracle, SQL, Informatica Powercenter 9.1.
Jan 2010 - Jun 2011
6 months

Consulting

Softwarehaus

  • Design and implementation of ETL processes within quality management processes in the automotive sector.
  • Systems and technologies used: UNIX, Windows, Oracle, SQL, PL/SQL, Informatica Powercenter 8.6, Perl, SVN.
Jan 2010 - Apr 2011
4 months

Consulting

Softwarehaus

  • Implementation and configuration of a browser-based application for inventorying telecommunications components. Using an SQL-centric framework, the modules are built. Interfaces from Excel to Oracle provided with Perl and PL/SQL. Tests with SQL and Perl.
  • Systems and technologies used: UNIX, Windows, Oracle, SQL, PL/SQL, Perl, Excel, TWiki, SVN.
Jan 2010 - Feb 2011
2 months

Consulting

Softwarehaus

  • Implementation of ETL processes within marketing processes in the automotive sector.
  • Systems and technologies used: UNIX, Windows, Oracle, SQL, PL/SQL, Informatica Powercenter 8.6, Perl, SVN.
Jan 2009 - Aug 2010
8 months

Consulting

Softwarehaus

  • Implementation and configuration of browser-based applications supporting rollout projects in telecommunications. Modules built using an SQL-centric framework. Interfaces and reports in Excel and XML based on SQL. Tests with SQL and Perl.
  • Systems and technologies used: UNIX, Windows, Oracle, SQL, PL/SQL, Perl, JavaScript, HTML, TWiki, SVN, XML, XSLT.
Jan 2009 - Mar 2010
3 months

Consulting

Softwarehaus

  • Implementation and configuration of a browser-based application for inventorying telecommunications components. Using an SQL-centric framework, modules are built. Interfaces from Excel to Oracle provided with Perl and PL/SQL. Tests with SQL and Perl.
  • Systems and technologies used: UNIX, Windows, Oracle, SQL, PL/SQL, Perl, Excel, TWiki, SVN.
Jan 2009 - Jan 2010
1 month

Consulting

Softwarehaus

  • Maintenance of a tool for controlling telephone systems. Bug fixes, data cleansing and extensions using SQL and PL/SQL.
  • Systems and technologies used: UNIX, Oracle, SQL, PL/SQL, SQL*Plus, TWiki, SVN.
Jan 2009 - Jun 2009
6 months

Consulting

Softwarehaus

  • Implementation and configuration of a browser-based order management tool in telecommunications. Modules built using an SQL-centric framework. Interfaces and reports in Excel based on SQL. Tests with SQL and Perl.
  • Systems and technologies used: UNIX, Windows, Oracle, SQL, PL/SQL, Perl, JavaScript, HTML, Excel.
Jan 2009 - Jun 2009
6 months

Consulting

Softwarehaus

  • Implementation and configuration of a browser-based tool supporting rollout projects in telecommunications. Modules built using an SQL-centric framework. Interfaces and reports in Excel based on SQL. Tests with SQL and Perl.
  • Systems and technologies used: UNIX, Windows, Oracle, SQL, PL/SQL, Perl, JavaScript, HTML, Excel.
Jan 2008 - Apr 2008
4 months

Consulting

Data center

  • Implementation of data reconciliation from total bank inventories with operator database data. The reconciliation is implemented as a Unix application in C/C++ with ESQL accesses to DB2.
  • Systems and technologies used: C/C++, UNIX, DB2 V9.
Jan 2008 - Feb 2008
2 months

Consulting

Softwarehaus

  • Implementation and configuration of a browser-based tool supporting rollout projects in telecommunications. Modules built using an SQL-centric framework. Interfaces and reports in Excel based on SQL. Tests with SQL and Perl.
  • Systems and technologies used: UNIX, Windows, Oracle, SQL, PL/SQL, Perl.
Jan 2007 - Sep 2007
9 months

Consulting

Data center

  • Implementation of data supply from bank message files into an operator database within legal requirements. For runtime optimization, data supply implemented in C/C++ with ESQL accesses to DB2 as UNIX applications. Tests with SQL.
  • Systems and technologies used: C++, ESQL, DB2 V9, UNIX.
Jan 2007 - Feb 2007
2 months

Consulting

Bank

  • Implementation of data migration for credit card supplies. Migration implemented via Informatica workflows. Tests with SQL on Oracle.
  • Systems and technologies used: Informatica Powercenter, Oracle 10g, SQL Navigator, UNIX.
Jan 2007 - Jan 2007
1 month

Consulting

Bank

  • Testing of data supplies from country subsidiaries into a central corporate database. Tests of Informatica workflows using SQL on Oracle.
  • Systems and technologies used: Informatica Powercenter, Oracle 9i, SQL Navigator, UNIX.
Jan 2005 - Mar 2006
3 months

Consulting

Bank

  • Implementation of data supplies from country subsidiaries into a central corporate database. Supplies created as Informatica workflows heavily based on SQL. Tests with SQL.
  • Systems and technologies used: Informatica Powercenter, Oracle 9i, SQL Navigator, UNIX.
Jan 2005 - Feb 2006
2 months

Consulting

Industrial company

  • Implementation of Windows services for receiving and sending data.
  • Systems and technologies used: C#, Windows Server 2003.
Jan 2005 - Feb 2006
2 months

Consulting

Industrial company

  • Integration of various communication partners and types; monitoring connections.
  • Systems and technologies used: Gedas RvsXp, IIS, MS SQL Server, MS BizTalk Server, Windows Server 2003.
Jan 2005 - Jan 2006
1 month

Consulting

Industrial company

  • Design and implementation of document reception via web server.
  • Systems and technologies used: C#, IIS, Windows Server 2003.
Jan 2005 - Jan 2006
1 month

Consulting

Industrial company

  • Design and implementation of data exchange for freight invoices in Edifact format.
  • Systems and technologies used: EDIdEv, C#, MS SQL Server, Windows Server 2003.
Jan 2005 - Jan 2006
1 month

Consulting

Industrial company

  • Design and implementation of data exchange in VDA format (supply call-off).
  • Systems and technologies used: C#, MS BizTalk Server 2004, MS SQL Server, Windows Server 2003.
Jan 2005 - Jan 2006
1 month

Consulting

Data center

  • Implementation of data supply from bank message files into an operator database within legal requirements. For runtime optimization, data supply implemented in C/C++ with ESQL accesses to DB2 as UNIX applications. Tests with SQL.
  • Systems and technologies used: C++, ESQL, DB2 V9, UNIX.
Jan 2004 - Jan 2006
1 year 1 month

Consulting

Industrial company

  • Design of interface for exchange of credit memos in VDA format.
  • Systems and technologies used: C#, MS BizTalk Server 2004, MS SQL Server.
Jan 2004 - May 2005
5 months

Consulting

Industrial company

  • Design and implementation of data exchange between different partners (supplier–customer) in VDA format (delivery notes, supply call-offs).
  • Systems and technologies used: C#, MS BizTalk Server 2004, MS SQL Server, Windows Server 2003.
Jan 2004 - Mar 2005
3 months

Consulting

Bank

  • Implementation of data supply (master data) to CRM system from ODS.
  • Systems and technologies used: SQL, PL/SQL, Oracle, Informatica, Windows XP, UNIX, Shell, FTP, SFTP, SSH.
Jan 2004 - Mar 2005
3 months

Consulting

Bank

  • Extension of data supply implementation for external payments from ODS.
  • Systems and technologies used: SQL, PL/SQL, Oracle, Informatica, Windows XP, UNIX, Shell, FTP, SFTP, SSH.
Jan 2004 - May 2004
5 months

Consulting

Bank

  • Implementation of data supply to credit card system from ODS.
  • Systems and technologies used: SQL, PL/SQL, Oracle, Informatica, Windows XP, UNIX, Shell, Connect:Direct, SSH.
Jan 2004 - Mar 2004
3 months

Consulting

Bank

  • Implementation of data supply to CRM system from ODS.
  • Systems and technologies used: SQL, PL/SQL, Oracle, Informatica, Windows XP.
Jan 2004 - Mar 2004
3 months

Consulting

Bank

  • Implementation of data supply for external payments from ODS.
  • Systems and technologies used: SQL, PL/SQL, Oracle, Informatica, Windows XP.
Jan 2004 - Jan 2004
1 month

Consulting

Bank

  • Maintenance of legacy systems.
  • Systems and technologies used: Visual Basic, SQL, Windows NT.
Jan 2003 - Jun 2003
6 months

Consulting

Bank

  • Implementation of data supply to ODS from leasing system.
  • Systems and technologies used: SQL, PL/SQL, Oracle, Informatica, Windows NT, UNIX, Shell, FTP, Erwin.
Jan 2003 - Mar 2003
3 months

Consulting

Bank

  • Implementation of account data exchange between ODS and the DWH staging area.
  • Systems and technologies used: SQL, PL/SQL, Oracle, Informatica, Windows NT, UNIX.
Jan 2003 - Mar 2003
3 months

Consulting

Bank

  • Testing and implementation of master and account data between legacy system and ODS.
  • Systems and technologies used: SQL, PL/SQL, Oracle, Informatica, Windows NT, UNIX, Erwin.
Jan 2002 - Aug 2002
8 months

Consulting

Softwarehaus

  • Maintenance and further development of a CRM system, including technical project management.
  • Systems and technologies used: SQL, UDB V6, C++ (MSVC), Windows NT, OS/2.
Jan 2002 - Feb 2002
2 months

Consulting

Bank

  • Testing and implementation of master data exchange between legacy system and ODS (Object Data Store).
  • Systems and technologies used: SQL, PL/SQL, Oracle, Informatica, Windows NT, UNIX.
Jan 2002 - Feb 2002
2 months

Consulting

Softwarehaus

  • Maintenance and further development of a CRM system.
  • Systems and technologies used: SQL, UDB V5.2, C++ (MSVC), Windows NT, OS/2.
Jan 2001 - May 2001
5 months

Consulting

Softwarehaus

  • Design and implementation of helper classes (DB access, GUI) within the servlet environment.
  • Systems and technologies used: JDK 1.2, JRun, JDBC, SQL, Swing, Windows NT.
Jan 2001 - Apr 2001
4 months

Consulting

Softwarehaus

  • Design and realization of a customer contact service considering existing data models.
  • Systems and technologies used: UML, Java, SQL, Erwin.
Jan 2001 - Mar 2001
3 months

Consulting

Softwarehaus

  • Optimization of a selection tool.
  • Systems and technologies used: SQL, UDB V5.2, C++ (MSVC), Windows NT, OS/2.
Jan 1999 - Mar 2000
3 months

Consulting

Softwarehaus

  • Specification and implementation of an interface DLL between a credit processing application and a customer advisory system.
  • Systems and technologies used: OOA, C, ODBC, UDB-CLI, Windows NT, OS/2.
Jan 1999 - Mar 2000
3 months

Consulting

Softwarehaus

  • Integration of a data warehouse tool into a customer advisory system.
  • Systems and technologies used: SQL, COGNOS, Windows NT.
Jan 1999 - Mar 2000
3 months

Consulting

Softwarehaus

  • Extension of a customer advisory system (specification, implementation).
  • Systems and technologies used: C++, SQL, UDB, Windows NT, OS/2.
Jan 1999 - Feb 2000
2 months

Consulting

Softwarehaus

  • Optimization of a marketing campaign management system.
  • Systems and technologies used: SQL, UDB V5.2, C++ (MSVC), Windows NT, OS/2, RTS-GUI.
Jan 1999 - Jan 2000
1 month

Consulting

Softwarehaus

  • Specification of a 'delete advisor' functionality.
  • Systems and technologies used: OOA, OOD.
Jan 1998 - May 1999
5 months

Consulting

Softwarehaus

  • Extension of a customer advisory system.
  • Systems and technologies used: C++, SQL, RTS-GUI, Oracle, Windows NT, Windows 3.11, OS/2.
Jan 1998 - Mar 1999
3 months

Consulting

Softwarehaus

  • Development of a marketing campaign management system (data modeling, specification, implementation, coaching).
  • Systems and technologies used: C++, SQL, UDB, Windows NT, OS/2.
Jan 1998 - Mar 1999
3 months

Consulting

Softwarehaus

  • Adaptation and extension of a tool for generating selections.
  • Systems and technologies used: SQL, C++, UDB, Windows NT, OS/2.
Jan 1998 - Jan 1999
1 month

Consulting

Softwarehaus

  • Development of reports for credit advisory.
  • Systems and technologies used: C++, RTS-GUI, Windows NT.
Jan 1998 - Mar 1998
3 months

Consulting

Softwarehaus

  • Development of a contact recording system within a customer advisory system (data modeling, specification, realization).
  • Systems and technologies used: C++, SQL, RTS-GUI, Oracle, Windows NT, Windows 3.11, OS/2.
Jan 1998 - Feb 1998
2 months

Consulting

Softwarehaus

  • Development of a system for planning and executing marketing campaigns.
  • Systems and technologies used: C++, SQL, RTS-GUI, Oracle, Windows NT, Windows 3.11, OS/2.
Jan 1998 - Feb 1998
2 months

Consulting

Softwarehaus

  • Optimization of a client-server application in a 64-bit environment (design, specification, implementation, testing).
  • Systems and technologies used: C++, SQL, RTS-GUI, Oracle, Windows NT, Windows 3.11, OS/2.
Jan 1998 - Feb 1998
2 months

Consulting

Softwarehaus

  • Implementation of the Euro conversion in a customer advisory system.
  • Systems and technologies used: C++, SQL, RTS-GUI, Oracle, Windows NT, Windows 3.11, OS/2.
Jan 1997 - Dec 1998
2 years

Consulting

Softwarehaus

  • Implementation of authorization profiles for users of a customer advisory system.
  • Systems and technologies used: C++, SQL, RTS-GUI, Oracle, Windows NT, Windows 3.11, OS/2.
Jan 1997 - Nov 1997
11 months

DB Development

Hardware and software manufacturer

  • Design of multithreading capability for a relational database system.
  • Systems and technologies used: C, Assembler, Windows NT, BS2000.
Jan 1996 - Dec 1997
1 year

DB Development

Hardware and software manufacturer

  • Design and implementation of replication within a relational database system.
  • Systems and technologies used: C, Unix, Windows NT, BS2000.
Jan 1994 - Dec 1995
1 year

DB Development

Hardware and software manufacturer

  • Design and implementation of ALTER TABLE functions within a relational database system.
  • Systems and technologies used: C, Unix, Windows NT, BS2000.
Jan 1993 - Dec 1994
1 year

DB Development

Hardware and software manufacturer

  • Maintenance of CREATE INDEX functions within a relational database system.
  • Systems and technologies used: C, Unix, Windows NT, BS2000.
Jan 1992 - Dec 1993
1 year

DB Development

Hardware and software manufacturer

  • Design and implementation of transaction functionality for DDL statements within a relational database system.
  • Systems and technologies used: C, Unix, Windows NT, BS2000.
Jan 1992 - Dec 1992
1 year

DB Development

Hardware and software manufacturer

  • Design and implementation of database buffering for DDL statements within a relational database system.
  • Systems and technologies used: C, Unix, BS2000.
Jan 1991 - Jun 1991
6 months

DB Development

Hardware and software manufacturer

  • Maintenance of authorization functions within a relational database system.
  • Systems and technologies used: Assembler, UNIX, BS2000.
Jan 1990 - Dec 1992
2 years

DB Development

Hardware and software manufacturer

  • Design and implementation of a task framework for service tasks within a relational database system.
  • Systems and technologies used: C, Unix, BS2000.

Summary

  • 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 management: 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, OOP 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

Languages

German
Native
English
Advanced

Education

Oct 1986 - Jun 1990
Lorem ipsum dolor sit amet

Dipl.-Inform. (FH) · Computer Science · Germany