Job ID: TX-LCRA11177 (911390906)
ODI/OBIA Consultant with PeopleSoft FSCM/HCM Load Plans, Analytics, LDAP/SSO, Weblogic admin, OBIEE, Essbase, BI Publisher, Tagetik, Maximo and Utility/Energy experience
Location: Austin TX (LCRA)
Duration: 7 months
Minimum Requirements:
Years Skills/Experience
8Experience developing customizations in ODI 11.1.1.9 and above
8Experience configuring, running, and customizing Oracle ODI Load Plans from PeopleSoft 9.2 FSCM (GL, AP, AR, BI, Contracts, PO, Project Costing) and HCM (Time and Labor, Payroll)
8Experience installing configuring, and customizing OBIA (11.1.1.10.1 and above): Financial Analytics, Project Analytics, HR Analytics
8Experience installing, configuring, administering, and patching Weblogic 10.3.6, Weblogic 12.2.1.1 and above
8Experience developing customizations working closely with the Functional Team.
8Experience with Microsoft Suite (Projects, Visio, Excel, Word, Power Point)
8Experience writing and reviewing detailed Functional Design Documents (FDDs)
8Proven project team building skills
8Experience writing and reviewing detailed Technical Design Documents (TDDs)
8Ability to alter project direction based on PM or Executive Direction
8Experience integrating RPD initialization blocks with LDAP and single sign-on (SSO)
8Experience extending out-of-the-box OBIA RPD with custom fact tables and metrics
8Experience developing ragged hierarchies in the logical layer
8Experience developing custom security model based on PeopleSoft trees
8Experience with opaque views
8Experience development of custom logic table sources to support performance tuning and/or custom metrics
8Experience integrating BI Publisher security model with LDAP and single sign-on (SSO)
8Experience developing custom BI Publisher data models
8Experience developing custom BI Publisher report layouts
8Experience scheduling BI Publisher report bursting
8Experience coding custom SQL to support BI Publisher pixel-perfect reporting
8At least 3 successful implementations of Oracle Business Intelligence applications
8Experience teaming with customers and technical staff in a complex, large scale OBIEE, OBIA, and ERP (PeopleSoft, Maximo, Tagetik and/or other Planning and Work Order management applications) environment.
8Experience teaming with customers and technical staff in a complex, large scale ERP and Business Intelligence environment.
8Experience migrating ODI, and OBIEE (RPD and Presentation Catalog) metadata from development and test to production environments.
8Experience trouble shooting and resolving Service Requests (SR) through Unit, System, Integration, and User Acceptance, test phases.
StrongCommunication, analytical and interpersonal skills at all levels of an organization.
StrongExperience teaming with customers and technical staff in a complex, large scale ERP and Business Intelligence environment.
StrongMust demonstrate good judgment and pragmatic approach to delivering software that optimizes architecture activities across company needs, business constraints and technological realities
Preferences:
Years Skills/Experience
2Experience integrating Essbase with OBIEE 12c and designing cubes to meet identified requirements
3Experience with a Utility or Energy Based company a plus
3Developing and publishing BI Publisher pixel-perfect reporting
3Developing and publishing OBIEE dashboards and analyses (including Essbase where identified)
3Developing ODI Load Plans from Tagetik or similar planning application 5.2.0 and above
3Developing ODI Load Plans from Maximo 7.6.06 and above
5Experience with all aspects of Documentation, Planning, Design, Build, Test, and Deploy Phases within OBIEE and OBIA.
StrongAbility to set and meet technical team deadlines while maintaining an even disposition under pressure
Strong Experience working through development of Interfaces with Technical Team through design, build and test
StrongGood teamwork skills, ability to collaborate with other functional and technical staff on the project.
StrongStrong interpersonal skill and the ability to collaborate effectively on diverse teams
The LCRA Enterprise Financial Operations Re-engineering (EFOR) Project is preparing for the re-engineering of PeopleSoft Financials version 9.2, Maximo 7.6, and Oracle Business Intelligence and is posting this position for the Technical Analyst of the EFOR project.
Currently, LCRA has a custom data warehouse and corresponding ETL leveraging Informatica. As part of the Enterprise Financial Operations Re-engineering (EFOR) Project, LCRA desires to implement the following Oracle Business Intelligence Applications: Financial Analytics, HCM Analytics and Project Analytics.
This Technical Analyst position will be responsible for assisting LCRA with the Oracle Business Intelligence (BI) technical development, integration, build and test of the reimplementation through go-live. The worker must have extensive knowledge of what is required to perform Oracle Business Intelligence system development.
The Technical Analyst will report to the Reporting Lead to ensure delivery throughout the project development lifecycle.
Duties for this position will include:
•Oracle Business Intelligence application development to build or modify objects including:
oOBIA 11.1.1.10.1 and above (Financial Analytics, Project Analytics, HR Analytics) Installation, Configuration, and Customization
oWebLogic 10.3.6
oWebLogic 12.2.1.1 and above
oODI 11.1.1.9 and above
oOracle ODI Load Plans from PeopleSoft 9.2 FSCM (GL, AP, AR, BI, Contracts, PO, Project Costing) and HCM (Time and Labor, Payroll)
oCustom Oracle ODI Load Plans from:
Maximo 7.6.06 and above
Tagetik 5.2.0 and above or similar planning application
oOBIEE 12.2.1.1 and above (RPD and Dashboard Development)
Experience integrating RPD initialization blocks with LDAP and single sign-on (SSO)
Experience extending out-of-the-box OBIA RPD with custom fact tables and metrics
Experience developing ragged hierarchies in the logical layer
Experience developing custom security model based on PeopleSoft trees
Experience with opaque views
Experience development of custom logic table sources to support performance tuning and/or custom metrics
oBI Publisher 12.2.1.1 and above
Experience integrating BI Publisher security model with LDAP and single sign-on (SSO)
Experience developing custom BI Publisher data models
Experience developing custom BI Publisher report layouts
Experience scheduling BI Publisher report bursting
Experience coding custom SQL to support BI Publisher pixel-perfect reporting
oSmartView 11.1.2.5.610 version or above
Experience with integration with Excel, Word and PowerPoint Preferred
oOracle Database 12.2.0.1 and above
•Collaboration with and support of the Functional Module Leads designs and supporting the technical team analysis, design, development and implementation of Oracle BI custom functionality;
•Responsibility for identification, documentation, and reporting of technical project Issues/risks to Reporting Lead and Project Team to determine the appropriate response strategy;
•Responsibility for ensuring clear Functional Design Documentation (FDD) and to ensure the Functional Team understands the solution boundaries and risks;
•Responsibility for ensuring clear Technical Design Documentation (TDD) and to ensure the Technical Team understands the solution boundaries and risks;
•Partnering with the other technical and functional resources to ensure custom solutions are sound;
•Ensuring best practices are used for custom development to maintain a high quality product.
•Ensuring consistent use of standardized processes and forms to manage project documentation, including but not limited to: Functional Design Documents, Technical Design Documents, Change Controls, Risk Registers, Work Packages and other project documents as needed;
•Working with LCRA Enterprise Financial Operations Re-engineering (EFOR) Reporting Lead and LCRA IT team members (regarding as is state) to mitigate risks and resolve issues throughout implementation as needed;
•Completion of tasks in an efficient and timely manner while keeping project stakeholders informed;
The worker should have a history of success as an application developer for Oracle BI Implementations using best practices.