Some of Our Projects

This website, http://www.pitama.org, www.pitama.org.

Terrazas de Pitama Parcelas.

This website, http://www.snowinstructorsjapan.com, www.snowinstructorsjapan.com.

SnowInstructorsJapan.com online Reservation System.

This website, www.onlineregistration.lionheartfitnesskids.com, onlineregistration.lionheartfitnesskids.com.

LionHeartFitnessKids Online Registration and Payment System.

This website, www.jsmachineandvalve.com, J~S Machine and Valve Inventory System.

J~S Machine and Valve Inventory System.

This website, www.taasales.com, Texas Angus Association.

Texas Angus Association Auction.

This website, www.findabull.net, MOVING.

Find an Angus Bull.

This website, www.simplemovinglabor.com, MOVING.

Moving.

This website, www.crrginc.com, COURT RECORD RETRIEVAL & RESEARCH.

Court Record Retrieval & Research.

This website, www.global-medical-coverage.com, is for a General Agent selling International Travel Medical and Global Health Insurance for International Medical Group(IMG).

  • Requirements:
  • Ability to sell all IMG Plans online
  • Global Health Quote page
  • International Travel Medical Quote page
  • Insurance Plan "Funnel"
  • Client Services email Form page
  • Contact page
  • Backend Administration system
  • Development Tools/Languages used:
  • PHP
  • MySql
  • SQL
  • Javascript
  • Ajax
  • mooTools
  • XHTML/CSS

The owner wanted it to contain all information necessary to sell all of the IMG Insurance plans. The content of the plan pages comes from the IMG website.

We used style sheets so that all pages were the same layout for top menu and side menus.

Each Insurance plan requires at least 6 pages, in some cases 7 or 8 pages.

In order to display a substantial amount of information on the Benefit pages we used the yooEffects accordian effect.

They also wanted what we are calling a "Plan Funnel" to allow visitors to simply click on image links and "drill down" to plans which meet their needs. The Funnel is fed by a database, it is quite complicated but functions just fine. The user can modify the contents of the Funnel and the order in which the Options appear. There are links contained in the database which are used on the Funnel for purchasing the Insurance plans.

Also required was quick quote pages, 1 for Global Health and 1 for International Travel Insurance. The data used to calculate the quotes is contained in a set of database tables so that the admin people can update the rates for the insurance plans as necessary.

They also wanted to provide a Client Services webpage which would allow current IMG policy holders to communicate directly with IMG via an email form. This is a relatively long form and the affects are accomplished using Ajax and Javascript.

And of course a Contact page.

The backend Admin system is a Custom Designed system specifically designed to meet the needs of this Client. It is not too difficult to use but does take some training and experience as the amount of data and data maintenance can be extensive at times.

This website, www.goglobalhealthinsurance.com, is for a General Agent selling International Travel Medical and Global Health Insurance for HCC Insurances Services.

  • Requirements:
  • Ability to sell all HCC Plans
  • Contact page
  • Backend Administration system
  • Development Tools/Languages used:
  • PHP
  • MySql
  • SQL
  • Javascript
  • Ajax
  • mooTools
  • XHTML/CSS

The owner wanted it to contain all information necessary to sell all of the HCC Insurance plans. The content of the plan pages comes from the HCC website.

We used style sheets so that all pages were the same layout for top menu and side menus.

Each Insurance plan requires at least 6 pages, in some cases 6 or 7 pages.

In order to display a substantial amount of information on the Benefit pages we used the yooEffects accordian effect.

Also required were links to HCC quote pages.

And of course a Contact page.

We actually did this website twice, the first time was done quickly in order to get the site up and producing quickly. Then we went back and re-designed to add all of the additional pages required to fill it out.

This website, www.InternationalGlobalInsurance.com, is for a General Agent selling International Travel Medical and Global Health Insurance for Seven Corners, Inc..

  • Requirements:
  • Ability to sell all Seven Corners Plans online
  • Contact page
  • Development Tools/Languages used:
  • PHP
  • MySql
  • SQL
  • Javascript
  • Ajax
  • mooTools
  • XHTML/CSS

