Keywords
Skills
Programming Languages:
- SQL and PL/SQL
- T-SQL
- Unix Shell
- Visual Basic
- HTML
- JavaScript
- PHP
- Java
- Oracle (9i, 10g, 11g)
- Microsoft SQL Server
- MySQL
- MS Access
- DB2
- Oracle Warehouse Builder 10g, 11g (ETL)
- Informatica Powercenter 7.4, 8.6 (ETL)
- SQL Developer, PL SQL Developer, TOAD
- SQL Plus
- SQL*Loader
- XML/BI Publisher
- Autoconfig and AD Utilities (adpatch, adctrl, adadmin, adrelink)
- Oracle Jdeveloper
- Oracle Data Integrator (ODI) 10g, 11g (ETL)
- Oracle Golden Gate
- Oracle Developer (Forms and Reports)
- OBIEE 10g, 11g
- Essbase
Project history
- 10/10/2016 – Ongoing
RM IT Professional Resources AG. Förrlibuckstrasse 10, 8031 Zürich (Switzerland).
Customer: Credit-Suisse.
- Database Administration for various internal and external business critical applications.
- Backup and restore (DR) policy implementation.
- Enterprise Manager Grid control setup to monitor large number of database infrastructure.
- Automated scripts writing for database backup, recovery and monitoring using PL/SQL, Unix/Linux Shell.
- Migration and upgrade of Oracle databases. Patch validation and implementation.
- DBaaS provisioning
- Work occasional off hours as well as part of a 24x7 on-call rotation
- 14/09/2015 – 29/07/2016
Stamford Consultants. Limmatquai 2, 8001 Zürich (Switzerland)
Customer: Credit-Suisse.
On charge to analysis the problems, gather the requirements and involved in the development (particularly those related with the databases).
- Creation of Interface between several applications
- Requirement engineer role
- 3rd Level Production Support
- Optimization and increase the performance of the DB process
- Virtualization of several standalone GUI to Citrix
- Batch scheduling jobs design and implementation in Control-M
- Database migrations and machine migration from Unix to Linux
- Technology used: Oracle RAC, Oracle 11g, Applications servers Linux, Unix and Windows.
- 01/10/2014 – 11/09/2015
Partners K2 AG. Neuhofstrasse SA 6340 Baar (Switzerland)
Customer: PostFinance. DWH Department.
- Developer and Business Analyst role
- Creation of Documentation LLD (Low Level Design)
- Close collaboration with the developer team in Bern
- Design and modeling of Datamarts
- 3rd Level Production Support
- Enterprise Manager Grid control setup to monitor large number of database infrastructure.
- Creation, updating and maintenance of ETL Mappings using Oracle Warehouse Builder (OWH) and Oracle Data Integrator (ODI)
- 10/06/2013 – 31/08/2014
Cognizant Technology Solutions. Hohlstrasse 560, 8048 Zürich (Switzerland)
Customer: Credit Suisse. FA (Financial accounting) department.
- Developing and supporting Oracle databases (SQL and PL/SQL).
- Working with Unix and SQL (Sybase, Oracle)
- Design and modeling of business processes.
- Desing and analysys reports in BI tool (Oracle OBIEE).
- Responsible for Batch job monitoring and troubleshooting (Control-M).
- Design of ETL processes in Informatica PowerCenter.
- Design and modeling of datamarts.
- DBA support.
- 3rd level Production support.
- 09/07/2012 – 30/04/2013 (10 months)
Stamford Consultants. Limmatquai 2, 8001 Zürich
Customer: Credit-Suisse. Hagenholzstrasse 20-22, Zürich (Switzerland)
Oracle senior developer on charge of a migration of a Swiss Datawarehouse:
- Migration of the SWISS database and staging part of an application from a legacy environment to the Credit Suisse Datawarehouse (DWH) platform including:
- Migration of Informatica 7.14 Workflows to a standardized DWH platform operating on Informatica 8.6
- Migration of batch scheduling jobs running on a internally developed scheduling program to Control-M
- Migration of Database objects on Oracle 10G to a standardized DWH platform operating on Oracle 11G
- Migration of Feed transfers (Connect Direct / ftp) to the new platform (FTPS)
- Deployment of the application parts using common change management (SWAN XP) and version control tools (Subversion)
- Close collaboration with the application and platform responsible based in Switzerland and Singapore
- 12/01/2009 - 06/07/2012 (3 years and 7 months)
Oracle MICC (Oracle Málaga International Consulting Center). c/Severo Ochoa, 30. Parque Tecnológico de Andalucía - 29590 Campanillas (Spain)
- Developing of Oracle, MS Sql-Server databases.
- Master Data Management (MDM)
- Creation/Modeling of Data Marts/Data Warehouse
- Reporting in OBIEE 10g or 11g, Apex
- Transferring of a large amount of data between heterogeneous databases.
- Design of a graphic data model of all databases joined with the business processes modeled on Sybase Power Designer.
- Creation of interfaces ETL (Extract, transform, and load) processes with Oracle Warehouse Builder (OWH) and Oracle Data Integrator (ODI)
- User support
- Solving issues at the helpdesk
- 29/06/2006 – 11/01/2009 (2 years and 8 months)
Oracle Ibérica S.R.L. c/. José Echegaray, 6, Edificio B, Madrid - Las Rozas (Spain)
- Expert developer in Oracle Forms and Reports and customization (Analysis, Design and Development).
- Experience in Database Development activities like Installation, applying patches and hot fixes, designing, Database Security, Data Transformation Services, and Query Optimization.
- Provide Oracle Application Server and Oracle APEX implementation and support.
- Expert in PL/SQL database programming.
- Database migration from Oracle to SQL server or MySQL, and vice versa.
- Experience in Data Modeling, Database Design, Database Programming and ETL Development.
- Provide 3rd level support for Oracle RAC, including applying patches, performance tuning, backup and recovery issues with RMAN/DataProtector, trace analysis, service creation, cluster, and system management.
Local Availability
Only available in these countries:
Switzerland
I'm available for traveling