Karina Jones       [Send email to request phone number] 33-6130	[Send email using form at bottom]

Database Analyst / Integrator – CROPP/Organic Valley Cooperative
Responsible for an Integrated Sales Management System – Demantra Spectrum using
an Oracle database. Writing PL/SQL procedures to support and enhance
functionality. Creation, Backup, and Restore of SQL Server databases. Writing,
Scheduling, and Running SQL Server Agent jobs. Integration of systems using
Business Objects Data Integrator. Transforms used: Query, Map, Date Generation,
Merge, Validation. Working closely with business partners to gather requirements
for projects. Toad.
	June 2007 – present

Programmer/Analyst – Cuna Mutual Insurance Company, Inc., Madison WI
Member of a four-person support team with support rotation and project work.
Tight deadlines. Analysis, coding, and support for the Members Marketing
Department. Support of purchased selection tool Utica’s Affine Campaign. Writing
SQL Server stored procedures, creating tables, views, indexes, functions. Writing
windows command files to integrate SQL Server tools like BCP and DTS, and command
line executables with Affinium Campaign. Some performance tuning. Documentation
of procedures and relaying of technical information to business area. Write and
analyze code in SAS, COBOL, DB2, some Visual Basic. JCL, MVS, JES2, SYNCSORT,
TSO.
Product support for a purchased content management system (Document Science’s
xPression).  
	August 1999 – June 2007

Contracted Programmer/Analyst – Advanced Business Systems, Inc. placed at
Wisconsin Department of Transportation. Part of a Y2K project team. Worked under
extremely tight deadlines and detailed methodology of analysis, coding, unit,
system, and user testing, and implementation. Analyzed and modified code in
Assembler,  COBOL, Fortran, and a proprietary database Filehandler. DB2. 	Feb
1998 - May 1999

Contracted Programmer/Analyst – Interactive Business Systems, Inc. placed at
Lands’ End, Dodgeville, WI. Write code for a financial department using COBOL,
Easytrieve, some Oracle.	
	Feb 1997 – Feb 1998

Programmer/Analyst – America Family Mutual Insurance Company
Write and maintain code in COBOL, FOCUS, QuikJob, and Assembler in an MVS
mainframe environment. Proficient in JCL, TSO/ISPF, SDSF, FileAid, Xpediter.
Analyze and create requirements documents, authorizations, and test plans.
Project team work.
	Jun 1995 – Feb 1997 

Security Administrator – America Family Mutual Insurance Company
Responsible for security the mainframe computer environment using CA-Top Secret,
support security policies, maintain security tables, process security access
request, problem resolution , document procedures, monitor security violations
and security reports.	Jan 1994 – Jun 1995

Office Manager and Bookkeeper – TDS Custom Construction Inc.
Data entry, A/P, A/R. checkbook and bank reconciliation, payroll and payroll tax
reporting, responsible for bank deposits, ordering, collection. Use MacP&L
(Accountant, Inc.), Excel, Microsoft Word, and ACCPAC general ledger on a
Macintosh IIsi.	
	Jul 1992 – Jan 1994

Editorial Assistant – American Sociological Review, UW-Madison
Performed office procedures in the absence of the Managing Editor; desktop
publishing; database management; correspondence; prepared text for publication,
responsible for budgeting; created and modified graphics.	Jan 1992 – Jul 1993

Program Assistant – Perinatal Substance Abuse Project, US-Madison
Coded and entered data in SPSS. Created county reports.	Jan 1992 – Jun 1993

Bookkeeper – Serendipity, Inc.
Financial statement preparation, bank reconciliation, double-entry accounting,
and sales tax reporting. Developed a customized accounting system.	Jan 1990 – Jan
1991

Technical Support Representative – The Computer Group
Software support; testing; resolving program “bugs”; addressing client
questions, problem, and complaints; assisting clients with software
installations; used Venture Publisher to revise software documentation; wrote
manuals for new software; created an office procedures handbook; developed
Quick-Start sheets that cut support calls by 50%; accounts receivable.	
	Mar 1998 – Jan 1991

Associate Degree in Computer Programming from Madison Area Technical
College.	Dec 1987
Some college credits, no degree.