| Job Duties |
| Analyze customers' requirements and update systems |
| Configure Oracle Business Intelligence Applications (OBIA) for Financials , Projects and HR Information Analytics by using interfaces like BIACM (Business Intelligence Applications Configuration Manager) and FSM (Functional Setup Manager). |
| Create Load plans for loading the Fusion ERP, DRM, Power plant, Projects Finance and PO data into the OACS Data warehouse Execute the load plans Full and Incremental, troubleshoot the issues caused during loads and ensure their successful completion along with scheduling |
| Validate / Unit test the date loaded on the Warehouse by running some test scripts against the source and compare it with the data in Warehouse Performance tuning the Oracle Data Integrator (ODI) tasks / sessions by adding necessary Indexes, Hints and profiles |
| Perform various customizations on both Oracle Data Integrator (ODI) and Oracle Business Intelligence Enterprise Edition (OBIEE) or Oracle Analytics cloud service (OACS) for Human Finance , Projects , Planning , Budgets and DRM data Design and develop various tasks on data sync and execute the jobs periodically to extract data from fusion ERP using PVO's and load into data warehouse. |
| Develop OBIEE/OACS RPD by working through 3 layers ( physical , BMM and presentation) . Implement the migrations related to Oracle Business Intelligence Applications OBIA, OACS , ODI and data sync code for both out-of- the-box and customized successfully from Development environment to the Test environment and TEST to PROD environments on Linux operating system |
| Work on the OCI PaaS environments for verifying patches and executing ODI data loads along with development process Integrate Oracle Analytics cloud services (OACS) and Oracle Transactional business Intelligence (OTBI) environments with Dev ops for automating the migration process with necessary code merge and code review approvals |
| Interact with users to design and modify the data warehouse to come up with necessary Facts and Dimension tables required for reporting Document the new techniques and functionalities which are included with the product versions and share with team and provide the knowledge transfer on activities performed Document the required Technical design documents and Unit test documents which are required for code development process. |