SUMMARY:

Result oriented professional with more than 10 years of progressive experience in OBIEE ( 12c, 11g and 10) in capacity as a reports/dashboard/BI Publisher developer, metadata and RPD developer, Data Modeler and BI Administration. Worked with custom data warehouse as well as BI Apps with Oracle E - Business Suite 11i and R12 data sources.

AREAS OF EXPERTISE INCLUDE:

• RPD Development
• OBIEE Reports Development
• Dashboards Development
• BI Publisher Reports Development
• Objects and Data level security
• Upgrade of OBIEE from 11g to 12c
• OBIEE and Oracle EBS Integration
• RPD Deployment Automation
• Catalog migration
• BI Publisher Reports Scheduling
• Reports and Dashboards security
• BI Administration
• Informatica
• SQL, Oracle Data Integrator

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Senior OBIEE Consultant

Responsibilities:

• For OBIEE 11g to 12c upgrade, created OBIEE 11g archive package and imported into 12c env.
• Used Visual Analyzer to develop BI Reports using OBIEE repository.
• Developed 19 new subject areas and modified several existing subject areas (for additional Physical and Logical calculated Columns, Hierarchies, Repository variables, Presentation folders etc).
• Developed over 100 answers/reports and over 20 dashboard with multiple tabs having varying complexities.
• Developed 15 different BI Publisher reports with BI Answers and Physical Database as a data source for data model with RTF template and scheduled to send these reports to end users every week.
• Implemented a process to improve performance of large reports up to factor of 10 or more.
• Re-wrote OWB mappings and interfaces using ODI as part of OWB to ODI migration project.
• Efficiently managing OBIEE 11g daily administration tasks like Dashboard security, Catalog objects migration ( DEV-QA-PROD), Metadata/RPD development.
• Analyzed and archived 14000 reports not used by end users in previous 2 years. The performance of catalog navigation, report search improved by factor of 3.
• Developed process for migration of Repository changes and catalog objects from DEV-QA-PROD env and to clone RPD and Web catalog from PROD to QA/DEV with Database schemas.
• Implemented usage tracking and metadata dictionary in new env.
• Developed a data lineage Subject Area to indentify which presentation columns are used in different reports
• Implemented SA System subject area for setting up default user profiles for Agents.

Confidential, Vienna, VA

OBIEE Lead

Responsibilities:

• Identified the hardware configuration for installation of Oracle BI Analytics on Linux platform for Database, Informatica Server, DAC Server and OBIEE Services.
• Installed Database, Informatica Server, DAC Server and OBIEE Services on Linux and Informatica client, DAC client and OBIEE Administration on windows client.
• Configured and Established connectivity between DAC, Informatica and Database.
• Configured Informatica Source files, Lookup files, mappings for HR, Financials and Procurement & Spend Analytics.
• Developed execution plan in DAC for a HR, Financials and Procurement and Spend Subject areas and run the execution plan for full load and incremental load.
• Monitored failed tasks and resolved errors by modifying informatica mappings based on the log information.
• Created new Informatica mapping for additional AR aging buckets and developed tasks and workflows in Informatica. Added new developed tasks to DAC tasks and subject areas and created new execution plan for modified subject areas.

Confidential, Monroe, NC

Senior OBIEE Developer

Responsibilities:

• Analyzed and prioritized migration of Oracle Discoverer EUL to OBIEE.
• Developed proof of Concept (POC) for migrating Oracle Discoverer End User Layers (EUL) to OBIEE Repository. Developed reports using migrated EUL and compared results with Oracle Discoverer reports.
• Imported data warehouse tables into the physical layer of the repository by ODBC connection and established the links between the tables. Created Business Model and Mapping Layer. Created Aggregates on sales amount and Dimension hierarchies. Developed presentation layer and arranged the folders according to the subject areas.
• Designed, developed and Tested Report in the Dashboard and implemented data and object level security.

Confidential, Chicago, IL

Senior Consultant

Responsibilities:

• Reported to Project Manager, responsible for Single Sign-On (SSO) implementation of OBIEE with Oracle E-Business Suite.
• Implemented Single Sign-On (SSO) integration of Oracle Business Intelligence Enterprise Edition (OBIEE) with Oracle E-Business Suite.

Confidential, Chicago, IL

Senior Associate

Responsibilities:

• Worked on requirements gathering and designing & Development of Repository (Physical Layer, Business Model & Mapping and Presentation Layers) for Oracle Service Contracts, Depot Repairs and Install Base data from Oracle E-Business Suite.
• Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of OBIEE for Depot repair to view service requests by Region, state and product category.
• Developed many Reports / Dashboards with different Analytics Views (Pivot Table, Chart, Column Selector, and Tabular with Filters) using OBIEE.
• Worked extensively to formalize the logical design using ERWIN and physical creation of database objects like tables, view, sequences, function, packages, procedures etc.