SUMMARY

• Eight years of experience as an Oracle applications (E - Business Suite) consultant, technical developer with expertise in General Ledger, Account Payables, Accounts Receivables, Fixed Assets, Order Management, Inventory, Purchasing, Install Base, Service Contracts, System Administrator, and Cash Management.
• Experience in developing OBIEE (Siebel v.8 Analytics) Repositories, Dashboards, Answers/Reports, iBOTs, Enterprise Data Warehouses (EDW), Data Marts (DM), Operational Data Stores (ODS), and Data Integration, and Client/Server OLAP/OLTP systems, PL/SQL development.
• Expertise in providing end-to-end business intelligence solutions using OBIEE.
• Proficient in building analytical repository, and customizing teh Oracle BI Apps repository business models, generating reports, and creating dynamic Dashboards using Siebel Analytics/OBIEE.
• Strong experience 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.
• Expertise in creating different report views like Table, Pivot, Charts, View/Column selector, Narrative and Union reports.
• Hands on experience in Autantication and Authorization of OBIEE by using LDAP, Database autantication, External Autantication and also implemented Single Sign on (SSO).
• Expertise in implementing Security Models for Dashboards, Row level, object Level, Role Level, Dashboard Level.
• Expertise 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 implementing Oracle BI Apps in all phases like implementing Out of order Box prebuilt mappings, Designing ETL, metadata management using DAC, Creating Oracle provided DataWarehouse, OBIEE RPD development, OBIEE reports and Dashboards
• Expertise in DataWarehouse Administration Console (DAC) to configure, monitor and schedule ETL.
• Good Experience in Performance Tuning of Informatica Mappings.
• Experienced in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, Oracle BI Apps, 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.
• Expertise in Developing Mappings, Maplets, Workflows and Sessions using Informatica Power center.
• Hands on experience working with OBIEE RPD modeling.
• Extensive experience in Metadata Modeling at all three layers (Physical, Business Model and Presentation) using teh OBIEE. Administration Tool.
• Expertise in creating, modifying, using and debugging Stored Procedures, Views, User Defined Functions using SQL Server/PL SQL.
• Worked with different SDLC Environments Agile, Iterative, and Water Fall Methodologies.
• Experienced in interacting with users, gathering requirements, and drawing up Business Case Scenarios.

TECHNICAL SKILLS

Oracle Applications: Oracle Financials E-Business suite R12/11i (Order Management, Inventory, Purchasing, General Ledger, Accounts Receivables, Accounts Payables, Fixed Assets, Cash Management, AOL, System Administrator).

BI Tools: Siebel Analytics 7.8.x,7.7.x,7.5.x,OBIEE 10.1.3.x,OBI Applications 7.9.x

ETL Tools: Informatica Power Center 8.x,7.x,6.x, DAC 10.1.3.4.1

Languages: C, C++, C#, Java, SQL, PL/SQL, HTML, XML

Web Servers: IIS, Web Logic Server, OC4J.

Data Bases & Tools: Oracle 11g,10g,9i,8i, SQLServer2005/2000, TOAD, SQL Navigator.

Operating Systems: Windows 98, 2000, 2003 server, XP, LINUX

PROFESSIONAL EXPERIENCE

Confidential, San Mateo, CA

OBIEE Consultant

Responsibilities:

• Gatheird requirements from teh client for GAP Analysis, translated them into technical design documents and worked with team members in making recommendations to close teh GAP.
• Performed teh setting up, installation and configuration of teh complete Analytics platform environment and teh required connectivity for seamless integration with teh DataWarehouse.
• Installed and configured OBIEE, DAC and Informatica on Unix/Linux Environment.
• Worked on integrating and configuring BI Publisher with OBIEE.
• Used ETL processes to load data from Flat files, Oracle Databases into teh target OLAP databases.
• Designed and developed Custom Mappings and Workflows in Informatica to bring teh data from other data source systems and Integrated using Universal Adapters in DAC.
• Extracted various sources like Oracle tables and imported Flat files using Informatica Power Center.
• Customized Oracle BI metadata in teh analytics repository with Oracle BI Administration Tool.
• Customized teh Repository by creating Facts and Dimensions and adding extra columns to teh Existing Facts and Dimensions.
• Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool.
• Implemented row and data level security on subject areas, dashboards and reports.
• Involved in configuring and customizing sources, targets, tasks and execution plans using DAC.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Migrated Analytics RPD and Webcat from one environment to another.
• Developed Complex Reports by using teh Different Views like Table, Pivot, Chart, Column Selector, View Selector and Combined with Similar Requests.
• Configured IBOT’s for delivering alerts and for Cache Seeding.
• Built teh Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star and snowflake Schemas.
• Implemented dynamic dashboard prompts to zoom into particular segments of teh business in a performance-optimized manner.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Enhanced performance of Reports / Dashboards by implementing teh Materialized Views, Table partitions, re-building of indexes and managing Cache etc.

