PROFESSIONAL SUMMARY:

• 8+ years of diversified IT experience in delivering Business Intelligence solutions by gathering requirements, analysis, Dataware house development, Data modelling, testing, reporting and implementation using Business Analytics Tools like OBIEE 11.1.1.7/10.1.3. x, ODI 11.1.1.7, Informatica Power Center 9.x/8.x/7.x etc for various Business Intelligence (BI) applications.
• Expertise in Business Model development with Facts, Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Experienced in Installation, Configuration, Upgrade, Migration and Administration of Oracle Business Intelligence Enterprise Edition (OBIEE), Informatica & Oracle Data Integrator (ODI).
• Expertise in converting and using Oracle pre - built rpd (Financial Analytics, HR, Sales, Supply Chain, Order Management, Procurement and Spend Analytics etc.) according to business requirements.
• Worked on OLTP/OLAP applications, E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling. Extensive experience with Fact and dimensional tables, and slowly changing dimensions.
• 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.
• Expert in implementing and handling the complex environments which include clustering of servers, Backup and Failover Strategies with connected and disconnected analytics.
• Expertise in implementing Security Models for Dashboards, Row level, Object Level, Role Level, Dashboard Level.
• Experience in creating Aggregate tables using materialized views and using Aggregate Persistence wizard.
• Extensive experience in OBIEE repository (Physical, Business Model and Mapping and Presentation layers) for both Stand-Alone and Integrated OBIEE implementations.
• Expertise in developing Interactive Dashboards with drill-drown capabilities using global and local filters, Security setup (groups, access/query privileges), metadata objects and web catalog objects (Dashboard, Pages, Folders, Reports) and KPI’s for performance indication and scheduling Agent/IBots.
• Expertise in implementing Oracle BI Apps in all phases like implementing Out of order Box (Vanilla mappings) prebuilt mappings, Designing ETL, metadata management using DAC, Creating Oracle provided data warehouse BAW,OBIEE RPD development, OBIEE reports and dashboards.
• Installed and Configured Oracle Data Integrator (ODI)software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning and developing ETL.
• Developed new interfaces of E-LT and ETL in Oracle Data Integrator (ODI).
• Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating and loading data into Data Warehouses and having comprehensive knowledge in data normalization/de-normalization.
• Developed numerous ODI Interfaces, packages, scenarios to extract data from different source systems such as Oracle EBS (AR, AP, GL, OM Modules), Legacy Systems such as Mainframe, Flat files and Load into ODS/EDW.
• Data Warehousing experience using Informatica Power Center 9.0.x, 9.1/8.1, 8.5, 8.6.1.
• Strong working knowledge in architecture, design and development of Extraction, Transformation and loading process (ETL) with Informatica with Data in ETL tools.
• Experience in Performance Tuning of sources, mappings, targets and sessions.
• Proficient in using Informatica Workflow Manager, Workflow monitor to create, schedule and control Workflows, Tasks, and Sessions
• Experience in components such as Mapping Designer, different types of Transformations such as (Source Qualifier, Filter, Aggregation, Router, Update Strategy, Lookup, Union, etc.)
• Testing and Debugging of Informatica Mappings, Mapplets, Sessions, Tasks, Worklets and Workflows
• Expertise in Data Warehouse Administration console (DAC) to configure, monitor and schedule ETL routines.
• Involved in configuring and customizing sources, targets, tasks and execution plans using DAC.
• Extensive experience in working with RDBMS like Oracle, Sybase, UDB and SQL Server.
• Experience in creating SQL, PL/SQL, Stored Procedures/Packages/Triggers/Cursors and UNIX Shell scripts and very proficient in SQL tuning and optimization of queries.
• Excellent problem solving skills with strong technical background and good inter-personal skills, Quick learner and excellent team player, ability to meet deadlines and work under pressure.
• Experience in all phases of the System life Cycle including project definition, analysis, design, coding, testing, implementation and Production support.

TECHNICAL SKILLS:

BI/Reporting Tools: OBIEE 11.1.1.7/10.1.3. x, Discoverer4i/9i/10g, BI Publisher, Oracle Business Intelligence Applications 7.9.x, Siebel Analytics 7.8/7.7.

DWH/ETL Tools: Oracle Data Integrator 11.1.1.7, Informatica Power center 9x/8x/7x, DAC.

Database.: Oracle RDBMS, Oracle 11g/10g/9i/8i, Sybase 15/12.x, UDB 8.1, SQL Server 2005/2000.

Languages: SQL,PL/SQL,UNIX Shell Scripting,C,C++,HTML,ASP.NET.

Operating Systems: Windows NT/2008/XP/2000/2003, RHEL 4.x/5.x, UNIX (Solaris, Linux).

Database Tools: SQL*Loader, SQL*Plus, TOAD 9.x, 8.x.

