Tom Trottier, MBA, ATM-G, CL
+1 613 860-6633 Tom@Abacurial.com – 469 Ancaster AV, Ottawa Ontario Canada K1R 7V8
Skilled presenter. Thorough, sensitive manager. Logical Mensan. Energetic performer. Imaginative designer!
Canada Post Corporate Meta Model using PSL/PSA and GML-Script/VS, later IEW and Ventura Publisher
Canada Post Finance and Cash Management Information Architecture (IA) and Assets and Material Management IA using IEW, specifying systems and projects to be constructed.
Department of National Defence(DND) Supply System using BPwin, ERwin, sed, Excel, HTML.
Bank of Canada Retail Debt Management System using DMR’s P+, Excelerator, and Project Workbench.
Public Service Compensation System, using P+, Excelerator, PowerBuilder, Aion for Atlantic Research.
Public Works and Government Services Automated Realty Management System, using Data Manager and IEW.
House of Commons Maintenance & Cleaning Work Management System, using IEW.
Ontario Government Workers’ Compensation Claims, using HIPO, structure charts, and pseudo-code.
Firearms Registry performance testing, team of six (Systemhouse Ltd) using Unix & Oracle DB.
Canada Post Environment Team, four members, four years, developing & supporting corporate meta model.
University of Ottawa MBA Students Association – co-president; Toastmasters District 61 Area 40 Governor, and previous club presidencies; Camera Canada College - Facilities manager, 2003; Vice President, CfSC
Sears Canada HQ General Ledger and Inventory control system using PL/1, CICS, and IMS DB/DC.
Saudi Arabia Telephone Company Service Order, Telephone Traffic, Billing, and Line Assignment Systems using COBOL, CIC, BTS II, and IMS DB/DC.
MCI Billing Detail Record using ASN.1 – for trillions of long distance calls.
Canada Post - programs to publish information & system models from PSL/PSA and IEW in GML and Ventura Publisher respectively.
Websites for Systemhouse Ltd Global Development Centre, RA Bridge Club, Courteous Canine Accessories, others.
Program to publish models from Excelerator to HTML.
Department of National Defence - Inventory statistics, microfiche records system, using COBOL, VSAM, and SAS.
APL functions for Micro Computer Machines and University of York Psychology Department(Dr. M. Friendly)
Artificial Intelligence government program success measurement system using APL and fuzzy logic for the Government of Thailand – Dr. George Abonyi.
BNR(Nortel) SL-10 packet switcher configuration program – increased performance by 1000%
Department of National Defence Data dictionary, using Data Manager and creating ISPF Dialog Manager panels.
Ontario Ministry of Community and Social Services Statistics system for persons in Ontario institutions, using Mark-IV and SPSS
Led Canadian Tire HQ to convert from COBOL to PL/1 and introduced ISPF Dialog Manager for programmers and for use creating store placard displays.
System Blueprint for Local Number Portability, including Service Order Administration and Interface Broadcast Agent, for MCI through Systemhouse.
System Blueprint for time and expense recording, using Java and Sybase, for Systemhouse Ltd. (SHL).
Information Technology Strategy Study using Excelerator, Developer, Joint Application Development for the administration branch of the Department of Finance and Treasury Board.
Bachelor of Arts (Computer Science) |
York University, Toronto |
Master of Business Administration |
University of Ottawa, 1986 |
Generalised Entity-Relationship Model |
BNR |
Database Design |
Cullinet |
System 2000 Concepts & Applications |
DRI |
Competent Leader |
Toastmasters |
Improved Programming Technologies |
IBM |
Java for C++ Programmers |
Algonquin College |
Object-Oriented Analysis & Design |
Forte |
Structured Analysis & Design |
IBM |
CICS Application Programming |
IBM |
Advanced Toastmaster – Gold |
Toastmasters |
Development Tools |
|
Methodologies: |
Structured Analysis & Design, Information Engineering, Productivity Plus, Service Analysis, HIPO, System Development Life Cycle (SDLC) |
Computer-aided software engineering(CASE): |
Excelerator, ADW & IEW, Sterling Developer, Answer:Architect, BPwin, Oracle Designer |
Data Dictionary: |
Data Manager, Lotus Notes, IDD, Pride |
Database: |
Oracle, SQL Anywhere, Access, IDMS, Lotus Notes, DL/1, IMS DB/DC, System 2000 |
Languages: |
ASN.1, APL, Java, Basic, Visual Basic, COBOL, Fortran, PL/1, JCL, CICS, sed, perl, Python |
Testing: |
Batch Terminal Simulator II, (BTS-II); SQA Suite: Robot, LoadTest |
Web Development |
Dreamweaver, PSPad, HTLM kit, Tidy, XHTML, Xenu, Filezilla, Javascript, HTML Transit |
OSs: |
UNIX(SCO, HP-UX, Solaris) Linux, Windows, VM/CMS, MVS |
Networks: |
Netware, Internet, MS System Management Server, LanWatch32, Etherpeek |
Hardware: |
PC, Mac, 3090, HP580, Ethernet, T1, Cisco |
Application Software |
|
Project Mgmt: |
MS Project, VisiSchedule, TimeLine, SuperProject, Project Workbench |
Graphics: |
Visio, Corel, MacDraw, Freelance, PowerPoint, Paint Shop Pro |
Words: |
MS Word, HTML, SGML, Ventura Publisher, Script VS, TypeReader, Open Office |
Numbers: |
Excel, 1-2-3, SAS, SPSS, Crystal Reports, Quattro Pro |
Other: |
ISPF, Dialog Manager, Adapt, Unix utilities |
Email: |
Cc:Mail, Eudora, Pegasus, COCOS, Exchange, Outlook |
Enhanced reliability; have been cleared to Secret earlier, but not current.
On request.
Fluent English, passable French.
Detailed experience follows...
modelled with a team, using BPwin, several portions of the existing supply and distribution system of DND. created a SED script to publish BPwin models on the web in HTML; created Excel spreadsheets to analyse source and destination of data within the model and defined techniques to identify modified objects and data.
Using IEW, analysed and designed a system to manage personnel and work orders for cleaning and meeting set-ups/takedowns. Evaluated against a commercial system.
Using DMR’s Productivity Plus (P+) methodology, analysed the Customer, Customer Request, Procedures, Workload, Workgroup and Help data facets. Designed the Customer Request and Workgroup functions, analysed issues surrounding postal codes, delivery points and address standardisation, and analysed use of workflow management procedures. used the Excelerator CASE tool for data and process modelling and Project Workbench for scheduling.
For an initial design, designed various subsystems of PSCS relating to time reporting and payment using Productivity Plus and the Excelerator CASE tool. specified PowerBuilder screens and interfaced with the Aion Development System artificial intelligence engine.
led the plan that prepared the strategy. The team examined the functions of the branch and recommended information technology projects and directions to meet technology, budgetary and PS-2000 challenges cost-effectively. The project used Excelerator and Developer, collecting information in Joint Application Design (JAD) sessions.
examined all existing Finance and Cash Management systems in Canada Post and planned their integration and replacement systems, using IEW.
examined all existing and planned systems supporting asset and material management in Canada Post, and designed a data architecture to support and integrate them and future systems.
managed the IA Environment Team (varying from two to four persons over two years) to refine, extend, and implement CPC’s metadata model. This metamodel was used in all the information architecture Business Area Analysis (BAA) projects. These BAAs detailed the functions of Canada Post and specified the systems to be constructed over the next ten years.
The team implemented the metamodel initially on IBM MVS using PSL/PSA as the repository and manipulation tool and GML-Script/VS for publishing and indexing. Later, IEW [ADW] and Ventura Publisher on the PC were used. The team wrote programs to assure completeness and correctness and to publish various documents based on the repository. This involved extensive dialogue with project manager and prime users to ensure relevance and clarity of the resulting analysis and design documents.
This group does all the data administration for all the national systems of the department. developed "System" and "Project" object profiles, integrating them into the existing Data Manager dictionary, and supporting them with reports and on-line interfaces using the ISPF Dialog Manager. enhanced the existing on-line dictionary interface with expanded context-sensitive help.
Created the data model of the existing ARMS system resolving ambiguities. Presented seminar to the systems maintenance staff in the uses of data modelling and the relevance of the ARMS data model to their work, and the opportunities and problems discovered. Used IEW, Data Manager.
Working in a team, specified the requirements for a new system administering the provincial grants to municipalities.
Working in a team, used HIPO, structure charts, and pseudo code to develop the administration system for workers’ claims.
Used COBOL, VSAM, and SAS to analyse inventory statistics and update microfiche support for NATO product listings and order numbers.
Used SPSS and Mark IV to support the management of persons in Ontario institutions.
Made and tested a variety of small changes to existing COBOL accounting and actuarial programs using COBOL and Easytrieve.
Assisted CTC to convert from COBOL to PL/1. Developed standards and guidelines for the use of PL/1. Programmed an on-line text editing system using Dialog Manager and PL:/1 for the creation of the auto part compatibility displays in CTC stores across Canada
Designed and programmed the Sears HQ General Ledger in PL/1. Supervised testing and implementation on time and in budget.
Designed and programmed, on a crash basis, an inventory system for a new series of warehouses.
Created APL functions for graphic displays of statistical measures for Dr. Friendly of the Psychology department.
Advised students on Fortran, APL, and COBOL problems.
managed and helped produce the System Blueprint for this system to support Local Number Portability for MCI, comprising Service Order Administration (SOA) and Interface Broadcast Agent (IBA).
Redesigned the Billing Detail Record (BDR) which records all information about services supplied by MCI’s Automated Response Units (ARU) and operator consoles. The record is used for fraud control, network management, receivables, payables, marketing, and troubleshooting. 6,000,000 per day are created and merged with any necessary switch records. The new record, the Intelligent Service Event record uses ASN.1 encoding to improve flexibility and reduce bandwidth required.
Redesigned the Service Package (Property) record that determines online what services a caller has available to him/her and how they are delivered.
Bell Canada International (BCI), as part of a consortium with hardware manufacturer Ericsson, won the contract to expand and run the Saudi Arabia Telephone Company. BCI set up an office in Toronto to create and test all the computer programs from scratch to run the company using COBOL, IMS DB/DC, and BTS-II. Analysts would determine requirements in Saudi Arabia and bring back specifications to Canada for programming and testing, then take the programs back to Saudi for final testing and implementation.
was the lead programmer on the major projects:
SASOS – Saudi Arabian Service Order System. designed and programmed the mainline of this bilingual (English/Arabic) IMS DB/DC program. also accompanied the system back to Saudi and implemented it on time, in budget, on location within four months.
Telephone Traffic and Statistical Analysis. Designed and programmed edit and calculation programs
Telephone Billing System for all customers. Designed and programmed the mainline.
Telephone Line Assignment. Designed and programmed the mainline.
In addition, set-up the BTS-II testing and modelling environment and functioned as a mentor to his peers.
The SL-10 data packet switch is the basis for the public data networks in Canada, Germany, and other countries. supported the SL-10 developers and the IBM VM/CMS software development environment. This included compilers, linkers, a configuration program, problem tracking, development management, and EXEC programs to simplify their usage.
While updating the hardware/software configuration program to handle twice as many nodes, I increased the performance of the program by 1,000%. This reduced the time needed to configure a complete network to 20 minutes from 3+ hours (potentially 7 with the extra nodes). This allowed developers to test configurations much faster, as well as supporting field personnel in their specification and loading of a data packet network.
Designed and supervised the implementation of a Problem Tracking System using GERM, the predecessor of ZIM and maintained many GERM-based applications.
led a team of four to six persons testing a nation-wide WAN application, in a specially constructed performance lab, and remotely across the country. His team constructed test scripts using Rational’s SQA Robot that exercised a PowerBuilder application running on Windows NT. Up to 48 NT PCs ran the test scripts under Rational’s Load Test, simulating up to 1,000 users. Test scripts were run locally and over links extending 5,000 km.
The application under test accessed an HP580 HP-UX server running Oracle 7.3.4 and SQL*Net over a LAN and T1-based WAN using Cisco routers. The team stored measurements of response time and bandwidth for user actions in an SQL Anywhere database and reported using Crystal Reports, Word, and Excel.
We created a general-purpose system of parallel-running stored procedures to populate quickly a 150 GB DB for software tuning. The system used information in Oracle system tables to determine how to create the test data, and then created self-describing data subject to the defined constraints and estimated volumes.
We measured bandwidth using MS System Management Server, LanWatch32, Etherpeek, and a Data General Sniffer. UDP 9 discard service packets were used to mark out areas of interest with minimal overhead, and a program was constructed to put detailed bandwidth measurements from LanWatch into an SQL Anywhere database and relate it to response times.
created the website for SHL’s Ottawa Global Development Centre, using HTML with a text editor. used HTML Transit to convert dozens of documents from MS Word to a linked set of web pages, which were indexed using MS Index Server. documented the process for update and expansion by administrative personnel.
specified in a "System Blueprint" a web interface to replace an existing PowerBuilder client/server application recording time and expenses in SHL, using Java applets to communicate with remote Sybase databases.
Analysed digital audio radio propagation and bandwidth data for presentation to the quadrennial World Administrative Radio Conference in Geneva.
Planned, budgeted and scheduled $2,500,000 project to acquire laptops for CPC sales personnel.
Created an Artificial Intelligence engine using fuzzy logic in APL on a PC to measure and predict government program success based on incomplete and lagged data such as economic indicators.
This generic program allows users to make their connections, incorporate their assumptions, add and delete indicators, and notifies users of conflicts between reality and their model so that the model can be interactively improved. Both forward (implications) and backward (reasons) tracing were supported.
Dr. George Abonyi of the University of Ottawa supervised.