Summary:

• Over Eight years of IT experience in complete Software Development Life cycle SDLC implementation experience of Data ware House and Business Intelligence applications using Oracle Applications, OBIEE , Informatica and DAC.
• Working Experience with Financial, Insurance, Tele Communications and Manufacturing Industries.
• Expertise in developing Oracle BI Siebel Analytics Repository .rpd at three layers Physical, Business Model Presentation Layer , Time Series Objects, Interactive Dashboards with drill-down capabilities using global local Filters, Security Setup groups, access / query privileges , LDAP, External Tables, configuring Analytics Metadataobjects Subject Area, Table, Column , Web Catalog Objects Dashboard, Pages, Folders, Reports and scheduling iBots.
• Expertise in Business Model development with Dimensions, Hierarchies, Level Based Measures, Aggregation Rules, Time Series, and Caching.
• Extensively worked on Performance Tuning the OBIEE.
• Experience in Dimensional Data Modeling using Star Schema, Snow-Flake Schema.
• Worked on Siebel Analytics Web services and extracted results from Siebel Analytics and delivered them to external applications.
• Extensive experience in building Interactive Dashboards with drill-down drill-through capabilities using global local Filters, Contextual Navigation, Guided Analytics, Business Rules with User Identity Roles, Profiles Personalization.
• Strong understanding of Business Logic, Business Process flows, identification of Business opportunities.
• Experience in OBIEE/BI Apps OBIA with Sales Analytics, Financial Analytics, Supply Chain Analytics, Procure and Spend Analytics and HR Analytics.
• Experience in Configuration and setting up OBI Apps.
• Worked on Informatica that provides critical integration between ERP, CRM, Metadata and Remote Data and deliver it to Data Warehouses, Operational Data Stores and Business Intelligence tools.
• Extensive knowledge in Oracle database development using PL/SQL, Stored Procedures, Triggers, Functions and Packages.
• Extensive experience in designing developing Answers, Delivers, iBots Dashboards.
• Expertise in Essbase cube analysis, design and maintenance, Essbase database administration upgrades.
• Efficient in troubleshooting, performance tuning and optimization of ETL and reporting analysis.
• Extensive Experience in Data Warehousing development using ETL tools such as Informatica 8.x/7.x/ 6.x.
• Very strong in developing Informatica Mappings / Mapplets using various Transformations Filter, Expressions, Router, Aggregative, Lookup, Router, Update Strategy for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Strong experience in Data Warehouse Administration Console DAC 7.9.6, 7.9.5 .
• Configured and registered the custom workflows in DAC.
• Experience in developing BI Publisher Reports in 10G/11G.
• Well versed with using SQL and PL/SQL for BI Publisher and XML Publisher.
• Experience in troubleshooting complex SQL Queries and improve the data delivery performance.
• Experience in writing complex queries and packages.

Technical Proficiencies:

• Oracle Applications:OBIEE 11g/10g, Siebel Analytics 7.8.x/7.7.x/7.5.x,Hyperion Essbase 9.x/7.x/6.x, OBIEE Publisher 10.1.3.4/11.1.1.5
• ETL Tools: Informatica Power Center 8.1.1/7.1.2/6.2/6.1/5.1, Power Mart 5.0/4.7.
• Tools: Toad 4.0.3, Erwin 4.1.4/3.5.2, MS-Access, MS-Visio.
• Methodologies: Ralph Kimball's Star Schema and Snowflake Schema.
• RDBMS: MS-SQL Server 2005/2000/7.0/6.5, Oracle 10g9i/8i/7.3.
• Languages: PL/SQL, SQL, C, C , Java 1.2, XML.
• Operating Systems: Windows XP/2000/NT/98/95, UNIX, MSDOS.

Professional Work Experience:

Confidential

OBIEE Developer

Responsibilities:

Developed Physical Layer, Business Model Mapping and Presentation Layer using Oracle BI Administration Tool in OBIEE 11g/10g.

