Oracle, PL/SQL, developer, Business Analyst, Technical Analyst
Aktualisiert am 17.04.2024
Profil
Freiberufler / Selbstständiger
Remote-Arbeit
Verfügbar ab: 15.05.2024
Verfügbar zu: 100%
davon vor Ort: 95%
Oracle/SQL
VBA
HTML
Batchfile
ksh
Java
Data modelling
SAMBA
LDAP
iptables
MS T-SQL
mongoDB
MS-Access
JIRA
GIT
HP-QC
Subversion
Tableau
PowerBI
Confluence
Apache
Excel/VBA
Deutsch
Muttersprache
Englisch
C2 ? Level (CEFR)
Portugiesisch
A1 - Level

Einsatzorte

Einsatzorte

Deutschland, Schweiz, Österreich
auch weltweiter Einsatz denkbar
möglich

Projekte

Projekte

3 Monate
2023-12 - 2024-02

ARS - Anaylse-Redaktions-System

Analyst / Developer Oracl pl/ Git
Analyst / Developer
Orac Unix Git
Oracl pl/ Git
DEKA Investmentfonds
remote
1 Jahr 5 Monate
2022-01 - 2023-05

ARS - Anaylse-Redaktions-System

Analyst / Developer Ora PL/ Java
Analyst / Developer
PL/SQL Developer IBM Change Synergy Unix Oracle 19 VBA Java
Ora PL/ Java
DEKA Investmentfonds
Frankfurt am Main
6 Monate
2021-04 - 2021-09

ST-PT Portfolio and Resources Planing

Business Analyst / Technical Analyst / Developer HTML/PHP VBA Eclipse ...
Business Analyst / Technical Analyst / Developer
bug analysis, troubleshooting, performance tuning, code reviews on existing databasesm, training, knowledge transfer,  collecting business requirements; writing tech. specifications according to business requirements; liaise with different stakeholder from business department and it


JIRA Toad Subversion Eclipse Apache Tableau TOAD GIT SVN SQL-Developer PL/SQL Oracle Shell
HTML/PHP VBA Eclipse Oracle 11g/12c PL/SQL bash Git ETL
Telefonica
München
7 Monate
2020-09 - 2021-03

Virtualisation for small and mid-size companies

Technical analyst
Technical analyst
  • Virtualisation for small and mid-size companies
  • creating ad-hoc virtual infrastructure for small and midsize companies with cloud storage, directory services, collaboration services, video conferencing in the wake of COVID pandemie
  • Tools: Eclipse, JITSI, RocketChat Technologies: Virtualisation with Docker, Linux Debian, Bash-Scripting, Firewall, directory services like SAMBA, LDAP, collaborative services like video conferencing, chat, cloud storages
Virtualisation with Docker Linux Debian Bash-Scripting Firewall directory services like SAMBA LDAP collaborative services like video conferencing chat cloud storages Eclipse JITSI RocketChat
small and mid-size companies
Bayern
2 Jahre
2017-10 - 2019-09

ST-PT Portfolio and Resources Planing

Business Analyst / Technical Analyst / Developer VBA Oracle 11g/12c PL/SQL HTML ...
Business Analyst / Technical Analyst / Developer
Setup, development of a reporting databases on Oracle environments with PL/SQL; Web-Front-End development; IDV maintaining (VBA); environment harmonization and staging concepts; writing tech. specifications according to business requirements; liaise with different stakeholder from business department and IT
Toad Subversion Eclipse Apache Linux Oracle 11g/12c PL/SQL Atlassian JIRA
VBA Oracle 11g/12c PL/SQL HTML REST PHP ETL GIT SVN
TELEFONICA
München
6 Monate
2016-06 - 2016-11

CARA - Cross Asset Risk Analyzer

Business Analyst
Business Analyst
Business Analyst at Hypovereinsbank AG München / Unicreditgroup
Projekt : Cross Asset Risk Analyzer.  A homegrown data warehouse application for financial risks at Unicredit bank.

