SUMMARY

• Dedicated IT professional with 7+years of progressive expertise in design, configuration, development, testing and implementation of Data warehousing Oracle Business Intelligence Developer (OBIEE 11g/10g and BI Publisher) Over 3+ years of experience in Information Technology designing, developing, architecture, administration and implementation of Business Intelligence, Data Warehouse Applications under different environments. Core focus on Data Warehousing and ETL tools OBIA 7.9.6 / 7.9.5 Financials, Procurement & Spend and Order Management Analytics.
• Experience as Oracle Business Intelligence Developer in different Business Applications, Oracle Applications R12/11i (E - Business Suite) Consultant, Technical Developer with expertise in Oracle Manufacturing Modules (OM, INV, PO, WSH), Financials modules (GL, AP, AR) and System Administrator.
• Experience in Business Intelligence and Transactional applications, Design and Implementation of Data Warehouse/Data Mart, Gathering Business User Requirements, System Analysis, Design and Data Modeling.
• Strong experience in 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.
• Experience in developing Dimensional Hierarchies, New Logical Columns, Filters and Variables as per business requirements.
• Experience in data warehousing such as dimensional modeling, star and snowflake schemas, data marts, fact and dimension tables identification.
• Experience with scheduling tool Data Warehouse Administration Console (DAC) to configure, monitor and schedule ETL routines of the Oracle Business Analytics Warehouse.
• Extensively used Informatica Designer to create and manipulate source definitions, target definitions, mappings, mapplets, and transformations.
• Well versed with using SQL and PL/SQL for BI Publisher and XML Publisher.
• Developed different types of reports including RTF, EXCEL, and ETEXT TEMPLATES.
• 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.
• Excellent communication skills, ability to meet tight deadlines and prioritize tasks.

TECHNICAL SKILLS

Development Tools: Informatica Power Center 7.1, Business Objects XIR2, and UNIX.

Languages: Oracle SQL, PL/SQL and UNIX shell scripts.

Database: Oracle10g/9i, Teradata 8.1, SQL Server, DB2 8.0.

PROFESSIONAL EXPERIENCE

Confidential, Rockville, MD

OBIEE/OBIA Consultant

Responsibilities:

• Worked with Business Groups to identify, analyze, and document Business Requirements.
• Using the OBIEE 11.1.1.5 Administration tool to develop and enhance RPD and meta-data objects
• Designing, Developing/Enhancing and Testing the Physical Layer, Business Layer and Presentation Layer of OBIEE 11g
• Designing, Creating/Enhancing and Testing Report(s) in the Dashboard and created the adhoc reports according to the end user need.
• Developed Dashboards / Reports using different Views (Pivot Table, Chart and Column Selector, view Selector), with drill-down and drill across capabilities, guided navigation and dashboard and page prompts.
• Create connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository as per the Standards
• Created numerous executive level reports and dashboards were generated to provide insight into the claim/claim transaction/Diagnosis/Procedure/Member/Provider/Third Party data
• Designed Schemas using Fact, Dimensions, Hierarchical, Physical, Logical, Alias and Extension tables with star and snow flake architecture
• Performed OBIEE Admin works likenew ID creation, Account modification of existing users, Password reset and Deletion of accounts.
• Developed Unit and System test plans and participated in resolution of bugs in OBIEE suite.
• Customized Dashboard pages like Overview, Budget vs. Actual, Asset usage, Financial Structure, GL Balance, Cash Flow and Balance Sheet in General Ledger Dashboard (GL)
• Customized Payments Due, Payment Performance, Customer Report dashboard pages in Account Receivables (AR).
• Created business reports using Analysis within OBIEE 11g
• Analyze Design, and Develop OBIEE Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer, and Presentation Layer.
• Implemented Financial Analytics. Integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).
• Supporting and coordinating onsite/offshore teams
• Was part of the Essbase OBIEE integration to bring Budget and Forecast information into OBIEE.
• Worked with ETL Team for enhancement to Facts / Dimensions in developing the Initial and Incremental ETL process.
• Actively participated in meetings with Project Managers, Business Users and Business Analysts during testing and deployment stage of the application development lifecycle.

Environment: OBIEE 11.1.1.6.9 , BI Apps 7.9.6.4, DAC 11.1.1.6.4 , Informatica 9.0.1, Oracle EBS Apps, Red-Hat Linux, Oracle 11g (11.1.0.7.0 ), SQL Developer.

Confidential, Salt Lake City, UT

OBIEE/OBIA 11g PeopleSoft Consultant

Responsibilities:

• Worked with key project management team and business people to formulate and communicate the business vision for the project and mapping out the initial requirements in Financial Analytics, Supply Chain Analytics and HR Analytics.
• Responsible for Security design and development of an Enterprise data warehouse and BI system.
• Worked collaboratively with other internal business groups and IT technical groups to define Data Warehouse models and Business users Dashboards. Worked with system admins in Installation and Configuration of OBIEE Applications (OBIEE Server, OBIEE Apps, DAC, Informatica and BI Publisher).
• Working on Oracle/PeopleSoft reports on OBIEE for GL, AP and Projects.
• Created Budget vs Actual report with details drill down for each Cost Center.
• Created/Modified/ Customized Metadata repository (.rpd) and Configured Metadata Objects using OBIEE Admin tool.
• Working BI APPs 7.9.6.3 / BIP reports and create/update the Technical Documents.
• Developed and implemented the coding of Informatica Mapping for the different stages of ETL (SDE/SIL/PLP).

Environment: OBIEE 11.1.1.6.8 , BI Apps 7.9.6.3, DAC 10g, Informatica 9.0.1, PeopleSoft 9.1, Oracle EBS R12, Oracle / Red-Hat Linux, Oracle 11g (11.1.0.7.0 ), SQL Developer.

Confidential, Rutland, VT

OBIA/INFORMATICA CONSULTANT

Responsibilities:

• Involved with Finance Team and users to gather requirements
• Actively Interacted with project managers & team members to discuss timely deliverables, project status & documented technical specifications from functional specifications in reporting point of view
• Customized OBIEE repository by adding custom columns and tables using BI administration tool
• Identified Financial Analytics facts, dimensions & star schema models to create custom subject area
• Created Materialized Views to look up Organization Hierarchy Descriptions for OOTB Hierarchy tables
• Informatica Power center 9.0.1 is used to load the Oracle EBS data into OBAW using Source Dependent Extracts (SDEs) & Source Independent Loads (SILOs), PLP and Custom Folders
• Based on user requirements, DAC tasks and Informatica mappings were debugged and DAC parameters were changed to load multiple Subject Areas into OBA Warehouse.
• Involved in preparing system requirement specification and design document to provide an overview of the technical design specifications required for the warehouse enhancements
• Involved in customizing Account Receivables, Accounts Payables and Oracle GL Subject Areas and corresponding dashboards as per user requirements
• Created 8 new mappings and modified several existing mappings as per the business requirements
• Modified the account and product hierarchies by assigning custom attributes to various levels in the hierarchy tree structure
• Involved in discussions with EBS team and other team members in identifying dimension and fact tables and modeling into star schema, developing dimensional Hierarchies, level based measures to build Fixed Assets.
• Configured Informatica custom workflows & synchronized with DAC tasks for routine scheduling
• Took back-up of DAC, BI & Informatica repositories and BI Web catalogs
• Involved in Knowledge transfer to GMP Developer on various issues and product maintenance

Environment: OBIEE 11.1.1.6.9 , BI Apps 7.9.6.4, DAC 11.1.1.6.4 , Informatica 9.0.1, Oracle EBS Apps, Red-Hat Linux, Oracle 11g (11.1.0.7.0 ), SQL Developer.

Confidential, Albany, NY

OBIEE/BI Publisher consultant

Responsibilities:

• Worked with Business Groups to identify, analyze, and document Business Requirements.
• Using the OBIEE 11.1.1.5 Administration tool to develop and enhance RPD and meta-data objects
• Designing, Developing/Enhancing and Testing the Physical Layer, Business Layer and Presentation Layer of OBIEE 11g
• Designing, Creating/Enhancing and Testing Report(s) in the Dashboard and created the adhoc reports according to the end user need
• Create connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository as per the Standards
• Created numerous executive level reports and dashboards were generated to provide insight into the claim/claim transaction/Diagnosis/Procedure/Member/Provider/Third Party data
• Designed Schemas using Fact, Dimensions, Hierarchical, Physical, Logical, Alias and Extension tables with star and snow flake architecture
• Created business reports using Analysis within OBIEE 11g
• Generated various Analytics Reports like Formulary Report, Diagnosis Report, Claim Detail Report (for Member/Provider) etc. using global and local filters
• Developed different kinds of Reports (pivots, charts, tabular) using Filters
• Schedule reports as per the requirement using BI Publisher and represented them in Web Application (dynamic/static scheduling)
• Burst BI Publisher reports for each units within NYDOH and publish them
• Managed day-to-day RPD using MUD and manage Schedulers, Agents
• Managed security privileges for each subject area and dashboards according to user requirements
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance
• Created Data Model documents for Purchase Orders, expense and Accounts Payables Modules
• Extensively used XML as data sources
• Analyze Design, and Develop OBIEE Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer, and Presentation Layer.
• Implemented Financial Analytics. Integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).
• Configured OBIEE, DAC and Informatica on Unix/Linux Environment.
• 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.
• Setup of Multi User Development Environment (MUDE) in OBIEE
• Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.

