Summary

• Over 8 years of Complete Life Cycle or End-to-End gathering Business Users Requirements, System Analysis, Design Data Modeling, Development, Testing implementation experience of Business intelligence and Data warehouse applications using OBIEE, Oracle Applications and Informatica.
• Very strong experience in developing OBIEE/Siebel Analytics Repository .rpd at three layers Physical Layer, Business Model Presentation Layer , Time Series Objects, Interactive Dashboards with drill-down capabilities using global local Filters, OBIEE/Siebel Security Setup users/groups, access / query privileges , configured OBIEE/Analytics Metadata objects Subject Area, Table, Column , Presentation Services/Web Catalog Objects Dashboard, Pages, Folders, Reports , scheduling iBots.
• Experience in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, Oracle BI Apps, Informatica Power Center.
• Expertise in creating different report views like Table, Pivot, Charts, View/Column selector, Narrative and Union reports.
• Expertise in implementing Security models for Dashboards, Row level, object Level, Role Level, Dashboard Level.
• Extensively worked on BI Server, BI Answers, BI Dashboards and BI Delivers iBots .
• Experience in Upgrading OBIEE environments.
• Extensively involved in end to end implementations of BI solutions for implementing Financials, Supply Chain Analytics, Procurement and Spend Analytics.
• Experienced in Performance Tuning of Source, Targets, Mappings, Sessions and Transformations.
• Configured DAC Data Warehouse Administration Console for Creating Execution plans, metadata management and monitoring the Informatica ETL Process.
• Created APPS mode EUL and enabled seeded Business Areas and workbooks.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Extensive experience with Fact and dimensional tables, and slowly changing dimensions.
• Sound knowledge of database architecture for OLTP and OLAP applications, Data Analysis, ETL processes in developing data marts and Enterprise Data Warehouse
• Very strong in Extraction, Transformation and Loading ETL of data from Multiple Sources to Data Warehouse and creating Workflows with Worklets and various Tasks.
• Experience in development customization of Oracle BI Publisher XML Publisher , BI Discoverer Reports.
• Experience in writing, testing and implementing SQL/T-SQL/PL/SQL, Stored Procedures, Triggers and Functions.
• Experience in writing, maintaining and executing Test cases, Test plans, and Test scripts and generating software defect reports.
• Expertise in Oracle PL/SQL and database Performance Tuning by implementing Parallel Execution, Table Partition, materialized views with query rewriting, creating appropriate indexes, usage of hints, re-building indexes and also used the Explain Plan and SQL Tracing.
• Project management experience, project proposals, presentation and documentation
• Expertise in business planning, analysis software designing skills with ability to transform business users' input into software requirements and specifications.
• Excellent Written and Verbal Skills Results oriented and Self-Starter looking for challenges Ability to rapidly learn and apply new technologies and improve processes Self-motivated and results-oriented with solid work ethic.

Technical skills:

Professional Experience:

Confidential

Role : OBIEE Consultant

• OBIEE Environment Installation and Configuration in an Enterprise setup.
• Knowledge of OBIEE Scale-out, MUD and cluster configuration setup.
• Apache webserver setup and configuration.
• Working knowledge of Linux OS and Oracle Database.
• Closely worked with the business analysts to gather user requirements and did thorough Data Analysis.
• Installed and configured OBIEE, Informatica and DAC.
• Worked with Oracle BI OBIEE Installation, Oracle BI Server, Presentation Server, Oracle BI Repository RPD , Oracle BI Administration.
• Created OBIEE Repository and implemented the business logic by customization, Dimensional Hierarchies, Aggregate Navigation, level Based Measures, Security Management Data level/Object level security , Variables, Initialization blocks and cache management.
• Performed Consistency check and Global Consistency check of the Business Model before exposing Business Models in the Presentation Layer considering errors, warnings and best practices.
• Worked with OBIEE Answers, Intelligence Dashboards. Demonstrated knowledge in dealing with various functionalities like prompts, views, aggregates, global filters, scheduling, guided navigation, customization, conditional formatting of reports.
• Developed Repository .rpd , configured metadata objects Subject Area, Table, Column and Web Catalog Objects Dashboard, Pages, Folders, Reports .
• Created Security Settings in Oracle Administration Tool to setup Groups and Provide Access Privileges and Query Privileges and also managed security for Groups in BI Answers
• Extensively worked on global filters for use in exercising dashboard wide control over requests that are embedded into a dashboard page.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Successfully implemented OBIEE delivers/Created Proactive agents iBots and configured Interactive dashboards to alert the Business/Field users as per the requirements.
• Developed dimensional hierarchies based on the business requirement of an attribute.
• Worked on upgrading OBIEE 10g to 11g.
• Customized the existing Informatica repository and added new mappings and workflows based on the requirements.
• Developed Informatica Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy and Aggregator.
• Worked on extracting data from Oracle EBS, OLTP flat files and integration and loading data to Data Warehouse OLAP system.
• Registered new tables, indexes, tasks in DAC and created custom ETL execution plan for nightly data warehouse load.
• Build test cases and tested the Reports/Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.

Environment: Oracle Applications 11i/R12 ,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.

Confidential

Role : OBIEE Consultant/OBIEE admin

