SUMMARY

• Over 7 years of IT experience in delivering Business Intelligence solutions with expertise in gathering requirements, analyzing, developing, testing, deploying Business Intelligence BI applications using OBIEE/Siebel Analytics, Oracle Business Intelligence Publisher BI Publisher , Informatica ,BI System Administrator.
• Experience in providing end-to-end Business Intelligence solution by dimensional modeling design, developing and configuring OBIEE Repository RPD , Interactive Dashboards, OBIEE Answers, security implementation, Analytics Metadata objects, Web Catalog Objects Dashboard, Pages, Folders, Reports and scheduling Agents/iBots.
• Hands on experience in Installation, Configuration, Up-Gradation, Customization, Migration and Administration of OBIEE BI Publisher.
• Worked on Multiple source systems like Siebel , Oracle Apps on various versions.
• Extensive experience in implementing BI Publisher Pixel reports using Multiple Templates like RTF, XSLT, EXCEL.
• Hands on Configuring Usage Tracking, Configuring LDAP like OIM, AIM weblogic LDAP .
• Knowledge on Exa analytics Machine and installation experience with latest OBIEE version with OEL 5.9.
• Installation and Configuration of Oracle Business Intelligence 11.1.1.7.0, Informatica 9.0.1, Oracle DB 11.0.2.3 Software's in windows server 2008/Linux 5.9/ Oracle Enterprise Linux 5.9.
• Expertise in Handling Linux environments for Deploying OBIEE RPD Catalog and handling weblogic components.
• Expertise in Bursting the Reports with Different Output Format like PDF, Excel and RTF in BI Publisher and Different Delivery Channels like E-Mail, FTP and File.
• Expertise in converting Functional Design Documents to Technical Design Documents
• 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.
• Expert in implementing and handling the complex environments which include clustering of servers, Back up and Failover Strategies with connected and disconnected analytics
• Experience in developing Informatica Mappings/Mapplets for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and creating Workflows with Worklets Tasks and scheduling using both Workflow Manager and Unix Shell scripts.
• Experience in performance tuning at the Database level by creating Aggregate tables, Bitmap, B-Tree Indexes, RPD level by creating Database hints in Physical Layer, Tuning Reports.
• Expertise in developing new reports, testing and customizing existing reports using SQL procedures, Reports in XML/BI Publisher and OBIEE by interacting with the business analysts and end users.
• Expertise in Design and Development of interfaces and conversion programs to integrate Oracle Applications modules and to import data from various sources into Oracle Applications.
• Strong experience in hierarchies, complex and foreign joins, initialization block, presentation/repository/session variables, calculations, aggregates, partitions, fragmentations and slowly changing dimensions.
• Expertise in gathering business requirements from end users and develop technical solutions.
• Proven ability to quickly learn and apply new technologies. Excellent analytical, problem solving skills and ability to follow through with projects from inception to completion.

TECHNICAL SKILLSET

PROFESSIONAL EXPERIENCE:

Confidential

BI Technical Consultant

Responsibilities:

• Design, development and deployment of new OBI Reports
• Redesigning the new changes in Business with the existing warehouse system and modifying repository Answers.
• Involved in Detailed Impact analysis on the existing reports new changes into the reports and Repository.
• Experience in Offshore Onsite model coordinating with the end client with daily calls over the EOB.
• Involved in providing technical solutions to the scenarios as part of the support enhancement and redeveloped the reports as per new requirement.
• Deployed OBIEE 11g RPD and Web Catalog using Enterprise Manager.
• Extensive Development of the repository according to the BRD Business Requirements Document and building the metrics in accordance with the FSD Functional Specification Document .
• Hands on experience in data warehousing technologies including ETL, Oracle BI Server architecture, and metadata management
• Mapped different data sources to the Physical Layer and created the Business Model and Mapping Layer design of hierarchies, dimensions, and aggregates
• Define appropriate joins, calculations, dimensions and measures in the repository
• Created and customized various Reports and Dashboards for various user groups
• Designed various reports as per the requirements for user interface design like Drill Down, Pivot, Break down Reports, Narrative and Nested reports in Answers
• Created reports with different views Compound, Chart, Table, Pivot, Ticker and Narrative
• Developed and scheduled agents for delivering personalized reports to users on time
• Secured Dashboards and Reports by defining user roles
• Implemented OBIEE security at the data and object levels.
• Worked on Creating Level based hierarchies to support drill down.
• Created report templates using BI Publisher.
• Created new reports in Usage tracking to monitor the usage of different reports and dashboards.
• Developed templates and reports in Oracle BI Publisher in rtf format.
• Applied Optimization techniques and tuned performance of the reports such as caching and building summary tables.
• Created saved filters using dynamic repository variables so business users can use these filters for ad-hoc reporting.
• Extensive usage of Presentation Variables as part of Dashboard Prompts and filter the reports accordingly.
• Created agents to seed and purge cache for cache management.
• Extensive Use of Catalog Manager to migrate the reports/prompts/dashboards from one environment to another environment.
• Conducted Training and workshops sessions for Business users from different groups and departments for smooth transition into OBIEE as BI Consumers.
• Configured Bi publisher agents to alert the users based on the requirements and scheduled BI Publisher reports in PDF/Excel/CVS formats.

