Projects

Key projects: listed here are the most important projects in which I worked. Beyond this there was a variety of smaller consulting assignments which lasted between one and 20 days.

2021-2024: Migration and upgrade of an Oracle Forms and Reports installation

Planning and rebuilding of highly available Oracle Forms and Reports environments (dev, test, acceptance, production) on RHEL (Red Hat Enterprise Linux). Transfer of the configurations from the AIX-based legacy systems. Configuration of OHS (Oracle http Server) proxies. Integration of an Active Directory system, configuration of SSL. Migration, deployment and testing of several legacy applications. Conducting error analyses and providing solutions. Creation of a patch plan for all components of the Forms and Reports installation and patching of several systems.

Client: German logistics and postal company

Role: Consultant

Technology: Oracle Forms and Reports Version 12.2.1.4, Oracle HTTP Server, Python, bash, Oracle Database 19c Enterprise Edition, SVN, Git, Java 1.8.0, Oracle Weblogic Server 12.2.1.4.0

Result: Provisioning of several Oracle Forms and Reports environments until production takeover. Migration of the old applications to the new system. Creation of a patch plan and patching of all components. The live scripting method was used for setup and documentation.

2021/2022: Planning, setup and configuration of Oracle Service Bus environments

Planning and rebuilding of highly available Oracle Service Bus environments (dev, test, acceptance, and production) in version 12.2.1.4. Transferring the configurations from the legacy systems, security configurations for SSL, SOAP and WS-Security. Creating and deploying OSB projects. Design and creation of an OSB development environment.

Client: Public administration in Liechtenstein

Role: Consultant

Technology: Oracle Service Bus 12.2.1.4, SAML 2.0 and WS-Security with OWSM (Oracle Webservices Manager), Apache HTTP Server, Python, bash, SOAP/REST, Jenkins Continuous Integration Server, SVN, Git, and Oracle JDeveloper.

Result: Provision of several Oracle Service Bus environments, including migration and deployment of OSB projects from the legacy systems. Provision of a development environment for OSB projects. The live-scripting method was used for setup and documentation.

2021/2022: Migration and upgrade of an Oracle Forms and Reports installation

Planning and rebuilding of highly available Oracle Forms and Reports environments (dev, test, acceptance, production) on RHEL (Red Hat Enterprise Linux). Transfer of the configurations from the AIX-based legacy systems. Configuration of OHS (Oracle HTTP Server) proxies. Integration of an Active Directory system, implementation of SSL configurations. Migration, deployment and testing of several legacy applications. Performing error analysis and solution  deployment.

Client: German logistics and postal company

Role: Consultant

Technology: Oracle Forms and Reports Version 12.2.1.4, Oracle HTTP Server, Python, bash, Oracle Database 19c Enterprise Edition, SVN, Git

Result: Provision of several Oracle Forms and Reports environments until production rollout. Migration of the old applications to the new system. The live-scripting method was used for setup and documentation.

2021: Landing Zone on AWS – Quick Start – Consulting and Implementation

Development of two offer packages: “Landing Zone on AWS – Quick-Start – Consulting and Implementation”.

Partner: Amazon Partner Network

Role: Conception, implementation, test, documentation

Technology: AWS Control Tower, AWS Organizations, AWS Service Catalog, AWS Single Sign-on, AWS Config, AWS CloudFormation, Amazon CloudWatch, AWS CloudTrail, AWS Identity and Access Management, Amazon Simple Storage Service, Amazon Simple Notification Service, AWS Lambda, AWS Step Functions, AWS CodeCommit, AWS CodePipeline, Amazon Simple Queue Service, AWS Key Management Service

Results: Two service packages for hands-on entry into a secure, scalable AWS environment with multiple accounts, the foundation of a landing zone on AWS, using a pre-built PoC concept and a portfolio of different extensions, customizable to each customer’s needs.

2020: Professional Development – Amazon AWS Certification

Client: internal

Technology :Amazon Web Services: multiple AWS Services.

Results: Certification as an AWS Solutions Architect Associate. 2020 Open Source Project – Life-Scripting

Technology: Emacs 27, Org-Mode, Lisp, HTML, AWS-S3, Git-Hub

