Jean Francois Patchez

I'm a consultant who has over 30 years experience in information technology. Over the past 20 years, I worked mainly in the field of business intelligence. My intervention in projects of great complexity have earned me the confidence of my customers and peers. 

I acquired a great expertise with many tools, such as IBM Websphere Datastage (Certified with PX). I'm recognized for the effectiveness of my achievements. I obtained a “DESS Informatique” diploma from the University of Paris, which is equivalent to a Masters degree in Information Technology. 

I'm rigorous in my approach and I developed the ability to easily adapt to new environments. Moreover, I'm very appreciate for the quality of my work. I know the agile methodology and Jira. 

Videotron – 1.5 years (June 2022 – Febuary 2023) - Freelancer 

Datastage 11.7 Analyst and Developer 

Business Intelligence Advisor – Domain: Telecom 

As part of the DB2 to IIAS migration and Etiya integration projects, I participated in the analysis, development and testing. 

The DB2 to IIAS migration project aims to migrate data from the DB2 database to the IIAS database using datastage jobs and unix scripts. 

The Etiya integration project allows the transfer and integration of data from Videotron subsidiaries in the staging, datawarehouse and datamarts. 

It should be noted that the projects were managed in agile mode with the use of Jira software. 

In this context, I carried out the following activities: 

• Creation of tasks with Datastage 11.7 (coding and testing). 

• Creation of Unix scripts (Kornshell). 

• Development of scenarios and test documents. 

• Creation of Tivoli schedules. 

• Creation of SQL queries. 

Environment: Datastage 11.7 PX, UNIX (Kornshell Script), DB2, Toad, Tivoli, Jira. 

** CGI - 13 years (October 2007 – June 2022) - Business Intelligence Consultant 

Desjardins – 2 years (May 2019 – May 2022) with CGI 

Analyst and Developer team lead Datastage 

Business Intelligence Consultant – Bank 

As part of EID (Data Integration Exchange) and FinTPE projects, I participated in the analysis, development and testing. 

The FinTPE project aims to feed the SalesForce application with various data sources (Rest API, text file). The FinTPE application allows online financing to TPE (Very Small Business) members and thus free up time for front-line employees. 

The EID project enables the validation of text files and the transfer of data via MFT between source and recipients.      

In this context, I have achieved the following tasks: 

Canadian National – 8 months (September 2018 –March 2019) with CGI 

Analyst and Developer Datastage 

Business Intelligence Consultant – Rail transport 

As part of the Catalyst project, I participated in the analysis, development and testing. The Catalyst project aims to feed the Catalyst application with various data sources via the Catalyst API.  

In this context, I have achieved the following tasks: 

• create tasks with DataStage 11.5 (coding and testing); 

• develop scenarios and test documents; 

• create SQL queries with Oracle and sql-server; 

• create UNIX scripts in Korn Shell. 

• create schedules with the ESP scheduler; 

• create Datastage job using java code to request LDAP; 

• use the ISPW source manager  

Environment: DataStage 11.3 PX, UNIX, Oracle 12.1, SQL Server 2008 R2, Toad, XML, API, Jira, Service Manager, ISPW, Java.  

Desjardins – 1 year (August 2017 – July 2018) with CGI 

Analyst and Developer Datastage 

Business Intelligence Consultant – Bank 

In the SAM (Suspicious Activity Monitoring) project of the HBA (Stop Money Laundering) service and the EID (Exchange Data Integration) project, I participated in the analysis, development and testing. 

The SAM project aims to monitor the activity of bank clients to detect fraudulent activities (money laundering, ...) using modules of the Actimize application that generates alerts. The data sources are daily text files produced by the mainframe SIC system (Integrated Caisses System) and then validated via the SEM system (System Exchange Movement). DataStage tasks are developed to feed the Actimize staging tables daily. 

The EID project allowing the validation of text files and transfer of the data via MFT between the source programs and the zr0 zone of the project OSF (Optimization Financial Systems) which uses the model of data FSDF (Financial Service Data Foundation). Datastage jobs are run by the autosys scheduler according to their frequency (monthly, weekly, daily).         

In this context, I have achieved the following tasks: 

