SUMMARY

• Analyzed the Dimension tables and Fact tables to determine the joins between the tables.
• 7 years of technical expertise in the IT industry with prime focus on Analysis, Design, Development, Customization, Maintenance, and Implementation of various Business Intelligence, Data warehousing Applications in an effective way to deliver leading edge software solutions.
• Expertise in Data warehouse development, reporting, and testing using Siebel Analytics/Oracle BIEE.
• Great experience in designing and working with Star Schema/Snowflake Schema methodologies using Siebel Analytics/Oracle BIEE.
• Performed the GAP analysis between the EBS R12, 11i, OBIA 7.9.6.3 and PeopleSoft 9.1 tables to perform the required mappings.
• Used Microsoft Visio software to create Star Schemas for all the Subject Areas in SCM
• Experience in working on Dashboards, Answers, Delivers and Analytics Administration Tool while using BI Publisher, Siebel Analytics, and Oracle BIEE.
• Brief knowledge in the terms Dimensional data models, identification of fact and dimension tables, and De-normalization.
• Great ability in setting up and working in MUDE Multi User Development Environment
• Experience in extracting, transforming, and loading data ETL from Oracle e-Business Suite and other data sources, including Oracle's PeopleSoft Applications, and non-Oracle sources into the Oracle Business Analytics Warehouse OBAW .
• Experience in Installing and configuring the Oracle Business Analytics Warehouse OBAW .
• Designed and developed complex reports and also trained Business/ Power Users in creating reports using the Siebel/OBIEE Answers/Dashboards.
• Strong skills in troubleshooting SQL Queries which help in solving the problem and thus enhance the data delivery and performance tuning of OBIEE reports.
• Actively interacting with business partners to identify information and business requirements for reports.
• Upgraded Siebel Analytics 7.7x to Oracle BI Infrastructure 10x and documented the process.
• Experience in Installation, Configuration, and Administration of Oracle BI Apps 7.9.X, OBIEE 10g standalone, Informatica PowerCenter 9.x/8.x/7.1.4.
• Experience in DAC Client/Server Installation and configuration and also using them.
• Extensive experience in Siebel/OBIEE Answers, Delivers, iBots, and Intelligent Dashboards.
• Experience in configuring Interactive Dashboards with drill-down capabilities using Filters and Dashboard Prompts, Siebel Security Setup groups, access privileges , Metadata Objects and Web Catalog Objects Dashboard, Pages, Folders, Reports .
• Implemented 'Single Sign On' Security between OBI and EBSR1211.
• Performed the Performance Tuning of Dashboards/Reports and made required changes to repository and database.
• Expertise in debugging and optimizing the OBI Dashboards Reports.
• Good working knowledge on OBIEE with BI Applications EBS financials, SCM, Procurement and Spend Analytics etc. .
• Working knowledge on different data sources ranging from flat files, Oracle, SQL Server, DB2 databases.
• Experience in using Informatica Power Center 6.x/7.x/8.x for developing and designing of ETL methodology for supporting Data transformations and processing in a corporate wide environment.
• Worked on Source Qualifier, Expression, Filter, Lookup, Update Strategy, Stored Procedure, Joiner, Router, Aggregator transformation.
• Proficient in creating and using Informatica workflows and worklets.
• Worked extensively on 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, and robust mappings/mapplets.
• Experience in using Sources, Mappings, Targets, and Sessions for OBIEE data warehouse loads and resolving any data inconsistencies across loads
• Very good Written and Verbal Communication skills, and very good at giving presentations.

Confidential

OBIEE Developer

Responsibilities:

