Experience

Contra Costa County Public Works Department
255 Glacier Drive, Martinez, California 94533; 925-313-2000
Information Systems Programmer/Analyst   6/12 – Present

Human Resources (HR2)   Problem when trying to change the street address to 'S. El Camino Real', receive an error message-form 40508: Oracle error: unable to insert record. Blank road suffix ended up being the problem, undocumented system need to enter a period (.) to indicate NO SUFFIX. User is documenting this, no code changes at this time.

Human Resources (HR2)   Problem with system allowing two people to be assigned the same specific position. Discovered previous person in the position had not been properly removed. User properly removed previous person, no code changes at this time.

MaintStar/Inventory Journals (JV)   Problem in performing monthly reconciliation between JV reports and Maintstar warehouse inventories. Several causes encountered and corrected:

• Ensured JV reports used records for the entire month.
• Corrected situation in JV reports determining monthly stock item average cost, allowed credits to 'issued’ inventory can result in quantity (and division) by zero.
• JV reports calculates and uses monthly stock item average cost to 2 places, MaintStar calculates and uses to 4 places. User decided to leave this discrepency.
• Automated JV reports monthly stock item average cost calculation to be run with generation of JV reports.

Inventory Journals (JV)   Made corrections to the Inventory Journal reports to properly balance three inventory 'issue' reports. Determined that missing report entries were due to null entries in a report flag field that was inaccessible in a third-party (MaintStar) system. Created a second canvas for updating this flag field. In addition, when reports are generated a check will be made for any null values for items appearing on the report and if any items are found then this same form will be displayed allowing the field to be updated. Minor report heading and footer changes also made. Oracle form and reports, single developer.

Inventory Journals (JV)   Added separate credit report line and debit processing for Enterprise Management (Airports) organizations on JV reports. Modified SQL (added a record type field) to create a summary record for Airport charges, referenced in code as a 'sub-header' record, and subtracted 'sub-header' credit from 'header' record credit total. Oracle reports, single developer.

GSD "Pencil" Budget System   Ran year end update to GSD "Pencil" budget system. Since update was done before 2013 user noted that default fiscal year was not correct. Added pw_Utilities module with getCurrFYID function to produce a correct default fiscal year. Also wrote a GSD Pencil Budget New Year Procedure, 5 pages with a second 3 pages for recreating the database. Microsoft Access VBA, single developer.

Medleave   Microsoft Access database loops and cannot get out of it. Found data file was only 1KB. Operations restored the data file and I replaced the front ends on two computers. Microsoft Access database.

Engineer Drawings   Search on road name from list view is not finding all entries with that road name. Determined problem was with mixed case input not matching, corrected search. Oracle reports, single developer.

Public Works Phone List   After merger with GSD and additional hires there are too many names for the printed Public Works phone list page (Legal size paper, Landscape orientation). Modified report layout to print department column heading, followed by names, phone number, and optional group of names for Airports and M&T Lab departments where they share a single phone number. Created a database view and database functions to provide all input. Oracle form and report, PL/SQL functions, database view, single developer.

Universal Time Sheet (UTS)   Discussed merging GSD Option Codes with user, who decided to not do a one-time import of the current GSD option codes at this time. If they want some added for Universal Timesheet pop-up selection, informed them how these could be submitted for normal Option Code input. Also, if they want a whole bunch added then we can do a one-time download. Analysis only.

Overhead Rates   Minor modification to form to expand display of overhead rates from 2 decimal places to 3. Also modified view to correct organization selection, made agency dependent. Oracle form, database view, single developer.

Joint Billing System (JBS)   Minor modification to JBS summary report to include appropriate CD and PW designation with charge numbers. Oracle report, single developer.

Conversion from Oracle 5/6 to Oracle 11g   Converting current systems, forms, and reports, to 11g. Also establishing new form standards for Public Works Department. Oracle form and report, single developer.

