Patrick Hamou

Current

Senior Oracle Technical Specialist at Visa Desjardins
Lead Oracle Technical Advisor at Lécuyer et fils
President at Renaps Technology

IT Services at Various customers in the province of Quebec

see less...

1 more...

Past

Lead Oracle Technical Advisor at Quebec Government
Senior Oracle DBA at SRIC
CIO at Jati Technology

Lead Oracle DBA at Nomura Securities
Senior Oracle DBA at Uptodate
Manager of data processing operations at Foucray
Lead Oracle Technical Advisor at Dell Professional Services
Lead Oracle DBA at US Government
Senior Oracle DBA at Richemont
Senior Oracle DBA at Accenture
Senior Oracle DBA at BPR CSO
Lead Oracle DBA at IBM Global Services
Senior Oracle DBA at Transcontinental
Senior Oracle DBA at Noranda
Oracle Technical Specialist at JBM Logic
Oracle Analyst / Developer at A.L. Van Houtte

see less...

13 more...

Education

Oracle University

Recommended

13 people have recommended Patrick

Connections

348 connections

Industry

Information Technology and Services

Websites

My Company

Patrick Hamou’s Summary

Renaps Technology est une firme de services-conseils en technologies de l’information (TI) qui se concentre majoritairement sur les services Oracle de haut niveau. L’équipe Renaps, hautement qualifiée et expérimentée vous aidera à mettre en œuvre vos besoins informatiques. Notre expertise s’étend à aider quelque unes des plus importantes organisations internationales incluant des compagnies du « Fortune 500 », dans un large éventail de secteurs de l’industrie pour répondre à une gamme de difficultés d’affaires. Notre offre Oracle inclut des services d’administration de base de données (DBA), d’experts en développement Oracle Forms, PL/SQL ainsi qu’une expertise unique au Québec de migration Oracle Forms vers 10g ou Java.
===========================================

Renaps Technology is a quality Information Technology (IT) consulting firm focused on the delivery of superior Oracle services. Renaps provides highly skilled Information Technology and Software professionals to solve your mission critical IT project definition and implementation needs. Our expertise extends to helping some of the worlds largest organizations including fortune 500 companies, across a broad range of industry sectors to solve a breadth of business issues.
Our Oracle expertise ranges from Database Administration (DBA) to Forms and PL/SQL Development.
We provide unique Oracle Forms solutions in Quebec; our offering includes a unique Forms upgrade expertise - as well as a migration solution of your Forms to Java.

Patrick Hamou’s Specialties:

Senior Oracle DBA Services, Oracle Forms Development , Upgrade and Migrations to Java Experts

Patrick Hamou’s Experience

Senior Oracle Technical Specialist

Visa Desjardins

(Banking industry)

February 2008 — Present (1 year 6 months)

My role with Visa Desjardins is to provide expert Oracle support on Database Administration as well as to the development team.
Lead Oracle Technical Advisor

Lécuyer et fils

(Privately Held; Construction industry)

March 2007 — Present (2 years 5 months)

As the senior technical advisor and Lead Oracle DBA, I am helping Lecuyer resolve all of the outstanding Oracle issues. Also, I am coaching on-site programmers on SQL, Oracle Forms, and various Oracle matters. I am also the lead Oracle DBA for Lecuyer.
President

Renaps Technology

(Information Technology and Services industry)

April 2001 — Present (8 years 4 months)

Renaps Technology is a quality Information Technology (IT) consulting firm focused on the delivery of superior Oracle consulting services;
IT Services

Various customers in the province of Quebec

(Information Technology and Services industry)

2001 — Present (8 years)

Renaps Technology currently provides IT Services to 14 customers in the province of Quebec:

* IT staffing
* Oracle Forms modernization
* Remote Database Administration

===============================================

Renaps Technology procure présentement des services-conseils en technologie de l'information à 14 clients dans la grande région de Montréal:

* Placement de personnel informatique
* Modernisations Oracle Forms
* Administration de base de données à distance
Lead Oracle Technical Advisor