Oracle MS-SQL Server Sophis Risque Calypso
Unicreditgroup
Munich
4 Monate
2015-10 - 2016-01

Branche server transformation

Testmanager
Testmanager
Pilot / proof of concept project for a branche server transformation from windows to linux appliances.
HP QualityCenter HP Servicemanager
Unicreditgroup
Munich
1 Jahr 6 Monate
2014-04 - 2015-09

Operative Run of the Risk Management Application for Equity Derivatives

PL/SQL Java VBA ...


Zeitraum : 04.2014-09.2015
Firma/Institut: Hypovereinsbank AG München / Unicreditgroup
Projekt : Operative Run of the Risk Management Application for Equity Derivatives, interface monitoring, report generation,Development of KPI report, Reconciliation with Midoffice / Backoffice and downstream systems, training for internal employees
Software: Sophis Risque, Calypso, Oracle, VBA, PHP, MQ
Sophis Risque Calypso Oracle VBA PHP MQ
PL/SQL Java VBA PHP bash
Unicreditgroup
Munich
2 Jahre 3 Monate
2012-02 - 2014-04

Business / technical Analyst on Sophis Risque-2-Calypso migration project

Business / technical Analyst Oracle 11g PL/SQL HTML/PHP VBA ...
Business / technical Analyst
Zeitraum : 02.2012-04.2014
Firma/Institut: Hypovereinsbank AG München / Unicreditgroup
Projekt : Business / technical Analyst on Sophis Risque-2-Calypso migration project
Software : Oracle 11g PL/SQL,HTML/PHP,VBA, C++, SQL-Developer,Subversion,Sophis Risque (Riskcontrolling,Bestandssytem), Eclipse, MS-Visual Studio, Calypso
Developer Subversion Sophis Risque (Riskcontrolling Bestandssytem) Eclipse MS-Visual Studio Calypso
Oracle 11g PL/SQL HTML/PHP VBA SQL-
Unicreditgroup
Munich
4 Jahre 3 Monate
2007-12 - 2012-02

SPIRIT, Near-Time DB-gestütztes ad-Hoc and Overnight-Reporting

Developer, Technical analyst Oracle 10g PL/SQL HTML/PHP VBA ...
Developer, Technical analyst
 Near-Time DB-gestütztes ad-Hoc and Overnight-Reporting,Oracle PL/SQL developer, ETL,Overnight-Ladeprozesse, 3rd Level-Support,Performancetuning

Developer Subversion Sophis Risque (Riskcontrolling Bestandssytem) Eclipse MS-Visual Studio Calypso
Oracle 10g PL/SQL HTML/PHP VBA C++ SQL- Java
Unicreditgroup
Munich

Aus- und Weiterbildung

Aus- und Weiterbildung

4 Jahre 4 Monate
1996-09 - 2000-12

Studium Betriebswirtschaft

Diplom,
Diplom
Marketing, Vetrieb, Wirtschaftsinormatik

Position

Position

  • Stream lead
  • Business Analyst
  • Technical Analyst
  • Developer
  • Testmanagement

Kompetenzen

Kompetenzen

Top-Skills

Oracle/SQL VBA HTML Batchfile ksh Java Data modelling SAMBA LDAP iptables MS T-SQL mongoDB MS-Access JIRA GIT HP-QC Subversion Tableau PowerBI Confluence Apache Excel/VBA

Schwerpunkte

Personal Strengths

  • Hands-On / Can-Do mentality
  • Interpersonal skilled and integrable
  • Intrinsic motivated, diligent, patient
  • Goal and result orientated

Produkte / Standards / Erfahrungen / Methoden

