JL Zeeb Resume (Text)

OPERATING SYSTEMS

DEVELOPMENT METHODOLOGIES

SOFTWARE PRODUCTS

LANGUAGES

AFFILIATIONS

EMPLOYMENT HISTORY

PYRAMID COMPUTING, INC., Evergreen, Colorado  (May 1987 - Present)

President/Owner (January 1979 - Present)

Pyramid Computing was founded in 1979 as a part time business primarily for development and marketing of Software for Personal Computers.  In the years since its inception, three products have been developed and are currently being supported.  In May 1987 it evolved to a full time business including mainframe and PC consulting services.

The following is a list of the consulting engagements while with Pyramid Computing.  Each engagement lists the client as well as the nature of the project.


 

One of multiple Project Managers on the WFHM Automated Decisioning Integration program to integrate a new rules-based automated decisioning engine across the three Wells Fargo companies.  Developed automated tools to monitor this 250+ person program.  Project Scheduling was provided by Microsoft Project.  Used Visual Basic for Applications in MsProject, Excel, Word, PowerPoint & Outlook to develop the following automation.

• Created process that extracted assignments from the multiple MsProject schedules and created tasks in each person’s Outlook Tasks folder.  These tasks used Outlook reminders for Start and Finish dates.  When Outlook tasks were marked as complete, it sent a status update email to the Project Manager.

• Created process that posted task updates to the MsProject schedules from the status update emails generated from Outlook.

• Created process to automatically request task status updates via email for active tasks without a current status update.

• Created process to extract Late vs. Baseline tasks from the multiple MsProject schedules and import into Excel for review.  This allowed anyone to review this information and did not require a MsProject license.

• Created process to generate Start & Finish S-Curve charts from multiple MsProject schedules and automatically create an indexed PowerPoint presentation.

• Created processes to manage Deliverables and Work Products.  Created standard workflow (create, review, revise, approve) that can be inserted into the MsProject schedule to identify these tracking milestones.  Excel reports were created that extracted Deliverables and Work Products from the multiple MsProject schedules for items that were late or coming due soon.

Designed and implemented an integrated Earned Value Management System (EVMS) using Custom off the shelf (COTS) tools with custom interfaces to form the individual tools into an integrated system.  The program (Healthcare Integrated General Ledger Accounting System (HIGLAS)) is a ten-year plan to implement Oracle Financials to receive Medicare claim data electronically from the 50 state Medicare claim processors.  The EVMS system that was implemented to monitor this 200+ person program was approved by the government agency (CMS) as fulfilling the 32 OMB EVMS guidelines or equivalent.  Project Scheduling was provided by Microsoft Project, Earned Value calculation and basic reporting were provided by MPM and graphical EVM reporting was provided by Winsight.  It used Visual Basic for Applications in MsProject, Excel, Outlook & Access to develop the following automation.

• Created interfaces from four IBM labor reporting systems to post daily actuals at the work package level to the Integrated Master Schedule (IMS) in MsProject.

• Created and Excel spreadsheet to allow review of actuals posted by the Work Package Manager (WPM) and updates to Estimate to Complete (ETC) and planned Start & Finish dates.  The changes made in this spreadsheet were posted to the IMS on a weekly basis.

• Created Excel tools to extract data from MsProject and provide the ability to maintain work package data, milestones, resource assignments and predecessor relationships.  These tools allowed the thirty work package managers to provide updates to a central IMS administrator without ever having direct update access to the IMS.  

• Created several Excel based reports/query tools that allowed Work Package Managers or Cost Account Managers to extract current data from the system relating to Deliverables, Milestone Variances, Resource Allocation & Actuals & Budget vs. Actuals.

• Extensive use of automation was used to distribute information via email.  For example, weekly reports were zipped and sent as an email attachment to the Work Package and Cost Account Managers.  Work Authorizations were created as PDF files and attached to an individual email sent to each of the 200+ resources weekly.

