The URL can be used to link to this page

99-959CouncilFile# 95Q oRi��vaL RESOLIlTION OF SA{NT PAUL, MINNESOTA � Referred To Committee Date 1 An Administrarive Resolution to Establish 2 the Rate of Pay for the posirion of 3 Geographic Information Systems Deve]oper RESOLVED, that the rate of pay for the classificarion entiUed "GIS Systems Develope�" shall 0 7 � be established at Grade 22T, as set forth in 5ecrion I D 3 of the "Professional Employees Non-Supervisory Standard Ranges" in the Salary Plan and Rates of Compensation, and be it, Green Sheet # IO.ZR 2G - 39 FINALLY RESOLVED, that this resolution shall take effect and be in force on the first pay period following passage and approval. Requested by Departrnent of Office of Iabo l � ' latio� �: i�?��'� �` �cr�f- Form Ap tov by Ciry A omey By: �.�� q � Zt � �1 Adoption Certified by Council Secretary sy: �� _ � - � .a___ Approved by Mayor: Date /(Gf'fi'��d �� T / �: �� ,G�� Approved b, r for Submission to Council �3'� �� Adopted by Council: Date ��_ C. \ ��(R � �` .� II Human Resources i CONTACT PERSON & YHONE: � Maric Robertson �66 -6 41) Machael Foley �66 -64$t� MUSC BE OY COUNCII, AGENpA BY (DATL� TOTAL # OF SIGNATIJRE PAGES DATE INl'PIATED 91�o1�t t ASSSGN NI7MBER FOR ROUTING ORDER qq -q s� GREEN SHEET No.: 102926 �iC17ALDATE ALL LOCATIONS FOR SIGNATIJRE) INiTTAUDA?E � crrr covxcu. 6 CITY CLERK FIN.Bc MGT. SERVICE DIl2. CNIL SERVICE COMII3ISSION ncrioK xEQUFSrEV: Approval of the attached resolution tA establish the pay rate for the proposed classificarion entided GIS Developer. RECOMMENDATIONS: Approve (A) or Reject (R) PLANNING COMMISSION CIVII. SERVICE COMMISSION CB COMMITPEE STAFF D15'tRICT COURT SUPPORTS WHICH COLMCQ, OBJECTIVE? PERSONAL SERViCE CONTRAGTS M[SST ANSWER THE FOLLOWING QUFSTIONS: 1. Has tlils petson/5�m ever worked under a coMact for this departmenY? Yu No 2. Has tbis persrnJfvm ever been a city employee? Yes No 3. Does $tis persodfvm possess a skill not no�mally possessed by aay current ciTy employee? Yes No Ezplaui aR yes snswers on separete sheet and attach to green sheet INSTIATIN(:PROBLEM,ISSIJG,OPPORT(JNITY(1Nho, Geograplvcal Informadon SysCems (GIS) technology development will result in appticarions that will improve management of the City nifrastructure facilities. GIS is a new &eld of information technology. It requires specific competencies which are not norxnally acquired by traditionally trained information systems teclmicians. Tlris classification and the assi�ed compensation level will allow for the establishment of continued GIS support and application developmentin Public Works. _ anva.NZwcES � wrrxovEn: This important function of GIS application development will be appropriately classified and compensated. L�.v i�`... E{T0-; 5 R- �' �- :. _..v E.' -,�. ;, .t t DIBADVANTAGESIFAPPROVED: NOIIO. w:� �� K� Jr) L . �� _ e P•p� • } {_f.'.. . . , , �. � _ ._ � .. .. . . . . nisanvarrrncES iF rrar nrrxovEU: The City may not be able to recruit and retain employees with the competencies necessary to support GIS development. Consequently, improvements in infrastructure management will be delayed. TOTAL AMOUN'I' OF TRANSAGTIOM: $ I,OOO FCJPIDIlVGSOURCE: L3S '.. FSNANC3AL llYFORARATION: (EXPLAIN) COST/2EVENIIEBUDGETED: YCS ac.°rm� rrcJMB�x: 32001 Right of Way , C,� �£3��P�1 �9n�Ei , ... � PROPOSED TITLE OF CLASS: GIS SYSTEMS DEVELOPER DESCRIPTION OF WORK General Statement of Duties: CODE: 560A BU: 06 EFEECTIVE: ��q � Performs professional and technical work in the development, administration, and user access to computer systems involving GIS and CAD that are critical to providing access to infoxmation on the City's infrastructure. Performs other duties as assigned oY required. �ervision Received: Receives general administrative supervision £rom a higher level manager. �ervision ExeYCised: Does not exercise formal supervision. Acts as technical advisor, trainer, and project leader as assignedfrequired. TYPIGAL DUTIES PERFORMED The listed examples may not include all the duties performed by all positions in this class. Develops proceduxes, standards, and conventions for a variety of electronic, especially CAD and GIS related, computer-based project design and permanent record funetions including project design, as-builts, and maintenance and modifications. Instructs Public Works personnel in various aspects of CAD and/or GIS systems. This includes individual instruction to both inexperienced users and to more sophisticated users and also includes more formal, stxuctured training in classroom settings. Oversees some of the Public Works CAD and GIS initiatives and makes recommendations on timing and phasing so that various development initiatives are sequenced to make optimum use of human and technical resources. Creates web sites and associated portions o£ information systems, especially those dealing with spatial information. Performs research into new developments in information technology and in new ways of applying the technologies. Investigates alternatives and costs and makes recommendations as appropriate. Initiates, designs, and manages projects from inception to completion. Develops technical specifications for software and hardware related to CAD and GIS. Assists in developing RFPs for these purchases. Designs and establishes databases related to CAD/GIS systems. (continued on reverse side) GIS SYSTEMS DEVELOPER PROPOSED TITLE OF CLASS: Page 2 GZS SYSTEMS DEVEIAPER ,p �0�. � 1 Ensures security for these systems. Devises and develops interconnections between databases, application programs, websites, etc. Develops ideas, tools, and methods to get these applications into the field in a practical manner. KNOWLEDGE, SKILLS, ABILITIES AND COMPETENCIES Considerable knowledge of CAD and GIS. Considerable knowledge of database. Considerable knowledge of web site development. Working knowledge of Public Works £ield operations and overall operations. Considerable ahility to design and implement information systems and databases that have a high component of GIS and CAD and that deal with spatial and topographical information. Gonsiderable ability to develop information systems that are useful in the field as well as in an office environment. Considerable ability to visualize and work with the spatial aspects of data and to incorporate it into infoxmation systems. ConsideYable ability to success£ully initiate, execute, and manage several complex projects simultaneously. Considerable ability to visualize how a work £low or practice could be implemented in an electronic system. Considerable ability to teach computer skills especially to CAD and GIS users. Considerable ability to maintain self curxent on technical £ields impacting spatially oriented information systems. Working ability to institute e£fective security on systems that must also be readily accessible. Considerable ability to develop and/or adapt information system output media that aYe practical for construction-related field applications. Considerable ability to develop reliable interconnections among a variety of classes of software tools including databases, websites, and application programs. Considerable ability to develop computerized information systems without GIS SYSTEM5 DEVELOPER Page 3 PROPOSED TITLE OF CLASS: standard precedent. MII3IMUM QUALZFICATIONS GIS SYSTEMS DEVEIAPER a�►_q s� Aigh school graduation with courses in algebra and geometry and 15 college credits in mathematics, writing or English, computer sciences, and/or drafting, and 80 houxs of training in CAD, 80 houxs training in GIS, and two years of field experience in a public works environment and three years o£ experience in programming and developing systems in CAD and GIS that are also web-accessible in a constxuction ox public works environment, GIS SYSTEMS DEVELOPEI2 �lq- a �� Compensation Issues Proposed GIS System Developer Position Present Position Title Public Works Technician II Proaosed Position Title GIS System Developer Difference per Pav Period Compensation per uav period $ 1,642.96 Comnensatio�er pay period $ 1,910.77 $ 267.81 Annualized Additional Cost: $ 6,989.84 dt`� -°l 5 q Urban GI5 Systems GIS refers to Geographic Information Systems. These are computer based information systems that have a geographic orientation. The most common systems we see are "text-oriented" or number oriented systems (personnel databases, tax rolls, bank accounts, etc.) While these are sophisticated, the GIS systems contain numerical information which can be associated with a particular place and contains spatial data, such as topogaphy (a three dimensional map), sewer pipe drawings, road bed configurarions, water pipe routes, etc. Often putting this spatial information into a database involves doing things that have never been done before in terms of databases and applications (processing) programs. While this is a technologically challenging field it also has practical value in managing the infrastructure of an urban environment. The process will permit the consolidation of information which is now spread out throughout the City and is being maintained by several staffs. These include databases, other computer fi1es, and even some paper files. These databases do contain redundant infottnation, however the redundancy is necessary to make the disconnected systems function for their primary users. In addition, having the information "scattered" in this fashion makes it more difficult to make relationships that could possibly reduce maimenance costs. Most of these systems are not availab]e to field crews (sewers, water, streets, lights, parks, Police and Fire) who are actually working on a job unless they are transfened to paper format. (Paper format is more susceptible to having out of date information.) However, the GIS format presents the possibility of having portable display formats such as laptop computers that can be brought into the field and used by the crews, thus providing them with instant access to more complete and more curtent information than is now the case. The advantages to the City of properly designed GIS systems include focusing staff efforts, greater accessibility of data, the chance to provide more complete analyses, the possibility for maintaining information more accurately and at relatively less expense, and increased possihility of new and inventive uses in the field which will provide crews with more accurate information. The GIS systems offer significant possibilities for improved management of the City's infrastructure. olq _°ls9 CLASSIFICATION STQDY REPORT CLASS S'I`UDIED: INCUMBENT: STUDIED BY: DATE STUDIED: PERSONS CONTACTED: APPROVAL Public Works Technician II Robert Basques IVTichael F. Foley��j� ✓�� /'L 1/ August 23, 1999 Donald Sobania, Public Works (Manager) Dan Bartholic (Team leader) Robert Basques (Incumbent) George Huschle (I S) LeeAnn Turchin (H-R - Consultant on Public Works I5 Project) HUMAN RESOURCES MANAGEMENT: � (Signature) (Date) Background Public Works has been making an effort to "integrate" the majority of its design and GIS based information into related databases that are readily avai]able. This includes efforts to make relevant data accessible to workers in the field as well as to office staff. This also involved making GIS data compatible with related GIS based systems notably the County and the State. Public Works has allocated several positions out of its e�sting FTE to perform this task. This job profile was submitted by one of the people assigned to this task force. StudXComponents Review of}ob profile Interview with incumbent Interview with H-R Public Works Consultant Interview with Public Works manager Interview with manager in IS Interview with Public Works GIS Team Leader Comparison to class specifications Comparison to other positions QES evaluation and analysis Comparison to Class Specifications �tg ��5� The proposed class specification was compared with exisring class specifications in the EDP Series and in the newer Informarion Series. It was found that existing class specs did not address the responsibiliries of the position in question. The EDP posirions are being phased out since the class specs were obsolete. Progosed Class Spec The new proposed classification specification (attached) captures the responsibilities of the position in question. One important factor in this class spectfication is the idea that the position in question is working with spatially oriented data and this seems to require a particular aptitude and background that may not be possessed by traditional IS people even though they are, themselves, quite imaginative and creative. Conclusion It is recommended that this proposed class speciScation be adopted and the incumbent of the position in question be assigned to it. Comparison to Other Positions The proposed class spec was compared to the positions actually assigned to the EDP Series Positions and those assigned to the newer Infarmation Series. The EDP positions are being phased out since the class specs were obsolete and no satisfactory match was found in the new IS series. Conclusion It is recommended that the position in question be assigned to the proposed class specification. Q. E. S. Evaluation and Analvsis The QES analysis supports ailocation to grade 22T in PEA. Recommendation It is recommended that the position be allocated to the proposed new class specification attached and that this be placed at grade 22T in PEA. �a1-�1s OFFICE OF HUMAN RESOURC: John Hamilton, Director 54IVC P4liL � AAAA CTTY OF SAINT PAUL Norm Colem�m, Mayor FRi3M ;� �Tom Eggum, Director Department of Public Works �eS i I�. Michael F. Foley /� �� 1�71f1��11 � July 13, 1999 aoo ceryxou.v�� 25 Wes[Fourth Sa'eet SaintPmd,Mirsnesota �5102-1631 Telephone: 6I2-266-6500 TDD/CIP.� 672-266-650! JobUne: 612-266-b�02 FacsimiZe: 612-292-76� 6 Twenty Day Notice - Proposed GIS Systems Developer Posirion It has been determined that the tiUe and class spec�carion of GIS Systems Developer should be created. I have attached a copy of the class specification for your review. Please notify me within twenty days of receipt of Yhis memo, if you wish to discuss this action. If I do not hear from you within that timeframe, I will assume agreement and will proceed with the process. Meantime, I will be processin a resolufion to place this posirion in Grade 22T of the Professional Employee I3on-Supervisory Standazd Ranges in Secrion ID 4 of the the Salary Plan and Rates of Compensarion. I hereby waive the time remaining on this 20 day notice for the purpose of creating this title ancl�Cl"a�ss snecificntibn. � cc: Bob Horrisberger Labor Relations Affirmative Action Cindy Mullan (T&MS/IS) 7 Date �� 8 d s l�{' 6�i. S3�at1G�532! N�W�tH '�'t��' `.�� .!!; `� �" ;?�'�; °i°l • °ls � OFFICE OF HUMAN RESOURCES JohnHmtilton, Director GTTY OF SAINT PAUL Norm Coleman, Mayor 7uly 13, 1999 Professional Employees Association Mike Wilde, Business Representative 360 Robert Street I3. Suite # 424 Saint Paul, MN 55101 400CttyHaIIAnnes 25 WestFrn+rth Sveet SaintPmtl,Minnesota 551021631 RE: Twenty Day Notice - Proposed GIS Systems Developer Position Telephone: 612-26b6500 TDD/llY.• 612-366-650I Jobline: 612-266-6502 Facsimile• 612-292-7656 It has been determined that the title and class specification of GIS Systems Deueloper should be created. I have attached a copy of the class specification for your review. Please notify me within twenty days of receipt of this memo, if you wish to discuss this action. If I do not hear from you within that timeframe, I will assume agreement and will proceed with the process. I will also be processing a resolurion to establish the rate of pay for this title in Grade 22T, Section ID3, of the Professional Employees Non-Supervisory Standard Ranges in the Salary Plan and Rates of Compensation. Thank you. � � Mi ael Foley I hereby waive the time remainn�g on this 20 day notice for the purpose of creating this title and class specification. Name �kc Twe��'� Lvt p �" � �� I�� Q �/ �a � S G J(�a 1 �"� � O tl � P c f' I a''+ Date PROPOSED TZTLE OF CLASS: DESCRIPTION OF WORK General Statement of Duties: l � GIS SYSTEMS DEVEIAPER CODE: 660A BU: 06 EFFECTIVE: S� Q� � F Performs professional and technical work in the development, administration, and user access to computer systems involving GIS and CAD that are critical to providing access to in£ormation on the City's infrastructure. Per£orms other duties as assigned or required. Sunervision Received: Receives general administrative supervision from a higher level manager. Supexvision Exercised: Does not exercise formal supervision. Acts as technical advisor, trainer, and project leader as assigned/required. TYPICAL DUTIES PERFORMED The listed examples may not include all the duties performed by all positions in this class. Develops procedures, standards, and conventions for a variety of electronic, especially CAD and GIS related, computer-based project design and permanent record futtctions including project design, as-builts, and maintenance and modifications. Instructs Public Works personnel in various aspects of CAD and/or GIS systems. This includes individual instruction to both inexperienced users and to more sophisticated users and also includes more £ormal, structured training in classroom settings. Oversees some of the Public Works CAD and GIS initiatives and makes recommendations on timing and phasing so that various development initiatives are sequenced to make optimum use of human and technical resources. Creates web sites and associated portions of information systems, especially those dealing with spatial information. Performs research into new developments in information technology and in new ways of applying the technologies. Investigates alternatives and costs and makes recommendations as appropriate. Initiates, designs, and manages projects from inception to completion. Develops technical specifications for software and hardware related to CAD and GIS. Assists in developing RFPs for these purchases. Designs and establishes databases related to CAD/GIS systems. (continued on reverse side) GIS SYSTEMS DEVEIAPER � PROPOSED TITLE OF CLASS GI ��DEVELOPER ' Ensures security for these systems. , Devises and develops interconnections between databases, application � programs, websites, etc. Develops ideas, tools, and methods to get these applications into the field in a p=actical mannet. KNOWLEDGE, SKII.LS, ABILITIES AND COMPETENCZES Page 2 �q_�.SR Considerable lmowledge of CAD and GIS. Considerable knowledge of database. Considerable knowledge of web site development. Working knowledge of Public Works field operations and overall operations. Considerable ability to design and implement in£ormation systems and databases that have a high component of GIS and CAD and that deal with spatial and topographical information. Considerable ability to develop information systems that are useful in the field as well as in an office environment. Considerable ability to visualize and work with the spatial aspects of data and to incorporate it into information systems. Considerable ability to successfully initiate, execute, and manage several complex projects simultaneously. Considerable ability to visualize how a work flow or practice could be implemented in an electronic system. Considerable ability to teach computer skills especially to CAD and GIS users. Considerable ability to maintain self current on technical fields impacting spatially oriented information systems. Working ability to institute effective security on systems that must also be readily accessible. Considerable ability to develop and/or adapt information system output media that are practical for construction-related field applications. Considerable ability to develop reliable interconnections among a variety of classes of software tools including datahases, websites, and application programs. Considerable ability to develop computerized information systems without GIS SYSTEMS DEVEIAPER � PROPOSED TITLE OF CLASS standard precedent. MINIMUM QUALIFICATIONS �� GIS SYST�MS` DE�IEIAPER Page 3 a°�-q s� Aigh school graduation with courses in algebra and geometry and 15 college credits in mathematics, writing or English, computer sciences, and/or drafting, and 80 hours of training in CAD, 80 hours training in GIS, and two years of field experience in a public works environment and three yeaxs of expeYience in programming and developing systems in CAD and GIS that are also web-accessible in a construction or public works environment. GIS SYSTEMS DEVEIAPER CouncilFile# 95Q oRi��vaL RESOLIlTION OF SA{NT PAUL, MINNESOTA � Referred To Committee Date 1 An Administrarive Resolution to Establish 2 the Rate of Pay for the posirion of 3 Geographic Information Systems Deve]oper RESOLVED, that the rate of pay for the classificarion entiUed "GIS Systems Develope�" shall 0 7 � be established at Grade 22T, as set forth in 5ecrion I D 3 of the "Professional Employees Non-Supervisory Standard Ranges" in the Salary Plan and Rates of Compensation, and be it, Green Sheet # IO.ZR 2G - 39 FINALLY RESOLVED, that this resolution shall take effect and be in force on the first pay period following passage and approval. Requested by Departrnent of Office of Iabo l � ' latio� �: i�?��'� �` �cr�f- Form Ap tov by Ciry A omey By: �.�� q � Zt � �1 Adoption Certified by Council Secretary sy: �� _ � - � .a___ Approved by Mayor: Date /(Gf'fi'��d �� T / �: �� ,G�� Approved b, r for Submission to Council �3'� �� Adopted by Council: Date ��_ C. \ ��(R � �` .� II Human Resources i CONTACT PERSON & YHONE: � Maric Robertson �66 -6 41) Machael Foley �66 -64$t� MUSC BE OY COUNCII, AGENpA BY (DATL� TOTAL # OF SIGNATIJRE PAGES DATE INl'PIATED 91�o1�t t ASSSGN NI7MBER FOR ROUTING ORDER qq -q s� GREEN SHEET No.: 102926 �iC17ALDATE ALL LOCATIONS FOR SIGNATIJRE) INiTTAUDA?E � crrr covxcu. 6 CITY CLERK FIN.Bc MGT. SERVICE DIl2. CNIL SERVICE COMII3ISSION ncrioK xEQUFSrEV: Approval of the attached resolution tA establish the pay rate for the proposed classificarion entided GIS Developer. RECOMMENDATIONS: Approve (A) or Reject (R) PLANNING COMMISSION CIVII. SERVICE COMMISSION CB COMMITPEE STAFF D15'tRICT COURT SUPPORTS WHICH COLMCQ, OBJECTIVE? PERSONAL SERViCE CONTRAGTS M[SST ANSWER THE FOLLOWING QUFSTIONS: 1. Has tlils petson/5�m ever worked under a coMact for this departmenY? Yu No 2. Has tbis persrnJfvm ever been a city employee? Yes No 3. Does $tis persodfvm possess a skill not no�mally possessed by aay current ciTy employee? Yes No Ezplaui aR yes snswers on separete sheet and attach to green sheet INSTIATIN(:PROBLEM,ISSIJG,OPPORT(JNITY(1Nho, Geograplvcal Informadon SysCems (GIS) technology development will result in appticarions that will improve management of the City nifrastructure facilities. GIS is a new &eld of information technology. It requires specific competencies which are not norxnally acquired by traditionally trained information systems teclmicians. Tlris classification and the assi�ed compensation level will allow for the establishment of continued GIS support and application developmentin Public Works. _ anva.NZwcES � wrrxovEn: This important function of GIS application development will be appropriately classified and compensated. L�.v i�`... E{T0-; 5 R- �' �- :. _..v E.' -,�. ;, .t t DIBADVANTAGESIFAPPROVED: NOIIO. w:� �� K� Jr) L . �� _ e P•p� • } {_f.'.. . . , , �. � _ ._ � .. .. . . . . nisanvarrrncES iF rrar nrrxovEU: The City may not be able to recruit and retain employees with the competencies necessary to support GIS development. Consequently, improvements in infrastructure management will be delayed. TOTAL AMOUN'I' OF TRANSAGTIOM: $ I,OOO FCJPIDIlVGSOURCE: L3S '.. FSNANC3AL llYFORARATION: (EXPLAIN) COST/2EVENIIEBUDGETED: YCS ac.°rm� rrcJMB�x: 32001 Right of Way , C,� �£3��P�1 �9n�Ei , ... � PROPOSED TITLE OF CLASS: GIS SYSTEMS DEVELOPER DESCRIPTION OF WORK General Statement of Duties: CODE: 560A BU: 06 EFEECTIVE: ��q � Performs professional and technical work in the development, administration, and user access to computer systems involving GIS and CAD that are critical to providing access to infoxmation on the City's infrastructure. Performs other duties as assigned oY required. �ervision Received: Receives general administrative supervision £rom a higher level manager. �ervision ExeYCised: Does not exercise formal supervision. Acts as technical advisor, trainer, and project leader as assignedfrequired. TYPIGAL DUTIES PERFORMED The listed examples may not include all the duties performed by all positions in this class. Develops proceduxes, standards, and conventions for a variety of electronic, especially CAD and GIS related, computer-based project design and permanent record funetions including project design, as-builts, and maintenance and modifications. Instructs Public Works personnel in various aspects of CAD and/or GIS systems. This includes individual instruction to both inexperienced users and to more sophisticated users and also includes more formal, stxuctured training in classroom settings. Oversees some of the Public Works CAD and GIS initiatives and makes recommendations on timing and phasing so that various development initiatives are sequenced to make optimum use of human and technical resources. Creates web sites and associated portions o£ information systems, especially those dealing with spatial information. Performs research into new developments in information technology and in new ways of applying the technologies. Investigates alternatives and costs and makes recommendations as appropriate. Initiates, designs, and manages projects from inception to completion. Develops technical specifications for software and hardware related to CAD and GIS. Assists in developing RFPs for these purchases. Designs and establishes databases related to CAD/GIS systems. (continued on reverse side) GIS SYSTEMS DEVELOPER PROPOSED TITLE OF CLASS: Page 2 GZS SYSTEMS DEVEIAPER ,p �0�. � 1 Ensures security for these systems. Devises and develops interconnections between databases, application programs, websites, etc. Develops ideas, tools, and methods to get these applications into the field in a practical manner. KNOWLEDGE, SKILLS, ABILITIES AND COMPETENCIES Considerable knowledge of CAD and GIS. Considerable knowledge of database. Considerable knowledge of web site development. Working knowledge of Public Works £ield operations and overall operations. Considerable ahility to design and implement information systems and databases that have a high component of GIS and CAD and that deal with spatial and topographical information. Gonsiderable ability to develop information systems that are useful in the field as well as in an office environment. Considerable ability to visualize and work with the spatial aspects of data and to incorporate it into infoxmation systems. ConsideYable ability to success£ully initiate, execute, and manage several complex projects simultaneously. Considerable ability to visualize how a work £low or practice could be implemented in an electronic system. Considerable ability to teach computer skills especially to CAD and GIS users. Considerable ability to maintain self curxent on technical £ields impacting spatially oriented information systems. Working ability to institute e£fective security on systems that must also be readily accessible. Considerable ability to develop and/or adapt information system output media that aYe practical for construction-related field applications. Considerable ability to develop reliable interconnections among a variety of classes of software tools including databases, websites, and application programs. Considerable ability to develop computerized information systems without GIS SYSTEM5 DEVELOPER Page 3 PROPOSED TITLE OF CLASS: standard precedent. MII3IMUM QUALZFICATIONS GIS SYSTEMS DEVEIAPER a�►_q s� Aigh school graduation with courses in algebra and geometry and 15 college credits in mathematics, writing or English, computer sciences, and/or drafting, and 80 houxs of training in CAD, 80 houxs training in GIS, and two years of field experience in a public works environment and three years o£ experience in programming and developing systems in CAD and GIS that are also web-accessible in a constxuction ox public works environment, GIS SYSTEMS DEVELOPEI2 �lq- a �� Compensation Issues Proposed GIS System Developer Position Present Position Title Public Works Technician II Proaosed Position Title GIS System Developer Difference per Pav Period Compensation per uav period $ 1,642.96 Comnensatio�er pay period $ 1,910.77 $ 267.81 Annualized Additional Cost: $ 6,989.84 dt`� -°l 5 q Urban GI5 Systems GIS refers to Geographic Information Systems. These are computer based information systems that have a geographic orientation. The most common systems we see are "text-oriented" or number oriented systems (personnel databases, tax rolls, bank accounts, etc.) While these are sophisticated, the GIS systems contain numerical information which can be associated with a particular place and contains spatial data, such as topogaphy (a three dimensional map), sewer pipe drawings, road bed configurarions, water pipe routes, etc. Often putting this spatial information into a database involves doing things that have never been done before in terms of databases and applications (processing) programs. While this is a technologically challenging field it also has practical value in managing the infrastructure of an urban environment. The process will permit the consolidation of information which is now spread out throughout the City and is being maintained by several staffs. These include databases, other computer fi1es, and even some paper files. These databases do contain redundant infottnation, however the redundancy is necessary to make the disconnected systems function for their primary users. In addition, having the information "scattered" in this fashion makes it more difficult to make relationships that could possibly reduce maimenance costs. Most of these systems are not availab]e to field crews (sewers, water, streets, lights, parks, Police and Fire) who are actually working on a job unless they are transfened to paper format. (Paper format is more susceptible to having out of date information.) However, the GIS format presents the possibility of having portable display formats such as laptop computers that can be brought into the field and used by the crews, thus providing them with instant access to more complete and more curtent information than is now the case. The advantages to the City of properly designed GIS systems include focusing staff efforts, greater accessibility of data, the chance to provide more complete analyses, the possibility for maintaining information more accurately and at relatively less expense, and increased possihility of new and inventive uses in the field which will provide crews with more accurate information. The GIS systems offer significant possibilities for improved management of the City's infrastructure. olq _°ls9 CLASSIFICATION STQDY REPORT CLASS S'I`UDIED: INCUMBENT: STUDIED BY: DATE STUDIED: PERSONS CONTACTED: APPROVAL Public Works Technician II Robert Basques IVTichael F. Foley��j� ✓�� /'L 1/ August 23, 1999 Donald Sobania, Public Works (Manager) Dan Bartholic (Team leader) Robert Basques (Incumbent) George Huschle (I S) LeeAnn Turchin (H-R - Consultant on Public Works I5 Project) HUMAN RESOURCES MANAGEMENT: � (Signature) (Date) Background Public Works has been making an effort to "integrate" the majority of its design and GIS based information into related databases that are readily avai]able. This includes efforts to make relevant data accessible to workers in the field as well as to office staff. This also involved making GIS data compatible with related GIS based systems notably the County and the State. Public Works has allocated several positions out of its e�sting FTE to perform this task. This job profile was submitted by one of the people assigned to this task force. StudXComponents Review of}ob profile Interview with incumbent Interview with H-R Public Works Consultant Interview with Public Works manager Interview with manager in IS Interview with Public Works GIS Team Leader Comparison to class specifications Comparison to other positions QES evaluation and analysis Comparison to Class Specifications �tg ��5� The proposed class specification was compared with exisring class specifications in the EDP Series and in the newer Informarion Series. It was found that existing class specs did not address the responsibiliries of the position in question. The EDP posirions are being phased out since the class specs were obsolete. Progosed Class Spec The new proposed classification specification (attached) captures the responsibilities of the position in question. One important factor in this class spectfication is the idea that the position in question is working with spatially oriented data and this seems to require a particular aptitude and background that may not be possessed by traditional IS people even though they are, themselves, quite imaginative and creative. Conclusion It is recommended that this proposed class speciScation be adopted and the incumbent of the position in question be assigned to it. Comparison to Other Positions The proposed class spec was compared to the positions actually assigned to the EDP Series Positions and those assigned to the newer Infarmation Series. The EDP positions are being phased out since the class specs were obsolete and no satisfactory match was found in the new IS series. Conclusion It is recommended that the position in question be assigned to the proposed class specification. Q. E. S. Evaluation and Analvsis The QES analysis supports ailocation to grade 22T in PEA. Recommendation It is recommended that the position be allocated to the proposed new class specification attached and that this be placed at grade 22T in PEA. �a1-�1s OFFICE OF HUMAN RESOURC: John Hamilton, Director 54IVC P4liL � AAAA CTTY OF SAINT PAUL Norm Colem�m, Mayor FRi3M ;� �Tom Eggum, Director Department of Public Works �eS i I�. Michael F. Foley /� �� 1�71f1��11 � July 13, 1999 aoo ceryxou.v�� 25 Wes[Fourth Sa'eet SaintPmd,Mirsnesota �5102-1631 Telephone: 6I2-266-6500 TDD/CIP.� 672-266-650! JobUne: 612-266-b�02 FacsimiZe: 612-292-76� 6 Twenty Day Notice - Proposed GIS Systems Developer Posirion It has been determined that the tiUe and class spec�carion of GIS Systems Developer should be created. I have attached a copy of the class specification for your review. Please notify me within twenty days of receipt of Yhis memo, if you wish to discuss this action. If I do not hear from you within that timeframe, I will assume agreement and will proceed with the process. Meantime, I will be processin a resolufion to place this posirion in Grade 22T of the Professional Employee I3on-Supervisory Standazd Ranges in Secrion ID 4 of the the Salary Plan and Rates of Compensarion. I hereby waive the time remaining on this 20 day notice for the purpose of creating this title ancl�Cl"a�ss snecificntibn. � cc: Bob Horrisberger Labor Relations Affirmative Action Cindy Mullan (T&MS/IS) 7 Date �� 8 d s l�{' 6�i. S3�at1G�532! N�W�tH '�'t��' `.�� .!!; `� �" ;?�'�; °i°l • °ls � OFFICE OF HUMAN RESOURCES JohnHmtilton, Director GTTY OF SAINT PAUL Norm Coleman, Mayor 7uly 13, 1999 Professional Employees Association Mike Wilde, Business Representative 360 Robert Street I3. Suite # 424 Saint Paul, MN 55101 400CttyHaIIAnnes 25 WestFrn+rth Sveet SaintPmtl,Minnesota 551021631 RE: Twenty Day Notice - Proposed GIS Systems Developer Position Telephone: 612-26b6500 TDD/llY.• 612-366-650I Jobline: 612-266-6502 Facsimile• 612-292-7656 It has been determined that the title and class specification of GIS Systems Deueloper should be created. I have attached a copy of the class specification for your review. Please notify me within twenty days of receipt of this memo, if you wish to discuss this action. If I do not hear from you within that timeframe, I will assume agreement and will proceed with the process. I will also be processing a resolurion to establish the rate of pay for this title in Grade 22T, Section ID3, of the Professional Employees Non-Supervisory Standard Ranges in the Salary Plan and Rates of Compensation. Thank you. � � Mi ael Foley I hereby waive the time remainn�g on this 20 day notice for the purpose of creating this title and class specification. Name �kc Twe��'� Lvt p �" � �� I�� Q �/ �a � S G J(�a 1 �"� � O tl � P c f' I a''+ Date PROPOSED TZTLE OF CLASS: DESCRIPTION OF WORK General Statement of Duties: l � GIS SYSTEMS DEVEIAPER CODE: 660A BU: 06 EFFECTIVE: S� Q� � F Performs professional and technical work in the development, administration, and user access to computer systems involving GIS and CAD that are critical to providing access to in£ormation on the City's infrastructure. Per£orms other duties as assigned or required. Sunervision Received: Receives general administrative supervision from a higher level manager. Supexvision Exercised: Does not exercise formal supervision. Acts as technical advisor, trainer, and project leader as assigned/required. TYPICAL DUTIES PERFORMED The listed examples may not include all the duties performed by all positions in this class. Develops procedures, standards, and conventions for a variety of electronic, especially CAD and GIS related, computer-based project design and permanent record futtctions including project design, as-builts, and maintenance and modifications. Instructs Public Works personnel in various aspects of CAD and/or GIS systems. This includes individual instruction to both inexperienced users and to more sophisticated users and also includes more £ormal, structured training in classroom settings. Oversees some of the Public Works CAD and GIS initiatives and makes recommendations on timing and phasing so that various development initiatives are sequenced to make optimum use of human and technical resources. Creates web sites and associated portions of information systems, especially those dealing with spatial information. Performs research into new developments in information technology and in new ways of applying the technologies. Investigates alternatives and costs and makes recommendations as appropriate. Initiates, designs, and manages projects from inception to completion. Develops technical specifications for software and hardware related to CAD and GIS. Assists in developing RFPs for these purchases. Designs and establishes databases related to CAD/GIS systems. (continued on reverse side) GIS SYSTEMS DEVEIAPER � PROPOSED TITLE OF CLASS GI ��DEVELOPER ' Ensures security for these systems. , Devises and develops interconnections between databases, application � programs, websites, etc. Develops ideas, tools, and methods to get these applications into the field in a p=actical mannet. KNOWLEDGE, SKII.LS, ABILITIES AND COMPETENCZES Page 2 �q_�.SR Considerable lmowledge of CAD and GIS. Considerable knowledge of database. Considerable knowledge of web site development. Working knowledge of Public Works field operations and overall operations. Considerable ability to design and implement in£ormation systems and databases that have a high component of GIS and CAD and that deal with spatial and topographical information. Considerable ability to develop information systems that are useful in the field as well as in an office environment. Considerable ability to visualize and work with the spatial aspects of data and to incorporate it into information systems. Considerable ability to successfully initiate, execute, and manage several complex projects simultaneously. Considerable ability to visualize how a work flow or practice could be implemented in an electronic system. Considerable ability to teach computer skills especially to CAD and GIS users. Considerable ability to maintain self current on technical fields impacting spatially oriented information systems. Working ability to institute effective security on systems that must also be readily accessible. Considerable ability to develop and/or adapt information system output media that are practical for construction-related field applications. Considerable ability to develop reliable interconnections among a variety of classes of software tools including datahases, websites, and application programs. Considerable ability to develop computerized information systems without GIS SYSTEMS DEVEIAPER � PROPOSED TITLE OF CLASS standard precedent. MINIMUM QUALIFICATIONS �� GIS SYST�MS` DE�IEIAPER Page 3 a°�-q s� Aigh school graduation with courses in algebra and geometry and 15 college credits in mathematics, writing or English, computer sciences, and/or drafting, and 80 hours of training in CAD, 80 hours training in GIS, and two years of field experience in a public works environment and three yeaxs of expeYience in programming and developing systems in CAD and GIS that are also web-accessible in a construction or public works environment. GIS SYSTEMS DEVEIAPER CouncilFile# 95Q oRi��vaL RESOLIlTION OF SA{NT PAUL, MINNESOTA � Referred To Committee Date 1 An Administrarive Resolution to Establish 2 the Rate of Pay for the posirion of 3 Geographic Information Systems Deve]oper RESOLVED, that the rate of pay for the classificarion entiUed "GIS Systems Develope�" shall 0 7 � be established at Grade 22T, as set forth in 5ecrion I D 3 of the "Professional Employees Non-Supervisory Standard Ranges" in the Salary Plan and Rates of Compensation, and be it, Green Sheet # IO.ZR 2G - 39 FINALLY RESOLVED, that this resolution shall take effect and be in force on the first pay period following passage and approval. Requested by Departrnent of Office of Iabo l � ' latio� �: i�?��'� �` �cr�f- Form Ap tov by Ciry A omey By: �.�� q � Zt � �1 Adoption Certified by Council Secretary sy: �� _ � - � .a___ Approved by Mayor: Date /(Gf'fi'��d �� T / �: �� ,G�� Approved b, r for Submission to Council �3'� �� Adopted by Council: Date ��_ C. \ ��(R � �` .� II Human Resources i CONTACT PERSON & YHONE: � Maric Robertson �66 -6 41) Machael Foley �66 -64$t� MUSC BE OY COUNCII, AGENpA BY (DATL� TOTAL # OF SIGNATIJRE PAGES DATE INl'PIATED 91�o1�t t ASSSGN NI7MBER FOR ROUTING ORDER qq -q s� GREEN SHEET No.: 102926 �iC17ALDATE ALL LOCATIONS FOR SIGNATIJRE) INiTTAUDA?E � crrr covxcu. 6 CITY CLERK FIN.Bc MGT. SERVICE DIl2. CNIL SERVICE COMII3ISSION ncrioK xEQUFSrEV: Approval of the attached resolution tA establish the pay rate for the proposed classificarion entided GIS Developer. RECOMMENDATIONS: Approve (A) or Reject (R) PLANNING COMMISSION CIVII. SERVICE COMMISSION CB COMMITPEE STAFF D15'tRICT COURT SUPPORTS WHICH COLMCQ, OBJECTIVE? PERSONAL SERViCE CONTRAGTS M[SST ANSWER THE FOLLOWING QUFSTIONS: 1. Has tlils petson/5�m ever worked under a coMact for this departmenY? Yu No 2. Has tbis persrnJfvm ever been a city employee? Yes No 3. Does $tis persodfvm possess a skill not no�mally possessed by aay current ciTy employee? Yes No Ezplaui aR yes snswers on separete sheet and attach to green sheet INSTIATIN(:PROBLEM,ISSIJG,OPPORT(JNITY(1Nho, Geograplvcal Informadon SysCems (GIS) technology development will result in appticarions that will improve management of the City nifrastructure facilities. GIS is a new &eld of information technology. It requires specific competencies which are not norxnally acquired by traditionally trained information systems teclmicians. Tlris classification and the assi�ed compensation level will allow for the establishment of continued GIS support and application developmentin Public Works. _ anva.NZwcES � wrrxovEn: This important function of GIS application development will be appropriately classified and compensated. L�.v i�`... E{T0-; 5 R- �' �- :. _..v E.' -,�. ;, .t t DIBADVANTAGESIFAPPROVED: NOIIO. w:� �� K� Jr) L . �� _ e P•p� • } {_f.'.. . . , , �. � _ ._ � .. .. . . . . nisanvarrrncES iF rrar nrrxovEU: The City may not be able to recruit and retain employees with the competencies necessary to support GIS development. Consequently, improvements in infrastructure management will be delayed. TOTAL AMOUN'I' OF TRANSAGTIOM: $ I,OOO FCJPIDIlVGSOURCE: L3S '.. FSNANC3AL llYFORARATION: (EXPLAIN) COST/2EVENIIEBUDGETED: YCS ac.°rm� rrcJMB�x: 32001 Right of Way , C,� �£3��P�1 �9n�Ei , ... � PROPOSED TITLE OF CLASS: GIS SYSTEMS DEVELOPER DESCRIPTION OF WORK General Statement of Duties: CODE: 560A BU: 06 EFEECTIVE: ��q � Performs professional and technical work in the development, administration, and user access to computer systems involving GIS and CAD that are critical to providing access to infoxmation on the City's infrastructure. Performs other duties as assigned oY required. �ervision Received: Receives general administrative supervision £rom a higher level manager. �ervision ExeYCised: Does not exercise formal supervision. Acts as technical advisor, trainer, and project leader as assignedfrequired. TYPIGAL DUTIES PERFORMED The listed examples may not include all the duties performed by all positions in this class. Develops proceduxes, standards, and conventions for a variety of electronic, especially CAD and GIS related, computer-based project design and permanent record funetions including project design, as-builts, and maintenance and modifications. Instructs Public Works personnel in various aspects of CAD and/or GIS systems. This includes individual instruction to both inexperienced users and to more sophisticated users and also includes more formal, stxuctured training in classroom settings. Oversees some of the Public Works CAD and GIS initiatives and makes recommendations on timing and phasing so that various development initiatives are sequenced to make optimum use of human and technical resources. Creates web sites and associated portions o£ information systems, especially those dealing with spatial information. Performs research into new developments in information technology and in new ways of applying the technologies. Investigates alternatives and costs and makes recommendations as appropriate. Initiates, designs, and manages projects from inception to completion. Develops technical specifications for software and hardware related to CAD and GIS. Assists in developing RFPs for these purchases. Designs and establishes databases related to CAD/GIS systems. (continued on reverse side) GIS SYSTEMS DEVELOPER PROPOSED TITLE OF CLASS: Page 2 GZS SYSTEMS DEVEIAPER ,p �0�. � 1 Ensures security for these systems. Devises and develops interconnections between databases, application programs, websites, etc. Develops ideas, tools, and methods to get these applications into the field in a practical manner. KNOWLEDGE, SKILLS, ABILITIES AND COMPETENCIES Considerable knowledge of CAD and GIS. Considerable knowledge of database. Considerable knowledge of web site development. Working knowledge of Public Works £ield operations and overall operations. Considerable ahility to design and implement information systems and databases that have a high component of GIS and CAD and that deal with spatial and topographical information. Gonsiderable ability to develop information systems that are useful in the field as well as in an office environment. Considerable ability to visualize and work with the spatial aspects of data and to incorporate it into infoxmation systems. ConsideYable ability to success£ully initiate, execute, and manage several complex projects simultaneously. Considerable ability to visualize how a work £low or practice could be implemented in an electronic system. Considerable ability to teach computer skills especially to CAD and GIS users. Considerable ability to maintain self curxent on technical £ields impacting spatially oriented information systems. Working ability to institute e£fective security on systems that must also be readily accessible. Considerable ability to develop and/or adapt information system output media that aYe practical for construction-related field applications. Considerable ability to develop reliable interconnections among a variety of classes of software tools including databases, websites, and application programs. Considerable ability to develop computerized information systems without GIS SYSTEM5 DEVELOPER Page 3 PROPOSED TITLE OF CLASS: standard precedent. MII3IMUM QUALZFICATIONS GIS SYSTEMS DEVEIAPER a�►_q s� Aigh school graduation with courses in algebra and geometry and 15 college credits in mathematics, writing or English, computer sciences, and/or drafting, and 80 houxs of training in CAD, 80 houxs training in GIS, and two years of field experience in a public works environment and three years o£ experience in programming and developing systems in CAD and GIS that are also web-accessible in a constxuction ox public works environment, GIS SYSTEMS DEVELOPEI2 �lq- a �� Compensation Issues Proposed GIS System Developer Position Present Position Title Public Works Technician II Proaosed Position Title GIS System Developer Difference per Pav Period Compensation per uav period $ 1,642.96 Comnensatio�er pay period $ 1,910.77 $ 267.81 Annualized Additional Cost: $ 6,989.84 dt`� -°l 5 q Urban GI5 Systems GIS refers to Geographic Information Systems. These are computer based information systems that have a geographic orientation. The most common systems we see are "text-oriented" or number oriented systems (personnel databases, tax rolls, bank accounts, etc.) While these are sophisticated, the GIS systems contain numerical information which can be associated with a particular place and contains spatial data, such as topogaphy (a three dimensional map), sewer pipe drawings, road bed configurarions, water pipe routes, etc. Often putting this spatial information into a database involves doing things that have never been done before in terms of databases and applications (processing) programs. While this is a technologically challenging field it also has practical value in managing the infrastructure of an urban environment. The process will permit the consolidation of information which is now spread out throughout the City and is being maintained by several staffs. These include databases, other computer fi1es, and even some paper files. These databases do contain redundant infottnation, however the redundancy is necessary to make the disconnected systems function for their primary users. In addition, having the information "scattered" in this fashion makes it more difficult to make relationships that could possibly reduce maimenance costs. Most of these systems are not availab]e to field crews (sewers, water, streets, lights, parks, Police and Fire) who are actually working on a job unless they are transfened to paper format. (Paper format is more susceptible to having out of date information.) However, the GIS format presents the possibility of having portable display formats such as laptop computers that can be brought into the field and used by the crews, thus providing them with instant access to more complete and more curtent information than is now the case. The advantages to the City of properly designed GIS systems include focusing staff efforts, greater accessibility of data, the chance to provide more complete analyses, the possibility for maintaining information more accurately and at relatively less expense, and increased possihility of new and inventive uses in the field which will provide crews with more accurate information. The GIS systems offer significant possibilities for improved management of the City's infrastructure. olq _°ls9 CLASSIFICATION STQDY REPORT CLASS S'I`UDIED: INCUMBENT: STUDIED BY: DATE STUDIED: PERSONS CONTACTED: APPROVAL Public Works Technician II Robert Basques IVTichael F. Foley��j� ✓�� /'L 1/ August 23, 1999 Donald Sobania, Public Works (Manager) Dan Bartholic (Team leader) Robert Basques (Incumbent) George Huschle (I S) LeeAnn Turchin (H-R - Consultant on Public Works I5 Project) HUMAN RESOURCES MANAGEMENT: � (Signature) (Date) Background Public Works has been making an effort to "integrate" the majority of its design and GIS based information into related databases that are readily avai]able. This includes efforts to make relevant data accessible to workers in the field as well as to office staff. This also involved making GIS data compatible with related GIS based systems notably the County and the State. Public Works has allocated several positions out of its e�sting FTE to perform this task. This job profile was submitted by one of the people assigned to this task force. StudXComponents Review of}ob profile Interview with incumbent Interview with H-R Public Works Consultant Interview with Public Works manager Interview with manager in IS Interview with Public Works GIS Team Leader Comparison to class specifications Comparison to other positions QES evaluation and analysis Comparison to Class Specifications �tg ��5� The proposed class specification was compared with exisring class specifications in the EDP Series and in the newer Informarion Series. It was found that existing class specs did not address the responsibiliries of the position in question. The EDP posirions are being phased out since the class specs were obsolete. Progosed Class Spec The new proposed classification specification (attached) captures the responsibilities of the position in question. One important factor in this class spectfication is the idea that the position in question is working with spatially oriented data and this seems to require a particular aptitude and background that may not be possessed by traditional IS people even though they are, themselves, quite imaginative and creative. Conclusion It is recommended that this proposed class speciScation be adopted and the incumbent of the position in question be assigned to it. Comparison to Other Positions The proposed class spec was compared to the positions actually assigned to the EDP Series Positions and those assigned to the newer Infarmation Series. The EDP positions are being phased out since the class specs were obsolete and no satisfactory match was found in the new IS series. Conclusion It is recommended that the position in question be assigned to the proposed class specification. Q. E. S. Evaluation and Analvsis The QES analysis supports ailocation to grade 22T in PEA. Recommendation It is recommended that the position be allocated to the proposed new class specification attached and that this be placed at grade 22T in PEA. �a1-�1s OFFICE OF HUMAN RESOURC: John Hamilton, Director 54IVC P4liL � AAAA CTTY OF SAINT PAUL Norm Colem�m, Mayor FRi3M ;� �Tom Eggum, Director Department of Public Works �eS i I�. Michael F. Foley /� �� 1�71f1��11 � July 13, 1999 aoo ceryxou.v�� 25 Wes[Fourth Sa'eet SaintPmd,Mirsnesota �5102-1631 Telephone: 6I2-266-6500 TDD/CIP.� 672-266-650! JobUne: 612-266-b�02 FacsimiZe: 612-292-76� 6 Twenty Day Notice - Proposed GIS Systems Developer Posirion It has been determined that the tiUe and class spec�carion of GIS Systems Developer should be created. I have attached a copy of the class specification for your review. Please notify me within twenty days of receipt of Yhis memo, if you wish to discuss this action. If I do not hear from you within that timeframe, I will assume agreement and will proceed with the process. Meantime, I will be processin a resolufion to place this posirion in Grade 22T of the Professional Employee I3on-Supervisory Standazd Ranges in Secrion ID 4 of the the Salary Plan and Rates of Compensarion. I hereby waive the time remaining on this 20 day notice for the purpose of creating this title ancl�Cl"a�ss snecificntibn. � cc: Bob Horrisberger Labor Relations Affirmative Action Cindy Mullan (T&MS/IS) 7 Date �� 8 d s l�{' 6�i. S3�at1G�532! N�W�tH '�'t��' `.�� .!!; `� �" ;?�'�; °i°l • °ls � OFFICE OF HUMAN RESOURCES JohnHmtilton, Director GTTY OF SAINT PAUL Norm Coleman, Mayor 7uly 13, 1999 Professional Employees Association Mike Wilde, Business Representative 360 Robert Street I3. Suite # 424 Saint Paul, MN 55101 400CttyHaIIAnnes 25 WestFrn+rth Sveet SaintPmtl,Minnesota 551021631 RE: Twenty Day Notice - Proposed GIS Systems Developer Position Telephone: 612-26b6500 TDD/llY.• 612-366-650I Jobline: 612-266-6502 Facsimile• 612-292-7656 It has been determined that the title and class specification of GIS Systems Deueloper should be created. I have attached a copy of the class specification for your review. Please notify me within twenty days of receipt of this memo, if you wish to discuss this action. If I do not hear from you within that timeframe, I will assume agreement and will proceed with the process. I will also be processing a resolurion to establish the rate of pay for this title in Grade 22T, Section ID3, of the Professional Employees Non-Supervisory Standard Ranges in the Salary Plan and Rates of Compensation. Thank you. � � Mi ael Foley I hereby waive the time remainn�g on this 20 day notice for the purpose of creating this title and class specification. Name �kc Twe��'� Lvt p �" � �� I�� Q �/ �a � S G J(�a 1 �"� � O tl � P c f' I a''+ Date PROPOSED TZTLE OF CLASS: DESCRIPTION OF WORK General Statement of Duties: l � GIS SYSTEMS DEVEIAPER CODE: 660A BU: 06 EFFECTIVE: S� Q� � F Performs professional and technical work in the development, administration, and user access to computer systems involving GIS and CAD that are critical to providing access to in£ormation on the City's infrastructure. Per£orms other duties as assigned or required. Sunervision Received: Receives general administrative supervision from a higher level manager. Supexvision Exercised: Does not exercise formal supervision. Acts as technical advisor, trainer, and project leader as assigned/required. TYPICAL DUTIES PERFORMED The listed examples may not include all the duties performed by all positions in this class. Develops procedures, standards, and conventions for a variety of electronic, especially CAD and GIS related, computer-based project design and permanent record futtctions including project design, as-builts, and maintenance and modifications. Instructs Public Works personnel in various aspects of CAD and/or GIS systems. This includes individual instruction to both inexperienced users and to more sophisticated users and also includes more £ormal, structured training in classroom settings. Oversees some of the Public Works CAD and GIS initiatives and makes recommendations on timing and phasing so that various development initiatives are sequenced to make optimum use of human and technical resources. Creates web sites and associated portions of information systems, especially those dealing with spatial information. Performs research into new developments in information technology and in new ways of applying the technologies. Investigates alternatives and costs and makes recommendations as appropriate. Initiates, designs, and manages projects from inception to completion. Develops technical specifications for software and hardware related to CAD and GIS. Assists in developing RFPs for these purchases. Designs and establishes databases related to CAD/GIS systems. (continued on reverse side) GIS SYSTEMS DEVEIAPER � PROPOSED TITLE OF CLASS GI ��DEVELOPER ' Ensures security for these systems. , Devises and develops interconnections between databases, application � programs, websites, etc. Develops ideas, tools, and methods to get these applications into the field in a p=actical mannet. KNOWLEDGE, SKII.LS, ABILITIES AND COMPETENCZES Page 2 �q_�.SR Considerable lmowledge of CAD and GIS. Considerable knowledge of database. Considerable knowledge of web site development. Working knowledge of Public Works field operations and overall operations. Considerable ability to design and implement in£ormation systems and databases that have a high component of GIS and CAD and that deal with spatial and topographical information. Considerable ability to develop information systems that are useful in the field as well as in an office environment. Considerable ability to visualize and work with the spatial aspects of data and to incorporate it into information systems. Considerable ability to successfully initiate, execute, and manage several complex projects simultaneously. Considerable ability to visualize how a work flow or practice could be implemented in an electronic system. Considerable ability to teach computer skills especially to CAD and GIS users. Considerable ability to maintain self current on technical fields impacting spatially oriented information systems. Working ability to institute effective security on systems that must also be readily accessible. Considerable ability to develop and/or adapt information system output media that are practical for construction-related field applications. Considerable ability to develop reliable interconnections among a variety of classes of software tools including datahases, websites, and application programs. Considerable ability to develop computerized information systems without GIS SYSTEMS DEVEIAPER � PROPOSED TITLE OF CLASS standard precedent. MINIMUM QUALIFICATIONS �� GIS SYST�MS` DE�IEIAPER Page 3 a°�-q s� Aigh school graduation with courses in algebra and geometry and 15 college credits in mathematics, writing or English, computer sciences, and/or drafting, and 80 hours of training in CAD, 80 hours training in GIS, and two years of field experience in a public works environment and three yeaxs of expeYience in programming and developing systems in CAD and GIS that are also web-accessible in a construction or public works environment. GIS SYSTEMS DEVEIAPER