SUMMARY:

• Over Thirteen years of professional experience in Oracle, in all phases of software life cycle with expertise in OBIEE v 11G and 10x,Discoverer v 3.36 thru 11g, EPB, DBI 6, Business Intelligence for Financial HR and Supply Chain modules, Data Integration using SAP BODS 4.x, Discoverer Administration, Desktop, Plus and Noetix Views v5 and 6.Involved in Implementation of BI, DBI and OBIEE projects, Upgrade projects for Discoverer and OBIEE with full life cycle of Requirement Analysis, Design, Development, Implementation and Testing.
• As a dynamic Oracle BI/DBI and OBIEE consultant, I am capable of analyzing business requirements and developing innovative solutions to optimize business processes and productivity.
• Also I have a proven track record of success in implementing Oracle technical solutions for businesses in a cross section of industries.
• Manages a Multi Dimensional and Multi member Projects to help the Clients go to the Next level as far as the Business Intelligence Initiative is concerns
• Provided Consulting to the existing teams as a SME for Oracle BI 11g Products mainly OBIEE, Business Objects Data Services(BODS 4.2),Fusion Middleware Applications and Discoverer
• Involved in Gap Analysis Study to recommend a powerful and robost BI Reporting solution, Oracle Discoverer Views 11g v/s Noetix Views 6
• Responsible for the Implementation of Noetix Views v 6.01 with Noetix Web Query as the front end application which finally slated to replace the existing Discoverer environment.
• Defined the business rules and helped the entire team of ETL Developers who were involve in the development of various transformations using BODS 4.2 to map data into the new targeted system
• Expertise in Setup of Repository, Formulas, Prompts and Dash Boards
• Experience in configuration of seeded KPIs and Dashboards for BI and DBI Finance, Supply Chain, Procurement and Human Resources modules. Implemented EPB for Financial Reporting requirements, Setup of EPB GL link, Setup of Dimensions, Hierarchies
• Ensures the alignment of various stakeholders in BI projects from the scratch and took the clients to the next level

ORACLE SKILLS SUMMARY:

Oracle: Apps 10.7,11.3,11i and 12 Supply Chain, Procurement, Financial( AP,AR,FA and GL)Order Management (OM), Purchasing (PO), Inventory (INV), OPM, Sales & Operations and HR

Oracle Technical: OBIEE 10G and 11G, OBIA Financial and HR Analytics, Data Integrator, PL/SQL, Data Conversions, Discoverer v3.6 thru 11g, XML Publisher 5.6,Noetix Views v 6.0.1 Noetix Generator/Query Server,Web Query and Business Objects Data Services ( BODS 4.2 ) 2 - 10

Environment: UNIX, Windows 95/98, 2000,NT,7 and Vista, Oracle 8,9i,10g and

Tools: SQL Plus, Toad, SQL Loader, Developer6i,Pl/SQL Developer

Methods: Oracle AIM for Documentation and Test Scripts preparation

Datawarehousing: Well versed with the Star Schema and the Snow Flake Technique

ORACLE CONSULTING EXPERIENCE:

Confidential, Minneapolis, MN and Plymouth, MI

Oracle BI Analyst/Consultant

Environment: OBIEE 11g, Discoverer 10G/11G Admin, Desktop Viewer and Plus, Oracle EBS r12 ( financials, manufacturing, Projects and Purchasing) BODS4.2 ETL, SQL* Plus, PL/SQL and Oracle Fusion Middleware Applications

Responsibilities:

• Involved in this project from requirement gathering, documentation and delivery
• Lead the team to understand the functionality of the Discoverer 11G and conforming it to work with EBS r12 which involves a hands on approach in the creation of the Datawarehouse/Datamart, EUL and corresponding objects to fulfill the business requirement
• Acted as an SME in their development effort from ETL, modeling and reporting perspective
• Helped the team in creating a Datamart from Scratch to conform the cross functional business requirements of various oracle standard delivered reports.
• Involved in detailed mappings and expression development where BODS toolset was used and also assisted the offshore development team in defining business rules and how they can be achieved by using various transforms available in BODS 4.x
• Lead the team of developers to develop detailed mapping/functions and transforms in migrating existing reports originally written in Business Objects
• Migrated the existing reports to the higher version from Discoverer 4i to 11g and also converted the Business oibjects reports to OBIEE Answers
• Worked exclusively in rewriting the standard oracle reports as custom dashboards esp Sales Order Acknowledgement report, AR Aging Trial Balance and Daily Sales Outstanding report in AR Item to cost Summary and detailed report in PO, Travel Cost Summary and detailed report in HR and Price Confirmation Report in Sales and Operations
• Developed a detailed test cases to test these developed and migrated reports and assign work to fellow developers accordingly
• Trained the users to use the new centralized reporting environment and also developed the security mechanism available in OBIEE 11g

Confidential, Las Alamos, NM

LOracle BI Consultant

Environment: Oracle 10g,11g SQL* Plus, PL/SQL, Oracle Discoverer 11g Admin Desktop Viewer and Plus, Oracle BI Apps v7.x and Web Logic,HR Analytics, Financial Analytics, Oracle EBS r12 ( financials, manufacturing, Projects and Purchasing) Oracle Fusion Middleware Applications, Noetix Views, Noetix Generator, Noetix WebQuery and Query Server v 5 and 6

Responsibilities:

• Responsible to oversee this project and to lead the team to understand the Functionality of OBIEE11G, Fusion Middleware Applications/Discoverer 11g
• Created numerous cross functional reports from scratch involving Financial (GL AP AR) and Projects modules, like Travel Cost Summary and detailed report etc which serves as the focal point in the entire department of Energy spending
• Involved in the customization of various HR Analytics out of the box solution and make them possible by mapping the data in conformation to r12 upgrade
• Used the Noetix Generator to create the EUL which replaced the existing EUL US of Discoverer
• Involved in training programs for user community to teach them how to use Noetix tools which is slated to replace the Discoverer plus and viewer
• Involved in creation of various Dashboards which helped in the Decision making policy of the entire DOE Financial team comprising the executive level managers
• Created some 170 OBIEE reports in Financials and HR systems and helped in creation of the environments ( the RPDs ) for them
• Provided expert level 2/3 level user support to address various techno-functional issues in the HR and Financial Analytics
• Helped in the Data Integration initiatives involving the Informatica and PL/SQL tool sets
• Worked extensively with the user community in SIT and UAT also created a test plan in the process

Oracle BI Architect

Confidential, Norman, Ok

