Patrick Hamou

Current

• Senior Oracle Technical Specialist at Visa Desjardins
• Lead Oracle Technical Advisor at Quebec Government
• Lead Oracle Technical Advisor at Lécuyer et fils

• President & Principal Consultant at Renaps Technology

see less...

1 more...

Past

• 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...

12 more...

Education

• Oracle University
• maimo

Recommended

11 people have recommended Patrick

Connections

272 connections

Industry

Information Technology and Services

Websites

• My Company
• My Blog

Patrick Hamou’s Summary

Renaps Technology is a quality Information Technology (IT) consulting firm focused on the delivery of superior Oracle consulting 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 Expert Database Administration (DBA) to Expert Forms and PL/SQL Development, we also provide complete Peoplesoft, SAP and Documentum services.

Patrick Hamou’s Specialties:

Senior Oracle DBA Services, Oracle Forms Development and Upgrade Experts, Expert Oracle Streams Implementor, Complete Documentum Administration, Peoplesoft Technical Administration, SAP Development and Customization Team.

Patrick Hamou’s Experience

• Senior Oracle Technical Specialist

  Visa Desjardins

  (Banking industry)

  February 2008 — Present (9 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

  Quebec Government

  (Government Agency; 10,001 or more employees; Government Administration industry)

  September 2007 — Present (1 year 2 months)

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

• Lead Oracle Technical Advisor

  Lécuyer et fils

  (Privately Held; Construction industry)

  March 2007 — Present (1 year 8 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 & Principal Consultant

  Renaps Technology

  (Information Technology and Services industry)

  April 2002 — Present (6 years 7 months)

  Renaps Technology is a quality Information Technology (IT) consulting firm focused on the delivery of superior Oracle consulting services; we also provide complete Peoplesoft, SAP and Documentum services.

• 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

Patrick Hamou’s Education

• Oracle University

  Certified DBA, Certified Application Developer, Oracle, 1999 — 2002

• maimo

Additional Information

Patrick Hamou’s Websites:

• My Company
• My Blog

Patrick Hamou’s Groups:

Business Connection

•    TEN - Top Executives Net
•    Oracle Bloggers
•    TalentBar: HR and Recruiter Network
•    Database Experts
•    ORACLE PRO

Patrick Hamou’s Contact Settings

Interested In:

• consulting offers
• new ventures
• job inquiries
• expertise requests
• business deals
• reference requests
• getting back in touch