SUMMARY

• Over 10+ years of cross - functional experience Enterprise in Reporting tools like OBIEE, INFORMATICA and Data Warehousing, along wif Oracle Applications (E-Business Suite) and Technical experience in developing
• Experience in OBIEE Development and Design along wif implementation of Data Warehouse and experience in Requirement Gathering and performing analysis.
• Expertise in use of INFORMATICA Power-center 9x and 8x in Data warehousing And OBIA 7.9.6X (Financials and Procurement, HCM and Service Analytics) for ETL.
• Experience in Dimensional Modeling, Repository Management (RPD), Extraction Transformation and Load (ELT). Cross-platform proficiency (Oracle EBS Financials, CRM, Supply Chain and Manufacturing), fluency in tools (BI Publisher, Discoverer, Oracle Reports) and advanced noledge of developer applications, tools, methodologies and best practices.
• Experience in Upgrading OBIEE from 10g to 11g along wif developing OBIEE Repository at all three layers (Physical layer, Business Model and Mapping layer and Presentation layer) and Interactive Dashboards wif drill-down capabilities using Global & Local Filters.
• Proficiency in RPD (11G AND 10G), BI Apps components and Data Modeling (Star and Snow flake schema).
• Installing ODI - configuring standalone agents & Java EE agents and upgrade of ODI.
• Used ODI Designer to develop complex interfaces (mappings) to load the data from the various sources into dimensions and facts.
• Extensively Worked on INFORMATICA Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy and Aggregator.
• Extensive experience wif INFORMATICA Power Center in all phases of Analysis, Design, Development, Implementation and support of Data Warehousing applications using INFORMATICA Power Center 9.x/8.x/7.x.
• Extensive Experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using INFORMATICA Power Center (Workflow Manager, Workflow Monitor, Warehouse Designer, Source Analyzer, Warehouse Designer, Transformation developer, MAPPLET Designer, Mapping Designer, Repository manager, Metadata Manager and INFORMATICA server), INFORMATICA Power Mart, Power Analyzer, Power Connect, Power Exchange OLTP, OLAP, Data Reports.
• Extensive experience wif INFORMATICA Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Normalizer, Union and XML Source Qualifier.
• Configured DAC for creating Execution plans, Metadata Management and Monitoring INFORMATICA ETL process.
• Experience in Full Cycle Implementation and Support of Oracle Distribution modules Oracle Inventory (INV), Purchase Order (PO), Order Management (OM), Shipping (WSH), Account Payables (AP), Account Receivables (AR) and System Administrator.
• Expertise in Procure to Pay, Order to Cash Cycle and RICE (Reports, Interfaces, Conversions, Extensions) components.
• Customizing Reports and Forms using Oracle FORMS 10g/6i/4.5 and REPORTS 10g/6i/4.5.
• Worked on Oracle Implementation Methodology (AIM) to facilitate the implementation and address the complexities. Developed Functional Design Document MD050.
• Work collaboratively wif team members to achieve common goals, while carrying out responsibilities and commitments
• Good noledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, OLTP and Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.
• Full Cycle Implementation and Support of Oracle Distribution modules Purchasing, Inventory & Order Management in R12.
• SR management (Open, Monitor, Update, Close)
• Positive Attitude and Proficient in defining, communicating and fulfilling the project goal and breaking complex issues into manageable parts

TECHNICAL SKILLS

BI Tools: OBIEE 11g/10g, Oracle BI Publisher, BI APPS 7.9.6.x/7.9.5, Data warehouse Administration Console (DAC) 11g/10g

ETL Tools: INFORMATICA Power Center 9.x/8.x, DAC, Oracle Data Integrator (ODI).

ERP Applications: Oracle R12/11i (Inventory, Purchasing, Order Management, Warehouse Management, BOM) and Financials (General ledger, Accounts Payable, Accounts Receivable, System Administrator).

Operating System: Windows 7/NT, Windows 2000/XP, UNIX and LINUX.

Database Tools: MS office, Toad, Data Loader, SQL Loader

Languages: SQL, PL/SQL, UNIX Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential, New York

Sr. OBIEE / OBIA Lead

Responsibilities:

• Determining the Project Needs and establishing a roadmap wif the best practices;
• Providing the Scalability & Expandability Options;
• Governance Model for Execution & Post Support Operations;
• Design, Architect, Propose a strong BI roadmap dat can address the business needs;
• Customer / Business Interaction discussions to gain noledgebase of the business, understand customer needs & devise a user adoption strategy;
• Developed procedures, Packages, interfaces and workflows in ODI.
• Designed and Developed INFORMATICA Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.
• Analyzed, Designed, and Developed OBIEE Metadata repository (RPD).
• Used Oracle BI Administration tool to implemented Multiuser Development Environment (MUDE). Migrated Analytics RPD and Web catalog from one environment to another.
• Responsible for designing, developing and testing of the ETL strategy to populate the data from various source systems (Flat files, MS SQL Server and Oracle) feeds using PL/SQL and ODI.
• Working in developing ETL program for supporting Data Extraction, transformations and loading using ODI (Oracle Data Integrator);
• Developed Unix Shell scripts for maintaining Files and to run INFORMATICA jobs.
• 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.
• Worked on BI Publisher reporting and build complex Data Models, Templates as per the business requirement dat had to return huge data volumes.
• Created INFORMATICA Power Exchange Data maps to pull data from Source Systems and imported the data maps into Source Analyzer by using INFORMATICA Power Center Designer.
• Registering new tasks, creating new subject areas, execution plans table and task actions in DAC.
• Performed the Setup, Installation and Configuration of the complete Analytics platform environment OBIEE, INFORMATICA and DAC and the required connectivity for integration wif the data warehouse.
• 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.
• Configuration of Addition Autantication Provider (LDAP) in Oracle WEBLOGIC;
• Performance tuning and enforcing repository best practice;
• Building and Customizing Security Model in WEBLOGIC for OBIEE;