Results: Live scripting is an approach to combine work in IT projects, documentation and reuse. It involves documenting work on the command line while it is being executed (github.com/andreaswittmann/live-scripting)

2019: Migration Oracle Service Bus from OnPremise to AWS Cloud

Migration of highly available Oracle Service Bus environments (dev, test, acceptance, production), version 11.1.1.9 OnPremise to version 12.2.1.3 in the AWS Cloud, automated, replicable and versioned

Client: International logistics group

Role: Conception, implementation, documentation, DevOps

Technology: Oracle Service Bus 12.2.1.3, Saltstack, WLST, Python, bash, GitLab CI/CD, SOAP/REST, Jira/Confluence, AWSCloudFormation,AWSIdentityandAccessManagement, Amazon Simple Storage Service, Amazon EC2, Amazon Elastic Block Store, Amazon Elastic File System, Amazon Data Lifecycle Manager, Amazon Relational Database Service (RDS)

Results: Design and development of automated functional and connection tests based on GitLab CI/CD (continuous integration/continuous deployment). Concept and implementation of automated patch processes for EC2 instances with AWS Maintenance Window. Analysis and elimination of security vulnerabilities for EC2 environments. Preparation and support of the migration from Oracle Service Bus to the AWS Cloud.

2018: Further development of the infrastructure for the operation of Oracle Service Bus and Oracle Weblogic

Client: International logistics group

Role: Conception, implementation, documentation, DevOps

Technology: Salt Stack, Core OS ETCD 3.2, Python, GIT, AWS SSM (Simple System Management), Parameter Store, Boto3 (AWS Python API), Java 7, Java 8, Weblogic Server 10 und 11, Oracle Service Bus 11/12

Result: Design and development of a secure password management for the automatic provisioning of operating environments. Design and implementation of a multi-user development environment for Salt Stack including version control and branching model. Analysis and elimination of security vulnerabilities for various Weblogic and Oracle Service Bus environments.

2017: Further development of the infrastructure for the operation of Oracle Service Bus and Oracle Weblogic

Client: International logistics group

Role: Conception, implementation, documentation, DevOps

Technology: Salt Stack, Python, Java 7, Java 8, Weblogic Server 10 und 11, Oracle Service Bus 11/12

Result: Requirement analysis and conception of a cross-platform and cross-technology monitoring system based on Elastic Search, Kibana and Grafana. Documentation for the security management of Weblogic Server and Oracle Service Bus environments. Migration of an Oracle Service Bus environment from OSB 11 to OSB 12.

2015-2017: Building an SOA infrastructure

Client: German Insurance Group and Building Society, Koblenz

Role: Consultant

Technology: Weblogic Server 12, Oracle Service Bus 12, Python, SOAP/REST

Result: Creation of an architecture for the highly available operation of Weblogic server environments. Extension of a library for the automated provisioning of Weblogic Server environments. Design and implementation of an improved deployment procedure for Java Enterprise applications. Development of highly available Oracle Service Bus domains.

 
2015: IT Security Workshop

Client: German Insurance Group and Building Society, Koblenz

Role: Consultant

Technology: Weblogic Server 12, Oracle SOA Suite 12

Result: Preparation and delivery of a workshop on “Web Single Sign-on with SAML 2.0” and “WS- Security with OWSM (Oracle Webservices Manager)” including lecture, demonstration and exercises.

2013-2015: Migration of an existing customer solution into a highly available Enterprise Service Bus platform

Client: International logistics group

Role: Consultant

Technology: Oracle Weblogic Server 10.3, Oracle Service Bus 11gR1, SUSE Linux Enterprise Server 11, IBM WebSphere MQ V7.0, Oracle Database 11g, Python, SOAP/REST

Result: Architecture, design, implementation and execution of high availability tests for an enterprise service bus and messaging platform based on Oracle OSB, Oracle WLS and Java Messaging Service. Evaluation and adaptation of the original architecture. Implementation and deployment of custom solution to improve overall system availability. Creation and tracking of Oracle support cases.

2012: Professional Development – Subject: Identity Management

Customer: internal

