• Over 8 years of experience on Data warehouse development, reporting using Siebel Analytics/Oracle BI OBIEE , Dimensional modeling across Banking, Retail, Financial, Pharmaceutical and HealthCare Industries.
• Extensive DW experience using Oracle Data Integrator, Configured and setup ODI, Master Repository, Work Repository, Projects, Models, Sources, Targets, Packages, Knowledge Modules, Interfaces, Scenarios, Filters, Condition, Metadata.
• Strong understanding of Data Warehouse concepts ETL, OLAP, Star Schema, Data Modeling using Normalization, Business Process Analysis, Dimensional Data Modeling, FACT Dimensions tables, Physical Logical Data Modeling , Aggregate persistence wizard.
• Experienced in configuring OBIEE Reports Dashboards, OBIEE Delivers, Narrative views, advance Reports.
• Working with Key performance indicators KPI like KPI watch lists, KPI Scorecards in OBIEE 11g.
• Modeling experience using Normalization, Fact and Dimensions Tables, Physical and Logical Data Modeling
• Extensive experience in OBIEE Answers, Dashboards, Delivers, iBots with OBIEE stand- alone/integrated implementation, Catalog Manager.
• Strong expertise in BI reporting, sourcing data from multiple data sources like EBS, Oracle R12/11g, SQL Server 2005 and several flat files.
• Proficient in using the time-series functions to support historical time comparison analysis and creating requests, adding filters, creating prompts, and creating pivot tables using OBI
• Specialized in developing stored procedures, functions, packages and database triggers using Oracle SQL and PL/SQL to improve query performance.
• Experienced in Data Modeling, identification of Facts and Dimensions, Creation of schemas Star , Hierarchies, Documentation of Report and Dashboard Layouts, End User Demo/Documentation for Business/Report Users.
• Experienced in configuring the security settings in OBIEE Administration Tool to set up Groups, Access Privileges and Query Privileges using LDAP and external database authentication.
• Strong experience on working hierarchies, complex and foreign key joins, initialization block, presentation/repository/session variables, aggregate tables, partitions and fragmentations.
• Implemented different Caching techniques to improve the performance of BI server.
• Extensive experience in developing Interactive Dashboards with drill-down capabilities, Security Implementation Creating groups, grant access privileges, data level and report level , Metadata and Web Catalog Objects pages, folders and reports and scheduling reports using BI Delivers.
• Experience in reviewing the existing OBIEE reports documentation, analogous reports design, reports building reports unit testing, delivery of reports package for production and verification of post deployment.
• Experience of working with technical architects and application designers in defining and maintaining metadata of the enterprise.
• Experience in prototype building and demonstrating to clients. Optimizing reporting and query performance and develop custom tables.
• Excellent communication, interpersonal, analytical skills and strong ability to perform in a team.
• Experience in ETL concepts/methodology for supporting data extraction, transformation and loading using Informatica Power Center.
• Expertise in extraction, transformation, and load ETL of data directly from different heterogeneous source systems like flat files, Excel, Oracle, and SQL Server. Implemented ETL process to load data into target tables.

Confidential

Role: Sr.OBIEE Developer

Responsibilities:

• Involved with OBIEE installation, configuration and administration.
• Exclusively worked on OBIEE Administration Tool Physical, Business Model Mapping, and Presentation Layers , Answers, Dashboards, Catalog Manager.
• Developed and tested RPD Physical, BMM and Presentation Layer , configured metadata objects and web catalog objects as per the client and reporting requirements using OBIEE Admin Tool and Web tool.
• Configured OBIEE iBots to deliver analytics content based upon schedule and used automated iBot queries to obtain daily and weekly reports.
• Experience in Dimensional Modeling such as star schema, snow flake schema, creating Facts, Dimensions and Measures.
• Monitor logs by setting log level and debugged reports issues by understanding the SQL queries behind them used TOAD to run these SQL queries
• Used repository variables to dynamically modify conversion values for logical column formulas.
• Implemented data level security depending on roles.
• Implemented security by creating roles web groups, checks with external tables and LDAP, and Object Level Security.
• Debugged modified some of the existing reports and dashboards, and fixed some of the issues related to performance, data quality etc., during production support.
• Created Various BI Publisher Reports on top of BI Answers and aligned them on various Dashboards as per the requirement.
• Performance tuning of dashboards/reports and made changes to database by implementing the materialized views, aggregate tables, etc.,
• Enhanced performance by creating aggregate tables, Indexes and managing cache.
• Tested and migrated code over Dev, QA and Production of Repository, Dashboard Reports and OWB mappings and workflows.
• Managed security privileges for each subject area and dashboards according to user requirements in OBIEE 11g.
• Added users and configured security in web logic console of OBIEE 11g.
• Design Customize OBIEE Answers Views charts Create save Filters Create Charts Tables Bins in OBIEE Answers.