Joint Billing System (JBS)   Updated work order prefix code in JBS for Universal Time Sheet. One line code change in daily log. Oracle form, single developer.

Program Accounting   Accrual work orders are appearing in normal activity charge lists and not in accrual charge list. Located problem in views and the function generating the selections. Replace some hardcoded exceptions with dynamic Select statement using table data criteria. Also made approved changes to program accounting and time accounting table data to put them both in sync. Oracle form, PL/SQL function, database view, single developer.

GSD Work Order   When deleting the last displayed row get "Field must be entered." message when trying to save. Modified to remove row with appropriate buttons enabled. Also added messages (in bottom bar) to show what mode just entered and added message when trying to add a work order that already exists when they enter the work authority field, not just when they try to insert later. Also enabled ADD button after a find for a work order that doesn't exist. Oracle form, single developer.

Universal Time Sheet (UTS)   Cleaned up the task code list. Modified view used to remove Accrual, blank, and duplicate task code/description pairs. Oracle form, database view, single developer.

Universal Time Sheet (UTS)   Modified database function to include the new GSD Work Orders as available for the UTS to copy over to a new pay period. Oracle database function, single developer.

Universal Time Sheet (UTS)   GSD folks added to Universal Time Sheet; point-of-contact for implementation. Implementation calls included: access to timesheet problems, improper default shifts, charge numbers not available, minor (old) user documentation errors, and routing to Daily Log timekeeping instead of UTS. Routed calls appropriately.

Daily Log   Modified Daily Log form to prevent new GSD work order's hour entries to cause a switch to the "Daily Log lite" form. Oracle form, single developer.

GSD Work Order   Created a one view form for temporary use in updating the GSD Work Orders for use with the daily timecards. Created SQL/DDL script to establish new table in production, modify charge number view to access it, and one time load of new GSD Work Order table. The view will contain all entries from the new table, so they will be free to enter any work order that they wish to use with the timesheets. Loaded GSD tasks into existing Task table. Oracle form, SQL/DDL scripts, single developer.

Daily Log   Modified column popup (LOV, List Of Values) selection to provide the appropriate list of permits and removed a now unneeded "Permit Update" button. This corrected problem of permits sometimes not available when they should be, and sometimes available when they shouldn't be. Oracle form, single developer.

Engineer Drawings   Modified functions to consolidate multiple road number and names into single fields to standardize both road suffixes and portions of road names. Oracle database function, SQL/DDL scripts, single developer.

Engineer Drawings   Created new view to use a new road info table, modified forms to use new view. Oracle form, database function, SQL/DDL scripts, single developer.

Engineering Drawings   Modified Engineering Drawings form to jump between "detail" and "list" canvases without affecting ezisting "list" canvas query selection. Consolidated the "Exit" button code similar to FileStor. Changed the first page displayed when starting from "detail" canvas to "list" canvas. Added a second window so both "list" and "detail" canvases can both be displayed at once. Added double clicking on "list" window row item to display associated "detail" window for that row. Oracle form, single developer.

Flood Control (FileStor)   Added resizing to form by adding scroll bars to window and changing “list” form to 'context' type. Fixed Exit button and window close box to exit the window properly when in query mode. Cleaned up both formatting and default canvas and window sizing. Cleaned up all buttons to prevent some erratic behaviors. Oracle form, single developer.

Engineering Drawings   Created functions to consolidate multiple road number and names into single fields for input into new Laser Fiche system. Oracle database function, SQL/DDL scripts, single developer.

Shoestring Solutions
Danville, California 94526-0094; 925-389-0710
Software Developer, Owner   9/98 – Present

Established Shoestring Solutions in Danville for software contracting; building solutions to problems through software development.  Various jobs in 4th Dimension (4D), CSS, HTML, JavaScript, MySQL, PHP, VBA, XML, YUI (Yahoo User Interface, AJAX/JSON). 