Technology: Oracle Identity and Access Management (11.1.1.5), Oracle SOA Suite 11g (11.1.1.6.0), Oracle Weblogic Server 10.3.6, Java SE Development Kit 6 Update 33, Oracle JDeveloper 11g (11.1.1.6.0) Studio Edition, Oracle Identity Manager Connector MS AD User Management 11.1.1.5.0, Oracle Database 11g, Release 2, Oracle Virtual Box 4.1.22, Oracle Enterprise Linux 5.8, Microsoft Windows Server 2008 R2, Microsoft Windows 8 Professional

Result: Installation and evaluation of Oracle Identity Manager, creation of an installation tutorial. Installation and analysis of the Oracle Active Directory Connector, authoring of a workshop on the installation and use of the Connector.

2012: WLS Workshop

Customer: IT service provider for the municipal administration, Berlin

Role: Consultant

Technology: Oracle Weblogic Server 12

Result: Accompaniment of a workshop on WLS in the context of a WLS training course

2012: Professional Development – Subjects: Oracle Forms and Reports

Client: internal

Technology: Oracle Weblogic Server 10.3.6, Oracle Forms and Reports 11g Release 2, Oracle Database Express Edition 11g Release 2, Oracle Linux Release 5.8, Oracle SQL Developer 3.1

Result: Training on Oracle Forms and Reports, installation on Windows 7 and on Virtual Box, inclusive database and development tools. Development of a “Quickstart Guide”.

2012: Professional Development – Subjects: WLS12c, Eclipse, Virtual Box, SAML, SSO, WS-Trust

Client: internal

Technology: Oracle Weblogic Server 12c, Oracle Enterprise Pack for Eclipse 12.1.1, Virtual Box 4.1, Oracle Enterprise Linux 5.8, Oracle Enterprise Linux 6.3

Result: Evaluation of new features in WLS12c and Enterprise Pack for Eclipse, creating and analyzing a single-sign-on scenario, based on SAML and WS-Trust. Evaluation of Oracle Virtual Box and Oracle Enterprise Linux as basis for a lab environment.

2011: Develop a business process management platform for foreign delegations

Client: International listed technology group, Erlangen

Role: Consultant

Technology: Oracle Weblogic Server 10.3, Oracle JRockit 1.6 R28, Jython, SUSE Linux Enterprise Server 11, Entrust GetAccess Entitlement System, Oracle Business Process Management Suite 11g

Result: Integration of Oracle Business Management Suite into the customer‘s own entitlement system, based on SAML (Security Assertion Markup Language) and SSO (Single Sign On). Configurations of test and production systems, auto-start configuration, SSL configuration. Recommendations for further developing the system architecture.

2009-2011: Various projects for J2EE application in rail logistics.

Client: Listed company for railway logistics and wagon hire, Hamburg

Role: Architect, Consultant

Technology: WLS 9.2, WLS 10.3, JRockit 5.0 R28, Jython, Windows Server 2003/2008, Oracle Enterprise Manager 11g, Oracle AD4J 10g (Application Diagnostics for Java)

Result: Installation and evaluation of the products Oracle Enterprise Manager 11g and Application Diagnostics for Java (AD4J 10g and 11g) as part of the project i4R-logistics. Design, build and configure a security solution for an Internet application, based on 2- way SSL. Migration of an ESB solution to WLS 10.3. Analysis of performance problems. Setup of further testing, and production environments. Architecture consulting for the development department. Design and implementation of a standardized load test environment for J2EE projects, conducting load tests. Proof of concept of a Web service connection with WS-Security.

2009: Review of various application platforms, problem analysis and recommendations.

Client: German logistics and postal company

Role: Architect, Consultant

Technology: Weblogic Server 9.2, Weblogic Server 10.2

Role: Review of existing production environment for a variety of application platforms, including projects for a customer card, staff scheduling, PC Postage, IP07 and IP09 Internet platforms. Analysis of acute problems and solutions. The summary of the review resulted in a best-practices document. Proposal for the standardization of operating environments.

2008-2009: Various projects for J2EE application in rail logistics.

Client: Listed company for railway logistics and wagon hire, Hamburg

Role: Architect, Consultant

Technology: WLS 9.2, WLS 10.3, JRockit 5.0 R28, Jython, Windows Server 2003

