Job Descriptions & Pay
APPLICATIONS SYSTEMS ANALYST
|Class Title:||APPLICATIONS SYSTEMS ANALYST|
|Salary Schedule:||Approved Arizona Law Enforcement Merit System Council Salary Schedule|
|Summary Statement:||Under direction, the Applications Systems Analyst is responsible for planning, designing, and implementing major information systems; functions as a coordinating systems analyst; and performs related work as required. This is a competitive classification.
|Essential Functions:||(not intended to be all inclusive)
1. Designs on-line automated systems to provide new and/or enhanced applications, using mainframe/ personal computer hardware and software.
2. Designs data entry and query screen layouts; report layouts, and file layouts for mainframe and client server systems to outline the user interface using a mainframe/personal computer, hardware, software, and system utilities tools.
3. Writes and revises program and system specifications to create directions for development and modifications of program code using a mainframe/personal computer, hardware, and software.
4. Develops testing plans and tests and reviews new and modified systems and programs to ensure all programs and systems meet client specifications and needs, section standards and guidelines, and efficiency requirements using programming and systems expertise.
5. Analyzes existing applications and systems to determine needed modifications and/or enhancements using a mainframe/personal computer and knowledge of the assigned systems.
6. Supervises subordinate technical personnel to provide direction and feedback, and ensure assigned projects and tasks are completed accurately and by the specified due date using time management skills and knowledge of staff assignments.
7. Plans, monitors and controls several assigned projects concurrently to effectively use time and programming resources using a mainframe/personal computer, time management skills, and project management software.
8. Interviews Department and outside clients to determine system requirements using technical expertise.
9. Evaluates business problems and revised operational procedures to identify potential enhancements to assigned systems to meet changing business requirements using technical expertise.
10. Reviews and approves the work of subordinate technical staff (e.g. electronic forms, job documentation, program code, etc.) to ensure information is correct and complete using a mainframe/personal computer and technical expertise.
11. Reviews, with subordinate technical staff, mainframe and/or client/server program specifications for new applications, modifications to existing applications and ad hoc reports to ensure a clear understanding of user requirements using a mainframe/personal computer and software.
12. Diagnoses and corrects computer programs and systems to identify and solve problems using mainframe/ personal computer hardware and software.
13. Conducts and/or attends administrative and/or technical meetings or conferences to obtain and/or disseminate information regarding assigned work area issues.
14. Serves as a technical liaison between the work unit and other segments of the Department or outside agencies to investigate and resolve problems, and facilitate proper use of assigned systems using a mainframe/personal computer, modern office equipment, and personal contacts.
15. Establishes performance measures, goals, objectives and priorities for subordinate technical personnel utilizing applicable management principles, and Department General Orders, policies, and procedures.
16. Evaluates subordinate employees' work performance to advise staff of requirements and expectations of the position and provide feedback regarding work performance using evaluation documentation and evaluation forms.
17. Communicates in writing with Department employees, other agencies and the general public to provide information and resolve issues using a mainframe/personal computer.
18. Estimates required resources to complete tasks in assigned projects in order to project completion dates and aid in scheduling, using a mainframe/personal computer and scheduling/tracking applications.
19. Interprets and disseminates information applicable to assigned systems (e.g. time and activity, overtime, leave policies, state statutes, laws, administrative rules, general policies and procedures etc.) to provide responses to questions using a mainframe/personal computer, state statutes, and Department General Orders, policies and procedures.
20. Reviews and comments on various documents (e.g. topic papers, technical reports, project proposals, etc.) to ensure the Department has information on the impact of such proposals on the Department automated systems, assess technical feasibility, and present alternative proposals using a mainframe/personal computer, written communication skills, and technical expertise.
21. Develops, implements, and monitors project schedules to ensure all affected parties are aware of the various time commitments, resources available, and current status of projects, using a mainframe/personal computer and electronic project scheduling and tracking programs.
22. Writes, updates and submits routine, periodic, and special reports to provide information (e.g. project status, description of new computer systems, enhancements to existing systems, etc.) to clients and management using documentation of activities and time spent, a mainframe/personal computer, software, and electronic mail systems.
23. Remains current on job-specific and departmental topics through training courses, workshops, seminars, professional organizations, professional publications, etc. to apply appropriate policies and technologies to assigned systems.
24. Prioritizes and schedules client requests to ensure the most critical needs for assigned systems are completed in a timely manner using a mainframe/personal computer.
25. Develops detail project plans to identify tasks, task dependencies, critical path and staffing requirements to develop and implement assigned mainframe and client/server systems using a mainframe/personal computer, project management software, and technical expertise.
26. Designs large-scale batch systems to provide new and/or enhanced applications using a mainframe/personal computer, UNIX server, hardware and software.
27. Prepares charts, diagrams, correspondence and technical documents to support clients in understanding the data and work flows, procedures, processes, scope and objectives of a new automated system using a mainframe/personal computer, software, hardware, technical expertise and modern office equipment.
28. Coordinates the installation of new and modified systems with Section personnel to ensure online and batch interfaces with other Department applications function correctly using a mainframe/personal computer and modern office equipment.
29. Assists clients with questions and problems on assigned systems to enable clients to obtain accurate and complete information and understand how to use the system, using modern office equipment and knowledge of the systems.
30. Schedules, monitors, develops and conducts training for subordinate technical staff to ensure they have the needed knowledge, skills and abilities to perform their jobs, using technical knowledge.
31. Develops ad hoc programs, or runs existing programs, to generate special reports and/or file searches to meet client requirements using a mainframe/personal computer, hardware, software, systems expertise, and appropriate programming languages.
32. Monitors data in mainframe and client/server files to ensure data entered into applications is correct, using a mainframe/personal computer and knowledge of the applications.
33. Codes and modifies online and batch mainframe modules and/or client/server modules for new applications and processes, or modifications to existing applications and processes using mainframe/personal computer hardware and software and technical expertise.
34. Coordinates the installation of new and modified systems with computer interface agencies to ensure all agencies have simultaneous access to new and modified systems using modern office equipment.
35. Assists technical staff in the resolution of mainframe, personal computer, and client/server problems using a mainframe/personal computer and technical expertise.
36. Develops and conducts training on assigned systems to enable trainers throughout Arizona (e.g. D.S., outside agencies, etc.) to prepare and conduct training for system users, using mainframe/personal computer hardware and software, oral and written communication skills, and training documentation.
37. Gathers and analyzes data to provide accurate information for briefings, reports and correspondence using modern office equipment and mainframe/personal computer hardware and software.
38. Maintains validation/security tables and disseminates information for assigned systems to validate data and ensure system users can access automated systems, using a mainframe/personal computer, hardware, and software.
39. Composes written test questions, training and experience supplements and interview questions to evaluate technical expertise of prospective employees and outside technical consultants using a mainframe/personal computer, software, technical expertise and modern office equipment.
40. Interviews applicants for vacant technical positions and temporary contract programming services to evaluate their technical capabilities using technical expertise and Department policies and procedures.
41. Provides direction to clients on the design and layout of new or enhanced pre-printed forms for computer data entry using a mainframe/personal computer, software, hardware and technical expertise.
42. Implements mainframe and/or client/server modules in a production environment for new applications and processes or modifications to existing applications and processes to provide system accessibility to the client using mainframe/personal computer hardware and software, and technical expertise.
43. Extracts data from mainframe/personal computer and/or client/server files and databases to be loaded to files and databases on different platforms to replicate data for cross-platform applications using a mainframe/ personal computer, software, and technical expertise.
44. Modifies mainframe and client/server database files to incorporate organizational and other widespread changes for applications to function properly using mainframe/personal computer hardware and software and technical expertise.
45. Recommends database structure changes to enhance the performance of the database, ensure the database is defined correctly, and ensure the database meets functional specifications using a mainframe/personal computer and technical expertise.
46. Researches commercial mainframe and client/server software development tools to improve staff productivity using professional organizations/publications, a mainframe/personal computer, software and the Internet/World Wide Web.
47. Writes training documentation of systems to use as the basis for developing training modules for system users utilizing a mainframe/personal computer, hardware, and software.
48. Writes applications and systems documentation to provide written support and backup of program functions using a mainframe/personal computer, hardware, and software.
49. Assists co-workers with mainframe, personal computer, and client/server development tools and hardware and software using a mainframe/personal computer and technical expertise.
50. Prepares and delivers oral and graphic presentations to small and large groups to provide information and answer questions regarding information systems functions and Department automation using presentation skills and mainframe/personal computer hardware and software.
51. Assists trainers in writing training documentation to ensure documentation is correct and complete using technical expertise and interpersonal skills.
52. Evaluates and makes recommendations on commercial software to improve programmer productivity and client services using a mainframe/personal computer, technical expertise, and knowledge of client and Department requirements.
53. Prepares Requests for Proposals, requisitions, and other documents to obtain outside programming services for assigned projects, and to select and obtain commercial software and application development tools to improve productivity of staff and client services, using a mainframe/personal computer and modern office equipment.
54. Serves in the absence of the supervisor to ensure efficient operation of affected area.
55. Prepares and submits grant proposals, budgets, reports to obtain funding for projects using mainframe/personal computer.
56. Monitors grants to ensure project is on schedule and within budget and meets grant objectives using mainframe/personal computer and project management skills.
57. Represents the Department at multi-agency meetings, committees, task forces to present information or support the Department's position using appropriate reports, documentation, and technical expertise.
58. Leads and/or serves on multi-agency task forces to facilitate the development/implementation of new or modified automated systems using technical expertise.
59. Coordinates development, testing, and implementation of new or modified computer systems with outside agencies to ensure interfaces with other agencies' systems using mainframe/personal computer and technical expertise.
60. Manages application software support for the Arizona Criminal Justice Information Systems (ACJIS) to coordinate projects, use resources efficiently, and meet customer needs using knowledge of automated systems, technical expertise, and project management skills.
|Knowledge, Skills, & Abilities Required:||Knowledge of:
1. professional standards for systems development and documentation.
2. the principles, concepts, capabilities and operations of large-scale mainframe digital computer hardware, data storage devices and peripherals (e.g. MVS/ESA mainframe computer, character-based terminal, keyboard, laser and line printer, direct access disk drives, magnetic tape reels, etc.).
3. the physical design and principles of relational database models and entity-relationship diagramming.
4. batch processing for custom developed applications in the mainframe and microcomputer environments.
5. third generation programming languages (e.g. COBOL, ANSI-C, PL/SQL, CICS command level, Adaprep, etc).
6. the principles and techniques of function-oriented system analysis and design.
7. efficient mainframe terminal character based screen design standards and techniques.
8. project estimating techniques.
9. the waterfall life cycle model and methodologies of systems development.
10. the processes, techniques and tools of project management. technical computer terminology.
11. data modeling principles and techniques for computer file storage.
12. the internal representation of the data in electronic data storage (e.g. EBCDIC and ASCII character sets, packed, numeric formats, etc). Knowledge of the principles and concepts of teleprocessing monitors to develop real time, interactive applications (e.g. CICS).
13. on-line, synchronous transaction processing for custom developed applications.
14. various types of mainframe computer file organizations and file access methods (e.g. sequential, partitioned, indexed sequential, virtual storage access method, generation datasets, etc).
15. high-end database management systems (e.g. Oracle, Adabas, etc.) and their data dictionaries.
16. current technological trends for mainframe, client/server, and personal computer information systems.
17. various communication techniques between application components (e.g. program-to-program method, message queuing method, etc).
18. advanced mathematical calculations and statistics.
19. computer interfaces with outside agencies.
20. federal and state laws, regulations, policies, procedures concerning security and privacy of automated systems.
21. the criminal justice system: terms, concepts, processes.
22. assigned applications systems.
23. system design requirements and programming techniques for multiple networks: ACJIS, MIS, NCIC, NLETS, DOA, SWBS.
1. effectively communicating in writing for both administrative and technical purposes.
2. accurately interpreting statutes, laws, policies, procedures and written instructions.
3. developing and maintaining effective working relationships with individuals at all levels of an organization.
4. reviewing, interpreting, and proofreading comprehensive, analytical, statistical, technical, and administrative reports, documents, and manuals.
5. flowcharting business procedures, functions, data flow and work processes.
6. translating manual work procedures and processes into automated computer programs and systems.
7. the use of on-line editors and computer keyboard devices to create and/or modify data in computer files, code programs, and create and/or modify reports and system documentation.
8. system testing applications to identify performance, data integrity, communication and functionality problems and ensure the programs are corrected accordingly.
9. developing logical conclusions and implementing practical solutions to highly complex technical and business problems.
10. effective time management and organization techniques.
11. identifying, researching, analyzing and interpreting technical information from a variety of sources to resolve complex problems, (e.g. design, code, debug, etc.) custom developed applications.
12. performing multiple highly complex tasks concurrently.
13. analyzing highly complex systems and programming specifications to develop logical coding.
14. recognizing hardware and software problems and implementing effective solutions (e.g. mainframe, personal computer, client/server, etc.).
15. effective listening.
16. developing function-oriented applications.
17. describing problems, alternatives, and making recommendations.
18. solving highly complex logic problems.
19. applying various application design techniques for multiple computer systems.
20. providing technical training, direction, and guidance to subordinates, peers, and clients.
21. defining data models in logical views and various types of physical data structures.
22. analyzing user needs to design appropriate system modifications or new applications to meet the identified requirements.
23. developing highly complex systems and programming specifications.
24. adjusting priorities and work schedules as necessary to meet project deadlines.
25. coding basic and advance mathematical calculations in various programming languages.
26. analyzing and interpreting the contents of a computer's memory and main storage information in a dump to resolve complex and comprehensive application development and operational problems that occur during computer program execution.
27. using debugging tools and techniques for identifying causes of logic problems in custom developed applications.
28. using mainframe operating system job control language (OS/JCL).
29. selecting the best tool on various platforms (mainframe, personal computer, UNIX, etc.).
30. integrating applications which extend across sections of the organization.
1. maintain confidentiality of sensitive information.
2. learn and apply new technical knowledge and skills.
|Minimum Qualifications:||Requires three (3) years of experience as a Computer Programmer/Analyst with the Arizona Department of Public Safety; OR any combination of course work in computer science, management information systems, or a related field from an accredited college, technical school or university and experience in systems design and programming to total five (5) years.
Progression to the next pay level/step requires an overall performance rating of at least "Standard" in the last 12 months.
One (1) year of work experience is equivalent to 30 semester (45 quarter) hours of course work from an accredited college or university.
Must successfully complete the examination process.
FLSA Status: Non-Exempt
Current as of: 6/19/2013 6:52:13 PM