Background Summary:

Result Oriented IT professional with around 9+ years of progressive experience in the IT field and 7+ years of experience in Oracle Business Intelligence projects that span the full life cycle implementation of Oracle Business Intelligence/Siebel Analytics.

• Expertise in Developing Oracle Business Intelligence Solutions, gathering Business Requirements & implementing them using BI Tools as Siebel Analytics/OBIEE.
• Extensive experience in OBIEE/Siebel Analytics, Oracle BI Apps Data Warehousing and Informatica.
• Expertise in handling all phases of Software Development Life Cycle (SDLC) of the BI Projects.
• Experience in Upgrading the BI suite tools OBIEE 10G to 11G.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema, Snowflakes modeling, fact and dimension tables modeling of data.
• Expertise in design and development of three layers (Physical, Business model and Presentation) of an OBI Metadata Repository using Oracle BI Administration tool.
• Configured Answers (ad-hoc querying, reports), Interactive Dashboards with drill-down capabilities (charts/tables/graphs), Delivers/iBots (Agents) administered Web Catalog Objects.
• Involved in Business Model development with Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series and Cache Management.
• Participated in Security Setup at both Object and Data levels, which involved creation of users/groups, LDAP authentication setup Single- Sign-On of OBIEE.
• Setup the OBIEE 11G security by using Fusion Middleware Enterprise Manager and Oracle Web-logic Administration Console.
• Actively involved in using Repository, Session variables and Initialization blocks.
• Customized Oracle BI Applications and modified prebuilt solutions according to the requirements.
• Extensively used the four basic Informatica Power Center client tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor
• Actively involved in Installing, configuring and customizing DAC (execution plans, subject areas, tables, and task) and monitoring ETL process using DAC & Informatica workflow manager.
• Proficient in working on production, development & test environments in different RDBMS in Oracle 8i/9i,10g,11g and strong troubleshooting skills
• Strong experience in back-end programming with Oracle PL/SQL and SQL.
• Soft skills include excellent communication, ability to understand and analyze the client requirements and have the ability to work in a team as well as independently.

Technical Skills:

Reporting Tools

OBIEE 11.1.1.5 ,OBIEE 10.1.3.4, OBI Apps 7.9.6.x

ETL tools

Informatica Power Center 9.0,8.x/7.x, DAC 10.1.3.1.4

Database Tools

TOAD , SQL*Loader , SQL Developer

Databases

Oracle10g/9i/8i

Operating Systems

Windows, UNIX,LINUX

Languages

SQL, PL/SQL

Education:

Bachelors in Electrical & Electronics Engineering, India

Professional Experience

Confidential, Seattle WA Aug 2011 to Current
OBIEE Admin/ Develop

Starbucks Corporation (Starbucks) is the roaster and retailer of specialty coffee in the world, operating in more than 50 countries. Starbucks purchases and roasts whole bean coffees and sells them, along with handcrafted coffee and tea beverages and a variety of fresh food items, through Company-operated retail stores. It also sells coffee and tea products and license its trademarks through other channels, such as licensed retail stores and, through certain of its licenses and equity investees, the Company produces and sells a variety of ready-to-drink beverages. In addition to its flagship Starbucks brand, its portfolio includes brands, such as Tazo Tea, Seattle’s Best Coffee, and Starbucks VIA Ready Brew. Starbucks has three operating segments: United States (US), International, and Global Consumer Packaged Goods (CPG).

Responsibilities:

OBIEE 10G to 11G Upgrade:

• In the OBIEE 11G upgrade project our main goal is to upgrade the BI (Financial, Supply Chain Management) customizations to the Oracle BI significant release OBIEE 11G.
• I played a major role in upgrading the OBIEE (Answers, RPD and Web-Catalog) 10G to 11G
• OBIEE RPD & Web-Catalog Upgrade: Used the Upgrade Assistant (ua.bat) tool to upgrade the OBIEE 10g rpd and Web-catalog to the new version.

OBIEE 11G Security Setup:

• Configured LDAP to OBIEE 11g for Authentication in Web logic Admin Console.
• Modified all the OBIEE Security that has been completely changed from the previous versions 10g to the newer version of OBIEE 11g.
• 10g Web-Catalog has been upgraded to 11g and pointed on the server, but users were unable to login because of the changed Oracle BI 11G Security architecture.
• According to the new security setup - Refreshed all the (GUI’s) Global Unique Identifiers of the users to login to the OBIEE 11G Analytics.
• Removed all the users from the upgraded RPD and Created all the users and groups in the Web Logic Administration console, assigned all the users to the required groups.
• Created Application Roles and policies in the Fusion Middleware Enterprise Manager and added the users.
• Created multiple roles and added for all the customizations dashboards.