Designed an integrated project plan process using Microsoft Project.  This consisted of over 50 concurrent project plans linked by a common resource pool.  Project plans were source controlled thru checkout / check-in.  Customized the MsProject plans with over 200 components (Fields, Tables, Views, Filters, Forms, Calendars, Macros).  Used Visual Basic for Applications in Excel, Outlook & Access to develop the following automation.

• Created a weekly process to integrate these plans and distribute the centrally maintained components.

• Developed an automated process to maintain the individual resource calendars for 250+ people in MsProject by extracting vacation days from the Lotus Notes Vacation Planner tool.

• Created an Excel timesheet to collect weekly actuals and allow bottom-up re-estimating thru remaining work and start/finish date adjustments.  This data was then automatically posted to the MsProject plans.  Developed an automated process to generate these timesheets and email them each week. 

• Extracted and reported Earned Value information as well as calculating EV performance ratios (SPI, CPI, TCPI, etc.) not provided by MsProject. 

• Created an automated process to generate S-curve charts as PDF files showing cumulative baseline, projected and actual work/starts/finishes for each MsProject plan.

• Created an automated MsProject plan auditing process that analyzed each plan for over thirty items. i.e. Task guidelines compliance, Task relationship quality, Resource assignment anomalies, etc.  This created a custom email for each plan owner with the specific plan issues identified.

• Created a consolidated Resource Information report showing baseline, actual and projected hours by week by MsProject plan.  This was used to analyze resource-leveling issues.

Database team lead and interim Test team lead.  Responsibilities included selecting modeling software (ErWin), Project planning, estimating and tracking, coordinating data model changes with customer DBA’s, etc.  Specific tasks included:

• Setup a backup Oracle server for the CIS database.

• Maintained Oracle user, table, column and security updates.

• Created daily test data creation/update scripts.

• Created procedures to synchronize Oracle databases in three physical locations.

• Reviewed and updated Use Cases using RequisitePro.

• Created DataAttributes template to be used in Design Use Cases.

• Installed and maintained ClearQuest Oracle instance.

• Created Data Project Plan in MsProject with tasks, task dependencies, estimates, resource assignments.  Used resource-leveling to refine the plan.

Upgraded an IBM Delphi 4 application (xTools) to Delphi 6.  Generalized this specific custom application that interactively displays data model information including tables, column definitions, constraints and valid values.  Created a process to extract metadata from ErWin, Excel and Lookup database tables to populate the xTools database.

Developed tools to assist in the merging of data from Wells Fargo Bank’s twenty-two states to the Norwest HOGAN Banking System database.  These tools consisted of a program that would take a COBOL copybook as input and create a SAS program that would analyze the contents of each field in the file.  Developed Excel macros that used OLE to interface with the Extra! 3270 emulation program to download mainframe files, modify them with Excel and upload them back to the mainframe.

Developed tools to assist in conversion of over twenty acquired Bank’s data to the Hogan database.  These tools consisted of a generalized Front-end that would match and merge data from various input sources to a single input file that would be input to the main conversion program.  Also developed macros to extract data from Excel spreadsheets for uploading to the mainframe for input to the conversion process.  Developed an Account Number duplicate checking process that would check the acquired Bank’s account numbers against over 50 million account numbers in ten different input files.

Developed a complete automated system to support the operations of this 120+ student school.  This consisted of a Customer Database Excel spreadsheet.  This maintained data on all children in the school, parents & class assignments.  The functions supported were, entry of receipts for each month, calculation of tuition and additional charges, creation of invoices, class lists, attendance sheets, sign-in / sign-out sheets, etc.  Specialized printing requirements were supported by Microsoft Word using OLE automation.

Lead Programmer / Architect for Mainframe Conversion on this three-year project to convert Child Welfare data from the fifty-eight counties in California to a single DB2 Mainframe database.  This database serves a Windows-9x multi-tier software application used by over 10,000 child welfare workers.  Instrumental in developing the conversion architecture, standards and procedures.  Assisted with the development of Delphi based, PC Data Mapping tools which generated Mainframe COBOL/DB2 conversion programs.  Designed and created a generalized exception reporting process which was used for all conversion reporting.

