Overview:

• Responsible and highly motivated professional with 8 years of Data warehousing, ETL experience and Over 7 years of experience in BI tools OBIEE/ Siebel Analytics/ Hyperion Essbase .
• Expertise in complete SDLC of Analysis, Design, Development, Maintenance and Documentation of various functionalities of Data Warehouses and Data Marts.
• Experience in designing and developing Banking, Financial, Insurance and Pharma Health care.
• Expertise in designing and developing the OBIEE/Siebel Analytics Metadata Repository .rpd using OBIEE/Siebel Analytics Server Admin tool.
• Good Knowledge in Developing OBIEE Reports using 10G/11G.
• Expertise in creating, modifying and administering OBIEE/Siebel Analytics Intelligence Dashboards using OBIEE/Siebel Answers, creating iBots using OBIEE/Siebel Delivers.
• Expertise in configuring Interactive Dashboards with drill-down capabilities using global and local Filters. Expertise in Implementing Object level as well as Data level Security.
• Expertise in Performance tuning of OBIEE/Siebel Analytics by implementing Cache management and Aggregate Navigation techniques. Implementing Database tuning as well.
• Experienced in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Fact andDimensions tables and Physical and Logical data modeling in the OBI Administration tool.
• Extensive Experience in developing BI Publisher Reports in 10G/11G.
• Extensive experience in customizing .RPD and Web catalog of OOTB Implementation of various OBI Applications like Financial Analytics.
• Expertise in debugging and optimizing the OBIEE/Siebel Analytics Dashboards / Reports and Informatica Mappings / Workflows.
• Well versed with using SQL and PL/SQL for BI Publisher and XML Publisher.
• Expertise in Oracle BI Answers, BI Interactive Dashboards and Oracle BI Server and Oracle BI Publisher, Implemented Best Practices in BI Publisher/XML Publisher.
• Experience in OBIEE/BI Apps OBIA with Sales Analytics, Financial Analytics, Supply Chain Analytics, Procure and Spend Analytics and HR Analytics.
• Extensive experience in installing and setting up OBI Apps, Configuring DAC and Informatica servers.
• Experience in troubleshooting Complex SQL queries and improve data delivery performance
• Extensively used Informatica Power Center 8.1/7.x/6.2.2 for Extract, Transform and Loading of data from multiple data sources to Data Warehouse and creating various mappings, sessions and Workflows.
• Working knowledge on different data sources ranging from flat files, Teradata, Oracle, SQL Server, DB2 databases and Sybase.
• Expertise in Essbase cube analysis, design and maintenance, Essbase database administration upgrades, performance tuning and optimization on Windows environment.
• Worked extensively on different Informatica transformations like Source Qualifier, Expression, Filter, Aggregator, Lookup Strategy, Update Strategy, Sequence generator, joiner transformations, Router etc.
• Expertise in implementing complex business rules by creating re-usable transformations, robust Mappings/Mapplets, Sessions and Workflows and Worklets.
• Good experience with configuring Data Warehouse Administration Console DAC for creating execution plans, metadata management and monitoring the Informatica ETL Process.
• Configured and registered the custom workflows in DAC.
• Excellent communication skills, ability to meet tight deadlines and prioritize tasks.
• Experience on Production support.
• Expertise in writing complex queries and packages.

Technical Proficiencies:

OLAP/BI Tools: OBIEE 11g/10g, Siebel Analytics 7.8.x/7.7.x/7.5.x, Essbase 9.x/7.x/6.x,

OBIEE Publisher 10.1.3.4/11.1.1.5, Hyperion 9.3.1/11.1.3.