Data Modeling: Dimensional Data, Erwin, ER/Studio, Visio, Star Schema, Snowflake, Tables,Physical Logical.

PROFESSIONAL EXPERIENCE:

Confidential, CA

Sr. OBIEE / ODI / Oracle BI Apps Developer

Responsibilities:

• Worked with Business Groups to identify, analyze, and document Business Requirements.
• Installed and configured OBIEE repository Server, OBIEE Presentation Sever, BI Publisher and ODI.
• Migrated and merged OBIEE Repository and Catalogs.
• Server Space management as per the need
• Provided extended production support based on the demand and complexity of the issue.
• Implemented Over all security, SSO, OBIEE content and Data level security.
• Create/Manage Repository/Web Users and Groups and assigning permissions using Enterprise Manager and Console.
• Worked with Business analysts 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.
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Worked in End to End construction of the BI model from repository to reports development.
• Worked with OBIEE Answers, Intelligence Dashboards in OBIEE 11g. Demonstrated knowledge in dealing with various functionalities like prompts, views, aggregates, global filters, guided navigation, customization, conditional formatting of reports to satisfy the end users.
• Designed and developed physical, logical and presentation layers of the repository with new data model changes.
• Developed dimensional hierarchies to facilitate the drill down and report navigation.
• Configured Bi Scheduler and created iBots to schedule and deliver Analytics content to multiple delivery destinations and also a Cache Seeding mechanism.
• Implemented the Caching Strategy according to the client’s data load frequency.
• Enabled Usage Tracking to monitor the usage and performance of reports.
• Implemented MUDE (Multi User Development Environment) in OBIEE.
• Created complex measures in BMM (Business Model and Mapping Layer) using Level based Measures, Time Series calculations and different Aggregation Strategies.
• Created new Repository Variables, Session variables and Initialization blocks to configure security, data access and authorization on Repository and Catalog objects.
• Implemented connection aggregate navigation by creating multiple logical table sources for the same logical table and configured the pool settings according to the requirements.
• Created Answers reports using various analytics views like Table, Pivot tables, Charts, Column Selectors, View Selectors, Narrative, Static text etc.
• Created common header and footer templates for all the reports in Answers.
• Created new Dashboards and created dashboard Prompts for selective viewing and User Interactivity. Implemented column selector functionality using Dashboard Prompts and Presentation variables.
• Was responsible for performance improvement of the reports by using various strategies in both the database and OBIEE like Indexes, Hints in Physical Layer, Materialized views and Caching.
• Involved in Integrating Oracle BI Presentation Services with BI Publisher and Set up BI publisher Security to control access given to business users.
• Experienced in working with BI (XML) Publisher, Data Templates, RTF, and XSL Templates and provided the capability to download the reports in the user defined formats.
• Installed ODI. Set up the ODI connection with Oracle, MS SQL Server and flat file.
• Developed, Supported and Maintained ETL (Extract, Transform and Load) processes using Oracle Data Integrator (ODI).
• Translated business requirements into technical specifications to build the Data Warehouse.
• Created and Maintained data base objects (Tables, Views, PK keys, Indexes, Partitions, Triggers, and Sequences, etc.).
• Developed numerous ODI Interfaces, packages, scenarios to extract data from different source systems such as Oracle EBS (AR, AP, GL, OM Modules), Legacy Systems such as Mainframe, Flat files and Load into ODS/EDW.
• Validate the Data which was brought into ODS/DW using SQL/PL-SQL scripts.
• Opened several Oracle SR’s for product issues and regularly interacted with Oracle support team, development team and worked closely with Oracle in resolving product Bugs.
• Responsible for setting up ODI in all the environments (DEV, UAT and PROD) which includes all the tasks from Installing and configuring ODI to releasing the environment to users (assigning security, client installations and other related tasks).
• Installed the J2EE ODI Agents on WebLogic server as part of ODI setup.
• Responsible for setting up/administering source and target connection in ODI.
• Responsible for scheduling the Scenarios to execute in serial/parallel modes to meet the data load requirement.
• Monitor the scheduled ODI jobs in PROD and apply fixes for failed ones.
• Huge experience in fine-tuning complex ODI processes for better performance.
• Migrate the ODI scenarios across different environments (from Dev to UAT and then to Prod) using PPM packages.
• Experience in customizing ODI Knowledge Modules, writing custom codes using Jython to meet the complex business requirements.
• Experience in designing Mini Schemas/Data Models/Data Marts for Legacy Systems in Oracle and develop Reports out of OBIEE answers, dashboards as per business requirement.
• Experience in building ad-hoc reports in OBIEE answers and design some mid level dashboards as per user requirements.
• Experience in building and maintaining database objects (Tables, Views, Procedures and Functions etc ) used in the Data Models.
• Responsible for creating Test plans and co-ordinate with Testing Team in executing test plans for the ETL Interfaces.
• Responsible for project documentation (documenting functional, technical documents, preparing test cases/test plans and KT plans).
• Developed and tested Store procedures, Functions and packages in PL/SQL for Data ETL.