PL/SQL
expert
VBA
expert
HTML/Php/JScript
advanced
JAVA
working knowledge
Data modelling
expert
JIRA
advanced
Subversion
advanced
GIT
advanced
T-SQL
expert
DB2
working knowledge
MS- SQL Server
advanced
Oracle Administration
working knowledge
Equity Derivatives
advanced
Investment Banking
advanced
DWH
working knowledge
shell scriptings
advanced
Tableau
working knowledge
Power BI
working knowledge
DB design & development
expert
MS Office
expert
ClearCase, ClearQuest,
working knowledge
Rational Software
advanced
HP: Qualtiy Center, Service Manager
expert
Toad
expert
Sophis Risque
expert
Calypso
working knowledge
Confluence
advanced
Docker
working knowledge
PostgreSQL
working knowledge
SONAR
working knowledge

Betriebssysteme

Linux
Unix
Windows

Linux

Programmiersprachen

PHP
PL/SQL
KSH/bash Linux scripting
VBA
T-SQL
JSON
XML
JAVA
Python

Datenbanken

Oracle
8/9/10g/11g/12c in-deep
Access
seit A97
MS SQL Server
2000 Server
MySQL
4/5
SQL
PL/SQL, T-SQL
mongoDB
Oracle experience:
  • 10+ years of experience with expertise as Oracle PL/SQL Developer in areas of Application software development and maintenance in Oracle environment using Client/Server
  • Good understanding of Business Functionality in Pharma, Banking industry, Telecommunications
  • Created Packages, Procedures, Functions, Triggers, Cursors using PL/SQL in UNIX and Windows environment
  • Created Schema, Users, Tables, Constraints, Indexes, Triggers, Privileges, Roles, Cursors, Ref Cursors, User Profiles, anonymous blocks, directories, sequences, and synonyms.
  • Granted resources, privileges and roles to users
  • Tuned SQL queries using EXPLAIN PLAN, Hints and SQL*Plus Auto trace report for query optimization
  • Used Oracle built-in packages
  • Performance Tuning of Oracle Applications
  • Wrote Shell Scripts for scheduling jobs in Unix/Windows, migrating data into tables.
  • Experience on Data migration activities and business data validations.
  • Good experience in Trouble shoots the issues (Apache, PL/SQL, Batch scripts,VBA).
  • Application development with all stages of System Development Life Cycle (SDLC): design, analysis, coding, and testing
  • Offshore consulting experience in Austria, Swiss, UK, USA

Datenkommunikation

TCP/IP
Windows Netzwerk

Branchen

Branchen

  • Pharmazie
  • Banken und Versicherungen
  • Industrie
  • Telekommunikation

Einsatzorte

Einsatzorte

Deutschland, Schweiz, Österreich
auch weltweiter Einsatz denkbar
möglich

Projekte

Projekte

3 Monate
2023-12 - 2024-02

ARS - Anaylse-Redaktions-System

Analyst / Developer Oracl pl/ Git
Analyst / Developer
Orac Unix Git
Oracl pl/ Git
DEKA Investmentfonds
remote
1 Jahr 5 Monate
2022-01 - 2023-05

ARS - Anaylse-Redaktions-System

Analyst / Developer Ora PL/ Java
Analyst / Developer
PL/SQL Developer IBM Change Synergy Unix Oracle 19 VBA Java
Ora PL/ Java
DEKA Investmentfonds
Frankfurt am Main
6 Monate
2021-04 - 2021-09

ST-PT Portfolio and Resources Planing

Business Analyst / Technical Analyst / Developer HTML/PHP VBA Eclipse ...
Business Analyst / Technical Analyst / Developer
bug analysis, troubleshooting, performance tuning, code reviews on existing databasesm, training, knowledge transfer,  collecting business requirements; writing tech. specifications according to business requirements; liaise with different stakeholder from business department and it


JIRA Toad Subversion Eclipse Apache Tableau TOAD GIT SVN SQL-Developer PL/SQL Oracle Shell
HTML/PHP VBA Eclipse Oracle 11g/12c PL/SQL bash Git ETL
Telefonica
München
7 Monate
2020-09 - 2021-03

Virtualisation for small and mid-size companies