ETL Tools: Informatica Power Center 9.1/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.
• Developed many standard Reports/ Dashboards with different Analytics Views Drill-Down, Pivot Table, Chart, Column Selector, and Tabular with dashboard and page prompts using Siebel Analytics Web.
• 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.2.
• 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.
• Upgraded the software OBIEE10 g to OBIEE 11 g
• Collected the artifacts and connection details for the objects to be upgraded from 10g to 11g as below
• o The RPD file, together with an Administrator password
• o The Web Catalog, as a directory
• o The Deliveries directory
• o The BI Publisher repository directory
• o Connection details for the following schemas
• o The BI Scheduler Delivers schema S NQ SCHED
• o The BIP Scheduler schema
• o Any customizations, CSS files, Javascript files etc
• o Transfer to a temporary directory on the BI 11g server
• Created the BIPLATFORM schema
• Contained tables previously held in separate schemas in OBIEE 10g
• o Scheduler
• o Usage Tracking
• o SA SYSTEM
• Created other supporting schemas required by FMW11g
• The upgrade assistant used is Standard Oracle Fusion Middleware lifecycle application
• Orchestrates upgrade from Oracle BI EE 10.1.3.2
• Migrated below details
• o RPD including RPD Users and Groups to WLS LDAP
• o Presentation Services Webcatalog
• o Scheduler Schema Delivers
• o BI Publisher Repository
• o BI Publisher Schema
• o 10g Security model to 11g
• Generated log files
• Not migrated: Configuration files,Custom style sheets, JavaScript
• Deployed to Oracle, SQL Server, DB/2
• Worked on Dashboard and Page level prompts and Report filters.
• 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.
• Involved in Design and Data Modeling using Star schema.
• Migrated web catalog and RPD from DEV and PROD environments.
• 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.

Environment: OBIEE 11.1.1.6.2, PL/SQL, TOAD, Oracle 11g, SQL Developer

Confidential

OBIA Developer

Responsibilities:

• Worked on OBIEE/BI Apps OBIA with Case Management.
• Coordinated in the client installations and integration of OBIEE 11.1.1.6.1, DAC and Informatica 9.1.
• Created Logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data, and Repository Variables.
• Developed different Requests, Filters, Views, Charts, Interactive Dashboards with page using OBIEEE Answers and dashboard Prompts.
• Implemented security tasks like creating user groups, users and managing users by setting up their privileges and profiles.
• Configured interactive Dashboards with drill-down, drill across capabilities using Filters and Dashboard Prompts, Siebel Security Setup groups, access privileges , Metadata Objects and Web Catalog Objects Dashboard, Pages, Folders, Reports and guided navigation links.
• Worked with different stages of handling data viz. requirement gathering, identifying data sources/targets, data modeling, data cleansing, data loading, and building Star schema.
• Develop fine tuning reports by using view selector, column selector, drill down- drill through analysis, creating master/detail reports, using database, numeric, date and time functions, etc, where ever necessary to increase performance.
• Worked on Design, Development, Implementation, Testing and Maintenance of Oracle Databases, ETL Processes and Database Deliverables.
• Worked on implementing Security at object level and data level using Repository Variables, Initialization Blocks, and Session Variables.
• Created, Enhanced and troubleshoot reports on BI Publisher.
• Worked with Data warehouse Administration Console DAC to schedule and run full and Incremental ETL loads, to schedule the Informatica jobs, and to customize Execution Plans.
• Developed Informatica Mappings/Mapplets using various Transformations Filter, Expressions, Router, Aggregative, Lookups, Update Strategy and also in creating Workflows.
• Worked on writing complex SQL queries, creating different PL/SQL Objects, Fine Tuning the code, and also in using SQL Loader for loading data into Data Warehouse/Data Mart.
• Tuned Performance for the reports by implementing aggregate navigation and cache management.
• Used Informatica Power Center tools for analysis, design, mapping and workflow.
• Develop mappings in Informatica according to functional/application areas to load the data from source
• to target tables.
• Develop various transformations like Source Qualifier, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading the data into target table.
• Created Workflows, Tasks, and database connections using Workflow Manager.
• Develop Mappings and Workflows to generate staging files.
• Develop Mappings and Workflows to load the data into Oracle tables.
• Developed complex Informatica mappings and tuned them for better performance.

Environment: OBIEE 11.1.1.6.1, Oracle BI Apps 7.9.6.3 Case Management , BI Publisher 10.1.3.4.1/

11.1.1.5.0, Informatica Power Center 9.1, Oracle 11g/10g, DAC, TOAD, SQL, Windows XP

