Professional Summary

7 years of progressive experience in IT industry specific to Oracle technologies like OBIEE 10g/ 11g, Oracle Business Intelligence Apps OBIA . Oracle BI Publisher, Oracle Reporting Tools, Oracle PL SQL, Oracle SQL and Oracle Database

Expertise:

• Experienced in using Business Intelligence Applications like Financial Analytics, Procurement and Project Analytics.
• Experience in developing Interactive Dashboards with drill-down capabilities using global and local Filters, Security Setup groups, access/query privileges , Metadata Objects and Web Catalog Objects Dashboard, Pages, Folders, Reports .
• Experienced in full life cycle development of OBIEE implementation projects and understanding of all aspects of Business intelligence reporting applications development.
• Experienced in gathering Reporting analysis requirements, writing of technical design documents, development, testing and migration activities.
• Experienced in working with OBIEE administration tool / repository rpd and development of Physical Layer, Business Model Mapping Layer and Presentation Layers.
• Experienced in designing the data model including fact tables, dimension tables, hierarchical objects.
• Experienced in defining key metrics, dimensions, hierarchies, Aggregate Navigation, Aggregates based on dimension, Level Based Measures, Variables, Initialization blocks, Cache Management.
• Experienced in configuration and publishing of the iBots to deliver analytics contents based on schedule, automated iBots queries to send all the periodic transactional data to users through email delivery.
• Experienced in PL SQL development including Packages /Procedures /functions/ materialized views/ views.
• Experienced in Debugging, Optimizing and Performance Tuning of Oracle BI Dashboards/Reports/SQL queries.
• Experienced in working with SQL Developer, SQL Plus, TOAD, Oracle BI Publisher, Oracle Reports, and Oracle Discoverer.
• Experienced in working on Oracle E Business Suite Financials and supporting ETL Teams in extracting data from EBS Environment for data ware house project supporting the OBIEE reporting environment.

Technical Skills:

Oracle 10g / 11g, OBIEE 10g/11g, OBIA Financial Analytics and Project Analytics , Oracle Discoverer, Oracle Reports, BI Publisher , Oracle E Business Suite Financials , Oracle PL SQL , Oracle SQL , SQL Developer, TOAD , UNIX

Work Experience

OBIEE Consultant

Confidential

Responsibilities:

• Designed and developed the OBIEE Metadata Repository .rpd using OBIEE Admin Tool / OBIA Financial and Project Analytics by importing the required data base objects both Facts and Dimensions with integrity constraints into physical layer using connection pool. Developed Dashboards and Ad hoc reports.
• Configured and developed BI Apps Financials and Projects .
• Worked on multiple reporting requirements of CARTUS Financial systems and ATLAS Move Management system reporting requirements like preparing financial dashboards including revenue, expenses and assets by business segments, cos centers, expenses dash boards and Profitability reports for each Major account , Vendor Spent and commissions payouts reports by Account.
• Worked on Oracle Financials R12 BI Publisher reports and also worked on extracting the data from Oracle ERP to local data ware house systems.
• Worked with business users on reporting requirements and security group's access permissions etc.
• Imported Physical tables from Oracle database and defined relations between Physical tables at the Physical Layer
• Worked on building OBIEE Repository at 3 layers i.e., Physical Layer, Business Model and Mapping Layer and Presentation Layer.
• Mapping in data sources using OBIEE Admin tool to create repository rpd
• Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per the business requirements
• Developed Time Series Objects using period Ago and To Date functions for time series comparisons.
• Created various session and repository variables and initialized them in the Initialization Blocks to change metadata dynamically as the environment changes.
• Configured BI Scheduler to deliver alerts and publish updated content to subscribed users as per the schedules and business requirements.
• Used various cache management techniques for performance tuning including configuring, defining cache parameters, cache persistence time, cache seeding and purging, and event polling.
• Created security settings in OBIEE Administration Tool and set up groups, access privileges and query privileges and also managed security for groups in OBIEE Answers.
• Integrated BI Publisher with OBIEE to build reports in word, excel and doc format.
• Customized Reports look and Feel using Column Formatting, Conditional formatting
• Developed and debugged many Dashboards using different Analytics Views Pivot, Table, Chart, and Column Selector, View Selector , Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.
• Maintained iBots to deliver the messages and group mails to the business users with the periodic daily / weekly /Monthly etc. reports
• Involved in migration of Analytics rpd and Web Catalog objects from developing environment to QA environment and to the Production environment.

Environment: OBIEE 11g,OBIA, Oracle 11g, Windows 2003 Server, Oracle E-Business Suite R12, BI Publisher, SQL, PL/SQL, Oracle Discoverer , Oracle reports

OBIEE Consultant

Confidential

Responsibilities:

• Panasonic has implemented OBIA Oracle Business Intelligence applications Financial, Procurement analytics and integrated with Oracle EBS and OBIEE development environment. I worked as OBIEE developer to develop dash boards, configuration and managing of analytics, security groups and scheduling of deliveries.
• Worked with the Business users for requirement gathering and defined requirement specifications documents.
• Configured and developed BI Apps Financials and Procurement modules.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer
• Created numerous interactive dashboards and reports that provide insight into the financial data to all levels of management reporting needs.
• Developed Calculated Measures and assigning these Aggregation levels based on Dimension Hierarchies.
• Created business reports using BI Answers, and various analytics reports based on end users requirements.
• Developed Month Ago, Year Ago Measures for Comparison of Sales and Used Time Series Functions and To Date Functions Extensively.
• Created Aggregated Tables and Configured the Content in Business Model Layer to use the Aggregate Tables for better Performance.
• Worked on PL SQL development, SQL Queries supporting the user reporting requirements, Extraction of data from the application systems.
• Created Complex Joins, Alias Tables and Views.
• Tuned OBIEE Reports and designed Query Caching and Data Caching for Performance Gains.
• Worked with materialized views and aggregates to improve the performance.

Environment: OBIEE 11g,OBIA, Oracle 11g, Windows 2003 Server, Oracle E-Business Suite R12, BI Publisher, SQL, PL/SQL, Oracle Discoverer , Oracle reports

OBIEE Developer

Confidential

Responsibilities:

• Worked on with wealth management business unit users on requirements gathering and performing gap analysis, and documenting them into business reporting.
• Worked with Financial Analytics module of Business Intelligence Applications.
• Created reports and dashboards to bring in variety of information at reporting dash board where users can review the revenue, leads, and client engagement history and referral fees. Developed data models and Created metadata repository .rpd as per business requirements at three layers in Oracle BI Administration Tool.
• Created metadata repository .rpd as per business requirements at three layers in Oracle BI Administration Tool.
• Defined Physical Diagram by defining foreign key Joins and developed Business Diagram in BMM layer to define Business Model and requirements.
• Defined multiple Dimensions Drill-Down Hierarchies Logical Facts /Measures objects in Business Model Layer, and created the Presentation catalogs in Presentation Layer.
• Worked extensively on Answers, Delivers, and Intelligent Dashboards for financial reporting and related Analytics.
• Developed Various Dashboards and Reports and Created the Business Model for Ad-hoc queries using Oracle BI Answers and assigning them to application specific dashboards.
• Extensively used Repository Variables, Session Variables and Initialization Blocks for Configuring the Data and User Security.
• Managed and provided Permissions for Reports and Dashboards in OBIEE Presentation Services Web Catalog.

Environment: OBIEE 11g,OBIA, Oracle 11g, Windows 2003 Server, Oracle E-Business Suite R12, BI Publisher, SQL, PL/SQL, Oracle Discoverer , Oracle reports

Confidential

BI Developer

Responsibilities:

• Worked on Corporate services Project Tracker reporting requirements and involved in business requirements study and development of Reporting solution using OBIEE tool.
• Worked with multiple team members and business users on detail solution design and integration with data sources.
• Developed multiple dash boards for revenue management by each project management group, technology services aging invoices, Labor hours spent on multiple projects, commissions paid out by each business groups, sub-contractor project commitments, client invoicing reports etc.
• Created and administered the Physical Layer, Business Model and Mapping Layer, Presentation Layer in OBIEE Administrator tool.
• Designed and build Oracle BI Analytics data model, designed customized Star and Snowflake schemas by extending Fact and Dimension tables
• Created Dimensional Hierarchy, Logical columns, Aggregate columns, Level based Measures and Aggregate navigation in BMM layer
• As per client requirements designed Answers, interactive dashboards, filters, prompts, guided navigation.

Environment: OBIEE 10g, Oracle 10g, Windows Server, OLAP data base, BI Publisher, SQL, PL/SQL

Oracle Technical Consultant

Confidential

Responsibilities:

• Involved in gathering the requirements, performing gap analysis, and documenting them into business reporting.
• Created reports and dashboards for review by the business users.
• Created metadata repository .rpd as per business requirements at three layers in Oracle BI Administration Tool.
• Developed Custom code for conversion of the data from one source system to another application systems using Oracle SQL, Oracle PL SQL tools.
• Worked Report development using Oracle Reports , Oracle SQL
• Account Analysis Reports, Aging Reports, Supplier History Reports and Asset Register Reports.
• Provided Production support for all Financial Applications.
• Developed deployment scripts using FND Load and UNIX Scripting to move the code from one instance to another instance.
• Worked on system administration and Application Object Library for defining responsibilities, value sets, lookups developed various new OBIEE reports according to the business requirement specifications including etc.

Environment: OBIEE 10g, Oracle 10g, Windows Server, OLAP data base, BI Publisher,

SQL, PL/SQL

Oracle Developer

Confidential

Responsibilities:

• Worked on Interest rate calculation program development using Oracle PL SQL, Oracle SQL and Oracle Reports.
• Worked on Oracle Applications development of Interfaces and Conversions.
• Worked on Oracle report development using oracle reports, oracle discoverer and XML publisher.
• Worked on development Technical specification documents for all the development work done.
• Worked on extract program to pull the data from multiple data sources and send it to data warehouse applications.