• Created automatic generation of weekly reports for Business Operations Group.  Simplified one hour manual data download and Excel formatting process to one minute menu selection and generation of each report (CSS, HTML, JavaScript, MySQL, PHP, and YUI datatable).
• Converted Joomla "list" HTML page from 1.5 million character download to less than 0.5 million character download by converting formatting from server side PHP to frontend JavaScript formatting using a YUI datatable; also added column sorts and dynamic search (CSS, JavaScript, and PHP).
• Created widget to YUI pagination to display count of rows listed and a clear button to clear entered search criteria (JavaScript).
• Added placing cursor on first input or select element, if one exists, on site's HTML template page (CSS and JavaScript).
• Added display of logged on user's name in site's HTML template page header (CSS and PHP).

• Production Watch 2, for Warner Brothers Television  System for tracking television production costs per episode, replacement for Production Watch (4Dv2) system used by Warner Brothers.  From requirements provided by Barrymore Information Technologies submitted marked code changes and additions to the new system under development.  Built as a cross-platform (Mac/PC) 4th Dimension (4Dv6) client/server relational database.  Part of a three (plus) person development team for project.
• Production Watch, for Warner Brothers Television  Created modifications for the existing Production Watch (4Dv2) system to export specified data. Single developer for submitted modifications.
• "Match" program, for Warner Brothers Television   Created a one-time program (4Dv6) to assist in standardizing company names prior to import into the new system. Lead of a two person development team for project.

Davora Insurance Agency
1250 Pine Street, Suite 305, Walnut Creek, California 94596; 925-933-2188
Agency Producer (California Agent license 0E01889)  3/04 – Present

Prospect for new clients; quote insurance needs; advise of possible exposures, coverages, deductibles, and discounts; complete the application process; fulfill any underwriting requests; advocate for client through issuing of the policy; inform client of any insurance company changes affecting their policies; resolve inquiries; and provide ongoing customer support.  Farmers Financial Solutions (FFS) Registered Representative (Series 6 and 63).

Lockheed Martin Enterprise Information Services
1111 Lockheed Martin Way, Sunnyvale, California 94089; 408-742-7151
System Integration Analyst Specialist   5/00 – 11/01

Export/Import Licensing & Compliance Office (EILCO) License Tracking  System for tracking Export and Import License data.  Requirement specification developed with customer consultant and future system administrator.  New system replaces existing system of Excel spreadsheets.  Multi-phase schedule generated from requirement specification.  Coded and implemented Phase 1 of system, including import of data from Excel spreadsheet data.  Implemented as 4th Dimension relational database on Windows 2000 Server, with accommodation for Web Serving anticipated for a later phase.  Lead of a two person development team for project.

ACAS Service Request  System for tracking ACAS Service Requests from request creation within the system to work completion and payment.  Inherited existing system implemented as a Microsoft Access database.  Reviewed and provided estimates and recommendations for customer requested modifications.  Coded and implemented changes (VBA).  Implemented as Microsoft Access relational database.  Single developer for project.

Salaried Performance Appraisal (SPA for 2001)  System for submittal and initial processing of yearly Salaried Performance Appraisals for Lockheed Martin Space Systems.  Modifications to existing Microsoft Word form for Managers and an Excel based system for all other salaried personnel.  Reviewed and provided estimates for Human Resources requested modifications.  Coded and implemented changes (VBA).  Implemented as cross-platform (Mac/PC) Microsoft Word and Excel templates.  Single developer for project.

Failure Reporting and Corrective Action System (FRACAS)  System for discrepancy documents.  Added database modifications, including changes for generation of dynamic HTML pages.  Added JavaScript, where appropriate, to dynamic pages.  Implemented as 4th Dimension relational database with Web Serving on Windows NT Server.  Part of a six person development team for project.

