|
HEADWAY'S PROJECTS |
Here are some of our projects
grouped by technical area. Most of these are custom database systems
conducted in the Calgary area.
|
ASP
-
Gas Transportation Company - We
developed a complex ASP application in front of a SQL Server
database. We provide ongoing SQL
maintenance on the application, database, and provide the custom web
hosting for this system.
-
Sport Medicine
Clinic - We have developed a web browser system to conduct online
injury analysis questionnaires. This is a secure health records
system.
-
Professional 360-degree feedback
and custom questionnaire system. This is an ASP system in front of a
SQL Server database. We also built a custom Microsoft Access
database to query and report on the database.
|
ASP.Net
- Management Consulting - We developed
and maintain a 360-degree professional
feedback system as a web database application. A client-server
database application produces reports that are used in the classroom.
|
Database Applications
-
Materials Testing
- We developed a secured multi-user database application for materials testing data entry and
reporting. The installation files and information about the system
are maintained on a web page for the various client offices across
Canada to download from. The reports use a graphing OCX. There is
a custom Help file. We developed another database system to capture
data from a Mettler Toledo electronic balance.
- Machine Manufacturer - We
assumed the maintenance of a critical Microsoft Access inventory
management and billing system.
- Heavy Duty Mechanic - We built a system that provides billing
for parts and labour at a heavy-equipment repair shop. We assist in
the marketing of the system for others. Microsoft Access.
- Pipeline Operator - We
developed a critical system to schedule the pipeline shipments. We've maintained it for
several years since then. Microsoft Access in front of a SQL Server
database.
- Well Logging -
We developed and maintained a critical service
order and financial performance information system for an oil well
logging company.
- Gas Producer - We
developed a critical gas and oil production reporting system
in front of a Oracle database. A complementary graphing system was
developed. We provided a team leader and mentor to maintain this
system and upgrade several others from Access 97 to 2000.
-
Oilfield Supply - We maintained a complex inventory
database application for this oilfield materials company.
|
Database Replication
- Heavy Duty Mechanic
- We
used Microsoft Access Replication and Synchronization to allow users
to enter data in multiple copies of a database for later merging.
The application has end-user functions to manage the replication and
synchronization.
|
FoxPro
-
Sport Medicine Centre - We maintained a FoxPro application that is a
client-server questionnaire for a sports injury clinic. We later
rewrote is as an ASP / Access web system.
|
Macromedia
Flash
-
Heavy Duty Mechanic
- We provided an opening movie for a client's web site
using Macromedia Flash. We currently develop web and kiosk surveys
and marketing tools using Flash.
|
Imaging
- Heavy Duty Mechanic - In an Access
front-end we used the Windows Imaging components to scan and display
financial documents. This involved activating the Windows 2000
Imaging components on XP machines.
|
Microsoft Access
|
Multi-Dimensional Database Systems
-
Oil and Gas Producer - We
developed a Microsoft Excel VBA application for financial reporting
on a Hyperion Essbase multidimensional database.
-
Oil and Gas Producer - We constructed
and managed a Hyperion Essbase multidimensional database for
managing the client’s financial budget. Developed a Comshare
Decision OLAP application.
|
Multiple Regression Analysis
- Municipal Management - We developed
the first version of the City of Calgary's system to appraise
residential property values using multiple regression analysis
(sales comparison approach) of property valuation.
|
Petroleum Production and Reservoir Engineering
-
Integrated Oil and Gas -
We have experience with the design; testing; spec adherence; and help
desk activities of corporate data systems. We also have a great
background in petroleum subsurface artificial lift, reservoir
management under water and miscible floods, and SCADA and production
accounting systems.
|
SAS System
-
Meat Packer - We supported a
and RDB data warehouse
and a SAS reporting system for several years. This database
processed quality assurance data for the food processing industry.
|
SQL Server
- Web Site
Traffic Monitor - Our
web site traffic graphing tool connects to our SQL Server database
through an Internet connection quite nicely. It's a Macromedia Flash
tool. The Microsoft Access version of it connects to the same
database.
- Project and Time Tracking - We
converted our own projects and billing system from an Access /
Access front / back system to an Access / SQL Server version.
- Gas Transporation Company - We
work with SQL Server's DTS to automatically backup our client's
database on the web host. We built an Access front-end to connect to
the web host database and the local backup of the database. The
application compares the web version to the local copy, does
comparisons, and database growth analysis. It also monitors the use
of the ASP application and any errors incurred.
- Access to SQL Server database
conversions - We have converted two critical Access / Access
systems to Access / SQL Server system.
|
Surveys
- Health
Records - We maintain survey system to track to progress of sports
injury treatments.
- Marketing - We have developed
questionnaires and surveys for distribution on web browsers and
touch-screen kiosks. They have been dressed up with Flash movies and
attractive images.
- Management Consulting - We developed
and maintain a 360-degree professional
feedback system as a web database application. A client-server
database application produces reports that are used in the classroom.
|
System
Upgrades
-
Food Producer - For Y2K we upgraded several Microsoft Access system.
- Oil and Gas Producer -
We supplied a team of three people to convert about
80 Lotus Approach database systems to Microsoft Access systems.
|
|
Visual Basic 6
-
International Business Registry - We developed an
interface to an Access database of business registrations using VB6.
The application included a software licensing control to allow
it to be used as a demo before being purchased and activated with an
unlock key. A Windows Help file was written and incorporated into
the system.
|
Web Sites
- Government Services - We
developed a web site to distribute documents to authorized users.
- Heavy Duty Mechanic - This
web site uses Flash movies.
- Management Consulting - We
developed this web site using graphics delivered to us. We developed
another .Net web site with questionnaires for a 360 degree feedback
company.
- Training Company - We
developed this web site to accept the online booking of training
courses.
- More web
sites we've done.
|