Job Description :
Works with business users, project team to understand the application and reporting requirements. Designs BO universes to accommodate complex business reporting requirements for desktop and web intelligence and XCelsius reporting. Architecture the business requirements and processes and build universes using complex BO features and design. Creates derived tables as needed to resolve complex reporting issues. Develops and tunes the PL/SQL queries to improve BO reports performance. Develops and implements aggregate aware function and @ variables. Develops Deski and Webi reports using cross table, drill down, prompts, dimensional and other BO features. Provides production support for existing BO universes and reports. Redesigns and modifies existing universes to accommodate the business reporting needs in maintenance. Helps convert the existing Deski reports to Webi using reporting tool and resolve any errors. Coordinates UAT testing of the BO reports with users and technical team. Coordinates the BO universe and reports releases to QA and production environment. Creates user accounts using Infoview admin module and assign roles for user access to reports. Develops security features users, groups and folders for the BO project needs. Creates canned adhoc and dashboard reports using BO universe. Experience in creating logical and physical data models. Experience writing PL/SQL queries, stored procedure, packages, function and triggers. Experience with new and existing project development using agile methodologies.