PROFESSIONAL SUMMARY

• 8 years of experience with OBIEE/Siebel Analytics: Application Architecture, Repository Development, configured metadata objects Subject Area, Table, and Column and web catalog objects Dashboards, Pages, Folders, Reports .
• Experience in OBIEE 11.1.1.6, 10.1.3.4.1, Oracle BI Applications 7.9.6.x, BI Publisher, Siebel Analytics 7.x which include building and configuring repository, creating and managing oracle/Siebel Intelligent Dashboards, oracle/Siebel Answers, oracle/Siebel Delivers and oracle/Siebel iBots ETL Informatica, Reporting-Siebel Analytics, Scheduling-DAC .
• Experience in Installing and Configuring OBIEE 11.1.1.5 with Weblogic.
• Experience in Installing and Configuring OBIA Financial, HR, Sales, Supply Chain and Order Management, Marketing Analytics, etc.
• Expertise in implementing complete Data warehouse lifecycle including Installation, Configuration of OBIEE, BI Apps, BI Publisher, Informatica, DAC, Database 10g/11g in Windows and Linux Environment with single and multi-node clusters.
• Expertise in Integrating Oracle EBS with OBIEE, Informatica and DAC
• Experience in understanding transactional data modeling OLTP and working in OLAP data model design.
• Installation and Upgrade of OBIEE/Siebel Analytics, Informatica and DAC Data warehouse Application Console for multi OLTP regional instance environment and on Windows and UNIX environment.
• Expert in installation, upgrade, migration and administration of Oracle applications E business suite on various LINUX and Windows platforms.
• Efficient in analyzing business requirements and designing/creating Subject Area in Analytics Repository RPD .
• Expert in configuring and using Oracle pre-build RPD's Financial, HR, Sales, Supply Chain and Order Management, Marketing Analytics, etc. according to business requirements.
• Extensive experience on OBIEE/Siebel Analytics features i.e.Security, cache, usage tracking, dimensional hierarchy, aggregate navigation, MUD, Disconnected, Integration Variables/Initialization Blocks configuration BI Publisher etc.
• Experience in designing Star Schema/Snowflake Schema methodologies using OBIEE Admin Tool.
• Experience in creating dimension hierarchies and level-based measures and adding disparate sources to business model objects.
• Extensive experience in Performance tuning, identifying bottlenecks and resolving to improve performance at Database, reporting and ETL level Creation of Materialized views, Indices, Aggregate tables.
• Experience on assigning Data level security Object level security to the users using OBIEE repository objects external Database.
• Experience in troubleshooting SQL queries and improve data delivery performance.
• Experience in managing users and setting up their privileges and profiles using LDAP External Table Authentication
• Experience in setting up a Multi-User Development Environment MUDE .
• Created and scheduled iBots using delivers to send alerts, run reports, and deliver reports to the users.
• Proficient in using the time-series functions to support historical time comparison analysis and creating requests, adding filters, creating prompts, and creating pivot tables using OBI.
• Experience in Creating Navigation based on other reports, column selector, dashboard prompts, drill down reports.
• Strong in Analysis and collecting business requirements from Business Analysts and users.
• Team player and an individual contributor with steep learning curve and good interpersonal skills

Technical Skills:

Professional Experience:

Confidential

OBIEE CONSULTANT

Responsibilities:

• Gathered Business requirements by interacting with the business users, defined subject areas for analytical data requirements.
• Performed gap analysis and provided a timeline for the requirements.
• Configured the Datawarehouse Administration Console DAC according to the OBIA 7.9.6.3 Financial analytics.
• Modified the Source system parameters in the DAC according to the Business requirements with their respective currencies and exchange rates.
• Built custom execution plans as to pull data from two different Peoplesoft sources simultaneously in a single run.
• Scheduled the Custom Execution plan for a weekly run in the DAC scheduler.
• Built custom mappings in Informatica SDE, PLP and SIL folders according to the Business Tree structures.
• Included the custom mappings in DAC Execution plan.
• Custom data mart is built with dimensions and facts in order to retrieve the necessary measures and attributes.
• Provide ad hoc ability in the OBIEE system for query and build reports.
• Automated ETL process is set up using Informatica and DAC scheduling tool to gather all the required data.
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Done Migration process.
• Configured the OBIEE repository Physical, BMM and Presentation layer
• Created dimension hierarchies and aggregates in the BMM layer.
• Worked with the repository and session variables. Created Initialization blocks to provide Object level security for the users.
• Used the security settings to setup users, Groups and Access privileges.
• Built materialized views to solve complicated joins and improve performance.
• Customized reports in OBIEE answers and integrated them into the Dashboards according to the Business requirements.
• Created prompts, Drill down and navigation for the Business to view data at different level of granularity.
• Restricted prompts options and visibility according to the level of user viewing the dashboards.
• Generated reports using the OBIEE features like pivot tables, charts and view selector.
• Performed Data Validation of data in the reports and dashboards. Worked with Netezza appliances for BI Reporting/Appliances.
• Extensively used SQL Tuning to improve performance. Created iBots to send pre-processed reports using OBIEE Delivers.
• Unit, integration and system testing for all components in OBIEE. Prepared test cases and documented the results.
• Worked with project management to provide estimates of project costs and timelines Understand business change requests and how to manage business expectations

