Languages and Databases

C, C++, Perl, SQL, Java, HTML, XML, JavaScript, PerlScript (mod_perl), PHP (Smarty templates, ADO), Flash 5-MX 2004 (ActionScript 2.0), Makefiles, *nix (csh and bash) scripting, Delphi, Pro-IV, Omnis (Mac & PC), MySQL, Sybase, Oracle, Informix, MS SQL Server, and MS Access (JET).

APIs

Win32, OCI (7.x-8.x), DBLib, CTLib, DBI/DBD, T-SQL, PL/SQL, E-SQL, Open Interface, Perl/Tk, SybPerl, OraPerl, AVS, Tibco Rendezvous, and MFC.

IDEs

Emacs, Microsoft Visual Studio, Delphi, Borland C++ Builder.

Other Software

Apache, CVS, Rational Clearcase, MS Information Exchange Server, MS Office, Cygwin, GDB (DDD), and Purify.

Operation Systems:

Unix (Solaris, SCO, HPUX), Linux (Gentoo, Red Hat, Slackware), DOS, and MS Windows.

• Developing dynamic content web sites, using PHP, MySQL, Smarty templates, and ADO.
• Developing CLIMATE, (Clinical Management and Treatment Education), using Flash MX, Delphi, JET, Perl, PHP, and MySQL. CLIMATE is a "Doctor's Assistant" program. An animated character instructs patients suffering from disorders how to best manage and treat themselves outside of the clinical environment. Treatments exists for a variety of disorders, included Depression, Chronic Heart Failure, Diabetes, Alcoholism, and Asthma.
• Developing Win32 applications for web site administration. Programs written in C/C++ or Delphi communicate with XML-RPCs to a server-based PHP script for web site administration. With this interface, clients can manage their own site inventory, user registration, and transactions.
• Developing Win32 applications per client requests. Programs written include a new tertiary tree GUI for Windows, and an interface to MYOB.

• Assisting in development of dynamic content web sites, using Perl, CGI, Flash MX, PHP, and MySQL.
• Developing SDesk, an "infinite" desktop program for Microsoft Windows.

• Worked on a team building a large-scale trading application in C. The trading application, called Abacus, consists of 2 million lines of C source code spanning approximately 5000 files. Abacus is written to support multiple platforms (Win NT 4.0, Sun Solaris) and multiple Databases (Sybase, Oracle, MS SQL Server). Abacus also uses Tibco Rendezvous for event notification and de-coupling of software components.
• Assisted in development of Toolkit, a multi-language API (C, C++, Java, Visual Basic, Perl), which allows clients to customize the Abacus program.
• Assisted in development of Orien, a messaging service for Abacus that, among other things, eases the creation of web-based applications that booked deals through Abacus.
• Traveled to international clients for on-site development.

In addition to my responsibilities listed under Open Link International, I was also responsible for:

• Installation of Abacus system at client sites including Unix server installation, database (Oracle, Sybase) installation, and third party product installation.
• Installation of Abacus developer environment at Dynegy, an energy company that bought Abacus source code.
• On-site, full time consultation for Dynegy, including training in Abacus, Tibco Rendezvous, CVS, Makefiles, Perl ... everything needed to develop and build Openlink's software.
• Wrote online and offline documentation.
• Alpha development for an energy trading/scheduling module for Abacus. The project was abandoned when it was determined that no client would pay for it.

In addition to my responsibilities listed under Open Link International, I was also responsible for:

• Creating a cross-platform automated build environment for the Abacus application, using Perl, Makefiles, CVS, ELisp. All releases from OLF are done through the NY office using tools I wrote.
• Participating in the porting projects of Open Link Enterprise to various other databases. Each port required extensive code changes, both C source and SQL (schema and stored procedures):
  • Participating in the Informix porting project (from Sybase). The project required the integration of Informix's DBLibrary-esque API, and the conversion of (at the time) some 900 Sybase stored procedures.
  • Leading the MS SQL Server porting project (from Sybase).
  • Leading the Oracle port (from Sybase), assisting in the DBLibrary to OCI conversion and leading the changes from T-SQL to PL/SQL. Preliminary work for this port included writing test OCI applications, in C and in Perl (OraPerl, DBD/DBI) Wrote syb2ora.pl, a DBI/DBD Perl script to convert a Sybase database (Data and Schema) to Oracle.
