Work with users to gather requirements for OBIA procurement,finance,custom OBIEE and BI publisher reports.
Modify OBIA repository,create custom tables and joins for OBIA reports.
Create custom reports in OBIA procurement and finance.
Write custom SQL queries using PeopleSoft finance and procurement tables,to validate datain OBIA reports.
Customize out of the box scenarios in ODI and add it to the existing load plan.
Generate load plans in ODI and optimize those using custom OBIA tables,modifying ODI
interfaces and creating table indexes to reduce the ODI load running time.
Migrate ODI objects(Interface,Scenarios and
Packages)between environments using smart export and import.
Create report in OBIEE to track ODI load status and errors using SNP tables.
Work with DBAs and oracle support to rectify the runtime errors on ODI loadplan.
Install,upgrade and maintain Oracle DataIntegrator(ODI) in Production,test andQA servers.
Install,upgrade and maintain Oracle Business Intelligence Enterprise Edition(OBIEE)in Production,test andQA servers
Install,upgrade and maintain Oracle Business Intelligence Applications (OBIA) in Production,test andQAservers.
Import and export service instance using WebLogic scripting tool in AIX server to export
and import presentation services catalog,datamodel and securitypolicymetadata between environments in OBIEE 12C.
Run commands in AIX to import SSL certificate and keys to res for active directory authentication.
Configure security providers,active directory and oracle internet directory(OID)using WebLogic administration console.
Create users and add them to groups in WebLogic admin console.
Create roles and add groups & users in WebLogic enterprise manager.
Use AIX commands to start,stop and navigate through files and folders in the all AIX servers for OBIEE and ODI
Perform error diagnostics in OBIEE and ODI using serverlogs.
Install,configure and migrate reports from OBIEE 220.127.116.11 to18.104.22.168
Perform Authentication and Authorization (implement object and row level security).
Use Write back feature in OBIEE to implement and maintain the reports where users are able to enter data for expected budget and expenditure values and plan current and future
Fiscal year Budget and expenses
Plan,develop data model and create custom reports in OBIEE for
Alternative Dispute Reports(ADRESS)based on user requirements.
Model the ADRESS repository by importing data warehouse tables,creating new physical and logical joins.
Create custom templates inBI publisher,using bursting definition and schedule reports to be delivered to anFTP folder in a remote machine based on the requirement for domestic violence reports users.
Create custom queries andviews using oracle internet directory tables for security reports.
MaintainEBAR,elicense, foster care and security reports usingBI publisher.
RunAIX scripts on the server to rename DV reports BIpublisher files and add them to the server.
Create and modify repository and session variables in OBIEE.
Create newtables and views indatawarehouse
Bachelor Degree inComputer Science
Ability to communicate effectively,orally and in writing, and to establish andmaintain effective working relationships with peers,endusers and vendor development staff, as well as all levels of management and judicial personnel as necessary.
Must be familiar OBIEE(Oracle Business Intelligence Enterprise Edition)12C.
Must be able to develop reports, design rpd, administer server and perform server upgrade in OBIEE 12C.
Experience in OBIEE security configuration (authentication and authorization)
Must have experience in configuring active directory and oracle internet directory(OID) security in OBIEE 12C.
Must be familiar with write back feature in OBIEE 12C.
Must have experience in OBIA(Oracle Business Intelligence Applications)12C, Procurement and Finance.
Must have experience in Oracle Data Integrator 11G.
Must have experience in ODI customization,migration between environments and load plan generation.
Must be familiar with Oracle BI publisher 12C
Must be able to create xmlptemplates and associate with SQLcode
Must be familiar with
Must be able to read user requirements and understand the dependencies on roles.
Must be able to work closely with Oracle database administrators and Oracle xmlp server administrators and enterprise security groups.
Must have a deep knowledge of report design, views, materialized views, and database design for reporting.
Must befamiliar with star schema and warehouse architecture design.
Must be able to distinguish who the current userof the report is so that roles and report outputcan be designed accordingly.
Must understand the separation of business logic from the presentation of the data via xmlpserver.
OBIEE 12C.Oracle Data Integrator 11G.Oracle BI publisher 12C,Oracle PL/SQL and xmlpublisher