Technical analyst
Technical analyst
  • Virtualisation for small and mid-size companies
  • creating ad-hoc virtual infrastructure for small and midsize companies with cloud storage, directory services, collaboration services, video conferencing in the wake of COVID pandemie
  • Tools: Eclipse, JITSI, RocketChat Technologies: Virtualisation with Docker, Linux Debian, Bash-Scripting, Firewall, directory services like SAMBA, LDAP, collaborative services like video conferencing, chat, cloud storages
Virtualisation with Docker Linux Debian Bash-Scripting Firewall directory services like SAMBA LDAP collaborative services like video conferencing chat cloud storages Eclipse JITSI RocketChat
small and mid-size companies
Bayern
2 Jahre
2017-10 - 2019-09

ST-PT Portfolio and Resources Planing

Business Analyst / Technical Analyst / Developer VBA Oracle 11g/12c PL/SQL HTML ...
Business Analyst / Technical Analyst / Developer
Setup, development of a reporting databases on Oracle environments with PL/SQL; Web-Front-End development; IDV maintaining (VBA); environment harmonization and staging concepts; writing tech. specifications according to business requirements; liaise with different stakeholder from business department and IT
Toad Subversion Eclipse Apache Linux Oracle 11g/12c PL/SQL Atlassian JIRA
VBA Oracle 11g/12c PL/SQL HTML REST PHP ETL GIT SVN
TELEFONICA
München
6 Monate
2016-06 - 2016-11

CARA - Cross Asset Risk Analyzer

Business Analyst
Business Analyst
Business Analyst at Hypovereinsbank AG München / Unicreditgroup
Projekt : Cross Asset Risk Analyzer.  A homegrown data warehouse application for financial risks at Unicredit bank.

Oracle MS-SQL Server Sophis Risque Calypso
Unicreditgroup
Munich
4 Monate
2015-10 - 2016-01

Branche server transformation

Testmanager
Testmanager
Pilot / proof of concept project for a branche server transformation from windows to linux appliances.
HP QualityCenter HP Servicemanager
Unicreditgroup
Munich
1 Jahr 6 Monate
2014-04 - 2015-09

Operative Run of the Risk Management Application for Equity Derivatives

PL/SQL Java VBA ...


Zeitraum : 04.2014-09.2015
Firma/Institut: Hypovereinsbank AG München / Unicreditgroup
Projekt : Operative Run of the Risk Management Application for Equity Derivatives, interface monitoring, report generation,Development of KPI report, Reconciliation with Midoffice / Backoffice and downstream systems, training for internal employees
Software: Sophis Risque, Calypso, Oracle, VBA, PHP, MQ
Sophis Risque Calypso Oracle VBA PHP MQ
PL/SQL Java VBA PHP bash
Unicreditgroup
Munich
2 Jahre 3 Monate
2012-02 - 2014-04

Business / technical Analyst on Sophis Risque-2-Calypso migration project

Business / technical Analyst Oracle 11g PL/SQL HTML/PHP VBA ...
Business / technical Analyst
Zeitraum : 02.2012-04.2014
Firma/Institut: Hypovereinsbank AG München / Unicreditgroup
Projekt : Business / technical Analyst on Sophis Risque-2-Calypso migration project
Software : Oracle 11g PL/SQL,HTML/PHP,VBA, C++, SQL-Developer,Subversion,Sophis Risque (Riskcontrolling,Bestandssytem), Eclipse, MS-Visual Studio, Calypso
Developer Subversion Sophis Risque (Riskcontrolling Bestandssytem) Eclipse MS-Visual Studio Calypso
Oracle 11g PL/SQL HTML/PHP VBA SQL-
Unicreditgroup
Munich
4 Jahre 3 Monate
2007-12 - 2012-02

SPIRIT, Near-Time DB-gestütztes ad-Hoc and Overnight-Reporting

Developer, Technical analyst Oracle 10g PL/SQL HTML/PHP VBA ...
Developer, Technical analyst
 Near-Time DB-gestütztes ad-Hoc and Overnight-Reporting,Oracle PL/SQL developer, ETL,Overnight-Ladeprozesse, 3rd Level-Support,Performancetuning

