View all jobs

Systems Analyst 3

Madison, WI
Job Description
Understands business objectives and problems, identifies alternative solutions, performs feasibility studies and cost/benefit analysis of alternatives. Analyzes user requirements, procedures, and problems to automate processing or to improve existing computer system: Confers with personnel of organizational units involved to analyze current operational procedures, identify problems, and learn specific input and output requirements, such as forms of data input, how data is to be summarized, and formats for reports. Writes detailed description of user needs, program functions, and steps required to develop or modify computer program. Reviews computer system capabilities, specifications, and scheduling limitations to determine if requested program or program change is possible within existing system.
Studies existing information processing systems to evaluate effectiveness and develops new systems to improve production or specifications as required. Prepares specifications to detail operations to be performed by equipment and computer programs and operations to be performed by personnel in system. Conducts studies pertaining to development of new information systems to meet current and projected needs. Plans and prepares technical reports, memoranda, and instructional manuals as documentation of program development. Upgrades system and corrects errors to maintain system after implementation. May assist computer programmer in resolution of work problems related to project specifications, or programming. Develops backup and recovery procedures. Evaluates outcomes. May prepare time and cost estimates for completing projects. May direct and coordinate work of others to develop, test, install, and modify programs. Systems Analyst capabilities with 8 or more years of experience, relies on experience and judgment to plan and accomplish goals, independently performs a variety of complicated tasks, a wide degree of creativity and latitude is expected.

This contract is for legislatively mandated enhancements to DNR's Waterway and Wetland Protection Database (WWPDB) identified in the recently passed biennial budget. WWPDB is an Oracle database with an

ASP.NET user interface in an intranet environment. Specifically:

1) Develop document storage for non-permit documents:
The first part of this project would analyze potential document storage areas - expanding BLOB storage within WWPDB, adding on to the E-Permitting system, connecting to the SWIMS Electronic Guidance and Documents (EGAD) module, or some other option, make a decision as to which path to pursue, and do the work of building the storage infrastructure and associated user interface to allow DNR staff to upload documents.

2) Implement a public interface for document download:
The second part of this project will be to provide an interface for the public to download the documents described above. We currently envision using the map-based interface of the Surface Water Data Viewer (SWDV) to accomplish this - a user "clicks" on a point of interest on the map, gets data currently stored in WWPDB and a link to download any associated documents. A similar approach has been used by the water quality monitoring and assessment program, and we may be able to use part of their work for this. The WWPDB File Manager will collaborate with the SWDV Manager to implement this interface in the existing SWDV framework.

3) WD E-Permitting system integration and other smaller changes/enhancements:
The two items above will have top priority with the expected budget allocation. Any leftover contractor hours will be used to wrap up integration with the SharePoint e-permitting system and cover other small enhancements like additional date fields, any updates to the Embeddable Locator Tool (ELT), etc.
Powered by