SUMMARY:

• 8 years of experience in designing, developing and implementation of OBIEE 10g & 11g, 3+ years' experience in 11g.
• Experienced in OBIEE … BI Applications 7.9.6.x, 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). Experienced in Data Warehousing Methodologies.
• Experienced in OBIEE solution architecting (OBIEE 11g & OBIEE10g) and have a strong understanding on OBIEE 11g capabilities with Web logic 10.3.5 as an Application server. Knowledge on Tableau 8.1
• Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer. Experienced in working with Oracle Fusion & Web Logic.
• Experienced in designing and developing Data Modeling and Analysis using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables and Physical and Logical data modeling in the OBI Administration tool.
• Highly skilled at configuring OBIEE Metadata Objects including repository, variables, interactive dashboards with Map viewer/Big Maps/Google Maps, reports and three tier OBIEE architecture.
• Experienced in writing, testing and implementation of Stored Procedures and Packages at database level using PL/SQL, Database designs Methodologies.
• Experienced in Integrating OBIEE with Hyperion Essbase 9.x and in developing RPD and reports against multidimensional databases.
• Expert in configuring, designing, development, implementation and using Oracle pre-build RPD's (Financial, HR, Sales, Supply Chain and Order Management, Marketing Analytics, etc.) and ETL Mappings according to business requirements. Experienced in Oracle EBS R12 Financial.
• Expert in building repositories using star schema, developing Subject Areas, and applying security (group, access / query privileges) at object and data level in Administration Tool. Hands on experience in customizing reports, filters and charts in Oracle BI Answers, Interactive Dashboards, BI Publisher (Excel) and Delivers. Expert knowledge of report development execution in a complex environment.
• Comprehensive knowledge in general accounting principles, business functions of general ledger, treasury accounting, accounts payable, asset management, billing, cash flow statements and receivables.
• Experienced in Simplifying Migration Process - Changing environment specific variables in RPD development, administration, analysis report.
• Created and scheduled iBots using delivers to send alerts, run reports, and deliver reports to the users. Experienced in supporting performance tuning and process tuning at all levels.
• Proficient in using the time-series functions to support historical time comparison analysis and creating requests, adding filters, creating prompts, and creating pivot tables.
• Experienced in configuring Usage Tracking and Multiuser Development Environment (MUDE).
• Experienced in creating Dimensional hierarchies and designing customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variables.
• Experienced in translating business requirements into a business dimensional model, key subject areas, dimensions, hierarchies, attributes and measures.

TECHNICAL SKILLS:

OBIEE Infrastructure: OBIEE … OBIEE … OBIEE 10g

OBIEE Applications: OBIA7.9.6.3, 7.9.6.1(Financialanalytics, HR Analytics, Sales, Service, Marketing) ETL Tools Knowledge in Informatica Power Center9.0, InformaticaPower center8.6.1, DAC … ODI 11g Languages and Web Technologies SQL, PL/SQL, Java, C, C++ XML, HTML/XHTML, TOAD, SLA

ERP and Applications Servers: Oracle Applications 11i, R12, PeopleSoft 8.9, Oracle Web Logic Server 10.3.5 RDBMS DB2 UDB (8.x and 7.x), Oracle11g/10g, MS-Access, SQL-Server 2008,Hyperion System 9 Essbase Operating Systems Microsoft Windows 8.x, Windows 7, Solaris 5.8, UNIX, Oracle Enterprise Linux 5.7, Mac OS X

Methodologies: Software Development Life Cycle (SDLC) -Waterfall Model, Agile Methodology, Rational Unified Process (RUP)

WORK EXPERIENCE:

Sr. OBIEE Developer

Confidential, Sunnyvale, CA

Responsibilities:

• Interacted with Client Services Management business representatives for gathering the Reports / Dashboards requirements and to define business and functional specifications.
• Creating and modifying Business Intelligence requests using Oracle Business Intelligence Answers.
• Performing administrative tasks related to the development and configuration of Interactive Dashboards.
• Designed and Built OBIEE RPD at 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model / data mapping (create Logical tables & data source mapping) and Presentation Layer level (create presentation catalogs.), test and validate the model.
• Developed the Dimensions and Time Series Objects in the Business Model and Mapping Layer with Security settings using LDAP Authentication to setup groups, access and query privileges
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Used Oracle Business Intelligence Delivers to configure, schedule, and deliver personalized alerts to Interactive Dashboards by using Agents.
• Created Data Model Design and Documentation (Facts and Dimensions, Business Users & Security Permissions, Stars with Hierarchies, Business Model Names for Source Columns, Reports and Dashboard Layouts).
• Created Database Report Layouts Using BI Publisher Desktop (Template Builder) in MS Word.
• Integrating OBIEE and BI Publisher and Scheduling BI Publisher reports and Created BI publisher reports based on various data sources.
• Developed different levels of Security set-up are for the entities of the application (on both Repository file and Web catalog file).
• Developed and Debugged Interactive Dashboards and Reports relating to Customer Feedback Analytics, with different Analytic Views (Guided Navigation, Pivot Table, Chart, View Selector, Column Selector, Filters, and Dashboard Prompts) using Presentation Services.
• Implemented Object Level Security for the objects like Dashboards and Reports, and Data Level Security for Region and Product dimensions, using Session Variables.
• Developed Performance Tuning Strategies for optimizing the performance.

Environment: OBIEE 11.1.1.7, OBIEE Financial Analytics 7.9.6.1, Essbase 9, Oracle EBS R12.1.1, Informatica 8.6, DB2 UDB (8.x and 7.x), Oracle Enterprise Linux 5.7, Windows Server 2003, Windows XP.

Sr. OBIEE Developer

Confidential, Westlake Village, CA

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 Data warehouse Administration Console (DAC) according to the OBIA 7.9.6.3financial 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 People soft 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.
• Configured the OBIEE repository (Physical, BMM and Presentation layer)
• Created dimension hierarchies and aggregates in the BMM layer.
• Worked with the repository (PRD) and session variables. Created Initialization blocks to provide Object level security for the users.
• Designed developed new subject areas and modified according to the requirements. Created answers page/ dashboards/prompts/Analysis on requirement.
• Used the security settings to setup users, Groups in Web logic Console 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.
• Generated reports using the OBIEE features like pivot tables, charts and view selector.
• Performed Data Validation of data in the reports and dashboards.
• Performed production support activities/trouble shooting the issues.
• Prepared and maintained documentation for all new or modified RPD objects and ETL mappings.
• Unit, integration and system testing for all components in OBIEE. Prepared test cases and documented the results.

Environment: OBIEE 11.1.1.6, OBIEE Financial Analytics 7.9.6.3, Oracle EBS R12.1.1, Informatica 8.9, Oracle 11g, Oracle Enterprise Linux 5.7, Windows Server 2008 R2, Windows XP.

OBIEE Developer

Confidential, Seattle, WA

Responsibilities:

• Installing OracleBI Analytics and configuring the connection parameters with SQL Server, Oracle 10g.
• Created/Modified Metadata repository (rpd) as per the data requirements by using OracleBI Analytics Server Admin tool.
• Independently Designed and developed subject areas in the RPD(Physical, BMM and Presentation layer)
• Defined 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.
• Involved in Data Modeling, Design Documents, and data warehouse.
• Conducted project planning and work estimations.
• Responsible for supporting and enhancements for the existing projects in OBIEE.
• Updated the RPD layers and OBIEE reports upon modifications.
• 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).
• Created Snowflakes and Star Schema to perform data modeling for proposed architecture.
• 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).
• Created materialized views to fasten slower queries with complex joins in them.
• Identified Data Sources (Oracle BI& Enterprise DW) & Extension columns - Identified OracleBI OLTP tables, fields, Map them with Staging Tables and finally map them to OLAP's Physical layer tables/schemas.
• Developed and scheduled iBots for delivering personalized reports to users on time.
• Secured Dashboards and Reports by defining user roles.
• Participated in the implementation of any OBIEE product upgrades. Performance tuning ETL mappings and Reports
• Implemented OBIEE security at the data and object levels.
• Manage/modify database security and database schema.
• Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Created/designed functional and technical documentation for Reports, RPD and Informatica mappings.
• Applied Optimization techniques and tuned performance of the reports such as caching and building summary tables.
• Supported business operations via OBIEE including: investigating defects or issues.
• Identified the gaps between user requirements and existing applications - Primarily the Finance App.
• Done data migrations using Import/Export, FTP, Database Links and SQL*Loader.
• Trained End Users to Build Ad Hoc Reports using OBIEE.

