We provide IT Staff Augmentation Services!

Senior Oracle Bi Consultant Resume

Iowa City, IA

SUMMARY:

  • Around ten years of experience in the IT industry with emphasis on database, data warehouse development and reporting using Siebel Analytics/Oracle BI (OBIEE).
  • Worked extensively in analysis and development of data warehouse applications using Siebel Analytics 7.7/7.8.2/OBIEE 10.1.3.2/OBIEE 11G/IBOTS
  • Experience in BIApps(OBIA) with Sales Analytics, Financial Analytics, Supply Chain Analytics, Procure and Spend Analytics and HR Analytics.
  • Hand - on experience with Oracle Data Integrator(ODI)
  • Experience in writing, testing and implementing SQL/T-SQL/PL/SQL, Stored Procedures, Triggers and Functions.
  • Experience designing, configuring, and delivering Oracle BI Publisher solutions to solve business problems using Oracle BI Publisher (10g/11g)
  • Hands-on experience in extending/customizing Oracle Business Analytics Warehouse (OBAW)
  • Experience in installing and configuring Active Directory with BI Publisher.
  • Experience with OBIEE/Siebel Analytics in both front and back-end development.
  • Exclusively worked on OBIEE Administration (Physical, Business Model & Mapping, and Presentation Layers), Answers, Dashboards, Job Manager, Catalog Manager, BI Publisher, Marketing and Disconnected Analytics.
  • Sound knowledge of database architecture for OLTP and OLAP applications, Data Analysis, ETL processes in developing data marts and Enterprise Data Warehouse.
  • Working Knowledge of tables, processes and configurations.
  • Expertise in converting and using Oracle pre-build rpd’s (Finance Analytics, Project Analytics, Procurement) according to business requirements.
  • Experience in Installation, configuration, and operational design of BI software solutions.
  • Experience in writing JAVA scripts as required while building reports and Dashboards.
  • Capability to adapt to any industry and learn any new technology/trends.
  • Good understanding of full life cycle methodologies, from conceptualization to implementation and maintenance.
  • A quick learner with an eye for detail and excellent analytical and quantitative skills.

TECHNICAL SKILLS:

Databases: MS SQL Server 2008/2005/2000, Oracle 11g/10g/9i/8i, DB2, Oracle EBS R12,Sybase, MS- Access, Essbase, Tera Data.

Operating Systems: UNIX (AIX 5.1), Windows NT, Windows 95/98/00/xp, Linux, Solaris.

Languages: SQL, PL/SQL, HTML, UML, UNIX Shell Scripting, C, C++, JAVA, .Net.

Reporting Tools: OBIEE 11g/10g, Siebel Analytics 7.8.x/7.7.x/7.5.x, BI Publisher 10.1.3.4/11.1.1.5.

Business Intelligence: Siebel 8.1,OBIEE (Oracle Business intelligence Enterprise Edition), Administration, Answers, Interactive Dashboards, Oracle BI Publisher, Briefing Books, BI Delivers, Web Catalog Administration, Analytics Server Administration

Middleware Tools: Informatica, Oracle Data Integrator(ODI)

Data Modeling: Dimensional Data, Erwin, ER/Studio, Visio, Star Schema, Snowflake, TablesPhysical and LogicalEducation Bachelor of Technology, ANU, India.

PROFESSIONAL EXPERIENCE:

Confidential, Iowa City, IA

Senior Oracle BI Consultant

