Good Knowledge and experience working on PLSQL packages, procedures and functions.
Data modeling and design ability¸ hands on experience in developing OBIEE repository with Physical¸ Logical and Presentation layers and build reports/dashboards from the repository.
Good experience in Business Model Development creating Dimensional Hierarchies¸ Aggregation ¸ Time Series functions and Level Based Measures.
Knowledge of Cache Management¸ migrating RPDs and Catalogs between different environments.
Able to create reports like Table¸ Chart¸ Pivot¸ Column selector¸ Narrative views¸ iBots ¸ Write back¸ BI Publisher reports and publish/schedule them in dashboards.
Able to Implement Object level Security and Data level Security ¸ provide and manage User Access.
Able to work with business groups and stakeholders in gathering user requirements and design Functional and Technical specification documents.
Good Communication skills & Team Player who can effectively work and collaborate with small groups and can take ownership.
Oracle E-Business Suite environment experience will be an added advantage.