Professional Summary

• Over 9 years of diversified IT experience working with OBIEE 10.1.3.x/11g, Siebel Analytics 7.x, Oracle BI Applications 7.9.x, which include building and configuring repository, creating and managing Oracle/Siebel Intelligent Dashboards, Oracle/Siebel Answers, Oracle/Siebel Delivers, Oracle/Siebel iBots, BI Publisher and Extraction Transformation and Loading using Informatica
• Expertise in converting and using Oracle pre-built rpd's Financial, HR, Sales, Supply Chain, Order Management, Procurement and Spend, Manufacturing Analytics etc. according to business requirements.
• Expertise in Business Model development with Facts, Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Expertise in OLTP/OLAP System Study, Analysis and 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, Back up and Failover Strategies with connected and disconnected analytics
• Expertise in implementing Caching Strategy for the reports and usage tracking of reports
• Hands on experience in Authentication and Authorization of OBIEE by using LDAP, Database authentication, External Authentication and also implemented Single Sign on SSO .
• 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.
• Expert in converting Functional specs to Technical Specs and implementing OBIEE Best practices.
• 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.
• 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
• Expertise in developing ETL Strategies using Informatica Power Center and Loading of data from multiple data sources and creating workflows with worklets and various tasks and scheduling them using both workflow manager and Unix Shell Scripts using pm cmd .
• Logical and Physical Data Modeling and Dimensional modeling skills in Physical database design, Relational Models, Star Schemas, and Snowflake Schemas.
• Expertise in Data warehouse Administration console DAC to configure, monitor and schedule ETL routines.
• Experienced in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, Oracle BI Apps, Informatica Power Center.
• Designed and developed efficient Error handling methods and implemented throughout the mappings. Hands on experience in tuning mappings, identifying and resolving performance bottlenecks.
• Expert in Unit, System and Integration Testing and Performed Data Validation for all the ETL's and reports generated from Informatica and OBI/Siebel Analytics.
• Experienced in troubleshooting production issues and production support for projects.
• Experience in customizing mappings to transform data from a transactional database and other sources to staging tables and further to target tables.
• Installed and Setup ODI Master Repository, Work Repository, Execution Repository
• Worked on Loading and Integration KM in Flow tab in ODI Interfaces
• Created ODI Interfaces using different transformation logics and migrated data from flat files/legacy to Oracle data base.
• Implemented CDC through ODI Journalization Knowledge Modules KMs .
• Created procedure to delete the staging tables, Variables Last Value and used it in the ODI Package.
• Used Topology Manager to manage the data describing the information systems physical and logical architecture.
• Utilized different knowledge modules as per mapping rules to load data from legacy systems/Flat Files.
• Extensively used ODI Designer and ODI Studio to create and manipulate source data stores, target data stores, packages, interfaces, procedures, variables
• 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.
• Ability to define project technical requirements, documenting and communication for conversion into robust system designs.
• Unique combination of personal, analytical, technical and communication skills.

TECHNICAL SKILLSET

Professional Experience:

AMC Theatres, Leawood, KS Nov 2013 Till Date

Sr. OBIEE Consultant/OBIA Consultant

Responsibilities:

• Worked with the end users to discuss the requirements and did the necessary GAP analysis to fulfill the client needs.
• Integrated data from Finance enterprise systems and transformed data using Informatica ETL .
• 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.
• Monitored Incremental and Full load of Data through Data Warehouse Administration Console DAC and Informatica Work Flow Monitor.
• Performed End-to-End development mappings, data sources, business rules/logic, RPD, subject areas, reports/dashboards and administration .
• Customized Financial and projects related OOTB reports.
• Worked on Project, Procurement and Spend and finance related source queries to get the exact data required to built the report
• Created complex Union reports .
• Created Views in physical layer combining data from different tables
• Designed Star-Schema using Facts, Dimensions, Physical, Logical, Alias and Extension tables and established
• relationships Foreign Keys Physical Logical between tables.
• Created different types of Customized Reports Drilldown, Aggregation, Levels to meet business requirements.
• Created Dimension hierarchies to achieve the drill down functionality.
• Created filters and provided customized prompts filtering options appropriately to avoid excessive data visibility in reports.
• Created Technical design documents

Environment: OBIEE 11.1.1.7.1 , BI Apps 7.9.6.3 Financial , Procurement and Spend Analytics, Projects , Oracle EBS R12.1.3, Informatica 9.1, SQL Server 2008/Netezza 7.2.0

Confidential

Sr. OBIEE Consultant/OBIA Consultant

Responsibilities:

• Worked closely with the end users to collect the requirements and did the necessary GAP analysis to fulfill the client needs.
• Configured Financial, Procurement and Spend and Supply chain analytics domain value files.
• Did data validation for Finance, Procurement and Spend and Supply chain Analytics comparing data between EBS production and OBAW Production
• Developed new reports and customized Financial Analytics OOTB reports.
• Customized out of box Dashboard pages like Sourcing Trends, Revenue, Customer, Backlog, Shipping Performance, Total Spend Overview, Exceptions, Purchase Requisitions, Purchase Orders and Employee Expenses in Supply Chain, Procurement and Spend Analytics.
• Designed Star-Schema using Facts, Dimensions, Physical, Logical, Alias and Extension tables and established
• relationships Foreign Keys Physical Logical between tables.
• Used Informatica Power Center for ETL purpose, for Data Extraction from ERP, Data Mapping and Data
• conversion Transformation and Data loading into the BAW warehouse.
• Customized OOTB Informatica mappings for financial analytics based on the business requirements.
• Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.
• Created different types of Customized Reports Drilldown, Aggregation, Levels to meet business requirements.
• Created Dimension hierarchies to achieve the drill down functionality.
• Worked extensively on BMM Business Model and Mapping layer to capture the changes.
• Responsible for documenting all the mapping changes in the Physical Layer /Business Model / Presentation Layer of a Repository.
• Designed Intelligent Dashboards for different user groups to view updated KPIs.
• Importing groups into the repository and granted security privileges explicitly and through group
• inheritance. Responsible for documenting the logic and design of the reports and the reporting structure.
• Created filters and provided customized prompts filtering options appropriately to avoid excessive data visibility in reports.
• Worked SQL queries for better database performance.
• Optimized performance using Indexes, Aggregate tables and materialized views.
• Developed Unit and System test plans and performed testing for data validation.
• Trained End Users on how to build dashboards and reports.