The owner wanted it to contain all information necessary to sell all of the Seven Corners Insurance plans. The content of the plan pages comes from the IMG website.

We used style sheets so that all pages were the same layout for top menu and side menus.

And of course a Contact page.

The client wanted this site put up quikly in order to have the ability to sell policies. We will be redesigning the website soon to add more functionality and detail

This website, www.GlobalTravelCoverage.com, is for a General Agent selling International Travel Medical and Global Health Insurance for International Medical Group(IMG), HCC Medical Services and Seven Corners, Inc..

  • Requirements:
  • Offer Travel Insurance Plans from a variety of companies
  • Contact page
  • Development Tools/Languages used:
  • PHP
  • Javascript
  • Ajax
  • mooTools
  • XHTML/CSS

The owner wanted this website to be basically a one page site. There are additional support pages for the Policy Benefits descriptions of the Travel Plans offered.

We used style sheets so that all pages were the same layout for top menu and side menus.

The Contact form is at the bottom of the index page.

This website has links to the 3 main website for the client

This website, www.AffordableTravelCoverage.com, is for a General Agent selling International Travel Medical and Global Health Insurance for International Medical Group(IMG), HCC Medical Services and Seven Corners, Inc.

  • Requirements:
  • Offer Travel Insurance Plans from a variety of companies
  • Contact page
  • Development Tools/Languages used:
  • PHP
  • Javascript
  • Ajax
  • mooTools
  • XHTML/CSS

This website is very similar to globaltravelcoverage.com except that there are no supporting Benefit pages. Instead the link for More Information is to the appropriate page on one of the client's other websites.

This is really an experiment to see which is more effective. Both websites have a Purchase now button.

The owner wanted this website to be basically a one page site.

We used style sheets so that all pages were the same layout for top menu and side menus.

The Contact form is at the bottom of the index page.

This website has links to the 3 main website for the client

This website, www.NeedStudentInsurance.com, is for a General Agent selling International Travel Medical and Global Health Insurance for International Medical Group(IMG), HCC Medical Services and Seven Corners, Inc.

  • Requirements:
  • •Offer Student Travel Insurance Plans from a variety of companies
  • Contact page
  • Development Tools/Languages used:
  • PHP
  • Javascript
  • Ajax
  • mooTools
  • XHTML/CSS

The owner wanted this website to also be basically a one page site. There are additional support pages for the Policy Benefits descriptions of the Travel Plans offered.

This website sells only International Student Insurance plans.

We used style sheets so that all pages were the same layout for top menu and side menus.

We used style sheets so that all pages were the same layout for top menu and side menus.

The Contact form is at the bottom of the index page.

This website has links to the 3 main website for the client

This website, www.GlobalMedInsurance.com, is for a General Agent selling International Travel Medical and Global Health Insurance for International Medical Group(IMG), HCC Medical Services and Seven Corners, Inc.

  • Requirements:
  • Offer Travel Insurance Plans from a variety of companies
  • Contact page
  • Development Tools/Languages used:
  • PHP
  • Javascript
  • Ajax
  • mooTools
  • XHTML/CSS

The owner wanted this website to also be basically a one page site. There are additional support pages for the Policy Benefits descriptions of the Travel Plans offered.

This website sells Global Medical Insurance plans for people living or working outside their home countries

We used style sheets so that all pages were the same layout for top menu and side menus.

The Contact form is at the bottom of the index page

This website has links to the 3 main website for the client

This screen is an exact copy of the Crrginc Administration screen.

This is the work area, all Input and Reporting is Displayed in this area of the Webpage.

There are actually 3 different Administration Screen for this Website.

  • CrrgInc Administration
  • Client Manager Administration
  • Client User Administration

Client Managers and Client Users may Create a New Order, Search Orders and Download Reports from this screen.