Environment: Oracle Data Integrator (ODI 11.1.1.7.1 ), OBIEE 11.1.1.7, BI Apps 7.9.6.4/7.9.6.1 (Financial Analytics, Order Management and Supply Chain Analytics, Procurement and Spend Analytics, HR Analytics), Oracle E-Business Suit (R12.2.2), Toad 9.1, Windows XP/2003, Oracle 10g/11g, MS SQL Server 2012, UNIX Shell Scripting, SQL Developer, PL/SQL.

Confidential, PA

Sr. OBIEE Technical Consultant / Oracle BI Apps Developer

Responsibilities:

• Conducted meetings with business representatives for gathering the business requirements.
• Involved in full life cycle implementation of Financial, Supply Chain and Order Management Analytics including installation, configuration, extension and customization.
• Worked with both Onsite- Offshore teams.
• Conducted workshops to gather user requirements and performed GAP analysis.
• Provided extended production support based on the issues.
• Installed and Configured OBIEE, DAC and Informatica on linux environment.
• Worked on extracting data from Oracle EBS, OLTP flat files and integration and loading data to OLAP system.
• Designed and Developed Custom Mappings and Workflows in Informatica to bring the data from other data source systems and Integrated using Universal Adapters in DAC.
• Implement incremental logic for Stage load mappings and Insert/update logic for all Fact mappings.
• Implemented Multiuser Development Environment (MUDE) Using Oracle BI Administration Tool.
• Migrated Analytics RPD and Webcat from one environment to another.
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.
• Designed and implemented the single sign on (SSO).
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Application level.
• Involved in setting up Ibots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.
• 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, 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 and snowflake Schemas.
• Data corrections - problem finding and solving using custom scripts written in SQL/PLSQL with cursors, triggers, procedures and functions.
• 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: OBIEE 11.1.1.6/10.1.3.4, Oracle 11g, Oracle R12 (GL, AP, AR, TCA, PO, OM, FA, CRM),SQL*Loader, Oracle BI Publisher, Discoverer 10g, Reports 6i, MS SQL Server 2008, Informatica 9.0.x/9.1, XML, PL/SQL, UNIX Shell Scripting, Windows NT.

Confidential, CA

OBIEE Technical Consultant

Responsibilities:

• Conducted meetings with Subject Matter Experts (SME), Business Analysts and End-Users in gathering and analyzing the Business Reports Requirements.
• Gathered requirements from the client for GAP Analysis, translated them into technical design documents and worked with team members in making recommendations to close the GAP.
• Integrated OBIEE with EBS for Single Sign On (SSO).
• Provided extended production support based on the issues.
• Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBot queries to obtain daily and weekly reports.
• Created Environment Variable on Unix/Linux Environment.
• Designed and Developed Dashboard Pages Like Total Spend Overview, Trends, Exceptions, Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee Expenses in Procurement and Spend Dashboard.
• Designed and Developed Procurement and Spend and Supplier Performance, General Ledger, Payables, Receivables, Profitability, Dashboards in OBIEE.
• Customized Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee expenses OOB dashboard pages in Procurement and Spend Analytics.
• Designed and Developed Custom Mappings in Informatica to Load the Receivables Data from Legacy system.
• To implement incremental logic for Stage load mappings and insert/update logic for all Fact mappings.
• Extracted various sources like Oracle tables and imported Flat files using Informatica Power center.
• Extensively developed mappings on various business areas in the project by employing the available Transformations.
• Responsible for extracting Data from Oracle Apps Modules & loading into stage system and warehouse system.
• Customized Dashboard pages like Overview, AP Balance, Payments Due, Essectiveness, Payment Performance, Supplier Report, Invoice Details and AP Transactions in Payables Dashboard.
• Customized Dashboard pages like Profit and Loss, Revenue, Products and Customers in Profitability Dashboard.
• Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Customized Oracle BI metadata in the analytics repository with Oracle BI Administration Tool.
• Customized the Repository by creating Facts and Dimensions and adding some extra columns to the Existing Facts and Dimensions.
• 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.
• Created Dimension hierarchies to achieve the drill down functionality.
• Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, Aggregator.
• Designed and Developed Sessions and Workflows.
• Designed, implemented and tested security privileges on subject areas, dashboards and reports.

Environment: OBIEE 10.1.3.4.1, Oracle Apps 11i, Oracle Bi Apps 7.9.6, Informatica 8.6.1, DAC 10.1.3.4.1, Oracle 10g/11g, Oracle EBS R12, Oracle SQL Developer 2.1.1. UNIX Shell Scripting, PL/SQL.