Environment: Oracle Applications 11i/R12 General Ledger, Accounts Payables, Accounts Receivable, Inventory, Purchasing,Fixed Assets, OBIEE 11.1.1.3/ 10.1.3.4.1 , Oracle BI Apps 7.9.6.1, Informatica Power Center 8.6.1, Oracle 11g, PL/SQL, DAC 10.1.3.4.1 , Toad, Linux, File-Zilla.

Confidential, Memphis, TN

OBIEE Consultant

Responsibilities:

• Involved in installation and configuration of OBIEE with Informatica and Responsible for setting up teh environment including installation of OBIEE, BI Apps and Informatica in all teh environments.
• Analyzed,Designed,and Developed OBIEE/Siebel Analytics Metadata repository (RPD) dat consists of Physical Layer, Business Mapping and Model Layer, and Presentation Layer.
• Migrated Repository and Catalog between environments like Dev, Test, QA, maintenance and Performance.
• Experience working with Metadata architecture and dashboard design.
• Created Views and Aliases in physical layers for performance tuning.
• Worked According to Agile Environment to meet Deadlines on time.
• Developed different kinds of Reports (Pivots, Charts, Tabular) using global and local Filters.
• Configured teh Anlaytics repository(RPD) and implemented teh security to autanticate and authorize Oracle EBS users.
• Configured IBOTS and Delivers and created proactive iBots and interactive Dashboards to alert teh Marketing team about business changes.
• Performed Data Validation on teh reports.
• Executed teh SQL queries using SQL Developer.
• Responsible for configuring teh informatica Source and lookup files.
• Custumized teh existing informatica repository and added new mappings and workflows based on teh requirements.
• Developed custom Reports/Ad-hoc queries using Seibel Answers and assigned them to application specific dashboards.
• Developed different kinds of Reports (Pivots, Charts, Tabular) using global and local Filters.
• Configured Report Navigation (Column and Value) to achieve navigation between teh reports in Answers.
• Designed and Developed Informatica Mappings from Scratch to Load teh Data from Source System to Staging system and Warehouse System.
• Created and ran Sessions & Workflows to load teh data into teh Data warehouse.
• Customized Expected Receipts Reports, Journal Entries Report and Billing History Report in Account Receivables using XML/BI Publisher.
• Used XML/BI Publisher for Multi language reporting purpose.
• Developed and configured various reports in BI Publisher such as vendor listing, AP Invoices and Check Printing
• Developed reports in GL like Bonus Accrual-Units, Bonus Accrual-Area Supervisor, Inter company transaction detail report, Hyperion Trial Balance using BI publisher.
• Performed tuning in Informatica Source and Target and Mapping and Target and Session level and oracle query tuning.
• Involved in Unit Testing, Peer Testing & Regression Testing.
• Conducted training Sessions on Informatica power center and OBIEE.
• Designed, implemented and tested security privileges on subject areas, dashboards and reports.

Environment: Oracle Applications R12, Service Requests,Service Contracts,Install Base,General Ledger, Account Payables, Accounts Receivable,Inventory, Order Management, Oracle Purchasing,Oracle 9i (9.2.0), XML/BI Publisher 5.6.3, OBIEE,Discoverer 10g,Repots10g,SQL*PLUS, SQL*Loader, TOAD, PL/SQL, Unix.

Confidential, Phoenix, AZ

OBIEE Consultant

Responsibilities:

• Installed Siebel Analytics/OBIEE and related components for development, QA and production environments.
• Involved in development and review of System documentation
• Implemented Supply Chain and Procurement and Spend Analytics.
• Created and customized intelligence Dashboards in Oracle Business Intelligence to suit teh client’s requirements.
• Created different types of Customized Reports (Drilldown, Aggregation) to meet client requirements
• Involved in teh installing and configuring of Financial Analytics.
• Setup Multi User Development Environment (MUDE) in OBIEE.
• Designed and developed General Ledger, Payables, Receivables and Profitability Dashboards in OBIEE.
• Developed Dashboard pages like Liquidity,GL Balance,Cash Flow and Balance Sheet in General Ledger Dashboard.
• Developed Dashboard pages like AP Balance,Overview,Payments Due,Supplier Details and Invoice Details in Payables Dashboard.
• Developed Dashboard pages like AR Balance,Payments Due,Invoice Details and All AR Transactions in Receivables Dashboard.
• Developed Dashboard pages like Overview,Margins,Revenue,Products and Customers in Profitability Dashboard.
• Administering teh OBIEE Dashboards and Reports, Data Visibility.
• Installed, Configured Data Warehouse Administration Console (DAC) and Monitored Incremental and Full load of Data through DAC and Informatica WorkFlow Monitor.
• Responsible for extracting data from Oracle Apps Modules and loading into stage system and warehouse system.
• Developed Mappings using corresponding Source,Targets and Transformations like Sequence Generator,Source Qualifier, Router,Filter,, Joiner, Lookup, Expression, Aggregator and Update Strategy.
• Worked extensively in Oracle BI Security, Web Object Security and Data Level Security.
• Created Presentation catalogs and Folders in Presentation Layer and Performed Global Consistency Check in Oracle BI Administration Tool.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Executed teh SQL queries using TOAD.
• Utilized teh BI Publisher tool functionality for creating pixel perfect reports and report templates.

Environment: Oracle Applications 11i/R12 iProcurement, General Ledger, Account Payables, Accounts Receivables,Fixed Assets, BI Apps 7.9.5, Supply Chain(SCM), OBIEE 10.1.3.4.0/10.1..3.3/10.1..3.2 , Oracle 10g, Informatica 8.1.1, DAC 7.9.5, XML/BI Publisher 5.6.3, Discoverer 10g/4i/3i, PL/SQL, SQL*PLUS, SQL*Loader, TOAD,Unix.

Confidential, Sunnyvale, CA

Oracle Applications and OBIEE Consultant

Responsibilities:

• Gatheird and analyzed teh Business Requirements in collaboration with theSales, Marketing andFinanceSMEs, Business Analysts and users.
• Part of teh installation team to install OBIEE BI Apps.
• Designed and Developed Financial Dashboard like General Ledger,Payables,Receivables.
• Created AD hoc reports in Acount Payables.
• Worked extensively on OBIEE Answers to create teh reports as per teh client requirements.
• Created reports in Answers and embedded them in Dashboards according to teh requirements.
• Used Analytics ODBC client to perform query validation.
• Created customized dashboard prompts as per teh business requirement
• Developed calculated measures and assigned aggregation levels based on dimension hierarchies.
• Created Alias and configured repository with logical dimensional modeling using star schema.
• Involved in creating data sources for connecting to teh database utility
• Created Dashboard prompts and advance filter criteria.
• Customized GL Detailed Trial balance report, GL Period to Date Balances reports in General Ledger using FSG’s.
• Designed and developed Customer Interface, Auto Lockbox Interface.
• Designed Customer Products Summary Report in Install base using OBIEE.
• Worked on Service Contract interface program by using teh standard API’s.
• Generated Inter Company Transaction Detail Report, Open-Debit Memo Report in General Ledger using Reports 6i.
• Customized Supplier Payment History Report in Account Payables to meet client requirements.
• Performance Tuning of Dashboards/Reports and made changes to database by implementing teh materialized views, partitions, re-building of indexes, overwriting teh sql execution path by making use of hints etc
• Worked closely with Users, Developers and Administrators to resolve ongoing Production issue

Environment: Oracle Applications 11i (11.5.10) General Ledger, Account Payables, Accounts Receivable,Inventory, Supply Chain(SCM), OBIEE 10.1.3.2, XML/BI Publisher 5.6.3, Discoverer 10g, SQL*PLUS, SQL*Loader, TOAD, Unix.

Confidential

PL/SQL Developer

Responsibilities:

• Interface with Customers Management Team to capture and analyze business requirements.
• Worked with a team of IT developers in teh Initial Database Design/Data Modeling/Data approval.
• Creating database objects including tables, indexes, clusters, sequences, roles, and privileges.
• Loading data from flat files into database tables using SQL* loader.
• Calculating and monitoring size and space for tables, clusters and indexes.
• Creating and maintaining triggers, packages, functions and procedures.
• Created users and established teh application security by creating roles.
• Writing PL/SQL Stored Procedures, Functions, views, & Triggers for teh application.
• Optimized teh embedded SQL queries using statement level optimizer hints when essential, to adhere to teh defined OLTP response time.
• Importing/Exporting data from/to different databases using utilities like SQL*Loader, Import/Export.
• Unit testing and monitoring performance and providing System support.

Environment: Oracle 8i, Flat files, MS Access, SQL Plus, SQL LOADER, and Windows NT.