Environment: OBIEE 11.1.1.6.0 , BI Apps 7.9.6.3 Financial , Supply Chain and Procurement and Spend Analytics , Oracle Applications R12.1.3, Informatica 9.1, Oracle 11g, TOAD, windows 7, SQL Developer

Confidential

Sr. OBIEE Consultant/OBIA Consultant

Responsibilities:

• Responsible to develop and customize HR Analytics OOTB reports related to Absence, Compensation, HR performance, Retention, Recruitment and Workforce Profile.
• Configured Workforce Event , Recruitment Event Reason , Pay Type files
• Customized the OOTB mappings to alter the actual Headcount metric to exclude non executive directors NED
• Created different types of Customized Reports Drilldown, Aggregation, Levels to meet business requirements.
• Generated various Analytics Reports like Formulary Report, Union Report.
• Developed Ad-hoc and standard Reports/Dashboards pages with different Analytics Views Drill-Down, Cascading Style Sheets, Pivot Table, Graphs, Column Selector and Tabular with prompts, global and local Filters , contextual navigation.
• Worked extensively on BMM Business Model and Mapping layer to capture the changes.
• Responsible for documenting all the mapping changes in the Physical Layer /Business Model / Presentation Layer of a Repository.
• Developed many Dashboards / Reports for providing analytical information using Oracle BI Answers.
• Analyzed Informatica ETL mappings and transformation and suggested the changes based on the business requirements.
• Performance tuning of Dashboard/Reports.
• Responsible for cache management.
• Responsible for document the logic and design of the reports and the reporting structure.
• Created filters and provided customized prompts filtering options appropriately to avoid excessive data visibility in reports.
• Performed unit testing and Responsible for the End User support.
• Configured OBIEE iBots/ Agents to deliver daily and weekly reports.
• Responsible Training End User on How to use the OBIEE Tool and How to creating Adhoc reports using OBIEE 11 G.

Environment: OBIEE 11.1.1.6.0 , BI Apps 7.9.6.3 HR Analytics , Oracle Applications R12, Informatica9.0.1, BI publisher, Oracle 11g, TOAD, windows 7, SQL Developer

Confidential

Sr. OBIEE Developer/Admin

Responsibilities:

• Installed and configured OBIEE repository Server, OBIEE Presentation Sever, oc4j, JDK, BI Publisher.
• Migrated and merged OBIEE Repository and Catalogs
• Monitoring the overall usage and taking necessary steps to improve the performance if needed
• Server Space management as per the need.
• Did the Necessary RPD and Catalog upgrades and applied patches as part of admin team.
• Provided extended production support based on the demand and complexity of the issue.
• Implemented Over all security, SSO, OBIEE content and Data level security
• Created users and groups in the LDAP server, and administered these users and groups using the WebLogic Server Administration 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.
• Implemented the Caching Strategy according to the client's data load frequency
• Enabled Usage Tracking to monitor the usage and performance of reports
• Managed/Administered OBIEE web catalog using Catalog Manager
• 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
• 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 according to best practices by using Columns, Sections and Guided Navigation
• 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.
• 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.

Environment: Oracle Applications R12 Financials, Projects, Supply chain and Order Management , OBIEE 10.1.3.4.1/11.1.1.5, BI publisher 10g, Oracle 11g, Toad, PL/SQL, HPUX, Windows XP

Confidential

Sr. OBIEE Technical Consultant

Responsibilities:

• 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
• 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.
• 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 11i/R12, OBIEE 10.1.3.4.1, OBIA 7.9.6.1, Informatica Power Center 8.6.1, Oracle 10g, DAC 10.1.3.4.1, Toad , Linux, File-Zilla

Confidential

OBIEE Technical Consultant

Responsibilities:

• Installed and Configured Financial Analytics and Procurement and Spend Analytics. Integrated data from Finance and other enterprise systems and transformed data using Informatica ETL .
• 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 .
• 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 Profit and Loss, Revenue, Products and Customers in Profitability Dashboard.
• Customized Dashboard pages like Overview, AP Balance, Payments Due, Payment Performance, Supplier Report, Invoice Details and AP Transactions in Payables Dashboard.
• Customized Dashboard pages like Overview, Budget vs. Actual, Asset usage, Financial Structure, Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger 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: Oracle Applications 11i/R12, OBIA 7.9.6, OBIEE 10.1.3.4.1, Informatica 8.6.0, DAC 10.1.3.4.1, SQL PLUS, SQL Loader, TOAD, Unix

Confidential

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: OBIEE 10.1.3.3, Oracle BI Applications 7.9.5 HR Analytics , Oracle EBS R12, Informatica 8.1, DAC 10.1.3, SQL Server 2000, Sun Solaris, Windows 2003

Confidential

OBIEE/Siebel Developer

Responsibilities:

• Translated business requirement into reporting matrix in OBI/Siebel Analytics.
• Involved in up-gradation, configuration and administration of Siebel Analytics 7.8.2 to OBIEE 10.1.3.1
• 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.