• Effectively interacted with the end users for requirement gathering and defined requirement specifications document by access and retrieval of financial and personnel data from one single source.
• Prepared Technical Design Documents TDD of the complete implementation of the Business Module
• Developed different kinds of Reports pivots, charts, tabular using global and local Filters.
• Coordinated and worked with different teams like APPS, DBA, testing team, functional team and end users.
• Developed custom reports/Ad-hoc queries using Answers and assigned them to application specific dashboards.
• Configured Interactive Dashboard with drill-down capabilities using global and local Filters, Metadata Objects and Web Catalog Objects.
• Implemented and deployed MUDE Multi User Development Environment for repositories.
• 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 Star Schema and Custom Subject Area in OBIEE RPD for Fixed Assets module.
• Designing and developing physical and logical star schema using OBIEE admin tool. Import/create tables and add/change physical joins/keys.
• Implemented Financial, Supply Chain, Procurement and Spend Analytics.
• Participated in creating test plans, test objectives, test strategies and test cases in the QA testing phase
• Performed the GAP analysis between the EBS R12, 11i and OBIA 7.9.6.3 tables to perform the required mappings.
• Worked on Informatica Source Analyzer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor and Informatica server to load data from flat files, SQL.
• Run/Schedule ETL from DAC Client, monitor and trouble shoot complete ETL log files, DAC email notifications and DAC Server issues.
• Created new Mappings, Sessions, and Workflows in Informatica.
• Exported and Imported Informatica workflows by using Repository Manager.
• Created Full and Incremental sessions in Informatica and used Workflow monitor the workflows.
• Creation/customization of star schemas and Business Metrics in RPD as per customer requirements.
• Managed Security privileges for each Subject area and Dashboards according to user requirements.
• 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.
• Experienced working on agile model project.
• Responsible for moving the code to higher level databases and troubleshooting.
• Involved and Analyzed Dimensional data models, identification of fact and dimension tables, and De-normalization.
• Trained End users on Answers and Answers schemas thus enabling them to create ad-hoc reports and assisting them in resolving any issues.
• Managed the migrations of the webcatlog and RPD among different Environments
• Creating global filters, complex queries, prompts reports charts, tables, graphs in Answers and also created rpd/report development and worked on OOTB.
• Registered new tasks in DAC and run them through DAC Execution plan.
• Monitored Incremental and Full load of Data through Data Warehouse Administration Console DAC and Informatica Workflow Monitor.
• Use to examining the session logs if the workflows fail and fixing up the defect.
• Providing support and fixing issues related to Data on Reports, Dashboards etc.
• Experience in working with oracle by opening an SR for critical issues and providing them required details.

Environment: OBIEE 11.1.1.5.0/10.1.3.4.1, Oracle Applications R12 General Ledger, Accounts Payables, Accounts Receivable, Purchasing, PeopleSoft 9.1, Informatica Power Center 9.1.0/9.6.0, DAC 11g/10.1.3.4.1, Oracle 11g, Toad.

Confidential

Sr. OBIEE Developer

Responsibilities:

• Worked with Business Groups to identify, analyze, and document Business Requirements.
• Gathered requirements for GAP Analysis, translated them into technical design documents and worked in making recommendations to close the GAP.
• Implemented Financial, Supply Chain, Procurement and Spend Analytics.
• Integrated data from Finance and other enterprise systems and transformed data using Informatica ETL .
• Designed and Developed Custom Mappings, Workflows and Registered in DAC.
• Created Star Schema and Custom Subject Area in OBIEE RPD for Fixed Assets module.
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Worked on extracting data from Oracle EBS, OLTP flat files and integration and loading data to DataWarehouse OLAP system.
• Designed and Developed Custom Mappings and Workflows in Informatica to bring the data from other data source systems and Integrated using Oracle Adapters in DAC.
• Registered new tables, Indices, Workflows in DAC.
• Created new subject areas and Execution Plans in DAC.
• Customized various out of the box tasks in Informatica.
• Used various transformations SQ, Expression, Lookups, Update Strategy, Filter etc in Informatica.
• Implement incremental logic for Stage load mappings and Insert/update logic for all Fact mappings.
• Gathering requirements from business users and converting them into technical design documents.
• Creating complex joins/keys, setting levels to support Drill-down, Aggregation/Sum over columns and used DAC has deployment tool for ETL.
• Creating global filters, complex queries, prompts reports charts, tables, graphs in Answers and also created rpd/report development and worked on OOTB.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Implemented Multiuser Development Environment MUDE Using Oracle BI Administration Tool. Migrated Analytics RPD and Web catalog from one environment to another.
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level the Application level.
• Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters , contextual navigation, business rules with user identity and roles within the OBIEE suite.
• Monitored Incremental and Full load of Data through Data Warehouse Administration Console DAC and Informatica Workflow Monitor.
• Developed Informatica Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.
• Created and Customized Dimension Hierarchies to achieve the drill down functionality as per Business Requirements.
• Experience in performance tuning at the Database level by creating aggregate tables, Bitmap, B Tree Indexes, RPD level by creating Database hints in physical Layer, Tuning Reports.
• Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas.
• Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.
• Involved in customizing out of the box reports to support the business requirements.
• Involved in configuring and customizing sources, targets, tasks and execution plans using DAC.
• Involved in Query Tuning to maximize the performance of reports and Dashboards.

