SUMMARY:

• Over 7 years of involvement in planning, creating and execution of OBIEE 10g & 11g and ODI 12c/11g/ 10.1.3.4/10.1.3.5, 3+ years' involvement in 11g.
• Valuable knowledge of OBIEE 11g and also having hands on experience in OBIEE 10g in integration with BI publisher Extraction, Load and Transformation (ELT) using Oracle Data Integrator (ODI) 11g, Informatica 9.x/8.x/7.x and SQL, PL/SQL.
• Strong experience in configuring and developing the Analytics/OBIEE Repository (RPD), whichinvolves Schema Import, Implementing the Business Logic by customization, DimensionalHierarchies, Utilities, Subject Areas etc.
• Making and tweaking dashboards and reports to meet client prerequisites.
• Expert knowledge of report development execution in a complex environment.
• Administration of OBIEE and the OBIEE Web Catalog.
• Experience in incorporating BI Publisher with OBIEE.
• Installation, configuration of ODI in Unix / Linux environments.
• Proficient in Oracle, SQL, MS/SQL.
• Excellent relational abilities, administration aptitudes, group abilities with result arranged mentality.
• Excellent communication skills, strong architectural skills, hardworking and a good team player.
• 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 supporting performance tuning and process tuning at all levels.
• Experienced in configuring Usage Tracking and Multiuser Development Environment (MUDE).
• Good Exposure in dimensional demonstrating.
• 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.
• Expertise in installing, configuring, and administering WebLogic Server 6.x/7.x/8.x/9.x/10.x/11.x in various environments.
• Implemented the extraction, loading, and transformation (EL - T) of data using Oracle Data Integrator.
• Expertise with all ODI graphic tools - Topology, Security Manager, Designer and Operator and configuring the ODI master and work repositories, ODI models defining and organizing the ODI project including interfaces, packages, procedures, variables and user defined-functions.
• Hands on experience working with ODI Knowledge Modules- LKM, IKM, RKM, JKM and CKM.Customized versions for the existing ODI Knowledge modules which can be re-used in data integration projects.
• Expert ability to trouble shoots and prioritizes issues.
• Excellent interpersonal and communication skills for efficient client interaction.

TECHNICAL SKILLS:

• Oracle Data Integrator(ODI) 12c/11g/ 10.1.3.4/10.1.3.5
• OBIEE 11G/10G, Reports 10Gg/6i/4i, WebLogic Server 6.x/7.x/8.x/9.x/10.x/11.x
• Discoverer 10g/6i/4i, Forms 6i, XML Publisher 5.6.3/5.6.2, Oracle Web Application Server 4.0.8
• Oracle Enterprise Manager (2.1.0), General Ledger, Accounts Receivables, Accounts Payables
• Order Management, Inventory, Fixed Assets, Cash Management, Advanced Pricing
• Service Contracts, Purchasing, AOL, System Administrator, Oracle 10g/9i/8i/7.x
• TOAD, SQL Navigator, SQL*PLUS, SQL* Loader, Unix Shell scripts, K shell, C shell
• SQL, PL/SQL, JAVA, XML, C, C++, Unix, Linux, Windows 7/ NT/XP/2000/98.

PROFESSIONAL EXPERIENCE:

Confidential, TX

Sr. OBIEE/ODI Developer

Responsibilities:

• Worked on Oracle Enterprise Manager to activate and Deploy RPD.
• Extensively used Catalog Manager for migrating Web Catalog.
• Worked in developments of analytics Reports using OBIEE Answers and assign them to specific Dashboards with Oracle Financials EBS as source of data from the modules like AP,GL and FA
• GG setup integrated capture to replace CDC.
• Experience in installing, maintaining, upgrading and patching Golden Gate.
• Worked on the RPD for the new Subject area design for the Cash flow Metrics Created Reports, Dashboard Prompts and Dashboard Pages like - Budget and Actual, Balance Sheet.
• Responsible for designing, developing and testing of the ETL strategy to populate the data from various source systems (Flat files, Active Directory-LDAP, SQL Server and Oracle).
• Created Repositories, Agent, Contexts and both of Physical & Logical Schema in Topology Manager for all the source and target schemas.
• Installing ODI 11.1.1.6 on all the environments and configuring ODI.
• Patching ODI 11.1.1.6.0 to 11.1.1.6. and Upgrading ODI from 10.1.3.4 to 11.1.1.6.4.
• Testing the newly upgraded ODI 11G and ODI 12C fixing issues related to upgrading and running ODI jobs as per schedule.
• Created ODI Procedure, ODI Package, ODI Variables, ODI Scenarios,, ODI Functions, ODI Mappings, ODI Load Plans.
• Created the users, profiles using the ODI security manager.
• Financial Planning Manager and other developers
• As an administrator I was responsible for security across multiple users and groups.
• Created Packages, Scenarios and Load Plan Components, Load Plans using ODI.
• Generated Load Plans and Executed Integrated Testing over Payroll Subject Area using ODI.
• Provide ad hoc ability in the OBIEE system for query and build reports.
• Configured the OBIEE repository(Physical, BMM and Presentation layer)
• Created dimension hierarchies and aggregates in the BMM layer.
• Customized reports in OBIEE answers and integrated them into the Dashboards according to the Business requirements.
• Performed Data Validation of data in the reports and dashboards.
• Unit, integration and system testing for all components of ETL and reporting. Prepared test cases and documented the results.
• Created PL/SQL stored procedures, functions and triggers for change data capture(CDC).
• Creating standalone agent on windows server.
• Implemented CDC through ODI Journalization Knowledge Modules (KMs).
• Developed Expressions, filter, joins, Split, Variables, user functions Using ODI .
• Developed interfaces for loading the lookup and transactional data.
• Developed interfaces to load the data from flat files, SQL Server to stage and from stage to Oracle HUB.
• Created Dynamic and Session Variables and Performance tuned the ODI interfaces.
• Changed knowledge modules using Java code for AP/AR for General Ledger tables in ODI.
• Performance Tuning of Reports and made required changes to repository and database.
• Complete responsible for preparing the END to END Document.

Environment: ODI 11.1.1.5.0, ODI12c, WebLogic Server 11.x, OBIEE 11.1.1.6.5, OBIA 7.9.6.3, Oracle EBS, Oracle 11g, SQL*PLUS, SQL Developer, Windows XP.

Confidential, TX

Sr. OBIEE /ETL Developer (ODI)

Responsibilities:

• Involved in Creating and Administering the Physical Layer, Business Model & Mapping
• Layer and Presentation Layer using Oracle Business Intelligence Admin tool.
• Responsible for developing OBIEE repository RPD from the scratch using the best practices for the three layers.
• DevelopedPL/SQL Packages, ProceduresandFunctionsaccordance with Business Requirements for loading data into database tables.
• Developed Oracle BI Metadata repository using BI Administration tool.
• Developed interactive Dashboards and Reports in Oracle BI Answers as per the reporting specifications.
• Defined and created Initialization Blocks, Repository and Session Variables for generating filters and defining security.
• Created Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model & mapping layer.
• Gathering requirements from users to develop interfaces, packages.
• Deploying Scenarios from one environment to other environment.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
• Applied Cascading Prompts and Multi Level Prompts on Dashboards.
• Identified issues, performance bottlenecks, and optimized the Business Intelligence Dashboards and Reports.
• Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Upgrading from ODI 10G to ODI 11G environment.
• Resolving Upgrade issues to make sure daily loads run efficiently.
• After Upgrading in Development environment performed export and import
• Experience in Dimensional Modeling such as star schema, snow flake schema, creating Facts, Dimensions and Measures.
• Export/Import interfaces across different environments
• Created Topology which includes creating Master/Work repositories, Physical/Logical schemas, Agents, and Context.
• Experience in running RCC (Repository consistency check) to see if master and work repositories are consistence.
• Purged the logs in the operator.
• Performed sending mails to team whenever any ODI jobs are failed by using ODI tools.
• Worked in importing data from different sources like database, flat file, XML files, excel.
• Experience with Business systems such as Sales, Inventory and Order Management.
• Used Interfaces to load data from Flat files, CSV files in to staging area (Oracle) and load in to Oracle data warehouse
• Experience in increasing efficiency of data load from source to target by doing performance tuning.

