🚀 go-pugleaf

Student Assistant / Intern - Programming and analysis in a
complex, heterogeneous environment

The Information Resource Management Office is a small
(5-person) department concerned with the documentation and
management of the University's  administrative data (e.g.,
payroll, student, and purchasing).  Since our inception 3
years ago we have produced data dictionaries; collaborated
to deliver administrative data via a relational,
client/server data warehouse; and published data standards.
The IRM Office works on an MVS mainframe, a Novell LAN,
high-end Windows workstations, and a UNIX machine (a gopher
server).  We use SAS for data manipulation and management,
Easycase for data modeling/CASE/repository, PERL for system
utilities, and several different data retrieval packages
including MS-Access and Prism/Pivot.

We are looking for a student assistant who can support the
IRM staff and be responsible for carrying out specific
projects.  Willingness to become a competent SAS programmer
is expected as is a command of several different
programming languages and environments.  Two or more
semesters of programming experience is assumed.  Highly
desirable knowledge includes: SAS, UNIX, PC-DOS, Windows,
SQL, Perl, and mainframe Job Control Language.  Salary
commensurate with experience and competence.  Position
would be full time in the summer and part time during the
academic year. 

------------------------------------------
Possible student projects for summer of 1995:

Document tape handling in the entire SURDS system in preparation for
automating the tape-backup aspect of the system and reducing the number of
intermediate redundant copies of the 45 SURDS datasets that are produced
each year.  This will involve understanding the SAS and JCL code enough to
assess redundancy and timing issues.

Based on the documentation project above, design, develop and implement
JCL and SAS code that will reduce ambiguity, tape charges and human
intervention.  A very high degree of accuracy and precision is required of
this system.

Play a supporting role in the production of a new edition of the data
dictionary for the 9.1 version of the Payroll/Benefits system.  This will
involve verification of definitions, data element names, and the meanings
of individual codes.  The data dictionary will be published on paper as
well as electronically (maybe on a gopher server, but probably on a WWW
server).

The IRM has collected and organized metadata for different systems and
different projects in ways that reflect the specific purposes, constraints
and characteristics of each project.  This project would document the
differences between the various data dictionaries that have been developed
and standardize them where possible.  Specifically it would standardize
and combine E9MSTR with data dictionaries for PAR, and the HR Control
Tables.  The project would describe a process for incorporating change
into IRM's data dictionaries as change occurs on the mainframe systems, in
the data warehouse, and in IRM's thinking about metadata.

The data administration literature defines a range of different
information that is regarded as important for managing and documenting
data resources.  This project would search the literature and produce a
report proposing a standard for the University of Colorado.

Migrate all gopher documentation to a web server.  Prepare paper
documentation for Windows, Mac, X-Windows and cell-based systems that will
get potential users connected to IRM's data documentation resources.

IRM has produced several pieces of documentation for mainframe resources
over the years that are now out of date.  This project would update: "How
to Execute SAS Version 6.06 under TSO", "Mainframe Data Resources", and
other documents.
--------------------------------

--
John D. Smith, IRM, CB 50, UofColo, Boulder, CO 80309 - (303) 492-9473