For a regional bank's Branch Systems Group, developed and supported
up to 27 PC applications used in branches and head office
departments.
Completed Year 2000 (Y2K) testing for 10 PC applications,
including inventory of 3rd-party software, initiating requests for
compliance letters, setting up and using "model branch" Windows NT
test network.
Tested and migrated PC applications from DOS and OS/2 to Windows NT,
with changes where needed. Assisted NT conversion staff and users
to resolve problems during conversion.
Developed applications, including all phases from business
requirements through to writing manuals, distribution and support.
Ensured that applications met business needs by working with clients
outside the IT department. Applications: mortgage program
(5 upgrades); loan program (new program plus 3 upgrades);
electronic forms program (5 upgrades); and others.
Gas Plant Management
Operating at a major gas plant in Alberta.
Plant operators optimize performance to meet pipeline company
demand.
Large system (9-MB data base).
Linked to SCADA computer for automatic input of measured volumes.
Generates output file of month-end accounting data which is sent
to head office mainframe.
Related subsystem tracks inventory of products derived
from natural gas.
Pump Repair Information
Operating in the heavy oil field of a multinational company.
Owner tracks history of failures, and reduces costs by upgrading
pumps.
Large system (10-MB data base each year).
Runs at multiple locations, with data consolidated into a central
data base.
Alberta Health Care Billing
Maintains history of patients and services provided.
Produces government claim forms.
Enhanced for electronic submission of claims and retrieval
of payment information. This is done through Datapac, using
a communication package supplied by a service bureau.
Operations Reporting
Installed for a market-leading well service company.
Management analyzed competitive performance and financial results.
Program calculated employee performance bonuses.
Ran at multiple locations throughout Alberta, with data integrated
by remote communication.
Head office system was multi-user on a local area network.
Client Account Management
Installed at two mutual fund broker-dealers.
Integrated data provided monthly by mutual fund management
companies.
Provided client statements and timely information in response
to queries.
One installation was multi-user on a local area network, with
password access controls.
Membership Data Base
Used by southern Alberta constituency of a major party
during a federal election.
Enabled candidate and organizers to work most effectively
with party members and supporters.
This party's candidate won the election.
Personnel Information (Enhancements)
Used by a Calgary food wholesale company.
Maintained employment history, education and salary information
for employees throughout western Canada.
Supervisory Control & Data Acquisition (SCADA)
Implemented minicomputer programs for a natural gas field monitoring
and control system supplying a large gas processing plant owned by
a major Canadian petroleum company.