CAREER EXPERIENCE

Independent Consultant, from 1993.

12 Years Corporate I.T. Experience (1981 through 1993)


Systems Analyst/Programmer for TLD Professional Services

Clients include London Drugs, Children's & Women's Hospital, RCMP, and Township of Langley.

.


Systems Analyst/Programmer/Network Technician for DDP Consulting Group

  • MS Access 2000, MS Access 97, MS Access 2.0
  • Crystal Reports v5.0
  • MS SQL 6.5
  • MS Windows NT 4.0
  • Network cabling & configurations
  • Netware 4.11 Administration
    •

    Development Projects:

  • Investment Tracking Database - This MS Access 2000 application tracks all members and their investments, creates automatic correspondance using Microsoft OutLook, determines all payouts to the members.
  • Marine Diving Insurance Database - This MS Access 97 application maintains all data for an international insurance program as well as being an Automation Controller of Microsoft Word 97. The Automation relationship allows the data to be maintained in Access and have the entire user interface in Access, but all policy production is completed using Rich-Text documents from Microsoft Word. The project included a complicated conversion process of existing, and sometimes flawed data. Users were highly involved as the development progressed. Training was individual and on-site.
  • New Business Penetration/Loss Business Analysis System - This MS Access 97 application is used by the 100+ Business Producers for a national insurance company. MS Access Replication synchronizes data across five locations for consolidation to the company’s Controller. Documentation is supplied through an online Microsoft Help File.
  • Election Ballot Eligibility System - This MS Access 2.0 application, compiled for run-time with the ADT, controlled all aspects for Mail-In Voting of a provincial union. Mailing labels were produced with Bar-Coding for unique identification of the member. Eligibility flags were set by the user. A bar-code scanner was used to read the returned envelopes for extremely fast sorting of eligible and ineligible votes.
  • Crystal Reports was used to create complex reports from Microsoft SQL ODBC Datasource, for two projects. These routines sometimes required the creation of SQL Stored Procedures to complete the requirements
    •

    .


    Web Adminstrator/Designer     for Steveston Christian Church

    The SCC Site (www.steveston.org) is a focal point for the communication of the church membership with some pages being quite static and others changing once or twice a week. The project also encourages all members to participate in the development of the site.

    .


    Year 2000 PC Lifecycles Automation Reporting     for Westcoast Energy Inc. (Jan-May 1999)

    Each department required status reporting of the work being completed in their area. This Summary Reporting identified status items including hardware compliance, MS Access databases and Excel workbooks (both on individual workstations and file servers), software compliance, and user acknowledgement of techniques to be applied in the future.

    Originally reporting was build up by hand using reporting from the Business Status database (an Access 97 database shared by a dozen people of so), but the process struggled with errors and was time consuming. Using Automation, we controlled the MS Word document production directly from routines in the Access database; this included all calculations, report details, and formatting. The Summary reports finished between 15 and 140 pages depending on the department involved

    .


    Year 2000 MS Access Remediation     for Westcoast Energy Inc. (Jul-Dec 1998)

    The Year 2000 Project encompassed the entire company. I operated as part of the team responsible for the PC Lifecycles (remediation of all personal computers in the company, excluding servers). This team addressed hardware compliance, installed software, Microsoft Excel workbooks and Microsoft Access databases.

    My responsibilities included:

    .


    Instructor     on behalf of the Minoru Senior’s Centre, 1997

    · Introduction to Computers is a course especially designed for centre members who have limited or no experience with PCs. Primary objective is to introduce enough information to give the students the ability to determine the impact and benefits of owning and operating a computer in their own home environment. Also a number of students wanting help removing their fear of computers. The course was very well received.

    Instructor on behalf of the Open Learning Agency

    Single and two-day on-site courses in Microsoft Access

    .


    Micro/Network Technician     for the University College of the Fraser Valley (a multi-campus college), which is comprised of six Netware 4.1 servers and over two hundred client workstations; second contract for installation of 64 new Win95 machines, 1996/1997

    .


    Network Technician     for the Credit Union Central of BC, 1996

    Part of an emergency team recovering the user environment following the failure of a Netware 4.1 server

    .


    NT Network Installation     for the Burnaby Community Skills Centre

    Design and implementation of a MS Windows NT 3.51 network used by students and staff

    .


    Solution Provider     for Small & Residential Offices

  • Hewlett-Packard Advanced Product VAR
  • General Consulting
  • Systems Upgrades
  • LAN Recommendations
  • New System Installs
  • Publications using Adobe PageMaker®
  • Custom Microsoft Access Applications
  • Creating Windows Help Files
  • General Support for OS/2 v2.1
  • Visual Basic
  • Contact Management, primary with Maximizer
    •

    .


    Other Experience

    Chairman of Electronic Communication Committee for a Federal Political Party

  • Co-ordinate all ideas for Electronic communication, by computer or other electronic means
  • Serve as System Analyst for national computer systems and reporting
  • Participate in the interview/selection process for any technical computing personnel
  • Assist various executives in determining their computing needs

    • and Systems Analyst for this Party

  • Evaluation and support of their system needs, locally in their Head Office and distributed across the country
  • Development and maintenance of the National Membership System (Microsoft Access)
  • Development, maintenance, and management of Electronic Funds Transfer (EFT) Donations System (Microsoft Access)
    •

    Census Commissioner in Richmond, for the 1996 National Census

    The Commissioner reports to the Area Manager, and is responsible for managing all Census Representatives dealing with the public, within the Commissioner’s territory

    Accounts Representative for a Canadian Computer Memory Wholesaler, 1995

  • Supporting current and new accounts by meeting and supplying the needs for the individual accounts (memory products include: variety of common SIMMs, Laser upgrades, Notebook upgrades, PCMCIA cards) -- this often required recommending appropriate memory for their needs
    •

    Elections Canada Operations Technician, 1993

  • Management of data-entry operators and their schedules
  • Co-ordinates and monitors the production operation of the voters list for the Returning Officer
  • Administrate the Local-Area-Network
  • Trains and Supervises the production centre personnel

    • .