Responsibilities:

  • Interacted with business Management representatives for gathering the Reports/ Dashboards requirements and to define business and functional specifications.
  • Created new repository, customized existing metadata Repository (rpd).
  • Designed and developed Physical Data Layer, Business Model & Mapping and Presentation Layer using BI Administration Tool.
  • Designed Physical relationship diagrams using Fact and Dimensional tables.
  • Developed Dimensions and Time Series objects in the Business Model and Mapping Layer.
  • Configured measures in the Logical Layer and mapped to multiple Physical source tables.
  • Developed reports using BI Dashboard and Answers, views & charts, created filters to obtain weekly sales for each region & send alerts to upper management.
  • Configured metadata objects (Subject Area, Table, and Column) and Web Catalog Objects (Dashboard, Pages, Folders, and Reports).
  • Involved in customizing the ODI Mappings/Interfaces in OBIEE 11G
  • Experience in setting up ELT loads in BIACM by defining source Instance and configure offerings and creating load plans
  • Mapped the configurations of BMM Layer to accommodate for the territorial hierarchy that were accommodated via chart drilldowns.
  • Assisted in creation of pivot table request allowing manager to analyze the business from different perspectives using column selector.
  • Experience in creating and customizing existing out of the box ODI interfaces, packages and monitoring ELT loads
  • Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain weekly reports, delivery of reports through email, hand-held devices and mobile phones.
  • Extensive Performance tuning in BI by implementing Aggregate navigation and cache management.
  • Created adhoc reports, reports with parameter fields, complex reports running from stored procedure, sub reports on request from main report, reports from different databases and reports with complex calculations and Running totals report.

ENVIRONMENT: Oracle EBS R12, OBIEE 11.1.1.9, TOAD, OBIA 11.1.1.9, ODI 11G,Oracle Discoverer, BI PublisherOracle PL/SQL, LINUX, HTML

Confidential, Waynesboro, VA

Senior Oracle BI Consultant

Responsibilities:

  • Business requirement gathering, understanding business objectives and analysis. One on One meeting with SME to understand the business scenario and process in Capturing User Requirement using technical specs.
  • Get the database connectivity and design the Physical Layer, Business model and Mapping layer and the presentation layer in the repository.
  • Creating reports and publishing them in the dashboards using answers.
  • Customized and developed repository, configured metadata objects (Subject area table column) and web catalog Objects (Dashboards, Pages, Folders, and Reports.).
  • Customized Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee expenses OOB dashboard pages in Procurement and Spend Analytics, Financial Analytics, Project Analytics using OBIEE.
  • Customized out of the mappings in Oracle Data Integrator according to the user requirements.
  • Configured BIACM and FSCM in BIAPPS 11.1.1.7
  • Add users to the new group and apply the data level security and object level security at the rpd and Web catalog.
  • Worked on trouble shooting the incremental and full loads through ODI Studio, added newly created mappings to existing load plans.
  • Configured Row Level Security to allow users to view data only according to the requirement.
  • Involved in the analysis of the existing system reports and modification of the reports, created new reports based on the user requirements.
  • Performance Tuning of Dashboards/Reports and made recommendations for changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the SQL execution path by making use of hints etc.
  • Life-cycle support for migration efforts from Development to Integration Test to Production Analytics.
  • Involved in developing the Incremental ETL process i.e., Mappings & Interfaces using various knowledge modules, various transformations
  • Modified Pre-built OBI Applications dashboards, Answers, Repository for Sales, Finance, procurement, project&Grants and Order Management Analytics.
  • Involved in training to users of departments like Finance, Budget and procurement & spend analytics on using OBIEE reports and Dashboards.
  • 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 EBS R12, OBIEE 11.1.1.7, OBIA 11.1.1.7, Oracle Data Integrator 11.1.1.7, TOAD.

Confidential, Bocaraton, FL

Oracle BI Consultant

