SUMMARY OF QUALIFICATIONS

• Over Seven years of end-to-end business intelligence solution by installing, configuring metadata building analytics repository, dimensional model design, business model design, and interactive Business Intelligence Dashboard and Report design and implementation.
• Experience in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, Oracle BI Apps, Informatica Power Center.
• Have an excellent understanding of OLAP, BI Architecture, Business Intelligence and Data Warehousing Concepts.
• Proven Strength in creating guidelines and templates for designing developing BI Applications.
• Have in-depth knowledge on OBIEE Infrastructure, Answers, Dashboards and Reports, Data analysis, Data warehousing and ETL techniques, PL/SQL scripts
• Expertise in implementing OBIEE Security using Single Sign on Authentication mechanism.
• Strong knowledge and experience in developing OBIEE Repository at three layers Physical Layer, Business Model Presentation Layer , Time Series Objects, Interactive Dashboards with drill-down capabilities using global local Filters, OBIEE Security Setup users/groups, access / query privileges , configured OBIEE/Analytics Metadata objects Subject Area, Table, Column , Presentation Services/Web Catalog Objects Dashboard, Pages, Folders, Reports .
• Involved in end-to-end implementations of BI solutions for implementing Financials, Human Resources, Supply Chain Analytics, Procurement and Spend Analytics.
• Well experienced working with Oracle EBS modules like General Ledger, Account Payables, Accounts Receivable, Inventory, Purchase Order and Order Management.
• Highly experienced in Performance Tuning of Source, Targets, Mappings, Sessions and Transformations.
• Configured DAC Data Warehouse Administration Console for Creating Execution plans, Metadata management and monitoring the Informatica ETL Process.
• Good Knowledge and experience in customizing knowledge modules based on requirements.
• Adept in development and customization of Oracle BI Publisher XML Publisher , BI Discoverer Reports and improved business functionality by creating actionable reports and customer facing documents, that help in speedy business decision making.
• Expertise in Oracle PL/SQL and database Performance Tuning by implementing Parallel Execution, Table Partition, materialized views with query rewriting, creating appropriate indexes, usage of hints, re-building indexes and also used the Explain Plan and SQL Tracing.
• Worked in tandem with Oracle Consultants on numerous Service Requests Patch installations.
• Expertise using PL/SQL for writing Stored Procedures, Functions, Packages, Triggers and in the creation of tables, views, indexes.
• Expertise in business planning, analysis software designing skills with ability to transform business users input into software requirements and specifications.
• Competency in writing, maintaining and executing Test cases, Test plans, and Test scripts and generating software defect reports
• Experience in supporting the production system and handling day-to-day issues.
• Self-motivated team-oriented individual with strong ability to merge and coordinate with other teams.

TECHNICAL EXPERTISE

PROFESSIONAL EXPERIENCE

Confidential

OBIA / OBIEE SENIOR CONSULTANT

• Involved in the setup, installation, and configuration of complete Analytics platform environment for OBIEE, Informatica, DAC, and the required connectivity for seamless integration with data warehouse.
• Extracted the data from source system PEOPLE SOFT transformed the data and loaded into the OBIEE analytics warehouse using Informatica.
• Configured Column and Dashboard Filters in OBIEE Requirement validation of the reports and drilldowns.
• Performed End-to-End development mappings, data sources, business rules/logic, RPD, subject areas, reports/dashboards and administration
• Customized repositories using metadata objects Tables, Columns and Web Catalog Objects Folders, Reports .
• Maintaining user security in shared services like creating and deleting groups/users.
• Multi User Development Environment MUDE setup in OBIEE.
• Coordinated Onsite- Offshore Team for assigning the tasks and assisted offshore team for OBIEE technical aspects.
• Maintained Repository, Web catalog backups up to date for Development and test environments.
• Created Unit test cases for Analytics reports and Analytics dashboards and executed manually.
• Coordinating with the offshore development team to resolve issues affecting development work progress.
• Working on the development different dashboard for the customer needs.
• Worked on the SQL query development for the testing of the different Dashboards and Answers.
• 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 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.
• Exclusively Involved in Unit Testing and Data validation.
• Maintained Daily status, RPD Changes, ETL Changes and Project plan Documents.