Videotron – 3.5 years (September 2013 – April 2017) with CGI 

Analyst and Developer Datastage 

Business Intelligence Consultant – Telecom 

In the project InfoHub, Fondation Netezza, Espace Client Mobile, Paiement Mobile and Itinérance forfaitaire, I participated in the analysis, development and testing. 

The goal of the InfoHub project was to create an intermediate database (equivalent to an ODS) to feed multiple target. In order to do integrated transactions, I had to use a Working Queue, the queue manager, the transaction manager and the stage Distributed Transaction (DTS).   

The Netezza Foundation project aimed to replicate DB2 tables in a Netezza database using Datastage jobs 

The Espace Client Mobile project aimed to give access to the client area of Vidéotron from a mobile phone. To do this, I had to feed new tables of the InfoHub project from multiple source. (Text File, Message Queue). 

The project Paiement Mobile aimed to allow payments with mobile phone. In order to do that, I had to feed new tables from the Datawarehouse to do Business Objects reports. 

The other projects were in the datawarehouse to feed dimensions and facts for Business Objects reports. 

In this context, I have achieved the following tasks: 

•           Creating of Datastage 9.1 jobs; 

•           Creating of Unix Scripts in Korn Shell; 

•           Creating of the test documentation; 

•           Creating of SQL Query in Oracle 11, DB2 and Netezza. 

The projects were managed in agile with the Jira software. 

Environment: Datastage 9.1 PX, UNIX, Oracle 11g, DB2 10.5, Netezza 7.2, PL/SQL, Toad, Jira 

Laurentian Bank (BLC) – 8 months (November 2012 – July 2013) with CGI 

Multiplex real estate Mortgage – Analyst and Developer (OWB and PL/SQL) 

Business Intelligence Consultant – Bank 

For the Multiplex Property Mortgage project, I participated in the analysis, development, and testing. The goal of the project was to preserve customer history in the data warehouse during the migration of mortgages from one system to another. Meetings were held with users to identify migration rules followed by the development, testing, and production phases. Afterwards, daily processing was implemented to gradually migrate mortgages. 

In this context, I performed the following tasks: 

•           Creating OWB and PL/SQL jobs; 

•           Conducting analysis and meeting with users to determine the rules of migration; 

•           Creating the testing documentation; 

•           Writing SQL queries in Oracle 11. 

Environment: UNIX, Oracle 11, Oracle Warehouse Builder, PL/SQL, SQL Loader, Toad 

Laurentian Bank (BLC) – 1.5 years (May 2011 – October2012) with CGI  

Analyse and creation of Oracle Warehouse Builder jobs 

Business Intelligence Consultant – Bank 

The purpose of this project was to provide files to CDIC (Canada Deposit Insurance Corporation) in the case of bankruptcy to reduce the time needed to repay the bank’s customers. To do this, we had to feed an intermediate database (equivalent to an ODS) from files produced by the mainframe.  

The files were loaded using SQL Loader into staging tables and then into the intermediate database with the ETL Oracle Warehouse Builder (OWB). Subsequently, this data was transferred to an SAD database (equivalent to a data mart), then an IDD database to be formatted as the target files. Finally, text files with the CDIC format were produced from the IDD database.  

In this context, I performed the following tasks: 

•           Creating OWB and PL/SQL jobs to feed the ODS; 

•           Creating the testing documentation; 

•           Creating SQL queries in Oracle 11; 

•           Creating Unix scripts in Korn Shell to copy files; 

•           Analyzing and optimizing the performance of SQL queries and OWB jobs by changing the settings; 

•           Comparing the results from the data warehouse with those obtained in the ODS. 

Environment: Unix, Oracle 11, Oracle Warehouse Builder, PL/SQL, SQL Loader, Toad. 

National Bank Financial Group – 1 year (May 2010 - May 2011) with CGI 

Creation of Websphere Datastage Parallel PX jobs 

Business Intelligence Consultant – Bank 

The goal of this project was to feed the data warehouse from multiple data sources using WebSphere DataStage PX 8.1.  

My tasks were as follows: 

•           Creating DataStage PX 8.1 jobs; 

•           Creating the testing documentation; 

•           Writing SQL queries in Oracle 11; 

