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.