1E76

PAY RANGE: EP19

 

PROGRAMMER ANALYST 2

 

GENERAL DEFINITION

 

            This is intermediate level computer programming and analysis work.  Employees in this class perform a variety of assignments analyzing require­ments for computer services, determining how to meet computer requirements and developing programs.    This class is differentiated from the lower level class by an increased emphasis on systems analysis and increased independence of performance.  The employees specialize in the use of a designated computer language within a system environment or use one or more of the designated computer languages, including fourth generation languages.  The employee works under the direction of a technical supervisor.

 

TYPICAL EXAMPLES OF WORK (ILLUSTRATIVE ONLY)

 

            Performs systems analysis for new or existing application requests; meets with users to discuss requests and user objectives; analyzes use requirements; determines how the system that is to be computerized works manually or reviews the system specification and documentation of an existing system to determine the current design; confers with system users and managers and supervisors; assists in preparation of needs or cost benefit analysis; develops systems logic and work flows; determines what modules to include; designs the data base, data file and screen layout and determines record number and size; modifies and maintains the data base; designs user access parameters to provide file security; writes back-up and recovery procedures to protect against lost of data; evaluates paper flow, task time, human resources and other external and interrelationship factors that will impact upon  the proposed or modified system; develops a preliminary program specification, taking all the collected data and information into consider­ation. 

            Designs program logic to meet specifications and conformance to standards; codes program in appropriate language; prepares work flow process documentation; determines the size and number of files and records; tests programs; creates test data; checks input for accuracy and completeness; trouble-shoots existing programs to identify problems; periodically meets with users to identify problems; writes narrative explanations of programs; prepares forms and documentation.

            Confers with supervisor, project leaders and user representatives to determine objectives and user requirements; periodically analyzes assigned system components to determine adequacy; develops recommended improvements; periodically confers with representatives of user agencies to determine if systems and programs are meeting requirements.  Assists other agencies in systematizing non-computer projects; may train operating department personnel in the use of computer applications; may meet, as part of a team, with other City agencies and computer consultants and vendors regarding new systems or revisions to existing systems.

            Attends education training sessions when appropriate.

            Performs related work as required.

 

REQUIRED KNOWLEDGES, SKILLS AND ABILITIES

 

KNOWLEDGE OF:

 

•           the theory and practice of systems analysis

•           the theory and practice of systems design

              the principles, methods and process of Software Development Life Cycle (SDLC)

•           the application and techniques of programming for the appropriate computer language

•           documentation procedures

•           the current uses, capabilities and configurations of electronic data processing equipment

•           the theory and practice of procedures analysis

•           source code language programming and appropriate control languages

•           at least one data base management system, such as ADABAS, Oracle Database, SYBASE, Microsoft SQL Server, DB2 or VSAM file access method

•           the methods and techniques used in the evaluation and analysis of software, hardware and application systems to achieve efficient system utilization

•           the methods and techniques used in protecting systems security

              one or more of the following programming languages: C#, VB.NET, JAVA, JavaScript, HTML, XML, COBOL, NATURAL, PowerBuilder, PL/SQL or T-SQL

 

ABILITY TO:

 

•           learn the applications of new software packages

•           interpret and apply information in technical manuals

•           think logically and sequentially

•           present ideas clearly, both orally and in writing

•           communicate data processing concepts to non-technical

•           analyze complex organizational and procedural problems

              develop and implement project plans

•           complete work within the confines of a time schedule

•           establish effective working relationships with associates, departmental and administrative officials, supervisors, and other data processing personnel

 

MINIMUM ACCEPTABLE TRAINING AND EXPERIENCE  (The following statement represents the minimum training and experience standards which will be used to admit or reject applicants for tests.  Applications submitted by candidates for this class will be reviewed based on training and experience requirements as approved on 5/13.)

 

EDUCATION:

 

            Completion of a bachelor's degree program at an accredited college or university, with major course work in Computer Science, Decision Science, Information Systems, or a closely related field

 

AND

EXPERIENCE

 

            Two years of experience performing computer programming and analysis work, one year of which shall have been above the trainee level.

 

OR

 

            Any equivalent combination of education and experience which has included completion of a bachelor's degree program which has included or has been supplemented by eighteen (18) semester hours of course work in computer science, decision science or information science and which has been determined to be equivalent by the Office of Human Resources.

 

PHYSICAL AND MEDICAL REQUIREMENTS

 

            Ability to physically perform the duties and to work in the environmen­tal conditions required of a position in this class.

 

NOTE: Employees with experience in the classes listed below can substitute extra experience on a year for year basis, for the required education specified above.

        

Information Technology Trainee (1E70)

               Programmer Analyst 1 (1E75)

 

Class Established 5/62

Spec. Revision: 12/95

Latest Spec. Revision:

CSC: 4/13

Ad. Board: 5/13

 

CW