•           Analyzing the analysis documentation to create the DataStage jobs and communicating with the DBA to create the table. 

Environment: Unix, Oracle 11, Websphere Datastage 8.1 Parallele PX. 

Yellow Pages Group – 2.5 years (October 2007 - April 2010) with CGI 

Creation of Websphere Datastage Server jobs 

Business Intelligence Consultant – Directory Sale 

The goal of this project was to feed the Siebel software using DataStage.  

In this context, I was responsible for the following tasks: 

•           Analyzing and modifying DataStage 7.5 Server jobs and fixing bugs in production; 

•           Creating a schedule for Control-M; 

•           Providing support for DataStage; 

•           Writing SQL queries using Toad; 

•           Creating EIM jobs and IFB files for Siebel. 

Environment: Unix, Oracle, Websphere Datastage Server 7.5, Control-M, Siebel, EIM Siebel. 

** IBM/LGS  -  2 years (November 2005 - September 2007) - Business Intelligence Consultant 

IBM Global Services US - 7 months (October 2006 - July 2007) with IBM/LGS 

Creation of Websphere Datastage Parallel PX jobs 

Business Intelligence Consultant – IBM 

The goal of this project was to feed the data warehouse and data marts to analyze sales.  

In this context, I carried out the following tasks: 

•           Creating DataStage PX jobs; 

•           Creating UNIX scripts to archive the data in DB2 tables; 

•           Writing DB2 queries using Brio. 

Environment: UNIX, DB2, Websphere Datastage Entreprise 7.1 

National Bank – 6 months (February 2006 - July 2006) with IBM/LGS 

Maintenance of Websphere Datastage Enterprise jobs 

Business Intelligence Consultant – Bank 

The goal of this project was to feed the data warehouse from multiple data sources.  

My tasks were as follows: 

•           Analyzing and modifying DataStage PX jobs in order to perform the maintenance to feed the data warehouse; 

•           Updating the PERL script with UNIX to add new tables; 

•           Writing DB2 queries using Aqua Data Studio; 

•           Updating the project documentation using Rational Portfolio Manager. 

Environment: UNIX, DB2, Websphere Datastage Entreprise 7.1, Script PERL, Rational Portfolio Manager. 

Charles River Laboratories – 2 months (November 2005 - December 2005) with IBM/LGS 

Analyzes and creation of WebIntelligence reports and universe with Business Objects XI 

Business Intelligence Consultant – Pharmaceutical 

In this role, I analyzed and created Web Intelligence reports with Business Objects XI in order to automate the production of end-of-month documents for the QA department.  

Specifically, my tasks were as follows: 

•           Analyzing old Excel documents and determining the data sources in collaboration with a Charles River Laboratories programmer/analyst;      

•           Creating a universe and Web Intelligence reports in Business Objects XI; 

•           Training users in Business Objects XI (Universe and Web Intelligence reports creation); 

•           Creating training and project documentation. 

Environment: Windows NT, SQL Server, WebIntelligence and Business Objects XI. 

** ODESIA - 1.5 years (Janvier 2004 - August 2005) - Business Intelligence Consultant 

SITA – 6 months (March 2005 - August 2005) with ODESIA 

Analysis and creation of mapping and workflow in Informatica 7 

Business Intelligence Consultant – Air Transport 

The goal of this project was to feed an ODS, a data warehouse, and a data mart with various data sources. This involved analyzing call centre activities using Web Intelligence reports (Business Objects XI).  

In this context, I carried out the following tasks: 

•           Creating mapping and workflows with Informatica; 

•           Installing a loading strategy to enable the automatic correction of erroneous data; 

•           Analyzing and determining data sources in order to feed the data warehouse; 

•           Producing project documentation; 

•           Performing the initial load. 

Environment: UNIX, Oracle 8, Informatica 7. 

Dynamite – 2 months (January 2005 - February 2005) with ODESIA 

Analysis and creation of mapping and workflow in Informatica 7 

Business Intelligence Consultant – Clothing trade 

The goal of this project was to create an ODS. 

In this context, my tasks were as follows: 

•           Analyzing the current situation with a team and building the analysis file; 

•           Creating Informatica data mapping to load the data from COBOL files. 

