PROFESSIONAL SUMMARY:

• Over all 8+ years of professional experience in Business Intelligence, Data Warehousing and Database Applications including Analysis, Design, Development, Testing and Support using ODI, OBIEE and BI APPS.
• 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.
• Hand - on Siebel 8.1 CRM, OBIEE 10g/11g and OBIA 7.6.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 in ODI setup, Master Repository, Work Repository, Projects, Models, Packages, Interfaces, Scenarios, Filters, Metadata and extensively worked on ODI knowledge 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 test OBIEE Dashboards / 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 designing OBIEE Dashboards, 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 of ODI jobs and OBIEE reports.
• Extensively utilized OBIEE delivers 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 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, SQL, and PL/SQL.
• 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.

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

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, Tampa, 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 on Oracle Enterprise Manager to 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.
• Performed Unit, Integration and Regression testing to validate reports and mappings.

Environment: OBIEE 11.1.1.9, 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, Lone Tree, CO

OBIEE/ODI Developer

Responsibilities:

• Installation and Configuration of OBIA /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, 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 in ODI.
• Involved in managing the data describing the information systems physical and logical architecture by using ODI Topology 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 using ODI.
• Worked extensively in creating and modifying ODI Knowledge Modules (RKM, LKM, JKM, IKM, CKM, and SKM) .
• Created documentation of details that is implemented in ODI objects such as interfaces, procedures, variables, packages.
• Performed Designing, Developing and implementing tasks of multiple ODI interfaces.
• Involved in developing and maintaining various Packages, Interfaces, Variables, and Models, which populated the Data into the Target Star Schema on Oracle Instances using ODI.
• Managed users and permissions in ODI Security manager .
• Worked with Oracle DBAs when creating master and work repositories for ODI.
• Configured ODI Agents on Windows server and tested them to execute and schedule ODIScenarios.

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

Confidential, Westlake, TX

OBIEE/ODI Developer

Responsibilities:

• Extensively worked on creation of packages, construction of data warehouse and data marts, and synchronization using ODI
• Assisted in Installation & configuration of Oracle Data integrator ( ODI ) in the Windows environment
• Used RKM to reverse the metadata of the system database
• Involved in creating database connections, physical and logical schema using the Topology Manager.
• Monitor the scheduled ODI jobs in PROD and apply fixes for failed ones
• Used ODI designer to create projects and release scenarios
• Created master and work repositories for ODI by coordinating with Oracle DBAs
• Worked extensively on tuning various OBIEE system components settings to meet some of the user requirements
• Created cross-functional reporting against various data sources
• Designed and developed various Interactive Dashboards and reports with drilldowns, guided navigation, switching reports out of variable prompts and dashboard section conditions
• Designed and developed Dashboards/Reports mockup as per user requirements
• Designed Dashboard pages like Vendor Details, Vendor Payment Details and Invoice Details with different Analytics Views (Pivot Table, Chart, Tabular and View Selector), Alerts , Guided Navigation
• Designed and developed Financials, Procurement and Spend Dashboards in OBIEE according to user requirements and created executive level dashboards to provide insight into the financial data
• Implemented Write back functionality with in OBIEE to allow users to input data into Data Warehouse
• Migrated RPD, Catalog, Security from Development to Test to Production
• Worked extensively on Performance Tuning at various levels such as Dashboards , Reports, logical query and physical query
• Created auto purge for repository projects and scheduled as per the demand
• Conducted various workshop sessions with super users to bring then up to speed on subject areas, reports, dashboards and also helped them to understand the limitations of the System
• Security management for users, groups and web-groups using the various authentication systems (Database table, Dashboard / Report-level security)
• Customized OBIEE Styles, Skins and Messages according to the client requirements

Environment: OBIA 11.1.1.7, ODI 11g, OBIEE 11.1.1.6.6/6.2/11.1.1.5/10.1.3.4, Oracle 11g, SQL Developer, SQL, PL/SQL, Windows XP.

Confidential

PL/SQL Developer

Responsibilities:

• Designed and implemented ETL processes that scan and read data from more than 20 tables from relational database to staging table doing required transformations.
• Wrote stored Procedures/Functions/Packag es in various schemas as per business requirements and was involved with the tuning, Performance, Optimization of queries and standardization of the code.
• Involved in performance fine-tuning of the queries/reports using Explain plan and Tkprof.
• Created stored sub programs with Dynamic SQL and Ref Cursors
• Implemented nightly load processes to read changed benefit and geographic data sent from mainframe as flat files which includes transformations, scanning tables for missing fields, error reporting etc.
• Worked on procedures that load data into Star Schema from staging tables.
• Involved in performance fine-tuning of the queries/reports using PL/SQL and SQL Plus.
• Created stored sub programs with Dynamic SQL at both Client and Server side.
• Wrote scripts for creating tables, Indexes, Grants and Synonyms in different schemas and made modifications for the existing tables as per business logic.
• Implemented utilities that use DBMS scheduling to scan relational database tables for updates at specified intervals.
• Implemented special precautionary measures to avoid duplicates while scanning multiple tables for changes.
• Used Database trigger for making history of insertion, updating, deletion and all kind of Audit.
• Extensively used oracle packages, Stored procedures, sequences, ref-cursors, dynamic queries, utl-files, bulk inserts, exception handling, DB Links etc.
• Worked on porting of existing reports based on relational database to Star Schema, which involves defining queries involving fact and dimension tables.
• Closely interacted with testing team to address issues and defects on the timely manner.

Environment: TOAD, PLSQL Developer, Oracle10g/9i.