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, AccèsD, Cost management per activity, BD Expert, Law C37, VISA New Bin, Sales Management – Re-run & History, Tranfers Between Individuals – Automatic Teller, Sales Transit, Request for business financing, Microfiches).• 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.• Develop UNIX scripts for restructuring tables and cleansing expired data.• Develop scripts in order to invoke the UNIX scripts by the Autosys scheduler.• Fill the required forms for migration of the new programs (Impact and volume awareness documents, troubleshooting document for support team, etc.)• Preparation and follow-up of the programs to implement the projects. • Assist with the implementation and post-installation of projects while insuring proper functionality with the new programs. Environment : UNIX (Korn Shell), DataStage PX, SQL, DB2, Processus Desjardins methodology (internal PDD), INFOMAN, PVCS, Autosys, Lotus Note.

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.• Implement the standard for errors and exclusions.• Develop a code according to the standards and practices dictated by the company while insuring that functions and business processes are encapsulated and reusable.• Develop the business process models with webMethods Designer utility.• Perform unit and integrated testing with all the applications involved.• Deploy the programs with webMethods Deployer utility.• Manage and plan the tasks of execution using the Scheduler utility.• Control the data flow between applications.Environment : Oracle 10g, webMethods 7.0, Windows, SMP, TNOM, ITC.

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 tasks with a view to the transition towards a new ERP system. Assist the project managers (O2C, P2P, CRM) with the extraction of their data to the ERP system.• 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.• Data design and modeling.• Develop in WebMethods with Developer, Designer (Modeler), Trading Network (EDI).• Document the business and technical needs.• Do the business analysis following the methodology governed by the politics of the company.• Assign tasks to team and follow their progress with an eye to the deadline.• Profile data during analysis and update business documents.• Coordinate common activities with those responsible for the infrastructure (DBA, UNIX).• Prepare a progress report on the evolution of the work.• Coordinate the EDI transfers with the VAN suppliers and the business partners.• Ensure a follow through and optimisation of data flow between applications.• Ensure a good transition to an ERP Environment.• Help the project managers (O2C, P2P, CRM) with the extraction and transition of their data.• Responsible for 3 to 6 people.Environment : DataStage 7.1, Oracle 9i et 10g, EnterpriseOne (ERP), webMethods 6.5, EDI, UNIX.

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.• Coordinate with the head office the putting into production of the new MAXIMO Projects.• Administrate the Novell network.• Ensure proper functioning of existing servers (Novell, Lotus Notes, UNIX, VAX).• Manage the equipment service contracts.• Upgrade the network’s transport lines.• Participate in the evaluation of a PC purchase plan with various suppliers (Toshiba, Dell, IBM, etc). • Manage software licenses.• Obtained savings of 15 per cent on PC purchases.• Responsible for 2 to 3 people.Environment : Novell, Windows XP/2000/98, UNIX, VAX, CISCO, MAXIMO, Oracle Financial,Oracle Database, LANDESK

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.• Implant a Bar Code system for Payroll and Inventory.• Design the interface between the laboratory system and the X-ray machine.• Implant a new help system for users of HEAT.• Develop UNIX scripts for the interfaces.• Coordinate and assign the activities for new employees on the team.• Program the modifications to be made in regard to the changeover to the year 2000.• Mentor to team members.Environment : Oracle Database, Impromptu, Powerplay, UNIX, VAX, MAXIMO, GEMMS, HEAT, Oracle Financial, Windows 95/98.

• 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