Quebec Government

(Government Administration industry)

September 2007 — April 2008 (8 months)

3.5 TB data warehouse migration from DB2 to Oracle 10g.
Senior Oracle DBA

SRIC

(Privately Held; Education Management industry)

November 2006 — February 2007 (4 months)

With Sric, I took care of all of the complex and previously unresolved issues with the DBA team on site. Besides taking care of all of the major issues, I also installed and configured Oracle Enterprise Manager Grid Control 10g Release 2.
CIO

Jati Technology

(Information Technology and Services industry)

October 2006 — February 2007 (5 months)

As the CIO of Jati Technologies, I was the head of the information technology group within the organization, reporting to the CEO and the CTO.
Several large scale development projects are under my control. The main database technology used in all projects is Oracle 10g Release 2.
Lead Oracle DBA

Nomura Securities

(Public Company; 5001-10,000 employees; NMR; Investment Banking industry)

May 2005 — November 2006 (1 year 7 months)

Oracle was new for Nomura, one of the worlds most prestigious Japanese Investment Banks; A very strong Oracle DBA was needed to build the infrastructure that will serve for the following years of operation. I was in charge of this task. I created kornshell scripts on Solaris and Linux, Installed and Configured Oracle 10g Grid Control (OEM), RMAN, Data Guard and Oracle Streams - Managed a total of about 100 databases.
I was also the lead Oracle DBA for Peoplesoft HR, EPM & FS, and for NCDI, Teleran and many other critical Oracle systems.
I am still doing some consulting work with Nomura on demand for very specific Oracle DBA projects.
Senior Oracle DBA

Uptodate

(Medical Devices industry)

May 2006 — May 2006 (1 month)

I elaborated a performance and architecture analysis and submitted a complete technical recommendations report for the Oracle Streams Advanced Queuing implementation at uptodate.com.
Manager of data processing operations

Foucray

(Consumer Goods industry)

March 1996 — February 2006 (10 years)

Renaps is taking care of all of Foucray's computer systems; We also build a complete management system for Foucray stores which the following modules: inventory, sales, purchasing, human resources, payroll, book keeping.

Renaps also takes care of :
• Database Administraton (Oracle 10g Express Edition),
• Development work ,
• Application Administration
• System Administration.
Lead Oracle Technical Advisor

Dell Professional Services

(Public Company; 10,001 or more employees; dell; Information Technology and Services industry)

2005 — 2006 (1 year)

Working with Dell Professional Services, my company (Renaps) took in charge and completed with success a major Oracle Forms Upgrade project.
Lead Oracle DBA

US Government

(Government Agency; 1001-5000 employees; Government Administration industry)

March 2005 — May 2005 (3 months)

As the lead Peoplesoft/Oracle DBA for Solano County, I took care of the different Oracle/Peoplesoft databases: HRMS and Time & Labour while the on site DBA was recovering from a medical operation.
This Peoplesoft implementation takes care of the pay for the 2500 county employees.
Senior Oracle DBA

Richemont

(Luxury Goods & Jewelry industry)

January 2005 — February 2005 (2 months)

Richemont is the world’s second most important luxury goods group. Its brands include Cartier, Mont Blanc, Baume & Mercier, and many others.

I joined Richemont in a very short notice and solved all of the most critical Oracle problems I was engaged for in the first week. The client is very satisfied of the results of my work that included the resolution of a critical ORA-01555 (Snapshot too old error) as well as several locks and performance and tuning projects. All of my work was explained to the two DBAs that were on site. They were also given a complete report of the resolutions/actions done.
Senior Oracle DBA

Accenture

(Public Company; Information Technology and Services industry)

April 2004 — November 2004 (8 months)

As the principal Oracle DBA, I completely took in charge the HR database for the main Accenture client in Montreal (Alcan Aluminium), and was the backup for several other Oracle projects (Oracle Financials 10.7 to 11i upgrade). During the 6 months of the contract, I also trained other Oracle DBAs to take in charge HR environments.

