SUMMARY

• Around 15 years of experience in IT including consulting and administration experience with, Oracle BI Apps, OBIEE, Hyperion products, Oracle Data Integrator (ODI), Informatica and OLAP - related technologies.
• Experience in Oracle BI APPS (OBIEE, ODI,Informatica, DAC)
• Experience in Hyperion Public Sector Planning and Budgeting Application.
• Expertise in writing Business Rules and Calculation scripts.
• Expertise in Life Cycle Management (LCM) to migrate the artifacts from source to target server for all Hyperion products and DB export/Import.
• Extensive knowledge in Hyperion Public sector planning and Budgeting OOTB application, Business Rule, Webforms.
• Extensive experience in design, analysis, development and implementation of various applications in Client/Server environment using Hyperion Planning 11/9.x,Hyperion workforce Planning, Hyperion Essbase 11/9.3.X/7.X, Essbase Administration Services (EAS), Hyperion Financial Reports, Hyperion Analytical Reports, Hyperion Smart View, Essbase Spreadsheet Add-in on Windows and Unix environments.
• Well-versed in SDLC (Software Development Life Cycle).
• Strong knowledge and Experience in installation, configuration, implementation and troubleshooting of Oracle Data Integrator (ODI).
• Has provided technical support to the Finance, Automobile and commercial banking.
• Expert in software installation, configuration, upgrading, testing and migrating of cubes in different environment.
• Proficient in writing program through Oracle SQL and PL/SQL on UNIX and Windows platforms.
• Experience in interacting with Business users to analyze the Business Process and requirements to transform the same into mock up screens and functional requirements.
• Well versed with Global database standards, SQL, Export/Import, SQL*Loader, PL/SQL Development, Shell Scripts, Performance Tuning of Database, and User management.
• Responsible for all training and knowledge transfer to off-shore personnel in support of
• Results-oriented individual who views challenge as an opportunity. A strong team player capable of working independently with excellent communication, analytical, and inter-personal skills.
• Experience in IT including consulting and administration experience with Oracle Business Enterprise Edition (OBIEE), Hyperion products, Oracle Data Integrator (ODI) and OLAP-related technologies.
• Experience on OBIEE 10.1.3.x/11 in designing Rpd using Administration Tool, Dashboards, Answers and Business Intelligent Solutions using Data Warehouse and OLAP Techniques.
• Experience on Informatica/DAC.
• Well versed with OBIEE plus components like OBI server, Answers and Interactive Dashboards.
• Developed several Interactive Dashboards with drill-down capabilities using global & local Filters for Oracle Business Intelligence Applications.
• Good Understanding on EBS R12 Procure to Pay Process, Order to Ship modules.

TECHNICAL SKILLS

DW Tools(OLAP and Reporting Tools): Hyperion Planning 9.x/11.x, Hyperion Essbase 9.x/11.x,Hyperion Financial Reporting, Hyperion Web Analysis Studio, Hyperion Smart View, Hyperion Analytical Administration Services, Hyperion Shared Services

Business Intelligence Tools: OBIA 7.9.6.3/ 11.1.1.10. 1 , ODI 11.1.1.9, Informatica 9.0.1 Hot fix and DAC OBIEE 10.1.3.3/10.1.3.4/11 g,OracleBIpublisher,OracleBI Administration Tool.

Languages: MAXL scripts, Essbase Calculation Scripts, UNIX, SQL, PL/SQL, Shell scripting.

Other Tools: T.O.A.D, Secured shell, Export/ Import, SQL*Loader, ODI (Oracle Data Integrator), Stats pack, Explain plan.

Project Planning Tools: Microsoft Project, Visio and Microsoft PowerPoint

Databases: Essbase v6.x, v7.x & System 9.3.1, SQL Server 2000, Oracle (11/10x), MS Access.

H/W Platforms: Windows 2003 and XP, UNIX.

PROFESSIONAL EXPERIENCE

Confidential

BI lead

Responsibilities:

• Lead and participate in activities on cross-functional teams in order to achieve goals of BI and IT projects.
• Setup, configuration and implementation of reporting solutions in BW and BI platform as a deliverable of either separate reporting requests or as part of other IT projects/initiatives.
• Translated DWHS design in OBIEE star model and responsible for all RPD configurations and changes Understanding of source data definitions (Oracle EBS).
• Created and Maintained Physical and Logical Data Models for Business applications, Operational & Analytical structures.
• Customized/Extended OOTB OBIA as per customer requirements using ODI Studio and Oracle BIEE Metadata repository (RPD) and Dashboards.
• Categorized reports (pre-built, customized and new), allocating OBIEE tasks (report development, security configurations) to development team and reviewing deliverables.
• Created BI publisher Data Models, Triggers and Bursting reports and Created Interactive BI Publisher reports and RTF Template designed to meet report requirements
• Responsible for engaging with end-users to communicate changes/impacts to the existing reports and prototyping/ demonstrating new reporting capabilities.
• Provided training on OBIEE/OBIA Dashboard/BI Publisher to business users.
• Troubleshoot production issues and identify and develop solutions
• Designed and Development complex end-user reports which included both ad-hoc queries and executive dashboards using OBIEE/BI Publisher.