Acting Vice President Information Systems for this startup company.  Established strategic plan for software platforms and development.  Developed Corporate Data Model and Systems Data Models that consisted of 150 tables and 1200 fields.  Developed programming standards and infrastructure for development the company’s core processing systems.  Directed the development of a proprietary software system utilizing capture, storage and retrieval of full motion video.  Portions of the application are implemented on the World Wide Web using Visual Basic programs that generate interactive Web pages using CGI Scripting.

Participated in various aspects of this three-year project to consolidate and convert twenty different banking software systems from two data centers into one common Hogan Banking System.  Worked with the Gladstone Conversion Software to convert Deposits applications that included DDA, CD’s, IRA’s, Savings, Restraints and Cycle Data.

Performed various functions to help define the standards and methodologies for the new IBM Mainframe environment.  This included: IBM SAA-CUA Screen standards, Development Life Cycle processes using Endevor, CICS Screen Attribute Test Transaction, and Program Documentation Standards.

Functioned as Project Manager for this project to implement the first phase of a new purchasing system.  Assisted in the planning and design of the bi-directional interfaces between the Database Maintenance on the IBM and the processing systems on the Unisys.  Was instrumental in the development of Audit and Synchronization processes to ensure that the data on both platforms was synchronized.

Functioned as Project Manager for this project to convert an existing real-time Order Entry / Invoicing system from the Unisys V-Series to an IBM ES-9000 Mainframe.  This consisted of detail design and development of a detailed work plan.  It also consisted of planning the use of Gladstone Conversion Software to convert both the COBOL source code and the data.

Functioned as Project DBA and System Architect during the downsizing of this project.  The project used over 140 database tables that occupy 12GB of storage.  Developed middle-ware to maintain duplicate read-only copies on the PC/LAN Oracle database of 30 databases that were maintained on the Mainframe in Datacom/DB.  This process is completely data driven and consists of a Mainframe extract program and an Oracle database update program.  Changes are detected on the Mainframe; the changed rows from each table are extracted and transmitted to the LAN along with the copybook for the table.  The Oracle update program processes the copybook and builds an internal table that maps the input data fields and data types.  It then uses the Oracle SQL dictionary tables to dynamically create an Update or Insert command with the data from the mainframe extract record.  It also performs a full database record count comparison and hash-total to ensure that the databases are in sync.

Formed a company to provide retail voice processing services and develop software for the Computer Voice Processing Industry.  The following services are currently available: Voice Mail, Voice Bulletin Board, Computer Appointment Verification and a Computer Telephone Monitoring Service for the Homebound.  Software is currently being developed using a Windows OOP development system with execution under OS/2 to permit multi-tasking for several phone lines.  Database access uses both DBase and IBM EE Database Manager.

Functioned as a member of the task force to evaluate downsizing the Billing/Promotions Project.  This consisted of a feasibility study, cost analysis, selection of a development environment, software evaluation and selection.  As a result of this study, the decision was made to develop and operate the remainder of the project on the PC/LAN using MicroFocus COBOL and Oracle.

Designed, developed and implemented a Database Management System for this Environmental Investigations Firm to control information collected in the investigation of Superfund dumping sites.  The system consisted of over thirty tables, entry screens and reports which support a database that controls the relationships between Waste Generators, Dumping Sites, Trucking Companies, Waste, Investigations and Documents.

Functioned as Project Manager and System Architect for the implementation of enhancements to the existing Order Entry System.  These enhancements were to integrate this system into the new menu system, standardize screen interaction to conform to SAA/CUA specifications and create common I/O modules so that the new Relational Database Tables could be easily integrated.  The system was written in Command Level COBOL and consisted of over 300 programs, 20 master files and 100 screens.

Taught prepared courses in Basic and Advanced PL/I programming at Dow Corning and Brooklyn Union Gas.  Developed and taught a custom course in PL/I for Fortran Programmers at Southwestern Bell Telephone.