Result: Creating a company-wide standards for the operation of J2EE applications. Definition of quality assurance processes, and takeover of operations. Design and implementation of a solution for operational monitoring of J2EE applications. Concept, architecture and implementation of an automated domain setup. Building of test and production environments. Preparation of an operating manual. Coaching the operations team. Troubleshooting and architecture consulting in development.

2008-2009: Operational Support

Client: International trading and services group, Hamburg

Role: Architect, Consultant

Technology: WLS 8.1, WLS 9.2, WLS 10, Apache Webserver (Diverse Versionen), JRockit 5.0 R27, R28, Oracle RAC 10i, Jython, Trac, Suse Enterprise Linux, HP-UX

Result: Corporate wide support for the operation of all productive WLS applications, coaching in the area of WLS administration, analysis and solution of production problems, proposals and implementation of measures to improve production reliability and quality assurance of J2EE applications. Introduction of an internal department wiki – and ticket system for tracking and documenting problem solutions.

2008: J2EE application for planning and monitoring in international railway logistics.

Client: Listed company for railway logistics and wagon hire, Hamburg

Role: Architect, Consultant

Technology: WLS 9.2, JRockit 5.0 R28, Jython, Windows Server 2003

Result: Review of the operating environment, implementing a solution for automatically rebooting WLS domains. Architectural proposals for scalable and highly available J2EE applications for future projects. Concept for a standardized load test environment.

2008: Workshops for the Migration of J2EE Applications

Client: Swedish energy company operating throughout Europe

Role: Consultant, Lecturer

Technology: Weblogic Workshop WLW 8.1, WLW 10.0, Eclipse 3.0, WLS 10.0, Weblogic Diagnostic Framework (WLDF)

Result: Preparation and delivering a workshop for migrating J2EE applications in WebLogic Workshop and JMX-based monitoring of J2EE applications.

2007: J2EE application to support sales with mobile phone contracts.

Client: Internationally active utility company, Oldenburg

Role: Consultant

Technology: WLS 9.2, Solaris 10

Result: Problem solving and analysis of WLS cluster communication and load balancing. Introduction of a JMX-based monitoring. Configuration of administration channels and Nodemanager. Review of the production environment.

2007:  Migrating of a legacy J2EE application, more than 200 individual modules were migrated to a 64-bit platform.

Client: International trading and services group, Hamburg

Role: Architect, Consultant

Technology: WLS 8.1, WLS 9.2, WLS 10, JRockit 5.0 R27, Oracle RAC 10i, Jython

Result: Design, architecture and implementation of an automated domain setup and an automated application redeployment, including the configuration of all required resources. Setup of test and production environments. Preparation of an operating manual. Running integration tests and preparation for productive launch of the system.

2007: J2EE application to support the bank branch network business.

Client: Hamburg-based private bank with international special financing for transport and real estate

Role: Consultant

Technology: Windows Server 2003, WLS 8.1, WLS 9.2

Result: Problem analysis and solution of load distribution. Concept and configuration of a boot- fixed deployment architecture. Setup of the production environment.

2007:  The project implements a software solution to support the purchasing department.

Client: International trading and services group

Role: Architect, Consultant

Technology: BEA WLS BEA WLS 9.2, Oracle 10i, Python, Spring, Synergy, Ant, Perl, Kodo

Result: Writing an operating manual. Production launch and handover to operations. Setting up a Linux-HA (high availability) solution. A scalable architecture for a batch framework, based on J2EE, Spring, and WLS-cluster technology. Design and implementation of a dynamic logging system with Log4J and JMX. Configuration of the cluster-wide object- persistence layer. (Kodo JDO with remote commit provider).

2006:  Sabbatical with trips to South America and Antarctica, participation in Spanish language courses, creation of a documentary film.
2004 – 2005: NOA 8: Development of a framework for batch processing in J2EE, migration of existing batch processes.

Client: International trading and services group, Hamburg

Role: Architect, Consultant, Team leader

Technology: BEA WLS 7.0, BEA WLS 8.1, Oracle 9i, Grinder load testing tool, Synergy, Ant, Perl

Result: Design of a J2EE architecture for batch processing. Definition of the system architecture for a batch framework. Setup of load-testing, integration-testing, and production environments. Performance analysis and optimization. Consulting for all BEA products used. Concept for productive system launch. Execution of the productive system launch and production control.

