PROFESSIONAL SUMMARY:

• Over 8 years of experience in OBIEE (Oracle Business Intelligence Enterprise Edition, Oracle BI Apps - Prebuilt Analytic Packages and Oracle Apps (Oracle EBS) implementations.
• Expertise in complete SDLC (Software development Life Cycle) which involves Requirement Gathering, Proof of concept, Gap analysis, converting functional to technical Spec, Design, Development, Testing and Implementation of the OBIEE/Siebel Analytics/ BI Apps/ Informatica/ ETL/ DataWarehouse/Oracle Apps projects.
• Expertise in implementing Oracle BI Apps in all phases like implementing Out of order Box (Vanilla mappings) prebuilt mappings, Designing ETL, metadata management using DAC, OBIEE RPD development, reports and dashboards.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large-scale DataWarehouse using Informatica Power Center, scheduling using DAC and reporting using OBIEE.
• Involved in end to end implementations of BI solutions for implementing Oracle Financial, Human Resources, Procurement and Spend Analytics, Supply Chain and Order Management Analytics.
• Involved in flattening Essbase account dimension and make use of required metrics for report development.
• Extensive knowledge in OBIEE Essbase integration and using scenarios to meet client requirements.
• Created custom subject areas in Oracle Data integrator and build a load plan to move the data from EBS to DataWarehouse.
• Extensive experience in OBIEE RPD Development, Answers Intelligent Dashboards, Delivers, iBots, implementing security using LDAP, Single sign on (SSO).
• Extensive experience in configuring Interactive Dashboards with drill-down capabilities using global and local Filters, Siebel Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Setup Multi User Development Environment (MUDE) using BI Administration tool.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling. Extensive experience with Fact and dimensional tables, and slowly changing dimensions.
• Having good experience with configuring Data Warehouse Administration Console (DAC) for Creating Execution plans, metadata management and monitoring the Informatica ETL Process.
• Involved in OBIEE upgrade from OBIEE 10g to OBIEE 11g and OBIEE 11.1.1.6 to OBIEE 11.1.1.7.
• Experienced in creating reports using the Oracle Essbase (Essbase) by integrating the Essbase with the OBIEE.
• Experience in development & customization of BI Publisher (XML Publisher) Reports.

TECHNICAL SKILLS:

Reporting Tools: OBIEE 11.x/10.x, OBIA 7.9.X

ETL/ELT Tools: Informatica 9.x/8.x/7.x, ODI 11.x

Relational Databases: Oracle 9i/10g/11gSource System PeopleSoft 9.1/9.2, Taleo 12.5, Essbase, EBS 11i/R12

Methodologies: Data modeling Logical/Physical, Star/Snowflake Schema, Dimension Tables, ETL, OLAP, SDLC

PROFESSIONAL EXPERIENCE:

Confidential, Herndon, VA

OBIEE Consultant

Responsibilities:

• Installed, Configured OBIEE cluster environment and LDAP security Authentication.
• Involved in Usage tracking configuration and maintenance of usage tracking data and handling usage tracking data migrations, along with OBIEE Migrations.
• Created MUD environment and merge new RPD changes from multiple OBIEE developers to master shared RPD to accommodate the new business requirements.
• Developed OBIEE-standalone RPD to extract data from Essbase cubes and Oracle Relational Tables.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository.
• Participating in problem solving and troubleshooting for the applications implemented with ODI.
• Designed Parent Child Hierarchy and Level based Hierarchy in Oracle Data warehouse to match Essbase Hierarchies as part of Essbase and Relational report integration.
• Improved the performance by including the aggregates in the model and setting the priority group according to the requirement.
• Created ODI Procedures for complex logic which is not possible to implement using interfaces and packages.
• Involved in Unit testing, User Acceptance Testing and System Testing to verify accuracy and completeness of ETL process.
• Imported OBIEE Essbase substitution variables and utilized Essbase scenarios to create Actual, plan & Forecast metrics using multiple LTS.
• Worked on upgrading OBIEE Projects from 10g to 11g both the Repository and web catalogues. Developed Dashboards with different subject matter Views (Drill-Down, Pivot Table, Graph, Tabular with Filters) using Oracle Business Intelligence (OBI) Presentation Services for the various work streams.
• Experienced in upgrading from Obiee11g to 12c.
• Modified Action Framework configuration file to implement Dynamic GO URL server name across multiple environments.
• Extensively used action Links and GO URL to build integration between Essbase reports and relational reports.
• Validated completed BI Reports data to compare with Essbase Smart View Add in by importing Essbase cube into excel.
• Configured bisqlgroupprovider adapter as part implementing External Table Authorization provider.
• Designed LDAP authentication with External table data level security to apply business unit level data security.
• Involved in unit testing and integration testing for all components in OBIEE.
• Interacted with end users and developers to validate the data model, reports and dashboards.
• Worked on BI Admin tool in MUD (Multi User Development) Environment to enhance the metadata. Created Folders/Sub-folders for different user groups and departments in Presentation Layer and managed catalog folders using catalog manager in Analytics as well.
• Worked on Configuring OBIEE Security parameters at object level, data level to control access to customer data.
• Provided to the end user’s on OBIEE Answers, Dashboard and Admin tool using OBIEE best Practices. Extensively used Variables (Repository/ Session/ Presentation) to implement Security and to have Dynamic Data Environment.

Confidential, Boca Raton, FL

OBIEE/ODI Consultant

Responsibilities:

• Conducted Join Successfully installed OBIA 11.1.1.8.1 which includes WebLogic 10.3.6 upgrade, OBIEE 11.1.1.7, ODI 11g and OBIA post installation patches.
• Extensively involved in configuring BI APPS for Financial, HR and Procurement Analytics by using the interfaces like BIACM (Business Intelligence Applications Configuration Manager) and FSM (Functional Setup Manager).
• Used ODI Designer to develop complex interfaces (mappings) to load the data from the various sources into dimensions and facts.
• Experienced in setting up ODI standalone Agents and J2EE Agents on Web Logic server based on requirements.
• Involved in Modification of existing scripts as needed for Linux instead of AIX.
• Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating and loading data into Data Warehouses.
• Created interfaces, Packages and Procedures in ODI to code the ETL logic.
• Implemented look up and various set operations in an ODI interface.
• Used ODI built-in version control feature for maintaining versions of ODI ETL components.
• Migrated code from one environment to another environment with DBA’s coordination and other dependent teams in project.
• Generated scenarios and deployed them using ODI Operator for code migration one environment to another environment.
• Used various knowledge modules and customized them if required based on source and target technologies for developing Interfaces using ODI.
• Designed and developed the Metadata Repository (.rpd) using OBIEE Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (Drill-Down, Hierarchies) & Logical Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Modified the OOTB dashboards and reports with many cosmetic and calculation changes according to the requirements
• Created many Custom reports and Dashboard with Advanced OBIEE Functionalities like Guided Navigation, Union reports, View Selector, Navigation to Bi Content etc.
• Setup Multi User Development Environment (MUDE) for developers to work in parallel by creating multiple projects.
• Implemented Tableau mobile dashboards via Tableau mobile application.
• Actively involved in defining the Migration strategy between different environments of repository (. rpd) & Web catalog along with applying security roles to the respective Reports and Dashboards.
• Extensively worked on using the Patch Merge Migration methodology in 11g for migrating changes from Test to Production OBI environments.
• Developed BI-Publisher end user reports which have many formatting capabilities meeting the needs of Users. Prompt integration between the BI-Publisher and the OBIEE Analytics is established using the Presentation Variables.
• Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance.
• Active involvement in documenting the Business requirements and also in interacting with the Data Warehouse Team regarding the Warehouse schema design changes to suit the business needs.
• Extensively involved in developing custom Project Analytics reports Project Profitability Report, Project Burn Report, Quote vs Actual Report and Resource Utilization by Project reports as per our business user requirement.
• Setup the visibility of Dashboards to employees with respect to their responsibilities. Administered permissions and privileges for Dashboard visibility and modifications to users based on their groups or responsibilities.
• Extensively worked with Taleo Cloud service system to receive Taleo source data in csv file format on monthly basis.
• Developed and maintained the logical and physical dimensional data models
• Extensively worked on admin tool, Answers, Dashboards, BI publisher and Security for users. Worked on creating complex reports, and customized widgets.

Confidential, Plano, TX

OBIA Consultant

Responsibilities:

• Installed the Oracle BI Applications (Informatica, DAC, OBIEE) on distributed environment and configured the OOB Prebuilt Oracle HR Analytics, Finance Analytics and responsible for administration and migration of repositories between various environments.
• Extensively involved implementing LDAP Security with External Table Authorization.
• Organized meeting with Business users as part out of the box reports GAP analysis and gathering requirements for custom reports.
• Created Global Prompts, Narrative Views, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Responsible for creating migrating BI Catalog and RPD from DEV Environment to UAT Environment and creating step by detail design document to provide migration details.
• Worked on scheduling Daily incremental loads after creating new client specific execution plan.
• Implemented BIAPPS 7.9.6.4 Financial Analytics, Procurement & Spend Analytics and Human Resource Analytics for PeopleSoft 9.1 source system.
• Expertise with both connected and Un-Connected Lookups, Reusable Transformation, extensively worked with Look up Caches like Shared Cache, Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations, extensively used SQL Override function in Source Qualifier Transformation.
• Extensively worked with Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters.
• Extensively involved in creating client specific custom reports pointing to Taleo, PeopleSoft HCM & custom CSV files.
• Created custom mappings using different Transformations like Source Qualifier, filter, Router, Aggregator, Lookup, Expression, Sequence Generator, and Update Strategy to store the data in target table.
• Involved in designing custom ETL mapping to extract Recruitment information from Taleo and Workforce, Compensation & Performance Management sourcing from PeopleSoft HCM.
• Extensively involved in creating OBIA installation and configuration document to provide step by procedure of OBIEE software installation overview to client team.
• Applied various function formulas in the building the reports in the Oracle BI Answers.
• Created mappings using different Transformations like Source Qualifier, filter, Router, Aggregator, Lookup, Expression, Sequence Generator, and Update Strategy to store the data in target table.
• Extensively involved in customizing pre-built OBIA Financial analytics dashboards Employee Expenses and General Ledger dashboard to meet business needs.
• Involved in designing and developing custom BI reports to replace legacy financial reports sourcing from PeopleSoft 9.1 FNSCM.
• Performing Testing of the IT Defects raised by the Testing team.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems.

Confidential, Corvallis, OR

OBIEE Developer

Responsibilities:

• Merged new RPD, dashboard and Answers requests with existing OBIEE content and Upgraded RPD, Catalog from 10.1.3.4.1 to 11.1.1.3 and 11.1.1.3 to 11.1.1.5.
• Created custom CSS classes and styles, java scripts and HTML scripts to enhance the dashboard functionalityandproduce reports that meet user requirements.
• Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, AnswersandDelivers.
• Worked on improving the dashboard performance, readability,andsecurity.
• Involved in requirement gathering from user through meetings, understanding the business from end userandtechnical perspective.
• Coordinated theOBIEERPD and Web Catalog objects migration from Dev environment to QA environmentandto the Production environment.
• Worked on OBIEE Security implementation to provide data level security according to the user role.
• Extensively involved in creating Monthly/Quarterly/Yearly balance sheet reports source from PeopleSoft FINSCM source system.
• Designed and developed custom BI reports sourcing from PS PROJECT, PS PROJ ACT TEAM & PS PROJ RESOURCE tables to analyze Project status Overview & Project Profitability.
• Worked on applying patches to OBIEE 11g environment after upgrading from OBIEE 10g by working with oracle after identifying the bugs.
• Implemented BI Publisher Bursting for scheduling the reports to deliver based on user role with security.
• Worked on implementing automatic cache purging after monthly data load completion by using Event pooling table.
• Worked on OBIEE mobile report delivery implementation by using IPAD.
• Extensively worked on all phases starting Requirement gathering, RPD development, security implementation, Report development and Report delivery by using Schedulers.
• Suggested the system requirements for installing OBIEE environments as part of upgrading the OBIEE 10g to OBIEE 11g.

Confidential, NY

OBIEE Developer

Responsibilities:

• Involved with management professionals, analysts as well as other business teams on requirement gathering.
• Worked extensively on Oracle Service Analytics to provide a comprehensive customer service solution to the customers.
• Effectively managed ODBC connections and imported the Physical tables, keys and foreign keys.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Created the Dimension Hierarchies and Level Based Measures in the BMM Layer according to the end user requirements.
• Modeling activities which included building star schema as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns in Business Model and Mapping layer.
• Established the logical joins/keys required to support drill-down aggregation.
• Configured advanced Navigation reports, guided navigation link, Union reports etc.
• Implemented the delivery of iBots using OBI Delivers to alert the associated teams.
• Gathered requirements from the users and generated prototype reports to help the business to visualize the design.
• Implemented the Cache Purging Strategy and usage tracking of Reports.
• Defined dimensional hierarchies and associated the proper level of granularity to the fact table.
• Added column/data level security at the repository level. The data was restricted with respect to the group user belongs too.
• Created reports according to user requirements and also created corresponding dashboards for the reports.
• Actively involved in deployment and post release support.
• Trained the users on how to use the Dashboards and Answers and also modify the stored reports in Answers.
• Created and converted BI Publisher reports into OBIEE as interactive dashboards for ad hoc analysis.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and kept logs.
• A number of optimization techniques are used to determine the most efficient access plan for SQL queries.
• Developed custom Packages using PL/SQL to build flat files to migrate data from Legacy to Oracle Systems
• Development of Stored Procedures to encapsulate Business processes.
• Developed procedures, functions, packages, Conversion Programs to convert Payable Invoices and Conversion Program to load Vendor data.
• Adding the triggers in form level, block level and Item level.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Prepared Mapping documents and design documents for data conversion.
• Developed validation procedures and error reporting on the data in the intermediate tables.
• Used dynamic SQL to find out the availability of tickets.
• Optimize the SQL statements using hints and created SQL scripts to tune performances and make backups.