Custom Software Development

Profile

More than 20 years of experience in computer systems. Expertise in analysis, design, development, configuration and maintenance of software applications for Windows, the World Wide Web and Mainframes (IBM 370 and compatibles) environments. Ability to find coherent and efficient computer systems solutions. Ability to adapt to new computer systems technologies. Good sense of observation. Attention to details. Striving for excellence.

• Analysis, design and development of My Leaves, an iOS application that allows employees to keep track of their employment related vacation leaves, sick leaves and compensatory leaves.
• Analysis, design, development and maintenance of EGES (Etops Ground Evaluation System); a web based application used to evaluate the knowledge of airline pilots (HTML, PHP, CSS, MySQL).
• Analysis, design and development of Mindful version 2, event reminder and password manager for Windows (Delphi 7, Fast Reports 2.5).
• Maintenance, support and marketing of three public software products; Account Xpress, Loan & Mortgage, and Mindful (Delphi 7, Fast Reports 2.5).
• Technical assistance to software users.
• Web site development and maintenance (HTML, PHP, CSS, JavaScript, MySQL).

• Participation in the development and maintenance of the Sales Collection, Inventory and Audit (SCIA) system (Delphi 7, Oracle 9, PL/SQL, TOAD, Crystal Reports 10, Visual Source Safe).
• Crystal Reports reporting system administration for the department (Crystal Reports 10).

• Analysis, design and development of the Purchase Orders, Customer Orders and Accounts Receivable modules of CMMS, a multi-user Custom Merchandise Management System for the screen print and embroidery industries (Delphi 7, Firebird database 1.5, IBDataWorks, Fast Reports 2.5).
• Analysis, design and development of Mindful, an event reminder combined with a mini calendar, countdown timer and date calculator in a highly optimized system tray application (Delphi 7).
• Felitec's web site complete redesign (HTML, PHP, CSS and JavaScript).
• Analysis, design and development of Account Xpress 3, personal finance manager and budget planner for Windows (Delphi 7, Fast Reports 2.5).
• Analysis, design and development of Loan & Mortgage 2, amortization schedule calculator for Windows (Delphi 5, Report Builder).
• Analysis, design and development of PopReminder; email reminder service offered over the Internet (HTML, PHP and MySQL).

• Development of custom reports and data extracts to assist in the detection of automobile insurance frauds (TSO/ISPF, JCL, Mark IV / Vision Builder, Syncsort, File-Aid, File-Aid IMS, QMF, DB2, IMS, MS-Access, MS-Excel and Crystal Reports).

• Participated in the design and development of a client-server application for the inventory management of forestry products (Delphi, ErWin, Visual Source Safe and Oracle database).

• Analysis, design and development of a software licenses management / tracking system (Delphi).
• Analysis, design and development of Account Xpress 2, personal finance management and budget planning software for Windows (Delphi).
• Analysis, design, development and marketing of Account Express (version 1), personal finance management software for Windows (DELPHI 4, Report Builder).
• Analysis, design, development and marketing of Loan And Mortgage (version 1), amortization schedule calculator for Windows (DELPHI).
• Design and development of a client-server Incident Management System for the Highway 407 Express Toll Route (DELPHI 2 with SQL and ORACLE database).
• Analysis, design and development of an application for tracking and reconciling budget expenses of a school organization (DELPHI).

• Business Management System (BMS) support and optimization in an IBM Mainframe environment (TSO/ISPF, JCL, COBOL II, SAS, Syncsort, SQL and IMS).
• Investigated various errors and exceptions found in the data entering the BMS system. Developed, tested and implemented solutions to eliminate these errors (COBOL II, SAS, SQL, Syncsort, IMS).
• Created various custom reports for the BMS system users (JCL, Syncsort, SAS).
• Participated in the optimization of the BMS system by implementing and testing program changes.

• Analysis, design, development and marketing of Loan & Mortgage (version 1), amortization schedule calculator for Windows (DELPHI).
• Design and development of the Incident Management System for the Highway 407 Express Toll Route (DELPHI 2 with SQL and ORACLE database).
• Analysis, design and development of an application for tracking and reconciling budget expenses of a school organization (DELPHI).

• Analysis, design and development of the Salary Planning System used by about 1,500 finance officers nation wide (CLIPPER 5.1).
• Installation and administration of a Netware 3.11 Local Area Network (LAN) for about 50 users.
• Development of specific human and financial resources applications in both mainframe (IBM 370, TSO/ISPF, JCL, Easytrieve Plus, File-Aid, DB2) and PC (MS-DOS, CLIPPER , dBASE III Plus, SuperCalc) environments.
• Installation, configuration, evaluation and support of various software applications.

• Course elaboration, teaching and student evaluation.
  Course name: 'Initiation aux Ordinateurs' (MS-DOS, WordPerfect 5.1 and Lotus 1-2-3)
  Duration: 45 hours (30 participants)

• Analysis, design, development and support of a report selection and production system (combination of interactive and batch processing on IBM 370 Mainframe) allowing the analysis of audit activities on taxpayer's returns (TSO/ISPF, JCL, COBOL, CICS, Easytrieve Plus, SDF).
• Provided training and technical assistance to users of the system.

• Participated in the analysis and the development of the Operator Production Management interactive system (TSO/ISPF, JCL, COBOL, PL/1, CICS, SDF, IDD, File Aid, Script VS).

• Analysis, design and development of a computerized accounting system (CLIPPER).

• Analysis, design and development of a computer equipment inventory control system (dBASE III Plus).
• Analysis, design and development of a utility for the configuration of telecommunication equipment (dBASE III Plus).

Education & Certifications

Languages

Delphi / Object Pascal
PHP
HTML
JavaScript
CSS
Objective-C
PL/SQL
SQL
Mark IV / Vision Builder
Easytrieve Plus
COBOL
Clipper

Environments

Windows
OS X
iOS
DOS
Linux
MVS XA / ESA

Databases

Oracle
MySQL
Firebird
IMS
DB2
dBase III+
MS-Access

Utilities

phpMyAdmin
Xcode
Crystal Reports
Fast Reports
Report Builder
ErWin
IBDataWorks
CICS
File-Aid
File-Aid IMS
SyncSort
QMF
SAS
JCL