Application Development Analyst (WebFocus, JCL, SQL, IBM DB2, data governance, data reports)

FLDOT-1250

Primary Job Duties / Tasks

Duties of the selected candidate will include, but not be limited to :

• Analyze current Focus programs and WebFocus reports and document the specifications for these programs and reports.
• Work with management to develop an overall remediation strategy for all Focus programs and reports.
• Analyze existing reports and work with business users to determine how these reports can be improved based on current business needs.
• Read and document WebFocus and Mainframe Focus queries and convert them to T-SQL queries.
• Work with database administrators from the Office of Information Technology to create database views and stored procedures that will facilitate the remediation of WebFocus reports.
• Update Focus programs to encapsulate chart of account changes mandated by Florida PALM.
• Update WebFocus Reports to encapsulate chart of account changes mandated by Florida PALM.
• Convert Focus mainframe programs using mainframe flat files as a data source to use database tables instead.
• Analyze financial data and make recommendations to improve the data model of financial systems.
• Provide administration of the WebFocus environment for the dedicated PALM remediation environment.
• Perform knowledge transfer with technical staff of the office of the Comptroller.

Experience

Candidate MUST have a minimum of 2 years' experience in Tibco Mainframe Focus or WebFocus.

Application Development Analyst :

Key Knowledge, Skills and Abilities

The submitted candidate must be able to apply common knowledge, skills, and abilities in the following areas :

J-18808-Ljbffr