SUMMARY

• Over all 8+ years of professional experience in Business Intelligence, Data Warehousing and Database Applications including Analysis, Design, Development, Testing and Support usingODI,OBIEEand BI APPS.
• Experienced inOBIEEsolution architecting(OBIEE11g & OBIEE10g) and have a strong understanding onOBIEE11g capabilities with Web logic 10.3.5 as an Application server.
• Hand - on Siebel 8.1 CRM,OBIEE10g/11g and OBIA 7.9.x end-to-end implementation as a full project life cycle.
• Well-versed in Data Transformations and Data Migrations using Oracle Data Integrator 10g/11g from heterogeneous sources such as Oracle, MS SQL Server, DB2, Legacy systems, Flat Files and XML Files to perform ETL operations.
• Expertise inODIsetup, Master Repository, Work Repository, Projects, Models, Packages, Interfaces, Scenarios, Filters, Metadata and extensively worked onODIknowledge modules (LKM, IKM, CKM, RKM and JKM).
• Strong experience in configuring and developing the Analytics/ OBIEE Repository (RPD), which involves Schema Import, Implementing the Business Logic by customization, Dimensional Hierarchies, Utilities, Subject Areas etc.
• Excellent experience in designing and implementing complex ETL/ELT jobs.
• Expertise in creating and implementing functionalities like Dimensional Hierarchies, Measures, Aggregation rules, Level based measures, Rank functions, Time Series Objects.
• Experience in developing OBIEE Repository at three layers (Physical Layer, Business Model & Mapping Layer and Presentation layer).
• Analyze, design, develop, modify and testOBIEEDashboards / Reports with different Analytics Views (Pivot Table, Chart, Tabular and View Selector), Alerts, Guided Navigation, and Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters.
• Excellent experience in designingOBIEEDashboards, BI Answers, and Analytics using Administration Tool of Oracle Business Intelligence Enterprise Edition on Top of Data Marts and Data warehouse.
• Worked extensively on debugging, troubleshooting the defects and production issues in the areas ofODIjobs andOBIEEreports.
• Extensively utilizedOBIEEdelivers for sending alerts via intelligence agents (iBots) to interactive dashboards for subscribed users.
• Created worksheets by implementing different joins (left, inner, right, and outer joins), data blending and custom SQL and data source filters based on business requirements.
• Expertise in writing SQL Queries, complex joins for generating complex stored procedures, User-defined functions.
• Experience in creating Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures, and parameters.
• Involved in performance tuning of Oracle SQL, PL/SQL queries.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams.
• Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Excellent exposure to GL, AP, AR and PO modules, and further specialization in the EPM product line which includes Financial Service Industry (FSI).
• Implemented BI solutions in various domains such as Oracle Financial, Sales, and Human Resources worked on end to end implementation of BI APPS which include (OBIEE, ODI)
• Created highly formatted reports in Oracle BI publisher by using Oracle BI answers and Oracle BI server metadata. Performed RPD and web Catalogue merging.
• Configured and installed metadata objects and Web Catalog Objects, BI Publisher and integrated with OBIEE server.
• Expertise in Oracle SQL and database Performance Tuning by implementing Parallel Execution, Table Partition, materialized views with query rewriting, creating appropriate indexes, usage of hints, re-building indexes.
• Mapped Dashboard field requirements to OLTP/OLAP Physical/Business Model.
• Valuable knowledge ofOBIEE11g and also having hands on experience inOBIEE10g in integration with BI publisher Extraction, Load and Transformation (ELT) using Oracle Data Integrator (ODI) 11g, SQL, and PL/SQL.
• Expertise with allODIgraphic tools - Topology, Security Manager, Designer and Operator and configuring theODImaster and work repositories,ODImodels defining and organizing theODIproject including interfaces, packages, procedures, variables and user defined-functions.

TECHNICAL SKILLS

Reporting Tools: OBIEE 10g/11g, BI Publisher, BI Apps, RPD, Oracle EBS, OBIA 7.9.x, Scheduler DAC 7.x, Siebel Analytics 7.7 / 7.8,SSRS.

Oracle Applications: General Ledger, Accounts Receivables, Accounts Payables, Order Management, Inventory, Purchase Order.

ETL Tools: Oracle Data Integrator (ODI) 11g/12c, Informatica 8.6.0/8.6.1/9.0.1 , Informatica on Demand.

OBIEE Tools: BIEE 11.X/10.X, OBIA 7.9.5/7.9.6/7.9.6.1/7.9.6.2 DAC.

