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.