Confidential

OBIEE Technical Consultant

Responsibilities:

• Design, development and deployment of new OBI Reports
• Designed the Global Analytics Reports.
• Implementation of Custom Dashboards with Budget, Forecast Accuracy, F B reports.
• Processed Reconciliation of Seeded OBIA Analytical Reports.
• Performance Tuning of the OOTB OBIA ETL process and Dashboards/Reports. This including OBIA data warehouse tuning, and caching improvements in OBI Services
• Deployed OBIEE 11g RPD and Web Catalog using Enterprise Manager.
• Extensive Development of the repository according to the BRD Business Requirements Document and building the metrics in accordance with the FSD Functional Specification Document .
• Hands on experience in data warehousing technologies including ETL, Oracle BI Server architecture, and metadata management
• Mapped different data sources to the Physical Layer and created the Business Model and Mapping Layer design of hierarchies, dimensions, and aggregates
• Define appropriate joins, calculations, dimensions and measures in the repository
• Created Repository Users/ Groups and Web Groups and assigned permissions to the user groups to define security in the repository.
• Created and customized various Reports and Dashboards for various user groups
• Designed various reports as per the requirements for user interface design like Drill Down, Pivot, Break down Reports, Narrative and Nested reports in Answers
• Created reports with different views Compound, Chart, Table, Pivot, Ticker and Narrative
• Developed and scheduled agents for delivering personalized reports to users on time
• Secured Dashboards and Reports by defining user roles
• Implemented OBIEE security at the data and object levels.
• Worked on Creating Level based hierarchies to support drill down.
• Created report templates using BI Publisher.
• Set up Usage tracking to monitor the usage of different reports and dashboards.
• Developed templates and reports in Oracle BI Publisher in rtf format.
• Extensively worked with DBAs and BAs towards performance tuning in OBIEE and Data Warehouse environment using cache management, aggregate tables, and indexes.
• Applied Optimization techniques and tuned performance of the reports such as caching and building summary tables.
• Created saved filters using dynamic repository variables so business users can use these filters for ad-hoc reporting.
• Extensive usage of Presentation Variables as part of Dashboard Prompts and filter the reports accordingly.
• Created agents to seed and purge cache for cache management.
• Conducted Training and workshops sessions for Business users from different groups and departments for smooth transition into OBIEE as BI Consumer's.
• Extensive Use of Catalog Manager to migrate the reports/prompts/dashboards from one environment to another environment.
• Conducted Training and workshops sessions for Business users from different groups and departments for smooth transition into OBIEE as BI Consumers.
• Configured Bi publisher agents to alert the users based on the requirements and scheduled BI Publisher reports in PDF/Excel/CVS formats.

Environment: Oracle Business Intelligence Enterprise Edition OBIEE 11.1.1.6.6, BI/XML Publisher, Oracle DB 11.2.0.3, Toad, PL/SQL, Oracle Enterprise Linux, OBIA/BI APPS 7.9.6.3 Accounts payable, Accounts Receivable, General Ledger, Human Resource INFORMATICA 9.0.1, PEOPLESOFT 8.9/9.1, Oracle Applications R12.

Confidential

Role: Sr OBIEE Consultant

Responsibilities:

• Created and developed repository in various stages like importing data into the physical layer, building hierarchies in the BMM layer and finally grouping the logical tables into subject areas in the presentation layer.
• Coordinating with the ETL developers as the warehouse is updated on a weekly basis in the initial stages.
• Reports developed typically are like consolidated summary, Market summary, Corporate marketing and Distributor compensation and sales.
• Participated in the installation and upgradation of OBIEE components and contributed in documentation process.
• The reports developed are to give detail insight to the Company's executive branch in various sectors of organization performance like Key business indicators, Business Excellence, Distributor Experience, Consumer experience, Product and Brand Management on both calendar year and performance year basis.
• The above mentioned segments give in detail focus on sales of various products, changes in customer renewal counts, Distributor counts, share of a particular product in market of the related products etc,.
• Reports developed will be based on various parameters like region level, sub region level, affiliate level, market cluster level and country level.
• Developed Ibots to send reports to the customer team on a weekly basis.
• Once the development is complete, testing and validating of data across reports, migration of catalogs across DEV, QA environments.
• Created agents to seed and purge cache for cache management.
• Migration of RPD files and Web catalogs across environments as well as version controlling.
• Participating in regular meeting session to convey them of the status of development.

Environment: OBIEE 10.1.3.4,OBIEE 11.1.1.3,ODI, Oracle 11g, Oracle Data warehouse, Unix.

Confidential

Role: OBIEE Technical Consultant