Client Managers may also Edit the Client Users from this screen.

There is also a Database Maintenance Menu available for the CrrgInc Administrators.
The following functions are available:

  • Edit Employees
  • Edit Help
  • Edit Search
  • Edit BUID
  • Edit CRRG Info
  • Edit Standard Pricing
  • Edit Special Pricing
  • Edit Company Discounts

The only function missing on this Administration webpage is the ability to Add, Delete or Modify Webpages.

The Administration screen for Rocksolid Background Screening is much more basic that the one for CrrgInc.

           

This project consists of this Administration screen and a very extensive set of Input Forms.

This is the portion of the Project done by Alavida.com.

The Client needed a flexible XML driven gallery which would handle the 6 categories of Work that they do.

They are able to add the Thumbnails and photos/graphics along with the Links necessary to allow visitors to see their work.

It is a combination of Gallery and Portfolios.

The Client needed a flexible XML driven gallery which would handle the Music Videos they Produce and Direct.

They are able to add the Thumbnails and Videos as necessary.

This Hollywood Director wanted the site Simple, Dark and easy to update.

Installation of Style and Complete Setup of Zen-Cart ECommerce Solution.

Installed the Style for this ecommerce website. Modified many of the Zen-Cart php programs in order to customize Zen-Cart to the Client's specifications.
Also connected the site to Paypal and the USPS for Shipping Rates.
Comment from the Client: "The site is absolutely BEAUTIFUL!!!! And you did a fantastic job! We are just thrilled!!!"

Rockwell Collins Aircraft Performance Tracking System

General Information

This Project was done in the late 1990's, is located on Rockwell Collins's private Intranet servers. However this system is in use through-out the world by most of the Worlds' Major Airlines. This description of the APTS project I also wrote towards the tail-end of the development process. If you have any questions or comments please Contact Us.

Major Requirements

One of the requirements of APTS was that it had to be available anywhere in the World and any changes to the system be immediately available to all users at the same time. The system also should be easy to use and satisfy all of Rockwell's reporting requirements as well as that of their customers. The Browser environment satisfies these requirements and ASP allows the development of a user friendly, easily modified and updated system. APTS has been developed using Interdev as the development tool and ASP, HTML, DHTML, SQL and Javascript as the development languages. It is designed to run in Netscape 4.05 or above. The database in use is Oracle 7.3.

Service Calls

The technicians board the customer's aircraft and performs certain service work, from PM to troubleshooting and replacement of equipment. They carry with them a pre-printed form where they record the services performed as well as aircraft id, flight number, arrival time, etc. All information required is entered onto the form for later entry into APTS. I have started the development of a portable version of APTS to eliminate the need for these printed forms.

Data Entry

The technician or a data entry person, enters the required information from the Service Call into APTS. This is accomplished through the use of Data input screens which I designed to be functional, easy to use and allow as much validation as possible. The service call data may be completely entered at one sitting or saved and completed at a later time. When all of the information has been entered and validated it is then put directly into the Oracle database. This information is then ready for analysis and reporting. This gives Rockwell the edge over it's competition due to the fact that it has the service information "real time".

Inventory Control

APTS must also have the ability to move any part to any location within the Rockwell organization. While allowing for this movement it must also track the current location of any part as well as all parts currently on any aircraft. A part should be tracked from installation on customer aircraft to removal to repair to inventory and back to an aircraft. APTS does all of this and more. I have designed a system which allows all of the tracking required as well as the ability to see what parts are available as spares at any Rockwell facility. APTS also allows the transferring of a part from one facility to another.

In other words, APTS is much more than an Airborne Performance Tracking System it is also an Inventory and Spares tracking system

Reporting

