John BarrymoreSoftware Developer - Application Development HistoryClick here for PDF VersionPO Box 253Carmel CA 93921 Phone:831-402-3633 Email: john@barrymore.com |
| 04/2000 to 02/2008 |
| Subito Systems, Inc., San Bruno, CA |
| FCSwww |
| Subcontractor to Subito Systems, contracted to First Collateral Services (a warehouse lender) in Concord, CA. FCSwww is a web database used by First Collateral's customers (banks and mortgage brokers) to access current information on mortgages and accounts. Features easy site appearance management via CSS, and dynamically built hierarchically expanding columnar data via Javascript. |
| 10/97 to 05/98 and 12/98 to 06/2001 |
| Lockheed Martin Enterprise Information Systems, Sunnyvale, CA |
| Electronic Unsatisfactory Reporting System |
| EURS is a 4D Server based system that is used to create and manage Unsatisfactory Reports for missile parts and subsystems. Involvement: creation of web-based interface into the application for users located outside the firewall. |
| Systems Engineering Supplier Status |
| SESS is an application used to facilitate audits of Suppliers by Systems Engineering. It has extensive variance and discrepancy reporting functions and accesses external HTML based documents via dynamic hyperlinks and a standard web browser. Involvement: wrote Development Proposal and General Design Document. |
| Assessment Tutorial System |
| ATS is a 4th Dimension/web-based database that is used to facilitate programs and product operations in their performance of self-assessments and independent engineering assessments. It allows the various engineering disciplines to do a more comprehensive assessment of their “work to go” programs by instructing and familiarizing engineering personnel with individual engineering practices, and provides visibility into the relationship of engineering processes. |
| SPALT/PAD Automated Data System |
| SPADS is a database used as a “meta-document”, to track documents relating to changes in hardware for submarine-based ballistic missiles and surface support equipment. Produces a Corrective Action Summary Plan report, as well as an external Metrics report which uses MS Excel and Visual Basic for Applications as the external reporting mechanism. Ported application from Mac to cross-platform (Mac & Windows), and from 4th Dimension v3 to v6. |
| Y2K Remediation Database |
| Used to collate data from numerous Business Units and Organizations within a large aerospace corporation, and to provide statistical analysis of that data. 4th Dimension and MS Excel/VBA. |
| Y2K Source Code Analyzer |
| Used to analyze source code for lines affected by date fields, variables or literals and return the number of lines potentially impacted, as well as storing the line in the application for quick analysis. |
| 03/99 to 01/2000 |
| Warner Bros. Television, Burbank, CA |
| ProductionWatch 2 |
| Complete rewrite of a 4D 2.2.3 multi-user based production cost tracking system (See ProductionWatch, under Automated Solutions Group, below), to a 4D Server 6.5 based system, including proposal, system design document, complete development and migration of historical data. |
| 08/98 to 06/99 |
| Winston Marketing & Communication, San Jose, CA |
| Marketing Database |
| This 4th Dimension database is used to run many aspects of this high-tech advertising agency, including Account Management, Production, Media, Research, Timesheets, Estimates and Invoices. |
| 06/98 to 12/98 |
| CompuCom, San Jose, CA |
| Deals In Progress |
| For Cisco Systems. Complete rewrite of a complex FileMaker Pro application used to manage budgets, milestones and moves for Cisco’s real estate expansions. |
| 06/97 to 10/97 |
| Survivors of the Shoah Visual History Foundation, Universal City, CA |
| Data Conversion Application |
| An application used to migrate >15,000 Holocaust Survivor pre-interview questionnaires from a complex FileMaker Pro database (approx. 900 fields in 40 tables) to a 4D/Sybase structure with an entirely different architecture. Because flexibility was needed in assigning the target columns and tables, this application allows the user, in runtime, to determine the destination columns before performing the import. Written in 4th Dimension and 3rd party externals. |
| 06/97 to 10/97 |
| Paramount Pictures, Los Angeles, CA |
| Maintenance, re-engineering and documentation of numerous FileMaker Pro applications, including Casting Database, Resume Database, Swing-Sets, etc., as well as 4D/Sybase Credits application used studio-wide. |
| 01/96 to 06/97 |
| Automated Solutions Group, Huntington Beach, CA |
| Client Industry: Advertising |
| Timesheets |
| This is a time-tracking application for a major multinational advertising firm. It is used to track employee time both for the purposes of billing clients and compensating employees. The employee’s interface to the system is via Netscape Navigator over the company intranet. The application uses 4th Dimension, NetLink/4D and WebStar. Once the data is entered by the employee, all HR calculations are done in the 4D database. Then both sets of data (client billing and employee compensation) are exported to other systems. |
| Client Industry: Graphic Arts |
| Graphic Arts Yellow Pages |
| This is an on-line, create-your-own-ad web site for Graphic Arts companies, powered by 4th Dimension, NetLink/4D (a GGI external), and WebStar. |
| Client Industry: Public Utility |
| Business Management Information System |
| This is a 4th Dimension database used to schedule training resources for a public utility. It uses WebStar and NetLink/4D to provide and intranet access capability to the scheduler for anyone in the company with a web browser. |
| 03/95 to 12/95 |
| Athos Technology, Inc., Irvine, CA |
| Client Industry: Entertainment |
| Inventory Tracking System |
| This system tracks Information Systems hardware and software resources for a large entertainment corporation. The application’s primary focus is to keep track of users, their workplaces, phone and/or network connections, hardware and software configurations. The system is also designed to track service and technical support calls. The tech support function is tied into a Microsoft Mail system, so that a technician is automatically notified by e-mail that there is a service call, along with the current location and configuration of that system. SuperReport reports are stored in the data file through the use of BLOB Manager. The program was created with 4th Dimension, Foundation, AreaList Pro, DisplayList, ToolSet, SuperReport, BLOB Manager, and the MailMinder for MS Mail external development package. |
| Client Industry: Entertainment |
| Movie Credits Database |
| This system was created to manage information for a movie credits company. The application tracks films, the people who worked on the film and their role in the film. It also tracks companies, and the functions they performed relative to the film. While a fully functional, relational database with several tables, all data can be entered from a single movie input screen, making data entry an extremely simple and quick process. The program was created with 4th Dimension, Foundation, AreaList Pro, DisplayList, and ToolSet. |
| Client Industry: Entertainment |
| Script Management System |
| This application manages script submissions for an entertainment company. It tracks writers, companies, people submitting and receiving submissions, as well as synopses of the submissions. One of the most prominent features of this system is an extremely fast context-sensitive search mechanism which can quickly do ‘contains’ searches even on non-indexed text fields. The application was written with 4th Dimension and a variety of externals. |
| Client Industry: Consulting |
| Client Billing System |
| This application was written for in-house use at a the consulting firm, as well as a vertical market product. It tracks leads, clients, projects, billing & invoicing, etc. The program was written with 4th Dimension and related externals. |
| Client Industry: Entertainment |
| Incident Tracker |
| This application tracks bugs and feature requests in software. It was written for a major talent agency to track their own software developed in-house, as well as software written by external vendors. The program was re-engineered with 4th Dimension and popular externals. |
| Client Industry: Magazine Marketing |
| ASET |
| This is a commercial application, existing for Macintosh only, which was ported to windows when 4th Dimension was released for the windows platform as a proof-of-concept. It is was run on Windows NT Server, with both Macintosh and Windows clients. |
| 12/94 to 03/95 |
| MacTemps, Los Angeles, CA |
| Client Industry: Advertising |
| Call Tracking System |
| This system tracks calls generated by advertising for a Savings & Loan Institution. An ad in each region of the country publishes an 800 number for customer response. Each phone room generates a report of calls received by location and time period. That data is given to the ad agency in ASCII fixed-length format. The Call Tracking System takes the data from each phone room, and merges it into a 4D Server database that can be used by the client to determine the customer response by region, publication and time period, This application was re-engineered using 4th Dimension v.3 and deployed on 4D Server. |
| Client Industry: Aerospace |
| Accounting Program |
| This system was a customization of the A4 Macintosh accounting package from Softek systems of Colorado. The source code was licensed from Softek, and the Purchase Order and Voucher modules were customized for the purchasing department of a large aerospace/research corporation. The A4 package is a 4D Server based system. |
| Client Industry: Aerospace/Information Systems |
| Inventory Order System |
| This was an early proof-of-concept cross-platform Information Systems inventory order system. It uses a 4D Server back end, and a WWW client front end, using MacHTTP (now WebStar) as an intranet server. The system generates html dynamically from data entered into the 4D server database by the IS department, and provides an electronic-forms interface via Netscape to the employees. The tools used to create this application included: 4th Dimension v.3, System7Pack (an external package which provides apple-events support to 4D), MacHTTP, AppleScript, and various tools used to generate html. |
| 12/93 to 11/94 |
| Automated Solutions Group, Huntington Beach, CA |
| Client Industry: Entertainment |
| Post Production Scheduler |
| This application schedules post-production work for a sound editing house. It tracks the various stages of post-production sound and generates a Project Summary Report showing the state of any given project at the time of the report. It was originally written using 4th Dimension v.2.2.3 and commercial external packages, and has since been updated to 4D Server. |
| Client Industry: Entertainment |
| ProductionWatch |
| This is a production cost tracking system. It is used to facilitate tracking of production costs for feature films, episodic television, music videos, and commercials. The application allows clients to instantly compare actual costs and commitments against an individual budget, or, in the case of episodic television, an individual budget and a ‘pattern’ or standard budget for that show. The system allows the creation and printing of Purchase Orders, as well as the ability to match incoming invoices to Pos, and enter variance explanations. Reports generated by this application include Estimated Final Costs, Variance Explanations, Vendor Activity, Budgets, and a wide variety of Purchase Order and Invoice reports. This application was created using 4th Dimension v.2.2.3 and externals. |
| Client Industry: Entertainment |
| Vault Inventory System |
| This program maintains a vault-inventory tracking system for video and audio tapes. It tracks formats, clients, and titles as well as allowing the creation of traffic memos. It was originally written using 4th Dimension v.2.2.3 and commercial external packages, and has since been updated to 4D Server. |
| Client Industry: Transportation |
| Trip Reduction Management System |
| This is a commercial application written to manage compliance with the Southern California Air Quality Management District Trip Reduction Plan. The system is deployed at several large sites (hospitals, aerospace corporations, etc.) in Southern California. Information is entered about each employee from the SCAQMD Weekly Employee Survey Form, and the application then performs all the calculations and prints out the entire blue (Weekly Trip Reduction Plan) and white (Annual Trip Reduction Plan) SCAQMD books required by the air district. The data is then exported to MapInfo© for rideshare matching. This application was created using 4th Dimension v.3 and externals, and deployed on 4D Server. |
| Client Industry: Jewelry |
| Business Management System |
| This system is used to run a jewelry finding and accessories business. It allows the creation and tracking of accounts, inventory, purchase orders, prices and invoices. It was written with 4th Dimension v.3 and externals and deployed on 4D Server. |
| 01/92 to 12/93 |
| Rhino Records, Los Angeles, CA |
| Publicity Management System |
| This application is used to manage and facilitate all operations of the Publicity Department. The system maintains a database of music writers, their importance relative to various genres of music, the publications they work for and/or write for, along with circulation, audience data, and other information about the media outlet. The system also creates mailings of product to music writers, and automatically generates a tracking list from the mailing. The publicity is then tracked either at the time of the contact with the writer, or by entering the data from clippings provided by Burrelle’s clipping service. Reports are generated by project, listing in detail and summary the quantity and types of publicity generated by the department, as well as the total media impact. This program is a 4D Server application written entirely in 4th Dimension. |
| 02/90 to 01/92 |
| MacTemps, Los Angeles, CA |
| Provided a wide variety of Macintosh skills; several long-term assignments, including The RAND Corporation and Grey Advertising. Graphics applications (Adobe Illustrator and PhotoShop, QuarkXPress), long document processing, scientific documentation, spreadsheets, etc. |
| 1972 to 1997 |
| Freelance Actor |
| Resume upon request |