Job ID :
41071
Company :
Internal Postings
Location :
Tallahassee, FL
Type :
Contract
Duration :
12 Months
Salary :
DOE
Status :
Active
Openings :
1
Posted :
24 Jun 2024
Job Seekers, Please send resumes to resumes@hireitpeople.com

Job Responsibilities:

  • Perform technical assessments and define the impact on reporting and local computing applications as a result of Florida PALM. Produce written deliverables including, but not limited to architectural diagrams, technical specifications and narratives, interface requirements, and supporting functional or technical analyses.
  • Review Florida PALM interface offerings, file definitions, and standardized business processes to determine remediation required for Department financial related computing assets. Address dependencies with other interfacing computer applications. Propose potential decommissioning for unused computing assets.
  • Address remediation requests for local computing applications and WEB based inquiries for FDOT budget management, program development, cost accounting, funds authorization/reimbursement, and funds approval functions. Coordinate with application owners to identify essential financial related information for complex reconciliation efforts and validation of end results.
  • Provide detailed data element mapping of inputs and outputs with other systems interfacing with FDOT maintained applications impacted by the Florida PALM transition efforts. Inputs can include manual data entry, direct access to other systems, and batch uploads. Outputs can include data extracts, direct access to data from other systems, and reports.
  • Participate in validation of Florida PALM data configuration workbooks and supporting data conversion analyses of Department data to align with revised data structures. Develop data conversion programs to convert data within Department financial related computing assets.
  • Develop testing strategies, data scenarios and test plans to ensure computing asset modifications are tested properly beginning with unit testing and extending through Florida PALM cycle testing phases.

Job Description:

  • The submitted candidate must be able to apply common knowledge, skills, and abilities in the following areas:
  • Skill in developing and maintaining FOCUS and Web FOCUS programs and access methods using FOCUS Masters and SQL Pass-through.
  • Skill in developing and maintaining Power BI Desktop and Paginated Reports.
  • Skill in developing and maintaining SQL (Structured Query Language) statements, Views, and Stored Procedures for MS SQL Server and DB2 databases.
  • Ability to review programs for the afore-mentioned technologies and determine and document program flow, business rules/logic, inputs/outputs, and database actions included.
  • Knowledge of the principles, practices and techniques of documenting, maintaining and testing existing computing applications.
  • Knowledge of relational database theories and concepts.
  • Knowledge of mainframe computer systems and supporting software such as Customer Information Control System (CICS), Time Sharing Option (TSO), Job Control Language (JCL)
  • and Interactive System Productivity Facility (ISPF).
  • Ability to work independently in the technical analysis, evaluation and resolution of custom- written computer application production issues or problems, with little or no assistance, and to
  • make decisions and recommendations to remediate those issues or problems.
  • Ability to plan, organize, coordinate, and prioritize work assignments for him/herself or lower-level analysts.
  • Skill in accurately estimating time requirements for computer programming tasks in a computer application maintenance environment.
  • Ability to work effectively with Project Managers, Business Analysts, Data Analysts, and Technical Architects to build efficient, viable solutions in the maintenance of business applications utilizing all established departmental standards.
  • Ability to analyze processes and workflows to design efficient information solutions.
  • Ability to prepare complex computer program specifications.
  • Ability to prepare computer program test plan and to create test databases and test environments.
  • Ability to interact and collaborate directly with customers, technical staff, and management.
  • Skill in interpreting and communicating technical information both verbally and in writing.
  • Ability to develop and manage technical documentation in accordance with the Department standards.
  • Strong working knowledge of Microsoft Office.
  • Experience working on accounting and financial computing applications and monitoring complex interfaces with external systems.

Candidate MUST have:

  • A minimum of 10 years of systems analysis and programming experience.
  • A minimum of 5 years of FOCUS and WebFOCUS programming experience inclusive of FOCUS 4GL, WebFOCUS Application Studio and Report Caster.
  • A Minimum of 3 years of Microsoft Power BI development experience inclusive of Power BI Desktop, Power BI Paginated Reports, and Power BI Dataflows.
  • A minimum of 5 years of Structured Query Language (SQL) experience inclusive of SQL syntax, views and stored procedures.
  • A minimum of 5 years of broad IBM Mainframe development experience inclusive of but not limited to ISPF, JCL, COBOL, DB2 for z/OS or similar relational databases.

Preferred Qualifications:

  • Accounting, Financial, Computer Science or Management Information Systems (MIS) related
  • degree.
  • Skill in data conversion techniques, data cleansing approaches and validating data
  • relationships.
  • Knowledge of the Florida Accounting Information Resource (FLAIR) system, including
  • transaction type details and interfacing methods.
  • Knowledge of the Office of Comptroller’s internal applications, reporting systems, and
  • interfaces.
  • Knowledge of the Office of Work Program and Budget’s internal applications, reporting