Marc Gendreau Email & Phone Number

• Define best practices for Business Intelligence (BI), Partitioning DB2 v9, Analysis, Design, Programming and installation of several Business Intelligence (BI) projects using DataStage PX application (Dividends.
• Define and analyze needs with the client(s).
• Profiling and cleaning up of the data from the source systems in order to detect problems during extraction.
• Functional analyses for data warehouse extraction, transformation and loading programs according to the specific needs.
• Design and arrange the scheduler script for the extraction, transformation and loading.
• Develop UNIX scripts in order to automate the execution of the DataStage programs by the schedule.

• Design and install several interfaces in compliance with the new Law C198 (Sarbanes – Oxley Canadian). Incorporate their ITC billing systems with their High Speed Internet and IP Telephony provisioning system (SMP).
• Develop in webMethods: SOAP-RPC, XML, JDBC adapters notifications.
• Provide technical analysis with the newly built programs.
• Data profiling during analysis and update the business documents.
• Elaborate and build a prototype for the business and management community.
• Design the SQL scripts for data extraction, table creation, sequences, etc.

• BI and EAI Developer (DataStage and WebMethods), Business and Functional Analyst.In charge of the implementation of several interfaces, data warehouses and their data extraction. Managing and planning the execution of.
• Develop in DataStage with Designer, Manager, Director, Version Control.
• Develop exceptions reports written in DataStage and develop error management in webMethods.
• Deploy the DataStage programs.
• Modify the existing UNIX scripts.
• Design the SQL scripts for data extraction, table creation, sequences.

• Responsible for all information technology activity in the Region, the maintenance of all PCs and servers and user technical support.
• Upgrade the TCP/IP network.
• Install and upgrade the infrastructure (Servers, Routers, Switch).
• Purchase PC’s for the region network.
• Prepare the budget and monitor the region’s expenses.
• Assist and ensure user technical support.

• In charge of development, deployment and technical support of manufacturing system software.
• Install MAXIMO and its API in 16 plants.
• Develop the conversion programs between CMMS and MAXIMO with Oracle SQL.
• Define the business rules with the people in charge of the team (Maintenance, Finance, etc.).
• Execute the integration between MAXIMO and Oracle Financial.
• Coordinate the installation of the MAXIMO systems following the acquisition 3 new plants.

• Deployment of PC network infrastructure with the implementation of several Novell file servers.
• Automate the bank reconciliation, the General Ledger Journal Entries with the use of a spreadsheet.
• Participate in the triennial plan for computer systems development in the region.
• Documentation of information system and business procedures.Environment: Novell 3.12 & 4.01, DOS 6.1, Windows 3.11/95, VAX, CMMS, Lab.

• Conversion and implementation of a new CMMS maintenance system.
• Definition of a new standard for code changes by programmers.
• Ensure computer support for several proprietary programs including the systems of Plant Cost, key performance indicators (KPI), inventory, maintenance and payroll.
• Prepare user and procedures documentation.
• Administrator of the VAX VMS systems.Environment: VAX, Basic, Powerhouse, COBOL, FORTRAN.

• Ensure computer support for several proprietary programs including the systems of Plant Cost, key performance indicators (KPI), inventory, maintenance and payroll.
• Prepare user and procedures documentation.
• Administrator of the VAX VMS systems.Environment: VAX, Basic, Powerhouse, COBOL, FORTRAN

Responsible for computer support of several proprietary programs for all the administrative and financial functions of the business.Environment: VAX, Basic

Responsible for the conception of an inventory system for bottle labels. Support and upgrade of the newly created software.Environment: PC-DOS, Sensible Solution & ODBS, DBase III+.

Diploma In Computer Science

High School Diploma, General