Functioned as Project Manager and System Architect for the Technical Design phase of the new Order Entry / Billing / Promotions System.  Several documentation and design tools were developed to support design documentation for this large application.  These included; Documentation formatting program, Automated Logical Access calculations using Lotus 123, Access path documentation aids using TSO/SPF edit macros and Data Element / Entity reporting and cross-reference utilities which were run against the documentation source and permitted population of the Dictionary directly from documentation.

Made major enhancements to ESAS, the software package marketed by ZEEBAC for three additional clients.  These enhancements included; Conversion to BASIC 6.0, Increased capacities, Data Acquisition directly from laboratory equipment, Technical improvements resulting in increased speed and support for OS/2 and the PS/2.

Prepared the initial feasibility study for a new Order Entry/Billing/Promotions System.  Functioned as Project Manager of a seven-person team for the Functional Systems Design phase of this 2-3 year project.  The system was designed with Shared Corporate Databases using ADR Datacom/DB.  The design process utilized the Method/1 development methodology and Data Modeling and Data Flow techniques using Excelerator/PC computer aided design software.  It also included prototyping using ADR/Ideal.  The result of the Functional Design was a 700-page document that contained the specifications of the system.

Designed and developed a Document Preparation System for preparing the legal documents related to loans.  This system allowed for the selection of forms and prompted for the data items required on those forms.  The result was integrated with the mail merge function of Microsoft Word to produce the final documents.

Assisted in the enhancements to a product called IDSF (Interactive Database Segment Facility) which allows on-line modification of database segments.  The enhancements included creating an Assembler Language Command Level CICS version which supports DL/I and functions the same as the IMS DB/DC version.  Modifications included both MVS and DOS support and testing.

Designed, developed and implemented a system for analytical spectrographic laboratories to allow data entry of raw laboratory readings.  Concentrations of various elements were calculated as well as the printing of reports.  Development was in compiled BASIC on the IBM-PC.

Designed, developed and implemented a Real Estate Closing System which supported the data entry and printing of as many as twelve different legal forms.  The project included hardware evaluation, program development in BASIC and integration with word processing software.  The system was originally developed on the TRS-80 Model 4, it was later converted to run on the IBM-PC.

JUST TECHNICAL ASSOCIATES, INC., Dallas, Texas  (June 1979 - May 1987)

Senior Consultant/Director

One of the original founders of this national consulting firm with over fifty employees and offices in Dallas, Houston and Boston.  Served as a member of the Board of Directors and was actively engaged in consulting assignments.

The following is a list of the consulting engagements while with Just Technical Associates.  Each engagement lists the client as well as the nature of the project.

Prepared the Functional Systems Design specifications for the Micro to Mainframe communications portion of this classified software product.  The document was prepared using a combination of SCRIPT/PC and SCRIPT/VS.

Managed and participated in the project to convert their existing Order Entry system from the SHADOW teleprocessing monitor to CICS Command Level COBOL.  The programs were also converted from conversational to pseudo-conversational logic.  The system consisted of over 180 programs and maps.

Developed the Functional and Detail Design specifications for the Gas Balancing system that included over 1000 pages of documentation.  The system was designed for an IMS DB/DC environment.

Prepared the systems definition document for a Gas Balancing system that included user requirements, high level EDP design, implementation strategies, a detailed project plan, and estimates.

Developed menu driven remote communications system using CROSSTALK XVI on the IBM-PC.  This allowed consultants in the field to create correspondence and transmit it to the central office for letter quality printing.  Also created LOTUS 1.2.3 spreadsheets for time and expense reporting which could be transmitted to expedite client billing.

Analyzed the Decision Support/Information Center area with the goal of reducing workload and improving service.  Recommended establishing a request procedure; implementing resource accounting; and standardizing libraries and naming conventions.  Prepared an inventory of all jobs run by decision support, preliminary standards, and a detailed task plan and estimates to migrate the majority of the recurring jobs to a production of user submission environment.

Performed a variety of systems programming tasks required to bring up their new data center; installed and customized CICS 1.6.1 on an IBM 4341 MVS system using CBIPO and SMP/E. Added CICS Resource Definition Online (RDO) and Recovery/Restart. Installed Environmental Record Editing and Printing program (EREP); and designed and implemented the supporting JCL procedures and job streams. Created USS tables for both SNA/SDLC and BISYNC terminals and printers.

