Bank of America Cnslt - Apps Prog - PLSQL Hyperion Developer  in Plano, Texas

Cnslt - Apps Prog - PLSQL Hyperion Developer 


Job Specific Description

  • Able to develop application from scratch – including Database design, ETL, Essbase (BSO and ASO).

  • Capture and review business requirements and functional specifications with business.

  • Document the technical design and detail design document and other project related documents.

  • Challenge existing processes and recommend change where needed to add value and help reduce on-going maintenance.

  • Work with EPM, BI, Data Warehouse, and Oracle team to deliver enterprise level solutions.

  • Convert ASO formula to BSO and vice versa.

  • Support testing and production deployments.

  • Help develop complex items related to calculations, rules, queries or other items.

  • Maintain the health of the Hyperion platform by performing maintenance activities and implementing process improvements.

  • Develop new applications and functionality within the toolset while taking into consideration best practices and impacts to upstream/downstream processes.

  • Partner with financial accounting team to understand how Hyperion integrates with SAP/oracle E-Business Suite general ledger, data warehouse databases, and other related application systems.

  • Support end user business processes that include financial close, budgeting and forecasting processes, and related reporting.

  • Collaborate with the finance team to automate and streamline related business processes; financial close, budgeting, forecasting and reporting processes.     

Enterprise Role Overview

Develops, enhances, debugs, supports, maintains and tests software applications that support business units or supporting functions. These application program solutions may involve diverse development platforms, software, hardware, technologies and tools. Participates in the design, development and implementation of complex applications, often using new technologies. May provide technical direction and system architecture for individual initiatives. Serves as a fully seasoned/proficient technical resource. Will not have direct reports but may lead projects and direct activities of a team related to special initiatives or operations. May have responsibility for a project and project budget. May collaborate with external programmers to coordinate delivery of software application. Routine accountability is for technical knowledge and capabilities. Works under minimal supervision, with general guidance from more seasoned consultants. Typically requires 5-7 years of experience.


Required Skills:

  • 5 Hands on working experience with Essbase, Studio and EPMA.

  • Advanced knowledge of Hyperion Essbase (ASO, BSO, Calculation Scripts, Rules, MDX, Maxl).

  • Advanced Knowledge of Oracle Hyperion tools like ODI, EPMA, Essbase Studio, SVP, IR, WA.

  • Proficiency with Microsoft Excel and Word including Hyperion Smartview and Excel Add-in.

  • Hands on experience on relational databases and data modeling.

  • Proficiency with SQL/PLSQL programing.

  • Proficiency with coding/developing automation scripts (shell, batch, VBS, PowerShell).

  • Proficiency with VBA.

  • Candidates requiring sponsorship will not be considered for this position.

Desired Skills:

  • Exposure to hyepion planning, OBIEE

Job: TA-Applications Programming

Primary Location: US-TX-Plano

Work Locations: TX2982 7105 CORPORATE DR Plano 75024


Travel: No

Job Posting Date: Oct 17, 2016

Unposting Date: Oct 31, 2016

Full/Part-time: Fulltime

Hours Per Week: 40.00

Shift: 1st Shift

Req ID: 16050796