APTS should contain an ability to report on the data collected. One way APTS does this is through the use of a Report Designer utility I designed. This utility allows the user to select the fields they want to use in their report. This data is contained in the 2 tables which contain most of the data collected from the service calls. The user may select the column, sort order, column width, enter the column title and column alignment. The user may also select the Font size to use for the output. There is also an option to output to Excel. Included on this screen is user selected criteria so the report will select the facility, customer, date ranges, part, etc. There are many more criteria available. When the user is finished designing the report it may be displayed, then modifications made then displayed again. When the report is exactly what the user wants the report can then be named, a description entered and saved for use later by the user or by other users if desired. A report may also be recalled, modified and saved again.

There are many other "hard coded" reports available for the users, most of these reports have user selected criteria. A problem with any reporting via a Browser and a large database is the time required to "download" the completed report, they can be hundreds of pages many times. I solved that problem a few years ago when I created a series of reusable ASP subroutines. These subroutines allow me to create a new hard coded report very quickly, usually a few hours. However, the big advantage in using these subroutines is that they create a large report with as many pages of HTML as is necessary.

I have created approximately 1500 pages of report from a database in less than 2 minutes. These subroutines also create a series of "clickable index" pages so that the user can quickly navigate through the total report very quickly. I also provide a "print" link on each report page so that the frame containing the report may be printed simply by clicking this link.

Another set of reports shows what is "currently" going on in APTS, what service calls have been entered, what was done, where, by whom, when, etc. Also, more detail can be displayed in a portion of the screen and from there a detailed report may be display simply by clicking a link. This gives the 24/7 room the ability to monitor what is happening in "real time".

A great day-to-day management tool.

Messaging

APTS needed a method of sending messages to any or all repair facilities. I designed a simple Messaging page which is executed when a user logs in to APTS. After about a minute this page closes itself automatically. When a user wants to see these messages there is a "link", press the link and the Message page appears and closes automatically.

Any user can also send a message APTS users. APTS also displays an "information message" on the most commonly used screen in APTS. This message is controlled by the APTS management team. I also built in a method of allowing management to imbed a "link" within this message.

This provides the ability to provide all facilities with common reports, summaries, statistics, etc.

Data Extraction

Many users of the APTS system have the need to extract certain data from the system. I provided this feature by providing a screen which is dynamic in that it displays the names of all tables the user has the need to extract from. This list is created based on the current tables in the Database, so that if any new tables are added they will be listed automatically. There are certain hard coded criteria involved in this process.

Database Maintenance

As in any database system, the data must be maintained, users added, parts added, new customers added, etc. I provide this through the use of the report subroutines and editing screens. All of the tables are maintained this way, except for some of the tables which are linked to each other. In this case there are special editing screens so that the updates are completed properly.

Portable Use

Make APTS available to be used on a portable computer. I am currently working on this feature. I will use much of the Javascript code currently in APTS, the proper changes will be made and the Service Calls will be able to be input into this system in much the same way as the non-portable APTS system. The major difference is that the data will be transmitted to an Internet site via wireless and there the verification process will be completed and the data will be inserted into the database. This will give the technicians the ability to complete the Service Call and send the data immediately to APTS.

This will give Rockwell even faster access to their critical data.

Business Rules

I designed portions of APTS so that certain functionality depends on the use of Rules contained in a database table.

For example: Certain Rejection and Service codes are allowed for particular types of Services, these codes are contained in a "Rule" and when it is necessary to modify the way APTS handles these Services, the Rule is changed, not the program. This type of feature is used throughout APTS for various functions. One of the entries in the Rule table is a Javascript function, when the function requires modification, I just change it in the Rule table and the program which uses it changes the way it functions. Of course, the program must be written to read and process the Rule when needed, but that is a trivial matter compared to always having to modify the program, test and put into production.

A big time saver and convenience.

Table Driven

Much of the input required for APTS is either checked against tables or is available from drop-down boxes. Some of these tables are dynamically built as the APTS system is utilized more and more.

For example: When an aircraft id is entered it is verified against the aircraft table, if it is not found a message is generated telling the user. An aircraft type/part table is available so the user doesn't have to type a part number, simply select it from a drop down box. If the part is not in this table it will be added upon completion and verification. Over time no part should have to be typed unless new to the system.