Environment: OBIEE 10.1.3.4, Informatica 8.1, PL/SQL, TOAD and Windows.

OBIEE Developer

Confidential, Chicago, IL

Responsibilities:

• Gathered information by interacting with clients and end users.
• Involved in full Life Cycle Implementation of OBIEE.
• Involved in requirement analysis, designing of Data Warehouse, populating Warehouse using Informatica ETL, Design and implementation of custom business intelligence solutions (Metadata and Dashboards/ Reports) using the Oracle Business Intelligence (OBI) Analytics platform.
• Performed the detailed design implementation and testing of Reports/Dashboards and Analytical Data Model (Metadata/rpd).
• Designed and built Starschemas/snowflake schemas upon requirements.
• Configured repository (RPD) to use the LDAP authentication.
• Define the mapping from various physical databases to Business Layer to create the various subject areas in Presentation Layer.
• Defined dimensions and facts in the subject areas.
• Implemented OBIEE security for users and groups in administrator tool.
• Created reports by applying views, filters, calculations and conditional formatting in answers.
• Designed Intelligent Dashboards for different user groups to view updated KPIs.
• Created and scheduled iBots as per the business requirements.
• Participated in the Modeling of several multidimensional Data Marts including surrogate key design and index placement.
• Created the source and target instances and various transformations (Joiner, Aggregate, Lookup, Filters and Router Transformations) in Informatica and also created mappings, sessions and workflow to run ETL process using Informatica Power Center.
• Used DAC (Data Warehouse Administration Console) Client to manage, configure, customize and monitor ETL process.
• Applied Optimization techniques and tuned performance of the reports.
• Provided technical and user documentation and training. Created Dashboards on Pharma Sales Analytics.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Worked in the development of OLAP Databases and Structures used in the Health Care sector.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to OBIEE Repository.
• Migrated the tested code of Repository, Dashboard reports, and OW Mappings and Workflows from Development to QA and from QA to Production Environments.

Environment: OBIEE 10.x, Informatica Power Center 7.1.3, Oracle 10g, TOAD, Teradata and Windows 7.

OBIEE Consultant

Confidential

Responsibilities:

• Gathered Business Requirements by interacting with IT and documented them unambiguously as System Requirements Specifications (SRS) combination of (FR/NFR).
• Created Highlevel Design Documents (HLD) according to the Business System Requirements (FR/NFR)
• Worked as an Application Designer for Mapping & Designing RPD and ETL development.
• Documented Application Design Mapping & ETL Mapping, which helps Developers to implement ETL and RPD.
• Designed and Developed Custom Business Intelligence Solutions (Metadata and Dashboards/Reports) using OBIEE platform.
• Developed the OBIEE Metadata repository (.rpd) model with the necessary logic that involved creating the Physical, BMM layers with aggregates, dimensions & time series functions, Presentation layer with catalogs & folders and external table security using Siebel Server Admin tool. Also created hierarchies, variables, and event poll strategies in the repository.
• Developed Dashboards for each of Metrics by embedding Reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics in providing summary and detail reports.
• Implemented Dynamic Navigation to allow the system to pass parameters from the summary dashboards to the details dashboards.
• Implemented Groups and Hierarchy Level Based security to dashboards based on Role.
• Configured and automated iBots to deliver daily and weekly reports based on schedule.
• Performance Tuning of Reports by implementing the aggregate navigation, Cache and Oracle Materialized Views.
• Worked on DAC, Pharmacy Analytics for creating Auto Execution and Scheduling Tasks.

Environment: OBIEE 10g, Oracle 10g, Oracle Enterprise Manager, Oracle Developer 6.0/6i, SQL*Loader, SQL*Plus, PL/SQL, Windows 2000, Autosys, UNIX (Sun Solaris), TOAD, PL/SQL Developer.