We provide IT Staff Augmentation Services!

Obiee Developer Resume

Mount Laurel, NJ

SUMMARY:

  • Over 11 Years of IT experience in design and development of Oracle Fusion Applications using Fusion technology stack which includes OBIEE 10g/11g, OBIA,ODI and WebLogic server 10.3.
  • Experience in leading small and medium teams and also extensive experience in onshore coordination.
  • Well versed with Agile Software Process: Participated in daily scrum, Sprint planning meeting, Sprint review meeting and Sprint retrospective.
  • Experience in Analysis, Design, Development, Deploying and Testing including Implementation of Business Intelligence (BI) solutions using OBIEE/Siebel Analytics.
  • Worked along with business analysts, developers, management professionals and with business users from various locations of customer to gather requirements.
  • Experience in OBIEE Reports and Dashboard Builder.
  • Experience in Oracle BI Publisher builder.
  • Experience in Converting Oracle reports in to Oracle BI Publisher Reports.
  • Experience in Production Support Environment.
  • Good Knowledge on Data warehousing Concepts.
  • Experience in Writing and Executing the Test Cases.
  • Experience in Dimensional Modeling such as star schema, snow flake schema, creating Facts, Dimensions and Measures.
  • Exclusively worked on OBIEE Administration (RPD) (Physical, Business Model & Mapping, and Presentation Layers), Answers, Dashboards, Catalog Manager.
  • Experience in OBIE Administration, configuring MUDE, OBIEE Schedule, usage tracking. Repository Sever and Presentation Server configuration changes, Cache management, space management.
  • Extensive knowledge in all phases of Software Development Life Cycle SDLC (Requirement Analysis, Design, Development, Testing and Documentation). Exposure to version tracking control systems.
  • Delivered Corporate Training on OBIEE to SCOPE International, Chennai.
  • Dedicated, conscientious individual with strong sense of responsibility, work flexibly and quickly adapt to the changing environments professionally and personally.
  • Experience in installation and configuration.
  • Experience in Informatica installation,configuration and Building Mappings&Maplets.
  • Experience in setup usage tracking.
  • Experience in data level and object level security implementation.
  • Experience in Dimensional and Relational Data Modeling.
  • Experience in LDAP configuration.
  • Experience in OBIEE 12C Installation and Configuration.
  • Experience in ODI11g/12c Installation and Configuration.
  • Experience in ODI11g/12c Mapping Design.

TECHNICAL SKILLS:

Fusion Tools: OBIEE 12c/11g/10g, OBIA 7.9.6, BI Publisher,OBIA11g,Hyperion ESSBASE, Hyperion Interactive Reporting

ELT Tool: Informatica,ODI11g/12c,BO Data Services

Database: Oracle10g/9i/8i, SQL Server 2005/2008/2012.

Languages: SQL

Operating System: Windows 7/8, Windows NT, UNIX.

Database Tool: TOAD, SQL plus 11.x/10.x/ 9.x/ 8.x, SQL Developer 4.0.2.15

PROFESSIONAL EXPERIENCE:

Confidential, MOUNT LAUREL,NJ

OBIEE Developer

Responsibilities:

  • RPD & Catalog deployments.
  • RPD Development & Enhancements.
  • Involved in Patch installation.
  • Involved in Report Testing.
  • Responsible for Developing ODI objects like interfaces, packages, variables, procedures
  • And scenarios to ensure the successful execution of the data loading Process.
  • Configuration of topologies and Data servers in ODI.
  • Customizing knowledge modules to ensure data load process faster.
  • Loading data into Warehouse from various sources involving CSV files and Oracle, SQL SERVER
  • Exporting and importing the scenarios from DEV to TEST and TEST to
  • PROD environments.
  • Responsible for Business meetings, conversion of business rules into technical design document.
  • Scheduling the jobs in ODI to load data from cloud to DWH.
  • Work closely with the end users and designing the documents to the track changes.
  • Configure mail server and send mail notification on completion of Jobs.
  • SAP BODS(ETL) to load data from oracle to SQL Server