Environment: Oracle EBS R12.1.1, OBIEE 11.1.1.7, BI Apps 7.9.6.4, Informatica 9.5, DAC 11g.

Confidential

OBIA/OBIEE SENIOR CONSULTANT

• Implemented Financial Analytics.
• Performed the Setup, Installation and Configuration of the complete Analytics platform environment OBIEE, Informatica and DAC and the required connectivity for seamless integration with the data warehouse.
• Extracted the data from the source system EBS R12, transformed the data and loaded into the OBIEE analytics warehouse using Informatica.
• Analyzed, Designed, and Developed OBIEE Metadata repository RPD that consists of Physical Layer, Business Mapping and Model Layer and Presentation Layer.
• Interacted with SME's, Business Analysts and Users for gathering and analyzing the Business Reports Requirements.
• Implemented Data Level security by creating users groups, creating Session Variables and Initialization Blocks and associated catalog objects and Web modules with the created groups.
• Designed, implemented and tested security privileges on Dashboards and Reports.
• Worked using Catalog Manager to migrate Web Catalog among Instances.
• Involved in Performance tuning of sessions and mappings for better performance.
• Built reports using Answers including drilldown objects, union based reports and formatted functions within the reports.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Performed debugging for verifying the prebuilt ETL mappings for Oracle BI Applications.
• Designed and modified ETL Mappings using Informatica from Scratch to load the Data from Source System EBS to staging system SDE mappings and to the target Analytics Warehouse.
• Developed and debugged many intelligence Dashboards using different Analytics Views Pivot Table, Pie/Bar Chart, and View/Column Selector, Narrative View , Dynamic/Interactive Dashboards with drill-down capabilities using global and local Filters.
• Customized Dashboard pages like AR Balance, Payments Due, Invoice Details and all AR Transactions in Receivables Dashboard.
• Customized Dashboard pages like AP Balance, Overview, Payments Due, Supplier Details and Invoice Details in Payables Dashboard.
• Implemented Time Comparison and Calculation measures in the business model using Time series wizard and modeled Slowly Changing Dimension Data.
• Trouble shooting the issues related to repository models and report development.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Monitored Incremental and Full Load of Data through DAC.

Environment: Oracle EBS R12.1.1, OBIEE 11.1.1.7, BI Apps 7.9.6.4,Informatica 9.5, DAC 11g.

Confidential

OBIA/OBIEE SENIOR CONSULTANT

Responsibilities:

• Interacted with SME's, Business Analysts and Users for gathering and analyzing the Business Reports Requirementsand did the necessary GAP analysis, translated them into technical design documents and worked with team members in making recommendations to close the GAP.
• Performed the Setup, Installation and Configuration of the complete Analytics platform environment OBIEE, Informatica and DAC and the required connectivity for seamless integration with the data warehouse.
• Extracted the data from the source system EBS R12, transformed the data and loaded into the OBIEE analytics warehouse using Informatica.
• Implemented Financial Analytics, Procurement and Spend Analytics, integrated data from Finance and other enterprise systems and transformed data using Informatica ETL .
• Have developed custom mappings for a third data source and integrated it with the existing analytic warehouse.
• Setup of Multi User Development Environment MUDE in OBIEE.
• Analyzed, Designed, and Developed OBIEE Metadata repository RPD that consists of Physical Layer, Business Mapping and Model Layer and Presentation Layer.
• Integrated OBIEE with EBS for Single Sign On SSO .
• Created Star Schema, Time Series Objects, Hierarchies, Level Based Measures and Security using External Table Authentication, Session Variables, and Initialization Blocks.

