Richard - Développeur 4GL

PROFESSIONAL WORK EXPERIENCE:

Halo Brand, Chicago, IL
July 2019- Now
INFORMIX 4GL / SENIOR DEVELOPER Remote
HALO employs 300 corporate service team members with decades of knowledge and experience who support the over 500 creative and resourceful Account Executives across the nation who focus on implementing effective marketing solutions for over 40,000 satisfied clients each year. HALO is a global leader of promotional solutions, combining creativity, innovation and the most sophisticated technology for dynamic results. As a "full-service" promotional products distributor, we offer:
.
Successfully develop various 4GL projects USING 4gen on their ERP System.
Analysis of business requests, preparation of analytical and technical documents.
Source code optimization.
Unix script development ksh.
Unit testing of programs and debugging.
Created Informix tables and indexes.

Spartan Nash, Minneapolis, MN
NOV 2018- Apr 2019
INFORMIX 4GL / SENIOR DEVELOPER Remote
The most progressive wholesale grocery distributor and retailer in the Midwest, supporting independent grocers, and military commissaries and exchanges.
Successfully develop various 4GL projects on the Dallas Exe Warehouse Management System.
Analysis of business requests, preparation of analytical and technical documents.
Source code optimization.
Unix script development ksh.
Unit testing of programs and debugging.
Created Informix tables and indexes.

Loblaws, Toronto, ON
June 2018-Nov 2018
INFORMIX 4GL / SENIOR DEVELOPER
Loblaws is a chain of Canadian supermarkets operating 43 supermarkets in southern Ontario and, since 1998 in Quebec, 34 other stores. It is a subsidiary of Loblaw Companies Limited, which owns a portfolio of supermarket chains, such as Provigo in Quebec.
Successfully develop various 4GL programs on Elite DMS-WMS and Dallas Exe Warehouse Management System.
Analysis of business requests, preparation of analytical and technical documents.
Source code optimization.
Unix script development ksh.
Automation of work processes using Cron.
Creation and optimization of Informix tables and indexes.
Unit testing of programs and debugging.

Ensoft – Gaspe, Quebec
May 2007–May 2018
WordPress Webmaster / MySQL DBA / Informix 4GL services to various US customer.
The best of web design and web design - updated regularly with new designs, featuring the best WordPress Themes.
Provided local small business and nonprofit organizations with a reliable WordPress webmaster and MySQL DBA services.
WordPress website development.
Development of web applications using a PHP code generator.
Web animations and videos.
Gravity forms
MySQL database: installation, configuration, optimization, data architecture
Backup and restore.
Graphic design with Adobe PS and Fireworks.
Customer support and training.
Converted Informix 4GL source code to Genero to produce user graphical interfaces.


NewAlta – Calgary, Alberta
October 2006–Jan 2007
INFORMIX 4GL / SENIOR DEVELOPER
With a relentless focus on safety, efficiency and regulatory compliance, our earth, water, waste and resource solutions deliver meaningful results from the outset to the end of every project. Applying our specialized expertise in the oil and gas, mining and industrial sectors, we minimize your impacts and liabilities while we maximize recovery, improve sustainability and enhance your corporate reputation.
Extract from an Informix 4GL DB, data mapping, PL-SQL scripts Transform and Load data into an Oracle DB.

Informix 4GL ETL Migration Project to an Oracle DB via Toad (Load into Pl-SQL scripts) and
AquaFold (PL-SQL Validations scripts)
Successfully develop various loading/validation script in PL-SQL.
Unix ksh script development to automate data extraction
Unit testing of programs and debugging.
Logical modelling, physical database design, data sourcing / data transformation, data loading and performance tuning.

Groupe Cantrex – Ville St-Laurent, Québec
Apr. 2005-Nov 2006
INFORMIX 4GL / SENIOR DEVELOPER
Cantrex Nationwide members are part of North America's largest buying and marketing group—selling more products in the appliances, consumer electronics
Successfully develop various 4GL programs on the Elite-Series WMS (warehouse management system) and Elite-Series DMS distribution system.
Participated in application development session to gather information about clients need and to get familiar with vendors’ product.
Analysis of business requests, preparation of analytical and technical documents.
Source codes optimization.
Wrote Unix shell scripts ksh.
Automated work processes using Crontab.
Creation and optimization of Informix 4GL tables and indexes.
Unit testing of programs and debugging
Inbound / Outbound EDI 810-820 mapping
Migrated data from text files and Excel spreadsheets to SQL Server databases using Integration Services.
Increased query performance, necessary for statistical reporting after monitoring, tuning, and optimizing indexes by using the set explain utility.



