Summary of Experience:

• 7 years of experience in gathering Business Requirements, Analysis, Design, Development, Testing and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence
• Extensive BI and Data warehousing experience using OBIEE 11.1.1.5/ 10.1.3.x, OBIA 7.9.x, Informatica 8.6,Oracle data integrator 11g and SQL, PL/SQL.
• Extensive experience in OBIEE Administration Tool, OBI Answers, OBI Intelligent Dashboards, OBI Publisher, Delivers and iBots with OBIEE Applications.
• Experience in developing Dimensional Hierarchies/Creating Aggregate Measures/Aggregate Tables/New logical columns/Filters/Variables/Time Series Functions as per business requirements
• Proficient in configuring Security settings at various levels both in Repository level OBIEE Administration Tool to setup Groups, Access Privileges and Query Limits and Presentation Catalog level.
• Experience Integrating LDAP Server for authentication of users.
• Experience developing reports dashboards in OBIEE BI Publisher, Dashboard, Answers, Delivers, Oracle BI for Microsoft Office .
• Expertise in Creating Dynamic Dashboards and OBIEE Answers using Prompts, Filters, Calculations, Charts, Pivot tables, View Selector and Conditional Formatting.
• Experience in migration techniques for OBIEE components into various test and production environments.
• Strong understanding of OBIEE 11g concepts, especially in configuring Security settings using Weblogic Server Users and Groups , Oracle Enterprise Manager OEM for Roles and Privileges and Presentation Catalog.
• Strong Knowledge and understanding of Relational Databases Oracle and SQL Server , data warehousing concepts and querying tools.
• Skilled in data warehouse methodology, data analysis and modeling, business intelligence architectures, report development, ETL development, and database design.
• Created Test cases and Tested the Reports/Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.
• Experience in designing and testing mappings, mapplets and workflows using Informatica Power Center.
• Experience in designing and testing Interfaces,senarious and packages using Oracle data integrator
• Experience with Oracle EBS concepts of Financial Analytics, Spend Analytics and Supply Chain modules.
• Worked on different subject areas of AP, AR and GL to create Reports and Dashboards according to the business requirements.
• Very strong in Oracle PL/SQL programs, Procedures, Packages, Functions, Triggers and other objects.

.

TECHNICAL SKILLS:

Business Intelligence : Oracle Business Intelligence Enterprise Edition OBIEE 11.x/10.x, OBIA 7.9.x.

ETL Tools : Informatica Power Center 8.x/7.x, DAC 10.x

ERP Systems : Oracle EBS R12, People Soft, Siebel CRM.

RDBMS : Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2000, MS Access

Operating Systems : Windows 2000/XP/vista/7, LINUX, UNIX AIX, UNIX Solaris

Languages : Java, SQL, PL/SQL, T-SQL

Web Based : HTML, XML, Dreamweaver

Tools : SQL Plus, SQL Developer, TOAD

Others : MS office, Adobe Acrobat, Microsoft Visio

Project Experience:

Confidential

OBIEE/ODI developer

Responsibilities:

• Gathered the requirements from the business users for ODI interfaces design and OBIEE defining the reports, dashboards, hierarchies and the source systems for OBIEE.
• Developed ODI transformation logic and designed various Complex Interfaces.
• Used various transformations such as Joiner, Union, Lookup, Filter, Expression, Aggregator etc.
• Developed packages by using odi interfaces,procedures,variables.
• Designed the repository at all the three layers to support the reporting.
• Designed Star schema for fact dimensional tables and created alias for the dimension and fact tables when necessary.
• Implemented aggregated tables, Fragmentation Partitions , Time Series functions Security privileges for better performance and security measures.
• Designed dimensional hierarchies, materialized views and aggregate tables to support the reporting system.
• Configured the LDAP to OBIEE for Authentication and Audit for Fusion Middleware.
• Implemented data and object level security based on the business requirements through External table.
• Performed Consistency check and Global Consistency check of the Business Model before exposing Business Models in the Presentation Layer considering errors, warnings and best practices.
• Developed reports, dashboards, standard filters and prompts.
• Complicated reports have been developed using multiple views like Pivot, View Selector, Chart View and Gauges.
• Worked on different subject areas of AP, AR and GL to create Reports and Dashboards according to the business requirements
• Built test cases and tested the Repository/Reports by comparing the SQL Output on the Data warehouse to the values in the Reports and documented the test results.
• Created and scheduled iBots for delivering personalized reports to users
• Worked on implementing automatic cache purging after monthly data load completion by using Event pooling table.
• Implemented and developed the migration plan for moving the repository and web catalog from DEV to UAT and PROD.