Environment: Oracle Applications R12 General Ledger, Accounts Payables, Accounts Receivable ,Inventory, Purchasing, Order Management, Fixed Assets , OBIEE 11.1.1.5.0/10.1.3.4.1, Oracle BIApps 7.9.6.1/7.9.6.3, Informatica Power Center 8.6.1/9.0.1, DAC 10.1.3.4.1, Oracle 10g, Toad , Windows.

Confidential

Sr. OBIEE Developer

Responsibilities:

• Involved in implementing the OBI 11g into the SCPT project in order to replace the EBS reporting with OBIEE reporting.
• Performed the GAP analysis between the EBS R12, 11i and OBIA 7.9.6.3 tables to perform the required mappings.
• Involved in creating the scripts required for the views needed to import to perform the RPD development.
• Performed the GAP Analysis between SAP and EBS R12 tables to be able to map SAP columns to R12 columns so that to replace SAP reporting with OBIEE reporting.
• Worked on creating the data models for all the Subject Areas in SCM Inventory, Order Management, and Procurement .
• Played various roles - OBIEE developer/OBIEE Administrator.
• Solely responsible for migration of repository and Web Catalog from 10g to 11g.
• Test and identify impact and changes required for 11g rollout from RPD and Catalog perspective.
• Provided training to the existing team on 11g and the new capabilities.
• Responsible for installing, configuring and administration of Oracle BI Apps 7.9.6.3/7.9.6.2
• Performed WebLogic 10g installation, domain configuration and performance tuning. Deployed required applications on BEA WebLogic.
• Involved and Analyzed Dimensional data models, identification of fact and dimension tables, and De-normalization.
• Analyzed the Dimension tables and Fact tables to determine the joins between the tables.
• Used Microsoft Visio software to create Star Schemas for all the Subject Areas in SCM Inventory, Order Management, and Procurement .
• Imported the required tables into the RPD to perform the Star Schema joins for the relative subject areas.
• Involved in Designing and Completing the RPD for all the Subject Areas in Inventory, Order Management, and Procurement.
• Implemented and deployed MUDE Multi User Development Environment for repositories.
• Merged the different RPD's from the developers into one RPD.
• Involved in testing and debugging the RPD which has been built.
• Prepared and Demonstrated a Quick start guide introducing the OBIEE to the Users who are relatively new to the OBIEE track.
• Working in the PM activities of preparing and gathering the CR's for different tracks under Reporting of the SCM.
• Gathered the requirements and used the DOORS software in writing and updating the CR's.
• Working with the SharePoint to keep tracking of the CR's.

Environment: Oracle Business Intelligence EE 10.1.3.4.1, OBI Apps 7.9.6, DAC 10.1.3.4.1, Informatica 8.6.1, E-Business Suite R1211, Financial Analytics, SupplyChain Analytics, Procurement and Spend Analytics.

Confidential

OBIEE Developer Consultant

Responsibilities:

• Conducted meetings with business representatives for gathering the business requirements.
• Performed Data Warehouse analysis and identified the required Facts, Dimensions, Levels / Hierarchies of Dimensional and referential joins.
• Devised a model plan to implement the analytical repository from an Oracle Business Intelligence perspective.
• Worked on integrating and configuring BI Publisher with OBIEE.
• Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBots queries to obtain daily and weekly reports.
• Documented the Requirements and implemented a Design Solution for the BI Architecture.
• Worked extensively on the Oracle BI Admin Tool to create the Physical, Business and Presentation Layers.
• Created hierarchies, complex and foreign joins initialization block, presentation or repository or session variables, calculations, aggregates, partitions, fragmentations and slowly changing dimensions.
• Setup Multi User Development Environment MUDE in OBIEE.
• Granting access to users and maintain security by using database authentication and authorization.
• Designed and Developed Custom Mappings in Informatica to bring the data from Legacy system.
• Created Custom Mappings in Informatica to Load the Receivables Data from Legacy system.
• Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes, partitions, fragmentations, aggregate tables, managing cache and overwriting the SQL execution path by making use of hints.
• Performed the setting up, installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration with the data warehouse.
• Modified Pre-built OBI Applications dashboards, Answers, Repository for Sales, Finance, Supply Chain and Order Management Analytics.
• Designed and developed Analytics Metadata Repository .rpd using Oracle BI by importing the required objects with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions Drill-Down Hierarchies , Logical objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Developed many Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local Filters using Oracle BI Presentation Services.
• Developed many Accounting and Collection Time Series objects for comparing the Billings, Collections and Adjustments between the different time frames.
• Implemented and deployed MUDE Multi User Development Environment .
• Implemented 'Single Sign On' Security between OBI and EBS R1211.
• Configured IBots to deliver Analytics content based on schedule, automated IBot queries to obtain daily and weekly reports.
• Configured BI scheduler IBots for OBIEE.
• Created alerts using OBI scheduler which will send email to concerned managers based on alert report.
• Improved performance of the reports and dashboards by using IBOTS cache seeding capability.
• Installed BI Office Client MS OFFICE Add-ins , configured the connections which enable us to analyze and deploy Business Intelligence reports easily in Microsoft Office applications, Excel and PowerPoint.
• Performed the Performance Tuning of Dashboards/Reports and made required changes to repository and database.
• Participated in creating test plans, test objectives, test strategies and test cases in the QA testing phase
• Worked on OBIEE with BI Applications EBS financials, Supply Chain Management, Procurement and Spend Analytics etc. .
• Developed many incremental ETL using Informatica mappings Oracle PL/SQL procedure.
• Improved performance of ETL load by implementing creative ideas in Informatica.
• Created comprehensive and easy-to-understand Documentation of the complete implementation of Analytics that includes .rpd, Dashboards, ETL and Security etc. .
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to Siebel Analytics Repository.

Environment: Oracle Business Intelligence EE 10.1.3.4.1, OBI Apps 7.9.6, E-Business Suite R1211, Informatica Power Center 8.6.1, DAC, Oracle 10g, Windows 2003.

Confidential

OBIEE Developer

Responsibilities:

• Upgraded Siebel Analytics 7.7x to Oracle BI Infrastructure 10x and documented the process.
• For upgrade, acquired the license for OBIEE before uninstalling the Siebel Analytics.
• In the upgrade process, saved the webcat files, repository files, and other important files of Siebel Analytics and after the installation of OBIEE, upgraded the webcat files, rpd files, and configured the environmental changes.
• Install and configure OBIEE Analytics and Presentation Server, OBIEE Scheduler's for Delivers, OBIEE Publisher.
• Upgraded Informatica and DAC.
• Used OBIEE to design and develop reports across various modules.
• Used various presentation services tools such as Oracle Answers including drilldown objects, formatting and functions within the reports, dashboards, filters, and prompts to develop reports.
• Configured Financials, Order Management and Procurement Spend Analytics.
• Customized and Created New dashboards in OBIEE for AR, AP, GL.
• Customized Dashboard pages like Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger.
• Customized Dashboard pages like AR Balance, Payments Due, Invoice Details and AR Transactions in Receivables.
• Developed and customized Order Management Analytics dash boards like Order and Invoice Revenue by Product, Order Revenue Growth over Previous Year, Cumulative Order Revenue versus Last Quarter, Total Spend Analysis Over Time.
• Worked on adding additional columns in the Informatica Mappings to meet the client requirements in OBAW.
• Designed OBAW for Dashboard requirements in order to source data from multiple source systems
• Set up the Session Variables for all the reports developed using OBIEE.
• Worked on setting up the Siebel Analytics scheduler iBots
• Set up Invoice level security in OBIEE based on the user level access from EBS.
• Implemented Financial Analytics. Collecting and transforming data from Finance and other enterprise systems based on the requirement.
• Created many Reports / Dashboards using various Analytics Views Drill-Down / Dynamic, Pivot Table, Chart, Column Selector with global and local Filters using OBIEE.
• Design, Develop, and Customize OBIEE/Siebel Analytics Metadata repository RPD with three layers of Physical Layer, Business Mapping, Model Layer and Presentation Layer as per the business modules and requirements.
• Developed many complex Informatica Objects like Workflows, Sessions, Mappings, mapplets with various transformations .
• Configured BI Scheduler IBots to enable results and reports and email notifications to designated users of their success or failure according to a user's pre-determined schedule.
• Improved performance of the reports and dashboards by using IBOTS cache seeding capability.
• Created OID security for reports in OBIEE.

Environment: Oracle Business Intelligence EE 10x, OBI APPS 7.9.4, Oracle Applications 11.5.10 GL, AP, AR, OM, PO , OBIEE Financials, Order Management, Procurement Spend , Informatica, DAC, UNIX.

Confidential

Siebel Analytics Consultant

Responsibilities

• Understanding the Business Design Documents and creating an overall design based on requirements and Business reviews.
• Configured Column and Dashboard Filters in Siebel Analytics.
• Worked on Siebel Analytics webcat and created business reports and dashboards based on business requirements.
• Worked on Siebel Analytics Financials, SCM, HR
• Developed RPD based on the business requirements and created Subject Areas to utilize them with different criteria like charts, prompts, and pivot tables using Siebel Analytics Answers and Dashboards.
• Created logical tables and assigned levels, custom aggregation rules.
• Used Session variables and Created group accesses and privileges for the Siebel Analytics Web reports.
• Worked on Analytics components like Clients, Presentation Services and server, repository and data sources.
• Performed End-to-End development mappings, data sources, business rules/logic, .rpd, subject areas, reports/dashboards
• Designed and customized repositories using metadata objects and Web Catalog Objects.
• Created Unit test cases for Analytics reports and dashboards, and executed manually.

Environment: Siebel Analytics 7.8.2, Oracle 9i, Business Objects 6.1 and BO Xi, DAC, Informatica 7.1.1

Confidential

Siebel Analytics Consultant

Responsibilities:

• Thoroughly examined existing repository RPD - subject Areas, documents and designed new dimensions, facts, reports.
• Updating existing dashboards based on business requirements
• Extensively worked on Siebel Analytics - Physical, Business and Presentation Layers.
• Documented the changes made for the restructured Repository.
• Performed all the activities on Siebel Analytics - Presentation Services, Server, Repository, catalog Manager and Data sources.
• Administration User profile creation, Dashboards, Groups - Users setup for Dashboards and security/responsibilities.
• Performed End-to-End development-Informatica mappings, data sources, business rules/logic, rpd, subject areas, reports/dashboards, security etc.,
• Developed sessions, tasks, and workflows to migrate data from OLTP to DW/OLAP.
• Designed and restructured the Oracle Interactive Dashboards and reports.
• Creating and modifying existing tables, logics, mappings, sessions and workflows based on requirements.
• Provided user trainings on application and whenever is needed.
• Supported the existing production issues on EDW and Siebel Analytics.

Environment: Siebel Analytics 7.7, Oracle 9i, Informatica 6.2, DB2, UNIX