Data Modelling: Relational Modelling, Dimensional Modelling (Star Schema, Snow-Flake, Fact, Dimensions), Data Quality, Entities, Attributes, ER Diagrams, IBM-Rational Rose, MS Visio

Web Servers: Apache, IBM Web Sphere, Web Logic, and IIS.

Databases: Oracle 11g/10g/9i/8i, MS SQL Server, Teradata and DB2

Languages: SQL, PL/SQL, C, C++, Data Structures, UNIX Shell Script, Visual Basic

Web Technologies: ASP.NET, CSS,HTML, XML, Java Script

Operating Systems: Windows 98/2000/2003/ XP, Win 7, Linux

Others Tools: SQL plus, PL/SQL Developer, Toad, SQL* Loader IDQ, DB2.

PROFESSIONAL EXPERIENCE

Confidential, FL

OBIEE/ODI Developer

Responsibilities:

• Participated in the Requirements Gathering of the various work streams by meeting with the business user and base lining the details. Installed configured and administrated OBIEE 11g.
• Worked on Key Performance Indicators (KPI) within the BI environment which can be used as the catalyst toward driving more responsive interaction between users and data.
• Worked on Configuration & Application Deployment Management.
• Designed level measures and aggregate calculation using RPD
• Designed and developed Performance Measurement Dashboards/ Reports that are Dynamic & Interactive with drilldown, drill across capabilities split reports for summary & details information, and local & global filters using Oracle BI Presentation Services.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Enhance performance of Reports/ Dashboards by implementing the Aggregate tables, Materialized Views, Table partitions and managing Cache.
• Worked on Oracle Enterprise Manager to activate and Deploy RPD, Security, Capacity Management etc.., in OBI 11.1.1.6.
• Worked on Metadata Repository objects and also Web catalog Objects which include Dashboards, Reports, Pages and Folders.
• Customized Purchase Orders, GL, Account Receivables, Account Payables, Procurement and Spend Analytics, Order Management, Inventory reports using OBIEE 11g.
• Implemented data level security (Location Managers, Sales Executives etc.) using Session.
• Variables by creating content filter in dimension table in red.
• Set up the ODI connection with Oracle, oracle SQL Server and flat files.
• Troubleshoot the ODI connection with oracle by fixing the tnsnames.ora file.
• Implemented object level security for both repository objects and web objects by creating users and groups in repository and web catalog groups in the Presentation Services.
• Created Dimensional Hierarchies and Level Based measures, worked on Expression Builders and Calculation Wizards to generate certain expressions.
• Created ODI packages, scenarios using interfaces, variables, procedure
• Worked onOracle Enterprise Managerto activate and Deploy RPD.
• Performance tuned the OBIEE11.1.1.9interfaces.
• Extensively worked on developing Data model based on STAR schema concept using OBIEE 11g Administration Tool for current and future reporting requirement.
• Customized Oracle BIEEMetadata Repository using Siebel Analytics/OBIEE Admin Tool by importing some of the required objects with integrity constraints into Physical Layer.
• Performed implementation from OBIEE11g to OBIEE12C.
• Configured LDAP server to Authenticate users and implemented both object level and data level security based on roles and responsibilities.
• Involved in FIT GAP analysis between OBIEE 10.1.3.4.2 OBIA 7.9.6.2 and OBIEE 11.1.1.6.0 OBIA 7.9.6.3.
• Implemented OBIA ETL customizations on core fact tables AP, AR and related conformed dimensions both SDE and SILOS mappings.
• Performed Unit, Integration and Regression testing to validate reports and mappings.

Environment: OBIA7.9.6.3,OBIEE 12C, ODI 12.2.1, BI Publisher, RPD, BI Admin tools 11.1.1.9.0 , SQL, PL/SQL, Oracle 10g, Windows, Web Logic Server 11gR1 PS3, Financial Analytics, HR ( Human Resources) Analytics.

Confidential

OBIEE/ODI Developer

Responsibilities:

• Installation and Configuration ofOBIA/ODI/OBIEE 11G and 12C.
• Built EL-T ODI processes to demonstrate ODI functionality.
• Worked with the business analysts to identify and refine business requirements, create the technical architecture, environment necessary to support the business requirements and lead offshore team for development and testing.
• Planning the implementation, documenting the functional specification documents, technical specification documents and test case documents for the business processes identified.
• Designed and developed the OBIEE Analytics Metadata Repository (rpd) using OBIEE Server Admin tool by importing the required objects (Dimensions, Facts & Aggregates) with Referential Integrity constraints into Physical Layer using connection pool, developing multiple dimensions (Drill-down Hierarchies) & Logical & Facts Measure objects in Business Model Layer, and creating Presentation Catalog in Presentation Layer.
• Created Oracle BI Answers Requests, Oracle BI Interactive Dashboard Pages and Prompt
• Implemented comprehensive security functionality - created users & web groups, external table security using session variables, tested and validated model using BI Admin tool and associated catalog objects & Web modules with the created users / groups to data and object level security.
• Extensive Experience on Topology Navigator with developing ODI Physical and Logical Architecture, Contexts and Configuring Agents.
• Setup ODI 12c - upgrade existing ODI 11 - Integrate with OWB.
• Backing Up Your Existing ODI 11g Environment
• Upgrading the Database Containing the ODI Repository.
• Upgrading Your Standalone Agent Environment (no WebLogic Domain).
• Upgrading Your Standalone Agent Environment (with WebLogic Domain).
• Primary responsibility includes installing and configuring the Oracle Data Integrator ODI software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning, developing ETL.
• Created and Configured ODI Repositories, Interfaces, Packages, Procedures and Scenarios.
• Extensively used ODI to load data from Oracle, XML files and flat files
• Increased performance of loads by applying proper Hints, Indexes, and Analyzing master tables and explain plans to check cost.
• Worked closely with the end users/business and designing the documents to the track changes.
• Coordinated with the on-site and off-shore team and working on service requests as team.
• Used Oracle Data Integrator ODI to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database and Oracle EBS interface tables.
• Experience in BI Applications in development of rpd, data models and integrating with EBS, SFDC for development
• Experience in ODI designer, Topology, Operator, Master repository and work repository creation.
• Prepared detailed design for the ELT & PLSQL part of the system
• Worked in Interface creation, Packages, Scenarios, Variables, Sequences, Procedures and User Functions in ODI.
• Worked for different concepts like pivoting and parallel job execution in ODI.
• Developed Dimension Hierarchies in un BMM layer in RPD
• Involved in Performance tuning for the jobs in ODI.
• Scheduling jobs and load balancing in ODI.
• Extensively involved in production issues.

Environment: OBIEE 11.1.1.9.0 , RPD, BIAPPS 11.1.1.9.x, Oracle Data Integrator 11.1.1.9.0 /12C, EBS R12.1.3, Oracle 11g, Oracle E-Business Suite, Windows.

Confidential, San Jose, California

OBIEE/ODI Developer

Responsibilities:

• Involved in complete life cycle implementation of Invoices Tracking Analytics Application made for the Accounting Team to monitor the invoices made to Point-of-Sale (POS) customers, Commercial / Business customers and third-parties.
• Interacted one on one with SME from Billing and Account Receivables departments and other key Business Users in gathering the Analytics / Reports Requirements.
• Worked with business analysts to understand and document business needs for decision support data.
• Played an active role strategizing the migration of development objects from the development server to production server.
• Worked closely with ETL Team for enhancement to Facts / Dimensions in developing the Initial and Incremental ETL process.
• Developed many Reports using different Analytics Views (Pivot Table, Chart, and Column Selector), Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer.
• Also created hierarchies, variables, and event poll strategies in the repository.
• Developed Performance Tuning Strategies for optimizing the performance.
• Involved in the installation and configuration of Oracle BI EE 10.x in the windows as well as the Linux environment.
• Organized testing schedules and test scripts. Managed execution and sign-off tests and also played an active role in product rollouts.
• Involved actively in understanding knowledge modules for the current business process and rewriting them inODI.
• Involved in managing the data describing the information systems physical and logical architecture by usingODITopology Manager graphical tool.
• Created database connections, schemas, etc., using Topology Manager
• Involved in ETL process of loading the data from XML file to database to build the performance by usingODI.
• Worked extensively in creating and modifyingODIKnowledge Modules (RKM, LKM, JKM, IKM, CKM, and SKM).
• Created documentation of details that is implemented inODIobjects such as interfaces, procedures, variables, packages.
• Performed Designing, Developing and implementing tasks of multipleODIinterfaces.
• Involved in developing and maintaining various Packages, Interfaces, Variables, and Models, which populated the Data into the Target Star Schema on Oracle Instances usingODI.
• Managed users and permissions inODISecurity manager.
• Worked with Oracle DBAs when creating master and work repositories forODI.
• ConfiguredODIAgents on Windows server and tested them to execute and scheduleODIScenarios.

Environment: OBIEE10.X,ODI10g, Siebel Analytics 7.x, Oracle 10g/9i, Toad, Putty, Linux