Responsibilities:

• Involved in full life cycle implementation of Inventory and SBR Modules including installation, configuration, extension and customization
• Worked with Yield Management, Pricing Management, Revenue Optimization, and other business groups to identify, analyze, document business requirements and prepare technical specifications
• Configured Integration of OBIEE with BI Publisher environment using SSO
• Configured Bi Scheduler and created iBots/Agents to schedule and deliver Analytics content to multiple delivery destinations and also as Cache Seeding mechanism.
• Implemented the Caching Strategy according to the client's data load frequency
• Enabled Usage Tracking to monitor the usage and performance of reports
• Managed/Administered OBIEE web catalog using Catalog Manager
• Implemented MUDE Multi User Development Environment in OBIEE
• Created complex measures in BMM Business Model and Mapping Layer using Level based Measures, Time Series calculations and different Aggregation Strategies
• Configured drill downs for various types of Hierarchies using Dimensional Hierarchies in BMM layer
• Created new Repository Variables, Session variables and Initialization blocks to configure security, data access and authorization on Repository and Catalog objects
• Implemented aggregate navigation by creating multiple logical table sources for the same logical table
• Configured the connection pool settings according to the requirements
• Expertise in merging repositories using UDML Universal Database Markup Language
• Experience in modifying the Request XML for Answers reports
• Created Answers reports using various analytics views like Table, Pivot tables, Charts, Column Selectors, View Selectors, Narrative, Static text etc.,
• Created common header and footer templates for all the reports in Answers
• Created new Dashboards according to best practices by using Columns, Sections and Guided Navigation
• Created Custom Styles s custom folders according to the look and feel requirements to include the client's banners, images and fonts
• Customized the OBIEE messages by creating Custom Message XML files
• Created Dashboard Prompts for Selective viewing and User Interactivity. Implemented column selector functionality using Dashboard Prompts and Presentation variables
• Was involved in Unit, Integration and System testing and performed data validation for the reports generated using Informatica and OBIEE
• Was responsible for performance improvement of the reports by using various strategies in both the database and OBIEE like Indexes, Hints in Physical Layer, Materialized views and Caching
• Integrated OBIEE with BI Publisher and created Bi Publisher reports using OBIEE metadata Requests and Subject Areas

Environment: Oracle Business Intelligence Enterprise Edition OBIEE 11.1.1.7.0,Oracle Data Integrator 11.1.1.7.0,BI/XML Publisher, Oracle Airline data Model OADM 11.2.0.1A, Oracle DB 11.2.0.3, Toad.

Confidential

Role: Oracle BI Apps Technical Consultant

Responsibilities:

• Participated in Installation and configuration of OBIEE and BI Apps components like DAC, Informatica Power Center and Analytics Server.
• Loaded incremental and full load data into Data Warehouse tables using Informatica and Data Warehouse Administration Console DAC .
• Involved in developing the Incremental ETL processes i.e., Mappings Map-lets using various Transformations and Workflows with Sessions/Tasks. Executed the workflows through shell scripts using pmcmd. Registered the new tasks in DAC.
• Responsible for Implementing DAC Process Life Cycle i.e. Setup, Designing, Execute, Monitor.
• Performed migration and merging of RPD's using Administration tool
• Designed and developed custom reports for Service Contracts Analytics using Answers.
• Developed Reports/Dashboards with different Analytics Views Drill-Down/ Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with Global and local Filters using Answers.
• Designed and Configured Interactive Dashboards in Analytics for different groups of users which include Managers, Functional and Department Heads.
• Implemented security by creating roles web groups, external table security using session variables, LDAP, and Object Level Security.
• Modified and created new requests in Answers using global and local filters, prompts, calculations, conditional formatting in various analytical views.
• Setup usage tracking and developed usage tracking reports.
• Created iBots and delivers to send alert messages to subscribed user groups.
• Scheduled iBots and seeded server cache using Delivers to improve system performance. Also used iBots to clear server cache using NQCmd utility. Scheduled reports to be e-mailed using iBots.
• Created Dimension hierarchies to achieve the drill down functionality.
• Developed Mappings using Transformations like Source Qualifier, Sequence Generator,Filter,Router,Joiner, Lookup, Expression, Update Strategy and Aggregator.
• Designed and Developed Informatica Sessions and Workflows.
• Designed, implemented and tested security privileges on subject areas, dashboards and reports.
• Customized standard reports like Aging and Invoice reports in Receivables using XML/BI Publisher.
• Developed Inventory BI Publisher reports like Inventory details, Price evaluation.
• Customized the existing XML/BI Publisher reports as per client requirements.

Environment: Oracle Business Applications Loyalty, Finance, Customer care support , Oracle 10G,OBIEE 10.13.4.1,BI Applications 7.9.6.2, Informatica PowerCenter 8.6,Siebel CRM 8.1.1.5, Toad, SQL Developer, XML/BI Publisher 10.1.3.4.1, UNIX, Filezilla, Winscp.