Environment: OBIEE 11.1.1.6, Oracle Peoplesoft 8.9, ODI 11.1.1.6, Oracle 11g, Oracle Enterprise Linux 5.7, Windows Server 2008 R2, Windows XP.

Confidential

Sr. OBIEE Consultant

Responsibilities:

• Created RPDs, defined Physical Layer, and developed Business Model Mapping and Presentation Layer using Admin Tool.
• Created and managed OBIEE dashboards and reports such as CRDM CVG dashboard, Project status summary Dashboards for a particular market etc.
• Set up Meta data Objects Subject Area, Table, Column security and Data level security
• Modified Metadata Logical definitions in Analytics Repository using OBIEE Administration Tool.
• Created Physical and Complex Joins/ New Joins. Exposed custom attributes in Presentation Layer.
• Used narrative text, column selector, global and column filters to provide the functionality of viewing selective data for the end users.
• Created and maintained environment configuration documents. Was responsible for keeping the configuration management database up-to-date with changes and relationships to test, staging and production environments
• Performed Application Development, Administration of and configure of OBI architecture components and documentation
• Completed documentation when implementing changes to the production environments
• Through proper preparation, ensured environment readiness at the start of each Project Development, test, staging and production cycle
• Applied and coordinated application, OS and client Patches Install and Coordination
• Performed third party application integrations SiteMinder, LDAP, etc.
• Created support documentation SOPs for OBI application FAQ, Issue Log, EPM, Acct admin, etc.
• Monitored daily OBI application performance - Batch jobs, schedulers, services, cache, etc.
• Was responsible for proactive communications with core team - Delays in performance, outages, promotions, upgrades, etc.
• Prepared and executed OBI license utilization reports, system performance metrics, and issue tracking metrics.
• Performed server configuration and management tasks
• Responsible for OBI application security management and user accounts
• Responsible for OBI repository file, Migrations and Code Deployment during the project life cycle until
• Managed and escalated issues as needed.

Environment: OBIEE 11.1.1.6 11.1.1.7 Admin tool, Answers, MUD, Dashboards, Delivers, Agents / iBots, Windows Server 2003, 2008, Oracle 10g, 11g .

Confidential

Sr. OBIEE Consultant