Confidential, PHILADELPHIA, PA

OBIEE Developer

Responsibilities:

  • Production support and maintenance.
  • Creating Adhoc Reports based on user requirement.
  • Involved in Performance Tuning.
  • Security implementation.
  • RPD & Catalog deployments.
  • Schedule weekly and monthly reports using IBOTS.
  • Configured Usage Tracking for Auditing.
  • RPD Enhancements.
  • Monitoring DAC jobs.
  • Customization of Informatica mappings to load Flexi fields data into DWH.
  • Involved in Patch installation.
  • Involved in Report Testing.
  • Software Installation.

Environment: OBIA, Oracle 11g R2, Windows NT, OBIEE, DAC, INFORMATICA

Confidential, NEW YORK, NY

OBIEE Developer

Responsibilities:

  • Involved in requirements gathering.
  • Involved in installation and configuration.
  • Designed RPD using OBIEE Administration(Physical,BMM and Presentation layer)
  • Deployed rpd and catalogs using Enterprise manager.
  • Creating and enhancing pivot, chart reports using BI Answers
  • Utilized variables and initialization blocks in the repository
  • Created new reports and dashboards as per the business need
  • Analysis, Design, Implementation, documentations and BI specifications that in corporate OBIEE development standards & best practices as well as ongoing support for Data Warehouse.
  • Worked on performance tuning of various OBIEE Reports / Dashboard
  • Caching options configured and defined overall cache strategy
  • Implemented OBIEE security at the data and object levels
  • Created Oracle BI Publisher Reports.
  • Converting Oracle Reports in to Oracle BI Publisher Reports.
  • Bursting Oracle BI Publisher Reports.

Environment: Oracle Data Integrator (ODI) 11g/12c, OBIEE 11g/11.1.1.7, Oracle 11g/10g, SQL*Plus, TOAD, WinNT/7 and UNIX.

Confidential, Little Rock, AR

OBIEE Developer

Responsibilities:

  • Involved in requirements gathering.
  • Involved in installation and configuration.
  • Deployed rpd and catalogs using Enterprise manager.
  • Created new reports and dashboards as per the business need.
  • Analysis, Design, Implementation, documentations and BI specifications that in corporate OBIEE development standards & best practices as well as ongoing support for Data Warehouse.
  • Worked on Physical, Business Model and Mapping Layer and Presentation Layer of OBIEE Administration tool.
  • Caching options configured and defined overall cache strategy
  • Worked on performance tuning of various OBIEE Reports / Dashboard.
  • Leading the team and coordinating in sharing the daily status report of the ticket status
  • Monitoring the scheduled jobs.
  • Weekly status reviews with the team.
  • Created Oracle BI Publisher Reports.

Environment: Oracle Data Integrator (ODI) 11g/12c, OBIEE 11g/11.1.1.7, OBIA 11.1.1.7.1, Oracle 11g/10g, SQL*Plus, TOAD, WinNT/7 and UNIX.

Confidential, Newark, NJ

OBIEE Developer

Responsibilities:

  • Coordinated with the on - site and off-shore team and working on service requests as team.
  • Involved in designing the Star Schema.
  • Involved in software Installations.
  • Creating and enhancing pivot, chart reports using BI Answers.
  • Used different types of prompts and filters in Dashboards.
  • Imported reports into office Excel and PowerPoint
  • Implemented OBI security at the data and object levels.
  • Utilized variables and initialization blocks in the repository.
  • Upgraded catalog and rpd from existing 10g to 11g using upgrade agent (ua).
  • Creating and migrating iBots/Agents to 11g.
  • Set up Act As /Impersonation in OBIEE 11g, which helps to debug end user’s production issue.
  • Deployed rpd and catalogs using Enterprise manager.
  • Created new reports and dashboards as per the business need.
  • Analysis, Design, Implementation, documentations and BI specifications that in corporate OBIEE development standards & best practices as well as ongoing support for Data Warehouse.
  • Worked on Physical, Business Model and Mapping Layer and Presentation Layer of OBIEE Administration tool.
  • Caching options configured and defined overall cache strategy
  • Worked on performance tuning of various OBIEE Reports / Dashboard.
  • Creating Test cases for Unit Test, System Integration Test and UAT to check the data in OBIEE reports and dashboards.

