Total responsibility for design and implementation of a SQL Server 6.5 database gathering telecommuter call accounting information from Shiva modem/LAN interface servers. This information was served via Microsoft Internet Information Server to HTML/Javascript clients which browsed the database with Microsoft Visual Basic Webclasses scripts. This project involved SQL for interaction with the database, Javascript on the client side, and Visual Basic 6.0 for ASP scripting on the server and for various specialty client applications and utilities included with this system.
Designed and prototyped an online banking terminal in HTML and Java with server-side MS Access standing in for a mainframe DBMS to be designated on full implementation. Worked closely with marketing staff to develop several alternative designs for such a banking station.
Specified and implemented extensions to the Tempe Fire Department personnel time management system. This Visual Basic 4 application acted as client to an Oracle server-side database.
Set up a human resources help desk implementation in MS SQL Server. Managed operation of a client-server system for direct employee access to human resource data downsized from a mainframe.
Ported a DOS C bar code inventory control system to Windows 3.1 as Visual Basic front end calling critical C code as a DLL.
Designed and implemented a consultant resume presentation system that serves clients accessing on the World Wide Web. Consultant personal information is maintained in an MS Access database that can be commanded to convert the whole database into a set of interlinked HTML source pages, which are FTP'ed to the Web server site. Clients browsing the site can search for consultants by name, company, location, or skill set. This site is publicly accessible as http://www.icca.org.
Designed and implemented a data collection system for IC bench test equipment. This application was similar to the Thruput Systems implementation but was written in MS Access on Windows NT. Later, I was called on to port this system to Visual Basic 4.0 on NTW 4.0 .
Designed and implemented, in MS Access, a technical support help desk management system that tracked customer calls to technical support personnel. This application produced numerous statistical reports on performance of the help desk and efficiency of personnel.
Designed and implemented, in MS Access, a laboratory inventory management system.
Implemented, in Borland C++, a product labeling application that produces bar-coded shipping labels for all Intel product shipped from ten plants located around the world.
Implemented an employee time accounting system in MS Access, serving a staff of fifty CAD consultants. This system took time card data to update employee records, then produced statistical analyses of employee performance.
Designed and implemented a data collection and statistical reporting system for a network of functional IC production testers. The system was written in a combination of Clipper and Borland C++, and ran under DOS and Windows NT.
Ported the above system to Windows NT as a Visual Basic 4.0 front end with critical functions coded in C as a DLL.
Took over a patient reporting system written in Clipper and made numerous improvements and bug fixes.
Designed and implemented a mortgage market system for real estate agents. This wide-area client/server implementation consisted of two Clipper programs: a server process that maintained a database of mortgage bids and offers, and a client program that updated and queried the market database from multiple remote locations. The client processes communicated with the server over dialup modem lines.
Interested? Please email Alan Gore<agore@qwest.net>