Job ID: FL-PR775259-R154871 (911590617)
Hybrid/Local WebFOCUS Developer (12+) with FOCUS Masters, SQL Pass-through, Power BI Desktop, Paginated Reports, SQL Server/DB2, CICS, TSO, JCL, ISPF, data conversion/cleansing experience
Location: Tallahassee, FL (DOT)
Duration: 12 Months
8 Job Specific Knowledge, Skills, and Abilities (KSAs)
The submitted candidate must be able to apply common knowledge, skills, and abilities in the following areas:
1. Skill in developing and maintaining FOCUS and Web FOCUS programs and access methods using FOCUS Masters and SQL Pass-through.
2. Skill in developing and maintaining Power BI Desktop and Paginated Reports.
3. Skill in developing and maintaining SQL (Structured Query Language) statements, Views, and Stored Procedures for MS SQL Server and DB2 databases.
4. Ability to review programs for the afore-mentioned technologies and determine and document program flow, business rules/logic, inputs/outputs, and database actions included.
5. Knowledge of the principles, practices and techniques of documenting, maintaining and testing existing computing applications.
6. Knowledge of relational database theories and concepts.
7. 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).
8. 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.
9. Ability to plan, organize, coordinate, and prioritize work assignments for him/herself or lower-level analysts.
10. Skill in accurately estimating time requirements for computer programming tasks in a computer application maintenance environment.
11. 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.
12. Skill in mentoring junior developers in WebFOCUS/FOCUS and Power BI.
13. Ability to analyze processes and workflows to design efficient information solutions.
14. Ability to prepare complex computer program specifications.
15. Ability to prepare computer program test plan and to create test databases and test environments.
16. Ability to interact and collaborate directly with customers, technical staff, and management.
17. Skill in interpreting and communicating technical information both verbally and in writing.
18. Ability to develop and manage technical documentation in accordance with the Department’s standards.
19. Strong working knowledge of Microsoft Office.
20. Experience working on accounting and financial computing applications and monitoring complex interfaces with external systems.
Preferred KSAs:
21. Accounting, Financial, Computer Science or Management Information Systems (MIS) related degree.
22. Skill in data conversion techniques, data cleansing approaches and validating data relationships.
23. Knowledge of the Florida Accounting Information Resource (FLAIR) system, including transaction type details and interfacing methods.
24. Knowledge of the Office of Comptroller’s internal applications, reporting systems, and interfaces.
25. Knowledge of the Office of Work Program and Budget’s internal applications, reporting systems, and interfaces.
26. Knowledge of the new Florida PALM initiative and financial application.
9 General Knowledge Skills and Abilities (KSAs)
The submitted candidate must be able to apply common knowledge, skills, and abilities in the following areas:
1. Communication: Ability to clearly convey information, in both written and verbal formats, to individuals or groups in a wide variety of settings (i.e., project team meetings, management presentations, etc.). Must have the ability to effectively listen and process information provided by others.
2. Customer Service: Works well with clients and customers (i.e., business office, public, or other agencies). Able to assess the needs of the customer, provide information or assistance to satisfy expectations or resolve a problem.
3. Decision Making: Makes sound, well-informed, and objective decisions.
4. Flexibility: Open to change, new processes (or process improvement), and new information. Has the ability to adapt in response to new information, changing conditions, or unexpected obstacles. Ability to receive and give constructive criticism and maintain effective work relationships with others.
5. Interpersonal: Shows friendliness, courtesy, understanding, and politeness to others.
6. Leadership: Motivates, encourages, and challenges others. Adapt leadership styles in a variety of situations.
7. Problem Solving: Ability to identify, evaluate, and use sound judgement to generate and evaluate alternative actions, and make recommendations as accordingly.
8. Team Building: Encourages, inspires, and guides others toward accomplishing the common goal.
5 Education
Bachelor’s or Master’s Degree in Computer Science, Information Systems, or other related field. Work experience can substitute on a year for year basis for the degree.
6 Experience
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.
7 Primary Job Duties/ Tasks
The submitted candidate must be able to perform the following duties and/or tasks:
1. Perform advanced 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.
2. 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.
3. 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.
4. 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.
5. 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.
6. 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.
7. Confer with Central Office and District personnel to ensure the Office of Comptroller systems are performing as required.
8. Mentor, advise and assign tasks to junior staff to ensure remediation efforts are completed within the agreed upon timeframe.
F-Resume-Self-Certification-Form.docx