Developed and continue to maintain the content management system application, "Schoolboard.net". This is a Drupal site designed to allow school boards to conduct and record online meetings as well as upload, search and retrieve documents. This application is used by school boards across the United States.

Developed the content management system "labor.amptp.org" for AMPTP. This system houses the Directors Guild of America (DGA), Screen Actors Guild-American Federation of Television and Radio Artists (SAG-AFTRA) and Writers Guild of America (WGA) contracts for all the Hollywood motion picture and television production companies which are members. The system allows studio executives to search and retrieve contracts online for productions as well as during negotiation meetings.I designed, developed and maintain this system on an ongoing basis.

• In 1984, developed and marketed a software product known as "BILL-85", the first PC-based student loan billing package commercially available to colleges and universities in the United States. In 1990, developed and marketed the "Electronic Financial Aid Library", which was the first computer-based training assistance system for student financial assistance regulations. This development lead to a series of contracts with the United States Department of Education Office of Training and Dissemination in the mid-90's to develop a variety of computer-based study and training aids for the postsecondary education market.• Created the AQMD (formally APCD) Infobase, a searchable information database consisting of California Air Quality Management District rules and regulations.• Since 2005, have been developing and maintaining Drupal Content Management Systems using PHP and MySQL databases.• Developed SchoolBoard.net, a popular Drupal CMS currently used by school boards across the United States.• Utilized technologies such as HTML, JavaScript, PHP, SQL, COBOL, CSS, XML, Perl, REST API and Java to design and implement software solutions.• Managed projects, developed web-based database applications, and provided a variety of information database ("infobase" or "knowledgebase") solutions over the past 40+ years.• Currently working on developing searchable knowledgebases utilizing OpenAI Artificial Intelligence models and Drupal complex content management systems. First project: “The California Real Estate Tutor”, an AI-powered knowledgebase consisting of CA Real Estate rules, regulations and codes as specified by the CA Department of Real Estate. Also contains AI-generated Question and Answer fact sheets that can be used as study guides for the CA Real Estate Exam. Coming May 2023.

