SUMMARY

• Over 9+ years of experience in Analysis, Application Development, Maintenance, Implementation on Oracle 11g/10g, Informatica power center 9.x/8.x, OBIEE11g/10g, DAC 10g/11g which include over 5 years of experience in OBIEE/OBIA Reporting.
• Extensive experience as Technical ERP Developer/ConsultantinOracle E - Business Suite Applicationswith expertise in General ledger,Balance Sheet, P&L,Account Payables,Account Receivables,Fixed Assets,Order Management,Iprocurement and Purchasing, Inventory (GL, PL,AP, AR, FA, OM, PO, INV) Oracle BI Applications(OBIA/BI APPS).
• Expertise in providing end-to-end business intelligence solutions using OBIEE.
• Experience in performance tuning of Informatica mappings and sessions, Siebel Analytics Reports, SQL query and using Data Warehouse Administration Console (DAC) to schedule the Informatica jobs and metadata management.
• Experience in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, Oracle BI Apps, Informatica Power Center and DAC.
• Worked with different source systems like Oracle EBS R12 and People Soft FIN SCM 9.1
• Proficient in building analytical repository, and customizing the Oracle BI Apps repository business models, generating reports, and creating dynamic Dashboards using Siebel Analytics/OBIEE.
• Strong experience developing OBIEE Repository (.rpd) at three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Interactive Dashboards with drill-down capabilities using global & local Filters, Security Setup (groups, access / query/report privileges), configured Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages,Folders, Reports) and scheduling iBots.
• Expertise in creating different report views like Table, Pivot, Charts, View/Column selector, Narrative and Union reports.
• Extensively worked on Installation and configuration and in end to end implementations of BI solutions for implementing Financials, Supply Chain Analytics, Procurement and Spend Analytics.
• 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.
• Expertise configuring 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).
• Expertise implementing Oracle BI Apps in all phases like implementing Out of order Box prebuilt mappings, Designing ETL, metadata management using DAC, Creating Oracle provided DataWarehouse, OBIEE RPD development, OBIEE reports and Dashboards
• Expertise in DataWarehouse Administration Console (DAC) to configure, monitor and schedule ETL.
• Good Experience in Performance Tuning of Informatica Mappings.
• Expertise in Developing Mappings, Maplets, Workflows and Sessions using Informatica Power center.
• Expertise in creating, modifying, using and debugging Stored Procedures, Views, User Defined Functions using SQL Server/PL SQL.
• Worked with different SDLC Environments Agile, Iterative, and Water Fall Methodologies.
• Experienced in interacting with users, gathering requirements, and drawing up Business Case Scenarios.

TECHNICAL SKILLS

Oracle Applications: Oracle Financials E-Business suite(EBS) R12/11i (General ledger,Account Payables,Account Receivables,Fixed Assets,Order Management,Iprocurement and Purchasing, Inventory, System Administrator).

BI Tools: OBIEE 10g, 11.1.1.X,OBI Applications 7.9.x

ETL Tools: Informatica Power Center 9.0.2 HotFix, DAC 10.1.3.4.1 / 11 g

Languages: C, C++, C#, Java, SQL, PL/SQL, HTML, XML

Web Servers: IIS, Web Logic Server, Apache Tomcat,OC4J.

Data Bases & Tools: Oracle 11g,10g,9i,8i, SQLServer2005/2000, TOAD, SQL Navigator.

Operating Systems: Windows 98, 2000, 2003 server, XP, LINUX

PROFESSIONAL EXPERIENCE

Confidential, Erlanger, KY

OBIEE/ETL Consultant

Responsibilities:

• Interacting with clients POC to gather business requirements, document them and give a prototype to client for its review.
• Working with Business Analysts in formalizing the User Requirements, report and dashboard layouts.
• Interacting with ETL team for data modeling team.
• Extracted the data from the source systems Oracle,PeopleSoft, DB2, Mainframe flatfiles transformed the data and loaded into the OBIEE analytics warehouse using Informatica.
• Developing the Repository (rpd) and created the subject areas as per the requirements being an agile project where reporting and analysis are centered around using the OBIEE Administration tool.
• Building and configuring the three layers in the OBIEE repository using the Administration tool as and when required.
• Performing Repository Testing and validation before exposing Business Models in the Presentation layer.
• Developing various kinds of summary and detail drill down reports using compound layouts, view selectors.
• Created groups and users to manage the security privileges for each subject area in RPD and dashboards according to user requirements.
• Enhancing and tuning the performance for the reports taking longer time than required.
• Analyzed and Worked on BI/ETL production issues.