Environment: Windows NT, SQL Server, Informatica 7. 

Teleglobe – 10 months (February 2004 - November 2004) with ODESIA 

Analysis and creation of WebIntelligence reports and universe in Business Objects 6.1 

Business Intelligence Consultant – Telecommunications 

The goal of this project was to use Business Objects to create reports in an Oracle Financials environment.  

I performed the following tasks: 

•           Creating a universe and reports with Business Objects and Web Intelligence; 

•           Installing and configuring a Web Intelligence server; 

•           Analyzing user needs and documentation; 

•           Creating and training users; 

•           Installing development, testing, and production environments with migration procedures; 

•           Analyzing mapping in Informatica to determine the data sources to feed the data warehouse. 

Environment: Windows NT, Oracle 8, Business Objects 6.1. 

HOLCIM – 4.5 years (August 1998 - January 2003)  

Installation of an ERP and Business Objects 5 reports 

Oracle Database Administrator and Analyst for the installation of an ERP – Sale of cement and concrete 

In this context, my tasks were as follows: 

•           Analyzing user needs and configuring the software package Generix for the management and accounting modules; 

•           Creating and maintaining PL/SQL procedures and Business Objects universe and documents; 

•           Developing a Lotus Notes Domino 5 application to manage user requests; 

•           Creating MS Access and WinDev interfaces to link the Real Estate and Banking software (Cerg), the Payroll software (Arcole), and the ERP (Generix). 

Environment: UNIX, Oracle 7, Business Objects 5. 

Caisse de retraite de La Réunion – 1 year (June 1997 - July 1998)  

Data migration and installation of a Pension Plan management application 

Sybase Database Administrator and Project Leader to migrate data from a DPS6 to a RS6000 (UNIX) – Pension Plan Management 

In the context of a data migration from a DPS6 to a RS6000 (UNIX) and installation of a pension plan management application, I performed the following tasks: 

•           Analyzing the source system data recovery and upgrading an MS Access migration application and documentation; 

•           Migrating data from the source system; 

•           Providing technical support for a pension plan management software package in collaboration with remote teams in France; 

•           Managing user issues and software upgrade installations; migrating the Sybase database to a new version; and developing a pensioner statistics application in MS Access. 

Environment: UNIX, Sybase, Access. 

AXA Assurances – 1 year (September 1995 - September 1696)  

Installation of a reporting tool 

Programmer Analyst COBOL / CICS – Insurance 

In the context of installing a reporting tool enabling daily follow-up of the company’s, brokers’, and recovery companies’ activities, I performed the following tasks: 

•           Programming in COBOL and CICS on an IBM 4381/VM; 

•           Analyzing and modifying the accounting batch job scheduler; 

•           Installing and validating production data. 

Environment: CICS, COBOL, JCL. 

SOCREDO – 8 months (June 1994 - January 1995)  

Data migration 

Programmer Analyst COBOL / CICS – Bank 

I managed 150,000 deposit accounts within the context of a data migration.  

My tasks were as follows: 

•           Performing application maintenance and integration into the batch job scheduler; 

•           Programming in COBOL. 

Environment: CICS, COBOL, JCL. 

Office des Postes de Tahiti – 5 months (January 1994 - May 1994)  

Installation of a new invoicing system 

Programmer Analyst COBOL / CICS – Telecommunications 

For this project, I made changes in the COBOL billing programs to install a new invoicing system. Specifically, my tasks were as follows: 

•           Programming in COBOL and CICS; 

•           Programming and developing reports; 

•           Providing software support 

Environment: CICS, COBOL, JCL. 

Caisse de Prévoyance Sociale de Tahiti – 4 months (September 1993 - December 1993)  

Installation of a new health insurance system 

Programmer Analyst COBOL / CICS – Social insurance 

In the context of installing a new health insurance system, he was responsible for the following: 

•           Programming in COBOL and CICS; 

•           Developing and maintaining programs on an IBM 4381/VSE under the supervision of his project leader; 

•           Making changes in the COBOL program. 

Environment: CICS, COBOL, JCL. 

DESS Informatique University of Paris (equivalent to a “Masters degree in Information Technology” – 1992.