Developer Subversion Sophis Risque (Riskcontrolling Bestandssytem) Eclipse MS-Visual Studio Calypso
Oracle 10g PL/SQL HTML/PHP VBA C++ SQL- Java
Unicreditgroup
Munich

Aus- und Weiterbildung

Aus- und Weiterbildung

4 Jahre 4 Monate
1996-09 - 2000-12

Studium Betriebswirtschaft

Diplom,
Diplom
Marketing, Vetrieb, Wirtschaftsinormatik

Position

Position

  • Stream lead
  • Business Analyst
  • Technical Analyst
  • Developer
  • Testmanagement

Kompetenzen

Kompetenzen

Top-Skills

Oracle/SQL VBA HTML Batchfile ksh Java Data modelling SAMBA LDAP iptables MS T-SQL mongoDB MS-Access JIRA GIT HP-QC Subversion Tableau PowerBI Confluence Apache Excel/VBA

Schwerpunkte

Personal Strengths

  • Hands-On / Can-Do mentality
  • Interpersonal skilled and integrable
  • Intrinsic motivated, diligent, patient
  • Goal and result orientated

Produkte / Standards / Erfahrungen / Methoden

PL/SQL
expert
VBA
expert
HTML/Php/JScript
advanced
JAVA
working knowledge
Data modelling
expert
JIRA
advanced
Subversion
advanced
GIT
advanced
T-SQL
expert
DB2
working knowledge
MS- SQL Server
advanced
Oracle Administration
working knowledge
Equity Derivatives
advanced
Investment Banking
advanced
DWH
working knowledge
shell scriptings
advanced
Tableau
working knowledge
Power BI
working knowledge
DB design & development
expert
MS Office
expert
ClearCase, ClearQuest,
working knowledge
Rational Software
advanced
HP: Qualtiy Center, Service Manager
expert
Toad
expert
Sophis Risque
expert
Calypso
working knowledge
Confluence
advanced
Docker
working knowledge
PostgreSQL
working knowledge
SONAR
working knowledge

Betriebssysteme

Linux
Unix
Windows

Linux

Programmiersprachen

PHP
PL/SQL
KSH/bash Linux scripting
VBA
T-SQL
JSON
XML
JAVA
Python

Datenbanken

Oracle
8/9/10g/11g/12c in-deep
Access
seit A97
MS SQL Server
2000 Server
MySQL
4/5
SQL
PL/SQL, T-SQL
mongoDB
Oracle experience:
  • 10+ years of experience with expertise as Oracle PL/SQL Developer in areas of Application software development and maintenance in Oracle environment using Client/Server
  • Good understanding of Business Functionality in Pharma, Banking industry, Telecommunications
  • Created Packages, Procedures, Functions, Triggers, Cursors using PL/SQL in UNIX and Windows environment
  • Created Schema, Users, Tables, Constraints, Indexes, Triggers, Privileges, Roles, Cursors, Ref Cursors, User Profiles, anonymous blocks, directories, sequences, and synonyms.
  • Granted resources, privileges and roles to users
  • Tuned SQL queries using EXPLAIN PLAN, Hints and SQL*Plus Auto trace report for query optimization
  • Used Oracle built-in packages
  • Performance Tuning of Oracle Applications
  • Wrote Shell Scripts for scheduling jobs in Unix/Windows, migrating data into tables.
  • Experience on Data migration activities and business data validations.
  • Good experience in Trouble shoots the issues (Apache, PL/SQL, Batch scripts,VBA).
  • Application development with all stages of System Development Life Cycle (SDLC): design, analysis, coding, and testing
  • Offshore consulting experience in Austria, Swiss, UK, USA

Datenkommunikation

TCP/IP
Windows Netzwerk

Branchen

Branchen

  • Pharmazie
  • Banken und Versicherungen
  • Industrie
  • Telekommunikation

Vertrauen Sie auf GULP

Im Bereich Freelancing
Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

Fragen?

Rufen Sie uns an +49 89 500316-300 oder schreiben Sie uns:

Das GULP Freelancer-Portal

Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.