François Desaulniers

475, Prince-Edouard street, Suite 302

Quebec City (Quebec)

Canada - G1K 9G8

(418) 953-9531

Email : francois@desaulniers.com

DMR Conseil

30

DND (KMS)

Knowledge Management System

09-08

06-09

System analyst

Fernand Boudreau

(418) 653-6881

9

12 500

29

CSST

Modernisation of the services at CSST

04-07
06-08

System analyst

Sylvio Rancourt
418 266-4321

14

40 000

28

DMR

NeoBatch training

07-04

07-04

Course designer

Pierre Jutras

(418) 933-1716

1

---

27

CSPQ

SAGIR project : Implementation of the Oracle PGI

04-06 to date

Service Level Coordinator

Sylvain Montour

(418)528-2059

34

10 000

26

MRQ

Electronic exchanges - Inscription of the preferences

04-04 to 04-06

System analyst

Dany Richard
(418) 652-4985

2

10 000

25

DMR

DMR Conseil Internet site

02-04 to
03-04

Technical and System analyst, pro­grammer

Isabelle Laterreur
(418) 653-6881

2

---

24

MTQ

SAGIR project: analysis of the inter-system data flows

12-03 to
02-04

System analyst

Charles Perrault
(418)380-2005

3

11 1500

23

MRQ

Conversion in XP-M3 of the TP1 System and of the Data Warehouse

10-02 to
11-03

System analyst and

ana­lyst-programmer

Laurent Dion
(418) 652-5716

12

1000

22

MESS

Adaptation of the Income Security systems for the production of the R1/T4A R5 statements

06-02 to
09-02

System analyst and

ana­lyst-programmer

Yves Couillard
(418) 653-6881

3

1400

21

MAMM

Integration of the districts and the multiple rates of taxes to system ACQ

01-02 to
03-02

System analyst and

ana­lyst-programmer

Michel Beauchemin
(418) 653-6881

3

400

Bank of Canada

(Mandate with Kishi Konsulting Inc..)

20

RDMS Project

03-01 to
12-01

System analyst and

ana­lyst-programmer

---

9

1800

Public Works and Governmental Services Canada

(Mandates with Systematix Inc.)

19

GOS - production of cheques center

12-00 to
02-01

Process analyst

Peter Lwow
(819) 956-2718

3

5000

18

GOS – quality assurance, Internet documentation project

12-99 to
11-00

System analyst

John Hunter
(819) 956-1971

12

3000

Public Works and Governmental Services Canada

(Mandates with Kishi Konsulting Inc.)

17

Pension system – Streamlining project

01-99 to
11-99

System analyst

Annie Archambault
(819) 956-1167

11

100 000

16

Pay System

10-97 to
12-98

System analyst

Annie Archambault
(819) 956-1167

14

100 000

15

Common Architecture system

04-97 to
09-97

Ana­lyst-programmer

Peter Tighe
(613) 748-4067

5

10 000

Employment and Immigration Canada

(Mandate with Kishi Konsulting Inc.)

14

IPAR system

04-96 to
04-97

Ana­lyst-programmer

---

12

---

Public Works and Governmental Services Canada

(Mandate with Veritaaq Technology House Inc.)

13

Pension system

10-95 to
03-96

Ana­lyst-programmer

Beverly Miller
Peter Kluver

5

---

Revenue Canada, Customs and Excises

(Mandates with Veritaaq Technology House Inc.)

12

TRS application

07-93 to
09-95

Ana­lyst-programmer

---

26

---

11

HRS application

06-92 to
06-93

Ana­lyst-programmer

---

12

---

Supplies and Services department Canada

(Mandate with APG Inc.)

10

Corporate PASS system

01-92 to
05-92

Ana­lyst-programmer

---

4

---

Supplies and Services department Canada

(Mandate with Veritaaq Technology House Inc.)

9

Pay system

01-91 to
12-91

Ana­lyst-programmer

---

12

---

Via Rail inc.

(Mandate with APG Inc.)

8

IMPS system

03-90 to
12-90

Ana­lyst-programmer

Pierre Charrette

9

---

Bombardier inc.