• Interacted with functional and technical leads, SME's, marketing, finance, and other business groups to identify, analyze, and document business requirements.
• Responsible for setting up the environment including installation of OBIEE, BI Apps and Informatica in all the environments.
• Created and Administered the Physical Layer, Business Model and Mapping Layer and Presentation Layer in Analytics Repository .rpd using Oracle BI Administration Tool.
• Designed and developed many Dashboards/Reports that are Dynamic Interactive with intuitive drilldowns, drill-across flash-based drillable charts bar-charts, pie-charts, radars, and bubble-charts , and local global filters and cache monitor using Siebel Analytical Web.
• Configured IBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Performed the Security management for users, groups and web-groups using the various authentication systems.
• Performed Data Validation on the reports.
• Enhance performance by requesting Aggregate tables, Indexes and managing Cache after Benchmarking performance tuning strategies with business model-level calculations versus database level pre-computations and aggregations.
• Involved in developing the Incremental ETL process Mappings Mapplets using various Transformation and Workflows
• Worked in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Participated in analyzing ETL mappings using Informatica 8.6.1, used Transformations like Aggregator, Update, Filter, Lookup, Sorter.
• Built multiple execution plans in DAC for weekly and daily loads.
• 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.
• Did the logical database design, physical database design, and data modeling with Erwin/Model mart.
• Experience in working with PL/SQL while creating views in physical layer.

Environment: OBIEE 10.1.3x, BI Apps 7.9x, Oracle E-Business Suite 11.5.10, OBIEE 10g, Unix, Oracle BI Publisher Oracle XML Publisher Builder 5.6.3 , Oracle Discoverer 4i/10g, Informatica, DAC, OBAW, RPD,Oracle10g, Erwin, PL/SQL, Toad, Microsoft Excel 2000, MS SQL Server 7.0, Windows NT/2000, UNIX, Oracle 10g, PL/SQL, SQL Loader.

Confidential

Role : Siebel Analytics Developer

• Configured DAC Data warehouse Access control for running of ETL jobs.
• Worked to deploy and optimize performance of BPM applications.
• Extracted data from various ERP systems like SIEBEL CRM, Oracle EBS.
• Involved in Integrating Oracle BI Presentation Services with BI Publisher.
• Configured DAC for Financial Analytics and extracted data through Informatica.
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Implemented HR Analytics Proactive intelligence, Compensation Analytics, Operational Analytics . Integrated data from HR, Finance and other enterprise systems and transformed data using Informatica ETL .
• Developed HR intelligence Dashboards, used KPI's which provides powerful metrics, Alerts and reports to HR professionals and line managers, enabling them to understand how workforce factors are affecting individual departments and take appropriate actions.
• Modified Pre-built OBI Applications dashboards, Answers, Repository for Sales, Finance, Supply Chain and Order Management Analytics.
• Developed many Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local Filters using Oracle BI Presentation Services.
• Developed many Accounting and Collection Time Series objects for comparing the Billings, Collections and Adjustments between the different time frames.
• Implemented comprehensive security functionality by creating users web groups, setting up LDAP ADSI authentication and associating catalog objects and Web modules with the created users and groups.
• Configured IBots to deliver Analytics content based on schedule, automated IBot queries to obtain daily and weekly reports.
• Performed the Performance Tuning of Dashboards/Reports and made required changes to repository and database.
• Developed many incremental ETL using Informatica mappings Oracle PL/SQL procedures for loading into OLAP DB'S from multiple data sources which includes OM, AP, AR.
• Created comprehensive and easy-to-understand Documentation of the complete implementation of Analytics that includes .rpd, Dashboards, Security etc. .

Environment: Informatica Power Center 8.1/ 7.1, DAC 7.8, OBIEE 8.1, Flat files Oracle 9i, MS SQL Server 2003,DB2, Siebel Sales Marketing Analytics 7.8.4 Erwin 4.3, PL/SQL, UNIX Shell Scripting, Toad, LINUX ,Windows NT.

Confidential

Role : Oracle apps Developer

• Deployed Financials, Marketing and Contact Center Oracle Business Intelligence Analytics modules.
• Provided better data analysis and decision making for CCHS.
• Worked on OBIA installation, configuration, extension, and support for EBS R11 and R12
• Upgraded OBIA from R11 to R12
• Performed product gap analysis and specified customization scope to enhance prebuilt module capabilities from data integration to OBI metadata RPD to OBI presentation UI to the user community
• Installed and configured DAC in production environment
• Customized ETL to extend capabilities of OBIA modules.
• Implemented OBIA best practices while having tight delivery deadlines
• Extended OBI metadata to enhance the capabilities of OBIA modules.
• Integrate OBIA modules with existing and future deployments
• Customized and developed RPD Physical, BMM and Presentation layer .
• Created drill down hierarchies and implemented business logic for facts and dimensions
• Customized prebuilt dashboards and reports, Oracle Business Analytics Warehouse metadata objects, and web catalog objects.
• Deployed OBIA Marketing and Contact Center modules.

Environment: Oracle Applications 11i/R12, OBIEE 11.1.1.3/10.1.3.4.1, Informatica 8.6, DAC 10.1.3.4.1, Toad. TIMX, Account Payables AP , Accounts Receivable AR , Inventory INV , Purchase Order PO