SUMMARY:

• OBIEE Lead/Architect having 9 years of overall IT experience involving Architecting, Analysis, Design, Development and Implementation using standard SDLC methodologies.
• Core competencies include Data Modeling, Design and Development of OBIEE repositories, and building OBIEE Dashboards/Reports and working on OBIEE toolset (BI Answers, Delivers), Informatica ETL Data mart, Development/Administration of Confidential .
• Experience in configuring BI apps and managing data load parameters in BIACM.
• Extensive experience in designing and developing end - to-end BI solutions according to standard OLAP methodologies using Siebel Analytics/Oracle Business Intelligence (OBIEE), including 4 full life cycle implementations.
• Expertise in design and development of the three layers (Physical/Business Model and Mapping/Presentation) of an OBI Metadata Repository using Oracle BI Administration Tool.
• Configured Answers (ad-hoc querying, reports), Interactive Dashboards with drill-down capabilities (charts/tables/graphs), Delivers/iBots (alerts) and administered Web Catalog Objects (pages, folders).
• Experience in Security Setup at both Object and Data levels, which involved creation of users/groups, Confidential authentication setup and configuration of Multiuser Development Environment (MUDE).
• Created various BI Publisher reports and RTF templates.
• Extensive experience with ETL processes using Informatica Power Center tool.
• Proficient in ETL processes of creating Source/Target definitions, building Mappings/Mapplets using various Transformations, creating and monitoring Sessions/Workflows.
• Extensively used the four basic Informatica Power Center tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Expertise in Data warehousing concepts and different stages of handling data viz. requirement gathering, identifying data sources/targets, data modeling, data cleansing, data loading.
• Proficient in defining key metrics, dimensions, hierarchies, attributes and building Star and Snow flake schema.
• Extensive experience in Unit, Regression, Performance, Integration and User Acceptance testing methodologies.

TECHNICAL SKILLS:

• Oracle BI Applications 7.8.x, 11.1.1.8.1
• Oracle BI 11.1.1x/10.1.3.x
• Informatica Power Center/Power Mart 8.8/8.1/7.1/6.2
• Confidential 7.9.5/7.8.5 .
• ODI 11g,
• Sybase 12SQL Server 2008/2005/2000 Oracle 11i/10gMs Access with VB 6.0
• OC4JApacheIBM Web SphereWeb LogicIIS
• ErwinMicrosoft Visio
• CC#T - SQLPL/SQLHTMLCSSXML
• Win NT 2K Win XPRed Hat Linux, UNIX

CHRONOLOGICAL SUMMARY OF EXPERIENCE:

OBIEE Administrator/Developer

Confidential, Chicago, IL

Responsibilities:

• Performed functional configuration of BI Apps to load data into Data Warehouse tables.
• Involved in managing data load parameters and reporting parameters in BIACM for Financials, Supply Chain management, Project Analytics and HR Analytics.
• Managed Domain load plans in BIACM to load EBS data into Data warehouse tables.
• Involved in maintaining source files like GL Acct/Chart of Accts in BI Apps required for the data load in DWH.
• Performed FIT/GAP analysis on the out of the box reports.
• Worked on Designing security table and implemented SSO, Data level security to reports.
• Set up MUD Environment, created projects, patches and worked on RPD migration and Catalog migration.
• Worked with the users to gather the requirements and created BR-100s, MD.050s and MD.070s as per the requirements.
• Worked with ODI Developers and Oracle Applications team to identify source tables in EBS, create new mappings and also to modify the out of the box mappings.
• Created new mappings and modified existing mappings given as Confidential .
• Modified the out of the box reports, prompts and filters as per the user requirements.
• Set up Usage tracking in BI; created usage tracking reports to analyze the performance of reports using run times.
• Maintained Data Lineage for the modified out of the box reports.
• Created logical facts and dimension tables, subject areas in RPD for custom development of reports.
• Created various custom developed dashboards and reports involving charts, prompts and filters.
• Created action links between the reports and between the dashboards.
• Created and scheduled agents to deliver the reports to management.
• Customized OBIEE login page to include Confidential logos.
• Implemented write back functionality in the reports.
• Applied patches to existing version of OBIEE to accommodate new features.
• Involved in performance tuning of the reports.

Environment: OBIEE 11.1.1.7, ODI 11g, EBS 12.1.3, BI Apps 11.1.1.8.1 , Windows 7, LINUX, Weblogic, SQL Developer, PuTTY, WinSCP

OBIEE Lead Developer

Confidential, Torrance, CA

Responsibilities:

• As the OBIEE lead, Involved in end to end implementation of three projects.
• Obtain the requirements from business users and created BRDs an involved in design of warehouse tables.
• Administered OBIEE and applied patches to existing version.
• Involved in data modeling and creating ODI interfaces to load the data into tables.
• Created various subject areas and also worked on parent - child hierarchy, level based hierarchies.
• Implemented both data level and object level security for the reports at RPD level and Reports level.
• Set up MUDE and Involved in Repository migration and catalog migration across the environments.
• Created reports, action links, various views in reports as per the requirements.
• Customized the OBIEE login page and Confidential custom messages and colors to login page.
• Set up usage tracking for the reports and also implemented write back functionality
• Integrated Maps into OBIEE using Map viewer and created reports using map view.
• Worked on OBIEE reporting based on ADF pages as source.
• Implements Proxy access (Act As) feature to view the reports.
• Involved in performance tuning of the reports and cache management.
• Round the clock production support of all the projects developed.

Environment: OBIEE 11.1.1.7, ODI 11g, Oracle R12, Windows 7, SVN, WebLogic, SQL Developer, FileZilla

OBIEE Architect/Lead

Confidential, Stamford, CT

Responsibilities:

• Lead two projects involving OBIEE Answers Reports and BI Publishing Reporting.
• Customized the OBIEE Repository (Physical, BMM, and Presentation layers).
• Responsible for the Confidential and Powercenter execution plan development for a new OBIEE implementation of Financial Analytics.
• Created dimension hierarchies, aggregates, level based measures, defined level keys in BMM layer.
• Create drillable/guided navigation reports based on business requirements.
• Created repository variables and initialization blocks in RPD and presentation variables in Answers.
• Created customer faced documents using BI Publisher.
• Involved in production migration of BI Publisher reports, OBIEE RPD and Web Catalog. Also involved in version management
• Created reports involving multiple datasets in BI Publisher and created RTF Templates.
• Created charts and cross tabs in BI Publisher templates.
• Performance Tuning of Answers Reports and BI Publisher reports.
• Scheduled BI publisher reports via java app which enables the users to send/distribute the reports by themselves to distribution list.
• Involved in upgrade process from OBIEE 10.1.3.4 to 11.1.1.5
• Enhanced all the Answers reports/ BI Publisher reports and RPD after the upgrade.
• Helped manage risk analysis and mitigation plans, status reports, and client presentations; prepared business process models, milestone deliverables, and established critical success factors.
• Maintaining the Full and Incremental loads through Confidential on different environments like Development and Test environment.
• Created and maintained documentation for the project describing all the tasks and work flows.
• Provided post production support for the two deployed projects in OBIEE and BI publisher.

Environment: OBIEE 11.1.1.5 / 10.1.3.4.1 , BI Publisher, BI Apps 7.9.6.3, Oracle 11g, Windows XP, Solaris, Aquadata Studio, Confidential 7.9.5, SVN

OBIEE Developer

Confidential, Houston, TX

Responsibilities:

• Involved in all the phases of project from initial phase to the production release like requirement gathering, design, development, testing and release.
• Customized Confidential (Out of the box) Sales Analytics and Oracle Incentive Compensation ( Confidential ) repository as per the business requirements.
• Personally implemented most key projects of Empower rollout which involved building dashboards for Order Management, Order Fulfillment, Customer Service, Installation Management, Cash Management and Incentive Compensation.
• Created number of key reports for business such as Cross sales report, Revenue report, Finance and Authorization report, Lender analysis report for business to analyze.
• 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 to satisfy the end users. Managed dashboard and request security/privileges in the analytics catalog manager.
• Worked with onshore and offshore team of 5 developers and led the team in the direction of development.
• Worked on Informatica OOB and Customized SDE, SIL Mappings, Workflows following best practices of Siebel. Worked with Siebel compatible table structures by configuring Informatica transformation objects.
• Deployed the Informatica workflows to the Siebel Confidential and created dependency and dependent hierarchical tasks and monitored all the tasks in the execution plans that were running, scheduled, completed and failed with Confidential feature called run history and resolved the failed ones. Streamlined the Execution plans with their respective tasks in Siebel Confidential .
• Configured interactive dashboards by adding embedded content such as links/images, HTML objects and folders.
• Used Catalog Manager to maintain Analytics web catalog to manage Dashboards and Answers.
• Used the Security settings in Oracle BI Admin Tool to set up SSO, users, groups, access privileges and query privileges.
• Generated Real-Time Reports based on Siebel Call Center Application data model.
• Installed Informatica Power Center Version 8.6.1 in Sandbox and upgraded V7 to V8.1.1.
• Involved in Production support for Informatica, Confidential and Analytics and helping users with any questions regarding the reports or the data.

Environment: OBIEE V 10.1.3.4.1 , Confidential 7.9.5, Oracle 10GR2, Sun Solaris Platform, BI Apps 7.9.1, Oracle EBS 11.5.10, Siebel CRM 7.9.5, Toad, SQL*Plus, OBI Publisher, Windows XP.

OBIEE Developer

Confidential, Fort Washington, PA

Responsibilities:

• Involved in Creating and Administering the Physical Layer, Business Model & Mapping Layer and Presentation Layer in 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 OBIEE Answers and assigned them to application specific dashboards.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Configure and interactive Dashboards to alert the Marketing team about business changes.
• Managed day-to-day Rpd, BI Delivers, Scheduler & 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.
• Worked on Event Polling Tables to clear out the Cache on the OBIEE server side.
• Worked extensively on the initialization blocks and session variables for the SSO implementation to access the groups based on a pipelined table function.
• Built prototype reports from excel spreadsheets during the requirement-gathering phase to visualize the reports and clarify requirements.
• Handled Full load and refresh load via staging tables in the ETL Layer and involved in Design and Data Modeling using Star schema.
• Involved in upgrading the platform and applications to OBIEE though sequential and concurrent tasks which includes upgrading webcat, scheduler and migrating the rpd.
• Designed & assisted Informatica ETL developer to create new Aggregates.

Environment: OBIEE 10.1.3.4.1 , Oracle 10g, UNIX, SQL server, Windows NT 2000.

ETL Developer

Confidential

Responsibilities:

• Gathering the business requirements & technical specifications and the design of the systems.
• Analyzed complex mappings to extract and transfer source data from different databases.
• Worked extensively on ETL Designing for Fact, Dimensions tables used in BI Reporting (Siebel Analytics/OBIEE).
• Extracted data from Sales department to flat files and load the data to the target database.
• Designed and developed Informatica mappings for data loads.
• Used different transformations to develop Mappings such as Joiner, Aggregator, Router, and Normalizer & Expression.
• Tuning Informatica Mappings and Sessions for optimum performance.

Environment: Siebel Analytics 7.8/7.7/7.5, Informatica 5.0, Power Mart, Windows 2000, MS SQL Server 2000.