(Mandate with APG Inc.)

7

Warranty and Insurance systems

09-89 to
03-90

Ana­lyst-programmer

---

6

---

Canada Post Corporation

(Mandate with Systems Network Inc.)

6

System information and Time Costing System

09-89 to
04-89

Ana­lyst-programmer

---

6

---

Énergy, Mines and Resources Canada

(Mandate with Systems Network Inc.)

5

Student hiring system

04-89 to
02-89

Ana­lyst-programmer and technical support

---

3

---

Canada Post Corporation

(2^nd, 3^rd et 4^th student work term - University of Sherbrooke)

4

System information

08-88 to
05-88

Ana­lyst-programmer

---

4

---

3

Architecture Processing, S.I.G

12-87 to
09-87

Ana­lyst-programmer

---

4

---

2

Priority Post Track and Trace System

12-86 to
09-86

Programmer

---

4

---

Quebec Communications Department

(1^st student work term - University of Sherbrooke)

1

Central Information Office

04-86 to
01-86

Programmer

---

4

---

Amicale des sommeliers du Québec

Volunteer

---

Design and maintenance of the web site

09-97
to date

Webmaster

---

144

---

Nº 30

System analyst

9 months

Knowledge Management System

09-2008 to 06-2009

DND (KMS)

The main objective of the project is to provide the Department of Defense a national collaborative knowledge management system that will provide Canadian Forces the flexibility to structure its 
knowledge in order to share with one or more groups, receive any feedback from key participants on specific subjects thus a multi workflow, and multiuser multienvironnement. 
KMS offers a collaborative environment supporting the Canadian Forces military personnel in their process of knowledge management such as lessons learned, doctrine and support systems. 
The application facilitates the synchronization between these three areas and standardize the help of all the systems in LFC2IS ( "Land Forces Command and Control Information System). It will help context-oriented task of the military, improve and facilitate training and feedback (feedback) from the staff military aspects of all areas and formalize the exchange of information and knowledge between the organizations of the army. 
The system has undergone periodic deliveries under the Land Force Command and Control Information System (LFC2IS) since the introduction of contract development and maintenance in February 2005. 
Working as an analyst, Mr. Desaulniers is working to functional analysis of central processing units (SDS), records functional testing (TVPR) and achievement tests (TVRR). M. Desaulniers acts specifically on the structure activities and various other folders. This role led him to make sure to bring the case in many analysis, implementation, testing and the delivery into production..

Environment : Windows Microsoft Office Suite (Word, Excel, Power Point, Visio), Microsoft Visual SourceSafe, Entreprise Architect, RA Quest, Mantis, Linux Ubuntu 8.10 and 9.04

Method : Macroscope adapted with IEEE 12.207 standards

Nº 29

System analyst

14 months

Modernisation of the services at CSST

04-2007 to 06-2008

Workplace health and Safety Commision / Commission de la santé et de la sécurité du travail

(CSST)

In order to get a quick response for its business needs while minimizing the future costs of integration, improvement and development, CSST decided to carry out the modernization of its services on the basis of an existing commercial solution. The Modernization of the services at CSST project is a complete overhaul of mission systems for the CSST based on Oracle software solutions (Financial suite), Siebel (CRM) and Fair Isaac (business rules).

CSST has entrusted DMR with the full responsibility for the configuration and implementation of the solution. Overall, the scope of the corporate project is to modernize all services about repair system, financing system, prevention / Inspection and Administration systems, and all this in both direct service and in terms to support it. The specific scope of work for DMR requieres several deliveries spanning from May 2006 to 1 December 2008, followed by a period of maintenance and keeping the solution until December 2010.

Working as an analyst, Mr. Desaulniers works with the integration team to analyze Interfaces (MD050), the functional testing kits (TE030) and the tests themselves (TE080). Mr. Desaulniers operates particularly as a leader of system interfaces folder between the bank, CSST and the agent hub of the commission. That role led him to make sure to bring the case to many in the analysis, implementation, testing and delivery in production.

Environment : Oracle eBusiness Suite 11i, Oracle Content DB, Customer Data Hub, XML Publisher, Business Process Execution Language (BPEL), Ascent Capture, RigthFax, Oracle Collaboration Suite, Cisco ICM, OID, DBMS Oracle 10g, Windows 2003 DataCenter Edition, Windows 2003 Enterprise Edition, Windows Active Directory, HIS gateway, BizTalk, SharePoint and Content Management Server, IIS web server, SAS BusinessObjects DB2, Unisys Itanium2 server, HP Proliant server.

Methodology : AIM

Nº 28

Course designer

1 month

NeoBatch training QF01

04-2007 to 04-2007

DMR Conseil

NeoBatch from Fujitsu is a mainframe file management tool using the Microsoft Windows plateform. It allows to catalog PDS, datasets and members, to edit them, to make a scan on JCLs and to execute them as it is done on a mainframe. The current course in English is designed for all NeoBatch users. The new course however is for French-speaking operators at Desjardins Groupe d'Assurances Générales (DGAG).

Mr. François Desaulniers acted as a designer of the NeoBatch course. He identified the tool functionalities in its English version which are needed at the client (DGAG), prepared the course plan, the trainer guide and the student material - presentation, exercises and solutions. He validated the contents and simulated the presentation with a NeoBatch expert and several people involved in order to extract what is required at the client site from the tool specifications (and translated them in French).

Environment : NeoBatch, MS Power Point, HTML, Print Key, MS Paint, MS Word, MS Excel, Windows XP.

Methodology : DMR P+

Nº 27

Service level coordinator

34 months

SAGIR project : Implementation of the Oracle PGI

06-2004 to 03-2007

Quebec Shared Services Center

(CSPQ)

The development of the SAGIR system and its maintenance require the installation and the coordination of a support team for the development for the administration activities of the Oracle PGI, of the resolution of the incidents, realization of the change requests, management of the test environments, and management of the technological changes. Processes of management of the change requests, management of the configurations (30 development environments) and of management of the incidents were analyzed, established and documented in order to optimize the service of support for the development teams. The established processes are based on the ITIL practices.

Mr. François Desaulniers acted by way of coordinator of the EPC (Environments, Problèmes and Changes), of coordinator of the tests of maintenance and person in charge for the follow-up of the changes.
He conducted the weekly committee of the gathering EPC of the representatives of each following group: functional architects, the technological team, owners of the environments, system administrators, the technological team of Oracle, etc. This committee discusses the decisions to take in regards with the incidents and the change requests of strong gravities, and about the evolution of the environments. On a daily basis, Mr. Desaulniers ensured an assiduous follow-up of the incidents and change requests with the Peregrine Service Center application in order to make them progress through while making sure that these requests were tested and reflected in all the environments suitable with the requirement. He prepared the weekly report/ratio of the management indicators for the change requests. He was also responsible for gathering and following the requests by delivery for the production which he submitted to the committee for this purpose. This committee approves in a final way the change requests to be delivered in production before their realization.

Environment : Peregrine Service Center, Lotus Notes, Live Link, HTML, Oracle PGI, Visio, Documentation tools like MS Word, MS Excel, Windows XP, Oracle eBusiness Suite 11i and 12, DBMS Oracle 10g.

Methodology : AIM

Pratice : ITIL

Nº 26

System analyst

2 months

Electronic exchanges - Inscription of the preferences

04-2004 to 06-2004

Revenue Quebec

(MRQ)

Within the framework of the electronic exchanges project, the registered companies with CLIC Revenue will be able henceforth to use the Web payment services in order to specify some of their preferences, in particular the one to receive their report/ratio of handing-over by mail or electronic sending. As a systems analyst and analyst-programmer, Mr. Desaulniers developed a generic task program on the mainframe system allowing to manage the updates of the preferences of the "enterprise" users. The deliverables were design specifications, test specifications, technical realization, support with the realization, unit, functional and acceptance tests, and the setting in production.

Environment : TSO ISPF, COBOL, IDMS, JCL, File-Aid, Spitab, MyExtra!Entreprise 7.0, Mainframe IBM 3090, CA-IDD, Panvalet, Visio, documentation tools like MS Word, MS Excel, MS Access, Windows 2000

Methodology : DMR Macroscope, DMR P+

Nº 25

Technical analyst and system analyst, programmer

2 months

DMR Conseil Internet site

02-2004 to 03-2004

DMR Conseil

A team was chosen at DMR Conseil to convert their Internet site in order to make its maintenance dynamic and to allow the DMR administrators to modify it without having to ask for the intervention of a programmer.

As a systems analyst, organic and programmer, Mr. Desaulniers carried out the visual analysis of all the complete site by outlining his recommendations. He also made various analyses of the ASP.net code and C # current in order to bring his ideas to it and to propose certain improvements. He also took part in the conversion of the page of the courses offered by DMR to companies using the XSL style sheets and of the XML data format.

Environment : Internet, ASP.net, XSL, XML, XSLT, MCMS, C#, MS Word, MS Excel, MS Access, Windows 98

Methodology : DMR Productivity Plus (DMR P+)

Nº 24

System analyst

3 months

SAGIR project: analysis of the inter-system data flows

12-2003 to 02-2004

Transport of Quebec Department

( MTQ )

The SAGIR project aims in the long term to carry out the establishment and the deployment of an integrated solution of the systems into the MTQ. It is a major project within the department which will generate very important changes with its business processes, just as within its systems. It touches the fields of human, financial and material resources directly. More particularly, it covers several aspects such as : informational stock management, architectural work, achievements of adaptation of the systems, the development of interfaces and data conversion.

As a systems analyst, Mr. Desaulniers carried out the analysis of the information flow between the budgetary follow-ups system (PEB-0250) and all the systems with which it interacts, and this, for each facet by explaining the transformation applied to the metadata. In the same way, he made the analysis of the management system of the piloting tables (GBD-6005) and of the systems with which it interacts.

Environment : Mainframe IBM 3090, CA-IDD, Panvalet, TSO ISPF, COBOL, IDMS, JCL, SAS, CLIST, Oracle-SQL HOST, SQL*Loader, SQL Plus, Toad, MS Word-, MS Excel, MS Access, Windows NT, Visio, Internet, ASP

Methodology : DMR Productivity Plus (DMR P+)

Nº 23

System analyst and analyst-programmer

12 months

Conversion in XP-M3 of the TP1 System and of the Data Warehouse

10-2002 to 11-2003

Revenue Quebec

(MRQ)

Within the last years, the MRQ obtained a data warehouse with the objective of fighting tax evasion. The department wishes to widen the customers of the data warehouse and to achieve this goal, it must increase the frequency of data refreshing of the income tax returns of individuals and to increase the robustness of certain data feeding processes. Thus the department entrusted DMR with the mandate of consolidating certain data warehouse feeding.

As a systems analyst and analyst-programmer, Mr. Desaulniers carried out the conversion XP-M3, as well as the improvement of functionalities reporting to the Loading System of all companies to the data warehouse. Mr. Desaulniers was also responsible for converting the current programs, in order to allow, on request, a massive loading of the department data warehouse.

Environment : UNIX XP-UX, UNIX Script, XPDEV version 4, COBOL FOR UNIX, Oracle-SQL HOST, SQL*Loader, SQL PLUS, DbPartner Debugger for Oracle, IFTP 3.2 (IFTP32), metadata MRQ , TSO ISPF, COBOL, IDMS, JCL, File-Aid, SPITAB, Myextra!Entreprise 7.0, Mainframe 3090, CA-IDD, Panvalet, Visio, documentation tools like MS Word, MS Excel, MS Access, Windows NT

Methodology : DMR Productivity Plus (DMR P+)

Nº 22

System analyst and analyst-programmer

3 months

Adaptation of the Income Security systems for the production of the R1/T4A R5 statements

06-2002 to 09-2002

Employment and social Solidarity Department

(MESS)

As an analyst, Mr. Desaulniers took part in the technical realization of the Adaptation project of the Income safety systems for the production of the R1/T4A R5 tax statements. He carried out the technical analysis, the programming and the online and remote unit tests. He also delivered the modifications to the functional systems analysis.

Environment : PC-IBM, IDMS, VSAM, JCL, CICS, COBOL, Librarian, MGS, Expediter, File-Aid, Abend-Aid, 3090 IBM, TSO/ISPF, Visio, Windows, Word, Excel, MS Project, Outlook

Methodology : DMR Productivity Plus (DMR P+)

Nº 21

System analyst and analyst-programmer

3 months

Integration of the districts and the multiple rates of taxes to system ACQ

01-2002 to 03-2002

Municipal and Metropolis businesses Department

(MAMM)

As a systems analyst, Mr. Desaulniers realized in the framework of municipal fusions, the new functionalities referring to district integrations, municipalities of origin and multiple rates of taxes, as well as new functionalities found in the 2001-2002 development plan. The deliverables to produce were as follows:

• to update the rates of tax;

• to update and validate the requests for compensation;

• to bind the buildings to a request for compensation;

• to bind the taxes to a building;

• to bind the certificates to a building.

Environment : IBM mainframe 3090, MVS-ESA, TSO/ISPF, Database CA-IDMS, CA-ADS/Online and COBOL, CA-IDD, Panvalet, documentation tools like MS Word, Windows NT

Nº 20

System Analyst and analyst-programmer

9 months

RDMS Project

03-2001 to 12-2001

As a senior analyst and analyst-programmer at Bank of Canada, Mr. Desaulniers was responsible for making the problem analysis found on the system and in to make its maintenance. Mr. Desaulniers used the Cool:gen tool to generate code from CICS/COBOL and DB2. He was also responsible to carry out the unit tests and to deliver the modified components. Mr. Desaulniers also provided on-call services to restore system RDMS out of the normal hours of work.

Environment : COOL:GEN, CICS/COBOL, DB2, SQL, Platinum, JCL, CTRL-M, File-Aid, VSAM files, Windows NT, MS Office 2000, MS Outlook, Corel Quattro Pro, Corel WordPerfect, IBM MVS Mainframe, OS/MVS, TSO/ISPF, Netscape

Nº 19

Process analyst

3 months

GOS – Cheque production center

12-2000 to 02-2001

Public Works and Gouvernemen-tal Services Canada

As a process analyst at TPSGC, Mr. Desaulniers visited the three Public works cheque production centers for all of Canada (Halifax, Winnipeg and Quebec). He studied and analyzed the processes in place and the production methods used in these centers, in order to document them well. Mr. Desaulniers evaluated the possible impacts and identified the needs for integration in report/ratio to a new approach of extraction of the payments carried out by the SPS System (Volume of impression of a few million payments every month), according to new conditions imposed by Canada Post in order to obtain certain advantageous postal reductions. He proposed the solutions on the documented impacts. He was also involved in testing the establishment of the change.

Environment : LAN, MS Windows, MS Office 2000, MS Outlook, Lotus Smartsuite, Visio 5.0, IBM MVS Mainframe, OS/MVS, TSO/ISPF, IDD, Netscape

Nº 18

System analyst

12 months

GOS – Quality assurance, Internet documentation project

12-1999 to 11-2000

Public Works and Governmental Services Canada

As a systems analyst, Mr. Desaulniers, had to make the analysis of the application programs of ESTEL system falling under a project of Internet documentation for the employees, and of various other programs of the department in order to extract and document from them the policy rules which apply to those of the government (indexing the anomalies with the need). Moreover, Mr. Desaulniers scanned the metadata (elements of IDD) of the System of the pay in order to document them. Mr. Desaulniers’ knowledge was also used to determine the elements added to the current methodology, during all new Internet development with PWGSC.

Environment : COBOL MVS, IDMS, LAN, MS Windows, MS Office 97, MS Outlook, Lotus Smartsuite, IBM MVS Mainframe, OS/MVS, TSO/ISPF, IDD, Netscape

Nº 17

System analyst

11 months

Pension system – Streamlining project

01-1999 to 11-1999

Public Works and Governmental Services Canada

On two parallel projects, the improvement of the pension system and the project of removal of the magnetic tapes replaced by a data base IDMS, Mr. Desaulniers, acted in a team of analysts to design document and analyze the COBOL existing programs, in order to rewrite all the application and to put it in production. Mr. Desaulniers was also responsible for the unit tests and the delivery of all the modified components.

Environment : COBOL MVS, IDMS, DMLO, JSS, JCL, Endeavor, File-Aid, VSAM files, LAN, MS Windows, MS Office, MS Outlook, Lotus Smartsuite, IBM MVS Mainframe, OS/MVS, TSO/ISPF, IDD, Netscape Messenger

Nº 16

System analyst

14 months

Payroll System

10-1997 to 12-1998

Public Works and Governmental Services Canada

As a systems analyst, Mr. Desaulniers made the analysis, wrote the specifications, modified, tested and put in production a batch of programs COBOL of the System of pay (phase 7) for the project of the year 2000. Mr. Desaulniers was also responsible for phase 4 of 7, supervising ten human resources. In order to stage with a chronic problem during phase 4, he developed a working method used by all the analysts of the subsequent versions (including phase 7). He was also responsible for the unit tests and systems in these projects.

Environment : ADSO, COBOL II/MVS, DMLO, IDMS, JSS, JCL, Endeavor, LAN, Microsoft Windows, MS Office, Lotus Smartsuite, IBM MVS Mainframe, OS/MVS, TSO/ISPF, IDMS, Netscape Messenger

Nº 15

Analyst-programmer

5 months

Common Architecture system

04-1997 to 09-1997

Public Works and Governmental Services Canada

The Common Architecture system is an in-house made compiler from PWGSC whose commands and language “host” are called “SGF” and is used on a vast scale in a multitude of programs on the mainframe (COBOL, ADS/Online, Clist, Easytrieve, etc) of PWGSC. As an analyst, Mr. Desaulniers wrote all the specifications, modified all the COBOL (150) and ADS/Online (25) programs and all connected modules, like all the CLIST, JCL, JSS and all SGF commands connected to the Common Architecture system for the year 2000 compliance as well as for the conversion of COBOL MVS. Mr. Desaulniers was also responsible for all the unit tests and system tests, as well as for the delivery of all the modified components.

Environment : ADSO, COBOL/IDMS, JSS, JCL, LAN, CLIST, Common Architecture, SGF Commands, Microsoft Window, Lotus Amipro, IBM MVS Mainframe, OS/MVS, TSO/ISPF, IDMS, Netscape

Nº 14

Analyst-programmer

12 months

IPAR system

04-1996 to 04-1997

The IPAR System functions on a Unisys exploitation system. Throughout its contract with EIC, Mr. Desaulniers analyzed system IPAR (Immigration Payment Account Receivable) and conceived all the necessary specifications. He modified all the programs COBOL (100) and SDF in line (15) and related modules, all the floods of task WFL and converted the data bases DMSII of IPAR in order to make it year-2000 compliant. The system was to be imperatively converted before January 1997. Thereafter, he also conceived specifications and modified system IPAR, according to the customer's requests. Mr. Desaulniers was responsible for testing all the changes for the setting in production.

Environment : COBOL, LAN, Microsoft Windows, IBM MVS Mainframe, Unisys A-Series, Cande, WFL, SDF, DASDL/DMSII, Banyan, Beyondmail

Nº 13

Analyst-programmer

5 months

Pension system

10-1995 to 03-1997

As a systems analyst, Mr. Desaulniers was responsible for analyzing the problems that were found and maintaining the programs of the Pension System. Mr. Desaulniers was also responsible for carrying out unit tests and the delivery of all the modified components.

Environment : COBOL/IDMS, DC-COBOL/IDMS, JCL, LAN, Microsoft Windows, IBM MVS Mainframe, OS/MVS, TSO/ISPF, IDMS

Nº 12

Analyst-programmer

26 months

TRS application (Technical Reference System)

07-1993 to 09-1995

Revenu Canada, Douanes et Accises

As a systems analyst, Mr. Desaulniers was responsible for analyzing and conceiving the specifications as well as maintaining the ADS/Online application of TRS (30 functions) according to requirements of the client. The TRS application is a frame of reference on the rules of the government provided to the clerks that are at customs. On this project, some Cobol programs also had to be maintained. Mr. Desaulniers provided on-call services for production problems out of the business hours. Mr. Desaulniers was also responsible for the unit tests and the delivery of all the modified components.

Environment : ADS/ONLINE, DC-COBOL/IDMS, COBOL II/IDMS, JCL, DMLO, OLQ, IDD, DME, OLP, Infoman, Laptop, TPX, LAN, Microsoft Windows, TPX, IBM MVS Mainframe, OS/MVS, TSO/ISPF, IDMS

Nº 11

Analyst-programmer

12 months

HRS application (Human Resources System)

06-1992 to 06-1993

Revenu Canada, Douanes et Accises

As a systems analyst, Mr. Desaulniers maintained the HRS application written in ADSO/Online/IDMS and of COBOL/IDMS from provided impact analysis. When necessary, Mr. Desaulniers also wrote specifications. He was also responsible for the unit tests and the delivery of all the modified components.

Environment : COBOL/IDMS, JCL, ADS/ONLINE, DC-COBOL Using LRF, DMLO, OLQ, IDD, QSAM AND VSAM Files, DME, OLP, Infoman, LAN, Gateway, IBM MVS Mainframe, OS/MVS, TSO/ISPF, IDMS

Nº 10

Analyst-programmer

4 months

Corporate PASS system

01-1992 to 05-1992

Supply and Services Department Canada

As a systems analyst at SSD, Mr. Desaulniers was responsible for analyzing the changes with the system of Corporate PASS for the programs by batches (COBOL). Mr. Desaulniers also improved a package of programs of the Line Item purchase online system to provide data to the new interface on line between the system users and Corporate PASS. Mr. Desaulniers was also responsible for the unit tests and the delivery of all the modified components.

Environment : COBOL/IDMS, JCL, DMLO, OLQ, IDD, Gateway, IBM MVS Mainframe, OS/MVS, TSO/ISPF, IDMS

Nº 9

Analyst-programmer

12 months

Payroll System

01-1991 to 12-1991

Supply and Services Department Canada

As programmer-analyst with the payroll system, Mr. Desaulniers, along with a team of programmers and analysts, was responsible for converting the Social Insurance Number (SIN) of the Payroll System and replacing it by a personal Identifying number (PIN). Mr. Desaulniers was also responsible for the unit tests and the delivery of all the modified components.

Environment : COBOL/IDMS, JCL/JES2, DMLO, OLQ, IDD, QSAM AND VSAM Files, Gateway, IBM MVS Mainframe, TSO/ISPF, OS/MVS, IDMS

Methodology : DMR Productivity Plus

Nº 8

Analyst-programmer

9 months

IMPS System

03-1990 to 12-1990

As a systems analyst at Via Rail Inc., Mr. Desaulniers was responsible for maintaining the IMPS system (Inventory Management Procurement System) of Cullinet, which manages the list of the parts, the information of planning of the conditions of management and the inventory. Mr. Desaulniers was also responsible for the unit tests and the delivery of all the modified components.

Environment : ADS/ONLINE, COBOL/IDMS, JCL, DMLO, OLQ, IDD, OLP, DME, QSAM, VSAM and Generation Files, Infoman, Programmer Workbench, Endeavor, IBM MVS Mainframe, OS/MVS, TSO/ISPF, IDMS

Nº 7

Analyst-programmer

6 months

Warranty and Insurance systems

09-1989 to 03-1990

As programmer at Bombardier Inc., Mr. Desaulniers was responsible for coding on line (ADSO/Online) and batch Cobol program applications of the warrantee and insurance system. He was also responsible for the unit tests and the delivery of all the modified components.

Environment : ADS/ONLINE/IDMS, COBOL/IDMS, IDD, IBM Mainframe, DOS/CMS, IDMS

Nº 6

Analyst-programmer

6 months

System Information, "Time Costing System"

04-1989 to 09-1989

As a programmer analyst at Canada Post Corporation, Mr. Desaulniers, maintained the Time Costing System.

Environment : ADS/ONLINE/IDMS, COBOL/IDMS, IDD, IBM Mainframe, DOS/CMS, IDMS

Nº 5

Analyst-programmer and technical support

3 months

Student hiring system

02-1989 to 04-1990

As a programmer analyst at Energy, Mines and Resources Canada, Mr. Desaulniers maintained the «Student Hiring System ». In his daily tasks, Mr. Desaulniers was also responsible for the technical support and material installation.

Environment : IBM-PC, WordPerfect, Dbase III, Clipper

Nº 4

Student work term - analyst-programmer

4 months

System Information

05-1988 to 08-1988

As a student work-term analyst programmer, Mr. Desaulniers analysed and designed an online tool written in C language which allowed the engineers of the Canada Post Corporation to predict their needs in terms of volume of container and letter trainer for any given period..

Environment : IBM-PC, McIntosh, McDraw, McWrite, Language C.

Nº 3

Student work-term - programmer

4 months

Architecture Processing, S.I.G

09-1987 to 09-1987

Architecture Processing  system of the Canada Post Corporation is an online system on the mainframe used as a user-friendly interface in order to edit the IDD dictionary. As a student work- term analyst programmer at Canada Post Corporation, Mr. Desaulniers analysed problems which were submitted and ensured the Architecture Processing system maintenance. 

Environment : ADS/Online, Cobol, IDMS, DMLO, IDD, Mainframe.

Nº 2

Student work-term programmer

4 months

Priority Post Track and Trace System

09-1986 to 12-1986

Priority Post Track and Trace System is a complex batch and online mainframe system. Upon the specification provided, as a student work-term analyst programmer at Canada Post Corporation, Mr. Desaulniers coded the ADSO/online IDMS program as well as the batch COBOL/IDMS programs. He was responsible for the unit tests. To do so, he used the DMLO and IDD tools.

Environment : ADS/Online, Cobol, IDMS, DMLO, IDD, Mainframe.

Nº 1

Student work-term programmer

4 months

Central Information Office

01-1986 to 04-1986

Upon the specification provided, as a student work-term analyst-programmer, Mr. Desaulniers coded the batch COBOL/IDMS programs. He was responsible for the unit tests. To do so, he used the DMLO and IDD tools.

Environment : Cobol, IDMS, DMLO, IDD, Cobol, Mainframe.

Volunteer Webmaster

144 months

Site Web

09-1997 to date

Amicale des sommeliers du Québec

The Amicale des Sommeliers du Québec is a non-profit organization acting as a wine tasting brotherhood on a provincial scale. It offers courses on wine and related activities in its five regional sections incuding metropolitan Montreal, Quebec, the Heart of Quebec, Eastern Townships and the Outaouais.

As a self-educated voluntary Webmaster, Mr. Desaulniers is the single originator of the architecture, the design, the data modeling and the complete design of the ASQ Internet site (http://www.amicaledessommeliers.com).

Mr. Desaulniers initially wrote the site in the HTML language in 1997. In order to make it dynamic, the site was then converted by Mr. Desaulniers into ASP, JavaScript, VBScript by using a MS ACCESS (SQL) database on IIS server (in 2001). Later in 2003, the site was reconverted by Mr. Desaulniers in the PHP language, JavaScript on APACHE server using a MySQL database.

Evolving within a framework client/server, the site of the ASQ comprises a shutter Intranet made safe by the algorithms coded by Mr. Desaulniers where voluntary regional delegates enter the data relating to their regional section the database. The other shutter is public and the Net surfers view information thus available there. Mr. Desaulniers deals with the data modeling and the establishment of the new elements of the relational database.

Environment : Internet, Linux OpenSource Ubuntu 9.04, Django, Python, Windows XP PRO, CMS Made Simple, Object oriented UML formalism (OOP UML), PHP (OOP), MYSQL, PHP-MYADMIN, DB designer 4, dbQwikSite 4.2, EasyPHP, ConText, HASP Editor, Windows 98, Gaspi, ASP, Web Expert, MS Access, MS Excel, MS Word, Netscape Composer, MS Internet Explorer, FTP IPSWitch, Apache, IIS.