Kim K. Andregg

3527 Kersey Lane, Sacramento, CA. 95864

916-710-0724 cell

kandregg@raftman.com http://www.raftman.com/

 

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.

 

AREAS OF EXPERIENCE AND QUALIFICATIONS

  Network Security, DMZs, 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:

Adobe Acrobat, Adobe Photoshop, All fusion Erwin Data Modeler, CENT OS, Eclipse IDE, ETL Entity Translation Logic, F5 AAM Application Acceleration Manager, F5 AFM Advanced Firewall Manager, F5 APM Access Policy Manager, F5 ASM Application Security Manager, F5 Big IP load balancers (8900s, F5 Big IP LTM Local Traffic Manager, F5 Big IP TCL, F5 Big IP TMOS, F5 Blades, F5 DNS Domain Name Services, F5 Routing, F5 SDN Software Defined Network, F5 Viprion, F5 Viprions, Federal Enterprise Architecture, Hewlett Packard Onboard Administrator, HP Blade and Dell servers. HTML, HTTP, HTTPS, Java, JavaScript, Juniper VPN, Microsoft Access, Microsoft Active Directory, Microsoft ASP, Microsoft C# Sharp, Microsoft CDO Collaboration Data Objects, Microsoft Component Services, Microsoft DDNS, Microsoft DHCP, Microsoft DNS, Microsoft Excel, Microsoft Excel, Microsoft Exchange Server, Microsoft FrontPage, Microsoft FTP Server, Microsoft Hyper-V Server, Microsoft Internet Security Administrator, Microsoft MAPI, Microsoft Net Framework, Microsoft ODBC, Microsoft OLAP, Microsoft OLE, Microsoft Outlook, Microsoft Power Shell, Microsoft PowerPoint, Microsoft Project, Microsoft SQL Server 2014 Transact SQL, Microsoft SQL Server 2014, Microsoft SQL Server Reporting Services, Microsoft SQL Server SSIS DTS, Microsoft SQL Server Stored Procedures, Microsoft SQL Server Triggers, Microsoft TCP/IP, Microsoft Team Foundation Services, Microsoft Transact SQL, Microsoft Virtual Servers, Microsoft Visio, Microsoft Visual Basic, Microsoft Visual C++, Microsoft Visual Safe Source, Microsoft Visual Studio Net, Microsoft Windows Media Services, Microsoft Word, NNTP, Oracle, POP3, Radiant Logic Virtual Directory, Red Hat OS, RSA SecurID authentication manager, SMTP, SOA Service Oriented Architecture, SOAP Simple Object Access Protocol, Susie OS, Symantec Corporate Anti-Virus, Telnet, Trend Micro, VM Ware Workstation, VMWare ESX servers, VMWare, VPN, WAN, Windows Web / IIS Encryption via Secure Socket Layer, XML, Cognos Business Intelligence, Cognos Connection Manager, Cognos Framework Manager, Cognos Power play, Cognos Report Net, Cognos Report Net, Crystal Reports, DCL Data Control Language, DCOM, DDL Data Definition Language, DHTML, DML Data Manipulation Language, IBM DB2, QMF, IBM SQL, CICS, CICS Command Level, IBM Assembly, COBOL, Basic, Pascal, C, C++, Fortran, TSO, TSO Clist/ISPF, JCL, Adabas, Natural, Predict, Pac, Construct, Adasql, IDCAMS, ESP, Platinum, SAR, VSAM, ISAM, VTAM, ACF2, RACF, Endeavor, Panvalet, IOF, SDF, Fileaide, Extra, Syncsort,

 

 

EDUCATION:

 

California State University, Sacramento

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

 

EXPERIENCE:

 

System Software Specialist (Technical) II Department of Water Resources 3-12 to Present

Network Engineer, Data Base Administrator, and Web Developer: Performed network administration functions in a Windows 2008 R2 environment. Installed and maintained Microsoft Share Point 2010, SQL Server 2008 R2, Visual Studio 2010 and other software tools to support the DWR Share Point environments (development, test, and production). Performed Share Point administration functions (Application Management, Monitoring, Security, General Application Settings, System Settings, Manage servers in the farm, Backup and Restore, Upgrade and Migration, Testing and Regression Testing) for the Share Point environments. Produced unit, system, and production documentation for the DWR Share Point environments. The DWR Share Point environment was an N-Tier / 3 Tier environments (Web, Application, and Data). Built and maintained Microsoft SQL Server clusters in a VM Ware environment. Built and maintained a Project / Share Point environments in a VM Ware environment. Designed, built, and deployed F5 Big IP load balancers (8900s, Viprions, Blades), F5 Big IP TCL, F5 Big IP TMOS, F5 Big IP LTM Local Traffic Manager, F5 DNS Domain Name Services, F5 AAM Application Acceleration Manager, F5 AFM Advanced Firewall Manager, F5 SDN Software Defined Network, F5 Routing, F5 APM Access Policy Manager, F5 ASM Application Security Manager. Built and maintained RSA SecurID authentication manager and associated connections for two factor authentication version 8.1. Built CentOS Unix workstation, installed and configured VM Ware workstation for UNIX and Windows, installed and configured Windows OS inside a virtual machine running on the CentOS Unix workstation. Built a Share Point test environment (Share Point Enterprise 2010, Share Point Designer, Share Point Workstation, SQL Server Enterprise 2008 R2, Visual Studio 2010). Designed and built and secure network edge communications between edge appliances and inner networks DMZs (transition and inspection). Designed and built secure communication using packet level inspection, URL filtering, and content inspection. This was a Unix (CentOS, Red Hat), Microsoft Windows Server, Microsoft Share Point Enterprise 2010, Microsoft Share Point Designer, Microsoft Share Point Workstation, Microsoft SQL Server Enterprise 2014 R2, Microsoft Visual Studio 2014, Microsoft .Net, Microsoft VB.Net, LAN, WAN, Java, JavaScript, Microsoft VB script, Microsoft Visual Studio Team Foundation System, VMWare, ESX, Hewlett Packard C7000 enclosures Blade and Dell servers, F5 Big IP load balancers, Cisco, EMC SAN, Radiant Logic Virtual Directory.

 

Staff Information Systems Analyst State of California Victim Compensation & Government Claims Board 5-08 to 3-12

Network Engineer and Data Base Administrator: Performed network administration functions in a Windows 2003 / 2008 environment. Installed and maintained network equipment, core, access, and fiber switches Cisco and HP Procurve, VPN's, SonicWALL firewalls, F5 Big IP load balancers, PDU's and other associated network equipment. Performed data base administration and support functions for SQL server 2005 / 2008 applications. VCGCB has numerous SQL Server 2005 / 2008 applications, Web based, small and large. Performed database performance tuning, monitoring, database backup and restore, database maintenance, migration, upgrades (2005 to 2008) and security functions. Designed and installed Windows SQL server clustered database environments. Designed and developed new database schemes and other development functions. Designed, developed, and implemented Visual Studio Team Foundation System Database edition. Installed, configured, and managed Windows 2003 / 2008 Enterprise server environments (Active Directory, DNS, DHCP, FTP, IIS, etc.). Designed and performed Windows 2003 / 2008 Enterprise server installation, OS backup / restore / disaster recovery plans, maintenance and procedures. This was a Microsoft Windows Server, SQL Server, .Net, VB.Net, LAN, WAN, Java, JavaScript, VB script, Visual Studio Team Foundation System, VMWare, ESX, Hewlett Packard Blade and Dell servers, F5 Big IP load balancers, Sonic Wall, Cisco, EMC SAN, Kofax, Right Fax, Kentrox environment.

 

Staff Programmer Analyst State of California Office of Systems Integration 11-05 to 5-08

Performed project lead functions for the Cognos Business Intelligence software proof of concept project. Cognos proof of concept involved building a data mart, data warehouse, reports, analysis and administrative functions using Cognos Report Net, Framework Manager, Connection Manager and other Cognos tools. Performed SQL Server DBA design, installation and maintenance functions for the Cognos project. Welfare Data Tracking Implementation Project (WDTIP), responsibilities included DB2 DBA, database migration implementation and planning from DB2 version 7 to 8, and CICs system and application programming. Maintained WDTIP interfaces to MEDS, EDD, EBT, Statewide Client Index, CDSS, counties and other Federal agencies. This was a Microsoft Windows Server, SQL Server, .Net, VB.Net, LAN, WAN, Java, JavaScript, VB script, Erwin Data Modeler, Cognos, MVS/ESA, DB2, CICS, CICS Command Level, Cobol II, VSAM, and TSO environment.

 

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.

 

System Analyst Consultant, 8-00 to 1-01

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 California Contractors State License Board 9-99 to 1-00

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 Calif. 6-98 to 5-99

Transformation 2000 Department of Health Services State of California

Performed 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 CAL and CAB (Cost, Accounting and Billing) systems. Designed, developed, constructed, and executed test specifications, plans and scripts for CAL and CAB. Execution and planning of (system tests, stress tests, and acceptance tests). Designed and developed enhancements to CAL and CAB for year 2000 compliance. This was a MVS/ESA, CICS, CICS Command Level, Cobol II, VSAM, TSO, DB2, Adabas, Natural, Construct and Predict environment.

 

Systems Analyst Computer Resources Group Consultant Secretary of State Calif. 12-97 to 5-98

Semi-Official Canvas System, Secretary of State California

Performed 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 California counties. Performed and evaluated regression tests, incident and problem tracking. These functions encompassed the following: Construction of the QA Strategic Plan and Scope Statement for election 98; Construction and execution of test plans, test scripts and test, data (for both the mainframe legacy and the Internet reporting system); Execution and planning of (system tests, stress tests, and acceptance tests); Analysis of existing legacy and Internet reporting system. This was a MVS/ESA, CICS, CICS Command Level, Cobol II, VSAM, TSO, Adabas, Natural, Construct and Predict environment.

 

Systems Analyst Visionary Integration Professionals Inc. Consultant Board of Equalization State of Calif. 5-97 to 12-97

Integrated Revenue Information System, Board of Equalization, State of California

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

Welfare Intercept System (WIS) Social Services State of California

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 Equalization State of Calif. 6-95 to 9-96

Integrated Revenue Information System, Board of Equalization, State of California

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.

 

Payroll Conversion

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

 

MECCA

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 Topeka Santa Fe Railroad 11‑90 to 2‑91

 

Waybill System

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 Cincinnati Bell Information Systems 5‑90 to 6‑90

 

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

 

Department of Transportation State of Washington

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.

 

Department of Natural Resources State of Washington

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

 

Teal Data Center

Supply Ordering System and Dedicated Resources Billing System

Designed, developed and implemented an integrated Supply Ordering System for Teale Data Center to manage the equipment and materials ordering for Teals main warehouse. Designed, developed and implemented the Dedicated Resource Billing System for Teal Data Centers accounting. Dedicated Resource billing accounts for 40% 6.5 million of Teal monthly billing. Performed data modeling and design using a relational database approach. Performed Predict data dictionary administration functions. This was a MVS/XA, TSO, CICS, CICS Command Level, Cobol, Adabas, Natural, Predict and Execrator.

 

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.

 

References:

 

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

California State Lottery

Data Processing Manager III

 

Ben Beasley - 822-8533

California State Lottery

Data Processing Manager II