Environment: BI roadmap, ETL Program, Data Extraction, ODI (Oracle Data Integrator), RPD, LDAP Configuration, INFORMATICA Power Center, INFORMATICA Power Exchange, Oracle WEBLOGIC, Oracle EBS R12, Oracle ERP, Oracle DB 6, 10g, 11g, UNIX Shell Scripting, OBIEE / OBIA.

Confidential

Responsibilities:

• Installation and configuration OBIEE, BI-APPS, INFORMATICA 9 and DAC wif Siebel 8.x;
• Extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using INFORMATICA Power Center and DAC;
• Producing Detailed Designs, which indicate at a low-level which OBIEE components will be configured to support the Business Requirements;
• Worked on extracting data from Oracle EBS, OLTP flat files and integration and loading data to Data Warehouse (OLAP) system.
• Created UNIX Shell scripts and PL/SQL Scripts to automate UNIX and database activities.
• Monitored Incremental and Full load of Data through Data Warehouse Administration Console (DAC) and INFORMATICA Workflow Monitor.
• Worked on BI Publisher importing data from the data source and delivered Reports, common dashboards, metadata, security, calculation, caching, and intelligent request generation services.
• Analyzed, Designed, and Developed OBIEE Metadata repository (RPD) dat consists of Physical Layer, Business Mapping and Model Layer and Presentation Layer
• Used equalizer utility to equalize the RPD before upgrading.
• Used INFORMATICA Power Center Workflow manager for session management, and scheduling of jobs to run in batch process.
• Performing Dimensional Modeling;
• Configuration of LDAP in Oracle WEBLOGIC;
• Performance tuning and enforcing repository best practice;
• Metadata and ETL Specification to support requirement;
• Supporting design and configuration of ETL processes to load the Data Warehouse;
• Building and Customizing Security Model in WEBLOGIC for OBIEE;
• In corporate the business process in different layers of OBIEE me.e. Physical Layer, Business Layer and Presentation Layer;
• Consultant wif Oracle Support through Service Request;

Environment: OBIEE, OBIA Components, BI-APPS, INFORMATICA Power Center, DAC, ODI (Oracle Data Integrator), Oracle EBS R12, Oracle ERP, Oracle DB 10g, 11g, Siebel, ETL Program, Data Extraction, Dimensional Modeling, LDAP, Oracle WEBLOGIC.

Confidential, New Jersey

Senior BI Consultant

Responsibilities:

• Install and Configure OBIEE, BI-APPS, INFORMATICA and DAC wif Oracle EBS 12.1.1;
• Configure Oracle Scheduler and Delivers;
• Developed Customized Dashboards in OBIEE;
• Give Training to Users;
• Identify The Business Process;
• In corporate the business process in different layers of OBIEE me.e. Physical Layer, Business Layer and Presentation Layer;
• Performed the Setup, Installation and Configuration of the complete Analytics platform environment OBIEE, INFORMATICA and DAC and the required connectivity for integration wif the data warehouse.
• Extracted the data from the source system (EBS R12), transformed the data and loaded into the OBIEE analytics warehouse using INFORMATICA.
• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers and dashboards.
• Worked on integrating and configuring BI Publisher wif OBIEE.
• Develop Proposals Wif Team Members;
• Applying Patches of different modules;
• Cloning of Oracle EBS 12.1.1;
• Consultant wif Oracle Support through Service Request;
• Requirement Gathering for OBIEE Dashboards;
• Responsible for ETL Scheduling;
• Working functional on Oracle Financials and Oracle Manufacturing;
• Developed custom forms and reports and integrate in Oracle EBS 12.1.1;
• Upload data through API's and interface.

Environment: OBIEE / OBIA, BI-APPs, INFORMATICA, DAC, ODI (Oracle Data Integrator), Oracle EBS, Oracle ERP, ETL Scheduling, Oracle Scheduler and Delivers, Customized Dashboards.

Confidential

Oracle Apps Consultant

Responsibilities:

• Installation of Oracle E-Business Suite R12.1.1 wif Oracle EBS 12.1.1;
• Install and Configure OBIEE 10.3.4.1, BI-APPS, INFORMATICA 8.6.1 and DAC;
• Configure Oracle Scheduler and Delivers;
• Developed customized dashboards in OBIEE;
• Configure different sources in INFORMATICA and DAC;
• Write customize ETL from different sources in INFORMATICA and call it from DAC;
• Load Oracle REVELEUS Basel II Analytics in OBIEE.
• Customized reports development;
• Data uploading using SQL Loader and APIs;
• Cloning using Perl clone;
• Oracle support through METALINK;
• Oracle Discoverer reports development and integration wif EBS;
• Customize reports development (Report builder, XML Publisher and Discoverer) and integrate wif Oracle EBS
• Patch application, configuration and maintenance scripts etc.
• Prepare technical documentation for the use of new and revised applications
• Gathering, understanding and interpreting business information requirements