Environment: OBIEE 11.1.1.5,Oracle data integrator11.1.1.6,Oracle 11g, Oracle EBS R12 SQL Developer, Windows XP.

Confidential

OBIEE/Odi Developer

Responsibilities:

• Developed Odi Interfaces according to the design documents and mapping specifications
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes and generated Schema in the Database
• Developed Odi transformation logic and designed various Complex Interfaces Used various transformations such as Joiner, Union, Lookup,Filter, Expression, Aggregator etc
• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers and Scheduling IBOTS.
• Developed Physical Layer, Business Model Mapping and Presentation Layer using Oracle BI Administration Tool.
• Designed Star schema for fact dimensional tables and created alias for the dimension and fact tables when necessary.
• Configured the Logical Layer, Logical tables, dimensions and columns in Business Model and Mapping layer. Established the logical joins/keys required to support drill-down aggregation.
• Designed dimensional hierarchies, materialized views and aggregate tables to support the reporting system.
• Developed reports, dashboards, standard filters and prompts.
• Complicated reports have been developed using multiple views like Pivot, View Selector, Chart View and Gauges
• Configured the LDAP to OBIEE for Authentication and Audit for Fusion Middleware
• Implemented data and object level security based on the business requirements through External table.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created presentation catalog which allows exposing the business model to users in OBIEE Answers so that users can build requests to analyze the data.
• Documented the functional and technical report specifications
• Implemented and developed the migration plan for moving the repository and web catalog from DEV to UAT and PROD.

Environment: OBIEE 11.1.1.5,Oracle data integrator11.1.1.3,Oracle 10g, SQL Server 2008, Oracle EBS R12, TOAD 9.5.

Confidential

OBIEE/Informatica developer

Responsibilities:

• Developed Informatica mappings according to the design documents and mapping specifications.
• Developed Informatica transformation logic and designed various Complex mappings Used various transformations such as Joiner, Union, Lookup,Filter, Expression, Aggregator,Sequence generator etc.
• Extensively used OBIEE Administration Tool for customizing and modifying the Physical, Business and Presentation layer of the Repository.
• Architecture design of business model. Identified Facts, Dimensions, and Hierarchies of the business model. Created complex calculated measures based on time dimension to calculate Quarter Ago and Year Ago metrics
• Specified dimensional hierarchy and aggregate levels for the dimensions.
• Developed different brand level Reports, Filters, and Prompts using Oracle Business Intelligence Answers.
• Created various reports to fulfill the staff needs and customized the views using Oracle BI Answers.
• Designed and Configured Intelligent Dashboards in Analytics for different groups of users which include business users from various parts of the world.
• Used Analytics Web Catalog to set up groups, access privileges and query privileges.
• Created and scheduled iBots as per the business requirements.
• Reports development/customization with prompts and various types of pivot tables.
• Created and executed test cases to validated the User Interface, Data and Design.
• Communicating with client to understand/clarify requirements and suggest enhancements. Involved in Configuring of Oracle BI Applications in Development, Test and Production environments.
• Configured DAC client and server to work with Oracle BI Applications and Informatica.
• Defined Repository objects in DAC tasks, taskgroups, subject areas etc., , built, ran and monitored ETL execution plans.
• Installed and Configured Oracle BI Applications Oracle Financial Analytics and metadata repository files.
• Customized Out of Box OBIA reports to meet the requirements by doing Business Analysis, Technical Analysis and RPD Modifications.
• Designed, developed and tested reports for Oracle Financial Analytics modules of AP, AR and GL as per the requirements.
• Extensive SQL coding for data verification.
• Customizing latest oracle data warehouse to meet metadata design requirements.

Environment: OBIEE 10.1.3.4.2,Informatica Power Center 8.6,Oracle EBS AP, AR, GL OBIA 7.9.5.1,SQL Developer, SQL, PL/SQL, Windows XP, Unix AIX, Windows Server 2008.

Confidential

OBIEE/Informatica Developer

Responsibilities:

