Tom Trottier, MBA, ATM-G, CL

+1 613 860-6633 Tom@Abacurial.com 601-567 Cambridge St. Ottawa ON Canada K1S 4J5

Information Architect

Logical Mensan. Energetic performer. Skilled presenter. Thorough, sensitive manager. Imaginative designer!

Modelled

Designed / implemented

Managed

Maintained/Extended

Meta-modelled

Wrote

Education

Bachelor of Arts (Computer Science) York University, Toronto
Master of Business Administration University of Ottawa, 1986
Generalised Entity-Relationship Model Nortel
System 2000 Concepts & Applications DRI
Improved Programming Technologies IBM
Object-Oriented Analysis & Design Forte
CICS Application Programming IBM
Structured Analysis & Design IBM
Advanced Toastmaster Gold Toastmasters
Java for C++ Programmers Algonquin College
Competent Leader Toastmasters
Database Design Cullinet

Technical Experience

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
Databases 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, Tidy, HTML, Xenu, Filezilla, Javascript, HTML Transit, CSS, XHTML, DHTML
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 Managment: MS Project, VisiSchedule, TimeLine, SuperProject, Project Workbench
Graphics: Visio, Corel, MacDraw, Freelance, PowerPoint, Paint Shop Pro, Irfanview
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

Security Clearance

Enhanced reliability; have been cleared to Secret earlier, but not current.

References

On request.

Languages

Fluent English, passable French.

Detailed experience follows...

Data Modelling Experience

MODELLER, SUPPLY SYSTEM, DMASP (DBCM), ADM (MAT),DEPARTMENT OF NATIONAL DEFENCE (DND), 2000 2001

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.

SYSTEM DESIGNER, WORK MANAGEMENT SYSTEM, HOUSE OF COMMONS MAINTENANCE AND CLEANING, 1994

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.

MANAGEMENT ANALYST, RETAIL DEBT MANAGEMENT SYSTEM, BANK OF CANADA, 1993 - 1994

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.

DESIGNER, PUBLIC SERVICE COMPENSATION SYSTEM, ATLANTIC RESEARCH CANADA, OTTAWA 1992

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.

PROJECT LEADER, INFORMATION TECHNOLOGY STRATEGY STUDY, TREASURY BOARD/DEPARTMENT OF FINANCE ADMINISTRATION BRANCH, OTTAWA, 1990 - 1991

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.

SENIOR CONSULTANT, CANADA POST CORPORATION (CPC), OTTAWA, INTEGRATED DATA LTD

Systems Architect, Finance and Cash Management Information Architecture, 1990

Examined all existing Finance and Cash Management systems in Canada Post and planned their integration and replacement systems, using IEW.

Data Architect, Assets and Material Management Information Architecture, 1989-90

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.

Manager, Information Architecture Environment Team, 1987-89

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.

SYSTEMS ANALYST, DATA DICTIONARY GROUP, DEPARTMENT OF NATIONAL DEFENCE, OTTAWA, 1985-86

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.

DATA MODELLER, AUTOMATED REALTY MANAGEMENT SYSTEM, PUBLIC WORKS CANADA, 1990

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.

SYSTEM MODELLER, GRANTS TO MUNICIPALITIES, GOVERNMENT OF ONTARIO, TORONTO, 1977

Working in a team, specified the requirements for a new system administering the provincial grants to municipalities.

SYSTEM MODELLER, WORKERS COMPENSATION CLAIMS, GOVERNMENT OF ONTARIO, TORONTO, 1977

Working in a team, used HIPO, structure charts, and pseudo code to develop the administration system for workers claims.

Programming Experience

PROGRAMMER/ANALYST, CANADIAN FORCES SUPPLY SYSTEM (CFSS), DEPARTMENT OF NATIONAL DEFENCE (DND), OTTAWA, 1985

Used COBOL, VSAM, and SAS to analyse inventory statistics and update microfiche support for NATO product listings and order numbers.

PROGRAMMER/ANALYST, STATISTICAL ANALYSIS, MINISTRY OF COMMUNITY AND SOCIAL SERVICES, TORONTO, TORONTO, 1978

Used SPSS and Mark IV to support the management of persons in Ontario institutions.

CONTRACT PROGRAMMER, ROYAL INSURANCE COMPANY, TORONTO, 1977

Made and tested a variety of small changes to existing COBOL accounting and actuarial programs using COBOL and Easytrieve.

PROGRAMMER/ANALYST, CANADIAN TIRE CORPORATION (CTC) HQ, TORONTO, 1977

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

PROGRAMMER, SEARS CANADA, TORONTO, 1975-77

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.

PROGRAMMER, DR. MIKE FRIENDLY, YORK UNIVERSITY, TORONTO 1975

Created APL functions for graphic displays of statistical measures for Dr. Friendly of the Psychology department.

ADVISER/PROGRAMMER, YORK UNIVERSITY, TORONTO, 1973-4

Advised students on Fortran, APL, and COBOL problems.

Telecom experience

DESIGNER, MCI LOCAL NUMBER PORTABILITY (LNP) SERVICE MANAGEMENT SYSTEM (SMS), Systemhouse Ltd., 1999

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).

DATA ARCHITECT, AUTOMATED RESPONSE UNITS (ARU), MCI INTELLIGENT SYSTEMS PLATFORM, CEDAR RAPIDS, IOWA, 1996

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.

LEAD PROGRAMMER, SAUDI AUTOMATIC TELEPHONE PROJECT (ATP), TORONTO AND RIYADH, SAUDI ARABIA, BELL CANADA INTERNATIONAL (BCI), 1978-80

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.

Lead programmer on the major projects:

In addition, set-up the BTS-II testing and modelling environment and functioned as a mentor to his peers.

MEMBER OF SCIENTIFIC STAFF, BELL NORTHERN RESEARCH (NORTEL), OTTAWA, CANADA, 1980-82

SL-10 Support PL/1 Programmer

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.

Problem Tracking System Designer

Designed and supervised the implementation of a Problem Tracking System using GERM, the predecessor of ZIM and maintained many GERM-based applications.

Other Experience

SENIOR TECHNICAL ARCHITECT, SHL SYSTEMHOUSE INC (MCI WORLDCOM), OTTAWA, CANADA, 1997 2000

Team lead, Performance Testing of Firearms Registry PowerBuilder/Oracle application

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.

Intranet Website creator

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.

Designer, Web-based Time Reporting System and Expense Reporting System

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.

DATA ANALYST, DIGITAL AUDIO RADIO, COMMUNICATIONS RESEARCH CENTRE, 1991-92

Analysed digital audio radio propagation and bandwidth data for presentation to the quadrennial World Administrative Radio Conference in Geneva.

PROJECT LEADER, CORPORATE SALES AUTOMATION PROJECT (SAP), CANADA POST CORPORATION (CPC), 1990

Planned, budgeted and scheduled $2,500,000 project to acquire laptops for CPC sales personnel.

ARTIFICIAL INTELLIGENCE PROGRAMMER/ANALYST, EFFECTS SYSTEM GOVERNMENT OF THAILAND, 1985

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.