• Interacted with procurement and operation/maintenance business representatives for gathering the OBIEE reports/Dashboards requirements and to define business and functional specifications.Â
Â
• Involved in translating functional requirement into technical requirements.
Â
 • Conducted research and analysis of business requirement problems and available technologies to define system solutions that increase efficiency and effectiveness.Â
Â
• Create ODI data model, tables indexes, views, materialized views, synonyms, sequences for better performance of DB.Â
Â
• Utilized Oracle Data Integrator to develop and integrate Master, Work Repositories, data migration, quality and profiling.Â
Â
• Designed and Customized OBIEE dashboards and reports / Dashboards with different analytic views (Drill-Down/Dynamic, Pivot Table, Chart, Column selector, Tabular with local and global filters) using OBIEE/Siebel Analytic Web.Â
Â
• Created interactive maps using the new OBIEE 11g "Map Views" feature.Â
Â
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.Â
Â
• Created Data Maps/Extraction group in Power Exchange Navigator for legacy IMS Parent Sources.Â
Â
• Staged Data from legacy Proclaim IMS System into Oracle 11g Master Tables.Â
Â
• Performed CDC Capture Registrations.
Â
• Developed mappings that perform Extraction, Transformation and Load of Source data into derived Masters Schema using various Power Center Transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, Look Up, Rank, Joiner, Expression, Stored, Procedure, SQL, Normalizer and update strategy to meet business logic in the mappings.
Â
• Designed the Process Control Table that would maintain the status of all the CDC jobs and thereby drive the load of Derived Master Table.
Â
• Created Post Unix scrips to perform operation like gunzip, remove and touch files.Â
Â
• Involved in building ODI ETL architecture and Source to Target mapping to load data into Data warehouse.Â
Â
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.Â
Â
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.Â
Â
• Modified existing mappings for enhancements of new business requirements.Â
Â
• Designed and customized dashboards for review by the business users. • Extensive experience in OBIEE RPD (Physical, Business Model and Mapping and Presentation layers) for both Stand-Alone and Integrated OBIEE implementations.Â
Â
• Extensively worked in creating hierarchies, level-based measures, Time series metrics and aggregates in the BMML.Â
Â
• Excellent proficiency in data and object level Security in OBIEE.Â
Â
• Extensive experience in customizing OBIEE dashboards and reports.Â
Â
• Extensive experience in RPD and Reports performance tuning.Â
Â
• Modified Presentation Layer to add presentation tables and columns to meet the business user needs.Â
Â
• Worked on repository and session variables.Â
Â
• Used the security settings in Siebel Analytics Admin tool to setup users, Groups and Access privileges.Â
Â
• Created materialized views and aggregates to improve performance.Â
Â
• Customized Activity and Revenue star schemas.Â
Â
• Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance.Â
Â
• Customized reporting with OBIEE Answers and integrated them into the Dashboards.
Â
• Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.Â
Â
• Created user level security for intelligence dashboards based on Business Requirement.Â
Â
• Customized and Developed OBIEE Analytics Reports Account Activity, Revenue on business segmentation, Actual Vs Forecast Response rates, Segment, and Offer responses.Â
Â
• Created Dashboards with Dashboard prompts, Charts, Pivot tables.Â
Â
• Performed Data Validation of data in the reports and dashboards.Â
Â
• Extensively used SQL Tuning to improve performance.Â
Â
• Created iBots to send pre-processed reports using OBIEE Delivers.Â
Â
• Unit, integration and system testing for all components in OBIEE. Test cases have been prepared and documented the results.Â
Â
• Worked on evaluation of Oracle BI Enterprise Edition and its new utilities including BI Server, Answers, Delivers and Publisher.Â
Â
• Built Report prototype based on initial business requirements.Â
Â
• Created custom resource Catalogue and Manage content in the resource Catalogue.Â
Â
• Built Analyses and created Dashboards with Global prompts, column selectors, navigation and automatic development Documentation drilldown.Â
Â
• Performed testing and Data Validation of data in reports against the databases using SQL Developer and Toad.Â
Â
• Performed post-upgrade documentation and experience with OBIEE 12c install and configuration.