Job ID: FL-PR548565-R101004 (910590619)
Onsite/Local .Net Developer (12+) with C#, VB.net, ASP.net/MVC, WCF/Web API, Web Forms, Angular, Knockout, REST, JSON, data modeling, Azure, SQL Server, JCL, Cobol, DB2, z/OS and OOP experience
Location: Tallahassee, FL (DOT)
Duration: 23 Months
Position: 1
4 Scope of Services
Background:
The Florida Planning, Accounting, and Ledger Management (PALM) project is a multiyear endeavor to replace the State of Florida’s accounting and cash management systems with a modern financial management solution. The Florida PALM Project has a timeline that is broken down into distinct periods:
• Central and Departmental Wave – transition to Florida PALM for both Central and Departmental FLAIR functionality.
• Payroll Wave – transition to Florida PALM for Payroll functionality.
There are over 1,700 interfaces, enterprise applications, databases, automated processes, and reporting programs within FDOT that will require remediation due to:
• Transition to the Florida PALM Chart of Accounts values
• Replacement of Central, Payroll and Departmental FLAIR functionality
• Redevelopment of agency incoming and outgoing interfaces to the statewide accounting system
• Implementation of Information Warehouse data to support agency specific reporting requirements.
The computing asset modifications to complete the FDOT transition to the Florida PALM solution will take place over the course of three years in alignment with the Florida PALM Project scheduled timeline.
Problem Statement:
Included in the inventory of computing assets that must be transitioned to the Florida PALM solution are local computing applications and a reporting infrastructure to address core functional needs and to facilitate complex reconciliations for the management of budget and processing of actual financial results. The Department also has over 100 interfaces to/from the Department of Financial Services (DFS) Florida Accounting Information Resource (FLAIR) system. As part of the Florida PALM System Transition (FPST) Project, impacts to the Department’s computing assets must be determined and the applications must be remediated to interface with the Florida PALM system solution. In addition, computing assets must be analyzed to determine if there are any that need decommissioning. To allow for the transition to the Florida PALM solution, we are requesting a systems analyst position for the analysis and remediation efforts of the Department’s impacted financial related computing assets. The new position’s concentration will be the review of Florida PALM interface requirements, the analysis and remediation of impacted computing assets, and validation of modified computing assets during Florida PALM cycle testing.
5 Education
Bachelor’s Degree in Computer Science, Information Systems, or financial related field. Or equivalent work experience.
6 Experience
A minimum of 5 years of systems analysis/programming experience, with specific emphasis in Microsoft .NET, (C#, VB.NET), ASP.NET/MVC, WCF/WebAPI, ASP.NET Web Forms, JavaScript frameworks (Angular, Knockout, and others), REST, XML, JSON, HTML, and CSS.
7 Primary Job Duties/ Tasks
The submitted candidate must be able to perform the following duties and/or tasks:
1. Perform technical assessments and define the impact on the Department’s complex financial business processes on large cross-functional computing assets as a result of Florida PALM. Produce written deliverables including, but not limited to architectural diagrams, technical specifications and narratives, interface requirements, and supporting technical analyses.
2. Review Florida PALM interface requirements and file definitions 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. Work as a developer and subject matter expert for the Department’s computing assets requiring remediation as a result of Florida PALM, ensuring that robust and scalable solutions are implemented. Coordinate with application owners to identify essential financial related information for complex reconciliation efforts and validation of end results.
4. Support data conversion analyses of Department data to align with revised Florida PALM data structures and solution configurations. Develop data conversion programs to convert data within Department financial related computing assets.
5. 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. Provide guidance and oversight for quality assurance on all new code from inception through integration, staging and production environments.
6. Identify, analyze, and resolve problems and issues for remediated computing assets using troubleshooting tools and techniques.
7. Work in partnership with distributed cross-functional teams to ensure all aspects of the Florida PALM System Transition (FPST) is communicated, supported, and delivered according to the Department standards and industry best practices.
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:
The selected candidate must have the following required KSAs and experience:
1. Knowledge of terminology and concepts of DB2 for z/OS or Oracle databases or similar relational databases, including SQL proficiency.
2. Knowledge of Active Server Pages (Classic ASP) web page development languages VB and J-script.
3. Knowledge of Visual Studio/.NET web application development and JavaScript preferred.
4. Experience with development and maintenance of Software systems dealing with complex financial business processes.
5. Ability to prepare computer program test plans and to create test databases and test environments.
6. Skill in accurately estimating time requirements for computer programming tasks in a computer application maintenance environment.
7. Skilled in verbal and written communication, interpersonal, conflict resolution, and customer service.
8. Ability to work effectively in a fast-paced, high volume, deadline-driven environment.
9. Ability to balance multiple demands and work both independently and as part of a team.
10. Ability to conduct complex systems analysis and translate user requirements into business solutions.
11. Ability to integrate research and best practices into problem avoidance and continuous improvement.
12. Ability to effectively communicate and mentor development teams.
13. Ability to display professionalism in dealing with all levels of management and staff.
14. Ability to develop and manage technical documentation in accordance with the Department’s standards.
15. Strong working knowledge of Microsoft Office.
Preferred KSAs:
1. Experience working on accounting and financial computing applications and monitoring complex interfaces with external systems.
2. Skill in coding and debugging applications using web based and object-oriented programming languages.
3. Ability to translate between Mainframe based technologies to .Net.
4. Skill in data conversion techniques, data cleansing approaches and validating data relationships.
5. Knowledge of federal authorization and reimbursement computer systems, including interfacing methods.
6. Experience working with development technologies including but not limited to JCL, Cobol, DB2 for z/OS or similar relational databases.
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.
F-Resume-Self-Certification-Form.docx