return to OLinc home page

Timothy J. McKenna, B.Sc.

Send an email 
Upper Kent, NB
Canada
independent computer systems consultant since 1987
working in the consulting environment since 1982
IBM midrange specialist since 1978

Tim McKenna, through Original Logic Inc., has been providing computer consulting services for more than 20 years. Systems integration into the client's business environment has been the primary focus.

This means Tim does business systems analysis (what's your problem), system design (what's the solution), and project management (make it happen), with an emphasis on Internet-related technologies.


Resume Contents

Information
Services
Projects
 
Systems
Experience
Corporate
Experience
Professional
History
Quality
Indicators

Information Services

* Education and Training
* Strategic Planning, Information Systems Management and Project Management
* Business Requirements Definition, Systems Analysis, Architecture, and Design
* Internet, Intranet, Client-Server, HTML, Javascript, LAN, SQL and 4GL tools
* Programming: Java, RPG and RPG IV, COBOL, Visual Basic, VBscript, C, SQL
* Connectivity:  EDI integration (custom + ANSI X.12), cooperative and distributed processing, ODBC, JDBC
ToC ToP

Projects

* Warehouse Management Systems at McCain Foods Limited.
* Teaching as a full time professor at Seneca College, School of Computer Studies
courses: Business Programming with Java, iSeries Operations, Database, RPG IV Programming; ASP and VBscript, Systems Analysis and Design.
* Educational Computing Organization of Ontario (ECOO '99)
Presentation: Fitting the Computer (R)evolution into the Educational Experience
* Canadian Ski Patrol System, Kawartha Zone recruiting
* MAPICS  AS/400 manufacturing system interface to Agile Product Data Management on Win/NT system using FTP, iSeries IFS (Integrated File System), and custom programming
* Web system to deliver stock market technical analysis service from Measuredmarkets Inc.
* Sabbatical at Trent University - completed B.Sc. in Computer Studies and Psychology. Projects included web system to deliver corporate training programs for Clearnet and investigation into technology and education issues.
* Information Systems Management for $175M distribution company for 2+ years. Improved quality and availability of systems. Increased departmental efficiency by one third. Implemented various EDI projects. Developed strategy for the change over of the company's entire software platform.
* Client/Server EIS using COGNOS Impromptu and PowerPlay for securities brokerages.
* Information Systems strategic planning and hardware/software evaluation and for a foods distribution company.
* Electronic Data Interchange: design, analysis and programming of EDI systems. EDI ANSI X.12 standard implementation for Just-In-Time customer ordering/replenishment systems. Also, custom Accounts Payable to bank's payment distribution system, General Ledger to parent company financial reporting.
* IBM Response Line: manned response desk for IBM's midrange user community assisting customers with problem identification, troubleshooting, strategic direction, communications configurations, etc.
* System/36 to AS/400 conversion: educated the 50+ user community; managed the company wide system test and change over; migrated S/36 code to the AS/400; set up IPL, backup, system maintenance procedures, security and device configurations.
* GST Implementation: Project Manager for a $120+ million distribution company. Coordinated all company departments; researched GST requirements; educated management and staff; managed customer communications; systems design & analysis; programming.
ToC ToP

Systems Experience

Distribution and Accounting Systems:

* extensive experience at all levels and with a wide range of applications such as Order Processing, Inventory Control, Sales Analysis, Landed Costing systems, EDI Just-In-Time replenishment
* Project Leader of many installations; responsible for research, development, marketing, installation and support of propriety Accounts Receivable, Accounts Payable, and General Ledger packages for a consulting company
* installed 18 systems

Client-Server and 4GL:

* Javascript, SQL, COGNOS Impromptu & PowerPlay, mrc-Query, IBM Query, IBM PC Support, Business Modeler, Retrieval/36, ADD, EXTRACTO
* used these products as part of custom design solutions
* performed marketing, training, and support roles for those products
* experienced in data base interface design and implementation

Management & Analysis Reporting Systems:

* landed cost systems * customer credit worthiness
* profit margins analysis * inbound shipping performance
* inventory position forecast * freight costs tracking and analysis

Database Design:

* server to server systems, distributed processing
* designed a high performance data base for the claims department automation project at a large insurance company

Information Management Systems:

* analysis & design of a correspondence logging, tracking and retrieval system for an Ontario government ministry
* extensively modified a client data base / diary / sales call system to integrate it into the business of an IBM midrange hardware broker/reseller.
* various flexible on-line inquiry systems

Systems Studies:

* study of a large packaging manufacturer's operations and Information Systems requirements
* similar studies done for a personal care products manufacturer / distributor
* detailed evaluation of Parts Distribution software for an electronics distribution company

Miscellaneous:

* development and implementation of various productivity tools for programming and general operations
* e.g. security breach monitoring, job scheduling, unattended nightly housekeeping, disk usage analyzer
* development of teaching aids for RPG programming: interactive RPG programs to illustrate how various RPG operations work.
ToC ToP

Corporate Experience

ADT Security Services Canada custom customer billing system
Allied International Credit custom A/R, A/P & G/L systems
BMW Canada custom A/P & G/L systems
Canadian Standards Association custom A/P & G/L systems
ClearNET Web based system to deliver corporate training
ComputerLand custom A/P & G/L
Diamond Taxi Systems Integration, custom on-line administrative systems
Eli Lilly Canada custom distribution systems (pharmaceuticals, cosmetics)
Estee Lauder Canada management reporting
JVC Canada Inc. IS Management, overall systems development, EDI systems
First Marathon EIS with Cognos Impromptu & PowerPlay
Four Star Dairy strategic planning
Gravure Graphics Systems Requirements definition for packaging manufacturer
Honest Ed's custom A/P
MacLean-Hunter EIS (Business Modeller), custom A/P & G/L
Measuredmarkets Inc. Web based stock market analysis service
Mediscope Professional Products custom A/P and G/L systems
Meridian Securities EIS with Cognos Impromptu & PowerPlay, LAN setup
Ministry of Education and Training custom correspondence tracking system (now known as workflow)
Murcomp Data Systems custom sales automation system (company wide PIM)
Origin Technologies in Business Agile to MAPICS interface
Pepsi Canada custom distribution systems
Perth County Board of Education accounting systems
Phoenix Continental high performance data base design for client/server
Pindoff Records custom distribution systems
Sandbury Homes custom administrative system
Schwartzkopf Systems Requirements definition for manufacturing
Smith Packaging EDI with Mapics manufacturing systems
Super Fitness custom A/P & G/L systems
Tasco Distributors custom distribution systems (retail/wholesale appliances)
Toronto School of Business teaching IS/IT
Workplace Health and Safety Agency software training
Wm. E. Wright custom A/P & G/L systems
ToC ToP

Education and Employment History

present Professor of Computer Studies at Seneca College
Nineties mid-life sabbatical at Trent University,
completed B.Sc. in Computer Studies and Psychology.
Dean's Honours List, Trent U. Scholarship.
Eighties & Nineties Original Logic Inc., founder and managing partner, systems consultant
Eighties R.J. Percival Associates / CANTOC, Programmer/Analyst, Sr. Analyst, Consultant, Project Leader.
Seventies & Eighties General Motors of Canada, Programmer
Seventies Computer industry training at IBM Canada and General Motors
General Motors of Canada, Customs and A/R Dept. clerk
Trent University (completed 2 years, Psychology major)
ToC ToP

Quality

* Trent University B.Sc. - Dean's Honours List (overall A average for degree)
* lowest warranty costs and high customer satisfaction survey results with R.J. Percival Associates/CANTOC, "Employee of the Year"
* at General Motors, was recognized as the corporation expert on EXTRACTO and wrote a parts pricing and billing system which was named "best in the corporation" by our U.S. divisional customers
ToC ToP

Timothy McKenna and Gabriela Mann are partners in Original Logic Inc.