• Participating in the DBLibrary to CTLibrary port. Both are Sybase/MSSQL APIs, but DBLibrary has become obsolete and unsupported.
• Creating an SQL macro language for developers to use, to simplify creating code that worked for all Abacus supported databases. I also wrote a Perl "translator" which converted the macro language into Sybase, MSSQL, Oracle, or Informix specific SQL.
• In house support: I was responsible for teaching the new employees how to develop for Open Link using a set of standards I implemented.
• Junior System Administration for Unix systems and Sybase, Oracle, MSSQL, and Informix databases.
• Intranet site development, including Perl CGI schedules for such things as cell phones, laptops, and conference rooms. (OLF, at the time, was a young company and couldn't afford enough luxuries for all of the employees who needed them, so a scheduling system had to be made.)

• Designed and developed a Win32 front end to the Clinic Automation Program - an ongoing project to make the Arizona Heart Institute completely paperless. Created the Oracle RDB to track patient information, billing, and location.
• Programmed Oracle Developer 2000 screens for adding and viewing data.
• Developed various applications using C/Win32 API and Oracle named pipes and OCI to synchronize a network of screens located throughout the clinic.

Before beginning work on the above projects, I assisted in a thorough upgrading of the Arizona Heart Institute.

• Built and installed Windows 95 workstations
• Networked the clinic, adding email, Internet access and intranet access (using Microsoft NT IIS, and MS Exchange Server).
• Once the above project began, my support role lessened, and I rarely was asked to offer support outside of the IS department.

WCS was hired as full time IT and Sys Admin for Arizona Heart, so I was technically working for WCS while in Arizona. I still did the occasional side project for WCS after leaving Arizona, the last one being completed in April 1998. Besides the two years at AZHeart, projects I've done for WCS include:

• Modifying existing Pro-IV applications to client specifications.
• Provided customer support for the Pro-IV applications.
• Programmed various DOS, Unix and Windows utility programs - including data converters, and parsers - upon client requests. Most of these programs were written in C, but some were DOS batch files and some Unix scripts (sed/awk).
• Wrote a bitmap relocation and database program in C/Win32 API for Hershey's Chocolate Company in trade for Nutrageous Bars and Twizzlers. (In retrospect it wasn't worth it.) The program was for organizing thousands of product images for a plan-o-gram system.
• Designed and programmed a preliminary paperless billing system for the Arizona Heart Institute.
• Created a Win32 vending machine Planogram alpha program for Hershey's.

Mr. Husabø requested and paid for specific and proprietary changes to Scrollable Desktop, a virtual desktop system for Windows that I develop in my spare time.

"SDesk" allows a user to create a single giant desktop up to 32,000x32,000 pixels. The program manages movement around the virtual desktop by a number of key or mouse sequences. SDesk is freeware, downloadable from many sites around the web.

Mr. Husabø's request was to have opened windows max out to the size of the entire virtual desktop. He actually paid me to do this!

MCS hired me for a six-week gig to design a web based querying system. During this time, I:

• Designed and developed Jiffy 2000, a web based 4GL built on top of existing database schema and data. Jiffy 2000 is a single engine written in Perl, PHP, and Coldfusion to connect to Oracle, Sybase, and Informix. Several default design screens were created, then used to create user specific query screens against existing database tables.
• MCS is a mass marketing house, which buys and sells names and personal information. I applied data warehousing techniques to Oracle databases on VMS system. When dealing with extremely large amounts of information SQL queries, CGI scripts, and data accessing programs need tweaked for efficiency and speed.
• Wrote timesheet.pl, a Perl Win32::OLE script that accepts user input, or reads timesheet data from an Oracle database, and creates MS Excel timesheets.

• Designed and developed a drivers' examination web site, using Perl CGI and DBI/DBD. The questions for the examination are chosen at random from an Oracle database (or a flat file when in a debug mode), and a multiple choice test form is created. The answers were checked against the database and the results immediately sent to the testee and stored in the DMV database. (The name and mailing address of the test taker are already in a database; only a unique ID is given to the examination program.)