PROFILE:

• Around 6.9 Years of experience in Data Warehousing & Business Intelligence along with Linux/Unix.
• 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 users 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 and Mange Privileges.
• Able to migrate the security code (Users, Groups) from Non-PROD to PROD instances using weblogic console.
• Implemented deployment of external web services like change Password into OBIEE and Write Back, Usage Tracking features.
• Created the RPD Data dictionary reports using BI Publisher tool.
• Involved in the project document preparation like LLD and HLD, Data Lineage.

TECHNICAL SKILLS:

BI Tools: OBIEE 11 x, OBIA 7x,Tableau 8x (Basic Knowledge)

Database: Oracle 10g/11g

Operating Systems: Windows Family, Linux/Unix.

PROFESSIONAL EXPERIENCE:

Confidential, California

OBIEE Developer & Administrator

Environment: OBIEE 11.1.1.9.0 (11g), Oracle 11g

Operating Systems: LINUX/RHEL 5.8 x86 64; Windows Server 2008-Client Machine

Responsibilities:

• Involved in end to end unit testing of OBIEE application after upgradation from OBIEE 11.1.1.7.15 .1.1.9.0 version.
• Customized and developed RPD (Physical, Business model and Presentation Layer), configuration of Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Created Dimension hierarchies, new logical columns, Logical table sources in Business model layer.
• Creating and customizing the reports/dashboards, Agents, prompts.
• Creating the new users/groups and providing the access to the respective reports/subject areas.
• Monitoring the OBIEE Services (Dev, QA, UAT and Production), Agents, Help Desk Ticket System and Emails for the user tickets.
• Migrating the RPD and Web Catalog across all the Environments (Dev, QA, UAT and Production) based on business user’s requirements.
• Closing/Resolving the tickets/enhancements in time with user approvals.
• Working with the Oracle Support team on OBIEE Issues (Oracle SR).
• Clearing the log, /tmp files and taking the backup of RPD, Catalog as part of scheduled server maintenance activity.
• Modified the OBIEE customer logo, tab names as per the client requirement.

Confidential

OBIEE Developer & Administrator

Environment: OBIEE 11.1.1.6.8 (11g), Oracle 11g, OWB 11g

Operating Systems: LINUX/RHEL 6.7 x86 64 ; Windows Server 2008-Client

Responsibilities:

• Supporting the OBIEE, OWB environments (PROD, Pre-Prod, Test, DEV) and monitoring the OWB Jobs.
• 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.
• 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.
• 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.

Confidential, California

OBIEE Developer & Administrator

Environment: OBIEE 11.1.1.7.14 g), Oracle 11g

Operating Systems: LINUX/RHEL 5.8 x86 64 ; Windows Server 2008-Client Machine

Responsibilities:

• Customized and developed RPD (Physical, Business model and Presentation Layer), configuration of Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Created Dimension hierarchies, new logical columns, Logical table sources in Business model layer.
• Creating and customizing the reports/dashboards, Agents, prompts.
• Creating the new users/groups and providing the access to the respective reports/subject areas.
• Monitoring the OBIEE Services (Dev, QA, UAT and Production), Agents, Help Desk Ticket System and Emails for the user tickets.
• Migrating the RPD and Web Catalog across all the Environments (Dev, QA, UAT and Production) based on business users requirements.
• Clearing the log, /tmp files and taking the backup of RPD, Catalog as part of scheduled server maintenance activity.
• Modified the OBIEE customer logo, tab names as per the client requirement.
• Involved in end to end unit testing of OBIEE application after upgradation from 11.1.1.6 to OBIEE 11.1.1.7.140527 version.

Confidential

OBIEE Developer

Environment: OBIEE 11.1.1.6.0 (11g), Oracle 11g

Operating Systems: Windows 2008 Server and Linux

Responsibilities:

• Over all OBIEE UI Customizations.
• Understanding requirements and customizing the User Interface to meet the requirements i.e., Cosmetic Changes, Delete the Export to PDF & .MHT format options.
• Doing Research & Development for new requirements and prepare the proper documentation.
• Involved in the meetings & discuss about the feasibility of OBIEE for client requirements.
• Created Reports using different Analytics Views (Pivot Table, Chart, Column Selector, Table)
• Hands of experience with working on the Answers and Dashboards for various interfaces
• Modified some of the existing reports and dashboards, and fixing some of the issues related to performance, data quality etc., during production support.

Confidential, California

OBIEE Developer

Environment: OBIEE 11.1.1.6.0 (11g), OBIA (7.9.6.3), Oracle 11g

Operating Systems: LINUX/RHEL 5.8 x86 64

Module: OBIA Apps & Operational Reports

Responsibilities:

• Understanding requirements and customizing the Repository to meet the requirements i.e., Physical Layer, Business Model & Mapping and Presentation Layer level
• Creating dimensional hierarchies and level based measures as per business requirements.
• Specified Aggregate levels for each source and created dimension sources for each level of aggregates.
• Identified the Facts, Dimensions, and grain of the Dimensional model, and referential joins.
• Implemented data level security and object level security permissions/privileges as per role of each user.
• Creating users and groups assigning permissions depending on the user.
• Creating the requests in answers and see the results in various views like title view, table view, compound layout, chart, pivot table, ticker and static view.
• Interacted with the business users to gather reporting requirements focusing on Sales groups mainly focusing on Service Requests and Sales Analytics.
• Creating reports, filters, prompts and charts in Oracle Bl answers added then to intelligence dashboards.
• Created page level prompts and dashboards level prompts.