Environment: Oracle 10g, SQL* Plus, PL/SQL, Oracle BI SE-- Discoverer 11g Admin and Plus, OBIEE 11g and Web Logic, Oracle EBS r12 ( financials, manufacturing, OM, PO, Inventory and WMS

Responsibilities:

• Worked extensively with Physical Layer, Business Layer and Presentation Layer
• Created numerous executive level reports to fulfill the gap of non existence of the WMS reports. 'Dashboards' were generated to provide insight into the financial data
• Responsible for different types of Customization in the delivered Reports to bring in the required functionality of Drilldown and Aggregation rules
• Worked extensively on WMS. Item to cost( ITC), Supplier appearance report while PO auto requisition is uploaded, AR Aging trial balance report and Daily Sales Outstanding ( DSO ).Various measures were created in the process to see the detailed breakdown per customer,per region and per country and thus created custom hierarchies for the globally spreaded users
• Created new Facts and Dimensions and used some of the existing confirmed dimensions to build multiple data models for HR Analytics
• Created custom measures and formulaes in the Business Model layer and made it available for the users to use them in reporting
• Added users and configured security in web logic console of OBIEE 11g
• Managed security privileges for each subject area and dashboards according to user requirements
• Setting up LDAP authentication to enable Single Sign on for Users in Development environment leveraging Analytics Repository

Oracle BI Architect/OBIEE Admin/Developer

Confidential, Rockville, MD

Environment: Oracle 10g, SQL* Plus, PL/SQL, Oracle BISE/Discoverer10g Admin/ Desktop, Plus/Viewer, OBIEE,MS SQL server 2008 and SSRS

Responsibilities:

• Involved in this multi task and tool project from scratch to develop the reporting infrastructure for the company’s reporting services which is an integral part of the DSS
• Converted reports who were originally written in SSRS to OBIEE
• Installed the OBIEE system from scratch and configured the repository as well as their Business and Presentation Layers
• Used the Snow Flaking Techniques to create this Data warehouse which conformed to the Star Schema
• Developed the reports using BI Answers and also trained the users to use it
• Used various feature in OBIEE like the MUD environment and its security system to enhance the functionality
• An ongoing and open ended project due to federal govt’s requirementwhere the customers/users are spreaded all over the country

Oracle BIEE Admin/Developer

Confidential, Houston,Tx

Environment: Oracle 10g, SQL* Plus, PL/SQL, Oracle BI SE, Discoverer 10g Admin/ Desktop Plus/Viewer, OBIEE,and MS Office

Responsibilities:

• Designed and implemented a Metadata Repository providing a centralized information source for the data models, data maps, processes, documents, contact lists, project calendars and issues affecting the Companies merger process.
• Created and recreated various views i.e materialized views and also took advantage of the oracle delivered Business Views to see the business functionality is been brought in
• Involved in the project from the scratch to upgrade their reporting applications from r11i to r12
• Did a thorough inventory of reports and also responsible for the gap analysis thus by created the Data warehouse in conformation of the new findings and which also fulfilled the gaps
• Had to create various objects like views Item classess, joins and Hierarchies using Discoverer Administrator 10g toolset
• Involved in testing CPR and UAT to make sure the reports are running good
• Gathered the user requirement and Analyzed them from a report to report basis
• Upgraded numerous reports in Discoverer from 10g to 11g in which the entire environment was created using the Fusion Middleware Stack of Application

Oracle BI Consultant - OBIEE Admin and Lead Developer

Confidential, Saukville, WI

Environment: Oracle 10g, SQL * Plus, PL/SQL, Oracle BI SE, Discoverer 10g Admin/ Desktop, OBIEE, Noetix Views, Noetix Generator for Discoverer and OBIEE 10G

Responsibilities:

• Designed and developed the OBIEE Metadata Repository (.rpd) using the OBIEE Admin tool by importing the required objects (Dimensions, Facts & Aggregates) with Referential Integrity constraints into Physical Layer using connection pool, developing multiple dimensions (Drill-down Hierarchies) & Logical & Facts Measure objects in Business Model Layer, and creating Presentation Catalog in Presentation Layer.
• Worked very extensively on Noetix out of the box solution for OBIEE to develop various reports in Financials especially the AP/AR reports
• Responsible for customization of the .rpd file using snow flaking techniques and created a Star Schema Bi Mart
• Upgrade the Discoverer Reports from The EUL US End User Layer to the Noetix End User Layer
• Responsible for User requirement gathering, Analysis and writing the specification Docs MD 70’s
• Responsible for 120 Odd reports including 50 in OBIEE and the others in Discoverer 10g in a Noetix Environment
• Lead a team of 5 people and assign them work according to their individual areas of expertise
• Participated in UAT and fixing the findings of report defects and communicating it to the stakeholders
• Responsible for the successful completion of the project specification documentation as the scope of project changes overtime
• Extensively used various soft tools like MS Word, Excel, Projects, Powerpoint,Visio and email application to ensure project delivery apart from technical tools like Discoverer 10g r 2,OBIEE 10.3
• Review and approve designs for best software engineering practices especially huge volumes of data
• Participate in requirement definitions for impact to database design,Discoverer EUL,EFDS business processing,feasibility,performance and security
• Determined and approved modifications to the Discoverer EUL
• Troubleshoot data issues and took part in the mock go-live exercise
• Involved heavily in UAT and lead a big team of testers both IRS and NON IRS Employees
• Assists End Users with runaway queries and recommended correction and provided advise to the management in As Is and To-be processess
• Took Part actively in this Multi Million Dollar project EFDS to ensure smooth implementation and support
• Assist the TCC team with preparation of go live and filing season,(Tax Returns) informing them of any procedural changes to the Database or Discoverer EUL
• Defined various Meta Data Objects both from the Database and derived to fullfill the business requirement to analyse the prior yr v/s current data using the time series functions available in the OBIEE toolset
• Metadata Integration Strategy for the Enterprise Data Standards Initiative including software evaluation and information integration and management method development. Organization all existing data models, data flows and data dictionaries into a MetaData Repository.
• Created physical models of all databases and logical models of strategic customer and product databases. Designed a Corporate Conceptual Model as an architecture migration target and developed procedures to map this model to the database models to facilitate information location.
• Redesigned the key structures of IRS central institutional client database.

Confidential

Oracle BI Consultant/Lead Discoverer Administrator

Environment: Oracle 10g, SQL*Plus, PL/SQL, Oracle BI SE and EE, Discoverer 10g Admin/Plus and Desktop, Oracle EBS 11i(AP, AR, PO, SALES, INV OM,OPM,OTM,PLANNING) Oracle BI Publisher 5.6,Noetix Views and Informatica Power Center v 8x

Responsibilities:

• Involved in the setup and configuration of the Oracle BI environment to enable the reporting infrastructure using Discoverer Admin 10g and PLUS tool
• Interacted heavily with the users and maintained proper documentation to ensure the required reports are properly developed
• Created new folders in the existing OPM and PLANNING Business Area to enable reporting to the requirement
• Imported various folders in the Business Areas to enhance the RICE Components in order to make it worthwhile for the business needs and eliminating a huge effort of sending it back to the offshore team
• Created Custom Folders based on the SQL Statements which interacts with the FND tables and derived fields using the calculations available in Discoverer 10g
• Defined Business rules and supervised the Informatica development effort by a team of 12 developers and making sure the data is mapped as per the business requirement and uploaded correctly into the staging environment
• Interacted and co-ordinated with the offshore team involved in ETL Projects to make sure the data is mapped as per RICE Component Documents and thuis define dvarious transformation formulaes and formulaes in the process
• Involved in meetings with the Business Partners, Business Users and gathered the Business Requirements and documented them in a systematic manner (BRD), also discussed the technical feasibility and the system requirements for the new developments such as the creation of any new database tables or about using the existing tables and Schemas etc
• Developed the new metadata definitions, new Subject areas in the OBIEE Repository which involved working with the Physical, Business Model and Mapping and Presentation Layers of the Repository
• Configured dimensional hierarchy and implemented them in the appropriate reports
• Configured Aggregate tables in order to use them in the applicable reports
• Created reports in the OBIEE Answers and configured the results in different views such as Table view, Pivot table view, Chart view, Funnel view, Narrative view etc based on the requirement
• Created OBIEE Dashboard Prompts, Intelligence Dashboards to accommodate the reports that are built in Answers
• Used Oracle BI Delivers Intelligence Agent iBots to notify the business users.
• Created, published and scheduled reports using Oracle BI Publisher.
• Customized .rpd to extract more business functionality from the existing Out-of-box configurations
• Dealt with the performance issues by Tuning the queries for the reports which are running at significantly higher time periods
• Created new views in the database
• Participated in weekly scheduled support calls with Business Users concerning the Production Tickets
• Tested the reports and worked closely with the UAT testers to figure out the modifications if any are required and worked out on them to get the final sign-off from the Business partners
• Migrated the approved developments (Webcat, .rpd) from the Test environment to the Production environment using the catalog manager
• Involved in this biggest installation of Oracle EBS where the Implementation is going on for the past couple of years, interacted with various functional teams and helped them with their MOCK Production Testing feasibility and the system requirements for the new developments such as the creation of any new database tables or about using the existing tables and Schemas etc