Responsibilities:

  • Interacted with business Management representatives for gathering the Reports/ Dashboards requirements and to define business and functional specifications.
  • Created new repository, customized existing metadata Repository (rpd).
  • Designed and developed Physical Data Layer, Business Model & Mapping and Presentation Layer using BI Administration Tool.
  • Designed Physical relationship diagrams using Fact and Dimensional tables.
  • Developed Dimensions and Time Series objects in the Business Model and Mapping Layer.
  • Configured measures in the Logical Layer and mapped to multiple Physical source tables.
  • Developed reports using BI Dashboard and Answers, views & charts, created filters to obtain weekly sales for each region & send alerts to upper management.
  • Configured metadata objects (Subject Area, Table, and Column) and Web Catalog Objects (Dashboard, Pages, Folders, and Reports).
  • Worked on Answers to build Interactive Dashboards with drill-down capabilities.
  • Created reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics.
  • Mapped the configurations of BMM Layer to accommodate for the territorial hierarchy that were accommodated via chart drilldowns.
  • Assisted in creation of pivot table request allowing manager to analyze the business from different perspectives using column selector.
  • Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
  • Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain weekly reports, delivery of reports through email, hand-held devices and mobile phones.
  • Extensive Performance tuning in BI by implementing Aggregate navigation and cache management.
  • Created adhoc reports, reports with parameter fields, complex reports running from stored procedure, sub reports on request from main report, reports from different databases and reports with complex calculations and Running totals report.

ENVIRONMENT: Oracle EBS R12, OBIEE 11.1.1.6, OBIA 7.9.6.3, Informatica Power centre 9.6, DAC, TOAD.

Confidential, Leesburg, VA

OBIEE Consultant

Responsibilities:

  • I was involved in translating functional requirements into technical requirements assisted in building detailed project schedule, gathering the requirement, completed the proof of concept, Designed, Developed and Making Technical designs and Unit test scripts.
  • Worked with Oracle Procurement and Spend Analytics and Oracle Financial Analytics.
  • Daily status meetings and preparation of operational plan and Involved in technical Conference Room Pilot sessions.
  • Creating Interactive Dashboards, Answers and Administering Oracle BI Apps Applications.
  • Worked with Oracle BI Apps (OBIEE) Installation, Oracle BI Server, Presentation Server, Repository, Oracle BI Administration.
  • Creating KPI’s (Key Performance Indicators), Interactive Dashboards, Administering Oracle OBIEE
  • Applications.
  • Developed User Interface (UI) components Folders, Dashboards, Pages Columns, Sections,
  • Requests / Answers, Filters, Global Filters, Navigation Links, Views / Charts using Oracle BI Presentation Services.
  • Monitored performance by creating OBIEE’s Usage data model/subject area. Improved performance by using aggregate navigation, indexes and materialized views.
  • Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and make corresponding changes to Repository. Responsible for offshore / onsite coordination.
  • 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.
  • 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.
  • Maintained repository backups up to date for test environments and other related DB sources.
  • Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.
  • Expertise in Business Model development with Dimensions, Hierarchies, Measures,
  • Aggregation Rules, Time Series, Caching & Mapping.

ENVIRONMENT: SQL DEV, Informatica Power Center,DAC, OBIEE 11.1.1.6

Confidential - MART, Bentonville, AR

Oracle BI Consultant.

Responsibilities:

  • Understanding the Client requirements, source data, business objectives and key performance indicators.
  • Worked with Retail and sales analytics to make sense of business performance by adding context to real-time business measure.
  • Experience in Dimensional Data Modeling and Technical documentation and presentations.
  • Identified the Gaps by analyzing the Data mart Instance and provided alternative solutions as well recommended changes to Database.
  • Responsible for setting up the environment including installation of OBIEE and Informatica in all the environments.
  • Configuring the Analytics repository (RPD) and implementing the security to authenticate and authorize Oracle users.
  • Built the Physical Layer /Logical Layer/Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas.
  • Identified the Facts, Dimensions, and grain of the Dimensional mode, and referential joins.
  • Used SQL loader to import data from large flat files and Excel sheets to Oracle tables.
  • Built Repository at 3 layers i.e., Physical Layer (connecting to Data sources and import schema), Business Model / data mapping (create Logical tables and data source mapping) and Presentation Layer level (create presentation catalogs).
  • Created Business Facts & Dimensions and defined Logical relation between them in BMM layer.
  • Created Dimensional Hierarchies for the Drill Down functionality and implemented Business Logics for Facts.
  • Worked with Security of the application/solution to define users and groups, set permissions, Group Inheritance, Authentication Methods, Query Limits, Timing Restrictions, and Filters.
  • Extensively worked on Answers, Created Reports using different Analytics Views (Pivot Table, Chart, Column Selector and Table).
  • Implemented Security by creating roles & web groups, checks with External tables and LDAP.
  • Configured and Scheduled BI Publisher scheduler for report bursting to File and email locations and used advanced reporting features such as Online Analyzer, Excel Analyzer and report security options.
  • Designed Executive Dashboards to provide Business Critical Analytical view of the Written Sales for a set of Power Users.
  • Create/Manage Repository/Web Users and Groups and assigning permissions using OBIEE Administration Tool.
  • Extensively used Transformations like Lookup, Router, Normalize, Aggregator, Source Qualifier, Joiner, Expression and Update Strategy.
  • Performed Unit, Integration and Regression testing to validate reports and mappings.
  • Up graded OBIEE from 10G to 11G environment.

