Kim K. Andregg
Computer consultant with over 30 years of experience in government and private industry (Government, Natural gas, Railroad, Information Services, Real Estate, Telecommunications, Wood Products, Aircraft and Paper Manufacturing). I have a strong emphasis on accounting and network systems and security in government and private industry.
§ Network Security, DMZ’s, Network Edge Security, and Edge to Inner Network Communications, Traffic Transition and Encryption, Inspection (packet inspection, URL and content filtering) and Auditing.
§ Network Security Policy and Design
§ Object Oriented Analysis and Design, Functional Decomposition and Analysis, Client Server
§ Systems Analysis, Design and Structured Programming, JAD / RAD Design
§ Database Design, Data Modeling, Process Modeling, Relational Database Approach, n-tier architecture, data mart, and data warehouse construction, Service Oriented Architecture (SOA).
§ Software Engineering Methodologies and Case Tools, Entity Relationship, Warner-Orr, Yourdon
§ Quality Assurance, Control and Testing / Regression for Systems Development and Reporting, Independent Validation and Verification, Use Case analysis, test script planning
§ Applications Systems Management, End User Training
§ Technical lead, project lead, database administrator DBA and Software Enterprise Architect / Engineer
§ Web site design and development
§ Accounts Receivable, Payable, Financial Distribution, Payroll and Reporting, General Ledger, Journal Voucher Entry, Financial Reporting and Forecasting
§ Telecommunications Systems, Wood Products and Paper Manufacturing, Waybill, Bill of Lading, Hazardous Materials and Freight Bill, Natural Gas Accounting, Government Reporting and Accounting systems
§ Production of Project Scope Statements, Project Proposals, Project Management Plans, System Software Requirement Definitions, Functional Requirements, External and Internal Design plans, Design Specifications, Test Specification and Plans, Maintenance Manuals, User Manuals and Project Reporting Plans, Requests for Proposals and Requests for Quotations, Implementation, Migration and Data Conversion Plans, RFP's, RFO's, RFQ's, RFI's.
HARDWARE: IBM, PC and LAN Servers (Dell, Compaq, IBM, Hewlett Packard, Clones), Hewlett Packard Blade Servers
SOFTWARE OPERATING Microsoft: MVS/XA/ESA, ESX Unix, Linux, Cent OS, Redhat OS, Susie OS, Microsoft Windows Standard, Enterprise, Datacenter, Web Server Editions, Clustered Servers.
SOFTWARE LANGUAGES, ETC:
Major: Computer Science, Minor: Business Administration
Over 140 units completed, I have one course to complete my Bachelor of Science
Concentrations: System Software, Software Engineering, CAD/CAM Computer Graphics
Microsoft Certified Professional Windows 2003 (MCP)
Microsoft Certified System Engineer (MCSE Windows 2000) MCP #1471830
Microsoft Solutions Developer Network
System Software Specialist (Technical) II Department of Water Resources 3-12 to Present
Staff Information Systems Analyst State of California Victim Compensation & Government Claims Board 5-08 to 3-12
Staff Programmer Analyst State of California Office of Systems Integration 11-05 to 5-08
Systems Analyst / Project Lead Consultant to the California State Department of Consumer Affairs Medical Board 4-03 to 10-05
Performed analysis, design, construction, and implementation of new functionality for the Medical Board Consumer Affairs System (CAS). Implemented AB 1586 Physician Survey report system and SB 1950 Quality of Care enhancement to CAS. Performed programming, debugging, testing, test data construction, implementation, and production planning for AB 1586 and SB1950. This was a Microsoft Windows 2000, SQL Server, VB.Net, Microsoft Access, LAN, MVS/ESA, CICS, CICS Command Level, Cobol II, VSAM, TSO, Adabas, Natural, and Predict environment.
Professional Services: Systems Analyst / Network Administrator / Web Developer January 1997 to present.
Managed Windows 2003 / 2008 Advanced LAN servers / 2003 / 2008 Enterprise Servers for web site services and web development. Web servers served both non-profit and profit web sites. Web sites included development and maintenance of (Windows 2003 / 2008 Enterprise Servers, Domain Controllers, Internet Information Server, Exchange 2010 mail server, Access and SQL server 2005 / 2008, ODBC connections, Windows Media services, and other media software). Managing the Windows 2003 / 2008 LAN servers includes installation, maintenance, backup, recovery, routers, hubs, TCP/IP setup and troubleshooting system software. The development environment consisted of Visual Basic, VB script, Java Script, Microsoft ADO, Access, SQL server 2005 / 2008, ODBC connections, Visio, Visual Studio .Net, VB.Net, C# Sharp, Microsoft Net Framework, Crystal Reports, FrontPage and other windows based software. Example web sites include (wgmoore.org, donnerrails.com, pugman.com, raftman.com, willthegeek.com).
Systems Analyst / DBA – Soft Matrix Inc. Consultant to the Hewlett-Packard 5-02 to 3-03
Performed analysis and design of new functionality for the Passkey Pro-Active Engineering support system (Customer Relationship Management package). Performed programming Visual Basic, VS Net, ASP and Web site development and maintenance, SQL Server stored procedures, jobs, data transformation packages, SQL Server DBA support tasks, Windows 2000 server management, Internet Information server installation and management, for the Passkey system. This was an Internet / Web, Visual Basic, VB Script, ASP, Java Script, IIS, Windows 2000 server, SQL Server 7.0 / 2000, Outlook, and Exchange environment.
Systems Analyst – Netcom Inc. Consultant to the California State Department of Consumer Affairs 2-00 to 7-01
Performed analysis and design of new functionality and maintenance programming, DBA (database administrator Adabas and VSAM), CICS administration, RACF administration, debugging, testing, and enhancement on CAS Consumer Affairs and the BAR Bureau of Automotive Repair systems. Performed analyses, design, construction, testing, and implementation of SB-240 Child Support Enforcement program at Department of Consumer Affairs for the BAR (Bureau of Automotive Repair) and the CAS (Consumer Affairs Professional Licensing System). This was a MVS/ESA, CICS, CICS Command Level, Cobol II, VSAM, TSO, Adabas, Natural, and Predict environment.
Assisted in developing web site for the Caltrans State Highway Projects Knowledge Base. This is an Access database on the Caltrans Intranet. The program was developed using Macromedia Ultradev and Fireworks. The client-server system utilizes ASP and FrontPage extensions to control flow in the Wizard portion and DHTML written in Java-Script to handle interactive sections of the Knowledge Base. The remainder is done in VBScript.
Project Manager / Project Lead /
Systems Analyst – Manpower Technical Services Consultant to the
Performed quality control, assurance, testing, IVV, and Y2K compliance functions for Licensing, Pending Applications, Complaint / Enforcement, Cashiering, System Tables for the Contractors State License Board. Designed, developed, constructed, and executed test specifications, plans and scripts for CSLB systems. Execution and planning of (system tests, stress tests, and acceptance tests). Produces Y2K related deliverables and documentation (analysis, implementation, data conversion, testing, external interfaces, and Independent verification and validation section of the project). Responsibilities included hiring and managing both contract and state personal. This was a MVS/ESA, CICS, CICS Command Level, COBOL, VSAM, TSO, DB2, Adabas, Natural, Construct and Predict environment.
Systems Analyst – Computer Resources
Group Consultant to IBM / Department of Health Services State of
system support DBA (database administrator DB2, Adabas and VSAM), and CICS
administrator for DB2 and CICS. Performed
DB2 subsystem and CICS region setups, maintenance and initialization
tasks. Performed quality control,
assurance and testing functions for MEDS Medi Cal system. Performed quality control, assurance and
testing functions for the
Systems Analyst – Computer Resources Group Consultant Secretary of State Calif. 12-97 to 5-98
System, Secretary of State
quality control, assurance and testing functions for the SOC system. Designed,
developed, constructed, and executed test specifications, plans and scripts for
SOC project deliverables. Designed,
developed and constructed base line data for full scale test scenarios of the
SOC and interfaces to 58
Systems Analyst – Visionary Integration
Professionals Inc. Consultant Board of
Information System, Board of Equalization, State of
Performed quality control, assurance and contract validation functions for the IRIS project. Designed, developed, constructed, and executed test specifications and plans for IRIS project deliverables. Performed and evaluated regression tests, incident and problem tracking. This was a MVS/ESA, CICS, CICS Command Level, Cobol II, CICS, VSAM, TSO, Adabas, Natural, Construct and Predict environment.
Systems Analyst - Dapru Inc. Consultant Calif. Dept. of Social Services 10-96 to 5-97
Designed, developed and constructed the Welfare Intercept System (WIS). Performed DBA (database administrator Adabas). This was a MVS/ESA, CICS, CICS Command Level, Cobol II, CICS, VSAM, TSO, Adabas, Natural, Construct and Predict environment.
Systems Analyst - Software A.G./ Dapru
Inc. Consultant Board of
Information System, Board of Equalization, State of
Designed, developed and constructed the Assignment Control System, Workflow and Tax Calendar System. This was a MVS/ESA, CICS, CICS Command Level, Cobol II, CICS, VSAM, TSO, Adabas, Natural, Construct and Predict environment.
Systems Analyst - Pro Tech Systems Consultant Federal Express 2-94 to 5-95
MAXI MERLIN MACH Maintenance Aircraft Control System
Performed enhancements, conversion and implementation of the MAXI MERLIN MACH Maintenance Aircraft Control System. Designed and developed the Engine Monitoring and Engine Oil subsystem of MACH. Designed and developed the ACARS interface. This was a MVS/ESA, CICS, CICS Command Level, Cobol II, Microsoft, DB/DC, VSAM, TSO, Adabas, Natural, Construct and Predict environment.
Systems Analyst - Datamasters Inc. Contract Consultant RJ Reynolds Corp. 3-93 to 2-94
Budget System Manufacturing
Designed and developed a budgeting system for plants. The budget system feed the operations finance unit and interfaced to the corporate general ledger. Performed DBA (database administrator for Adabas and VSAM). This was a MVS/ESA, CICS, CICS Command Level, Cobol II, VSAM, TSO, DB2, Adabas, ADASQL, Natural, Construct and Predict environment.
Designed and developed interfaces for a conversion from a Natural / Adabase to a Tesseract Cobol DB2 payroll system. This was a MVS/ESA, CICS, CICS Command Level, Cobol II, VSAM, TSO, DB2, Adabas, ADASQL, Natural, Construct and Predict environment.
Programmer Analyst - IMI Software Services Inc. Contract Consultant MCI Corp. 11-92 2-93
Production support for MECCA (Multiplex Engineering Control Center Activity) and Network Management Systems. Performed maintenance and enhancement of CICS and Natural online and batch prograMicrosoft. This was a MVS/ESA, CICS, CICS Command Level, Cobol II, VSAM, TSO, Adabas, ADASQL, Natural and Predict environment.
Systems Analyst - Computer People Inc. Contract Consultant Weyerhaeuser Corp. 6-92 to 9-92
General Ledger Integration Project
Production of design and feasibility study for integration of remote site general ledger systeMicrosoft to a corporate center Dun and Bradstreet Millenium general ledger system. The design specification encompassed a feasibility study for 1) re-engineering; 2) replacing; 3) integrating remote site accounting systeMicrosoft to the corporate accounting system. This was a MVS/ESA, DB2, QMF, CICS, CICS Command Level, Cobol II, Cobol, TSO, VM/CP/CMicrosoft, DOS/VSE, PC, Microsoft Lanmanager and System Architect environment.
Systems Analyst - Software Resources Contract Consultant Simpson Paper Co. 10-91 to 3-92
Commitment Accounting System
Designed and developed account tracking system for Project, Work Order, Estimate to Complete, Cost Notes, Commitment Activity, Procurement Activity, Equipment Delivery, Project Closure and Reporting and online adhoc Inquiry. Designed and developed System Administration functions for Codes Tables, Security Administration and Feeder Systems Maintenance. Produced External and Internal design documentation and specifications. Performed analysis, data modeling using relational methodology, data dictionary and programming functions for the CAS system. This was a MVS/ESA, DB2, QMF, CICS, Command Level, Cobol II, TSO, Execrator, PC / LAN, Adabas, Natural and Predict environment.
Systems Analyst ‑ Price Waterhouse / Synergic Systems Contract Consultant Dept. of Rehabilitation 3‑91 to 10‑91
Field Computer System
Designed and developed Client Tracking, Equipment Inventory and Purchases, Financial Status, Award Status, Client Status, Client Open and Closure functions. Implemented Document Management Facility, Text Retrieval System. Developed e-mail and existing accounting systeMicrosoft interfaces. Developed a Codes System for Medical, Department of Education and miscellaneous federal, state and local codes. Performed CICS tuning and thread utilization. Performed Adabas and Natural tuning and thread utilization. Performed Predict (data dictionary) administration and database design (logical and physical modeling) relational database approach. Performed DBA (database administrator for Adabas and VSAM). This was a MVS/ESA, CICS, CICS Command Level, Cobol II, TSO, Execrator, Adabas, Natural and Predict environment.
Systems Analyst ‑ IBM/MTW
Corporation Contract Consultant to Atkinson
Analyzed, designed and developed prograMicrosoft for the Waybill subsystem. Developed program specification for Waybill, Bill of Lading and Repetitive Waybills. Developed file utility prograMicrosoft for DB2 and Predict file maintenance. This was a MVS/ESA, TSO, IMicrosoft/DC, DB2, QMF, Execrator, Adabas, Natural and Predict environment.
Systems Analyst ‑ Software Resources Inc. Contract Consultant Arkla Gas Inc 7‑90 to 11‑90
Gas Information System Back Period Adjustments
Designed and developed program specification for volume receipt allocations of purchase and transportation contracts with emphasis on roll up of back period adjustments. This was a MVS, TSO, CICS, and CICS Command Level, Cobol II, Adabas, Natural and Predict environment.
Systems Analyst ‑ Interwest Systems Inc. Contract Consultant
Pager Communication Accounting
Designed and developed prograMicrosoft for the Comptech Management System for RCCs (Radio Common Carrier). Performed custom modification and tailoring of program reports and accounting methods for new and existing client installations. This was an ATT UNIX System V, C, Micro Focus Cobol environment.
Systems Analyst ‑ Pro Data Inc. Contract Consultant 6‑88 to 5‑90
Transportation State of
Marine Payroll System
Conversion of existing payroll system to an Adabas / Natural / Cobol environment. Designed and developed payroll forecasting subsystem and retroactive pay system. Designed and developed program specifications for calculation of labor cost rates for the Marine Labor System. Completed 19 program modules for other subsysteMicrosoft of the Marine Labor System. This was a MVS, TSO, CICS, CICS Command Level, Cobol II, Telon, Design Aide, PC / LAN, Adabas, Natural and Predict environment.
Natural Resources State of
Revenue Management System
Installation of American Software Institutes Accounts Receivable, Customer Order Processing and Queued Order Entry system. Performed custom modifications and tailoring of AR and COPS for client sites CICS, ACF2, VTAM and Adabas / Natural / Predict environment. Designed and developed Adabas, Natural and Predict interfaces to ASI products. Designed and developed interfaces from ASI products to client sites existing contract and financial systeMicrosoft. Performed DBA (database administrator for Adabas and VSAM). This was a MVS, TSO, CICS, CICS Command Level, Cobol, Cobol II, VSAM, IEW Knowledge ware, PC / LAN, Adabas, Natural and Predict environment.
Systems Analyst ‑ California Community Colleges Chancellors Office 2‑87 to 5‑88
LAN Installation, Conversion and Interface Project
Performed purchasing and installation of hardware file servers, diskless and non-diskless workstations and laser printers. Performed conversion of Data point applications to IBM 9370 VM/CP/CMicrosoft and LAN based application. Designed and developed interfaces between token ring LAN to VM/CMicrosoft 9370 to MVS 3090. Implemented file transfer prograMicrosoft and methods with Rexx execs, TSO ISPF panels and TSO clists. Conversion of Mail Correspondence database to PC LAN environment. Designed and developed modifications to Student Tracking, Financial accounting and Revenue distribution systeMicrosoft. Installed and implemented database, spreadsheet and word processing packages on a large IBM Token Ring LAN and host system configuration. This was a MVS/XA, TSO, CICS, and CICS Command Level, Cobol II, VM/CP/CMicrosoft, PC and IBM LAN environment.
Systems Analyst ‑ Hornet Foundation Contract 11‑85 to 1‑87
Supply Ordering System and Dedicated Resources Billing System
developed and implemented an integrated Supply Ordering System for
State Teachers Retirement System
Manual Tracking System
Designed and developed a manual tracking system. Designed and developed several small database systeMicrosoft for the administrative unit. This was a MVS/XA, TSO, CICS, CICS Command Level, Excelerator, IDMicrosoft, Cobol environment.
Patrick Slesicki – 214-2756
VictuMicrosoft Compensation and Goverments ClaiMicrosoft Board
Data Processing Manager II
Jess English – 431-4251
Office of Technology Services
Senior Information Systems Analyst
Lina Luna-Pruitt - 822-8530
Data Processing Manager III
Ben Beasley - 822-8533
Data Processing Manager II