Environment: OBIEE 11.1.1.5/10.1.3.4 , BI Publisher 11g/10g, OBIA/BI APPS 7.9.6.x/7.9.5, DAC 10.13.4, Informatica Power Center 8.6.1, XML/BI publisher 11g/10g, TOAD, SQL, PLSQL.

Confidential, Houston, Texas

OBIEE/ ETL Developer

Responsibilities:

• Primary responsibilities includegathering business requirements, designing the functional and technical specifications.
• Involved in Creating and Administering the Physical Layer, Business Model & Mapping Layer and Presentation LayerusingOracle Business IntelligenceAdmin tool.
• Createdconnection pools, physical tables, definedjoinsand implemented authorizations in the physical layer of the repository.
• Created Dimensional Hierarchy, Level based Measures andAggregate navigationinBMM layer
• Managed security privileges for each subject area and dashboards according to user requirements
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Developed customreports/Ad-hocqueries usingOracle Answersand assigned them to application specific dashboards.
• Developed different kinds ofReports(pivots, charts, tabular) using global and local Filters.
• Created proactive agentsiBotsand interactive Dashboards to alert the financial team about business changes.
• Managed OracleDelivers,Scheduler & iBots.
• Handled Full load and refresh load viastagingtables in theETLLayer.
• Involved inDesignandData ModelingusingStar schema.
• Developed several mappings to load data from multiple sources to data warehouse.
• Developed and testedStore procedures, FunctionsandpackagesinPL/SQL for Data ETL.

Environment: OBIEE 11g/10g, Oracle BI Publisher 11g/10g, Oracle Applications R12, 11i (General Ledger, Accounts Receivables, Account Payables, Purchase Order, Supply Chain (SCM)), Oracle 11g/10g, Siebel CRM, Informatica 8.x, DAC 10.1.3.4.1 , PL/SQL, SQL, TOAD.

Confidential, Jersey City, NJ

OBIEE Developer

Responsibilities:

• Created security groups in repository, web groups in presentation services and configured privileges for security groups in Administration
• Strong experience in OBIEE analytics Repository (.rpd) - three layers (physical layer, Business model and Presentation layer).
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.
• Created hierarchies, complex and foreign joins, initialization blocks for repository or session variables, presentation variables in answers calculations, aggregates, partitions, fragmentations and slowly changing dimensions.
• Documented the Requirements and implemented a Design Solution for the BI Architecture.
• Granting access to users and maintain security by using database authentication and authorization.
• Implemented Type-II Slowly Changing Dimension (SCD) logic in OBIEE environment.
• Customized Trends, Balances, Returns and Bill of Materials in Inventory and Forecast, Revenue, Effectiveness, Customer Report OOB dashboard pages in Order Management (OM) Analytics.
• Customized Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee expenses OOB dashboard pages in Procurement and Spend Analytics.
• Developed balance sheet, profit and loss statement using BI Publisher.
• Provided reports in Financials by gathering business requirements from Business users.
• Registered the Templates and Data Definitions using XML Publisher Administrator responsibility.
• Setup Multi User Development Environment (MUDE) in OBIEE.
• Integrated OBIEE with EBS for Single Sign On (SSO).
• Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBots queries to obtain daily and weekly reports.

Environment: OBIEE 10.X, BI Publisher, Oracle 11g, DAC 10.13.4, Informatica Power Center 8.6.1, OBIA/BI APPS 7.9.6.x/7.9.5, SQL Developer, SVN Client, Linux, Windows, SAP.

Confidential

Informatica Developer

Responsibilities:

• Extraction, Transformation and Loading of the data using Informatica.
• Develop Mappings and Workflows to generate staging files.
• Develop Mappings and Workflows to load the data from DB2&XML files into Db2 tables.
• Developed various transformations like Source Qualifier, Sorter transformation, Joiner transformation, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading the data into target table.
• Created multiple mapplets.
• Created Workflows, Tasks, database connections using Workflow Manager
• Involving in extracting the data from Oracle, DB2, CSV and Flat files
• Implemented performance tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions to improve performance Understanding the Functional Requirements.
• Responsible for identifying the missed records in different stages from source to target and resolving the issue
• Extensively worked in the performance tuning for mappings and ETL procedures both at mapping and session level.