SUMMARY

• 8 years of information technology experience with specialization in data warehousing, ETL and BI.
• 7+ years of experience in customization and configuration of Oracle Business Intelligence Suite Enterprise Edition (OBIEE).
• 5+ years of experience in ETL tool Informatica Power - Center and extensive development knowledge of OBIA out of the box Informatica adaptors.
• 6+ years of experience in customization of Oracle BI Apps solution (OBIA) for various domains such as Financial, Procurement to Pay (PTP), Supply Chain.
• Good functional Knowledge in Accounting/Finance domain.
• 5+ years of experience in using Oracle R12 as a source system.
• Experience in development of complex OBIEE reports involving Combined Requests, Filter value from other reports and complex prompt selections.
• Extensive experience in development of OBIEE RPD Administration, involving complex data modeling, Aggregate table, Multiple Fact tables, Snow-Flake Schemas.
• Experience in development of Row level security on OBIEE Reports as well as configuring the Object level security.
• Experience in configuring the scheduler of OBIEE as well developing ibots (Emails) to deliver the reports to users.
• Experience in performance tuning of OBIEE Reports involving SQL tuning, Using Oracle Hints, Aggregate tables, Cache Management.
• Experience in developing complete ETL solution using Informatica that involves development of mappings, sessions and workflows using Mapping Designer, Workflow Manager and Workflow Monitor.
• Extensive experience of developing complex mapping in Informatica using Lookup, Update, Sequence generator, Expression, Joiner, parameters, variables etc.
• Experience in developing data models having Dimensions, Hierarchies, Facts, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Very good understanding of SDE, SIL and PLP mappings used in Oracle BI Apps solutions.
• Strong Knowledge of Entity-Relationship concept, Facts and Dimensions tables, Slowly Changing Dimensions and Dimensional Modeling such as Star Schema and Snow Schema.

PROFESSIONAL EXPERIENCE

Confidential, Oakbrook, IL

BI Business Analyst/OBIEE Developer

Responsibilities:

• Involved in building the OBIEE 11g report Mockups using Microsoft Excel as source.
• Involved in the requirement gathering for RP&A reports.
• Demonstrated the functionality of OBIEE to Business analysts and Users. Provided mock ups of new features of OBIEE 11g. (Hierarchy Columns, Ragged and Skip Level Hierarchies)
• Involved in the OBIEE 11g Mobile apps solutions, Single Sign on and Single Socket Layer Configurations.
• Involved in creating the benchmarks for OBIEE while integrating the multi-dimensional and Relational database considering the present scenarios of database outline of IOP Confidential Corp.
• Architect the security for both projects, which involved data level security as well as Object level security in OBIEE.
• Wrote conversion scripts usingSQL, PL/SQL, stored procedures, functionsandpackagesto migrate data from SQL server database to Oracle database.
• Lead off-shore team for major issues during Upgrade Project.
• Involved in all the testing jobs involving Unit testing, Integration testing and User Acceptance testing.

Environment: Oracle Business Intelligence Enterprise Edition 11.1.1.7/11.1.1.6/10.1.3.4.2 , Hyperion Planning

Confidential, Atlanta, GA

OBIEE and ETL Developer

Responsibilities:

• Helped Business Analysts, SMEs and Users to understand the functionality and achievability of OBIEE so they can make the best possible use of same.
• Performed GAP Analysis on existing OOTB OBIEE reports and Oracle Data warehouse with customization for new reports.
• Converted Functional design Document (FDD) to Technical design documents (TDD) for OBIEE and Informatica.
• Involved in developing high profile Financial reports involving Budgets and actual for whole Confidential ’s Corporation.
• Involved in developing Supply Chain reports involving inventory control, supply chain and order management.
• Trouble shooting the complex issues faced by other developers during development.
• Debugging the already developed reports and Informatica code, Confidential ’s was using HP Quality Center for managing the Defects.
• Resolving the major issues involving the data modeling with our Data modeling team and Oracle associates.
• Managed migration of code for three Confidential ’s Project Releases.
• Worked on Performance Tuning on Informatica code as well as OBIEE Reports.
• Configured Physical Layer in Repository: Import tables, Create Tables, add/change Physical Joins/keys.
• Configured Logical Layer in Repository: Create Logical tables/dimensions, Columns, Create logical Joins/keys, Set Levels to support Drill-Down, Aggregation/ Sum over Columns /Dimension Hierarchies to achieve the drill down functionality.
• Configured Presentation Layer in Repository: Create Folders/Sub Folders, Standard Queries for different user Groups. Create YTD Variation using Presentation Layer.
• Created Pivot tables, line chart, column charts and bar graphs and also used navigations according to the requirement.
• Developed SDE, SIL and PLP mappings for customized informatica code.
• Configured SQL Qualifier, Look up, Update, Expression, Filter and Stored Processor Transformation in informatica.
• Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart.
• Involved in designing the mappings, mapplets and reusable transformations.

Environment: Oracle Business Intelligence Application, 10.1.3.4, Informatica, DAC (Data warehouse Administration Console).

Confidential, Atlanta, GA

BI Business Analyst/OBIEE Developer

Responsibilities:

• Interacted with Subject Matter Experts (SME), Business Analysts and Users for gathering the business and reports / dashboards requirements.
• Performed GAP Analysis to gather functional mapping by coordinating with the Business Users to gather the data required for analysis.
• Worked in full SDLC Analysis, Design, Develop and Production Environment.
• Involved in Integration of OBIEE Administration and Presentation services with Oracle EBS R12.
• Evaluation and Review of business model based on Functional Design Document (FDD) and Technical Design Document (TDD) for Physical, Business and Presentation layers.
• Configured Physical Layer in Repository: Import tables, Create Tables, add/change Physical Joins/keys.
• Configured Logical Layer in Repository: Create Logical tables/dimensions, Columns, Create logical Joins/keys, Set Levels to support Drill-Down, Aggregation/ Sum over Columns /Dimension Hierarchies to achieve the drill down functionality.
• Configured Presentation Layer in Repository: Create Folders/Sub Folders, Standard Queries for different user Groups. Create YTD Variation using Presentation Layer.
• Created Pivot tables, line chart, column charts and bar graphs and also used navigations according to the requirement.
• Involved in security configuration of user group in OBIEE using existed LDAP Server.
• Created reports involving maps and also analytics with drill down capability on the maps.
• Multiuser Development Environment (MUDE) has been configured for Administration Tool to support for multiple users for the development environment.
• Configured the BI Scheduler to configure the Delivers/iBots mechanism.
• Involved in unit, integrate and user acceptance testing of the reports generated using OBIEE.

Environment: Oracle Business Intelligence 10.1.3.4, Oracle E-Business Suite R12, Oracle 8i/9i, DAC (Data warehouse Administration Console).