Local Assessment Tool (LAT)  System for scanning designated file servers for HTML files and checking for required classification tags.  Modified existing Perl script to run on Mac platform, it already ran on Windows and Unix platforms.  Downloaded Perl, analyzed, designed, coded, and tested. One day job, instant Perl programmer.  Single developer for modification project.

Lockheed Martin Missiles & Space
1111 Lockheed Martin Way, Sunnyvale, California 94089; 408-742-7151
Manufacturing Research Engineer, Senior; Data Systems Programmer, Senior   10/85 – 5/00

Infrastructure Improvements Database  System for tracking Infrastructure Improvement Initiatives and their associated Operating Characteristics.  From discussions with customer created database tables, relationships, VBA forms, navigation structure, reports, charts, and secure access system.  Implemented as Microsoft Access relational database.  Lead of a three person development team for project.

Shop Information System 2 (SIS 2)  System for generation and processing of Shop Orders for the Solar Array Center.  This was a replacement system for the original Shop Information System.  This system allows Manufacturing Engineers to create a Shop Order Template for creation of a part.  The Template is created from selecting standard steps from a Step Library.  Each step has a manufacturing type associated with it and one or more sub-step items that inform or collect data and sign-offs.  Shop Orders are generated from these Templates and are editable after creation.  Production anomalies are also handled and Shop Order modifications logged.  Analyzed, designed, coded, and tested.  Implemented as 4th Dimension client/server relational database on Windows NT Server.  Part of a two person development team for project.

Salaried Performance Appraisal (SPA for 1999 and 2000)  System for submittal and initial processing of yearly Salaried Performance Appraisals.  Inherited a Microsoft Word form for Managers and an Excel based system for all other salaried personnel.  Reviewed and provided estimates for Human Resources supplied modification wish list.  Also provided estimates for items needing correction that were discovered during the review process.  Coded and implemented changes (VBA).  Received a Superior Performance Award with implementation team and an individual Certificate of Achievement from customers.  Implemented as cross-platform (Mac/PC) Microsoft Word and Excel templates.  Single developer for project.

CRSS Flight Operations  System for tracking satellite instruction completion and requirements during initialization orbits.  Initializations must occur during the first orbits of a satellite by ground stations sending a set of planned commands.  Occasionally abnormalities occur during these orbits which require adjusting of commands.  The created system first parses initialization documents (VBA, Word and Excel) into records for initial import into the database.  After importing the system allows dragging of commands between orbits and other editing of command sequences.  As changes are made, or commands marked as completed, the system dynamically checks the planned command order and updates command completion requirements.  These requirements are based on prerequisites, same orbit requisites, and post orbit requisites that have also been loaded into the system.  Warnings and non-compliance are indicated by appropriate messages and red, green, and yellow color-coding.  Implemented as 4th Dimension relational database on Macintosh.  Single developer for project.

Configuration Accounting System (CAS)  System for tracking "as built" manufacturing configuration for use in standalone or small group areas.  System was patterned after an existing mainframe system.  Inherited system in early stage of development.  Completed coding, imported data from an obsolete system, and provided initial user training.  Implemented as 4th Dimension relational database on Macintosh, later converted to Windows.  Single developer for project.

SPALT/PAD Automated Data System  System for tracking status of Program Office documents relating to changes in hardware.  Analyzed, recommended, and coded corrections and enhancements.  Implemented as 4th Dimension client/server relational database on Macintosh.  Part of a five person development team.

Design Release System (DRS)  System for creating "as design" manufacturing configurations, including exploding parts lists.  Upgraded an existing system from single screen navigation to a more friendly multiple window navigation implementation.  Analyzed, recommended, and coded corrections and other enhancements.  Implemented as 4th Dimension client/server relational database on Macintosh, later converted to Windows.  Single developer for project.

Electronic Log Book  Prototype system for electronically processing manufacturing Test Procedures.  Existing Microsoft Word and Excel documents loaded into the database as single objects (AppleScript), presented to user in a controlled manner for data entry and sign offs (VBA, WordBasic), and progress tracked.  Prototype implemented as 4th Dimension client/server relational database on Macintosh.  Single developer for project.

