Work Experience

1989-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
1987-1989 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
1987 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
1986 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
1986 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
1983 - 1985 University of Waterloo Waterloo, ON
Teaching Assistant, Faculty of Mathematics (part-time)
  • Responsible for tutoring first year calculus students and marking their weekly assignments
1984 - 1985 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
1983-1984 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
1980-1982 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)

Patrick Fitzsimmons [www3.telus.net/patrick_fitzsimmons]
Copyright © 1995 - Present - Patrick Fitzsimmons -
This Page Last Updated: 2010-06-07 @ 19:00