Kim K. Andregg
916 481-7049 Residence 916-812-3286 cell
kandregg@raftman.com http://www.raftman.com/
Computer consultant
with 20 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 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 MAINFRAME, PC
and LAN Servers (Dell, Compaq, IBM, Hewlett Packard, Clones)
SOFTWARE OPERATING SYSTEMS: MVS/XA/ESA, Unix,
Microsoft Windows NT 4.0 Workstation, NT 4.0 Server, Microsoft Windows 2000 Professional, Server, Advanced Server,
Windows 2003 Standard, Enterprise, Datacenter, Web Server Editions
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 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.
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 2000 (MCP)
Microsoft Certified System Engineer
(MCSE Windows 2000) MCP #1471830
Microsoft Solutions Developer Network
MSDN
EXPERIENCE:
Staff Information Systems Analyst State
of California Victim Compensation & Government Claims Board 5-08 to Present
Performed data base adminstration
and support functions for various applications for VCGCB. VCGCB has numerous SQL Server 2000 / 2005
applications, Web based, small and large.
Performed database performance tuning, monitoring, database backup and restore, database maintenance
functions, SQL Server security function, etc.
Designed and developed new database schemes and other development
functions. Designed, developed, and implemented
Visual Studio Team Foundation System Database edition. This was a Microsoft
Windows Server, SQL Server, .Net, VB.Net, LAN, WAN, Java, JavaScript, VB
script, Visual Studio Team Foundation System 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. Welfare Data Tracking
Implementation Project (WDTIP), responsibilities included DB2 DBA, database
migration implementation and planning from DB2 verison
7 to 8, and programming. 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 2000 Advanced LAN servers / 2003 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 2000 / 2003 Enterprise Servers, Internet Information
Server, Exchange 2000 mail server, Access 2000 and SQL server 2000, ODBC
connections, Windows Media services, and other media software). Managing the Windows 2000 / 2003 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 2000, SQL server 2000, 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, 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
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 Knowledgeware, 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 Datapoint 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:
Richard Keene
(916) 653-7259
Employment Development Department
CEA
Department
of Consumer Affairs Medical Board
Senior
Staff System Analyst
916-263-2422
Department
of Consumer Affairs Medical Board
Data
Processing Manager
916-263-6181