Countdown Manual Parser   System for parsing selected Countdown Manual (RTF document) text information into records for input into an existing database.  Implemented as cross-platform Microsoft Word template (WordBasic).  Single developer for project.

Quiz System  Prototype system for processing of Air Force training Quizzes from instructor entering of questions and answers to student completion of a quiz, with status tracking.  Quizzes are generated either manually by selecting questions or automatically by selecting one or more question attributes (e.g., 30% very difficult questions).  Once a quiz is generated and released it may be taken on-line or several printing options are available, including printing multiple versions with same questions in different order or test with separate answer sheet.  Designed, coded, and tested system.   Distributed as an installation disk with ReadMe file and Quiz System Guide covering general system structure and use of the Quiz System.  Prototype implemented as a Visual Basic front end to Microsoft Access relational database on Windows 3.1/95.  Single developer for project.

Self-Study Guide  Prototype system for creating Self-Study Guides based on Asymetrix's Computer Based Training module (OpenScript).  Guides are created by instructor and taken by personnel.  Implemented with Informix relational database on Windows 3.1.  Single developer for project.

System Operations Group Lead  Assignment as System Operations Group Lead for Space System Division (SSD) Electronics.  Promoted a "work team" structure that supported empowerment of group members to make and implement decisions in their individual areas of expertise (i.e., Macintosh, Windows, or SUN/Unix.  Established and then expanded the Local Area Networks for the SSD Electronic Products, SSD Electrical Power Products, and Solar Array Centers.  Collaborated with Information Services and Facilities personnel on network design and equipment installations.  Diagnosed and corrected problems with Cabletron ethernet hub, StarController, Netway, Maxway, Fastpath, and GatorStar network equipment.  Setup and maintained AppleShare file servers, 4th Dimension Database Server, and Microsoft and QuickMail E-Mail Servers.  Installed Macintosh computer, printer, and network hardware and software.  Counseled users on the use and configuration of AppleShare, Canvas, MacTCP, Microsoft Excel, Word, and Mail, QuickMail, Netway SNA, and Telnet software.  Received an individual Superior Performance Award from SSD Electronics Manufacturing Division for support of their Paperless Project and general business needs.  Lead of a one to seven person support team.

Generative Planning (GenPlan) System   System for generative creation of plans (aka manufacturing work instructions, MWI).  A manufacturing planner using blueprints, parts list, and other information enters specific information and appropriate codes (from a code book) which will then generate the manufacturing work instructions for manufacturing of a specific part.  (These MWI's are sent to another system to create instances as shop orders.)  Created programming specifications (DCF, CMS) and handled project level responsibilities.  Analyzed, recommended, and coded enhancements.  Instructed personnel in design, coding, testing, and implementation of ISPF/PDF Panels and Libraries, COBOL and FORTRAN programs, CLIST command procedures, and JCL.  Received two individual Letters of Commendation from separate customers.  Implemented with VSAM files (with our own record protection scheme) on IBM 3090, MVS/XA TSO.  Part of a five to seven person development and maintenance team for the project.

MSD Manufacturing Program Support Systems Analyst  Assignment as temporary Systems Analyst for Missiles System Division's Manufacturing Program Support for six months while existing Systems Analyst worked on a special project.  Major assignments included:

1. CIN and Stop Order Posting  System for alerting shop personnel of postings to shop orders of Change Incorporation Notices and Stop Orders when transactions affecting these shop orders were attempted.  System required modification to the Factory Data Collection system and two other systems.  Specifications for two different programming groups created and submitted for work to be performed.  Coordinated with these programming groups through completion of the project.  Portions implemented on both IBM 3090 and Tandem NonStop II systems.  Lead of a two person analyst team for creation of the specifications and project coordination.
2. FDC Uniform Access & Refresh  System for accessing NonStop Factory Data Collection (FDC) system from various systems and automatic refreshing of code.  There was a problem with FDC system code changes not becoming effective because some FDC terminals would "never" leave a specific transaction screen, thus continuing to run "old" code in memory.  In addition new full screen terminal access to Tandem FDC transactions from both Tandem and IBM terminals and a uniform access structure needed to be established.  Created and submitted specifications for work to be performed and a comprehensive user guide for full screen terminal access.  Implemented on Tandem NonStop II, Guardian systems.  Single analyst and coordinator for project.
3. SWFLANT Remote Daily Timecards  System for processing remote daily timecards from a new Georgia facility.  Shop Floor personnel generate daily timecards that require daily processing, along with other Factory Data Collection data.  Specifications created, reviewed by both Manufacturing and Payroll personnel, and submitted for work.  (Actually returned to the Factory Data Collection programming group shortly after this and lead the programming effort for this project as part of a two person development team.)  Portions implemented on both IBM 3090 and Tandem NonStop II systems.  Lead of a two person analyst team for creation of the specifications and project coordination through submittal.

Factory Data Collection System   System for collecting shop timecard, shop order step buyoffs, and other information directly from the shop floor.  This information passes initial field edits and validation before being passed along to other systems for processing.  Analyzed, recommended, and coded enhancements.  Created programming specifications (DCF, CMS) and handled project level responsibilities.  Instructed personnel in design, coding, testing, and implementation of COBOL programs, Obey and Exec command procedures, and JCL.  Implemented with ISAM files on Tandem NonStop II, Guardian systems.  Part of a five to seven person development and maintenance team for the project.

Automated Data Acquisition Labor Computation (M61) System  System for batch processing of specific daily Factory Data Collection (FDC) data.  A large number of FDC transactions stored data on the Tandem system.  This data was unloaded and batch processed into several other systems.  Created a specification documenting this existing system.  Analyzed, recommended, and coded enhancements.  Implemented on IBM 3090 system.  Single developer for maintenance on project.

Lockheed Martin Missiles & Space
1111 Lockheed Martin Way, Sunnyvale, California 94089; 408-742-7151
Data Systems Programmer   11/80 – 2/83

Assignment as Task Leader of Systems Administration Group of Timesharing Services Department.  Insured establishment of users on two DECSystem-2060 computers, execution of the weekly accounting programs, and distribution of utilization reports.  Handled user billing and other administrative inquiries.  Programmed System Administrative functions (DECSystem 20, TOPS-20, DPL/SQL, JCL, and Command procedures).  Attended Fall 1982 DECUS Symposium as part of a group from Timesharing Services.  Lead of a three person administrative team.

Intel Corporation
2200 Mission College Blvd, Santa Clara, California 95054; 408-765-8080
Computer Operator, Operations Analyst   10/78 – 5/80

Assignment started as Trainee and advanced to Lead Operator of two DECSystem 10 (TOPS-10) and Univac 1182 computers with networks.  Also performed as backup Computer Room Supervisor and Operations Analyst (Univac ECL).  Responsibilities included training new Operators, formalizing and simplifying procedures, monitoring system load, trouble shooting user problems, building disk structures using DIAMON and TWICE, interfacing with System Programmers and Customer Engineers, and diagnosing Codex and Bell Telephone modem problems.  Completed Digital Equipment Corporation's Operator Training and Administrator course.  Lead of an eight person swing shift support team.

Apollo Oil Company
Hayward, California
Manager   6/72 – 3/77

Assignment started as a part-time position and advanced to Manager of the Hayward Station.  Managed for more than two years.  Responsible for all aspects of station operation, including hiring and training of personnel, scheduling work assignments, calculating daily books, and ordering supplies.  Letters of recommendation from both of my supervisors at the time are available.  Lead of a six to seven person team.

.NET

Open Systems

Mainframe