• Senior Oracle DBA for Alcan Aluminium (Peoplesoft HR databases)
o Database upgrades from Oracle 8i to 9i;
o Oracle environments refreshes;
o Development support and production migrations;
o Performance tuning at all levels;
o Unix scripts creation (Korn Shell) to monitor several aspects of Oracle environments;
o Upgrade of Peoplesoft Peopletools from 8.16 to release 8.20 on all environments (12 environments);

• Senior Oracle DBA for Alcan (other systems)
o Maintenance of more than 30 other Oracle databases,
o Creation and maintenance of ALL of the Korn Shell monitoring scripts on four new True64 servers,
Senior Oracle DBA

BPR CSO

(Civil Engineering industry)

March 2004 — April 2004 (2 months)

As the Senior Oracle DBA, I brought all the solutions to optimize the performances or the Csoft system that relies on an Oracle 9i Database.
Csoft is a software specifically used for the design and operation of real time control applied to wastewater systems for the city of Montreal, Louisville, Paris, New-York and several other major cities.

• Senior Oracle DBA Oracle 9i Release 2
o Configure memory resources and disks repartition to optimize performances;
o Tuned specific processes and presented SQL recommendations to have the application run as smoothly as possible.
o Provided recommendations on the general administration of the database;

The performances were enhanced by 10000% for the most important processes of the application.
Lead Oracle DBA

IBM Global Services

(Public Company; 10,001 or more employees; IBM; Information Technology and Services industry)

August 2002 — March 2004 (1 year 8 months)

At IBM's La Gaude facility, France, I was part of the unique Peoplesoft Team as the lead Oracle DBA for the group.
I had the chance to act on Europe’s largest accounts including Total Fina Elf (Number 15 on the Global 500) in the PXL project which is the implementation / administration of Peoplesoft HRMS across the world as the lead Oracle DBA. I Also worked on several Danone and Brink's projects,and have taught Oracle courses on the following subjects :
o Oracle internals
o Backup and recovery
o Performance and Tuning
o Oracle Networking (Net8)
Senior Oracle DBA

Transcontinental

(Public Company; Publishing industry)

April 2002 — July 2002 (4 months)

My main goal as a Senior Oracle DBA within this project was to handle the upgrade of Peoplesoft HRMS (from 7 to 8);
Senior Oracle DBA

Noranda

(Public Company; Mining & Metals industry)

April 2000 — March 2002 (2 years)

Occupation : Principal Oracle Database Administrator

• Principal DBA for all of Noranda head office databases (Toronto)
• Coaching to other DBAs and Application developers
• Expert DBA for all the head office HR databases (mostly PeopleSoft)
• DBA for the Oracle Financials databases and for Indus Empac databases
• DBA of Noranda’s Data Warehouse
• DBA of PeopleSoft7 and for the upgrade to Peoplesoft8 on Oracle 8i
• Performance tuning on various Oracle cases
o SQL tuning
o Oracle instances tuning
o I/O distributions
o Bottleneck determination.
• Daily maintenance and support for approximately 40 Oracle databases
Oracle Technical Specialist

JBM Logic

(Information Technology and Services industry)

May 1999 — April 2000 (1 year)

Occupation: Oracle Technical Specialist

• Oracle Instructor
- Oracle Database Administration and Application Development training for JBM clients and partners

• Principal Oracle DBA for “Le Groupe Lacasse” (one of Canada’s Fortune 500 company)
- Backup and Recovery,
- Performance tuning,
- SQL and PL/SQL support for the programmers,
- Data modeling and programming

• Occupations at JBM Logic
- Principal Oracle DBA.
- Oracle installations and support for all JBM clients,
- Programming and programming support in SQL, PL/SQL, Forms et Reports
- SQL tuning.
Oracle Analyst / Developer

A.L. Van Houtte

(Food Production industry)

September 1998 — May 1999 (9 months)

Occupation: Oracle Analyst/Programmer --> special projects.

• Special projects manager
• Data modeling for several projects
• Forms and Reports development under Develloper/2000
• Quality control and full cycle implementation