Environment: OBIEE 11.1.1.7.1 , Informatica Power Center 9.6.1, Oracle 11g DB, SQL developer, Linux, Windows 7.

Confidential, Atlanta, GA

OBIEE Consultant

Responsibilities:

• Installed and configured OBIEE 10g, Informatica 8.6.x, DAC 10g on new Production and Backup Production servers
• Migrating OBIEE rpd, catalog, Informatica and DAC rpd’s to new Production and Backup Production servers.
• Configured and setup BIPublisher, BIScheduler on Production servers.
• Upgrading OBIEE 10g to 11g and migrating rpd & catalog from 10g to 11g using utility bat file.
• Prepared and Provided Installation & Configuration documentation to the Shared drive for reference.
• Developed reports, prompts, pages under dashboards using different views like Pivot tables, Pie charts, Column selector, View selector and combined with similar requests.
• Manually configured Execution plans and ran ETL jobs in DAC 10g.

Environment: OBIEE 10g/11g, Informatica Power Center 8.6.x/9.0.x,DAC 10g/11g, Oracle 11g/10g, SQL developer,Linux, WinScp, Putty, Xming server,Windows 7.

Confidential, Arlington, VA

OBIEE Consultant

Responsibilities:

• Installed and configured OBIEE 11.1.1.7, Inormatica 9.x, DAC 11g and OBIA 7.9.6.4 Financial Analytics for People Soft sources on Development and Test environments.
• Gathered requirements from the client and performed GAP analysis for GL,BS,P&L and Budget, translated them into technical design documents and worked with team in making recommendations to close the GAP.
• Involved in understanding the GL, BS, AP, AR, P&L, Budget, Asset Management layout, tree structure and report structure formtas from People Soft 9.1 FIN SCM .
• Implemented configuration steps for Financial Analytics for People Soft 9.1 Source before the ETL full data load.
• Used OBIEE Administration Tool 11.1.1.7.1 for customizing and modifying the Physical, Business Model/Mapping and Presentation layers of metadata repository (.rpd)
• Customized and developed new metrics and calculated metrics of GL, BS, P&L, Budget, Asset Mgmt on Business Model & Mapping Layer and Presentation Layer of Oracle Analyticsrepository upon Client requirements And deployed it on the BI server.
• Customized Meta Data Repository (RPD) to work with PeopleSoft Financials (AP, AR, GL, P&L and Budget). Pulled new physical tables to physical layer of RPD, joined them with dimension tables, developed hierarchy and presented them to presentation layer.
• Configuration of OBIEE Security parameters at Object level, Data level, Row level and Dashboard privileges to control access to sensitive customer data and eliminate the ability for users to extract large volumes of data from repositories.
• Worked on Design, Development, Implementation, Testing and Maintenance of Oracle Databases, ETL Processes and Database Deliverables.
• Setup the visibility of Dashboards to employees with respect to their responsibilities. Administered permissions and privileges for Dashboard visibility and modifications to users based on their groups or responsibilities.
• Worked on performing full load using Informatica 9.x & DAC 11g and loading the Financial Analytics data from People Soft 9.1 source into Repository for the purpose of designing and developing of reports & dashboards.
• Coordinated the RPD and Web Catalog objects migration from Development environment to QA environment and then to the Production environment using OBIEE Catalog Manager.
• Worked on subject areas like Financials - General Ledger, Financials - Payables, Financials - Profitability and Financials - Budget.

Environment: OBIEE 11.1.1.7.1 , Oracle BI Apps 7.9.6.4 (Financial Analytics), Weblogic 11g server, Informatica Power Center 9.x,DAC 11g, PeopleSoft FIN SCM 9.1, Oracle 11g/10g, SQL developer,Linux.

Confidential, Newark, NJ

OBIEE Consultant

Responsibilities:

• Performed the setting up, installation and configuration of the complete OBIEE 11.1.1.6 client installations and Procurement and Spend Analytics platform environment and the required connectivity for seamless integration with the Informatica9.1 ETL and DataWarehouse Adminnistration Console (DAC) in all the environments.
• Used OBIEE Administration Tool 11.1.1.6 for customizing and modifying the Physical, Business Model/Mapping and Presentation layers of metadata repository (.rpd)
• Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements.
• Created Logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data, and Repository Variables.
• Implemented security tasks like creating user groups, users and managing users by setting up their privileges and profiles.
• Worked on Design, Development, Implementation, Testing and Maintenance of Oracle Databases, ETL Processes and Database Deliverables.
• Worked with Data warehouse Administration Console (DAC) to schedule and run full and Incremental ETL loads, to schedule the Informatica jobs, and to customize Execution Plans.
• Developed Informatica Mappings/Mapplets using various Transformations (Filter, Expressions, Router, Aggregative, Lookups, Update Strategy) and also in creating Workflows.
• Used Informatica Power Center tools for analysis, design, mapping and workflow.
• Developed mappings in Informatica according to functional/application areas to load the data from source to target tables.
• Developed various transformations like Source Qualifier, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading the data into target table.
• Created Workflows, Tasks, and database connections using Workflow Manager.
• Developed Mappings and Workflows to generate staging files.
• Configured DAC for Procurement & Spend Analytics and extracted data through Informatica.
• Developed Mappings and Workflows to load the data into Oracle tables.
• Developed complex Informatica mappings and tuned them for better performance.
• Created shell scripts to run the daily ETL loads on AutoSys tool instead of using DAC. Maintained and supported the AutoSys tool whenever ETL load run shows failed status.
• Created and tested Contingency plan if any fail-over ETL load exists on Active servers.
• Tested data in all environments such as DEV, UNIT, QA, PROD and worked closely with production support team to resolve any issues.

Environment: OBIEE 11.1.1.6.1 , Oracle EBS R12.1.3, Oracle BI Apps 7.9.6.3 (Procurement & Spend Analytics), Weblogic 11g server, Informatica Power Center 9.1, Oracle 11g/10g, DAC 10.1.3.4.1 , DB Artisan, SQL Developer, Windows XP.

Confidential, San Mateo, CA

OBIEE Consultant

Responsibilities:

• Performed the setting up, installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration with the DataWarehouse.
• Performed Upgrade of OBIEE from 10g to 11g. Setting up the environment. Installing 11g client on the server.
• Upgrade all 10g environment reports and Dashboards to 11g, performed Unit testing in all environment: s.
• Installed and configured OBIEE, DAC and Informatica on Unix/Linux Environment.
• Worked on integrating and configuring BI Publisher with OBIEE.
• Experience of installation of OBIEE 11G on Windows Single Server and Clustered.
• Used ETL processes to load data from Flat files, Oracle Databases into the target OLAP databases.
• 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.
• Extracted various sources like Oracle tables and imported Flat files using Informatica Power Center.
• Customized Oracle BI metadata in the analytics repository with Oracle BI Administration Tool.
• Customized the Repository by creating Facts and Dimensions and adding extra columns to the Existing Facts and Dimensions.
• Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool.
• Configured DAC for Financial Analytics and extracted data through Informatica.
• Used Informatica Power Center tools for analysis, design, mapping and workflow.
• Develop mappings in Informatica according to functional/application areas to load the data from source to target tables.
• Implemented row and data level security on subject areas, dashboards and reports.
• Involved in configuring and customizing sources, targets, tasks and execution plans using DAC.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Migrated Analytics RPD and Webcat from one environment to another.
• Developed Complex Reports by using the Different Views like Table, Pivot, Chart, Column Selector, View Selector and Combined with Similar Requests.
• Experience managing and coordinating onsite/offshore Model.
• Configured IBOT’s for delivering alerts and for Cache Seeding.
• Built the Physical Layer /Business Model and Mapping Layer/Presentation Layer of a Repository by using Star and snowflake Schemas.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Enhanced performance of Reports/Dashboards by implementing the Materialized Views, Table partitions, re-building of indexes and managing Cache etc.

