Further development and maintenance of a company-wide monitoring database

• Maintenance of a company-wide Oracle database that consolidates information from various internal databases, Active Directory and other systems

• Data transfer via Oracle jobs between the monitoring DB and other systems

• Data visualization and manipulation using APEX and Oracle Forms (the latter is being replaced by APEX)

• Gathering requirements from the business units

• Designing the implementation

• Implementing at the database level and in APEX

• System maintenance

• Troubleshooting

Technologies: Oracle 12, Oracle 19, Oracle PL/SQL, Oracle APEX, SQL Developer

• Programming a comprehensive dynamic ESG report for portfolio management

• Working as the sole developer in collaboration with the business unit

• Core technology: Seismic plug-in for MS PowerPoint

• Optimizing and fixing existing Seismic reports

• Implementing the static report design

• Implementing and optimizing the requirements in consultation with the business unit

• Analyzing existing data structures

• Developing database queries

• Creating Excel models for data aggregation

• Programming the dynamic Seismic elements for data visualization

• Testing and documentation

Technologies: Seismic, SQL, MS Excel, MS PowerPoint

• Assisting in the development of various concepts and software implementations related to storage management solutions

• Developing permission concepts for databases with storage analysis features

• Supporting data migration projects

• Creating guidelines for the offshore team in India and progress tracking

• Optimizing the technical backend for order-to-cash and delivery processes

• Modeling analysis processes with Transact-SQL and PowerShell

• Creating data analyses with Transact-SQL

Technologies: MS SQL Server, Transact-SQL, PowerShell, SCRUM, JIRA, Adonis

• Redesign of existing X4 interfaces (SWIFT, EDIFACT) to and from information service providers

• Reproduction of the interfaces as PowerShell scripts

• Standardization of legacy designs without code dependencies

• Analysis of the existing X4 interfaces

• Analysis and redesign of ETL processes

• Design of new interfaces with central error logging and code independence

• Implementation proposals

Technologies: X4, PowerShell, ETL, SWIFT, EDIFACT

• Coordination tasks between business departments and external SAP consultants

• User support in the SAP environment

• Programming data analyses to support the annual inventory

• Support of SAP users

• Coordination between business units and SAP consultants

• Data analysis of SAP data

• Customization of SAP mail merge functionalities

Technologies: SAP, VBA, MS Access, MS Excel

• Supporting designers in the Electronic Design Automation team by automating recurring tasks

• Automation of data archiving including concept, programming, integration and tests for data consistency

• Analysis of EDA data on component usage during failure analysis

• Creation of various statistics in the EDA design area

Technologies: Oracle, MS Access, Perl, Python, sh/csh, SQL, ER modeling, TCL, Cadence

• Interface development for bidirectional data exchange between logistics and inventory databases and customers (EDIFACT, FORTRAS and custom formats)

• Embedding the interfaces into in-house processing and synchronization

• Programming small helper programs for accounting, sales and controlling

• Reporting and intranet analyses with output in Excel, HTML and print

• Design and programming of extensive Perl libraries for standardizing database access, GUI development and output

• Building permission structures for reporting based on database roles

• Automation scripts on servers for time-based analyses and data monitoring with alerts

• Design and implementation of a data warehouse system and related ETL processes for mass data and nightly processing in Informix

Technologies: ER modeling, HTML, Informix, JavaScript, Shell scripting, Linux, MySQL, Perl, PHP, sh/csh, SQL, ETL, VB/VBA, EDIFACT, FORTRAS, QlikView

• Development of a knowledge database including requirements gathering, design/modeling and implementation in Postgres

• Creation of an authorization concept and frontend development

• Testing, documentation and deployment

• Maintenance and further development of the application

• Coordinating change and enhancement requests

• Installation of a bug tracking system (iTracker)

• Reviewing changes and updating documentation

Technologies: ER modeling, Oracle, MS Access, Postgres, SQL