Helmut Heidel
Dipl.Math.Univ.
Persönliche Daten
Deutsch (Muttersprache)
Rumänisch (Fließend)
Ungarisch (Fließend)
English (Gut)
Beschreibung
Anlagen
Profil
Helmut Heidel
Dipl.Math.-Univ.
Helmut Heidel
Email:
Mobiltel.: +49-172-6064385
PERSÖNLICHE DATEN
Alter:
52
Staatsangehörigkeit:
Deutsch
Status:
verheiratet
Fremdsprachen:
Englisch, Rumänisch, Ungarisch, Italienisch (B2), Spanisch (A1)
Ausbildung:
1985–1989 Universität Klausenburg (Cluj/Ro), Fachbereich Mathematik
TECHNISCHE KENNTNISSE
Fachliche Schwerpunkte:
Datenbank-Programmierung, Datenbank-Design, Datenbankadministration
Branchen:
Anlagenherstellung, Pharmaindustrie, Touristikbranche, Finanzdienstleistung,
Baudienstleistung, Telekommunikation, Leasing
Betriebssysteme:
MS Windows, HP-UX 10.20, Solaris 2.5/5.8, Linux (Debian, Oracle Enterprise
Linux, RedHat, Suse), IBM AIX 5/6/7
Datenbanken:
ORACLE-RDBMS Version 7, 8 ,9, 10, 11g, 12c
Hardware:
Intel Pentium, HP Serie 9000, SUN Enterprise 3000, IBM
Entwicklungstools:
APEX Version 3/4/5, ORACLE Developer 2000, Discoverer 11.1.1.7
Programmiersprachen:
PL/SQL, SQL, Shell-Scripts, Perl, HTML, XML
Standardsoftware:
MS-Office Professional, OpenOffice
Bisherige Tätigkeiten:
Datenbankprogrammierer, Schnittstellenprogrammierer, Oracle eBusiness-
SuiteTechnischer und Funktionaler Berater, Technischer Projektleiter, Datenbank-
administrator, Dozent für Oracle eBusiness Suite DBA
Profil Helmut Heidel / Mar 2018
1/10
Projekte
10/2012 bis dato
Oracle eBusiness Suite R12, Würth Leasing GmbH & Co. KG, München
Kunde:
Würth Leasing GmbH & Co. KG, Leasingabteilung der Würth GmbH
Position:
Entwickler, Technischer Berater, eBS-Apps-DBA
Aufgaben:
Apex Entwicklung
Web-Anwendung für das PDF-Archiv (Suchmaske über alle eingescannten
Kunden- und Lieferanten-Rechnungen)
Web-Schnittstellen zur Administration von Custom Setups
Web-Anwendung für die Abnahme der Migration (RuP-Oracle)
Anpassungen für Oracle Financials R12
Versenden DTAUS per EMail
AR: Automatisches Update der Zahlungsmethoden und Bankinformationen in
bei den Kunden
Aufsetzen und Einführen SEPA Verfahren
Interfaces für die Module AP, AR, GL
Discoverer EUL Administration
Installation and Administration for Discoverer (vers. 11.1.1.7)
Migration des Discoverer Connection Pools zu einer andern Datenbank
Apps-DBA / Datenbankadministration
Wartung der EBS Instanzen - Produktions- und Entwicklungs-systeme
Patches einspielen
Klonen (RapidClone)
Backup & Recovery
2 x Produktion (Installation und Wartung)
6 x Klones (Entwicklungs- und Testinstanzen)
Datenbankanbindungen via Oracle-Gateway zu IBM DB2 und MS Sql-Server
Migration RuP nach Oracle eBS R12
RuP-System nach Oracle eBusiness-Suite R12 Financials
Stammdaten
◦
Kunden
◦
Lieferanten
◦
Banken
Systemumgebung:
Web-based 3-tier System,
Red Hat Enterprise Linux Server release 6.4 (Santiago)
Windows-Clients/Browser, Oracle Applications Release 12.1.3
Subversion (SVN), Weblogic 10.3.6, Oracle Fusion Middlware 11g, Discoverer 11.1.1.7
Apache Tomcat 8.0
Programmiersprachen:
SQL and PL/SQL, UNIX-Shell-Script
Entwicklungstools:
Oracle APEX 4.2, Oracle SQL-Developer, Jasper Reports v. 4.7.0 – 5.5.0
Oracle BI Discoverer Administrator 11.1.1.7
Datenbank:
ORACLE-RDBMS 10g - 11gR2
Profil Helmut Heidel / Mar 2018
2/10
01/2010 bis dato
Oracle eBusiness Suite R12, DMC Group GmbH, Hallbergmoos
Kunde:
DMC Group GmbH (für einen öffentlichen Auftraggeber)
Position:
eBSuite-DBA, Application Support, Technischer Berater, Entwickler, DBA
Aufgaben:
Oracle DBA / Oracle RDBMS
Datenbankadministration
Installation / Upgrade / Wartung - Oracle RDBMS vers. 8 bis 11gR2
Performance Optimierung
Oracle Apex Administration
Installation & Administration
Oracle APEX Applications
Umfrage/Questionaire für das interne Roadmap
Data-Link (Abstimmungs-Tool) zwischen CR-System und eBusiness-Suite
Staff Commitee Intranet Apps (Personalverteterwahl, Survey)
E2E Management (DB Design und Daten Migration)
Oracle Application Server Support
OAS 10.1.2/10.1.3, OID-OIM 10.1.4, SSO 10g,
Installation & Administration
E-Procurement System
Administration
Performance Optimierung
Document Management System
Installation
Administration
Updates & Deployments
Agency Integrated Management System
Administration
Updates & Deployments
Performance Optimierung
eBusiness Suite Administration (Apps-DBA)
EBS - Oracle Financials
Administration / Support / Wartung / Patching / Klones
Schnittstellenprogrammierung
SingleSignOn & Auditing
EBS - Oracle Financials
Reports and Request Sets
EBS UPGRADE von Release 12.1.3 nach Release 12.2.5
Subversion (Source-Code-Versionsverwaltung SVN)
Setup / Administration
Benutzerverwaltung
Projektadministration
Systemumgebung:
Web-based 3-tier System, AIX 5.3, AIX 6.0, LINUX SUSE 8-10, MS-Windows, VMWare
Windows-Clients/Browser, Oracle Applications Release 12.1.3
Subversion (SVN), Weblogic 10.3.6, Oracle Fusion Middlware 11g, Discoverer 11.1.1.7
Programmiersprachen:
UNIX-Shell-Script, SQL and PL/SQL
Entwicklungstools:
Shell scripts, XML Publisher, APEX 4.0-5.0.4
Datenbank:
ORACLE-RDBMS 8 bis 11gR2
Profil Helmut Heidel / Mar 2018
3/10
01/2007-09/2011
Oracle eBusiness Suite R11i, Comprendium Structured Financing GmbH, München
Kunde:
Comprendium Structured Financing (Deutschland), Leasingunternehmen
Position:
Entwickler, Technischer und Funktionaler Berater
Aufgaben:
Prozessoptimierung / Setup / Reporting / Anpassungen und Support Oracle
Financials R11i Module:
Oracle Debitoren
Kundenmaskenanpassungen mit Forms Personalization
Update Rechnung & Attachement Report (XML/PDF printing)
AutoLockbox: Setup und Anpassungsprogrammierung
Oracle Kreditoren
Automatisierung des Lieferaten-Zahlungsprozesses aus Oracle eBS über
MultiCash/Eurodirect
Hochladen von aktualisierten Bankdaten
Vorläufige- & Endgültige Zahlungsliste, Zahlungsavis (Reports)
Automatisiertes Hochladen von “Inneract”-Rechnungen (Excel/Dataload)
Oracle Hauptbuch (GL)
ADI & FSG Setup / Support
Setup für neue Firma (CPR Structured Finance) (SOB/Calendar/Organization)
Lager und Order Management (Auftragsabwicklung)
Unterstützung bei der Intergration des Moduls “IPMS/ILFS” der Firma LNT
Setup für neue Remarketing Company für eine zentralisiert und automatisierte
Rechnungstellung der Bestellungen aus dem IPMS-System (integrated
portofolio management system)
Cash Management
Laden der Bankauszüge und Abstimmungsprogramme
System Administration
Setup Cloning Prozess mit Comprendium IT Infrastructure
Setup Patch Prozess mit IT Delivery Abteilung (patch wizard)
Setup neues Custom Module für Kundenanpassungen
Setup eBusinessSuite um den Company-Sicherheitsrichtlinien zu entsprechen
Firmenzusammenschluss von 7 Firmen
innerhalb der Deutschen Comprendium Gruppe
Verschmelzung und gleichzeitiger Geschäftsjahreswechsel
Migration R11i nach R12
Oracle EBS Release 12 Installation und Datenmigration
Technische Beratung
Systemumgebung:
Web-based 3-tier System, HP-UX rp4440 B.11.11-11.v3 U 9000/800
Windows-Clients/Browser, Oracle Applications Release 11.5.10
Programmiersprachen:
SQL and PL/SQL, UNIX-Shell-Script
Entwicklungstools:
ORACLE Developer 6i Tools, XML Publisher, Reports Manager, APEX 3.2 bis 4.0
Datenbank:
ORACLE-RDBMS 9.2.0.5.0 bis 10gR2
Profil Helmut Heidel / Mar 2018
4/10
12/2008 - 09/2009
Oracle eBusiness Suite, Telefónica / O2 Germany, München
Kunde:
Telefónica O2 Germany GmbH & Co. OHG, Telekommunikationsunternehmen
Position:
Entwickler, Technischer Berater
Aufgaben:
Anpassungen Oracle Financials R11 Module:
- Erweiterung der Produktpalette / Integration in Oracle Financials:
Debitoren Anpassungen
- DTA Lastschrifteinzug,
- Rechnungsdruck (RAXINV)
- AR Rechnungsimport (Online-Shops)
- Umsatzsteuerverprobung
Order Entry Anpassungen
- Auftragsimportschnittstelle
- OE - Debitorenschnittstelle
Schnittstellen Fremdsysteme (updates)
- WinCash
- Lapis
- GDF (über Materialized View Snapshots)
Reports für AR, GL, OE, INV
Systemumgebung:
Web-based 3-tier System, SUN
Windows-Clients/Browser, Oracle Applications Release 11.0.3
SourceRepository in ClearCase, Collab.softw. Lotus Notes
Programmiersprachen:
SQL und PL/SQL, UNIX-Shell-Script
Entwicklungstools:
ORACLE Developer 2000 Tools
Datenbank:
ORACLE-RDBMS 8
01/2009 - 09/2009
Oracle eBusiness Suite, MoneyMaxx Lebensversicherung, Düsseldorf
Kunde:
Deutsche Ring Lebensversicherung AG / NL MoneyMaxx Düsseldorf
Position:
Entwickler, Technischer Berater
Aufgaben:
Archivierung
(Archive and Purge) Reports für die Oracle Financials R11 Module:
AP Rechnungen Verbucht
AP Rechnungen Protokoll
AR Zahlungsaufteilungen
AR Details nach Konto
AR Übersicht nach Kategorie
AR Details nach Kategorie
AR Übersicht nach Konto
AR Transaktionen Details
AR Zahlungseingänge
GL Zeilen
GL Summen Salden
GL Kontenanalyse
GL Summen Salden
GL Summen Salden Detail
FA Abschreibungsaufwand
FA Anlagenabgänge
FA AHK Details
FA DACH Abschreibungsanalyse
Systemumgebung:
Web-based 3-tier System, HP-UX
Windows-Clients/Browser, Oracle Applications Release 11.5.10.2
Programmiersprachen:
SQL und PL/SQL
Entwicklungstools:
ORACLE Developer 2000 Tools (
Reports Designer
)
Datenbank:
ORACLE-RDBMS Release 8.0.6.0.0
Profil Helmut Heidel / Mar 2018
5/10
01/2006 - 01/2007
Oracle Applications, HochTief, Essen
Kunde:
HOCHTIEF AG, Baudienstleister
Position:
Technischer Berater / Programmierer
Aufgaben:
Anpassungen für Oracle Financials R11i
Technisches Design and Spezifikation für folgende CEMLIs:
- Debitoren: Angepasstes Mahnschreiben
- Kreditoren/Hauptbuch: Skontoumlage
Implementierung folgender Anpassungen:
- Zentralisiertes Periodenmanagement (Forms Maske)
- Automatischer Transfermanager von AP/AR nach GL
- Zentralisiertes Feherlhandling
- MO Access Control - FastSwitch (schneller Mandantenwechsel)
Oracle Projects:
Project Management Change Request Reports (XML Publisher)
Systemumgebung:
Web-based 3-tier System, HP-UX rp4440 B.11.11 U 9000/800
Windows-Clients/Browser, Oracle Applications Release 11.5.10
Programmiersprachen:
SQL and PL/SQL, UNIX-Shell-Script
Entwicklungstools:
ORACLE Developer 2000 Tools, XML Publisher
Datenbank:
ORACLE-RDBMS 9.2.0.5.0
04/2004 - 12/2005
Oracle Applications, KGAL, München
Kunde:
KGAL, financial services and leasing company
Position:
Programmierer, DBA
Aufgaben:
Technische Umsetzung folgender Anpassungen:
Oracle Kreditoren/Debitoren: Replikation der Lieferanten/Debitoren mit Hilfe von Alerts.
Es werden automtisch alle Änderungen aus einer definierten “Generalfirma” in bestimmte
Zielmandanten repliziert. (Adressen / Kontakte / Bankkonten / Aufteilungssets etc.)
Fixed Assets: Implementierung der manuellen Abschreibung mit Hilfe vom “Depreciation
Override Feature”.
Automatische Anlagenverarbeitung in FA_Mass_Addition
FA Baukosten-Reports
CVS Repository und Custom Patch Generierung:
Administration vom CVS-Repository und die Shell-script Wartung zum Generieren von
Custom Patches.
Nutzen: Alle Anpassungen können mit Standard AD Werkzeugen geladen werden
(adpatch).
Mandantenübergreifend: XHTML-Reports und Protokolle
Systemumgebung:
Web-based 3-tier System Intel,
Red Hat Linux Advanced Server release 2.1AS/i686, Windows-Clients/Browser
Oracle Applications Release 11.5.7 - 11.5.9
Programmiersprachen:
SQL and PL/SQL, UNIX-Shell-Script
Entwicklungstools:
ORACLE Developer 2000 Tools
Datenbank:
ORACLE-RDBMS 9.2.0.3.0
Profil Helmut Heidel / Mar 2018
6/10
2005 - 2009
Oracle Applications, Release 11i Trainings f. Oracle Univ. München / Dozent
Kunde:
Oracle University
Standorte:
München
Düsseldorf
Wien (Österreich)
Baden (Schweiz)
Bukarest (Rumänien)
Position:
Dozent
Kurstitel:
11i Install Patch and Maintain Oracle Applications
Kursinhalt:
Oracle Applications Release 11.5.10
11i Oracle Applications Install
Overview of Oracle Applications
Single-node Installation
Multi-node Installation
11i Oracle eBusiness Suite Architecture
Oracle Applications Environment
Oracle Applications File System
Oracle Applications Database
Advanced Configuration Options
11i Use Oracle Applications Utilities
AD Administration
Special Utilities
AutoConfig
License Manager
Reporting Utilities
Configuration Utilities
11i Patch and Maintain Oracle Applications
Patch Wizard
AutoPatch
OAM Timing Reports
OAM Applied Patches
11i Oracle Applications Advanced Topics
Cloning Oracle Applications
OAM Rapid Clone
Systemumgebung:
Web-based 3-tier System Intel,
Red Hat Linux Advanced Server, Windows-Clients/Browser
Profil Helmut Heidel / Mar 2018
7/10
03/2002 - 02/2004
Oracle Applications, Gebühren Info Service (ORF-GIS), Wien
Kunde:
GIS, Außenstelle des österreichischen Bundesministeriums für Finanzen zuständig für
die Einbringung der Rundfunkgebühren
Position:
Programmierer / Apps-DBA
Aufgaben:
Technische Umsetzung folgender Schnittstellen in Oracle Financials R11i:
OKS/AR/GL: Treuhandgeldabrechnungen für ORF/GIS (Abstattung). dazugehörige
Reports
OKS/AR: Rechnungsimportschnittstelle (AR Open Interface)
Post AutoInvoice Updates
Unix Shell-Script Environment für Zahlungsschnittstellen
Kundenschulungen:
Technische Abteilung von GIS und Telekom Austria
Themen: Systemadministration, Hintergrundverarbeitung, Druckerkonfiguration in
Oracle Applications
Apps-DBA activities: Klonen und Patches einspielen auf dem Entwickung- und Test-
Systemen
Systemumgebung:
Web-based 3-tier System, HP-UX PA-RISC (32-bit), Windows-Clients/Browser
Oracle Applications Release 11.5.7
Programmiersprachen:
SQL and PL/SQL, UNIX-Shell-Script, Perl
Entwicklungstools:
ORACLE Developer 2000 Tools, SQL*Loader, Workflow
Datenbank:
ORACLE-RDBMS 8.1.6.1.0 - 9.2.0.2.0
01/2001 - 02/2002
Oracle Financials, Frosch Touristik GmbH (FTI), München
Position:
Programmierer / DBA
Aufgaben:
Anpassungen für Oracle Financials R11i
Hauptbuch - Cost-Of-Sales Schnittstelle zum Reservierungs-System
Debitoren - Automatische Korrekturen
Debitoren - Lastschrifteneinzug/Rücküberweisungen AT
Debitoren - AR GL Transfer - Automatisiert
Cash Management - Bank Transfer-Programm
Unix Shell Skripting für Anpassungen/Schnittstellen
Unix Batch-System für Prozesse im Nachtfenster
Druckerkonfiguration Unix/Oracle Applications
Systemumgebung:
Web-based 3-tier System:
SUN Server (Solaris 5.8), Windows-Clients/Browser
Oracle Applications Release 11i
Programmiersprachen:
SQL and PL/SQL, UNIX-Shell-Script, Perl
Entwicklungstools:
ORACLE Developer 2000 Tools, SQL*Loader
Datenbank:
ORACLE-RDBMS 8.1.6.1.0
Profil Helmut Heidel / Mar 2018
8/10
12/1999 - 01/2001
Oracle Financials ’’MOVE’’ Projekt, EPCOS AG, München
Position:
Technischer Projektleiter / Programmierer
Aufgaben:
Koordinierung und Umsetzung folgender Datenübernahme- und Tagesschnittstellen von
Oracle Financials zu SAP R/3:
Debitoren - Offene Posten Übernahme
Debitoren - RIAS Tagesschnittstelle
Kreditoren - Offene Posten Übernahme
Kreditoren - BERBAS Tagesschnittstelle
Sachkonten - RH1 Tagesschnittstelle
Zahlungen von SAP - PAYEXT - PAYMUL96A
Hauptbuch – Automatisches Lader der Devisenkurse
Systemumgebung:
Client/Server System: SUN Server (Solaris 2.5), NT-Client
Oracle Applications Release 11.0.3
Programmiersprachen:
SQL and PL/SQL, UNIX-Shell-Script
Entwicklungstools:
ORACLE Developer 2000 Tools, SQL*Loader
Datenbank:
ORACLE-RDBMS 7.3.2 - 8.0.5
08/1999 - 11/1999
Oracle Financials, Buhrmann Office Products, Stuttgart
Position:
Datenbank Entwickler / Technischer Berater
Aufgaben:
Debitoren Rechnungsimportschnittstelle von Oracle Auftrag, Square Contracts+ und
Square Service+
Systemumgebung:
Client/Server System: SUN Server (Solaris 2.5), NT-Client
Programmiersprachen:
SQL and PL/SQL, UNIX-Shell-Script
Oracle Applications Release 11.0.3
Entwicklungstools:
ORACLE Developer Tools (Forms and Reports)
Datenbank:
ORACLE-RDBMS 8.0.5
1998 - 1999
Oracle Financials, Sigel GmbH + Co, Mertingen
Position:
Datenbank Entwickler / Technischer Berater
Aufgaben:
Altdatenübernahme, Anpassungen und Schnittstellen für die Oracle Financials Module
Kreditoren, Debitoren und Anlagen.
Systemumgebung:
UNIS YS Server (SCO-Unixware)
Oracle Applications Release 10.6.1
Programmiersprachen:
SQL and PL/SQL, UNIX-Shell-Script
Entwicklungstools:
ORACLE Developer Tools (Forms and Reports)
Datenbank:
ORACLE-RDBMS 7.1.6.2.0
Profil Helmut Heidel / Mar 2018
9/10
1997 - 1999
Oracle Financials, Siemens EC / PR / Solar, München
Position:
Technischer Berater / Programmierer
Aufgaben:
Anpassungen/Erweiterungen, Schnittstellen, Releasewechsel zu den Oracle Financials
Modulen
* Kreditoren
* Anlagen
* Debitoren
Import/Export-Schnittstellen, Statistische-Meldungen, Scheckdruck, Paymul96A
(EDIFACT), Lieferantenavis, Altdatenübernahme aus SAP, Feuerversicherung, etc.
Schulungen/Technischer Überblick zur Oracle RDBMS und den Oracle Tools für die IT-
Abteilung der Niederlassung in Singapur
Systemumgebung:
Client/Server System: SUN Server (Solaris 2.5), NT-Client
Programmiersprachen:
SQL and PL/SQL, UNIX-Shell-Script
Entwicklungstools:
ORACLE Developer 2000 Tools, SQL*Loader
Datenbank:
ORACLE-RDBMS 7.3.2 - 8.0.5
1996 - 1997
Stock management interface, Knorr Bremse, München
Position:
Programmierer
Aufgaben:
Anbindung des Lagerverwaltungsrechners (VAX) an PSK*2000 in Bezug auf
Wareneingänge, Fertigungsaufträge und Kostenstellenzugänge
Systemumgebung:
Client/Server System: HP 9000 Server and Client
(HP-UX 9.0)
Programmiersprachen:
SQL and PL/SQL, UNIX-Shell-Script
Entwicklungstools:
ORACLE Developer 2000
ORACLE-Supplied Packages (dbms_pipe)
Datenbank:
ORACLE-RDBMS 7.3.3
1990 - 1996
ERP-System PSK 2000, Hexal AG, Holzkirchen b. München
Position:
Datenbank Entwickler / DBA
Aufgaben:
Einführung und Betreuung des PPS-Systems PSK*2000 SE in den Bereichen Vertrieb,
Produktion, Stücklistenwesen
EDIFACT - Phoenix-Bestellservice Schnittstelle
DFÜ-Schnittstellen zu den Fremdkommissionierer der Hexal AG
Systemumgebung:
Client/Server System: HP 9000 Server and Client
(HP-UX 9.0)
Programmiersprachen:
SQL and PL/SQL, Shell-Script
Entwicklungstools:
ORACLE Developer Tools (Forms and Reports)
Datenbank:
ORACLE-RDBMS 7.3.2
Profil Helmut Heidel / Mar 2018
10/10
Skill Profile
Helmut Heidel
Dipl.Math.-Univ.
Helmut Heidel
Email: [email protected]
Cell:
+49-172-6064385
PERSONAL DATA
Age:
52
Nationality:
german
Status:
married
Foreign Languages:
english, romanian, hungarian, italian (B2), spanish (A1)
Education:
1985–1989 University of Cluj/Romania, Faculty of Mathematics
TECHNICAL SKILLS
Technical emphasis:
database programming, database design, database administration
Industries:
pharmaceutical industry, equipment manufacturing, turism, financial services,
construction services, telecommunication services, leasing services
Operating systems:
MS Windows, HP-UX 10.20, Solaris 2.5/5.8, Linux (Debian, Oracle Enterprise
Linux), IBM AIX 5/6
Databases:
ORACLE-RDBMS Version 7, 8 , 9, 10,11, 12
Hardware:
Intel, HP Serie 9000, SUN Enterprise 3000, IBM
Development tools:
Oracle Apex 3/4/5, ORACLE Developer 2000, Discoverer 11.1.1.7
Progr. languages:
PL/SQL, SQL, Shell-Scripts, Perl, HTML, XML
Standard software:
MS-Office Professional, OpenOffice
Past activities:
database developer, interface developer, technical consultant, technical project
manager, database administrator, Oracle Applications DBA instructor
Profile Helmut Heidel / Mar 2018
1/11
PROJECTS
10/2012 – to date
Oracle eBusiness Suite, Würth-Leasing GmbH & Co.KG, Munich
Customer:
Würth-Leasing GmbH & Co.KG, Leasing Department
Position:
Developer / Technical & Functional Consultant / Apps-DBA
Job Description:
Apps-DBA / Database Administration
Maintance of EBS Instances - Production and Development/Test Systems
Patching
Cloning (RapidClone)
Backup & Recovery (RMAN)
2 x Production (Install and Maintain)
6 x Clones (Development and Test Instaces)
Database Link via Oracle-Gateway to IBM-DB2 and MS-Sql-Server
Migration
RuP-System to Oracle eBusiness-Suite R12 (Financials)
Master Data
◦
Customer
◦
Supplier
◦
Banks
Customizations for Oracle Financials R12
Transfer DTAUS-Payment-Files per EMail
Accounts Receivable: Automated Updates for Payment Method und Bank
Accounts in R12
Setup and launch the new SEPA initiative
Interfaces for the Finance Modules AP, AR, GL
Apex Development
Different Apex-Applications integrated with the eBusiness-Suite
Apex-Applications for the Migration reconciliation RuP-Oracle
Discoverer EUL Administration
Installation and Administration for Discoverer (vers. 11.1.1.7)
Migration for the Discoverer Connection Pool to another DB
Apex Web-Form to query all archived scanned (PDF) Invoices
System environment:
Web-based 3-tier System,
Red Hat Enterprise Linux Server release 6.4 (Santiago)
Windows-Clients/Browser, Oracle Applications Release 12.1.3
Subversion (SVN), Weblogic 10.3.6, Oracle Fusion Middlware 11g, Discoverer 11.1.1.7
Apache Tomcat 8.0
Programming languages:
SQL and PL/SQL, UNIX-Shell-Script
Development tools:
Oracle APEX 4.2, Oracle SQL-Developer, Jasper Reports v. 4.7.0 – 5.5.0
Oracle BI Discoverer Administrator 11.1.1.7
Database:
ORACLE-RDBMS 10g - 11gR2
Profile Helmut Heidel / Mar 2018
2/11
01/2010 – to date
Oracle Support and Development, DMC Group GmbH, Hallbergmoos
Customer:
DMC Group GmbH (public sector defense department project)
Position:
Technical Consultant, Apps-DBA, Apex Developer, Application Support,
Job Description:
eBusiness Suite (Apps-DBA)
EBS - Oracle Financials
Administration / Support / Maintanance / Patching / Cloning
Interfaces
SingleSignOn & Auditing
Shell-scripting
Reports and Request Sets
EBS Upgrade
Release Upgrade from 12.1.3 to 12.2.5
Oracle APEX Applications
Survey / Questionaire for the internal Roadmap
Data-Link-Tool between CR-System and eBusiness-Suite
Staff Committee Apps for the Intranet (Voting,Survey,etc.)
E2E Management (DB Design and Data Migration)
Oracle Application Server Installation and Support
OAS 10.1.2/10.1.3, OID-OIM 10.1.4, SSO 10g, WebCenter Portal & BPM
Installation & Administration
E-Procurement System
Administration
Performance optimization
Document Management System
Installation
Administration
Updates & Deployments
Agency Integrated Management System
Administration
Updates & Deployments
Performance optimization
Oracle DBA / Oracle RDBMS
Database Administration
Installation / Upgrade / Support - Oracle RDBMS vers. 8.1 to 11g
Performance optimization
Oracle Apex Administration
Installation & Administration
Subversion (Source Control System - SVN)
Setup / Administration
User Administration
Project Administration
System environment:
Web-based 3-tier System, AIX 5.3, AIX 6.0, LINUX SUSE 8-10, MS-Windows, VMWare
Windows-Clients/Browser, Oracle Applications Release 11i
Subversion (SVN), Oracle Grid Control, Weblogic 10.3.4, Oracle Fusion Middlware 11g
Programming languages:
UNIX-Shell-Script, SQL and PL/SQL
Development tools:
Shell scripts, XML Publisher, APEX 4.0-4.2
Database:
ORACLE-RDBMS 8.1 to 11g
Profile Helmut Heidel / Mar 2018
3/11
01/2007 - 09/2011
Oracle Applications, Comprendium Leasing Deutschland GmbH
Customer:
Comprendium Leasing Deutschland, Leasing Company
Position:
Developer / Technical & Functional Consultant
Job Description:
Process Optimization / Setup / Customization / Reporting / Support
R11i modules:
Accounts Receivable
Customer Forms update w. Personalization
Invoice & Invoice-Attachement Report (PDF printing)
AutoLockbox: Setup and Programming
Accounts Payable
German Banks Data Upload
Automation of the Supplier Payment Process with MultiCash/Eurodirect
Perliminary&Final Payment Register Reports
Automated Invoice Upload from “Inneract” Excel Files
General Ledger
ADI & FSG Setup
Inventory & Order Management
Setup New Remarketing Company (Interfaces/Warehouse/Intercompany
Invoicing) for centralized and automated invoicing for orders from IPMS
(integrated portofolio management system)
Intergration support for the “IPMS” with Oracle Application
Cash Management
Bank Statement Loader and CE Reconciliation
System Administration
Setup Cloning Process with IT Infrastructure department
Setup Patch Processing with IT Delivery department (patch wizard)
Setup New Custom Module for all Customization
Setup eBS to correspond to the Company Security Directives
Merged seven companies
from the German Comprendium Group
Merge/Consolidation and change of fiscal year
Migration R11i nach R12
Oracle EBS Release 12 Installation und Data Migration
Technical Support
System environment:
Web-based 3-tier System, HP-UX rp4440 B.11.11-11.v3 U 9000/800
Windows-Clients/Browser, Oracle Applications Release 11.5.10.2
Programming languages:
SQL and PL/SQL, UNIX-Shell-Script, APEX 3.0-4.0s
Development tools:
ORACLE Developer 2000 Tools, XML Publisher, Reports Manager, APEX 3.2 to 4.0
Database:
ORACLE-RDBMS 9.2.0.5.0 to 10gR2
Profile Helmut Heidel / Mar 2018
4/11
12/2008 - 09/2009
Oracle eBusiness Suite, Telefónica / O2 Germany, München
Customer:
Telefónica O2 Germany GmbH & Co. OHG,
Telecommunications company
Position:
Technical Consultant / Developer
Job Description:
Reports for Oracle Financials R11 Modules:
Customizations/Extensions to integrate new Products:
Receivables Customizations
- DirectDebit Bank Interface (DTAUS),
- Invoice Printing (RAXINV)
- AR Invoice Import (Online-Shops)
- Tax Validation Process ( Umsatzsteuerverprobung)
Order Entry Customizations
- Order Entry Open Interface updates
- OE and Receivables AutoInvoice updates
Interfaces to external systems (updates)
- WinCash
- Lapis
- GDF
Reports for AR, GL, OE, INV
System environment:
Web-based 3-tier System, HP-UX
Windows-Clients/Browser, Oracle Applications Release 11.5.2
Programming languages:
SQL and PL/SQL
Development tools:
ORACLE Developer 2000 Tools
Database:
ORACLE-RDBMS Release 8.0.6.0.0
01/2009 - 09/2009
Oracle eBusiness Suite, MoneyMaxx Lebensversicherung, Düsseldorf
Customer:
Deutsche Ring Lebensversicherung AG / NL MoneyMaxx Düsseldorf
Position:
Technical Consultant / Developer
Job Description:
Archive
(Archive and Purge) Reports for the Oracle Financials R11 Modules:
AP Posted Invoice Register
AP Invoice Register
AP Payment Distribution Report
AR Account Details
AR Journal Entries
AR Transaction Detail
AR Receipt Register
GL Trial Balance - Summary1
GL Journal Line Report
GL Account Analysis
GL Trial Balance Summary 2
GL Detail Trial Balance
FA Assets Retirement
FA Journal Entry Reserve Ledger
FA Cost Detail Report
FA DACH Depreciation Analysis
System environment:
Web-based 3-tier System, HP-UX
Windows-Clients/Browser, Oracle Applications Release 11.5.10.2
Programming languages:
SQL and PL/SQL
Development tools:
ORACLE Developer 2000 Tools (
Reports Designer
)
Database:
ORACLE-RDBMS Release 8.0.6.0.0
01/2006 - 12/2007
Oracle Applications, HochTief in Essen
Profile Helmut Heidel / Mar 2018
5/11
Customer:
HOCHTIEF AG, international construction services provider
Position:
Technical Consultant / Developer
Job Description:
Customizations for Oracle Financials R11i
Technical Design and Specifications for following CEMLIs:
- Accounts Receivable: Special Customized Dunning Letter Print
- Accounts Payable/General Ledger: Discount reallocation
Implementation of following customizations:
- centralized Period Management Forms Mask
- automatic Transfermanager from AP/AR to GL
- centralized Error Handling
- MO Access Control - FastSwitch
Reports:
- Accounts Receivable: Open Items
- Oracle Projects:Project Mgmt. Change Request Reports (XML Publisher)
System environment:
Web-based 3-tier System, HP-UX rp4440 B.11.11 U 9000/800
Windows-Clients/Browser, Oracle Applications Release 11.5.10
Programming languages:
SQL and PL/SQL, UNIX-Shell-Script
Development tools:
ORACLE Developer 2000 Tools, XML Publisher
Database:
ORACLE-RDBMS 9.2.0.5.0
04/2004 - 12/2005
Oracle Applications, KGAL in Munich
Customer:
KGAL, financial services and leasing company
Position:
Developer, DBA
Job Description:
Customizations for Oracle Financials R11i
Accounts Payable / Accounts Receivable:
Replication of Vendors/Customer using Alerts.
All changes made in a defined “master client” (Generalfirma) are automatically replicated
into defined vendors/customer. (i.e. sites/contacts/bank accounts etc.). Also AP TAX
Codes, AR VAR Taxes, Distribution Sets, etc. are replicated from the master-client to
defined targets. Related XHTML-Reports.
Unix Shell Script Environment for all customizations
Fixed Assets:
Implement Manual Depreciation with the Depreciation Override Feature; Automatic
Accounting in FA Mass Addition;
Reports for building outlay; Asset Conversion
CVS Repository and Custom Patch Generation:
Repository administration and shell-scripting for the custom patch generation based on
the repository customization modules. Benefit: customizations can be loaded with
standard AD utilities (adpatch).
System environment:
Web-based 3-tier System Intel,
Red Hat Linux Advanced Server release 2.1AS/i686, Windows-Clients/Browser
Oracle Applications Release 11.5.7 - 11.5.9
Programming languages:
SQL and PL/SQL, UNIX-Shell-Script
Development tools:
ORACLE Developer 2000 Tools
Database:
ORACLE-RDBMS 9.2.0.3.0
Profile Helmut Heidel / Mar 2018
6/11
2005 - 2009
Oracle Applications, Release 11i Training – Instructor
Customer:
Oracle University
Locations:
Munich
Düsseldorf
Vienna (Austria)
Baden (Switzerland)
Bucharest (Romania)
Position:
Instructor
Job Description:
Oracle Course: 11i Install Patch and Maintain Oracle Applications
Course content:
Oracle Applications Release 11.5.10
11i Oracle Applications Install
Overview of Oracle Applications
Single-node Installation
Multi-node Installation
11i Oracle eBusiness Suite Architecture
Oracle Applications Environment
Oracle Applications File System
Oracle Applications Database
Advanced Configuration Options
11i Use Oracle Applications Utilities
AD Administration
Special Utilities
AutoConfig
License Manager
Reporting Utilities
Configuration Utilities
11i Patch and Maintain Oracle Applications
Patch Wizard
AutoPatch
OAM Timing Reports
OAM Applied Patches
11i Oracle Applications Advanced Topics
Cloning Oracle Applications
OAM Rapid Clone
System environment:
Web-based 3-tier System Intel,
Red Hat Linux Advanced Server, Windows-Clients/Browser
Profile Helmut Heidel / Mar 2018
7/11
03/2002 - 02/2004
Oracle Applications, Gebühren Info Service (ORF-GIS) in Vienna
Customer:
GIS is the Austrian authority for administration and collection of fees for public television
and radio
Position:
Developer / Apps-DBA
Job Description:
Customizations for Oracle Financials R11i
OKS/AR/GL:Abstattung
Specific Austrian Program for distribution of colected public TV and radio fees to the
austrian authorities. adiacent reports
OKS/AR: AutoInvoice - AR Open Interface/ Post AutoInvoice
HR: calculate total daily overtime for flexible working hours with concurrent program
(supporting development)
Unix Shell Skripting for Payment Interfaces
Customer Training:
Technical Department of Telekom Austria and GIS.
Topics: Technical Overview to Concurrent Manager, Background Processing and Printer
Configuration
Apps-DBA activities: Cloning and Patching the Development and Test System
System environment:
Web-based 3-tier System, HP-UX PA-RISC (32-bit), Windows-Clients/Browser
Oracle Applications Release 11.5.7
Programming languages:
SQL and PL/SQL, UNIX-Shell-Script, Perl
Development tools:
ORACLE Developer 2000 Tools, SQL*Loader, Workflow
Database:
ORACLE-RDBMS 8.1.6.1.0 - 9.2.0.2.0
01/2001 - 02/2002
Oracle Financials, Frosch Touristik GmbH (FTI) in Munich
Position:
Developer / DBA
Job Description:
Technical Realization of following Tasks in Oracle Financials R11i:
General Ledger - Cost-Of-Sales Daily Interface with Data from Reservation System
Accounts Receivable - Automatical Adjustments
Accounts Receivable - Direct Debit for Austria
Accounts Receivable - Transfer to GL - Automation
Cash Management - Bank Transfer Programs
Unix Shell Environment and Skripting for Customizations
Unix Batch scheduling system for overnight processes
Printer configuration Unix/Oracle Application
System environment:
Web-based 3-tier System:
SUN Server (Solaris 5.8), Windows-Clients/Browser
Oracle Applications Release 11i
Programming languages:
SQL and PL/SQL, UNIX-Shell-Script, Perl
Development tools:
ORACLE Developer 2000 Tools, SQL*Loader
Database:
ORACLE-RDBMS 8.1.6.1.0
Profile Helmut Heidel / Mar 2018
8/11
Profile Helmut Heidel / Mar 2018
9/11
12/1999 - 01/2001
Oracle Financials ’’MOVE’’ Project, EPCOS AG in Munich
Position:
Technical Project Manager / Developer
Job Description:
Coordination and Realization of following Data Conversion and Daily Interfaces from
Oracle Financials to SAP R/3:
Accounts Receivable - Open Items Conversion
Accounts Receivable - RIAS Daily Interface
Accounts Payable - Open Items Conversion
Accounts Payable - BERBAS Daily Interface
General Ledger - RH1 Daily Interface
Payments from SAP - PAYEXT – PAYMUL96A
Exchange Rates – DEVK
System environment:
Client/Server System: SUN Server (Solaris 2.5), NT-Client
Oracle Applications Release 11.0.3
Programming languages:
SQL and PL/SQL, UNIX-Shell-Script
Development tools:
ORACLE Developer 2000 Tools, SQL*Loader
Database:
ORACLE-RDBMS 7.3.2 - 8.0.5
08/1999 - 11/1999
Oracle Financials, Buhrmann Office Products in Stuttgart
Position:
Database Developer / Technical Consultant
Job Description:
Invoice Import Interface for Oracle Financials, Module Accounts Receivable
System environment:
Client/Server System: SUN Server (Solaris 2.5), NT-Client
Programming languages:
SQL and PL/SQL, UNIX-Shell-Script
Oracle Applications Release 11.0.3
Development tools:
ORACLE Developer Tools (Forms and Reports)
Database:
ORACLE-RDBMS 8.0.5
1998 - 1999
Oracle Financials, Sigel GmbH + Co in Mertingen
Position:
Database Developer / Technical Consultant
Job Description:
Data Conversion and Adjustments for Oracle Financials in Module Accounts Payable
and Accounts Receivable
System environment:
UNIS YS Server (SCO-Unixware)
Oracle Applications Release 10.6.1
Programming languages:
SQL and PL/SQL, UNIX-Shell-Script
Development tools:
ORACLE Developer Tools (Forms and Reports)
Database:
ORACLE-RDBMS 7.1.6.2.0
Profile Helmut Heidel / Mar 2018
10/11
1997 - 1999
Oracle Financials, Siemens EC / PR / Solar in Munich
Position:
Oracle Technical Consultant / Developer
Job Description:
Adjustments/Extensions, Interfaces, Release change for the Applications-Modules
Accounts Payable, Fixed Assets, Accounts Receivable
Import/Export-Interfaces, Statistical-Reports, Check printings, Paymul96A (EDIFACT),
Payment Advice, Fixed Asset Data Conversion from SAP, Asset Insurance Programs
Training / Technical Overview for the Oracle RDBMS and the Oracle Tools for the IT
Department of Siemens in Singapore
System environment:
Client/Server System: SUN Server (Solaris 2.5), NT-Client
Programming languages:
SQL and PL/SQL, UNIX-Shell-Script
Development tools:
ORACLE Developer 2000 Tools, SQL*Loader
Database:
ORACLE-RDBMS 7.3.2 - 8.0.5
1996 - 1997
Stock management interface, Knorr Bremse in Munich
Position:
Oracle Database Developer
Job Description:
Interface from the stock management computer (VAX-system) to the PSK 2000
system regarding incoming goods, production orders and cost centre acces
System environment:
Client/Server System: HP 9000 Server and Client
(HP-UX 9.0)
Programming languages:
SQL and PL/SQL, UNIX-Shell-Script
Development tools:
ORACLE Developer 2000
ORACLE-Supplied Packages (e.g. dbms_pipe)
Database:
ORACLE-RDBMS 7.3.3
1990 - 1996
ERP-System PSK 2000, Hexal AG in Holzkirchen b. Munich
Position:
Oracle-Database Developer / DBA
Job Description:
Introduction and care of the ERP-system PSK*2000 SE within the areas selling,
production, parts list
EDIFACT - Phoenix-commad-service
Data communications interfaces to the foreign delivery companies (commisioners) of
Hexal AG
System environment:
Client/Server System: HP 9000 Server and Client
(HP-UX 9.0)
Programming languages:
SQL and PL/SQL, Shell-Script
Development tools:
ORACLE Developer Tools (Forms and Reports)
Database:
ORACLE-RDBMS 7.3.2
Profile Helmut Heidel / Mar 2018
11/11