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.
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.
- Exposure to hyepion planning, OBIEE
Job: TA-Applications Programming
Primary Location: US-TX-Plano
Work Locations: TX2982 7105 CORPORATE DR Plano 75024
Organization: 4439529-GLOBAL DELIVERY CENTER OF EXPERTISE VS
Job Posting Date: Oct 17, 2016
Unposting Date: Oct 31, 2016
Hours Per Week: 40.00
Shift: 1st Shift
Req ID: 16050796