Environment: Oracle Applications 11i/R12 General Ledger, Accounts Payables, Accounts Receivable, Inventory, Purchasing,Fixed Assets, OBIEE 11.1.1.3/ 10.1.3.4.1 , Oracle BI Apps 7.9.6.1, Informatica Power Center 8.6.1, Oracle 11g, PL/SQL, DAC 10.1.3.4.1 , Toad, Linux, File-Zilla.

Confidential, Memphis, TN

OBIEE Consultant

Responsibilities:

• Involved in installation and configuration of OBIEE with Informatica and Responsible for setting up the environment including installation of OBIEE, BI Apps and Informatica in all the environments.
• Analyzed,Designed,and Developed OBIEE/Siebel Analytics Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer, and Presentation Layer.
• Migrated Repository and Catalog between environments like Dev, Test, QA, maintenance and Performance.
• Experience working with Metadata architecture and dashboard design.
• Created Views and Aliases in physical layers for performance tuning.
• Worked According to Agile Environment to meet Deadlines on time.
• Worked on administration ofOBIEECache management, Security Management for Users, groups and web groups using the various authentication system such as LDAP Authentication using Session variable as well as Dash board / Report level Security.
• Developed different kinds of Reports (Pivots, Charts, Tabular) using global and local Filters.
• Configured the Anlaytics repository(RPD) and implemented the security to authenticate and authorize Oracle EBS users.
• Configured IBOTS and Delivers and created proactive iBots and interactive Dashboards to alert the Marketing team about business changes.
• Performed Data Validation on the reports.
• Executed the SQL queries using SQL Developer.
• Responsible for configuring the informatica Source and lookup files.
• Custumized the existing informatica repository and added new mappings and workflows based on the requirements.
• Developed custom Reports/Ad-hoc queries using Seibel Answers and assigned them to application specific dashboards.
• Developed different kinds of Reports (Pivots, Charts, Tabular) using global and local Filters.
• Configured Report Navigation (Column and Value) to achieve navigation between the reports in Answers.
• Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.
• Created and ran Sessions & Workflows to load the data into the Data warehouse.
• Customized Expected Receipts Reports, Journal Entries Report and Billing History Report in Account Receivables using XML/BI Publisher.
• Used XML/BI Publisher for Multi language reporting purpose.
• Developed and configured various reports in BI Publisher such as vendor listing, AP Invoices and Check Printing
• Developed reports in GL like Bonus Accrual-Units, Bonus Accrual-Area Supervisor, Inter company transaction detail report, Hyperion Trial Balance using BI publisher.
• Performed tuning in Informatica Source and Target and Mapping and Target and Session level and oracle query tuning.
• Involved in Unit Testing, Peer Testing & Regression Testing.
• Conducted training Sessions on Informatica power center and OBIEE.
• Designed, implemented and tested security privileges on subject areas, dashboards and reports.

Environment: Oracle Applications R12, Service Requests,Service Contracts,Install Base,General Ledger, Account Payables, Accounts Receivable,Inventory, Order Management, Oracle Purchasing,Oracle 9i (9.2.0), XML/BI Publisher 5.6.3, OBIEE,Discoverer 10g,Repots10g,SQL*PLUS, SQL*Loader, TOAD, PL/SQL, Unix.

Confidential, Phoenix, AZ

OBIEE Consultant

Responsibilities:

• Installed Siebel Analytics/OBIEE and related components for development, QA and production environments.
• Involved in development and review of System documentation
• Created and customized intelligence Dashboards in Oracle Business Intelligence to suit the client’s requirements.
• Created different types of Customized Reports (Drilldown, Aggregation) to meet client requirements Involved in the installing and configuring of Financial Analytics.
• Setup Multi User Development Environment (MUDE) in OBIEE.
• Designed and developed General Ledger, Payables, Receivables and Profitability Dashboards in OBIEE.
• Developed Dashboard pages like Liquidity,GL Balance,Cash Flow and Balance Sheet in General Ledger Dashboard.
• Developed Dashboard pages like AP Balance,Overview,Payments Due,Supplier Details and Invoice Details in Payables Dashboard.
• Developed Dashboard pages like AR Balance,Payments Due,Invoice Details and All AR Transactions in Receivables Dashboard.
• Developed Dashboard pages like Overview,Margins,Revenue,Products and Customers in Profitability Dashboard.
• Administering the OBIEE Dashboards and Reports, Data Visibility.
• Installed, Configured Data Warehouse Administration Console (DAC) and Monitored Incremental and Full load of Data through DAC and Informatica WorkFlow Monitor.
• Responsible for extracting data from Oracle Apps Modules and loading into stage system and warehouse system.
• Developed Mappings using corresponding Source,Targets and Transformations like Sequence Generator,Source Qualifier, Router,Filter,, Joiner, Lookup, Expression, Aggregator and Update Strategy.
• Worked extensively in Oracle BI Security, Web Object Security and Data Level Security.
• Created Presentation catalogs and Folders in Presentation Layer and Performed Global Consistency Check in Oracle BI Administration Tool.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Executed the SQL queries using TOAD.
• Utilized the BI Publisher tool functionality for creating pixel perfect reports and report templates.

Environment: Oracle Applications 11i/R12 iProcurement, General Ledger, Account Payables, Accounts Receivables,Fixed Assets, BI Apps 7.9.5, OBIEE 10.1.3.4.0/10.1..3.3/10.1..3.2 , Oracle 10g, Informatica 8.1.1, DAC 7.9.5, XML/BI Publisher 5.6.3, Discoverer 10g/4i/3i, PL/SQL, SQL*PLUS, SQL*Loader, TOAD,Unix.

Confidential, Sunnyvale, CA

Oracle Applications and OBIEE Consultant

Responsibilities:

• Gathered and analyzed the Business Requirements in collaboration with theSales, Marketing andFinanceSMEs, Business Analysts and users.
• Part of the installation team to install OBIEE BI Apps.
• Designed and Developed Financial Dashboard like General Ledger,Payables,Receivables.
• Created AD hoc reports in Acount Payables.
• Worked extensively on OBIEE Answers to create the reports as per the client requirements.
• Created reports in Answers and embedded them in Dashboards according to the requirements.
• Used Analytics ODBC client to perform query validation.
• Created customized dashboard prompts as per the business requirement
• Developed calculated measures and assigned aggregation levels based on dimension hierarchies.
• Created Alias and configured repository with logical dimensional modeling using star schema.
• Involved in creating data sources for connecting to the database utility
• Created Dashboard prompts and advance filter criteria.
• Customized GL Detailed Trial balance report, GL Period to Date Balances reports in General Ledger using FSG’s.
• Designed and developed Customer Interface, Auto Lockbox Interface.
• Designed Customer Products Summary Report in Install base using OBIEE.
• Worked on Service Contract interface program by using the standard API’s.
• Generated Inter Company Transaction Detail Report, Open-Debit Memo Report in General Ledger using Reports 6i.
• Customized Supplier Payment History Report in Account Payables to meet client requirements.
• Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the sql execution path by making use of hints etc
• Worked closely with Users, Developers and Administrators to resolve ongoing Production issue.

Environment: Oracle Applications 11i (11.5.10) General Ledger, Account Payables, Accounts Receivable,Inventory, OBIEE 10.1.3.2, XML/BI Publisher 5.6.3, Discoverer 10g, SQL*PLUS, SQL*Loader, TOAD, Unix.

Confidential

PL/SQL Developer

Responsibilities:

• Interface with Customers Management Team to capture and analyze business requirements.
• Worked with a team of IT developers in the Initial Database Design/Data Modeling/Data approval.
• Creating database objects including tables, indexes, clusters, sequences, roles, and privileges.
• Loading data from flat files into database tables using SQL* loader.
• Calculating and monitoring size and space for tables, clusters and indexes.
• Creating and maintaining triggers, packages, functions and procedures.
• Created users and established the application security by creating roles.
• Writing PL/SQL Stored Procedures, Functions, views, & Triggers for the application.
• Optimized the embedded SQL queries using statement level optimizer hints when essential, to adhere to the defined OLTP response time.
• Importing/Exporting data from/to different databases using utilities like SQL*Loader, Import/Export.
• Unit testing and monitoring performance and providing System support.

Environment: Oracle 8i, Flat files, MS Access, SQL Plus, SQL LOADER, and Windows NT.