• Gathered Business Requirements and documented using Oracle's process Templates like MD50's etc.
• Help answer questions associated with the design of the status quo application, its features, and its capabilities
• Helped refine and determine feasibility, correctness, and completeness of end-user's requirements
• Participated in the scope definition meetings
• Performed data analysis on the sources Oracle EBS
• Experience in Installing and Configuring OBIA Financial, HR, Sales, Supply Chain and Order Management, Marketing Analytics, etc
• Configured Physical layer, Business Model Layer and Presentation Layer of the Repository
• Renamed the components as per business terminology
• Installation of Oracle 10g on single node and on cluster.
• Implemented Dimensional Hierarchies, Aggregate navigation, Fragmentation content, and other various features to meet the business requirements
• Created Repository, system and non-system session variable and initialization blocks for various reporting needs
• Created role based dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and various report prompts
• Utilized OBI reporting features Navigational, Drill Down, Drill Across, Guided Navigation, Security .etc
• Data and objects are restricted in accordance with application
• Cache is purged programmatically
• Integrated OBIEE with Oracle EBS and Siebel Application
• Created reports using the BI Publisher
• Delivers IBots are created and scheduled for fast response
• Conducted code walkthrough for the reports
• Created several analytical reports on Billing, Receivables, Customer demographics and Revenue
• Custom implementation is done with consideration of future enhancements and upgrades
• Developed custom SDE mappings that tapped to source systems and load staging area
• Developed custom SIL mappings to load data from the staging into target area
• ETL tasks related to Hierarchies Aggregates are created
• Used transformations like Source Qualifier , Expression , Update Strategy , Look up etc
• Configure Custom Workflows.
• Custom incremental mechanism applied to non-application data
• Performance tuning done to all jobs
• Full mode / incremental migration is done across different instances
• All Informatica tasks are configured in DAC
• Configured DAC for OBIEE Financial Analytics.
• Applied custom incremental mechanism that controls the data set
• New Subject Areas created
• Analyze Execution Plan
• Tested execution Plan in both Incremental Full Mode
• Parallel processing the ETL tasks that belong to same task order
• Worked on simple to complex interfaces and extensively used the advanced concepts of Informatica while developing the mappings
• Performance tuning is achieved
• Exported the DAC repository in full / incremental mode Logical, System Run
• Configured the AP, AR, GL, Profitability Analytics, and Extract date, Global and Local Currencies, Fiscal Calendar, Exchange Rate Types
• Experience in setup of General Ledger account Hierarchies
• Experience in Mapping Oracle GL Natural Accounts to Group Account Numbers
• Implemented User, Object and Data security in the integrated environment EBS and OBIEE
• Conducted walkthrough explaining the interface between Oracle EBS and OBIEE
• Designed Technical, Functional and ETL Design documents and Prepared Documentation For Testing and Production Support
• Contact point for defects in ETL team and Monitored the maintenance release.

Environment: OBIEE 10.1.3, OBIEE Financial Analytics 7.9.6.1,Oracle EBS R12.1.1, JD Edwards 8.1, Informatica 8.6, Oracle 10g, Oracle Enterprise Linux 5.7, Windows Server 2003, Windows XP

Confidential

OBIEE Developer

• Configured OBIEE Security Model, Siebel Security Model in BI Publisher reports and made them available for Siebel users accessing OBIEE Dashboards
• Extensively worked on RPD, dashboards, IBots, Answers Prompts
• Created BI Publisher reports and made them available on OBIEE Dashboards
• Worked on creating RTF templates, Layouts, Parameters for BI Publisher reports
• Installed and configured BI-Office, integrated it with OBIEE Web Catalog, and made the OBIEE reports and charts accessible in Microsoft Excel and Power Point
• Gathered Business Requirements and documented using Oracle's process Templates
• GAP analysis between the existing reports and OBIEE
• Configured Physical layer, Business Model Layer and Presentation Layer of the repository
• Renamed the components as per business terminology
• Implemented Dimensional Hierarchies, Aggregate navigation, Fragmentation content, and other various features to meet the business requirements
• Created Repository, system and non-system session variable and initialization blocks for various reporting needs
• Created role based dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and various report prompts
• Implemented MUD Multi User Development Environment
• Implemented Security Cache features to accommodate business requirements
• Security of the reports
• Moving and Merging the repository
• Done several Type I and Type II customizations on the Warehouse
• Created several SDE's and SIL's Mappings for Siebel as source
• Configuration of the DAC Server and the DAC client
• ETL refresh performance improvement
• Analyze and fix the problems reported by the users
• Coding, testing and supporting to users for UAT
• Carry out Quality Assurance activities for all deliverables

Environment: OBIEE 10.1.3.2, Informatica 7.1.4, Oracle 9i, TOAD, UNIX, Windows XP.

Confidential

Siebel Analytics Developer

Responsibilities:

• Created and administered the Physical Layer, Business Model and Mapping Layer, Presentation Layer in a Siebel Analytics repository.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Developed custom reports/Ad-hoc queries using Siebel Answers and assigned them to application specific dashboards.
• Developed different kinds of reports pivots, charts, tables using global and local filters.
• Configure Interactive Dashboards with delivers/iBots to alert the marketing team about business changes.
• Managed day-to-day Rpd, Siebel Delivers, Scheduler and iBots.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Handled full load and refresh load via staging tables in the ETL Layer.
• Designed and developed new Aggregates using Informatica ETL processes.
• Developed and tested stored procedures, functions and packages in PL/SQL for data ETL process.

Environment: Siebel Analytics 7.0, Informatica 6.1, Oracle 8i, UNIX, SQL server, Windows NT 2000.