- Responsible for updating and maintaining the SDSS Subscription Server system (http://sdss.scbbs.com) to handle online authentication for the GEM eBook Library. The eBooks were developed using XML, CSS, ASP and Java. GEM resells access to this content to Libraries, schools and municipalities across the United States. Thousands of end-users access this system daily.- Also provided technical support to GEM staff and clients which consisted of troubleshooting network, proxy and browser issues. Also responsible for updating, when necessary, Java, JSP, Javascript and Perl code.- Developed a failsafe rollover network utilizing MySQL master and slave databases (using Java servlets) which maintained authentication system access even when one or two servers crashed or were unavailable.- The back end of the site as well as the authentication system was written in Java. The front end (login, subscription creation and maintenance) was written in Perl. Responsible for development and update of all of this code.- Also developed comprehensive online help documentation.- Also worked on development of Slave Narratives Infobase which was first electronic search and retrieve database of the WPA recordings of former slaves.

Division of Special Education- Responsible for re-developing the DSE main Web Site from static HTML to dynamic database-driven information repository. Accomplished this task by re-designing the site to be self-administered – that is, all pages and information on the site can be created, uploaded and maintained using a standard web browser and word processing software.- The site application is designed to allow staff to create user-defined “sub-sites”, using only their browser, to support the Division’s 9 sub-divisions, 10 sub-sections, and 18 special schools throughout the Los Angeles area. In other words, a staff person can create a fully functional web site for each of the above entities using only his/her browser.- Utilized Netobjects Fusion to develop main site template (HTML, DHTML, Javascript). Javascript used for content checking and enhanced graphic display. - Developed web-based control panel that is used to upload and maintain all site data. Also developed security infrastructure that allows userids and passwords to be created for access to specific sections of control panel.- Site currently running on Apache web server under Linux operating system. Site programmed using Java, Java Servlets and Java Server Pages code embedded in HTML. Site database is maintained in MS SQL 7 database server running under Windows NT 4 operating system. Communications between web server and database server accomplished using TCP/IP.- Resonsible for design, development and final implementation of system. Also responsible for hardware/software configuration, documentation and staff training.

Procurement Services Group- Responsible for re-developing the PSG main Web Site from static HTML to dynamic, database-driven information warehouse. Re-designed the site to allow most pages and information on the site to be created, uploaded and maintained using a standard web browser and word processing software. This allows for more up-to-date posting of data and eliminates the need for a single Webmaster to be responsible for all site maintenance.- PSG Site allows LAUSD employees from 791 schools and 1000 offices to access detail on some 5,500 PSG products as well as securely access ongoing Master Contracts.- Developed multi-tiered security system that allows only LAUSD employees with appropriate userid/password to access certain areas of site, such as contract details.- Utilized Netobjects Fusion to develop main site template (HTML, DHTML, Javascript). Javascript used for content checking and enhanced graphic display. DHTML used for Pulldown Menu and Site Map components.- Developed web-based control panel that is used to upload and maintain all site data. Also developed security infrastructure that allows userids and passwords to be created for access to specific sections of control panel.- Site currently running on MS IIS web server under NT 4 operating system. Site programmed using Java, Java Servlets and Java Server Pages code embedded in HTML. Site database is maintained in MS Access database running on same computer.- Responsible for design, development and final implementation of system. Configured all software, created documentation and trained staff.

Information Technology Division- Designed and developed web-based security application used to create and maintain userids on IBM AIX system. Userids on this system are used by LAUSD employees and students for e-mail and Internet access. - The application runs on MS IIS web server, under the Windows NT operating system. It is designed to allow all LAUSD employees and students to self-create userids. The web (HTML) front end accepts input by end user, then verifies this information against the LAUSD Employee (HRS) and Student (SIS) DB2 databases running on mainframe systems. If submitted information is correct, the application then contacts Java server application (also developed by me) running on AIX RS6000 computer which is responsible for creating/updating/deleting userids in the passwd file. AIX application then reports results back to main application which then proceeds as necessary. The communications between the NT application and the AIX application is accomplished via TCP/IP socket calls, and are invisible to end-user. There are 889,030 students in the District, and 75,139 employees.- This application contacts a Windows 2000 computer running IBM UDB as a gateway to facilitate database communications between itself (running on Windows NT) and IBM mainframes. This, also, is accomplished via TCP/IP calls.- Developed multi-tiered security architecture which ranges from minimum access to end-users, medium access to employees and full access to specific ITD staff. - Application programmed using Java, Java Servlets and Java Server Pages code embedded in HTML- Responsible for designing system (hardware/software) architecture, installing and configuring software, developing, testing and implementation. Also created complete documentation and trained ITD staff in operations.- System currently running as Intranet Application (no access outside of LAUSD Network).

- Developed the “Site Director Security Server” (SDSS), which is a web-based, e-commerce enabled security front-end to Next’s (formally Folio Corp.) siteDirector Infobase Manager. SDSS allows clients to sell online subscriptions to online data in a secured manner and on-the-fly. - System was developed to run under a variety of environments. Database used is MS SQL, housed on Windows NT server. Utilizes IIS web server (under Windows NT os) for end-user security and display, Apache web server (under Linux os) for client security and display. Much of end-user security and verification accomplished through a variety of TCP/IP calls to database and other sources. TCP/IP also used for e-commerce (credit card) verifications. Application written using HTML, Javascript, Java and Perl. Initial development in ColdFusion, later replaced with Java Server Pages for better performance.- System supports not only individual customer logins, but also IP-recognition and referrer URL recognition for larger organizations. Site currently processes about 10,000 requests weekly for some 3500 customers worldwide. Subscribers include Palm Beach County Library System, Illinois Association of School Boards, University of Edinburgh, City of San Antonio, Dartmouth College Library, Chicago Municipal Reference Library, Boston College, Andersen Consulting, Mass Institute of Technology Libraries, City of Salem, Yale University Library.- Application relevant to this work order: Kellogg, Brown and Root, a division of Haliburton, distributes an instructional spreadsheet to all its sites performing oil well, oil rig and oil refinery construction. The spreadsheet lays out how construction projects should be done, and links directly to a knowledgebase running under SDSS. It includes sound and video. - Responsible for designing system (hardware/software) architecture, installing and configuring software/hardware, developing, testing and implementation and documentation.