269307 WHITE - CiTV CLERK COUIICll J��•iV I� '
PINK - FINAN.CE �
CANARV •+DEPARTMENT File NO. f• r ��
BLUE .;_MA„aR - GITY OF - SAINT PALTL .
��
� 0 rdinccnce Ordinance N�. 1 l(/ ��J
Presented By
Referred To Committee: Date
Out of Committee By Date
An ordinance amending Ordi.nance No. 7607, entitled:
"An ordi.nance fixing the duties and responsibiliti�s and the
minimum qnalifications for the various classes of positions in
the Classified Service of the City, "
approved February 13, 1g35, as amended.
THE COUNCIL OF THE CITY OF 5AINT PAUL DOES ORDAIN:
Section 1. That Ordinance No. 7607, approved February 13,
1935, as amended, be and the same is hereby �urther amended by
striking out the present spECifications for the titles listed below and
substituting in lieu thereof new specifications for these titles as follows:
v
DATA BASE COORDINATOR
SYSTEMS ANALYST I
�
SYSTEMS ANAL.Y5T II
�
5Y5TEMS ANALYST III
.
- 1 -
" COUIVCILMEN Requested by Department"of:
'.. Yeas Nays
Butler
' Hozza In Favor
Hunt
Roedler Against BY
Sylvester ;
Tedesco
Form Ap rov d by ' y Attorney
Adopte Council: Date
rtified P y Council S�cretar BY
By
Approved by Mayor: Date Appro by Mapor for S iss � Council
By BY
�� k �
� Title of class: • �`(��?,y►��'
• • �.;� � '�il �
DATA BASE COORDINATOR
DESCRIPTION OF WORK
General Statement of Duties: Performs responsible work coordinating,
scheduling and providing technical assistance for data processing
activities of City departments; controls the contents, organization,
integrity, privacy, storage environment and operating environment
of the municipal data bases, assists the Manager in the administra-
tion of the data processing unit.
Supervision Received: Works under the general supervision of the Manager
of Data Processing.
Supervision Exercised: Directs the work of Systems Analysts.
TYPICAL DUTIES PERFORMED
The listed examples may not include all duties performed by all positions in
this class.
Establishes the standards of data collection and data base documentation,
publishes the description and definitions of data elements, data seg-
ments, access requirements and methods of access for individual appli-
cations that use the data elements and segments, and compiles a diction-
ary or glossary of names assigned to every data element, segment, etc. ,
and defines the logical relationships between them.
Provides for the recovery of the data base in the event of castastrophic or
intermediate failure. He assumes the responsibility of providing the
. detailed requirements to implement recovery procedures and ensures
that they accomplish their intended purpose.
Consults with analysts and users in the most efficient methods of retriev-
ing data. Advises and informs users as to optimum use of retrieval
strategies and the development of appropriate access keys to accomplish
this.
Controls the integrity and security of the data base, and ensures that an
appropriate procedure exists such that specific rules or parameters
have been defined for individuals, terminals, etc. that will control all
deletions, modifications, updates and queries of the data base.
Directs and controls the sophisticated projects and tasks that need imple-
menting on data processing equipment.
Advises and consults with project leaders regarding the most effective and
efficient search/access strategies to use in designing systems.
Acts as a technical advisor to all committees, boards and department heads
requiring information as to the use of data processing equipment.
Plans and recommends machine modifications or additional equipment to
increase the capacity of the system.
Consults with the senior staff inembers, project leaders, and subordinate
personnel about work currently being performed, and coordinates between
groups, and insurea project schedules/deadlines are being met.
Assumes the duties and responsibilities of ma.nager in the manager's absence.
KNOW LEDGES, SKILLS AND ABILITIES
Thorough knowledge of data base management philosophies and concepts.
Thorough knowledge of computer programming and programming languages.
(continued )
-2-
r ,
� ,
" . � . ?�-'`�`''�'7
DATA BASE COORDINATOR
(c ontinue d)
Thorough knowledge of the common file organizations, and the search
strategies used i.n accessing them.
Thorough knowledge of on-line, interactive, and batch processing
systems.
Ability to supervise and direct the work of others on a project.
Ability to set data base standards and security checks and procedures.
Ability to interface with user departments in analyzing their data
processing requirements.
MINIMUM QUALIFICATIONS
College graduation with major course work in computer science, account-
ing, statistics, or related field and eight years' experience in data
processing, three years of which must have �een as a Systems Analyst.
or equivalent experience involving on-line or interactive processing
systems.
-3-
.� � }����«��1
Title of class:
SY ST EMS ANALY ST I
DESGRIPTION OF WORK
General Statement of Duties: Performs beginning level work in the analy-
sis, design and development of computer systems; performs computer
programming work including the analysis of data processing specifica-
tions; and performs related work as required.
Supervision Received: Works under the supervision of a unit head.
Supervision Exercised: None
TYPICAL DUTIES PERFORMED
Th e listed examples may not include all duties performed by all positions in
this class.
Analyzes work systems to determine data processing applications; confers
with users to define desired product.
Assists in researching and designing new and revised systems.
Writes and tests new computer programs; revises existing programs to
required specifications.
Writes job control statements for new and revised programs; prepares
detailed flowcharts and operating instructions for programs.
Prepares and updates procedure and documentation manuals; designs and
modifies data processing forms, reports and worksheets.
Provides project leadership on minor project when assigned.
KNOWLEDGES, SKILLS AND ABILITIES
Working knowledge of computer operations and procedures.
.., Working knowledge of data processing applications, systems analysis methods
and procedures.
Considerable knowledge of computer programming applications and techniques.
Working ability to communicate effectively with system users.
Considerable ability to write, test and revise computer programs.
MINIMUM QUALIFICATIONS
College graduation in Computer 5cience, Accounting, Statistics or a re-
lated field and one year of programming experience or equivalent.
-4-
._ ��'��'n`�
Title of class:
SYSTEMS ANALYST II
L�ESCRIPTION OF WORK
General Statement of Duties: Performs responsible work in the analysis,
design and development of computer systems; performs responsible
computer programming work; and performs related duties as required.
Supervision Received: Works under the general supervision of a unit head.
Supervision Exercised: None
TYPICAL DUTIES PERFORMED
The listed examples may not include all duties performed by all positions in
this class.
Analyzes work systems to determine data processing applications; confers
with users to define desired product.
Researches and devises procedures to obtain and organize information;
identifies files and documents required for data input; prepares flow
charts and documents systems for programming.
Writes and tests computer programs; reviews existing programs and recom-
mends modifications and revisions.
Prepares and updates procedure and documentation manuals; designs and
modifies data processi.ng forms, reports and worksheets.
Provides project leadership when assigned.
KNOW LEDGES, SKILLS AND ABILITIES
Working knowledge of computer operations and procedures.
Considerable knowledge of computer programming applications and techniques.
Considerable knowledge of data processing applications of systems analyses
methods and procedures.
Working ability to communicate effectively with system users.
Considerable ability to write, test and revise computer programs.
MINIMUM QUALIFICATIONS
College graduation with a major in Computer Science, Accounting, Statistics
or a related field and two years' experience as a Systems Analyst I or
equivalent.
-5-
-� • -
Title of class: ?�-',Q�?n�
M�1
SYSTEMS AIVALYST III
DESCRIPTION OF WORK
, General Statement of Duties: Performs highly responsible work in the
analysis, design and development of computer systems; performs highly
--responsible work coordinating the computer programming and systems
analysis activities of a data processing unit; and performs related duties
as required.
Supervision Received: Works under the general supervision of a unit head.
Supervision Exercised: May exercise within unit close technical supervision
over programming and systems staff.
TYPICAL DUTIES PERFORMED
The listed examples may not include all duties performed by all positions in
this class.
;
. Establishes standards and specifications for programming applications and
� systems analysis.
. Recommends modifications to systems software and hardware.
Provides technical assistance to programmer/analysts on new or revised
programming plans.
. Confers with system users to resolve problems a.nd answer questions re-
garding data processing applications.
Investigates and evaluates new equipment and techniques.
Analyzes, reviews and writes programs to increase operating efficiency
or adapt to new requirements.
Acts asa project leader.
KNOW LEDGES, SKILLS AND ABILITIES
Considerable knowledge of data processing applications of systems analysis
methods and procedures.
Considerable knowledge of computer hardware system capabilities.
Thorough knowledge of data processing programming applications and tech-
nique s.
Considerable ability to deal tactfully with and secure the cooperation of
subordinates and department personnel.
MINIMUM QUALIFICATIONS
College graduation with major course work in Computer Science, Accounting,
5tatistics or related fields and two years' experience as a Systems
Analyst II or eqnivalent.
-6-
WH17E - CITV CLERK CO1111C11 /"L�9,`���
PINK - FINANCE GITY OF SAIN.T PAITL �
CANARV -DEPj�RTMENT h �
BLUE.F h•MAVOR File� NO.
•
0 rdinccnce Ordinance N�. 1 C�3 C3
Presented By
Referred To Committee: Date
Out of Committee By Date
Section 2. This ordinance shall take effect and be in force thirty
days after its passage, approval, and publication.
- 7 -
COUNCILMEIV
Yeas Nays Requested by Department of:
Butler P E R S E L F:�'I C E
�ee�.. [n Favor
p�R'� /�l �?�c Lc. � �� z
Levine v Against By Thomas D. Crleason, Director
Roedler � '
�y�wCte.t
Tedesco
JUL 1 9 19T7 Form Appr ve by Cit Attorney
Adopted by Date
Cert' ' d P by ouncil S�cretary BY
Appr v by Mayor: Dat / �UL 2;2 1977 Appr by Mayor for S bm' sfin to Council
L-
By ' � 3 0 � By
puausM� �u�
. r
� ��313
Do not detach this memar��dum from the
. ordinance so that this inforrn�ion will be OM oi: 12/1975
availabte to the City Council. Rev. : 9/8/76
EXPLANATION OF ADMINISTRATIVE ORDERS9 c�
RESOLUTIONS, AND ORDINANCES
���1`�0'�
Date t Februa.ry 25, 1977
TO; MAYOR GEORGE LATIMER
FR: Personnel Office
RE: Ordinance for subrnission to the City Council
ACTION REQUESTED;
We recommend your approval and submission of this Ordinance to the
City Coun.cil.
! �
PURPOSE AND RATIONALE FOR THIS.ACT.YONo
This ordina.nce revises txi.e class speci#icati.ons for the titles of Data Base
Coordinator, Systems Ana,lyst I, Systems Analyst II, and Syetema Analyst IfI.
ATTACHMENTS:
Ordinance a.n.d copy for the City Clerk.
�� WH17E Y CLERK � - j� l A/�
�- PINK -���INANCE � -J�■■
-, CANARYi DEPARTMENT GITY OF SAI�NT PAUL COUI1C11 � �;��a�t,�
� rBLVE — MAVOR _ Flle NO.
O/ W /LfZ/�CG Ordinance N O. ��� /7
Presented By
Referred To Committee: Date
Out of Committee By Date
An ordinance amending Ordinance No. 7607, entitled:
"An ordinance fixing the dutie s and re sponsibilitie s and
the minimum q,ualifications for the various classes of positions
i.n t1�.e Classified Service of the City, "
appro�red February 13, 1935, as amended.
THE COUNCIL OF THE CITY OF SAINT PAUL DOES OR,DAIN:
Section 1. That Ordinance No. 7607, approved February 13,
1935, as a�cYiended, be and the same is hereby further amended by striking -
; out the title an.d ageci:E�ieatiox�s:.�o�: ''Cornmunity Service Offic�r", and,by
substituti.ng in �i�u �.ere�f, in its proper alphabetical order, the title and „ , . .
specifications for
POLICE COMMUIVITY OFFICER
_ 1 _
COUNCILMEIV Requested by Department of: .
Yeas Nays
Butler
Hozza In Favor
Hunt
Levine Against BY
Roedler
Sylvester .
Tedesco
Form Approved by City Attorney
Adopted b , �ncil: Date
C ied P y Council Secr�tary BY
By
Approved by Mayor: Date Approved by Mayor for Submission to Council
By BY
_ . f�F�`��,�
Title of class;
POLICE COMMUNITY OFFICER
PURPOSE
This class is beiizg established to give the Department of. Police the
opportunity to hire individuals who are familiar vvith neighbor.hood
problems, ��ho are below the age requirements for Police Officer,
or who may not be eligible for Police Officer but may in the future
become eligible, so that these employees may be exposed to and
learn about police work so that they may, through this exposure, in
formal and informal school training, become qualified for appoint-
ment as Police Officer in the Department of Police.
DESCRIPTION OF WORK
General Statement of Duties: Performs intermediate level non-sworn
police ��ork in the field and in the office; and performs related duties
as required.
Supervision Received: Works under close supervision of the unit super-
visor and technical direction of uniformed personnel in the field as
available.
Supervision Exercised: None.
TYPICAL DUTIES PERFORMED
The Ii sted example s may not include all dutie s pe rformed by all positions in
this class.
Performs public relations work in the community explaining police work
and procedures to the public and explains and relays community attitudes
to sworn officers,
Issues parking tickets, tags vehicles condemned by the Health Department
orauthorized agency and orders removal to the impounding lot.
Checks on location of reported stolen vehicles as dispatched and checics on
status of vehicles observed by officers in the field.
Conducts investigations of reported dog bite incidents, may impound
animal for obse rvation and prepare s written report of inve stigation.
Refuels patrol vehicles, inspects tire pressures, windows and lights,
delivers vehicles to garage for cleaning and general maintenance as
required.
Picks up and delivers reports, iriformation, evidence, other items and
personnel as directed or requested.
Receives, stores and categorizes arti.cles of evidence and recovered stolen,
lost or abandoned property; prepares and maintains accurate records of
all items received.
Releases articles to authorized individuals including properly identified
owners, court officers or police personnel.
Assists with departmental activities including public auctions, asseinhly
of reports and record keeping activities.
��articipates in police training programs as scheduled.
K\O�t�'LEDGES,SKILLS AND AB?LITIES
�ome kno«•ledge of police theories, principles and problems.
��, orking kno«-ledge of local, state and federal laws related to police work.
(continued)
- 2 -
r
`r'�'�`'���
Working knowledge of people, attitudes and problems of the commur�ity.
Some ability to keep records.
Working ability to deal effectively with the general public in police
business.
�'dorking ability to appl.y first aid.
`Vorking ability to communicate effectively orally and in writing,
MINIMUM QUALIFICATIONS
High school graduation and t�vo years' experience as a Communit}� Ser�•ice
Officer, or eqizivalent. Must be at least 18 years of age and must
possess a valid driver's license. After serving as a Police Comrnunity
Officer for three years, must either qualify and be appointed as a Police
Officer or be separated as a Police Community Officer. If no eaarnina-
tion for Police Officer is held during the first three years as a Police
Community Officer, appointment as a Police Community Officer may
be extended until such examination is held and completed,
- 3 -
�
. �
,
--___--__ ______,__
'� -----___
1St � -�� � ' �
�__` 2nd �
3rd `�'—f� � Adopted ' 7 � (�
/
Yeas
� Nays
BUTLER
HOZZA
_ HUNT ��,`(��?Ory
l
LEVINE
. ,
ROEDLER .
TEDESCO
PRESIDENT (SYLVESTER) /
\