Confidential

OBIA Consultant

Responsibilities:

• Experience in configuring Security Settings groups, roles, access/query/report privileges and scheduling iBots/Agents for OBIEE 11g..
• Trained in BI Publisher Standalone 11g as well as Integrated with OBIEE 11g, to answer business questions.
• Successfully installed and configured OBIEE 11g version 11.1.1.6.1.
• Developed BI Consumer reports using OBIEE 11g.
• Added users and configured security in web logic console of OBIEE 11g.
• Define data and technical architectures and technical requirements for the data warehouse.
• Choose or suggest data warehouse technologies such as Data Quality, ETL, BI and DBMS.
• Used Informatica Workflow manager and Workflow Monitor to schedule and monitor session status.
• Developed PL/SQL procedures and functions and used the same in mappings, pre and post sessions.
• Created Dimension hierarchy in Business model layer.
• Created measure with Logical Columns and Physical Columns.
• Created logical Tables and logical columns, Physical Columns.
• Created measures and level Based measures in Business Model.
• Developed many reports/dashboards Analytic views Pivot Tables, Charts, Column Selector, and View Selector .
• Customized and developed RPD Physical, Business model and Presentation Layer , configured metadata objects and Web Catalog Objects.
• Identified Facts and Dimensions levels/ Hierarchies of Dimensional model.
• Analyzed and used various data sources- Oracle and Excel and Web services.
• Interacted with Procurement and Operation/Maintenance business representatives for gathering the OBIEE Reports/ Dashboards requirements and to define business and functional specifications.
• Experience with weblogic server and Enterprise manager in OBIEE 11g.
• Re-developing all current Oracle Discoverer Finance and Publishing reports in OBIEE 11g.
• Extensively worked on developing Data model based on STAR schema concept using OBIEE 11g Administration Tool for current and future reporting requirement.
• Migrated current OBIEE 10g repository and web catalog to OBIEE 11g.
• Installed, maintained Production, development, test databases using oracle 8i-9i-10g-11g .
• Implementation and maintenance experience of oracle 10g and 11gR2 11.2.0.1 database and physical standby database, data guard DR before moving to production for reporting application.
• Developed the Incremental ETL Processes like Mappings Mapplets using various Transformations. And workflows with Sessions/Tasks. Executed the workflows with Shell Scripts.
• Responsible for analyzing, designing and developing ETL strategies and processes, writing ETL specifications for developer, ETL and Informatica development, administration and mentoring.
• Develop ETL programs mappings, sessions, workflows via Informatica 9.1.4.
• Saved Resources from a claims tracking process by modeling a Claims data mart to contain aggregated claims. Rolled up claims by coding SQL stored procedures, Informatica ETL and UNIX scripts.
• Implementation and configuration of Oracle Financial Analytics, Oracle HR Analytics, with OBIEE, BI Apps.

Environment: OBIEE 11.1.1.6.1, OBIA, Oracle BI Apps Oracle Financial Analytics, Oracle HR Analytics , Data Modeling ER Win , BI Publisher 10.1.3.4.1 /11.1.1.5.0, Informatica Power Center 9.1, Oracle 11g/10g, DAC, TOAD, SQL, Unix.

Confidential

OBIEE BI Consultant

Responsibilities:

• Interacted with Business Analysts and Users in gathering and analyzing and designing the Business Reports Requirements.
• Performed the gap analysis, Identified Facts and Dimensions with levels hierarchy and made required changes to the Data Marts.
• Involved in designing and developing subject areas in Repository .RPD catering to the OLAP reporting needs of Bank BI Project using OLAP Multi-Dimensional Essbase Cubes.
• Developed various Essbase cubes with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion.
• Developed MaxL scripts, data load rules DLR , Business rules, Calculation scripts and Report scripts for outline in Essbase cube.
• Implemented Complex Logging in SSIS Packages.
• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Created SSIS/DTS packages for Finance application that would transfer data among servers and perform other data transformations scheduled the same SSIS packages by creating the corresponding job tasks.
• Implemented the Time Series Wizard YTD, QTD, and MTD for comparing measures in different time Periods.
• Created Repository Static and Dynamic variables. Also created Initialization blocks for Session variables, which are used for authentication and security.
• Created Dimension Hierarchies in the BMM layer to drill down and drill across on various dimensions as per client requirement.
• Implemented OBIEE Security Object Level and Data Level Security in the OBIEE Repository and Answers using Repository Variables, Session Variables and Initialization Blocks.
• Created Security settings in OBIEE Admin Tool to setup groups, access privileges and query privileges. Implemented Object level as well as Date level security.
• Created Catalogs in Presentation layer used for both ad-hoc and Dashboard end users.
• Created OLAP requests in OBIEE/Siebel Answers and multi-level requests drill-downs and guided navigation .
• Created multiple reports reflecting region hierarchy based on roles VP, Director and Account executive.
• Worked on cache purging strategy using Event-polling table. Worked on IBots using OBIEE/Siebel Delivers for caching and delivering the reports to subscribed users.
• Documented the Functional and Technical design documents in MS word and latter converted the Technical design document in to the report Field Mapping Document.
• Performance tuning in OBIEE for star schemas by implementing aggregate navigation, cache management, Materialized Views and Database tuning.
• Used Informatica Power Center tools for analysis, design, mapping and workflow.
• A full cycle development of Supply Chain Analytics was implemented. Involved in indentifying, designing, configuring testing the application.
• Used DAC Data warehouse Administration Console for both incremental and full loads.
• Developed various transformations like Source Qualifier, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading the data into target table.
• Created Workflows, Tasks, database connections using Workflow Manager
• Worked with Element tool for logging and tracking and fixing bugs in QA Testing.
• Debugged and resolved data matching issues ranging from the base tables to BI dashboard reports.
• Loaded the data to fact and dimension tables from ODS to STG and STG to FCT and DIM.
• Develop Mappings and Workflows to generate staging files.
• Develop Mappings and Workflows to load the data into Oracle tables.
• Developed complex Informatica mappings and tuned them for better performance

Environment: OBIEE 10.1.3.4, BI Publisher XML Publisher , Financial analytics, HR analytics, Procurement, Supply Chain, DAC Data Warehouse Admin Console , Essbase 9.3.1, Informatica 8.1.1, Oracle 10g, windows XP.

Confidential

OBIEE Developer

Responsibilities:

• Coordinated in the client installations and integration of OBIEE 10.1.3.3, DAC and Informatica 7.1.2
• Interacted with business representatives for requirement analysis, and to define business and function/technical specifications.
• Customized OBIEE OOTB metadata repository for AR, AP and GL.
• Develop mappings in Informatica according to functional/application areas to load the data from source to
• target tables.
• Created the new columns in existing fact and dimension tables and creating all together the new dimension and fact tables.
• Imported the custom fact and dimension tables and configured it in the 3 layers of the RPD. Implemented Level Based Metrics in the BMM layer. Created Compound facts in the BMM as per the client requirement.
• Written RRD Report requirement document RDD Report development document TDD Technical design document .
• Designed Schema using custom fact, dimensions, physical, logical, Alias and extension tables
• Created Dimension Hierarchies in the business model and mapping Layer to drill down custom Store and product dimensions.
• Implemented conditional formatting using OBI Publisher.
• Customized the out of the box Informatica SDE and SIL mappings to include mappings for new columns created in the existing facts/Dimensions or created new SDE and SIL mappings for new facts/dimensions.
• Created Security settings in OBIEE Admin Tool to setup groups, access privileges and query privileges.
• Performance tuning in OBIEE for custom made star schemas by implementing aggregate navigation and cache management.
• Developed different reports using Siebel Dashboard and Answers like views charts, pivot and narrative, tabular used global and local filters.
• Created the Custom Dashboard for the custom reports and aligned the reports with in the dashboard according to client requirement.
• Tuned Performance for the reports by implementing aggregate navigation and cache management.
• Configured iBots and Delivers to send alerts to subscribed users.
• Ran the test scripts logged the bugs in element tool and fixed the bugs.

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.