Environment: OBIEE 11G, PL/SQL, Oracle BI Apps 7.9.6.3 / 7.9.6.2, Oracle Data Integrator (ODI) 11.1.1.7/10.1.3.5, Oracle 11g/10g, SQL*Plus,, TOAD, WinNT/XP and UNIX.

Confidential, Bentonville, AR

Sr. OBIEE Lead Developer /OBI Admin /ETL Developer

Responsibilities:

• Requirement analysis gathering, analyzing the functional and technical specifications.
• Gathered requirement and analysis for contact center telephony customized analytics.
• Work closely with business users to ensure completeness of requirements.
• Worked mainly on HR Analytics and worked with ETL team to develop tables and generated reports, as per requirements.
• Worked on creation of adhoc dashboards in OBIEE.
• Worked with detailed reports on various aspects of financial transactions and marketing data to brokers, historical sales, customers and financial centres on daily basis.
• Extracted the pre-built BI solutions of tables using Oracle BI Apps 7.9.6.(Marketing Analytics)
• Preparing MD50 and MD70 documents for the new functional requirements.
• Working on the Oracle EBS R 12,BI publisher reports, dashboards, adhoc reports.
• Implemented Security by creating roles & web groups using LDAP Authentication.
• Created and modified logical tables, logical columns and defined Foreign-keys and complex joins.
• Created dimensions, dimension hierarchies, levels, level based measures and defined level, attributes level keys.
• Extensively worked on admin tool, Answers, Dashboards, BI publisher and Security for users. Worked on creating complex reports, and cutomized widgets.
• Designed, developed and modified OOTB reports and dashboards.
• Worked extensively on various Cache Management techniques to increase the performance of the both Real-Time and Non Real-Time reports.
• Configured users, roles and privileges in administration console.
• Worked on security for users based on LDAP Authentication and SSO in Production and also other Authentication types (External table authentication and Database) in other environments.
• Worked extensively on Custom Build Real-time (OLTP source) and Non Real-Time Reports to enable Market/ Corporate Users to Order Management, Installation Management and Cash Management.
• Created Test Cases based off of the design specifications.
• Created mock reports as per the user requirements.
• Developed liaison with the Business to translate Business issues into IT solutions.
• Created adhoc reports and dashboard mock up as per the requirement.
• Wrote SQL Queries to test the transformations.
• Aggregate Navigation-Creating aggregate tables using materialized views.
• Executed Test cases in all phases of testing Regression testing, Integration Testing, System testing, end-to-end testing and UAT.
• Develop Test Plan including test scripts for Unit, System, and User Acceptance Testing including resolution of bugs.
• Observed configuring DAC environment created and scheduled execution plans.
• Involved in adding all the newly developed Dimension, General, Aggregate and Fact tables in to DAC and creation of new Subject Areas.
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r7.1
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Performed Report Validation and Integration Testing and manipulations using SQL.
• Exposure and knowledge of ETL transformation using ODI.

Environment: Oracle BI Apps 7.9.6,OBIEE 10.1.3.4, Oracle 11g, ODI, DAC 10.1.3.4.1, Oracle 10g R2ERwinr7.3, SQL, SQL Developer 1.5, HTML, Solaris 5.1, Windows Server 2003.

Confidential, PA

OBIEE Developer

Responsibilities:

• Implemented Financial Analytics and Procurement and Spend Analytics. Integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).
• Gathered requirements from the client for GAP Analysis, translated them into technical design documents and worked with team members in making recommendations to close the GAP.
• Worked on integrating and configuring BI Publisher with OBIEE.
• Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBot queries to obtain daily and weekly reports.
• Installed and Configured OBIEE, DAC and Informatica on Unix/Linux Environment.
• Upgraded Whole BI platform from 10.1.3.4.0 to 10.1.3.4.1 and BI Apps from 7.9.5 to 7.9.6.1.
• Worked on integrating and configuring BI Publisher with OBIEE.
• Implemented and worked on Multi User Development Environment (MUDE).
• Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBot queries to obtain daily and weekly reports.
• Experience creating, enhancing and optimizing simple to complex reports using Oracle Business Intelligence reporting tool including implementing functions to customize and enhance reports. Performed data analysis and modeling to write accurate and optimal SQL queries for BI Publisher reports.
• Responsible for day-to-day running of a busy team and able to mentor and guide team members.
• Developed PL/SQL packages and created Temp tables, which were used in Informatica and to develop reports in BI.
• Content settings, Complex joins fragmentation content and defining of Most Economical Source as per business requirement.
• Extensively involved in unit testing, peer testing and regression testing.
• Designed and Developed Custom Mappings in Informatica to bring the data from Legacy system to Data Warehouse.
• Extensively developed mappings on various business areas in the project by employing the available Transformations.
• As reporting architect on various Oracle Application implementations, made effective use of Business Intelligence as primary and adhoc-reporting tool. Defined strategies, custom designed and developed Presentation Layers, defined standards and processes for BI Development Cycle, performed BI installations, tuning, Testing and Bug fixing.
• Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Customized Oracle BI metadata in the analytics repository with Oracle BI Administration Tool.
• Customized the Repository by creating Facts and Dimensions and adding some extra columns to the Existing Facts and Dimensions.
• Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE.
• Created Dimension hierarchies to achieve the drill down functionality.
• Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.

Environment: Oracle Applications 11i/R12 General Ledger, Account Payables, Accounts Receivables, Inventory, Purchasing, Fixed Assets, BI Apps 7.9.6, OBIEE 10.1.3.4.1 /10.1.3.4/10.1..3.3/10.1..3.2, Informatica 8.6.0, DAC 10.1.3.4.1, XML/BI Publisher 5.6.3, Discoverer 10g/4i/3i,, SQL*PLUS, SQL*Loader, TOAD, Unix.

Confidential

OBIEE Developer

Responsibilities:

• Created Dashboards and Answers for End user.
• Implemented Invoice level security in OBIEE depending on the user level access by integrating with EBS.
• Performed the setting up, Installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration with the data warehouse.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local Filters using Oracle BI Presentation Services.
• Was involved in the installing and configuring of Financial Analytics.
• Designed and Developed General Ledger, Payables, Receivables and Profitability Dashboards in

• Developed Dashboard pages like AP Balance, Overview, Payments Due, Supplier Details and Invoice Details in Payables Dashboard.
• Developed Dashboard pages like Overview, Margins, Revenue, Products and Customers in Profitability Dashboard.
• Setup Multi User Development Environment (MUDE) in OBIEE.
• Monitored Incremental and Full load of Data through Data Warehouse Administration Console (DAC) and Informatica Workflow Monitor.
• Responsible for extracting data from Oracle Apps Modules & loading into stage system and warehouse system.
• Created and ran Sessions & Workflows to load the data into the Data warehouse.
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.
• Created Presentation catalogs, and Folders in Presentation Layer, and Performed Global Consistency Check in Oracle BI Administration Tool.
• Configured and Scheduled Sessions and Workflows.
• Exclusively Involved in Unit Testing, Peer Testing & Regression Testing.
• Worked on multiple folders at time to meet the dead lines of the tasks.
• Created VPD security for reports in OBIEE.
• Designed and developed logical model in BMM in Repository.
• Installed and Configured DAC.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Created custom reports in Payables in OBIEE according to user requirement.

Environment: Oracle Applications 11i/R12 iProcurement, General Ledger, Account Payables, Accounts Receivables, Fixed Assets, BI Apps 7.9.5, OBIEE 10.1.3.4.0/10.1..3.3/10.1..3.2, Informatica 8.1.1, DAC 7.9.5, XML/BI Publisher 5.6.3, Discoverer 10g/4i/3i,, SQL*PLUS, SQL*Loader, TOAD, Unix.