Patricio E. Colombo
54 Lockyer House
The Platt
Waterman St.
London, SW15 1EE
Day Mobile: 07958 540 878
Oracle Developer and
DBA with 8 years hands on experience in Oracle database Design &
Development, performance tuning, using Designer, PL/SQL, Discoverer, Team
Leading, DBA on Oracle 7, 8i & 9i; UNIX Sun Solaris, Linux, Shell
Scripting, SCO Unix, Java and XML.
Perl Advanced Current 1 year
Linux Expert Current 2 years
Shell Scripting Expert Current 3 years
Oracle DBA Rel. 7.2; 7.3; 8i & 9i Expert Current 5 years
Oracle Performance Tuning Expert Current 8 years
PL/SQL Expert Current 8 years
Developer/2000 Forms Rel. 4.5, 5 & 6i Expert Current 8 years
Developer/2000 Reports Rel. 2.5, 3 & 6i Expert Current 8 years
Designer/2000 Rel. 1.3.2 & 6i Expert Current 8 years
Discoverer Rel. 3 Administration Expert 4 years 3 years
Discoverer Rel. 3 Data Design Expert 5 years 3 years
UNIX Sun Solaris 2.6 Administration Advanced 4 years 2 years
Java Advanced Current 1 year
Java Servlets Advanced Current 1 year
Visual Basic 6.0 Intermediate 3 years 1
year
08/2002 -
Today Hello Magazine Ltd
London, United Kingdom
Developer: Development, Implementation,
Migration, Tuning of an Accounts system, integrating it with the Sales
application, which will be replaced in the near future with an in-house
development.
DBA: Successfully migrated four Oracle
8i databases running under SCO UNIX to Oracle 9i under SuSE Linux, also
implementing the backup & recovery strategy.
11/2000 -
02/2002 Independent Consultant
Buenos Aires, Argentina
CLIENT: I-Solution
·
PROJECT: GEVENUE
DESCRIPTION:
Team Leader & Developer: Design,
Development & Team Lead of an Internet Direct Marketing system for CRM
applications, or to run as a stand alone operation.
Based on HTML clients, using Oracle
Designer 6i and PL/SQL for the business logic.
Leading of a team of Java Programmers to design the Database-Internet
browsers interface.
·
PROJECT: GANEARE
DESCRIPTION: Data Model Design of a system for
account receivable tracking and collection, using Oracle Designer 6i.
·
Oracle DBA: Planning, Installation,
Maintenance, Backup & Recovery for the company’s Oracle database.
CLIENT:
Repsol-YPF
·
PROJECT: Boxes
DESCRIPTION:
·
Development of Multimedia CD-ROM’s
(Macromedia Director)
· Rental of PC’s for events
CLIENT:
Chroma System
·
PROJECT: Budgeting
DESCRIPTION: Development & Implementation of a system for project budgeting, and
administration of clients & mailings using Visual Basic 6.0 and MS Access.
CLIENT: Trén de la
Costa
·
PROJECT: Help Desk
DESCRIPTION: Development & Implementation of a Help Desk System, using Oracle
Designer 6i. I was also the Oracle 8i DBA for this project.
09/1998 -
11-2000 SDA Consultores Asociados
S.A.
Buenos Aires, Argentina
CLIENT: Municipality of Esteban Echeverría
PROJECT: Integral Tax Collection and Administration.
DESCRIPTION: Team Leader of 3 people (including myself) for the Implementation of a
Tax Collection Software using Oracle Forms 4.5; Reports 2.5 and PL/SQL.
This was my first contact with the
database as a DBA for an Oracle 7.3.4 installed under UNIX SUN Solaris 2.6,
which lead me into taking a course on this OS administration.
CLIENT: Price Waterhouse Coopers/Grant Thornton.
PROJECT: Integral Tax Collection and Administration.
DESCRIPTION: Implementation of the same Tax Collection software mentioned above,
for the Province of Entre Rios, Argentina, Using Oracle Forms 5.0; Reports 3.0 and
PL/SQL.
I was appointed Interim Team Leader
for this project, in charge of 9 people (including myself), a position that
extended for near 6 months, to later become the Support Manager for The Tax
Collection project for 5 Argentina provinces. This includes both projects I
mentioned.
PROJECT: City of Buenos Aires Traffic Control.
CLIENT: Siemens-Itron
DESCRIPTION:
Design, Development & Implementation of a
Traffic control system (photo speeding tickets) using Oracle Forms 4.5, Reports
2.5 and PL/SQL.
I was Team Leader for this project,
with a force of 4 (including myself).
After the
projects I mention above, I was promoted to Support Manager for all 6 teams
that worked for both the Tax Collection System & Traffic, to a total of 17 people.
09/1996 -
09/1998 Television Federal S.A.
Buenos Aires, Argentina
Design,
Development, Implementation & Maintenance of Administrative and Operations
Systems, including Analysis & Follow-up of Investments, Stocks, Accounting,
Sales & Security for the Database Applications of the Company. (Forms 4.5;
Reports 2.5; Designer/2000 1.3.2; Discoverer/2000 3.0; PL/SQL).
End-User
Training: Organization &
Coordination of the migration of an Integral News Operations & Air system,
Including Negotiation with vendor for software, Organization of Implementation,
and courses, technical and user end.
Technical
Training: Oracle Products within the Systems
Department.
Translator: Simultaneous Translation English-Spanish of
the abovementioned News course.
02/1996 -
04/1996 Industria Química
Alimentaria
12/1994 -
08/1995 Ruarte's Reports
12/1992 -
12/1994 United States
Embassy in Buenos Aires
12/1991 -
12/1992 Delta Airlines
03/1991 -
12/1991 Pan American World
Airways
Language Level
Spanish Native
English Excellent
Portuguese Basic
Italian Basic
Title Institution Year Type
Licensure in
Computer Sciences Univ.
Argentina de la Empresa 1997 University
(UK
Equivalent: MSc) Degree
Oracle Certified Professional R1. IT College – Argentina 05/2001 Tech. Cert.
Strategic Negotiation & Planning University
of Buenos Aires 2000 Grad. Studies
Team Leadership University
of Buenos Aires 10/2000 Grad. Studies
Oracle Open World Oracle
USA 10/2000 Tech.Training
UNIX SUN Solaris 2.6 Administration SUN
Argentina 03/1999
Tech.Training
Web Server Rel. 3 Development; Administration Oracle Argentina 1998
Tech.Training
Discoverer Rel. 3 Administration; End Users Oracle Argentina 1998
Tech.Training
Designer/2000 Oracle
Argentina 1997 Tech.Training
Developer/2000 Forms 4.5; Reports 2.5. Oracle
Argentina 1996 Tech.Training