COMPUTER ASSOCIATE (SOFTWARE)

Computer Associate (Software)

The Department of Financial Planning & Analysis (DFPA) is seeking a Computer Associate (Software), L2 to work in the Budget Control and Coordination (BCC) division. The BCC division is responsible for specialized technical support, software maintenance, and report development of our financial system. The implementation of the Hyperion System has increased accuracy and transparency of reporting. Some of the key responsibilities include:

• Assist in managing the Authority's Operating and/or Capital budget, including technical budgetary exercises.
• Assist in evaluating technical proposals and estimating the impact of management decisions and policies.
• Provide technical assistance in the preparation of the Authority's Operating, Revenue and/or Capital Budgets, consistent with the priorities of the Authority's Executive Management.
• Identify and recommend solutions to operational issues having an impact on the Authority.
• Generate ideas to improve existing programs, find new ways to make Budget exercises more efficient.
• Maintain MS Access and SQL Databases including updating and creating Queries to help team perform ad-hoc analysis for upper management.
• Responsible for running oracle processes for the bi-weekly payroll to post in GL.
• Maintain Oracle Hyperion planning.
• Work with Hyperion to import and extract data; create and update Hyperion calcs, forms, and reports to assist team with Budgetary exercises and analysis.
• Maintain and troubleshoot issues with ODI integrations between Hyperion and other systems.
• Provide technical support and SmartView assistance.
• Maintain integrity of system by doing routine reconciliation of system data.
• Create technical training material for inner and outer departments on technical processes as well as doing live training.
• Have experience working with Visual Basis and SQL along with Microsoft Office (Word, PowerPoint, Access, Excel, Outlook).
• Maintain department web pages.
• Provide and convert data from Hyperion to be loaded into U.S. Department of Housing and Urban Development (HUD) - Energy and Performance Information Center (EPIC) reporting system.