With more than 10 years working experience in DB development and design, in banks and financial industries.
German pass, Swiss Permit B valid till 08.2013
Projekt‐ & Berufserfahrung
UBS and Quartal Financial Solutions, Zürich
8/2007 – 10/2012Tätigkeitsbeschreibung
Application Engineer (Contractual)
UBS, Zürich (thru Tresag Management Services)
Aug. 2007 - Aug 2008
I was mainly involved in the following:
- development of JCS (Job Control Schedule) using Redwood Cronacle.
- development, maintenance and tuning of PL/SQL packages, procedures and functions.
- Unix scripting
Senior Software Engineer (Permanent)
Quartal Financial Solutions, Zürich
Oct 2008-Oct 2012
- database design and analysis
- coding and refactoring PL/SQL packages, procedures and functions.
- developed data migration scripts
- was involved in development of data segregation and object locking features
- tuning and optimisation
Ort: Manila, Philippines
In my last employer (Quartal), I managed to help the customer solving their 28-hour long-running process to make it run for less than 30 minutes. I managed to accomplish the task by tracing and refactoring queries and stored procedures, and most of all understanding the whole process. I was also the main designer/developer of the data migration feature of Quartal`s Commission application, where I had written most of the modular/generic stored procedures for extraction, transformation and loading of customer-specific database to new product database version.
At RS2, I was one of the 3-man team involved in the successful implementation of High Volume Engine module of the Bankworks application, with the aim to process 7 million transactions in 1 hour. Our team managed to achieve the goal by using bulk collections and bulk processing, table/index partitioning, and not to mention changing SQL hints which were affected by migrating to new Oracle version. Also, I had done session tracing, understanding explain plans and session profiling in order to trace what part of the whole process needs to be optimized.
I had worked also in UBS for GEAR project, which was a Very Large Database. As Application Engineer, I was involved in development and maintenance of PL/SQL packages, JCS scripts and chains, shell scripting and packaging.
As a person, I am very hardworking, fast-learner, and always find solution to a problem. I can work independently or with a team. I am also enthusiastic to learn new technologies that can be beneficial for the work, the team, and for the organization.
I hope that you consider my application suitable and look forward to hearing from you soon.