Josef Schermer
DevOps
Experience
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Industries Experience
See where this freelancer has spent most of their professional time. Longer bars indicate deeper hands-on experience, while shorter ones reflect targeted or project-based work.
Experienced in Information Technology (14 years), Banking and Finance (13 years), Automotive (9 years), Manufacturing (7 years), and Telecommunication (7 years).
Business Areas Experience
The graph below provides a cumulative view of the freelancer's experience across multiple business areas, calculated from completed and active engagements. It highlights the areas where the freelancer has most frequently contributed to planning, execution, and delivery of business outcomes.
Experienced in Information Technology (31 years), Business Intelligence (23 years), Product Development (13 years), Project Management (6 years), Human Resources (4 years), and Quality Assurance (3 years).
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
Languages
Education
Diploma in Computer Science (FH) · Computer Science
Profile
Frequently asked questions
Do you have questions? Here you can find further information.
Where is Josef based?
What languages does Josef speak?
How many years of experience does Josef have?
What roles would Josef be best suited for?
What is Josef's latest experience?
What companies has Josef worked for in recent years?
Which industries is Josef most experienced in?
Which business areas is Josef most experienced in?
Which industries has Josef worked in recently?
Which business areas has Josef worked in recently?
What is Josef's education?
What is the availability of Josef?
What is the rate of Josef?
How to hire Josef?
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
Similar Freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a DevOps
Nearby freelancers
Professionals working in or nearby Munich, Germany