SUMMARY:

• 4 years of experience in gathering Business Requirements, Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence
• Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow Flake Schemas using Ralph Kimball and Bill Inmon Methodology
• Extensive Business Intelligence and Data warehousing experience using OBIEE 11g/OBIEE 10g, Oracle BI Apps7.9.x OBIEE Prebuilt, BI Publisher, Informatica 9.x/7.x/6.x and DAC 10g/11g.
• Strong Experience in implementing the Oracle BI Order Management in respect with integrating ERP Systems like Oracle EBS.
• Extensive Experience in OBIEE Administrative Tool, OBIEE Answers/Analysis, OBIEE Dashboards, OBIEE Delivers and BI Publisher in designing, developing and with prebuilt.
• Very strong experience in developing OBIEE Analytics Repository (.rpd) - three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Siebel/OBIEE Interactive Dashboards with drill-down capabilities using global & local Filters, Siebel/OBIEE Security Setup (groups, access / report level and object level), configured Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling iBots/Agents.
• Good Experience in managing the OBIEE 11g Weblogic Console and Enterprise Manager .
• Experience in installing OBIA 7.9.6.3
• Very strong in developing Informatica Mappings / Mapplets using various Transformations for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and creating Workflows with Worklets & Tasks and scheduling sing both Workflow Manager and Unix Shell scripts (using pmcmd)
• Expertise in database Performance Tuning by implementing Parallel Execution, Partitions, materialized views with query rewriting, creating appropriate indexes, usage of hints, re-building indexes and also used the Explain Plan and SQL Tracing.
• Good Knowledge in ODI 11g, OBIEE 11.1.1.7.x and OBI Apps 7.9.6.3 .
• Good Working Knowledge in creating KPI’s and Scorecards in OBIEE 11.1.1.3/.5/.6.
• Very strong in PL/SQL Procedures, Packages, Functions, Triggers and other objects
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers and developers across multiple disciplines.

TECHNICAL SKILLS:

• OBIEE 11.1.1.3/11.1.1.5/11.1.1.6/11.1.17.1/11.1.1.9.1/12 c (Admin
• Web
• Answers
• Dashboards)
• Scheduler
• BI Publisher
• BI Apps 7.9.x
• Informatica 9.x/7.x
• DAC 10g/11g
• ODI 11g
• Oracle 9i//11g
• MS-SQL

PROFESSIONAL EXPERIENCE:

Confidential

Tools: OBIEE with ODI 11.1.1.7.1

Responsibilities:

• Complete lifecycle development from creating data model to reports testing.
• Installation and setup of OBIA 11.1.1.7.1
• Creating interfaces in ODI 11g
• Creating and executing load plans, packages
• Debugging errors in ODI
• Developing data models (star schema) in OBIEE 11g RPD.
• Developing and customizing complex reports in OBIEE 11g
• Creating BI Publisher reports and direct DB related reports
• Developing interactive graphs and views in OBIEE.
• Creating RCAs, Technical, Test Evidence and Performance documents.

Tools: ODI, OBIEE 11g

Confidential

Responsibilities:

• Complete lifecycle development from creating data model to reports testing.
• Interacted with business users for requirement gathering, understanding current implementation and environment.
• Understanding ODI 11g metadata tables and their relationships
• Creating data model, dimensional hierarchies with the ODI metadata tables in OBIEE 11g
• Running OBIA load plans on client DEV environment for testing/debugging functionality of OBIEE lineage reports and dashboards.
• Creating reports, dashboards, direct SQL reports to show the status, information of daily running load plans
• Creating views like Bulb, Gauge, graphs, pivot tables, conditional formatting, bins etc. to make reports more user friendly
• Documentation and POC

Confidential

Offshore Developer

Responsibilities:

• Automating Discoverer reports to OBIEE migration
• Involved in creating Oracle queries to fetch discoverer data from EUL metadata.
• Modifying configuration (XML) files in OBIEE.
• Applying object level security to OBIEE dashboards and reports by creating Application roles, groups using WLST commands.
• Using various utilities to migrate discoverer reports to OBIEE.
• Upgrading OBIEE catalog

Confidential

Tools: Oracle BI Apps 7.9.5/7.9.6, Informatica 8.1.1, DAC, Oracle11g, SQL Developer, Oracle E- Business Suite 11.5.10, R 12, PL/SQL.

Responsibilities:

• Interacted with Business Users and Business Analysts for gathering new business requirements and understand the current requirements and Data Analysis.
• Configured of Scheduler, Delivers and Cache Seeding by using Ibots.
• Customized OOB mappings in Informatica as per user’s requirement.
• Involved in assisting building detailed project schedule, gathering the requirement, completed the proof of concept in translating functional requirements into technical requirements, designed, developed and making Technical designs and Unit test scripts
• Gathered requirements from the users and generated prototype reports to help the business to visualize the design.
• Involved in upgradation of DAC 10g to DAC 11g . (Running Parallel Execution Plans)
• Responsible for all activities related to the development, implementation, administration and support of ETL processes and for scheduling using DAC and reporting using OBIEE
• Configured DAC - Data warehouse Access control for running of ETL jobs
• Worked with all three layers in the repository - Physical, Business, and Presentation Layer.
• Worked on security for users based on Authentication type in Production and other Authentication types ( External table authentication and Database) in other environments.
• Implemented the Cache Purging Strategy and usage tracking of Reports
• Defined dimensional hierarchies and associated the proper level of granularity to the fact table.
• Added column/data level security at the repository level. The data was restricted with respect to the group user belongs too.
• Created Summary and Detail reports per user requirements and created corresponding dashboards for the reports.
• Customized Out of Box Dashboards and Reports as per the User requirements given by the client.
• Actively involved in deployment and post release support.
• Trained the users on how to use the Dashboards and Answers and modify the stored reports in Answers.