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

Similar Freelancers

Discover other experts with similar qualifications and experience

Verified Expert

David Reitz