Languages:
Visual Basic 6.0,
C, C++(
CFront, ARM),
Pascal,
Modula-2,
Asm (68000,
68HC12,
PIC17C,
80x86),
Perl,
Java,
Crystal Reports 8.0, 8.5,
HTML,
Awk,
PHP4,
Bash,
TCL/Tk.
Platforms:
Netware,
AIX (Unix),
Windows (All),
MSDOS,
X Window or here,
OS/9,
Windows Terminal Server,
Palm OS,
WinCE,
Lotus Notes,
Linux (Red Hat,
Turbo,
Debian,
Fedora Core),
Dosemu
Data Access:
ADO 2.x, ODBC, MSJet, DAO, OLE DB, MS Data Shaping, Codebase
Database:
MSAccess, SQL Server7, Centura SQLBase, Lotus Notes, PostgreSQL
Chips:
80x86, PIC16C, PIC17C, 68000, 68HC12, DUART, Dallas Timekeeper, etc...
Application areas:
Integration of legacy applications into a Linux environment using Dosemu. Had to hack some code to get it to work of course ;-) This project is a rollout of 10,000 Linux boxes in a diskless, NFS mounted world. Had to grok quite a bit to get all this to work for us. We had numerous problems due to the NFS paradigm, but we have solved all of them. Rollout is Summer 2002, so I will be back with the war stories. Some areas I am now all-too familiar with: NFS, Diskless operation, Linux boot process, Dosemu, LPRng, Gtk+, Bash scripting, Awk, Perl, Ice Window Manager, X config, Serial comms. Each location will have a Server, a backup server, and two diskless PCs. There is a failover mechanism (not hot failover), to the backup server. Formula change distribution using Codebase and our satellite distribution network. Dosemu hacks: interrupt processing didn’t handle our program, the PIC code wasn’t working properly so I used other Dosemu functions as PIC replacement functions (lo and behold our program started working).
Used Crystal Reports to create unbound reports into a Lotus Notes cluster for a HR Internet Portal. The services we required from Crystal Reports were so unique, the Crystal Reports technical support staff never had experienced a customer using Crystal Reports in this fashion. My client created a set of reports, their client was allowed to modify and rename the report, upload the report to the server. When the report was run, the user selected the output format (HTML, PDF, Word97) and viewed the report online or locally (after receiving it via http).
Palm Pilot is being used as a publishing outlet for the company’s training program. Similar to an e-Book but more involved since it requires direct access to the training subjects. RIM Blackberry is also used in this project. A Visual Basic front end generates the code, compiles it for the Palm and Blackberry units.
Insurance client and group management application. Helps the customer track their customers, as well as generate Commission and Override reports. Will be used as the central database for their company. ADO was selected because it allows us to scale the application to SQL Server in the future with very little recoding.
Tie-in to ADP database in order to generate 401K data for 401K vendor. The data is then transmitted electronically via FTP to the 401K provider’s web site (Universal Pensions). The application provides amount summation as a cross-check to the ADP payroll summation.
Tapped into telephone switch in order to display Call queue data on terminals attached to the IP subnet. Also displayed data onto Windows Terminal Server clients. The call center staff was able to handle calls more efficiently because they would be able to pick up other district queues when the staff was not currently busy. This project also allowed the client’s salemen to visit a potential customer and show them the current call activity and how fast calls were picked up at the call center.This was accomplished by having their laptop call into the Win NT server in order to stream the call data to the laptop. The president of the company had said the system paid for itself within the first week of operation by booking an additional 100 orders per day.
Steel quoting system for a large steel manufacturer. Client was able to tightly control costs while virtually eliminating errors during the steel quoting process. All facets of the quoting process were programmed into the system. The client said the system paid for itself by never allowing them to overbid nor underbid steel contracts.
TCP/IP - Winsock socket server streaming UDP packets to the subnets.
Serial communications - 16bit DOS, 32bit DOS, BiModal, Microcontroller, Proprietary 68K, Windows platforms serial.
Warehousing system for million square foot warehouse. Picking for case pick and lift truck routing. Programmed for Telxon units attached to the pick lifts. Provided everything a picker at a warehouse needed in order to fulfill orders. Another module was created to fulfill the receiving of inventory.
Fire detection and annunciation panel. Client indicated the panel went to UL and then to manufacturing. It has never had any bugs in it.
Payroll, General Ledger, Accounts Receivable, Accounts Payable.
Novell network function toolbox. Novell Certified product. This was my own product designed for small developers to “netware enable” their applications. It may seem strange now, but in the late 1980s applications were being ported to Novell Netware networks and you had to buy very expensive tools. My network toolbox retailed for $140 and provided the top 80+ functions needed by programs.
Various Inventory tracking systems. These systems were custom for each client, tracking gasoline, impulse merchandise, etc...
Magazine subscription systems for three trade magazines. Tracking subscriptions, searching the database with different algorithms for duplicate entries, printing labels for different label sizes and types.
High speed recording/telemetry system used by Department of the Navy and international aircraft companies. Worked to find obscure bugs introduced by the Paris, France engineers (Paris operations were shut down).
Application for a laboratory which allowed a handheld computer to be used to track lab experiments involving lawn care products. Tracked various stages of the lab experiments and the parameters of the experiment.
Application which allowed road construction crews to remotely enter data into a handheld unit, upload the information to the main office. This allowed the business to immediately bill job extras. It eliminated foreman travel time to the main office, eliminated billing disputes, and increased efficiency. The client said it would allow him to not hire two full time office helpers due to the automation of data entry.
Internet portal prototype. This site will draw millions of people from day one. Currently this is a Black Project and cannot be discussed. A very interesting project.
Gasolina Analysis and Tracking program for a super pumping station (over 32 pumps). Tracked variance due to temperature. Information was submitted to the EPA for compliance.
|