Groupe Corus / Kruger– Trois-Rivières, Québec
June 2004-Jan 2005
INFORMIX 4GL / SENIOR DEVELOPER
The Trois-Rivières plant already produced this material for five years in the demonstration phase, but it is now moving up a gear. Kruger will continue to manufacture its other products, but these investments will enable it to produce cellulose filaments 24 hours a day, 7 days a week.
Successfully develop 4GL programs to automate BOL transfers on the warehouse management system and DMS Elite-Series.
Analysis of business requests, preparation of analytical and technical documents.
Source codes optimization.
Unix script development ksh.
Automation of work processes using Cron.
Creation and optimization of Informix 4GL tables and indexes.
Unit testing of programs and debugging

Vacances Air Canada – MONTREAL, QUEBEC
March 2003-May 2004
INFORMIX 4GL / SENIOR DEVELOPER
For 25 years, Air Canada Vacations has offered packages and tours in the South, Asia, South America and Europe.
Design various programs on reservation system ResIII. Implemented interface between ResIII and netAir website.
Successfully develop various 4GL projects on the RES-III reservation system
Successfully develop an interface between a BD Informix and a MySQL DB via ksh and PERL scripts.
Analysis of business requests, preparation of analytical and technical documents.
Source codes optimization.
Unix script development ksh.
Automation of work processes using Cron.
Creation and optimization of Informix and MySQL tables and indexes.
Unit testing of programs and debugging.

TECSYS INC. - MONTREAL, QUEBEC
Sept 1995-Jan 2003
INFORMIX 4GL / INTERMEDIATE DEVELOPER
Since our founding in 1983, so much has changed in the realm of supply chain technology.But one thing has remained consistent across industries, geographies, and decades — by transforming their supply chains, good organizations can become great. Our solutions and services create clarity out of operational complexity with end-to-end supply chain visibility. Our customers reduce operating costs, improve customer service, and uncover optimization opportunities.
Worked 3 years with customer enhancement team, then managed the release management team and was part of the team to design the interface between DMS and WMS system.
brands.
Successfully develop various 4GL projects on the Elite-Series warehouse management system and distribution system.
Analysis of business requests, preparation of analytical and technical documents.
Source codes optimizations.
Unix script development ksh and awk.
Development of "Store procedure" and Triggers on comics.
Automation of work processes using Cron.
Creation and optimization of Informix tables and indexes.
Unit testing of programs and debugging.
Inbound / outbound EDI 810-820 mapping.
Interdepartmental Coordination (RM-QA-CE).
Code review.
Training new employees on programming standards.
Problem solver sent to customer

SODEMA - MONTREAL, QUEBEC
SEP 1993-May 1995
INFORMIX 4GL / INTERMEDIATE DEVELOPER
Currently, the information professions, information systems and new technologies are growing. The SODEMA call center has taken advantage of developments in our century by offering excellent customer service via its call center.
Created multiple telemarketing programs and provide junior DBA services.
Successfully develop various 4GL programs to automate telemarketing campaigns.
Analysis of business requests, preparation of analytical and technical documents.
Backups and restores of BD Informix (onTape).
Creation of tables and indexes.
User support and training.
Unit testing of programs and debugging

GOVERNMENT OF NEW BRUNSWICK - FREDERICTON, NEW BRUNSWICK
SEP 1991-May 1993
INFORMIX 4GL / JUNIOR DEVELOPER
Originally hired for an on the job training for a duration of 3 months, I guess that they liked me as they offered contract extensions to install and train users on the police reporting system PORS.
Successfully develop various 4GL programs to produce reports on the "Woman Abuse" departmental program
Analysis of business requests, preparation of analytical and technical documents.
BD Informix (SE) installations and configurations on Xenix.
Configuration of the "Connection Manager" file, host and audit files.
Installation of the PORS system in NB municipalities.
Modifications and optimization of source codes.
User training.
Unit testing of programs and debugging. Creation of batch scripts (DOS).