• Developed manystandard Reports/ Dashboards with different Analytics Views Drill-Down, Pivot Table, Chart, Column Selector, and Tabular with dashboard and page prompts using Siebel Analytics Web.
• Upgraded from OBIEE 10g to 11g
• Defined Connection Pools to the Source Data warehouse tables in the Physical Layer.
• Created Repository Groups and Web Groups and assigned users to configure security in OBIEE 11.1.1.6.
• Setup Multi User Development Environment MUDE in OBIEE.
• Utilized session variables, repository variables and initialization blocks in the repository building and modification procedures in OBIEE.
• Worked on Dashboard and Page level prompts and Report filters.
• Implementation and configuration of Oracle Financial Analytics, Oracle HR Analytics, with OBIEE, BI Apps, Informatica, and Data warehouse application console DAC .
• Developed reports for GL, AR, AP modules Oracle Financial Analytics
• Managed Security settings in OBIEE Administration Tool.
• Extensively used Repository Variables, Session Variables and Initialization Blocks for Configuring the Data and User Security.
• Developed new dimensions, facts and aggregate tables.
• Worked on BMM to create logical tables and defined the complex joins.
• Created dimensional hierarchies in BMM layer.
• Developed calculated measures and assigned aggregation levels based on dimension hierarchies.
• Worked on the Time Series Calculation and implemented time comparison.
• Used Action Framework to see the linking of invoice details to Invoice number.
• Worked extensively with OBIEE Administration tool, Presentation services and BI Publisher.
• Created session variables for users to provide row- level data level security and used the session variable in OBIEE Answers to build the query.
• Created Aggregate Level facts to improve the performance in the reporting needs.
• Worked with Cache persistence Wizard to efficiently handle cache
• Developed Master Detail Report in OBIEE.
• Worked with properties such as changing the ownership of a folder or viewing the creation date of an object.
• Used the Totals/Subtotals/Group/Sort features of BI Publisher to make data intense operations happen at the template level.
• Designed Intelligence Dashboards and created Global Filters like Year, Quarter, Month, Product, and Distributor.
• Generated interactive and selective data reports pivots, charts, tabular using concepts such as filters, column selectors, global prompts and extensively used repository and presentation variables.
• Generated Drilldown Reports, Charts, Summary Reports, Navigational Reports.
• Created customized dashboard prompts as per the business requirement.
• Migrated web catalog and RPD from DEV and PROD environments.
• Created iBots and Delivers to send Alert messages to subscribed users especially during Month end Reconciliation.
• Worked on Informatica power center 8.6/7.1.4 client tool.
• Responsible for Unit and System Testing and performed Data Validation for all the reports. Developed SQL queries and PL/ SQL packages from scratch to use as BI Publisher Event Trigger.
• Worked extensively on Oracle BI Publisher and provided the capability to download the high-fidelity reports in the user defined formats PDF, CSV, HTML, EXCEL and XML DATA .
• Coordinated the RPD and Web Catalog objects migration from Development environment to QA environment and then to the Production environment using OBIEE Catalog Manager.
• Involved in setting up of the DAC which has the backup of your DAC client and Server and DAC metadata files.

Environment: OBIEE 11.1.1.6, Informatica power center 8.6,Oracle BI Apps Financial Analytics HR Analytics , PL/SQL, BI Publisher 10.1.3.4.1/11.1.1.5.0, DAC, TOAD, Oracle 11g/10g.

Confidential

Oracle BI Consultant

Responsibilities:

• Interacted with functional and technical leads, SME's, marketing, finance, and other business groups to identify, analyze, and document business requirements.
• Responsible for setting up the environment including installation of OBIEE, BI Apps and Informatica in all the environments.
• Created transformations like Expression builder, joiner, and router.
• Implemented OBIEE solution for 'Sales' subject area using various components of OBIEE Suite like Administration Tool, BI Answers, Interactive Dashboards, iBots/Delivers.
• Tuned the performance of the reports by creating various types of indexes wherever appropriate.
• Configured MUD for OBIEE Tool.
• Development of RPD using Physical, BMM and Presentation layers of BI Administration Tool.
• Imported physical tables and defined relations between Physical tables at the Physical Layer.
• Utilized features like narrative views, dashboard prompts to create interactive dashboards.
• Configured BI Scheduler and created simple, conditional and chained iBots to create alerts and deliver them using Oracle Delivers.
• Customized reports from BI Apps OOB-prebuilt seeded reports.
• 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.
• Used BI Apps prebuilt Informatica mappings for development
• Experience in working with PL/SQL while creating views in physical layer
• Installation and Configuration of DAC Data warehouse Application Console for multi OLTP regional instance environment.
• Built multiple execution plans in DAC for weekly and daily loads.
• Used DAC client to load the custom mapping to the warehouse.
• Involved in troubleshooting of Informatica Mappings and Workflows.
• Compared data from Hyperion Essbase with the OBI for data validation.
• Implemented BI Security using External Table for Authentication and Authorization.
• Developed/Updated Informatica Mappings and Workflows for ETL processes per reporting requirements.

Environment: OBIEE 10.1.3.4, Oracle 10g, Informatica Power Center 8.6, Oracle BI Publisher, Supply chain analytics, Procurement Analytics,PL/SQL, DAC, BI Apps 7.9x.

Confidential

OBIEE Developer

Responsibilities:

• Interacted with the client, at all levels, in order to discuss and decide on the requirements of the client.
• Created and implemented strong security in the database at all levels, that allowed only authorized user s to see their own sections.
• Responsible for setting up the environment including installation of OBIEE, BI Apps and Informatica in all the environments.
• Worked on Oracle Financial Application module such as AP, AR and GL.
• Created and Administered the Physical Layer, Business Model and Mapping Layer and Presentation Layer in Analytics Repository .rpd using Oracle BI Administration Tool.
• Designed and developed many Dashboards/Reports that are Dynamic Interactive with intuitive drilldowns, drill-across flash-based drillable charts bar-charts, pie-charts, radars, and bubble-charts , and local global filters and cache monitor using Siebel Analytical Web.
• Configured IBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Configured DAC for Financial Analytics and extracted data through Informatica.
• Setup Multi User Development Environment MUDE in OBIEE.
• Designed and developed General Ledger, Payables, Receivables and Profitability Dashboards in OBIEE.
• Working closely with the data modeler in creating logical data model Star Schema .
• Configured Intelligence dashboards by adding included and embedded content such as links/images, HTML objects and folders.
• Imported data from different data sources like Oracle and SQL server into Siebel Analytics Repository
• Involved in ETL Development using Informatica.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.
• Designed and developed transformations, mappings and sessions in Informatica to load target database.
• Configured DAC Data Warehouse Administration Console for Creating Execution plans, metadata management and monitoring the Informatica ETL Process.
• Built multiple execution plans in DAC for weekly and daily loads.
• Installed BI Publisher, Publisher Desktop, integrated with OBIEE to develop template. Used MS OFFICE Add-ons in reports, Dashboards and answers
• Developed different kinds of reports pivots, tabular, charts/graphs using local and global filters.
• Implemented column selector to select different column values

Environment: OBIEE 10.1.3.2, General Ledger GL , Account Payables AP , Accounts Receivable AR , OBIEE Publisher 10.1.3.2, EBS, OBI Applications, Informatica 7.1.2, Oracle 10g, SQL, Toad, UNIX.

Confidential

Siebel Analytics Consultant

Responsibilities:

• Involved in Project meetings and application status calls with clients, handling technical issues.
• Gather Business requirements from the Business Analyst. Give feedback and clear doubts with BA.
• Prepare Technical Specifications or give download to the Developer to prepare the Technical Doc.
• Give review comments and sign off on Technical Specs.
• Review Code for Coding standards and from Performance, reusability, modularity, etc.
• Do Tuning of the code such as SQL queries and PLSQL code.
• Review/Create/Modify the Reports RDF or Forms in Oracle 10g depending on the work load.
• Migrate the code in different environments DEV, TESTand PROD .
• Experience in Migration and Upgrade Oracle Database.
• Involved in creating 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 worked on Answers, Dashboards and Security for users and creating complex reports.
• Worked on Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
• Designed Interactive Dashboards and created dashboard prompts with multiple selections.
• Worked on creating DAC tables, task definitions, Subject areas and indexes for tables and worked on change capture mechanism during incremental load for tables which were not part of OOB.
• Extensively worked with Financial Reports.
• Expertise in deploying reports on Reports Server and troubleshooting Reports Server.
• Experience in Report Security issues.
• Created the source and target instances and various transformations Joiner, Aggregate, Lookup, Filters and Router Transformations in informatica and also created mappings, sessions and workflow to run ETL process using Informatica Power Center
• Created reports of using BI Publisher through OBIEE.
• Proven skills in SQL tuning and enhancing application performances.
• Proficient in server side programming like Procedures, Functions, Database Triggers Packages using PL/SQL and SQL.
• Worked extensively with SQL Loader using control files for data ware housing and data loading into oracle database tables.
• Proficient in Tuning SQL using Explain plan, SQL Trace and Auto Trace utility
• Worked extensively on various Cache Management techniques to increase the performance of the both Real-Time and Non Real-Time reports.

Environment: Siebel Analytics 7.8.4, Informatica Power Center 6.x/7.x, Toad, BI Publisher, Oracle 10g, PL/SQL , DAC

Confidential

PL/SQL Developer

Responsibilities:

• Setup the screens, reports and forms in different modules
• Trouble shooting for the end users requirement and Optimizing database
• Coordinating and scheduling changes to database based on requirements.
• Prepared system architecture diagrams, data flow diagrams and user interface details for entire application.
• Designed database tables and procedures, Triggers, Functions using PL/SQL.
• Performed tuning of SQL queries and reduced the processing time of batch jobs.
• Administration of Oracle networking like Names Server, TNSNAMES and Listener configuration and client configuration.
• Taking backups and restoring table spaces and database.
• Network Configuration and implementation of the Application Package in Client Place
• Created ftp connections, database connections for the sources and targets.
• Maintained security and data integrity of the database.
• Wrote database PL/SQL triggers and procedures to provide backend security and data consistency.
• Created UNIX shell scripts for FTP batch jobs, creating SQL reports.

Environment:MS Office, SQL Loader, SQL server 2000/2005, Windows 2000, Oracle 10g, PL/SQL, TOAD, UNIX shell scripiting.