I was originally hired to take over the payroll commission system (Access 97 and SQL Server 2000 development and support) to free up another developer to work with the outside vendors building us an entirely new system to replace the complete legacy code base. Later I was brought onto that project as well, as we gradually discovered how badly the vendor had missed the mark on the payroll portion of the system. (There are well over 100 distinct commission plans, with different structures.)
I’m implementing the payroll module of that system (the only portion of it being developed in house) in C# using SQL Server 2005 and LLBLGen Pro, while still responsible for maintaining the existing system (though I have a helper on that one).
Development from scratch of a J2EE based B2C web application. MS-Access application development and maintenance. DNS, Unix, VMS and Usenet administration and troubleshooting.
Servlet development in Java. Setup and configuration of Jserv and Apache. Migration to Tomcat and Velocity. Linux Administration. Maintained and enhanced a web-scraping application that uses an Oracle 8i database via JDBC. Leisure Industries bought the company that built this system, but did not retain any of the developers. The development system for it had been compromised and was insecure and unusable. I assumed sole responsibility for development and maintenance of the system, which was barely working at the time. An assistant was eventually hired to take over maintenance under my direction. I rebuilt the devlopement environment, and later rebuilt the production server when a disk failed and it turned out the hosting company had not been backing up the system because of decisions made by the original developers.
Maintained and enhanced an MS-Access application used for paying commissions. Converted it from Access 97 to Access 2000 and SQL Server. Maintained and enhanced an extension DLL for BizTalk 2000 to interface to this application's database. Consulted on other Access applications, and did some minor SQL Server programming.
Began work on an issue management system in ASP (VBA and JavaScript) using SQL Server. Project was shelved when the servlet project was made my top priority.
Development in Perl and Java. Analysis, design, and implementation of a distributed client-server user account management solution using Tivoli Management Framework as the underlying mechanism. Project was started in Perl, but after threading bugs were discovered in Perl, development was switched to Java.
Solaris installation and administration.
Worked as a telecommuter from Las Vegas, NV
Onsite consultant for Clark County School District. Implemented and updated a variety of PC to mainframe communication tools, primarily in Visual Basic. Implemented source code control. Trained district staff in maintaining these tools.
Ported 250K line Fortran/assembler system from HP1000/Imlac to VAX/VMS in Fortran and C. The system was used for clothing pattern digitizing, grading, plate layout, and pattern plotting. Enhanced this system to use X Windows graphics, and then to use a relational database system (DEC, now Oracle, Rdb). Added the ability to add text information to patterns on the computer, rather than the previous method of adding printed stickers to plots. Trained and supported the users on the new system. Added minor enhancements as requested. I maintained this system on a consulting basis through 2001 when it was retired. This project was at times a solo effort, and at times a team under my management of up to 6 people, and is the project I was initially hired for, and remained my primary responsibility.
95% completion of a port of the above system to Solaris/Intel using the ODI ObjectStore OODBMS. Project was cancelled when company chose to purchase a 3rd party solution, and I left the firm shortly thereafter. The 3rd party solution was not put into service until 2001.
Developed accounting applications for corporate accounting using MS-Access and MS-Excel, including Balance Sheet, P&L, Transaction Summary, Chart of Accounts Maintenance and PC to mainframe links. Designed and implemented the accounting database. I still maintain these applications on a consulting basis.
In charge of all internet-related activity, other than the web site, which was outsourced (though I did examine CGI scripts for security issues and install them on the ISP's server). Managed email, DNS and connectivity. Implemented the company's firewall (Linux based). Managed the Internet router (initially Ascend, replaced by the Linux based firewall when we went to wireless).
Designed and implemented project-oriented source code control tools for VMS, using DEC/CMS as an underlying mechanism. Ported a large number of freeware utilities from Unix to VMS. Ported Motif Tools (Xmt) package from Unix to VMS and assisted author in testing and debugging the package.
Implemented DECnet communications to the NYC office (where my primary system was actually used). Later implemented DECnet over IP once we had IP connectivity to the NYC office.
Specified and procured all VAX/VMS and Solaris systems mentioned above. Managed all vendor contacts for those systems, including procurement and maintenance.
I was, in effect, a department within a department, responsible for all aspects of the systems with which I was involved.
Led the development of a suite of civil engineering applications marketed by Harris Corporation's Computer Systems Division under the name CivilCAD. (The programs were also used internally by the engineering firm.) Team size varied from 2 to 5. Personally developed the Digital Terrain Modeling program (topographic mapping). Developed COGO (Coordinate Geometry) program based on public domain applications. Designed and assisted in development of Earthworks (construction cut and fill calculation) program. Consulted with subordinates on the design of a BOM (Bill of Materials) application, a ground survey post processing program, and a roadway profile design program. Implemented data import/export to Harris' CAD system using IGES data interchange format.
All of my programs had graphics output capabilities, both to HP pen plotters and Tektronix graphical displays. The COGO program generated nearly complete subdivision plats, enabling the firm to employ only 10% of the typical number of draftsmen for a firm of that size and type.
All development was done on Harris systems (Vulcan/VOS operating system) as well as on Unix systems resold by Harris (Masscomp, using a dual-universe SysIII/BSD4.1 OS, and CCI using a BSD4.2-based OS). Solely responsible for administration of the Masscomp system (we didn't have a CCI system onsite).
The BOM application used the dbVista database from Raima corp. This database was insufficient for our needs, and so we extended it in a joint development arrangement with Raima. I did all the contract negotiations with Raima and managed our relationship with that firm. I co-designed the transaction logging facility that we added and which they took back into their code base. We also ported the database to VAX/VMS for them under contract.
Various programming tasks for internal use only, including wire-frame 3D displays of client properties.
Evaluated the Moss3D software system for Harris Corporation to assess it's viability as a product to serve the US civil engineering market.
Packaged a suite of public domain civil engineering tools for Harris Corporation to use as a marketing tool in selling to civil engineering firms.
Member of the SIDIS seismic data visualization project team. This project was developed simultaneously on VAX/VMS and Perkin-Elmer OS32. Developed all OS-dependent code for both systems, including inter-process communication and synchronization, I/O, and serial communications with the VT180 we used as an intelligent terminal, in Fortran and assembler on both systems. In charge of the source code repository for the project on both systems.
Assistant VMS system manager, responsible for startup and login scripts, user and disk management, and normal maintenance of the system. Developed VMS source code control utilities based on those on the Perkin-Elmer. Developed VMS linker enhancements to match the capabilities of the Perkin-Elmer (which had been enhanced in many ways to mirror the company's mainframe-based development environment). Developed VMS device drivers for the RAMTEK display device based on code from RAMTEK for a different model of device, a different version of VMS, and designed to work with a different graphics software suite.
Trained other programmers on VAX/VMS and Perkin-Elmer usage, both of which I learned at this job from reading manuals. Consulted with other programmers on VMS-related issues, both in programming and system usage issues.
Implemented RJE over DECnet to allow us access to printers and other services on Texas Instrument’s IBM and TI980 networks. (TI was our parent company.)
Technically a co-op job, but I was the firm's only computer programmer. Ported civil engineering and graphics software written in Fortran from IBM 1130 and IBM S/360 systems to Harris H100 system. Modified programs to use HP pen plotters and Tektronics graphics displays. Implemented a job-tracking program in Pascal. Developed a COGO program using pieces of several public domain COGO programs, but with enhanced plotting capabilities. Developed a storm sewer drainage calculation program. Developed a ground cross-section plotting program. Enhanced bridge span stress calculation programs. Managed the Harris system.