We provide IT Staff Augmentation Services!

Obiee Developer & Administrator Resume

4.00/5 (Submit Your Rating)

CaliforniA

SUMMARY

  • 7.8 Years of experience in Data Warehousing, Business Intelligence.
  • Worked with KPMG SOX Auditing team and provided OBIEE Reports/Server level change proof documents.
  • Experience in developing OBIEE Repository at three layers (Physical, Business model and Presentation Layers), Reports and Interactive Dashboards.
  • Expertise in creating Hierarchies with drill - down capabilities using global & local Filters, creating static, dynamic and session variables, configuration of Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports).
  • Good Knowledge in Reports, different charts, narrative view, column selector, view selector, variables, pivot table and Dashboards with Prompts.
  • Capable to Migrate the RPD and Web Catalog across all the Environments (Dev, QA, UAT and Production) based on business user requirements.
  • Hands on experience with catalog manager and Job manager and Agents configuration.
  • Installed and configured OBIEE 11g, Smart view, office BI Plugins and created the reports with smart view, downloaded the reports into Excel using with smart view and office BI plugins.
  • Involved in OBIEE server maintenance activities like clearing the all log files, start and stop the OPMN services including with the weblogic server.
  • Hands on experience in troubleshooting and resolve the issues within the Service Level Agreements.
  • Creating users and groups and assigning security permissions/privileges based on responsibilities /roles.
  • Worked on implementing security at various levels: weblogic (Admin console, Enterprise Manager), RPD, web catalog, Manage Catalog Groups and Mange Privileges.
  • Implemented Write Back, Usage Tracking features.
  • Created the RPD Data dictionary reports using BI Publisher reports.
  • Involved in the project document preparation like LLD and HLD, Data Lineage.

TECHNICAL SKILLS

BI Tools: OBIEE 11 x, OBIEE 12 c, BI Publisher, Tableau 8x.

Database: Oracle 11g

Operating Systems : Windows Family, Linux/Unix.

Package: MS-Office

Ticketing Tools: Track-It, Wolken, Service Now.

PROFESSIONAL EXPERIENCE

Confidential, California

OBIEE Developer & Administrator

Responsibilities:

  • Involved in end to end unit testing of OBIEE application/Reports after upgradation from OBIEE 11.1.1.7.150120 to 11.1.1.9.0 version.
  • Interacting with the business users to gather reporting requirements.
  • Creating new reports using Table, Pivot and other views as per design document.
  • Adding the new Tables, Columns, Variables to the RPD and existing reports/Dashboards.
  • Good knowledge on resolving the errors at Reporting, RPD or Server level and good idea about all the logs/Configuration files.
  • Working on the BI Reports data issues and validating the Results before releasing the changes to users.
  • Migrating the RPD and Web Catalog across all the Environments (Dev, QA, UAT and Production) based on business user’s requirements.
  • Creating/modifying agents and monitoring the agents from Job Manager.
  • Creating the new users/groups and providing the access to the Required Reports/Subject areas using Manage Catalog Groups/Manage Privileges etc.
  • Working with ETL, EBS, DBA and Oracle Support teams (Oracle SR) on OBIEE Issues.
  • Given Read only permissions to the Key reports/dashboards, catalog folders to avoid the modifications by other users.
  • Providing the OBIEE Key Reports/Server Quarterly changes to KPMG SOX Auditing team.
  • Actively worked on during Month end, Qtr and Year end Support activities/ Issues.
  • Monitoring the OBIEE Services (Dev, QA, UAT and Production), Help Desk Ticket System and Emails for the user tickets.
  • Restarting all the OPMN, WebLogic services, Clearing the logs /tmp files and taking the backup of RPD, Catalog as part of scheduled server maintenance activity.

Confidential

OBIEE Developer & Administrator

Responsibilities:

  • Verifying all the Dashboards/Reports on daily basis and sharing the server’s health check status to Application Manager.
  • Creating the ad hoc reports, users as per the client requirements.
  • Attending the Status call with Confidential Application Manager and providing the status on all the open tickets.
  • Configuring and scheduling the Agents. Also, monitoring the Agents using Job Manger.
  • Adding new columns to the Repository and existing Reports.
  • Migrating the fixes from Dev, Pre-Prod to PROD environments (RPD, Catalog) with user approvals.
  • Providing the updates on the incidents to user using Service Now tool (SNOW) and closing the incidents within SLA’s with user approvals.
  • Worked with Oracle Support Team on Usage Tracking issues to load the day level data into S ETL DAY table up to 2020.
  • Monitoring the OBIEE, OWB environments (PROD, Pre-Prod, Test, DEV) and OWB Jobs.
  • Prepared the start/stop (OPMN, Admin and Weblogic BIServer) scripts to down/up the OBIEE 11g services and worked with DBA Team on issues/fixes.

We'd love your feedback!