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 requirements 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 consideration.
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 work in one or more designated computer languages in the area of assignment.
Performs related work as required.
REQUIRED KNOWLEDGE, 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)
• 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
SKILL IN:
• the application and techniques of programming for approved application/system development languages and tools within the system environment
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/24.)
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.
NOTE: 1) Employees with experience in the classes listed below can substitute additional experience on a year for year basis as specified above for the required education.
Information Technology Trainee (1E70)
Programmer Analyst 1 (1E75)
NOTE: 2) Completion of current, specialized industry recognized certifications related to the area of assignment may substitute for the required education on a year for year basis.
Any equivalent combination of education and experience which has been determined to be acceptable by the Office of Human Resources which has included the experience.
PHYSICAL AND MEDICAL REQUIREMENTS
Ability to physically perform the duties and to work in the environmental conditions required of a position in this class.
Class Established 5/62
Spec. Revision:
CSC: 4/13
Ad. Board: 5/13
Latest Spec. Revision:
CSC: 9/21
Ad. Board: 11/21
Latest Spec. Revision:
CSC – 4/24
Ad. Board – 5/24
JA