• Designed, implemented and tested security privileges on Dashboards and Reports.
• Worked using Catalog Manager to migrate Web Catalog among Instances.
• Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBot queries to obtain daily and weekly reports.
• Built reports using Answers including drilldown objects, union based reports and formatted functions within the reports.
• Performed debugging for verifying the prebuilt ETL mappings for Oracle BI Applications.
• Designed and modified ETL Mappings using Informatica from Scratch to load the Data from Source System EBS to staging system SDE mappings and to the target Analytics Warehouse.
• Using Universal adapters created new folders and mappings in Informatica to bring the data from other source systems.
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy and Aggregator.
• Developed and debugged many intelligence Dashboards using different Analytics Views Pivot Table, Pie/Bar Chart, and View/Column Selector, Narrative View , Dynamic/Interactive Dashboards with drill-down capabilities using global and local Filters.
• Customized Out of the Box Dashboard pages like Budget vs Actual, GL Balance, Cash Flow, AP Balance, Payments Due, Invoice Details, Supplier Reports, AR balance, Customer Report, AR Transactions in Financial Analytics.
• Customized Out of the Box Dashboard pages like Sourcing Trends, Total Spend Overview, Exceptions, Purchase Requisitions, Purchase Orders and Employee Expenses in Supply Chain Analytics and Procurement and Spend Analytics.
• Implemented Time Comparison and Calculation measures in the business model using Time series wizard and modeled Slowly Changing Dimension Data.
• Trouble shooting the issues related to repository models and report development.
• Developed many complex Full/Incremental Informatica Objects Workflows / Sessions, Mappings/mapplets with various transformations.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Customization and enhancement of standard Oracle applications reports in Account Payables module like Invoice Aging Report, Invoice Validation report, Cash requirement report using Oracle BI Publisher.
• Developed process and business rules around setup of new users Logins, Responsibilities ..
• Created new requests and opened Answers for ad hoc reporting to the End users.
• Conducted meeting with project managers, business users during testing and deployment stage of the application development life cycle.

Environment: Oracle EBS R12.1.1 General Ledger GL , Account Payables AP , Accounts Receivable AR , Inventory INV , Purchase Order PO , OBIEE 11.1.1.6, BI Apps 7.9.6.4,Informatica 9.1, DAC 11g,

Confidential

OBIEE DEVELOPER

• Proof of Concept to test the functionalities of OBIEE 11g 11.1.1.5 and Weblogic server Web Sphere is the only available app server at Wal-Mart
• Upgraded rpd having more than 30 subject areas , web catalog 80 GB , BI Scheduler, BI Publisher from 10.1.3.4.1 to 11.1.1.5.
• Implemented Single Sign On with Clear Trust configured to IIS.
• Implemented security with Microsoft Active Directory Authenticator, Configured multiple LDAP Servers approximately 20 LDAP Servers
• Monitored performance metrics using Enterprise Manager.

Environment: OBIEE 10.1.3.4.1, AIX, Web Sphere, Oracle 10g.

Confidential

• Tech Lead for BI and ETL Design, leading 2 developers.
• Worked on more than one terabyte of usage tracking data.
• Load Tested application using HP Performance Center
• Deployed the Usage Tracking BI Application to 5000 users.

Environment: OBIEE 10.1.3.4.1, AIX, Web Sphere, SQL Server, SSIS

Pre-Integration Business Intelligence

Confidential

• Tech Lead for BI Development, leading 3 developers.
• Closely worked with business in gathering the requirements and created a business model.
• Worked with BA in creating Business Requirements Document
• Worked with International business analyst and business users in creating the mockups dashboards/reports
• Worked with Data Architect on designing the dimensional model
• Involved in Building the RPD based on the requirements
• Involved in building reports and customization of dashboards based on the requirements.

Environment: OBIEE 10.1.3.4.1, AIX, Web Sphere, SQL Server