• Implement Operational Dashboards to view the completed tasks and open tasks in the dashboards.
• Created Pivot tables, views, charts.
• Created Prompts to Filter Interactive Dashboard Data and Configuring Guided Navigation Links.
• Customized Dashboards, Administered permissions and privileges for Dashboard visibility and modifications to users.
• Worked on OBIEE Answers to build Interactive Dashboards with drill-down capabilities.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Implemented Analytics Data level Security by creating Groups and setting up content filters in the repository.
• Created presentation catalog which allows exposing the business model to users in OBIEE Answers so that users can build requests to analyze the data.
• Configured measures in the Logical Layer and mapped to multiple logical source tables.
• Helped Customize and develop RPD, configured metadata objects Subject Area, Table, and Column and Web Catalog Objects Dashboard, Pages, Folders, and Reports .
• Created a repository using OBIEE Administration tool by importing tables into the physical layer and created the business and mapping model to incorporate the business logic.
• Developed Informatica transformation logic and designed various Complex mappings Used various transformations such as Joiner, Union, Lookup,Filter, Expression, Aggregator,Sequence generator etc.
• Developed Informatica mappings according to the design documents and mapping specifications
• Involved in Configuring of Oracle BI Applications in Development, Test and Production environments.
• Configured DAC client and server to work with Oracle BI Applications and Informatica.
• Defined Repository objects in DAC tasks, taskgroups, subject areas etc., , built, ran and monitored ETL execution plans.
• Installed and Configured Oracle BI Applications Oracle Financial Analytics and metadata repository files.
• Customized Out of Box OBIA reports to meet the requirements by doing Business Analysis, Technical Analysis and RPD Modifications.
• Designed, developed and tested reports for Oracle Financial Analytics modules of AP, AR and GL as per the requirements.

Environment: OBIEE10.1.3.4.2,Oracle BI APPS 7.9.5 financial nalytics,AP,AL,AR , Informatica 8.6, Oracle 9i,Flat files,TOAD,UNIX and Windows XP

Confidential

OBIEE/ Informatica Developer

Responsibilities:

• Worked with Business Analyst and analyzed the business requirements for developing the repository and extraction of reports.
• Analyzed the specifications provided by the client, understanding the business.
• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers, Scheduling IBOTS and BI Publisher
• Designed Star schema for fact dimensional tables and created alias for the dimension and fact tables when necessary.
• Created Views and alias for complex queries in the physical layer of OBIEE in order to improve the performance of the reports and to implement complex reports
• Specified Dimensional hierarchy and Aggregate levels for the dimensions.
• Used Filters Global and Local and provided customized prompts to avoid excessive data showing up in the reports
• Created various reports to fulfill the marketing needs and customized the views using Oracle BI Answers.
• Designed and Configured Intelligent Dashboards in Analytics for different groups of users, which include like Managers, functional heads, Department Heads.
• Managed Security privileges for each Subject area and Dashboards according to user requirements.
• Used the Catalog Manager and maintained the Analytics web catalog to manage dashboards answers.
• Worked in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Extensively worked on workflow manager and workflow monitor to create, schedule, monitor workflows, work lets, sessions, tasks etc.
• Build test cases and tested the Reports/Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.
• Performed Unit testing, integration testing to verify the report functionality and debugged dashboard reports to verify data matches as expected.

Environment: OBIEE 10.1.3.4.2, Informatica 8.1, Oracle 10g, SQL, PL/SQL,Windows XP, UNIX AIX.

Confidential

Oracle Developer

Responsibilities:

• Worked within the business intelligence team on existing project modules to identify where improvements need to be made in order to support new requirements and/or more efficiently support existing functionality.
• Created Stored Procedures, Packages and SQL Scripts.
• Developing Database Triggers to audit the sensitive data of the table along with user information and to enforce complex business rules.
• Developed SQL loader scripts to load data in the custom tables.
• Wrote several interfaces to the clients who has their data in Oracle ERP HRMS
• Modified existing codes and developed PL/SQL packages to perform Certain Specialized functions / enhancement on Oracle Application.
• Wrote Procedures and database triggers for the validation of input data and to implement business rules.
• Designed screen layouts, programming and integrating other sub-systems.
• Performed SQL tuning using Explain Plan, Hints and indexes.
• Involved in testing all forms, PL/SQL code for logic correction.
• Performed Unit testing on queries and reports.
• Automated the SQL scripts using UNIX shell scripting.

Environment: Oracle 9i/10g, Reports 6i, SQL plus, PL/SQL, Toad, SQL Loader, Win XP, Forms 6i.