Managed a team that completed a performance analysis of their IBM 3033 MVS system.  The performance analysis covered the areas of MVS tuning, DASD tuning, VSAM tuning and CICS tuning.  Primary responsibility area was CICS tuning.

Participated in a performance analysis of their IBM 3083 MVS system.  The analysis covered the following areas; applications performance, CICS performance and tuning, CICS VSAM performance, DASD utilization, MVS performance and tuning, NCP performance, and VTAM performance.  Primary responsibilities were in the applications and CICS response time analysis.

Maintained CICS 1.6.0 on their IBM 3033 MVS system while their systems programmer was on extended sick leave. Responsibilities included: maintaining CICS tables, performance analysis, and problem determination using OMEGAMON/CICS.  An additional test CICS system was created to support user acceptance testing and ABENDAID/CICS was installed.

Modified an existing JTA CICS Command Level COBOL education course to include PL/I Command Level considerations.  Taught the course to twenty students that consisted of 48 hours of classroom lecture and 15 hours of programming workshop.

Prepared the Programming Functional Specifications for the Data Archive enhancements to PROFS II Professional Office System using Document Creation Facility (DCF) and the Generalized Markup Language (GML) enhancements of SCRIPT/VS.

Designed and developed a CICS Interface system to facilitate migration from their existing in-house TP monitor and network to VTAM/CICS.  The system operated between CICS and the applications, providing access to either network and both CICS and in- house files.  This involved a message interface to translate maps between networks and a database interface to provide access using an in-house access method or CICS VSAM.  An EXCP level task was written to provide the link between the in-house network and CICS.  All interfaces were transparent to the applications so that migration could be accomplished without extensive changes to the application logic.

Evaluated and planned the conversion of the Network Modeling System from HP-3000 FORTRAN to IBM VS FORTRAN on a 3083. The tasks consisted of library setup, JCL creation, FORTRAN source code conversion, ACF2 security, TSO/SPF usage and conversion planning.

Designed and developed an enhancement to the UCC-7 scheduling system that would allow tracking of jobs executed using NJE.  This required a VTAM application that ran on all network CPU's and captured the NJE job's SMF records and routed them back to the submitting host.  This allowed UCC-7 to monitor the status of NJE jobs.

Developed and taught a two week instructional course in the PL/I programming language.  The course consisted of 30 hours classroom lecture, l5 hours of programming workshop, and a l50 page student handout.

Designed, developed, and implemented a Telephone Analysis System to extract and accumulate raw telephone call data received from the Phone Company.  The system consisted of a Telephone Master File maintained online using CICS that carried 24 months of history.  In addition, batch programs that produced a detail listing of all phone calls by extension as well as company and budget center sub-totals.

Selected and installed several IBM-PC's to support office automation.  Evaluated and selected word processing, communications, graphics and financial software.  Installed software on hard disk and created a system of menus to simplify access to the software.

Designed and developed the Batch Sub-systems of the Meter Inventory System which maintains records on over 400,000 instruments in the inventory.  The system was converted from a manual card file to an online CICS display and update.  It consisted of two main VSAM files with two alternate indexes each.  The primary responsibilities were coordinating the design and implementation of the CICS online and the batch update and reporting systems.  Specific duties included user specifications, high level design, file, report and program specifications, implementation, system testing, and problem determination. 

Provided assistance in developing a Data Dictionary Implementation Plan and an Automated Documentation System in conjunction with the SPECTRUM development methodology.  This was in support of a 24 man-year major development project.

Defined, designed, and implemented a CICS data entry/error correction front-end for the InSci Human Resource System. The project involved the complete scope of the project development cycle from functional specifications to implementation and user training.  The system was developed using CICS Command Level COBOL and Screen Definition Facility (SDF).

