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.
• Create High and low level design document (HLD/ LLD).
• 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 knowledge 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 teh data from teh 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 teh implementation and address teh complexities. Developed Functional Design Document MD050.
• Work collaboratively wif team members to achieve common goals, while carrying out responsibilities and commitments
• Good knowledge 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 teh 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 EBS R12/11i (Inventory, Purchasing, Order Management, EAM, Warehouse Management, BOM) and Financials (General ledger, Accounts Payable, Accounts Receivable, System Administrator). Siebel CRM.

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

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

Languages: SQL, PL/SQL.

PROFESSIONAL EXPERIENCE

Confidential, New York

Sr. INFORMATICA Lead

Responsibilities:

• Installation and configuration OBIEE, BI-APPS, INFORMATICA 9 and DAC using Siebel 8.x as source;
• Design start scheme data model in OBIEE by using Siebel Data Model;
• Create High and low level design document ( HLD/ LLD).
• Determining teh Project Needs and establishing a roadmap wif teh best practices;
• Providing teh Scalability & Expandability Options;
• Governance Model for Execution & Post Support Operations;
• Design, Architect, Propose a strong BI roadmap dat can address teh business needs;
• Customer / Business Interaction discussions to gain knowledgebase of teh business, understand customer needs & devise a user adoption strategy;
• Developed procedures, Packages, interfaces and workflows in ODI.
• Responsible to manage OBIEE Multiuser Development MUDE.
• Designed and Developed INFORMATICA Mappings from Scratch to Load teh 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 teh ETL strategy to populate teh 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);
• 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 teh business requirement dat had to return huge data volumes.
• Created INFORMATICA Power Exchange Data maps to pull data from Source Systems and imported teh 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 teh Setup, Installation and Configuration of teh complete Analytics platform environment OBIEE, INFORMATICA and DAC and teh required connectivity for integration wif teh data warehouse.
• Designed and modified ETL Mappings using INFORMATICA from Scratch to load teh Data from Source System (EBS) to staging system (SDE mappings) and to teh target Analytics Warehouse.
• Configuration of Addition Authentication 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, OBIEE / OBIA.

Confidential

Responsibilities:

• Installation and configuration OBIEE, BI-APPS, INFORMATICA 9 and DAC using Siebel 8.x as source;
• 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 teh Business Requirements;
• Worked on extracting data from Oracle EBS, OLTP flat files and integration and loading data to Data Warehouse (OLAP) system.
• Monitored Incremental and Full load of Data through Data Warehouse Administration Console (DAC) and INFORMATICA Workflow Monitor.
• Worked on BI Publisher importing data from teh 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 teh 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 teh Data Warehouse;
• Building and Customizing Security Model in WEBLOGIC for OBIEE;
• In corporate teh 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, Siebel, ETL Program, Data Extraction, Dimensional Modeling, LDAP, Oracle WEBLOGIC.

Confidential, New Jersey

Senior BI Consultant

Responsibilities:

• Install and Configure OBIEE, BI-APPS(Financial& Basel Analytics), INFORMATICA and DAC wif Oracle EBS 12.1.1;
• Configure Oracle Scheduler and Delivers;
• Developed Customized Dashboards in OBIEE;
• Give Training to Users;
• Identify Teh Business Process;
• In corporate teh business process in different layers of OBIEE me.e. Physical Layer, Business Layer and Presentation Layer;
• Performed teh Setup, Installation and Configuration of teh complete Analytics platform environment OBIEE, INFORMATICA and DAC and teh required connectivity for integration wif teh data warehouse.
• Extracted teh data from teh source system (EBS R12), transformed teh data and loaded into teh 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, 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(Financial Analytics), 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 teh use of new and revised applications
• Gathering, understanding and interpreting business information requirements

Environment: OBIEE BI-Apps, Oracle ERP, EBS, INFORMATICA, DAC, ETL, Oracle Scheduler and Delivers.