Environment: OBIEE 11.1.1.7.1 Answers/Dashboard/Delivers , OBIEE 11g, Oracle 10gR3/11g, SQL, SQL Plus, Toad, Informatica, SQL, PL/SQL, SQL Developer,

Confidential

Role: OBIA/EBS Consultant

Responsibilities:

• Involved in developing Project Plan for the future scope of the Financial Analytics project which includes developing learning management and recruitment subject areas from flat files provided by third party vendors using Universal adapters.
• Identified Financial Analytics facts, dimensions star schema models of workforce profile subject area.
• Created dashboards for General Ledger, Payables, Receivables, Projects, Profitability, etc.,
• Scheduled deliveries to CFOs, Controllers, Accounting Managers, Finance Analysts, Department Heads, Payables and Receivables Managers, Payables Receivables Analysts, Project Managers and Project Accountants.
• Involved in planning and delivering GL, and Phase I Reporting module which includes defining calendar, defining security rules, account aliases , roll-up group, journal sources, journal categories and used ADI general ledger desktop integrator to integrate the GL module to the excel sheet, designing and developing FSG reports such as Balance Sheet, P L Accounts and other management reports.
• Interacted with end users and functional architects for mapping the legacy data to the Oracle tables.
• Defined Profile Class, Dunning letters, Collectors, Customers, Auto Accounting, Transaction Types, Transaction Sources, Payment methods, Receipt classes, Receipt sources, Payment Terms, Receivable Activities in Receivables.
• Planning and Managing Service life cycle that mainly includes 1 Creating Contracts 2 Approving Contracts 3 Extending and Renewing Contracts 4 Terminating Contracts
• Setting up multiple payment service based processing in Service contracts
• Defined Payment Options, Payment terms, Distribution Set, Payment Format, Internal Banks, Recurring Invoices, Prepayments, Expense Report Templates, Interest on Invoice report, Matching options, Adjustment of Prepayments in Payables.
• Configured the setup for raising Batch invoices and Batch payments.
• Configured the setup for multi-currency invoices and payments in Payables.
• Configured the setups for prepayments and adjustment to payment to suppliers.
• Configured the setups for prepayment to employees and defined employee expense report.
• Created custom responsibilities to which were attached specific menus, forms and reports for restricted user access.

Environment: OBIEE 10.1.3.3, OBIA 7.9.6.3, ORACLE EBS R12, Oracle 10g, SQL Developer, Informatica 8.6, PL/SQL, Linux

Confidential

Role: OBIEE Consultant

Responsibilities:

• Worked extensively with users in gathering information, analyzing the data and creating adhoc reports
• Interacted with Business Analyst and data Modelers to understand the required functionality for OBIEE reports.
• Built prototype reports from excel spreadsheets during the requirement-gathering phase to visualize the reports and clarify requirements.
• Have Very good Understanding of the business requirements and Transforming the requirements into subject areas
• Implemented Multi-user Development Environment MUDE to support authorized OBIEE developers in making changes to the Repository.
• Identify Facts and Dimensions and creating Dimensional Hierarchy, Logical columns, Aggregate columns, Level based Measures and Aggregate navigation in BMM layer.
• Created new measures as well as modifying the existing measures at RPD level.
• Implemented security in maintaining users, roles and groups using Oracle database External Table Authentication/Authorization Approach .
• Involved in creating Star schema as per the business requirements to store the business attributes and measures and configured the Logical Layer, Logical tables, dimensions and columns and created the logical joins required to support drill-down aggregation
• Configured the Intelligent Dashboards for different user groups to view data across regions with the facility of drill downs and Charts.
• Worked with the Security settings in Oracle Business Administration Tool to set up users, groups, access privileges.
• Configured the scheduler which runs the IBots and delivers the content
• Worked with Informatica Designer tool in developing mappings and Mapplets to extract and loading the data from flat files, oracle to Oracle.
• Developed the Incremental ETL Processes like Mappings using various Transformations and workflows with Sessions/Tasks.
• Used Informatica Power Center Designer for developing mappings, using transformations, which includes aggregation, Updating, lookup, and summation. Developed sessions using Server Manager and improved the performance details.
• Expertise in customizing Oracle BI Repository RPD , Analytics Dashboard
• Responsible for handing over release notes for deployment to SIT and UAT environments.
• Scheduled Informatica workflows in DAC and monitored the Incremental and Full loads.
• Handled Bug Fixing in SIT and UAT environments using Quality Center hp tool.
• Involved preparing HLD and LLD documents based on the reporting requirement document provided by Client.
• Created Business Model to support Adhoc Reports for User Access based on Requirements
• Enabled Object Level and Data Level Security for Users belonging to different regions.
• Co-ordinated with QA team and created Test Plans and Test Cases to test and validate the reporting system and its data

Environment: Oracle BI Platform 10.1.3.3.1, UNIX, Informatica 7.1, Oracle 9i, Toad, Quality center, Unix.

Confidential

Role: Developer

Responsibilities:

• Worked closely with Business user in Understanding the reporting needs from target user groups.
• Designed various reports in Answers and configured Intelligent Dashboards for different user groups to view data across regions and Customer Demographics with the facility of drill downs and Charts
• Developed Subject Area with Physical Layer Objects Database, Connection Pool, Catalog, Schema, Table , Business Layer Objects Logical Table, Dimensions, Joins, Aggregation Rules, Case Expressions for Unmapped Columns, Facts, Initialization Blocks, Repository Dynamic Variables , Presentation Layer Objects Table, Columns
• Involved in Dimension modeling, Identified business attributes and measures, defined dimensional model STAR Schema to store the business attributes and measures.
• Customized the out of the box DAC containers to configure the ETL to run in both full and incremental loads as per the staging and target requirements.
• Created and tasks and tasks groups and subject matters in DAC, for Informatica servers.
• Implemented Data Level security into Business Model that has both Position Based Security and Geo based security for different user groups.
• Developed Dashboards, Reports with Analytics Views like Pivot Table, Chart, Tabular and View Selector, Alerts, Guided Navigation with drill-down capabilities
• Designed Developed a star schema for Fact, Dimension, Aggregates and Configured Physical/Business Modeling/Presentation Layers demonstrate the exiting Subject Areas and provided Functionality to BI Users
• Participated in creating mapping document for legacy systems.
• Actively involved in gathering user requirements and GAP Analysis
• Developed Dashboards, Reports with Analytics Views like Pivot Table, Chart, Tabular and View Selector, Alerts, Guided Navigation with drill-down capabilities
• Prepared the ETL spreadsheet after identifying the Facts and Dimensions.
• Tested various reports, graphs and updated in Test Director
• Developed Scorecard Dashboards, with Analytics Views Dynamic View, Narrative View, Pivot Table, Chart, Column Selector, with global and local Filters
• Configured the scheduler which runs the IBots and delivers the content also seed the cache
• Created the required mappings using Informatica Power Center Designer and created the tasks for the mappings developed through Informatica Power Center Workflow Manager
• Responsible for developing ETL processes, loading and validating data from source systems into the data warehouse using Informatica.
• Co-ordinated with QA team and created Test Cases to test and validate the reporting system and its data

Environment: Seibel Analytics 7.x, , Oracle 8i, SQL Developer, Quality center, Windows XP.