2002-2003: NOA 2 (major project, up to 200 employees) Implementation and extension of the modules of NOA1

Client: International trading and services group, Hamburg

Role: Architect, Consultant, Team leader

Technology: BEA WLS 7.0, BEA WLS 8.1, Oracle 9i, Grinder load test tool, CVS, Synergy, Ant, Perl

Result: Automated setup of WLS domains and test environments. Architecture, planning, implementation and testing of fail-over mechanisms. Architecture, planning and execution of load tests. Design and setup of a 7×24 production environment with corresponding productive launch and update mechanisms. Consulting for all BEA products used. Monitoring of all project phases, including production takeover and production control.

2002-2003: NOA 1 Project to redesign the corporate-wide customer management modules: product management, order processing, accounting, inventory control, processing of written orders and processing of returned goods.

Client: International trading and services group, Hamburg

Role: Architect, Consultant, Team leader

Technology: BEA WLS 7.0, BEA WLS 8.1, Oracle 9i, Grinder load test tool, CVS, Synergy, Ant, Perl

Result: Design of an architectural framework, development of migration concepts, prototyping, design and implementation of breakdown and load testing.

2002: Competitive Benchmark

Client: Listed international software group

Role: Architect, project management, implementation and

Technology: HP Superdome, HPUX 11i, Oracle 9.2.0.1.0, BEA WLS 7.0, BEA WLS 6.5.1, Mercury LoadRunner 7.5.1, IBM P690, AIX 5L

Result: Design, planning and implementation of a custom J2EE-load test. Execution of the test at the IBM Test Center in Montpellier, France, and at the HP Test Center in Boeblingen, Germany.

2002: Creating the architecture for a new version of enterprise-wide order processing (call center application)

Client: International trading and services group, Hamburg

Role: Architect, Developer, Team leader

Technology: BEA WLS, Tuxedo, Jolt, JBuilder, CVS, Visio

Result: Support in all phases of the project i.e. design, development, test, integration, and consolidation of results. Requirements analysis and modeling of use cases, architecture and design based on the Rational Unified Process (RUP). Integration of existing information models to the UML-based OOSE process. Leading of a project team.

2001: Developing a prototype J2EE application for order processing as a feasibility study, with focus on the architectural aspects of the legacy system integration, based on “Real Time RTOS”.

Client: International trading and services group, Hamburg

Role: Architect, Developer, Team leader

Technology: BEA WLS, Tuxedo, Jolt, JBuilder, CVS, Visio

Result: Proof of the scalability and exemplary analysis of security features.

2000-2002: Creation of an end customer application for construction financing on a J2EE

Client: German financial services provider, Hameln

Rolle: Senior Consultant, Trainer

Technology: BEA WLS, Netscape Enterprise Server

Result: Review of the application and the project, creating a multi staged procedure for productive launch of the system, general project consulting, customization and delivering of J2EE developer trainings.

2000: EJB pilot project with a focus on “Rapid Application Development”.

Client: Large Swiss bank, Zurich

Role: Architect, Senior Consultant

Technology: BEA WLS

Result: Problem analysis and solutions in the field of RMI/IIOP. Architectural consulting with a focus on scalability and high availability of a WLS-based system.

2000-2001: Development of a web portal named „Business Channel“.

Client: Major publishing house operating throughout Europe, Hamburg

Role: Senior Consultant

Technology: BEA WLS

Role: Consulting during the test, integration, and delivery phase. Productive launch of a clustered WLS system.

2000: Development of a WebShopping J2EE application.

Client: German mail order company for advertising material

Role: Senior Consultant

Technology: BEA WLS

Result: Review, analysis of problems and solutions.

1998-2000: Development of an application framework based on CORBA, C++ / Java.

Client: German financial services provider for savings banks, Hanover

Role: Senior Consultant

Technology: BEA Weblogic Enterprise, Tuxedo, eLink for SNA

Result: Consulting for BEA products. Problem analysis. Installation of WLE on Solaris, NT and OS/390. Establishment of a corporate performance and benchmark group. Development of architectural prototypes. Enterprise-wide management of BEA support cases.