Future Plans

I am experimenting with making APTS more graphical and less text and input based. This will be done utilizing graphical representations of the serviced aircraft.

This will make the gathering and input of service information much easier for the technicians as well as provide much more accurate data.

Rockwell Collins Inflight Provisioning System

General Information

American Airlines has DVD Players for Rental along with selections of Movies. These Players need to be serviced at the end of each leg of a flight. Each Player must be cleaned and serviced, then repackaged for rental on another flight. Any players which need further servicing must be pulled out of the system and sent to a location for repair.

Each Flight will have at least one DVD cart loaded and put on the Aircraft. All DVD Players sent out for repair must be logged as such and when they are returned they must be logged back into the system.

Service Calls

There are 8 main requirements for the proper functioning of the Rockwell Inflight Provisioning system.

  • Outbound Provisioning:
  • Inbound Provisioning:
  • Audit In-Stock Inventory:
  • Receive Inventory:
  • Transfer Inventory to Base:
  • Transfer to Repair:
  • Develop using MS Access:
  • Allow Scanning as much as possible:

Maintenance Action Control System (MACS)

General Information

The Maintenance Action Control System (MACS) is an internet based tool designed for the Maintenance Control Center (MCC).

Maintenance Control Operators (MCO's) are assigned responsibility for maintaining current information in the system for each contracted airline.

MACS is dependent on data recorded in the Airborne Performance Tracking System (APTS) to track deferrals, LRU requirements, service bulletin incorporation, and preventive maintenance requirements for both aircraft and individual LRU's.

Additionally, the system has separate reporting capabilities to meet service base and customer needs.

DATA INPUT/MANAGEMENT

Process Current Deferred Data. Real-time open deferral data from the APTS system is displayed. To this, the MCO adds additional flight routing information from customer supplied data and comments that may help the downstream bases clear the deferral. There is also a link available to help the MCO locate LRU inventory. The MCO can also review service call activity subsequent to the deferral to see if it was inadvertently cleared using a different Log Book number. If, after review, the MCO determines that it was cleared incorrectly, the MCO can correct the closing record. This information appears on the MACS Base Report and the Customer ODR report.

Aircraft PM Maintenance. The MCO creates and maintains aircraft preventive maintenance contract entries that will direct service base personnel to perform aircraft PM functions at specified intervals. This tool identifies contract number, tail numbers involved in the PM contract, frequency of PM Service, and then tracks which of the functions are completed, due, and overdue. MACS Aircraft PM completion is automatically updated by data input into the APTS system. This information shows on the MACS Base Report, but only for the bases that due PM's.

LRU PM Maintenance. The MCO creates and maintains specific LRU preventive maintenance contract entries that will direct service base personnel to perform PM on the LRU's at specified intervals. This tool identifies contract number, LRU part numbers involved in the PM contract, frequency of PM Service and then tracks which of the functions are completed, due, and overdue. MACS LRU PM completion is automatically updated by data input into the APTS system. This information shows on the MACS Base Report, but only for the bases that do PM's.

Service Bulletin Maintenance. The MCO enters details of the service to be completed including parts involved, specific instructions of the work required, which aircraft are involved and the specific locations within them where the work is to be performed. After input, this information is tracked until APTS inputs show the service bulletin has been completed. This information shows on the MACS Base Report.

REPORT OUTPUT

MACS Base Report. This report is automatically generated by the MACS system and is base dependant. Only information for the airlines that are serviced at the base will show up on the report. The report consists of current open deferrals, aircraft PM's that are due, LRU PM's that are due, a copy of the RIACT report and a listing of service bulletin activity that needs to be completed.

Customer ODR Report. This report is created by the MCO responsible for each airline and is saved as a non-interactive HTML file that is e-mailed to the customer and can be viewed with any internet browser. The report shows current deferral data for the airline, sorted by aircraft type and then by tail number. It then lists any comments that the MCO has directed to the airline. Next it shows deferrals open in the customer's system but closed in APTS, and items that were deferred for airline responsibility. Finally it shows the RIACT report, which is described in section 7.

RIACT (Rockwell In-Air Contact Tracking).This report shows all pre-service leg incidents reported by the airlines. The MCO's are responsible to add entries when reported and to delete entries as they are cleared or are recorded in APTS as service call entries. This report shows on the MACS Base Report, the Customer ODR Report and the APTS Arriving Aircraft Report.

Derbi System for Exxon Petroleum

General Information

This was our first Web Based project. Derbi was designed for use on the Exxon Intranet to manage their 13,000 retail outlets

Derbi was designed as a MsSql driven application using MS Interdev as the development tool. At the time we started this project Interdev was still in 'Beta', we upgraded to version 1.0 when it was released. Almost everything involved in this project was a first at Exxon and probably not done anywhere else at that time.

Major Requirements

EXXON required a system which would allow the users to retrieve selected records from a SQL database and allow them to make modifications and update the database via the Intranet.

Ease of Use

All of this needed to be done with Web pages which were easy for the users to understand and easy to use. Since there is a vast amount of data, the screens had to present the users with an easy-to-use and consistent method of criteria selection for record retrieval.

Reporting

Another major portion of this system was the design and implementation of the Reporting system. This system had to allow the user to select the criteria for the Report and then produce the reports via the Intranet.

Also, the Reports, 31 in all, could be produced either with Crystal Reports or ASP generated. The code had to be designed in such a way as to allow for the user to select the criteria the same way for either type of report. The user selection criteria would then be used to order the desired report. Some problems came up with using Crystal Reports on the Intranet at that time, Crystal Reports was a very young piece of software at that time, so I had to find solutions which bypassed the Crystal problems.

I found a solution, which allowed the user to order either report by simply pressing an appropriate command button on the Web page. This project required the use of HTML and extensive vbScript and ASP code as well as extensive on-the-fly creation of SQL statements for record retrieval and Database updates.

Conclusion

Since none of this had ever been done at Exxon, the whole Internet/Intranet thing was very new at that time. I was on my own to discover the problems and find the solutions as they occurred while designing and building Derbi.

I also had to put together all of the Graphics and in some cases designed them from scratch. I became proficient in using MS Image Composer and Paint Shop Pro for these tasks.

It was an extremely challenging and interesting Project.

General Information

This was our second Web Based project. The Financial Department wanted the ability to obtain Real Time reports which they had heard was possible with an Internet/Intranet system.

At the time I took this project most companies still depended on their IT Department for their Reports and they were almost all Paper Reports. Any New Reports they might want would require a 1 to 2 week delay before IT departments could have them ready.

Intranet/Internet Browser based systems changed all of that.

Major Requirements

Exxon required a series of Financial Reports which would allow for "drill-down" and "drill-up" abilities with all data for these reports coming from an internal MsSql database.

Drill Up/Drill Down

What I mean by "Drill-Down" report is the ability to start at the Highest Level possible. For example you might select an annual company wide financial report. Starting there you had the ability to simply click a link and you would go to the next level down, possibly a quarterly report. Or you could click a different link and see the data broken down by District. You had the ability to continue to "drill-down" until you were at a daily or retail location level.

The amount of detail seen for each report of course depended on the type of financial report you were looking at. It could be a report on Sales by location or Sales by time period.

Reports

There were a total of 4 types of reports each with the ability to go from very general to very detailed.

Conclusion

Another challenging and interesting Project. Exxon was very pleased with the results.

This sort of thing today is pretty common but back in 1996 it was all new. Most Financial reports at that time came from Main Frame computers and anything new could take if you were lucky a few days and more commonly a week or more. The reports were never interactive as they were printed reports and if you remember the "old days" very cumbersome to use compared to the technology we have today.

Everything below is pre-Internet

Interested in our full business solutions?

lets have a chat