Raphaël
de
AZCARATE
Download my CV at WORD6 format
PARIS,
FRANCE
|
Career Objective: Use my DB2
experience for challenging projects requiring integrating databases with
daily business practices and the Internet. |
E-mail : azcarate@magic.fr
Home:
00.33.6.10.18.65.21
PROFESIONAL EXPERIENCE
|
Jan 1999 to present Air France DB2 V7 |
Database
architect specializing in mission-crital data migration projects, optimization
for real-time use and data mining. Major accomplishments include:
. Optimization of Air France Frequent Flyer program
database. Provided
project implementation expertise, trouble-shooting supportfor entire project
team. Result: Access time decreased by up to 90%.
. Creation of HTML interface to link to AF Database. Created "proof-of-concept"
prototype in feasibility study. Result: Management acceptance for AF personnel
worldwide to use browser interface for access to database content.
. Implementation of Interface between AF and partner
databases. Researched
partner database implementations to ensure data integrity. Result: Project
completed on time and within budget.
. Managed DB2 database center. Responsible for company-wide data store with
400 Go used by 6,000 AF personnel.
Technical
Competencies: CICS, EDIFACT V3.1, NETDATA, HTML,
REXX, SQL, BMC
|
1995 to 1999 PLATINUM technology (Now part of
COMPUTER ASSOCIATE) FRANCE |
Course
Instructor for all DB2 Training.
. Designed, revised teaching materials. Result: Created high-level DB2
competence for over 600 programmers during 90 courses.
. Y2K Impact
Analyst. Consultant/Advisor
to determine Y2K impact on mission-critical corporate data.
. France-USA
office Liaison. Coordinated
communications and technical exchanges between Chicago headquarters and
Platinum France.
. System Administrator. Oversaw implementation and maintenance of DB2 platform for Platinum
France.
. Software Programmer. Implemented and integrity tested migration of ROSCOE to TSO.
Technical
Competencies: REXX, CICS, QMF, PRF, TSO, DB2 V4
|
1994 to 1995 Reflex Informatique (Paris) |
Programmer
for various projects for large French enterprises:
Nouvelles Frontieres: Reservation Booking program for DB2 database.
Societe Generale: Integration tests for bank's client account maintenance.
Paribas: Responsible
for Foreign currencies integration program.
GSI: Creation of
algorithms and macros to parameter billing software
|
1992 to 1994 IOS (branch of General des Eaux) Paris |
Executive
Engineer
Companie Generale des Eaux. Consultant to refine company's invoice system.
CCBP. Realisation of a program to enable personalization of bank cards (Smart
Cards).
|
1991 to 1992 Oxford Consulting |
Analyst
responsible
software used for credit program management.
|
1990 to 1991 Taller de Arquitectura Bofill (Madrid) |
Analyst
responsible
for invoice management software used by Spanish and American branches.
|
1988 to 1990 X.Pro |
Analyst focusing on 30 for organizations/companies such as
Chambre de Commerce et d'Industrie de Paris (CCIP)
|
Summary of Technical Experience |
Mainframes IBM Z900 Series
Operating
System: Z/OS V1R4, OS390, MVS
Database:
DB2 V7 dba expert, DL1 (basic knowledge)
Languages:
REXX, SQL, COBOL370, plus basic knowledge of CLIST, PL1 and ASM
Monitor
TP: CICS (Table: DFHRCT, Transactions: CEDA, CEMT, CEDF)
Monitor
Online: TSO ispf and basic knowledge of ROSCOE
Methods:
Merise
IBM PC
Operating
Systems: Windows XP /2000/98/95/NT, LINUX, DOS
Languages
and Macro: VBA 4 for Excel and Access, HTML (Java basic knowledge)
Software:
MsOffice 2000, Lotus Notes, DB2 Connect, Amc designor
|
Summary of Business Domain
Experience |
Reservation systems (AMADEUS), Air Freight, Frequence Plus,
Batch connecting system
Credit Card Personalization
Commercial and Personal Loan Systems
Stock Exchange (RELIT)
Accounting
Enterprise Payroll Systems
Industrial Manufacturing
Newspaper Publishing (CCIP)
Customer Accounts
|
Education |
1994 DEST, Paris Conservatoire National des Arts et Metier (CNAM)
1998 BTS, Paris Institut Superieur d'Informatique (ISI)
1985 ENI, Nantes Technical Training in COBOL, BASIC
1984 BTR, Technical Marketing
1983 BAC H Access University computer technician
(Diploma with Distinction)
|
Personal |
Born: June 27, 1963 Paris
Citizenship: French
Languages: French (native), English (fluent technical
level fluent, general written/spoken good), Spanish/Italian (basic knowledge)
Hobbies: Horseback Riding: participated in
World Jumping Competitions (1992), team manager of Paris Horseback Riding
Federation (1997), Tennis