Kim K. Andregg
916 359-8390 Residence
916-710-0724 cell
kandregg@raftman.com http://www.raftman.com/
Computer consultant
with over 25 years of experience in government and private industry
(Government, Natural gas, Railroad, Information Services, Real Estate,
Telecommunications, Wood Products, Aircraft and Paper Manufacturing). Strong emphasis on accounting systems in
government and private industry.
§ 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, Warnier-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 SYSTEMS: MVS/XA/ESA, ESX
Unix, Linux, Microsoft Windows 2003 / 2008
Standard, Enterprise, Datacenter, Web Server Editions, Clustered Servers.
SOFTWARE LANGUAGES, ETC:
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,
Oracle, MS Active Directory, MS Internet
Security Administrator, MS OLAP, MS DHCP, MS DNS, MS DDNS, MS TCP/IP, MS FTP
Server, MS Exchange Server, MS SQL Server 2000 / 2005, MS Transact SQL,
MS Component Services, MS ODBC, MS OLE, MS Internet Server IIS, MS Visual Basic
/ ASP, Java, Javascript, MS Visual Interdev, MS Power
Shell, MS Visual C++, MS Visual Safe Source, MS Word, MS Excel, MS PowerPoint,
MS Access, MS FrontPage, MS Windows Media
Services, HTML, XML, DHTML, VPN,
HTTP, HTTPS, DCOM, TELNET, WAN, Adobe Photoshop, Adobe Acrobat, Visio, Visual
Studio Net, VB.Net, MS C# Sharp, Microsoft
Net Framework, Crystal Reports, SQL Server DTS, SQL Server Stored Procedures,
SQL Server Triggers, SOAP Simple Object Access Protocol, Windows Web / IIS
Encryption via Secure Socket Layer, NNTP, SMTP, POP3, MS CDO Collaboration Data
Objects, MS MAPI, MS Outlook, Symantec Corporate Anti Virus, MS SQL Server Reporting Services, MS Visio, MS
Project, Allfusion Erwin Data Modeler, Cognos Report Net, Cognos Report
Net, Cognos Framework Manager, Cognos
Connection Manager, Cognos Powerplay,
Cognos Series 8 Business Intelligence, ETL Entity
Translation Logic, DDL Data Definition Language, DML Data Manipulation
Language, DCL Data Control Language, Federal Enterprise Architecture, TFS
Visual Studio Team Foundation System, SOA Service Oriented Architecture, VM
Ware, MS Hyper-V Server, MS Virtual Servers, ESX servers, Hewlett Packard
Onboard Administrator, HP Blade and Dell servers.
EDUCATION:
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
MSDN
EXPERIENCE:
System Software Specialist (Technical)
II Department of Water Resources 3-12 to Present
Network Engineer, Data Base
Administrator, 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-Teir / 3 Teir environment (Web,
Application, Data). Built CentOS Unix workstation, installed and configured VM Ware
workstation 8 for Unix, installed and configured Windows 7 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).
This was a Unix (CentOS, Red Hat), Microsoft Windows Server, Share Point
Enterprise 2010, Share Point Designer, Share Point Workstation, SQL Server
Enterprise 2008 R2, Visual Studio 2010, .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, Cisco, EMC SAN.
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 verison
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 SoftMatrix
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 a Internet / Web, Visual
Basic, VB Script, ASP, Java Script, IIS, Windows 2000 server, SQL Server 7.0 /
2000, Outlook, and Exchange environment.
Systems Analyst NetIncomm 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
Transformation 2000
Department of
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
Systems Analyst Computer Resources
Group Consultant Secretary of State Calif. 12-97 to 5-98
Semi-Official Canvas
System, Secretary of State
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
Systems Analyst Visionary Integration
Professionals Inc. Consultant Board of
Integrated Revenue
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
Welfare Intercept
System (
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
Integrated Revenue
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, IMS, IMS, 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
Production support
for MECCA (Multiplex Engineering Control Center Activity) and Network
Management Systems. Performed
maintenance and enhancement of CICS and Natural online and batch programs. 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 systems 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 systems to the corporate
accounting system. This was a MVS/ESA,
DB2, QMF, CICS, CICS Command Level, Cobol II, Cobol, TSO, VM/CP/CMS, 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 systems 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
Waybill System
Analyzed, designed
and developed programs for the Waybill subsystem. Developed program specification for Waybill,
Bill of Lading and Repetitive Waybills.
Developed file utility programs for DB2 and Predict file
maintenance. This was a MVS/ESA, TSO,
IMS/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 programs 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
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
subsystems 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
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 systems.
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/CMS
and LAN based application. Designed and
developed interfaces between token ring LAN to VM/CMS 9370 to MVS 3090. Implemented file transfer programs 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 systems. 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/CMS, PC and IBM LAN
environment.
Systems Analyst ‑ Hornet
Foundation Contract 11‑85 to 1‑87
Supply Ordering
System and Dedicated Resources Billing System
Designed,
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 systems for the administrative
unit. This was a MVS/XA, TSO, CICS, CICS
Command Level, Excelerator, IDMS, Cobol
environment.
References:
Patrick Slesicki 214-2756
Victums Compensation and Goverments Claims 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