Allowed Work Authorization US Citizen Green card Holder TN Visa GC EADH4EAD
Job Title: MAINFRAME Developer Focus/WebFocus Developer
Job Location: Tallahassee FL (hybrid3 days onsite)
Job Duration: 12month contract
Job Overview:
- 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 TSQL 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.
Required Experience: - MUST have a minimum of 2 years experience in Tibco Mainframe Focus or WebFocus.
- Experience developing programs in mainframe Focus.
- Experience developing processes and reports in WebFocus.
- Familiarity with IBM mainframe and Job Control Language (JCL).
- Strong SQL skills and experience with the IBM DB2 relational database management system
- Well versed in data governance best practices.
- Experience creating reports presenting financial data such as general ledger data purchasing data or revenue data.
- Analytical thinking for creating relevant data reports based on end user requirements.
- Understanding of how to implement solutions with multiple data sources.
Preferred Experience: - Knowledge of modern reporting tools such as MS Power BI IBM Cognos and Tableau
- Knowledge of the SCRUM Framework
- Knowledge of financial systems such as an ERP
- Familiarity with data management concepts such as Data Warehousing Operational Data Stores Data Lakes and Master Data Management