Environment:, Oracle Data Integrator 11g, OBIEE 10g/11g, SOA 11g, Oracle EBS, Siebel CRM, WebLogic server 10.3 and Jdeveloper 11.1.1.6.0, Oracle 10g,UNIX, Windows 2003 Server.

Confidential, Chester brook PA

OBIEE Developer

Responsibilities:

  • Creating and submitting status reports to up line managements.
  • Analysis, Design, Implementation, documentations and BI specifications that in corporate OBIEE development standards & best practices as well as ongoing support for Data Warehouse.
  • Worked on Physical, Business Model and Mapping Layer and Presentation Layer of OBIEE Administration tool.
  • Caching options configured and defined overall cache strategy.
  • Worked on performance tuning of various OBIEE Reports / Dashboard.
  • Involved in designing the Star Schema.
  • Involved in software Installations.
  • Creating and enhancing pivot, chart reports using BI Answers.
  • Used different types of prompts and filters in Dashboards.
  • Imported reports into office Excel and PowerPoint.
  • Implemented OBI security at the data and object levels.
  • Utilized variables and initialization blocks in the repository.

Environment:: OBIEE 10g/11g, Oracle Data Integrator 11g, Oracle 10g, Siebel 8.0, UNIX, Windows 2003 Server.

Confidential

OBIEE Developer

Responsibilities:

  • Involved in designing the Star Schema.
  • Involved in software Installations.
  • Creating and enhancing pivot, chart reports using BI Answers.
  • Used different types of prompts and filters in Dashboards.
  • Imported reports into office Excel and PowerPoint
  • Implemented OBI security at the data and object levels.
  • Utilized variables and initialization blocks in the repository.
  • Created, modified and formatted requests, along with charts and filters, in OBI Answers.

Environment: OBIA, Oracle 11g R2, Windows NT, OBIEE, DAC, INFORMATICA

Confidential

OBIEE Developer

Responsibilities:

  • Involved in designing the Star Schema.
  • Involved in software Installations.
  • Creating and enhancing pivot, chart reports using BI Answers.
  • Used different types of prompts and filters in Dashboards.
  • Imported reports into office Excel and PowerPoint
  • Implemented OBI security at the data and object levels.
  • Utilized variables and initialization blocks in the repository.
  • Created, modified and formatted requests, along with charts and filters, in OBI Answers.
  • Utilized OBI Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to intelligence dashboards for subscribed users.

Environment: OBIEE 10.1.3.4.0, Oracle 10g, OWB and Windows NT

Confidential

OBIEE Developer

Responsibilities:

  • Involved in designing the Star Schema.
  • Created Views and materialized views.
  • Creating and enhancing pivot, chart reports using BI Answers.
  • Used different types of prompts and filters in Dashboards.
  • Imported reports into office Excel and PowerPoint
  • Implemented OBI security at the data and object levels.
  • Utilized variables and initialization blocks in the repository.
  • Created, modified and formatted requests, along with charts and filters, in OBI Answers.
  • Utilized OBI Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to intelligence dashboards for subscribed users

Environment: OBIEE 10.1.3.4.0, Oracle 10g, and Windows NT

Confidential

OBIEE Developer

Responsibilities:

  • Involved in software Installations.
  • Involved in designing the Star Schema.
  • Creating and enhancing pivot, chart reports using BI Answers.
  • Created Narrative view, sectional view reports.
  • Created IBOTS in order to schedule reports.
  • Created Dashboards with conditional formatting.
  • Used different types of prompts and filters in Dashboards.
  • Imported reports into office Excel and PowerPoint.

Environment: OBIEE 10.1.3.3.2, Oracle 10g, Informatica and Windows 2000

Hire Now