Designed and developed the IMS DB/DC Customer Order System.  The project started with a feasibility study and progressed through user requirements, functional specifications, program design, programming, unit testing, system testing, and acceptance testing using the SPECTRUM system development methodology.  The system consisted of over 30 online screens that performed the functions of data entry, inquiry, and direct update as well as a batch system to create transactions to update the existing Customer Information Database.  Specific tasks included user-interface to develop specifications, database and system architecture design, programming, testing and implementation support. 

Designed and implemented telecommunications network for remote data entry and report transmission.  Network consisted of five (5) sites with a total of sixteen (16) terminals on both low and high-speed lines.  Specific tasks included network design, vendor, line and modem selection, as well as implementation coordination. 

Provided implementation support for the REACT production control system at a major furniture manufacturing company.  The system consisted of a minicomputer interface to the mainframe customer order system.  It would identify the detailed activities required to manufacture a specific item and create tickets which were input through a wand OCR device to track work-in-progress as well as drive the payroll system.  Specific tasks included design, programming, and implementation of several processors within the system. 

Provided design, implementation, and technical support for database migration from IMS DB/DC to a CICS VSAM environment.  The converted databases consisted of fourteen (14) 3350 spindles of patient billing data which must be reloaded each night to reflect changes made by the batch processing system.  Specific tasks included design and implementation of the conversion programs necessary to create the VSAM files suitable for online inquiry and update.  In addition, the procedures, control, and performance tuning were provided which were necessary to load that amount of data in the limited timeframe. 

Assisted in the creation of a migration plan to convert from a DOS/VS environment to OS/MVS.  Tasks included analysis of alternative approaches, program products, personnel, and costs. 

• Responsible for developing software design and documentation standards for small business microcomputer system implementation, training, education in micro software, quality assurance, and testing. 

• Account management responsibility for design and implementation of integrated small business Oil and Gas Accounting System on the IBM 5110 microcomputer.  This included General Ledger, Accounts Payable, Payroll, Joint Owner Billing, Royalty Distribution System, and Economic Modeling. 

• Evaluation and testing of microcomputer general business packages for small business. 

• Designed and implemented text editing function of TOOL, an online data base application for automatic generation of CRT screen formats. 

• Participated in analysis and preparation of proposal for Management Information and Scheduling System for the International Airport Commission of Saudi Arabia.

• Implemented online data entry applications for Medicaid contracts in four states, making enhancements that resulted in a reduction of the implementation time from four man months to 3/4 man month.

• Implemented Actuarial Calculating and Reporting system for Connecticut General Insurance Company.

• Designed and implemented the accounting interface between the General Accounting System and the Customer Service System at Northeast Utilities; Hartford, Connecticut.  The system consisted of over one hundred fifty program modules written in structured PL/1 and utilized the DL/I data base methodology. 

• Designed and documented the second phase implementation of the Construction Management System involving a Pert Scheduling System that would interface with the existing Estimating and Work Order Accounting Systems.

• Designed the Work Breakdown Structure Cash Flow Processor of the Construction Management System.  This involved the reapportioning of manpower estimates to a non-linear manpower usage curve. 

• Designed and implemented the Interim Scheduling System for the Engineering Department at Northeast Utilities.  It entailed an Input and Output interface with the IBM PMS/IV Scheduling System to minimize the effort required developing construction program networks by utilizing a Standard Network File. 

• Tested and evaluated the IBM PMS/IV Scheduling System for its adaptability to use in the Construction Management System at Northeast Utilities. 

• Assisted students in understanding and grasping programming concepts and assisted the instructor in evaluating student's work. 

• Responsible for interface between the user and EDS Systems Engineers on the implementation of the Regular Business Claims System at United Medical Service (N.Y. Blue Shield).

• Programmer/Analyst - Designed and implemented a system to evaluate and report the condition of the Radar System on the SR-71 Reconnaissance Aircraft.

• Officer-In-Charge - Responsible for daily operation and upgrading of systems related to SR-71 Automatic Navigational Planning and Maintenance Data Processing at a remote overseas operating center. 

• Programmer/Analyst - Responsible for maintaining and upgrading existing subsystems of the Maintenance Data Processing System for the SR-71 Reconnaissance Aircraft.