Environment: Oracle 11G, OBIEE 11.1.1.3/10.1.3.4, Tera Data, Tera Data SQL Assistant 14.1, Data Stage

Confidential, Charlotte, NC

OBIEE Developer.

Responsibilities:

  • Installed and configured OBIEE on Linux and Windows.
  • Experience in gathering and analyzing business requirements from various sources, ensuring the needs and delivery feasibility.
  • Involved in Integrating Oracle BI Presentation Services .
  • Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
  • Installed and configured OBIEE. Admin tool and Siebel web components including Intelligence Dashboards, answers, delivers and Analytics web.
  • Added Aggregate measures using Aggregate Persistence Wizard.
  • Enabled Usage Tracking Table and Dashboards.
  • Designed and developed Detailed Credit Analysis Report using BI Publisher which extracts the Markdown reasons and multiple credit requests.
  • Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.
  • Expertise in RPD Development, Oracle Answers, Oracle Delivers, DAC Configuration, ETL Configuration, and BI Publisher.
  • Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.
  • Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Siebel Application level.
  • Involved in setting up IBots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.
  • Designed Interactive Dashboards and created dashboard prompts with multiple selections.
  • Involved in Repository Configuration, Troubleshooting, Migration and Server Administration of DEV, QA and PROD environment.
  • Creating new measures as well as modifying the existing measures at RPD levels.
  • Involved in creating dimensional hierarchies to support drill downs.

Environment:, MS SQL Server 2003, DB2, OBIEE

Confidential

Siebel Analytics Developer

Responsibilities:

  • Working closely with the users in understanding the requirements.
  • Working closely with the data modeler in creating logical data model (Star Schema).
  • Designed and Customized data models for Data Mart supporting data from multiple sources on real time.
  • Built the Siebel Analytics repository (Physical Layer, Business Model and Mapping Layer and Presentation Layer).
  • Developing Calculated Measures, level based measures and dimension hierarchies in the Business Model and Mapping Layer.
  • Configuring Web Catalog Objects (Dashboards, Pages, Filters, Reports).
  • Generating different kinds of reports using Siebel Answers and assigning them to application specific dashboards.
  • Working on Siebel Answers to build Interactive Dashboards with drill-down capabilities based on period and class hierarchies.
  • Implementation of different views of report i.e. Pivot table, Titles, Graph, Filters etc.
  • For limiting the number of records I implemented Dashboard prompts and Filters.
  • Performed Pre and post implementation testing of Dashboard, Answers and validating Repository.
  • Creating Users, Groups and giving the permissions in Siebel Analytics Administration Tool and verifying the Permissions of the users in Siebel Analytics web.
  • Assisting in creation of pivot table requests allowing manager’s to analyze the business/data from different perspectives. configured a user guide with an access link, in that I explained how to access the reports and all.

Environment: Siebel Analytics 7.4, SQL Server 2000/2005, SQL Query Analyzer, oracle 8.0 Windows 2000/2003.

Hire Now