Commercial BI Implementation:

• Configured & Created Repository using OBIEE 11.1.1.5 Admin Tool.
• Worked extensively in importing required table related to OBI Apps (Order Management Analytics) & derived many more logical columns in Logical Layer.
• Designed Schema/Diagrams using Facts, Dimensions, Alias tables.
• Generated various Analytics Reports like Formulary Report & Daily Sales Report using Global Filters.
• In the commercial BI project our main goal is to build multiple dashboards for Gross Profit Trend and Comparing the Volume against current year to the previous year for the analysis.
• Designed and developed the Sales-rep level security for all the Commercial BI dashboards.
• Designed and developed multiple dashboards for the Finance Managers & Account Executives comparing the year over year volume analysis.
• Trained business users in getting familiar with OBIEE 11g in developing the reports

Environment: Oracle 11.1.1.5, OBIEE 10.1.3.4.1, BI Apps 7.9.6.3, Oracle SQL, SQL Developer, SQL, Windows XP

Confidential, Seattle WA Nov 2010 to July 2011
OBIEE Developer

Amazon.com Inc. is a leading global Internet company and one of the most trafficked Internet retail destinations worldwide. Amazon is an online shopping website with one of the largest product supplies online. Amazon directly sells, or acts as a platform for the sale of, a very broad range of products, including books, music, videos, consumer electronics, clothing and household products. The majority of Amazon’s sales are products sold by Amazon, with the remaining amount from third-party sellers.

Responsibilities:

• Understandingthe client Requirement.
• Working with Business User to make sense of business performance by adding context to real –time business measure.
• Gathering the Business Requirement and designing Technical design Documents.
• Create Metadata repository as per business requirement at three layers in Oracle BI Admin Tool.
• Created Alias tables when required to avoid Circular Joins in the OBIEE Repository.
• Designed Oracle OBIEE Repository at 3 layers Physical Layer (Connecting data source & import schema),Business model/data mapping (create logical tables & data source mapping ) and pulling into Presentation layer as per business Requirement.
• Create new logical columns, Dimensional hierarchy, Calculated measure, and mapping in BMM Layer.
• Developed Time series objects using Ago and To-date Functions for time series comparisons.
• Created Repository Users, Groups and Web Groups and assigned users to configure security in the OBIEE Server.
• Defined Repository, Session and Presentation variables using the Variable Manager in OBIEE Administration Tool
• Work on Ad Hoc Report as per business requirement. Developed custom reports/Ad-hoc queries using Answers and assigned them to application specific dashboards.
• Created and customized different views in report by making extensive use of View Selectors
• Created Prompted Reports which can be used in the Dashboard for page level or dashboard level Prompts in Answers
• Configured IBots to deliver Analytics content based on schedule, automated IBot queries to obtain daily and weekly reports as per the business requirements.
• Fixed the issues in the migrated environment by troubleshooting and testing the reports.
• Implemented various caching techniques for Performance tuning in OBIEE.
• Investigated and identified low performance queries and optimized them.
• Worked on building a repository and administering the Query Environment, Scheduler, Query Cache usingOBIEE
• Extensively used SQL Queries for troubleshooting, testing data level errors and cross-checking values.
• Extensively worked in migrating the repository from development to Test & Production environment.

Environment: OBIEE 10.1.3.4.1, Oracle PL/SQL, SQL Developer, SQL Loader, Windows XP

Confidential,Denver CO March 2010 to Nov 2010
OBIEE Developer

Confidential, provides the financial expertise to help people for life’s other goals along the way with a full array of financial products and services like Retirement plans, Education savings, Mutual funds, Life Insurance etc.., My Responsibility at this client is to gather requirements for the new reports and develop them using Answers and consolidate the existing reports .

Responsibilities:

• Worked Closely with the business team in understanding the business and the requirements for the development of repository and reports
• Designed Functional and Technical documents after gathering the requirements
• Developed OBIEE Metadata repository (.rpd) that consisted of Physical layer, business model and Mapping layer with Aggregates, Dimensions and time Series objects, and presentation Layer
• Extensively worked on Repository in defining Facts, Dimensions and Aggregation rules as per the business
• Implemented Object and data level security in administration tool
• Extensively worked on developing reports using the OBI Answers and published them on Dashboards
• Used various types of views i.e. Pivot, Column Selector, View Selector and so on while generating the reports
• Developed reports by using the local and global filters and various types of Dashboard prompts which made users easier to view the reports as their needs
• Implemented the external table authentication and utilized the external table by implementing dynamic variables and Initialization blocks in repository
• Extensively used different performance tuning methods like Caching, Aggregate tables and creating indexes on tables.
• Performed the Security management for users, groups and web-groups using the various authentication systems.
• Scheduled reports using iBots to send alerts in OBI Answers to deliver the information to Business Users.
• Worked on BI Publisher in developing the templates and generating the reports.
• Fixed the issues caused while generating the BI Publisher reports in Siebel Application.
• Prepared Functional and Technical Design documents for Reports.
• Performed transformation of Business Requirements to the ETL Mappings.
• Created complex business mappings involving various transformations like Aggregator, Sorter, Source Qualifier, Lookup, Filter, Expression, Router and Update strategy transformations.
• Developed transformation logic and designed various Complex Mappings and Mapplets using the Designer.
• Involved in unit, integration testing and User Training of the generated reports using Analytics. `

Environment: OBIEE 10.1.3.4, BI Apps 7.9.6.2, Oracle 10g, SQL developer, Informatica 8.6.1, Power Image EXP AG

Confidential,Sterling, VA Jan2009-March 2010
OBIEE Developer

Confidential,Transportation Management system delivers robust transportation planning and execution capabilities to shippers and third party logistics providers. It integrates and streamlines transportation planning, execution, freight payment, and business process automation on a single application across all modes of transportation, from full truckload to complex multi-leg air. Using the actual shipment data captured throughout the logistics lifecycle process, DHL Transportation Management System ensures that you are paying, billing, and tracking only for the transportation services that were provided.

Responsibilities:

• Interacted with business representatives for requirement analysis and to define business and functional specifications.
• Created/Modified Metadata repository (.rpd) and Configured Metadata Objects using OBIEE Admin tool.
• Configured measures in the Business Model Layer and mapped to multiple logical source tables.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Setup the visibility of Dashboards to employees with respect to their responsibilities.
• Configured & published Delivers / iBots to deliver analytics content based on schedule, automated related queries to obtain daily & weekly transactions by Emails.
• Administered permissions and privileges for Dashboard visibility and modifications to users based on their groups or responsibilities.
• Created templates for presenting results and Analytics and modified the Dashboard using cascading style sheets.
• Implemented comprehensive security functionality by creating users & web groups, setting up LDAP authentication and associating catalog objects and Web modules with the created users and groups.
• Developed Mappings and Workflows using various Transformations (Update Strategy, Router, Expression, and Aggregator).
• Data warehousing development using ETL Tools such as Informatica Power Center 8.1 and experience in DAC (Data warehouse Application Console) Configuration.
• Wrote complex SQL queries and PL/SQL programs to retrieve the information from the interface and update the information in TMS Application.
• Written Oracle Stored Procedures, Triggers and Packages and Materialized Views to effectively incorporate Business Logic and providing security by wrapping the contents.

Environment: OBIEE 10.1.3.4, Informatica Powercenter 8.6.1, DAC 7.9.5, Oracle 10g (SQL, PL/SQL), SQL Developer, TOAD, Windows Server 2003

Confidential, Kansas Jan 07 – Dec 08
OBIEE Developer

Confidential, is an intranet application that does the order processing for cable wire line VOIP orders (Digital Phone) submitted by the cable partners such as Time Warner Cable, Mediacom and Sudden Link. This project involves creating the UI for order processing, creating web services for secure transportation, creating windows services and automation packages to interact with other internal applications.

Responsibilities:

• Involved in the business user meetings and subject area layouts.
• Involved in Creating and Administering the Physical Layer, Business Model & Mapping Layer and Presentation Layer in a OBIEE repository.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Developed custom reports/Ad-hoc queries using Answers and assigned them to application specific dashboards.
• Developed different kinds of Reports (Pivots, Charts, Tabular) using global and local Filters.
• Configure and interactive Dashboards to alert the Marketing team about business changes.
• Managed day-to-day repository (.rpd), Delivers, Scheduler & iBots.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Created Virtual Dimensions (Aliases) on the original tables, and used them to join to other fact tables.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Involved in Design and Data Modeling using Star schema.
• Involved in upgrading the platform and applications to OBIEE though sequential and concurrent tasks which includes upgrading webcat, scheduler and migrating the rpd.

Environment: OBIEE 10.1.3.3, Siebel Analytics, Informatica 8.1, DAC, Oracle 9i, SQL*Loader, HTML, Windows NT/2000 and UNIX