Banner Image

Skills

  • Bi Reporting
  • Business Intelligence
  • Middleware
  • Oracle Data Integrator (ODI)
  • WebLogic

Services

  • BI Administration and Production

    $80/hr Starting at $3K Ongoing

    Dedicated Resource

      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...

    Bi ReportingBusiness IntelligenceMiddlewareOracle Data Integrator (ODI)WebLogic

About

• 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 of OBIEE/OAS/OAC.
• 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 of ODI
• Managing 90-days password rotation for WebLogic applications
• Manage deployment of ear files on WebLogic.
• Setup proxy and other web configurations in apache http config files.
• Manage application services and ensure application stability.
• Automate the startup of applications through shell scripting, such that no manual intervention is required.
• Automate deployment of application on Tomcat through shell scripting.
• Generated thread dump using jstack and kill -3 commands
• Oversee and manage the infra aspects such as disk space, memory usage and CPU utilization, etc.
• Successfully patched all WebLogic instances with critical patches every quarter.
• Performed Java upgrade for all applications.
• Implemented Audit Map Security Baselines on MW

Work Terms

Hours of operation: 1 PM IST to 11 PM IST
Preferred Payment mode: Credit to Bank account
Preferred Mode of communication: mail / Zoom

Attachments (Click to Preview)