Work Experience

Sept/89-Present TELUS Communications Edmonton, AB
Senior Developer Analyst (full-time)
  • Gained many years of development and support experience, including lots of business knowledge
  • Worked primarily in the Business Intelligence group on the TELUS Enterprise Data Warehouse
  • Obtained strong analytical skills and experience doing ETL with Informatica
  • Some of the Projects, Systems and areas where I have worked include:
    • Project Imagine (current) - development and documentation of Informatica PowerCenter template components used by developers to build the new "next generation" Oracle data warehouse
    • Enterprise Data Warehouse (EDW) - design, development and support of the TELUS data warehouse using DB2 and Informatica PowerCenter on a UNIX AIX platform
    • Decision Support System (DSS) Warehouse - design, development and support of the Alberta TELUS data warehouse using Oracle, IW and CLEAR:Access on a UNIX HP-UX platform
    • DSS Warehouse Intranet Web Site - web site design, development and support using FrontPage
    • Pre-Authorized Payment System (PAPS) - development and support of this COBOL/DB2 system which interfaces with both billing and the banks to handle direct debiting of either customer bank accounts or credit cards for the automatic payment of TELUS bills
    • Competitive Marketing and Product Analysis System (COMPAS) - development and support of the COBOL/DB2 and Focus extracts and XCOM jobs to transfer TELUS billing data to Stentor's national database used by Marketing for trend analysis and marketing campaign development
    • Customer Information System (CIS) - development and support of various Mark IV, Foremark, Focus and COBOL billing system data reports for internal TELUS Marketing customers
    • Install & Repair (I&R) - out in the field face-to-face with customers as a manager filling in for striking union members during the TELUS 2005 strike, specialized in ADSL trouble tickets / orders
    • Central Office Rackwork - spent a couple of weeks as a manager filling in for striking union members during the TELUS 2005 strike running jumpers in a Central Office
  • Responsibilities: design, programming, testing, support and documentation of all aspects of a large computing environment
  • Supervisors: John White, Marwyn Ratke, Cathy Smith, Alex Wolodko, Leanne Egeland, Kelly White, Steve Benteau, Eddy Mak, Alla Oygen and Rob Clarke (current)
Sept/88-Apr/89
Sept/87-Apr/88
University of Alberta Edmonton, AB
Teaching Assistant, Department of Computing Science (part-time)
  • TA for both a first year introductory computing science course for non-computing science students and a fourth year introductory computing science course in Artificial Intelligence for computing science students
  • Duties included teaching the first year students the use of a Macintosh and various applications and, for the fourth year students, teaching them MTS/Prolog and MTS/Lisp
  • Responsibilities: running computer labs, consulting, teaching and marking of all student assignments
  • Supervisors: Edward Cheng, Dr. Randy Goebel and Dr. Renee Elio
May/87-Aug/87 Ontario Hydro Toronto, ON
Technical Assistant - Computer Applications, Reactor Safety Reliability Section (summer)
  • Reviewed and corrected the mathematical Reactor Safety Reliability Model
  • Successfully redesigned, improved and reimplemented the Reactor Safety Reliability Model System (RELMOD III), using Lotus 1-2-3 on an IBM PC/AT
  • Responsibilities: design, programming, testing, debugging and documentation plus computer resource support, software installation and security
  • Supervisors: Tony Farr and Stan Harvey
Sept/86-Dec/86 Ontario Hydro Tiverton, ON
Simulator Maintenance Analyst, Systems Software Unit (co-op work term)
  • Analysed, block diagrammed and documented the Bruce A Simulator Instructor Facility software using DBase III Plus on VAX/VMS and MacDraw on a Macintosh Plus
  • Programmed (real-time), and tested modules of the Bruce A Simulator Instructor Facility software using VAX Fortran on VAX/VMS
  • Performed various system software functions such as disk backup and account maintenance
  • Responsibilities: design, real-time programming, testing, debugging and documentation
  • Supervisors: Jacques Plourde and Peter Richards
Jan/86-Apr/86 Ontario Hydro Toronto, ON
Technical Assistant - Computer Applications, Reactor Safety Performance Evaluation Section (co-op work term)
  • Designed and developed the computerized Project Management System (PROJMAN), using PC/Focus on an IBM PC/XT
  • Maintained the Reactor Component Fault Database System using Focus in MVS/XA TSO
  • Installed and tested an IRMA board and related software on an IBM PC/XT
  • Responsibilities: design, programming, testing, debugging, documentation (PROJMAN user manual), plus computer resource support, security, software and hardware evaluation, installation and testing
  • Supervisors: Kevin Newell and John Coleby
Sept/85-Dec/85
Sept/83-Dec/83
University of Waterloo Waterloo, ON
Teaching Assistant, Faculty of Mathematics (part-time)
  • Responsible for tutoring first year calculus students and marking their weekly assignments
May/85-Aug/85
Sept/84-Dec/84
Bank of Montreal Scarborough, ON
Technical Specialist, User Technical Services Section (2 co-op work terms)
  • Responsible for the User Support Hotline: solving user problems in a large multi-site MVS/XA TSO and VM/CMS computing facility
  • Installed and tested a new release of Panvalet, (a library management and security system), in a MVS/XA TSO computer network environment
  • Gained valuable practical experience using and supporting a vast variety of software and hardware
  • Responsibilities: user support, software installation, testing, debugging and maintenance of the user support documentation library
  • Successfully completed third and fourth work term reports entitled Storage Media and Product Installation respectively
  • Supervisors: John Breurkes, John Ball and Jerry Bray
Jan/84-Apr/84
May/83-Aug/83
Royal LePage Toronto, ON
Systems Programmer Analyst, MIS Department (2 co-op work terms)
  • Worked on the development team of the Real Estate Management System (REMS) using Basic-IV on MAI equipment
  • Duties included writing REMS business specifications and drawing REMS schematics
  • Additionally programmed a consolidation report system using Apple/NPL on an Apple III
  • Responsibilities: design, programming, testing, debugging and documentation
  • Successfully completed first and second work term reports entitled Programming Problems and Testing and Debugging respectively
  • Supervisor: Ralph Manore
June/80-Aug/82 John A's Family Restaurant Thornhill, ON
Assistant Manager (part-time)
  • Supervised and delegated work to all employees
  • Responsibilities: maintaining public relations, inventory control, staff scheduling, payroll reporting and cash management, (have been bonded)
  • Manager: Walter Wolk

Patrick Fitzsimmons [www3.telus.net/public/pfitz]
Copyright © 1995 - Present - Patrick Fitzsimmons -
This Page Last Updated: 2007-12-19 @ 19:00