Summary

• 8 years of overall experience in Information Technology industry
• 6 years of experience in working with Oracle Business Intelligence Enterprise Edition OBIEE applications 10.1.3.4.1/ 11.1.1.3 / 11.1.1.5 / 11.1.1.6 / 11.1.1.7.5 Oracle Answers, Oracle Dashboards, Oracle Administration RPD Tool, BI Publisher, Map Viewer and Web Console
• 3 years of experience in developing complex reports in BI Publisher in OBIEE 11g
• 4 years of experience in working with data warehouses and data marts using Informatica Power center 8.1, 8.6 Designer, Repository Manager, Workflow Manager and Workflow Monitor
• Responsible for Implementing 3 Complete Life Cycle/End-to-End System Developments gathering Business Users Requirements, System Analysis, Design Data Modeling, Development, Testing of Data Warehouse, Datamart and Business Intelligence using Oracle Business Intelligence OBIEE
• Hands on experience in implementing Oracle EBS R11.5 and Oracle EBS R12/11i modules for the HR Analytics, Financials AR, OM Analytics and Procurement Spend Analytics.
• Proficient in Installing and configuring OBIEE/Siebel Analytics
• Working knowledge of Hyperion Essbase cubes
• Proficient in Installing and configuring OBIEE/Siebel Analytics, configuring parameters of Instanceconfig.xml Nqsconfig.ini
• Proficient in using OBIEE 11g Web Console for Deployments and Upgrading Security Polices
• Hands on Experience in Setting up Data Level, Row Level and Cell Level Security in OBIEE RPD
• Excellent Aptitude for dimensional data modeling, designing Star/Snowflake Schemas
• Hands on experience in performance tuning of various decision support systems using OBIEE query log, query optimization, performance tuning measures formula enhancement and aggregate table creation.
• Experience in Integrating Essbase Cubes into OBIEE Administrative tool for reports development
• Experienced in Installation, Configuration, and Administration of Informatica Power Center/Power Mart on Client/Server environment.
• Hands on experience in automated change management capture using OBIEE/Siebel DAC and Upsert transformations
• Understanding working knowledge of Informatica Designer Tools Warehouse Designer, Mapping Designer, Source Analyzer, Transformation Developer, Mapplet Designer and Transformation components Source Qualifier, Expression, Aggregator, Filter, Router, Sorter, Update Strategy, Lookup, Joiner and Sequence Generator .
• Extensive work with PL/SQL, performance tuning of Oracle using SQL trace, SQL plan, SQL hints, Oracle partitioning, various indexes and join types
• Ability to prioritize and execute tasks in a high pressure environment while handling multiple projects at same time.
• Excellent communication and documentation skills in preparing project related documents Project charter, BRD's, Risk Analysis and lessons learnt
• Experience in direct Client Interaction, conducting project stack holders meetings, resolving the issues in innovative approach and working in Result oriented manner.

Technical Skills

Professional Experience:

Confidential

Sr. OBIEE Developer /Lead OBIEE Developer

Detail Responsibilities:

• Extensive experience in working with both Oracle BI 10g environment and 11g environment, as well as upgrade process involved in migrating from OBIEE 10g to 11g
• Understanding and translating the business requirement to technical requirements for Enterprise Portfolio Reporting and Event Reporting Dashboard Projects in OBIEE 11g.
• Studied the existing reports on the SSRS platform, to satisfy business requirement on the new Oracle BI Platform OBIEE for Enterprise Portfolio Reporting Dashboard implementation.
• Translated Enhancement requirements into Technical requirments for the Manager Center Dashboard, and CoMIT Reporting
• Prepared the HLD High Level Design and LLD Low Level Design documents for the implementation of above projects
• Conducted data modeling review sessions for different user groups, participated in requirement sessions to identify requirement feasibility.
• Provided POC's to the end user, to provide an overview the OBIEE tool and its capabilities and how their requirements can be satisfied
• Actively participated in design and analysis sessions to ensure sound team decision-making
• Created and maintained OBIEE Repository .rpd for all the projects worked upon. Used available feature Dimensional Hierarchies, and Aggregate Navigation, Level Based Measures, Variables, and Initialization blocks extensively to implement business requirements, without compromising on the Best Practices recommended by Oracle.
• Developed RPD and provided secure access to users to develop their own Ad-Hoc Analysis
• Designed and developed Business Intelligence reports and dashboards, Enabled Agents in to deliver these reports directly to the users.
• Extensive experience in using Pivot Views, Tabular Views, Union Reports, Action Links, HTML Embedded Content, HTML Hyperlinks and various Graphical views to satisfy users requirement.
• Extensively worked on BI Publisher, created data models using OBI answers reports/generic sql, used them to create picture perfect report to be provided for the high level executives.
• Configured and Scheduled BI Publisher scheduler for report bursting through FTP/email
• Integrated Essbase cubes with the OBIEE application and developed reports based on these cubes
• Knowledge in developing Essbase cubes using Hyperion Essbase Tool.
• Experience in creating the reports using the different views such as Pivot, Tabular, Narrative etc as well as creating dashboards for the same using prompts, guided navigation as per the project needs
• Extensively maintained user's security access for different environments, which involved assigning specific groups/roles to the users based on the business requirements for different instances of the OBIEE platform as well as configuring the permissions for these groups/roles in the OBIEE environment.
• Implemented implicit and the explicit manager security both at the report/dashboard as well as Data level for the Manager Center Dashboard.
• Used 3-way merge on the rpd, to migrate the changes through different environments for different projects on a shared instance.
• Responsible for migrating Catalog, RPD and Security parameters through different DEV, UAT and PROD environments
• Heavily involved in using Informatica power Center 8.6 to extract and load data from source systems Flat Files to corresponding SOR layer for Event Management Dashboard.
• Used PL/SQL to develop OBIEE Security Tables data warehouse.
• Developed PL/SQL procedures for complex business logics, to be used in OBIEE RPD using Evaluate function
• Developed performance tuning strategies with business model-level calculations versus Data warehouse level pre-computations aggregations, aggregate navigation, cache management, Oracle materialized views.
• 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.
• Worked in On-Shore/Off-Shore Work environment, with experience in leading a team of three.

Environment:

OBIEE 11.1.1.6.2 BP1/OBIEE 11.1.1.6.7/ OBIEE 11.1.1.7.1, BI Publisher, Pl/Sql, Oracle 11g/10g, Hyperion Essbase 11.1.2.2, TOAD, .Net

Confidential

Sr. OBIEE Developer

Detail Responsibilities:

• Understanding the Business requirements and developing technical needs by comparing the requirements with the existing OTB repots.
• Heavily involved in using Informatica power Center 8.6 to study the existing out of box transformations and replicated them either in PL/SQL based Data warehouse or in the OBIEE RPD.
• Created OBIEE Repository .rpd which involves Schema Import, Implementing the business logic by customization, Dimensional Hierarchies, and Aggregate Navigation, Level Based Measures, Variables, and Initialization blocks.
• Configured Physical Layer to Import tables, Create Tables, add/change physical joins/keys from databases Oracle 10g and optimize connection pools
• Configured Logical Layer Create Logical tables/dimensions, columns, Create Logical Joins/keys, Set levels to support Drill-down, Aggregation / Sum over Columns. For the custom schemas designed to satisfy the reporting requirements
• Configured Presentation Layer Create Folders/sub-folders, Standard Queries for different User Groups to satisfy Ad-Hoc reporting requirements
• Designed and developed Business Intelligence reports and dashboards using Oracle Enterprise Edition BI Answers, BI Interactive dashboards and maintained the Analytics web catalog to manage Dashboards, Answers and Delivers
• Deployed Map Viewer and Integrated Map builder with OBIEE by creating the Spatial Data in database and Created different Maps using Different Themes, Colors and Markers
• Created Data source and Map Meta data Cache in Map viewer console.
• Implemented LDAP server authentication to validate the end user.
• Used 3-way merge on the rpd, to migrate the changes through different environments for different Subject Areas on a shared instance.
• Responsible for setting up Data Level, Row Level and Cell Level Security in OBIEE RPD
• Performed Unit Testing for the Code developed before Moving it in to UAT User Access Testing environment
• Extensively used MUDE to develop the RPD simultaneously between different Subject Areas
• Created an Autosys Job for a Unix script created to perform OBIEE RPD deployments on the server
• Worked extensively on various Cache Management techniques to increase the performance of the both Real-Time and Non Real-Time reports.

Environment:

Oracle BI Apps 7.9.6/7.9.5 HR Analytics , OBIEE 10.1.3.4.1/10.1.3.4, Informatica Power Center 8.6/8.1, Autosys

Confidential

ETL/OBIEE Consultant

Detail Responsibilities:

• Involved in importing new tables/columns into the OBIEE Repository .rpd
• Designed and developed Business Intelligence reports and dashboards using Oracle Enterprise Edition BI Answers and BI Interactive dashboards.
• Extensively worked on global filters for use in exercising dashboard wide control over requests that are embedded into a dashboard page.
• Created complex reports by using Set operations and direct database request.
• Implemented Dynamic Dashboard Prompts to zoom into different segments of the customers and Brokers, to achieve performance optimization and easy navigation of reports.
• Developed reports using different Analytics Views Pivot Table, Chart, and Column Selector , Interactive Dashboards with drill-down capabilities, Unions, charts, tabular using Dashboard and Page Prompts.
• Managed the Web Catalog WebCat to archive dashboards and user securities.
• Involved in the Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Created various folders, users and assigned permissions to them accordingly in Repository Manager.
• Updated administered the security privileges for the user profiles in Repository Manager
• Created various mappings like Update Strategy, Look up, Sequence Generator, expression, Aggregator, XML, Stored Procedure and tested the mappings for data verification in Designer
• Extensively used Informatica Power Center to create data maps for extracting the data from Relational and DB2 and loading into Oracle Staging tables initially.
• Created workflows and tasks in Workflow Manager and linked the database through server setup and various other connections.
• Involved in monitoring Informatica jobs/processes using Workflow Monitor
• Analyzed the session logs, bad files and error tables for troubleshooting mappings and sessions
• Implemented slowly changing dimension methodology and slowly growing targets methodology for modifying and updating account information and accessing them
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.
• Designing mapping templates to specify high level approach.

Environment:

Oracle BI Apps 7.9.6/7.9.5 Financials AR, OM , Procurement Spend Analytics , OBIEE 10.1.3.4.1/10.1.3.4, Informatica Power Center 8.6/8.1, Erwin, Oracle 11g/10g, DAC, Oracle EBS, Windows XP

Confidential

ETL/OBIEE Consultant

Detail Responsibilities:

• Designed and developed Business Intelligence reports and dashboards using Oracle Enterprise Edition BI Answers and BI Interactive dashboards.
• Extensively worked on global filters for use in exercising dashboard wide control over requests that are embedded into a dashboard page.
• Created complex reports by using Set operations and direct database request.
• Worked extensively on security for users and groups based on the individual and group responsibilities.
• Developed many Reports using different Analytics Views Pivot Table, Chart, and Column Selector , Interactive Dashboards with drill-down capabilities, charts, tabular using Dashboard and Page Prompts.
• Maintained effectiveness in creating the dashboards by appropriately including guided navigational links and drill downs. Setup the visibility of dashboards to employees with respect to their responsibilities.
• Providing object level security for different web groups based on responsibilities.
• Managed the Web Catalog to archive dashboards and user securities.
• Developed performance tuning strategies with business model-level calculations versus Data warehouse level pre-computations aggregations, aggregate navigation, cache management, Oracle materialized views.
• Configured Event polling for clearing the stale cache.
• Used Analytics Scheduler to configure Delivers and iBots to notify the corporate managers and region managers immediately about the messages.
• Generated iBot alerts for reports to be delivered by e-mail.
• Extensively used ETL to load data using Informatica Power Center 8.6.
• Developed many delta / incremental complex Informatica ETL process and Oracle Packages i.e., Mappings Mapplets using various Transformations.
• Redesign Informatica ETL DAC mappings based on new requirements.

Environment:

OBIEE 10.1.3.4.1/10.1.3.4, Siebel Analytics 7.5, Informatica Power Center 8.6/8.1, Erwin, Oracle 11g/10g, DAC

Confidential

Database Analyst

Detail Responsibilities:

• Monitoring use of the system, troubleshooting problems, conducting
• Developed PL/SQL stored procedures, user defined functions for complex rating calculations and bundle them into stored package that could be invoked from the Forms triggers
• Developed various UNIX Shell Scripts to automate the routine tasks
• Designed interface for the system.
• Created PL/SQL scripts for data transformation in line with program specifications.
• Creating temporary tables and indexes for loading and updating data.
• Designed and Developed Stored Procedures, Packages Functions using PL/SQL and SQL Scripts.
• Used SQL Loader to load data using direct and indirect path.
• Developed database Procedures to handle Partition Deletion and Truncation automatically based on data loading criteria using Dynamic SQL.
• Developed shell scripts for database replication processes.
• Table layout design, table space management and user maintenance.

Environment:

Pl/Sql, Oracle 11g/10g, UNIX, TOAD