SUMMARY:

• Over 8 years of 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.
• Extensive experience as Technical ERP Developer/Consultant in Oracle E-Business Suite Applications with expertise in General ledger, Account Payables, Account Receivables, Fixed Assets, Order Management , Iprocurement and Purchasing, Inventory GL, AP, AR, FA, OM, PO, INV and Payroll, Oracle BI Applications OBIA/BI APPS .
• Expertise in providing end-to-end business intelligence solutions using OBIEE.
• Experience in performance tuning of Informatica mappings and sessions, Siebel Analytics Reports SQL query and using Data Warehouse Administration Console DAC to schedule the Informatica jobs and metadata management.
• Proficient in building analytical repository, and customizing the 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.
• Extensively worked on Installation and configuration and in end to end implementations of BI solutions for implementing Financials, Supply Chain Analytics, Procurement and Spend Analytics.
• 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 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.
• Expertise in Developing Mappings, Maplets, Workflows and Sessions using Informatica Power center.
• 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:

PROFESSIONAL EXPERIENCE:

Confidential

OBIEE CONSULTANT

RESPOSIBILITIES:

• Performed the setting up, installation and configuration of the complete OBIEE 11.1.1.6 client installations and Procurement and Spend Analytics platform environment and the required connectivity for seamless integration with the Informatica9.1 ETL and DataWarehouse Adminnistration Console DAC in all the environments.
• Used OBIEE Administration Tool 11.1.1.6 for customizing and modifying the Physical, Business Model/Mapping and Presentation layers of metadata repository .rpd
• Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements.
• Created Logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data, and Repository Variables.
• Implemented security tasks like creating user groups, users and managing users by setting up their privileges and profiles.
• Worked on Design, Development, Implementation, Testing and Maintenance of Oracle Databases, ETL Processes and Database Deliverables.
• Used Informatica Power Center tools for analysis, design, mapping and workflow.
• Develop mappings in Informatica according to functional/application areas to load the data from source to target tables.
• Develop various transformations like Source Qualifier, Update Strategy, Lookup transformation,
• Expressions and Sequence Generator for loading the data into target table.
• Created Workflows, Tasks, and database connections using Workflow Manager.
• Develop Mappings and Workflows to generate staging files.
• Configured DAC for Procurement Spend Analytics and extracted data through Informatica.
• Developed Mappings and Workflows to load the data into Oracle tables.
• Developed complex Informatica mappings and tuned them for better performance.
• Created shell scripts to run the daily ETL loads on AutoSys tool instead of using DAC. Maintained and supported the AutoSys tool whenever ETL load run shows failed status.
• Created and tested Contingency plan if any fail-over ETL load exists on Active servers.
• Tested data in all environments such as DEV, UNIT, QA, PROD and worked closely with production support team to resolve any issues.

ENVIRONMENT: OBIEE 11.1.1.6.1, Oracle BI Apps 7.9.6.3 Procurement Spend Analytics , Informatica Power Center 9.1, Oracle 11g/10g, DAC 10.1.3.4.1, DB Artisan, SQL Developer, Windows XP

Confidential

OBIEE CONSULTANT

RESPOSIBILITIES:

• Gathered requirements from the client for GAP Analysis, translated them into technical design documents and worked with team members in making recommendations to close the GAP.
• Performed the setting up, installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration with the DataWarehouse.
• Installed and configured OBIEE, DAC and Informatica on Unix/Linux Environment.
• Worked on integrating and configuring BI Publisher with OBIEE.
• Experience of installation of OBIEE 11G on Windows Single Server and Clustered.
• Used ETL processes to load data from Flat files, Oracle Databases into the target OLAP databases.
• Designed and developed Custom Mappings and Workflows in Informatica to bring the 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 the analytics repository with Oracle BI Administration Tool.
• Modified Pre-built OBI Applications dashboards, Answers, Repository for Financial Analytics GL, AP, AR, FA .
• Customized the Repository by creating Facts and Dimensions and adding extra columns to the 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 the Different Views like Table, Pivot, Chart, Column Selector, View Selector and Combined with Similar Requests.
• Experience managing and coordinating onsite/offshore Model.
• Configured IBOT's for delivering alerts and for Cache Seeding.
• Built the 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 the 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 the 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

OBIEE CONSULTANT

RESPOSIBILITIES:

• Involved in installation and configuration of OBIEE with Informatica and Responsible for setting up the environment including installation of OBIEE, BI Apps and Informatica in all the environments.
• Analyzed,Designed,and Developed OBIEE/Siebel Analytics Metadata repository RPD that consists of Physical Layer, Business Mapping and Model Layer, and Presentation Layer.
• Developed different kinds of Reports Pivots, Charts, Tabular using global and local Filters.
• Worked According to Agile Environment to meet Deadlines on time.
• Created Views and Aliases in physical layers for performance tuning.
• Experience working with Metadata architecture and dashboard design.
• Migrated Repository and Catalog between environments like Dev, Test, QA, maintenance and Performance.
• Configured the Anlaytics repository RPD and implemented the security to authenticate and authorize Oracle EBS users.
• Executed the SQL queries using SQL Developer.
• Performed Data Validation on the reports.
• Configured IBOTS and Delivers and created proactive iBots and interactive Dashboards to alert the Marketing team about business changes.
• Responsible for configuring the informatica Source and lookup files.
• Custumized the existing informatica repository and added new mappings and workflows based on the requirements.
• Configured Report Navigation Column and Value to achieve navigation between the reports in Answers.
• Developed different kinds of Reports Pivots, Charts, Tabular using global and local Filters.
• Developed custom Reports/Ad-hoc queries using Seibel Answers and assigned them to application specific dashboards.
• Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.
• Created and ran Sessions Workflows to load the data into the 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

OBIEE CONSULTANT

RESPOSIBILITIES:

• Installed Siebel Analytics/OBIEE and related components for development, QA and production environments.
• Involved in development and review of System documentation
• Created different types of Customized Reports Drilldown, Aggregation to meet client requirements
• Created and customized intelligence Dashboards in Oracle Business Intelligence to suit the client's requirements.
• Involved in the 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 the 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 the SQL queries using TOAD.
• Utilized the 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, 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.

RESPOSIBILITIES:

• Gathered and analyzed the Business Requirements in collaboration with the Sales, Marketing and Finance SMEs, Business Analysts and users.
• Part of the 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 the reports as per the client requirements.
• Created reports in Answers and embedded them in Dashboards according to the requirements.
• Used Analytics ODBC client to perform query validation.
• Created customized dashboard prompts as per the 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 the 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 the 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 the materialized views, partitions, re-building of indexes, overwriting the 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, OBIEE 10.1.3.2, XML/BI Publisher 5.6.3, Discoverer 10g, SQL PLUS, SQL Loader, TOAD, Unix.

Confidential

PL/SQL DEVELOPER

RESPOSIBILITIES:

• Interface with Customers Management Team to capture and analyze business requirements.
• Worked with a team of IT developers in the 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 the application security by creating roles.
• Writing PL/SQL Stored Procedures, Functions, views, Triggers for the application.
• Optimized the embedded SQL queries using statement level optimizer hints when essential, to adhere to the 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.