Recent Experience:
• Performed environment migrations using BAR files for OBIEE upgrades within 12c and to OAC and OAS.
• Configured OBIEE vertical scaling for high availability.
• Setup Usage Tracking on OAC, administered User and Roles, System Settings, Manage Snapshots.
• Setup User and App Roles and implement Object Level Security on OBIEE, OAC, OAS.
• Setup Active Directory integration for authentication and BISQLGroupProvider for authorization of users for OBIEE.
• Performed password change for Admin user of OBIEE and OAS.
• Automate the startup of OBIEE and OAS application through shell scripting, such that no manual intervention is required.
• Patching on OBIEE and OAS.
• Automate Cache Purging for OBIEE, OAS and OAS
• Automate BI Agent Deliveries for OBIEE, OAS and OAC
• Automate RPD and Catalog migrations or OBIEE, OAS and OAC.
• Created and Scheduled BI publisher Bursting reports to deliver reports based on the content via ftp and file transfer delivery channels.
• Operated as a Subject Matter Expert for all things within Business Intelligence environment. Worked on resolving any functionality concerns within OBIEE, OAS and OAC and provide solutions for those issues.
• Setup Sync between Production and DR environment and ensure Business Continuity during Disaster Recovery.
• Perform Migration of ODI objects between environments, such as Scenarios, Load Plans, Sub Folders, Models, etc.
• Define and Associate Logical Schema and Physical Schema in ODI Topology
• Scheduling of Load Plan within ODI
• Improve Performance of ODI Data Loads, by re-sequencing the load plans by removing the mappings that need not run on daily basis.
• Improve Performance of Data Loads, by scheduling Gather Stats stored procedure for selective Tables on daily basis.
• Setup User and Profile Access on Oracle Data Integrator and also setup Read-only user access for ODI 11g.
• Automate Load Plan execution for ODI
• Patching on ODI and BIACM
• Performing activities on BIACM such as updating Data Load Parameters, Reset Data Warehouse.
• Marking the failed session or load plan executions as complete from backend SNP tables.
• Experience in Application Recovery Procedure on DR environment during Disaster Recovery.