Confidential, Saint Louis, MO

OBIEE/OBIA Developer

Responsibilities:

• Participated in discover/design phase of business requirements by meeting various business users.
• Prepared Fit/Gap Analysis documents between requirements in necessary customizations and out-of-the-box Oracle BIA functionality.
• Analyzed the business requirement gatherings and translated the functional specifications into technical specifications.
• Worked on extracting data from Oracle EBS, OLTP flat files and integration and loading data to OLAP systems.
• Extracted the pre-built BI solutions of tables by using Oracle BI Apps, OBI Admin tool to configure and create repository (.rpd) and prepared a detail design document.
• Developed the repository model based on different requirements, with the necessary logic that involved customizing the OOTB Physical, Business Model Mapping and the Presentation layer.
• Analyzed the transaction environment to identify the required facts and dimensions for the OLAP.
• Created hierarchies, variables, time series measures and event poll strategies in the repository.
• Developed and customized HR Analytics OOTB reports and new Reports, performed look-good changes to OTB Dashboards with different subject matter Views (Drill-Down/Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using OBI Presentation Services for the various work streams.
• Developed calculated measures and assigned Aggregation levels based on dimension hierarchies.
• Worked Extensively on OBIEE Answers to create the reports as per the client requirements.
• Designed and implemented the Bulletproof Single Sign on (SSO) process so that users can navigate from the portal to the OBIEE dashboard.
• Implemented guided navigation within reports.
• Worked with ETL Team on Informatica Power Center tools - Source Analyzer, Data warehousing designer, Mapping Designer and Mapplets, Transformations, Work Flow Manager (Task Developer, Worklets and Work Flow Designer) and Work Flow Monitor.
• Involved in creating custom Mappings, Mapplets to load the new tables and the new information into the warehouse.
• Used DAC Client to customize and execute out-of-the box DAC execution plans to run all ETL mappings at specified interval.
• Customized DAC tasks, tables, table groups and indexes as per requirements.
• Performed nightly incremental loads using DAC.
• Customized the change capture process of DAC to load data incrementally.
• Involved in Performance tuning of reports/dashboards as well as metadata repository using optimization efforts such as re-organizing the data, cache management, indexes.

Environment: Oracle Applications R12.0.1, R12.0.2, R12.0.4, R12.0.6 (AR, AP, GL, OM, INV, SCM), Oracle 10g, OBIEE 10.1.3.2.1, Oracle BI Apps 7.9.5, SQL*Loader, Oracle BI Publisher, Informatica 8.1, 8.5, Discoverer 10g, Reports 6i, PL/SQL, TOAD, UNIX Shell Scripting, Shell Scripting, Windows NT, Solaris.

Confidential

OBIEE/Siebel Developer

Responsibilities:

• Understanding the Business Design Documents and creating an overall design based on requirements and Business reviews.
• Built the Physical layer/Business Model and Mapping Layer/Presentation Layer of a Repository by using Star Schemas.
• Customized Mappings and used Aliases in Physical Layer.
• Participated in Adding Calculations to a Fact Table for various reporting requirements.
• Created Dimension Hierarchies and Level-Based Measures for Business requirements.
• Used Aggregate Tables and specified Aggregate Levels for each source.
• Mapped Dashboard field requirements to Siebel OLTP/OLAP Physical/Business Model.
• Designed and customized Siebel Answers Views and Charts, Create and save filters, Create Charts and Tables in Siebel Answers, Intelligence Dashboards and created Global Filters.
• Used Session Variables in report calculations and Security implementation.
• Used Preferred Drilldown to provide seamless navigation capability to business users.
• Involved in Performance Tuning of reports, created bitmap Indexes, Materialized Views and Table Partitions.
• Used Metadata Design Principles to Design Repository based on business requirements and followed best practices.
• Set up Analytics Server Security to control access given to business users.
• Created and granted privileges for the users using Analytics Catalog Manager.
• Set up LDAP authentication, used Row-Wise Initialization Blocks and set web groups.
• Administrated Scheduler Server and Tables to set up Delivers to configure iBots based on the threshold value of the user.
• Enabled Usage Tracking Table and Dashboards.
• Managed Deployment of Web Catalog and Repository of Siebel Analytics in dev to stage, stage to prod environments. Promoted changes in Repository and Web Catalog onto the production servers.
• Involved in creating Complex mappings using lookup, filter, joiner, aggregate, sequence generator and expression transformations using Informatica Power center.
• Created Test plans and executed the Unit and Integration Testing Scripts.

Environment: OBIEE 10.1.3.1, Siebel Analytics 7.8.2, Oracle 10g, DB2, PL/SQL, Informatica Power Center 7.1.3, UNIX, XML, SQL Navigator 4.5.