Confidential

Sr. OBIEE/ODI/BI Apps consultant

Responsibilities:

• Implemented End to End implementation of the OBIA upgrade from 7.9.6.3 to 11.1.1.10. 1
• Gathering the system requirements.
• Worked with the Infrastructure team in building the servers as per the oracle recommendations for the OBIA 11.1.1.10. 1
• Installed and configured OBIEE 11.1.1.9, ODI 11.1.1.9, OBIA 11.1.1.10 and OBIEE 12.2.1.0.0.
• Gathering the ETL requirements for upgrading/customizing from Informatica to ODI as part of upgrading from OBIA 7.9.6.3 to OBIA 11.1.1.10.
• Upgraded the OBIEE RPD/Catalog from 11.1.1.6 to 11.1.1.9 and to 12.2.1
• Worked on the RPD Merge techniques to merge the OBIA 7.9.6.3 RPD with OBIA 11.1.1.10.
• Implemented MSAD integration.
• Worked on Building the ODI Projects/Mapping/Interfaces/Procedures/Packages.
• Built the ODI load plans.
• Worked on ODI version control.
• Worked on the implementation of Security on OBIEE reports/Dashboards and folders.
• Worked with users providing hands on training on the new features of OBIEE 12.2.1
• Created Custom Execution Plans and Scheduling in DAC.
• Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups.
• Designed and Tested Reports in the Dashboards for the Oracle Financial Analytics modules like GL, AP, AR and created the Ad-hoc report according to the client needs.
• Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
• Identified issues, bottlenecks, and provided the solutions in the entire upgrade implementation Reports.
• Extensively worked with the users in testing the Upgrade features.
• Parallel supported the ongoing production environment.

Confidential

Sr. OBIEE/Informatica/BI Apps Developer

Responsibilities:

• Worked on BI Apps 7.9.6.3 Financial Analytics, Procurement and Spend Analytics and Project Analytics.
• Gathering the report requirements from user and analyzing the need for the ETL, Customized existing and developed new SDE & SIL Informatica mappings using transformations like Lookup, Filter, Expression and Aggregator.
• Good Understanding on EBS Procure to Pay Process, Order to Ship modules.
• Created Primary keys using Sequence Generator and loaded dimension from flat file using source analyzer and Expression builder in Informatica.
• Used the Data Warehouse Administration Console (DAC) to build, load and configure the Oracle Business Analytics Warehouse
• Created Custom Execution Plans and Scheduling in DAC.
• Maintaining the Full and Incremental loads through DAC on different environments like Development and Test environment.
• Developing OBIEE Repository (.rpd) at three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Interactive Dashboards with drill-down capabilities using global & local Filters, Security Setup (groups, access / query/report privileges), configured Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling iBots.
• Designed and developed new dashboard as per the user requirement (using hierarchical columns, selection steps, slider graphs, Scorecards) using OBIEE.
• Trouble shooting error and warnings while developing RPD for BI Financial, Procurement and Projects and grants Analytics.
• Enhanced Query performance, by analyzing & modifying SQL Query and Filters, for all the reports and dashboard prompts, to minimize the delay in Physical Query Execution
• Re Implemented the complete OBIEE security with the Microsoft AD integration from OBIEE-EBS integrated security.
• Worked with Web Logic Administration console to configure security within the OBIEE 11g using Application Groups and Roles.
• Responsible for cloning the Informatica, DAC, OBIEE web catalog and RPD from PROD TO DEV, TST environments on scheduled basis.
• Deployed all the updates into production after following the developing, Testing and following the protocol (Change Control Process) to push the changes/ updates into Prod.
• Responsible for cloning the Informatica, DAC, OBIEE web catalog and RPD from PROD TO DEV, TST environments on scheduled basis.
• Implemented Object Level Security for the objects like Dashboards and Reports, and Data Level Security for Departments using Session Variables.
• Applied the OBIEE 11.1.6.12 Bundle Patches
• Worked on laying the road map for the upgrade from OBIA 7.9.6.3 to OBIA 11.1.1.10