Oracle PL/SQL Entwickler

10/2007 – 12/2013

SEPA (Single Euro Payment Area) Project
------------------------------------------------
Participated in integration of SEPA with the bank system. Implemented the SEPA functionality in settlement and provision systems, customer letters. Implemented the postal returns SEPA blockage functionality.

AML (Anti Money Laundering) Project
-------------------------------------------
Developed Oracle based infrastructure to block the customer agreements and cards in case of money laundering suspect

FlashCredit - Credit Card Instant Issuing
-----------------------------------------------
Developed Oracle based infrastructure which enables IKANO Bank GmbH to quickly and cost effectively issue magstripe based credit cards in retailer shop. The Datacard card issuance system has been utilized. This is an ideal instant issuance solution for banks, credit unions and retailers. This fast desktop system can issue a ready-to-use ATM, debit or credit card in less than 30 seconds.

Germany Settlement & Merchant Fee and Commission Project
-----------------------------------------------------------------------
Developed an Oracle based infrastructure which enables IKANO Bank GmbH to calculate the purchase settlements which are realized in IKEA, H&M, DEICHMANN, MEDIAMARKT, JET and other partner’s stores in Germany . Responsible to manage all the settlement and billing and commission structure with different partners.

Credit Card Banking Applications Development
------------------------------------------------------
Developed and enhanced plenty of credit card banking applications. Core Oracle technologies (PL/SQL, DB design, Oracle Forms, Oracle Workflow) as well as Java, C++, ASP, JS/HTML, XML/XSL, FOP, SQL Loader and Unix shell scripting technologies have been utilized. Developed interfaces for Multicash, Bank-Verlag, Schufa, Deltavista, Brinks, FirstData. Developed the ATM money withdrawal, cash suppy infrustructure. Developed the instant issuing card embossing infrustucture. Developed the Delinquency Contact Scheduling module for credit card debt collection department. Designed the customer amd coorperate letters.

Poland Settlement & Merchant Fee Project
------------------------------------------------
Developed an Oracle based infrastructure which enables IKANO Bank GmbH to calculate the purchase settlements which are realized in IKEA stores in Poland. Responsible to manage the purchase transactions to be settled correctly in Germany, creating the automatic merchant fee invoices, kick-back (provision) invoices and transferring the settlement invoices into Navision accounting system which is centralized in Denmark.

10/2006 – 10/2007

JDARE J2EE Framework Design & Development
------------------------------------------------------
JDARE framework is intended to replace existing Oracle Forms/Reports/Discoverer based DARE system with a Java based system which will be running on a new, integrated, open, scalable based J2EE platform. DARE system is responsible to process all daily and monthly reporting requirements for Business Area Controlling department of the bank.


Controlling – IFRS Repo Reconciliation Report Application
------------------------------------------------------------------
Developed and implemented PL/SQL based REPO (Repurchase Aggreement) web reporting modules according to International Financial Reporting Standards ( IFRS ).

1/2003 – 10/2006

Patent Administration and Information System
-----------------------------------------------------
Developed and implemented modules for PATVIN project which is the professional patent administration and information system for patent departments or law chambers.

Patvin is a software package enabling enterprises to manage extensive portfolios of industrial patent rights smoothly and safely for their whole term. PL/SQL Developer, SQL Navigator, TOAD, Oracle Developer tools were utilized. Took part in various database design, management and optimisation tasks.

SEAT Deutschland - Nordic Project
-----------------------------------------
Developed and implemented a database stucture enabling to market autos to Norway and Sweden which are bought from Spain. Project is realized by utilizing PL/SQL and Oracle technologies. PL/SQL Developer, SQL Navigator, TOAD, Oracle Developer tools were utilized.

Infraserv GmbH & Co. Höchst KG – EnergyExpert Project
--------------------------------------------------------------------
PL/SQL Developer, SQL Navigator, TOAD, Oracle Developer tools were utilized. Developed and implemented a management & statistic tool for Infraserv GmbH using ORACLE technologies, Oracle Forms, Oracle PL/SQL and DYNAPLOT charting OCX