- Understanding existing HAL (Hyperion Application Link) mappings.
- Preparing technical and functional design documentations
- Creating new data sources on different technologies like Oracle, SQL server and Files.
- Working with different ODI Knowledge Modules such as LKM, IKM, CKM, and JKM.
- Working with different SQL queries in ODI with YELLOW INTERFACES.
- Creating ODI packages, scenarios using interfaces, variables, procedures.
- Creating incremental loads, facts and dimensions, designed new data elements and tables for data marts
- Installing and Configuring ODI 11.1.1.3 on all the environments with standalone agents for custom Data Warehouse project.
- Responsible for code migration from Dev to UAT and PROD environments
- Created standalone agent to automate ODI jobs and scheduling the ODI load plan and scenarios.
- Implemented Object Level Security for the objects like Dashboards and Reports, and Data Level Security for Principal and Teacher Evaluation dashboard.
- Enhanced Query performance, by analyzing & modifying SQL Query and Filters, for all the reports and dashboard prompts, to minimize the delay in Physical Query Execution
- Responsible for migrating the web catalog and RPD from DEV,UAT and PROD environments.
- Created Repositories, Agent, Contexts and both of Physical & Logical Schema in Topology Manager for all the source and target schemas.
- Created ODI Packages, Jobs of various complexities and automated process data flow.
Environments: ODI 11.1.1.3, OBIEE 11.1.1.7.1, SQL Developer, Toad, Oracle and Windows Server.