PROFESSIONAL SUMMARY:

• Over Seven years of experience in Business Intelligence and Transactional applications, Design and Implementation of DataWarehouse/Data Mart, Gathering Business User Requirements, System Analysis, Design and Data Modeling.
• Over 4 years of experience in all phases of design, development, and implementation of Financials, Procurement and Spend (P2P), Order Management and Inventory (SCM) and HRMS Analytics.

• Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas using Ralph Kimball Methodology.
• Very strong experience in developing OBIEE Repository (.rpd) at three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Interactive Dashboards with drill-down capabilities using global & local Filters, Security Setup (groups, access / query/report privileges), configured Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling iBots.
• Hands on experience in Authentication and Authorization of OBIEE by using LDAP, Database authentication, External Authentication and also implemented Single Sign on (SSO).
• Expertise in DataWarehouse Administration Console (DAC) to configure, monitor and schedule ETL.
• Involved in development of RICE objects (Reports, interfaces and data conversions, customizations, extensions) for the Oracle Applications E-Business Suite implementation across major modules.
• Experience in design, analysis, development, testing and implementation of applications in Oracle E-Business Suite using PL/SQL, Developer 2000, Oracle Reports 10g/9i/6i, Oracle Discoverer 10g/4i, XML Publisher 5.6.3/5.6.2.

• Expertise in implementing Security Models for Dashboards, Row level, object Level, Role Level, Dashboard Level
• Experience in creating Aggregate tables using materialized views and using Aggregate Persistence wizard.
• Expert in converting Functional specs to Technical Specs and implementing OBIEE Best practices.
• Expertise in configuring Interactive Dashboards with drill-drown capabilities using global and local filters, Security setup (groups, access/query privileges), metadata objects and web catalog objects (Dashboard, Pages, Folders, Reports).
• Expertise in implementing Oracle BIApps in all phases like implementing Out of the Box prebuilt mappings, Designing ETL, metadata management using DAC, Creating Oracle provided DataWarehouse ,OBIEE RPD development, OBIEE reports and Dashboards

• Experienced in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, DataWarehouse Administration Console (DAC), Informatica Power Center.
• Strong experience in developing and customizing Reports using OBIEE 10.1.3.4.1/10.1.3.4.0/10.1.3.3/10.1.3.2, Oracle Reports 6i/4.5/2.5 Discoverer 10g/4i/3i , XML Publisher 5.6.3/5.6.2.
• Extensively Worked on Informatica Power Center 8.x/7.x.
• Extensively Worked on Informatica Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, Aggregator.

Education & Certifications:

•  B.Tech Computer Science, JNTU, HYD, India.
• Oracle Certified Associate(OCA)

 Technical Skills:

OBIEE

Siebel

Informatica

DAC

Oracle e-Business

 Functional 

Developer 

Financials, Supply Chain, HRMS, Procurment & Spend