SUMMARY

• Around 7 years of IT experience on analysis, design, development, customization and maintenance of various business applications in an effective way to deliver business solution.
• Experienced in Full Systems Development Life-Cycle Implementation of Various Oracle/ETL /OBIEE Projects.
• Proven experience in implementing complete software life cycle involving various phases of design, development and implementation of Data Warehouses Data marts with OLAP Tools.
• Expertise in OBIEE 10.1.3.4,OBIEE 11.1.1.x and ODI 11g 11.1.x
• Responsibility includes involvement in gathering business requirements, analysis, design, data modeling, development, which include in designing ETL Process, building and configuring repository.
• Extensively used Administration Tool for customizing and modifying the physical, business and presentation layers of the metadata repository.
• Solid understanding of Ralph Kimball approach and experience in Dimensional data modeling, Star schema modeling, Snow-Flake modeling, identification of fact and dimension tables, Normalization, Physical and Logical data modeling.
• Experience in developing Dimensional Hierarchies/New logical columns/Filters/Variables per business requirements.
• Proficient in creating and managing Dashboards, Reports and Answers.
• Worked on ODI Oracle data Integrator tool to extract data from different source DB's to move to different target DB's, converting data from flat files to DB Tables, cleansing the extracted data and building Fact's and Dimension Tables at the Staging Area etc.
• Expertise in Building Metadata Repositories .rpd , Building Physical layer, Business Model and Mapping layer, Presentation layer using Oracle BI Administration tool.
• Expertise with developing dynamic and interactive Dashboards with drill-down drill-across capabilities, and Web Catalog using Oracle Business Intelligence Tool.
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series Caching.
• Very strong experience in developing Time Series Objects, Interactive Dashboards with drill-down capabilities using page and dashboard prompts, Siebel Security Setup groups, object and data level , LDAP, External Tables, configured Analytics Metadata objects Subject Area, Table, Column , Web Catalog Objects Dashboard, Pages, Folders, Reports and scheduling iBots.
• Experience in Installation, Configuration, and Administration of OBIEE 10.1.3.x, OBIEE 11.1.1.x and ODI 11g 11.1.x .
• Comprehensive knowledge in Debugging, Optimizing and Performance Tuning of Oracle BI/Siebel Analytics Dashboards/Reports by implementing Aggregate navigation, cache management and materialized views .
• Experience customizing the OBIEE Metadata/RPD and Dashboards/Reports.
• Responsible for migrating the web catalog and RPD from DEV, UAT and PROD environments.
• Excellent interpersonal , communication and written skills with strong aptitude to learn new technologies.

Technical Skills:

Methodologies : Dimensional Data Modeling Logical / Physical.

OBIEE Tools : Oracle BI EE 10.1.3.1/3.2/3.3/3.4/11.1.1.5.

ETL Tool : Oracle Data Integrator 11.1.1 .

Databases : Oracle9i/10g/11g, MS SQL Server2000/2005/2008, DB2.

Query Tools : SQL, PL/SQL.

Languages : C/C , C , Java, XML, HTML, ASP, JavaScript.

Operating Systems : Windows 98/00/NT/XP, Red hat Linux, Windows 2000/2003.

Other : Visio, MS Office, Adobe Acrobat.

Work Summary

Confidential

Role : Sr. OBIEE/ODI Consultant

Responsibilities:

• Using ODI tool to extract data from the Transactional source to Staging Area.
• Importing the Metadata using ODI from the source.
• Extracting the Data from the Transactional Source to flat Files.
• Modifying Integrated Knowledge Module to create Audit reports.
• Good understanding of All Knowledge Modules CKM,LKM,JKM,IKM etc .
• Configuring Slowly Changing Dimension to track the history of any record.
• Check Data consistency using CKM.
• Implement CDC's Change Data Capture on selected tables.
• Created business reports according to the user requirements.
• Used the OBIEE administration tool to develop and enhance the metadata.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Configured and created the repository using the OBIEE admin tool.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Built business model and established relationships and foreign keys Physical and Logical between tables.
• Involved in the modifications of the physical, business and presentations layers of the metadata repository using the OBIEE admin tool.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Involved in managing appropriate security privileges on subject areas and dashboards according to business requirements.
• Developed custom reports/ Ad-hoc queries using OBIEE answers and assigned them to application specific dashboards.
• Developed different types of reports Pivot, Charts, Tabular using global and local filters.
• Manage day-to-day rpd, Scheduler and iBots.
• Worked with OBIEE cache manager and followed the best practices to improve the performance
• Developed Performance Tuning Strategies, for optimized performance, by implementing Aggregate Navigation, Cache Management and Indexes.
• Developed and Implemented Usage Tracking Reports
• Setup MUDE Environment to facilitate multiple users repository development in parallel by setting up users and projects.
• Created groups in the repository and added users to the groups using External database security table and granted privileges explicitly and through inheritance.
• Executed Test cases in all phases of testing Regression testing, Integration Testing, System testing, end-to-end testing and UAT.
• Performed Report Validation and Integration Testing and manipulations using SQL.

Environment: OBIEE 11.1.1.6/10.1.3.4.1, Oracle11g, Windows Server, SQL Developer, ODI 11.1.1

Confidential

Sr. OBIEE/ODI Consultant

Responsibilities:

• Experience in gathering and analyzing business requirements from various sources, ensuring the needs and delivery feasibility.
• Experience in extracting the Data from the transactional system to the staging Area.
• Experience in creating Data Marts, creating Facts and Dimensions.
• Used ODI to create a Staging Area and clean the erroneous records and modify them.
• Also Implemented CDC's Change Data Capture on necessary Attributes.
• Experience in SCD's Slowly changing Dimensions .
• Experience in configuring the metadata layer .rpd using the Administration tool.

• Created business reports according to the user requirements.
• Used the OBIEE administration tool to develop and enhance the metadata.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Configured and created the repository using the OBIEE admin tool.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Built business model and established relationships and foreign keys Physical and Logical between tables.
• Involved in the modifications of the physical, business and presentations layers of the metadata repository using the OBIEE admin tool.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Created Time Series objects for comparing business performance with previous time periods using Ago and To Date Functions.
• Involved in managing appropriate security privileges on subject areas and dashboards according to business requirements.
• Developed custom reports/ Ad-hoc queries using OBIEE answers and assigned them to application specific dashboards.
• Developed different types of reports Pivot, Charts, Tabular using global and local filters.
• Manage day-to-day rpd, Scheduler and iBots.
• Worked with OBIEE cache manager and followed the best practices to improve the performance
• Developed Performance Tuning Strategies, for optimized performance, by implementing Aggregate Navigation, Cache Management and Indexes.
• Developed and Implemented Usage Tracking Reports
• Setup MUDE Environment to facilitate multiple users repository development in parallel by setting up users and projects.
• Created groups in the repository and added users to the groups using External database security table and granted privileges explicitly and through inheritance.
• Executed Test cases in all phases of testing Regression testing, Integration Testing, System testing, end-to-end testing and UAT.
• Performed Report Validation and Integration Testing and manipulations using SQL.

• Involved in integrating Ms Word and Excel with OBIEE which can access reports directly without logging into BI Presentation services.
• Involved in setting up the idle session expiry time for the obi user.
• Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache
• Involved in creating navigation and drill down reports.
• Created global Prompts used can be used across dashboards with default values.
• Involved in creating dynamic report columns using Dashboard prompts and presentation variables.
• Involved in saving the reports to local directory by using ibots which calls java scripts and classes.
• Developed various report templates for campaign and agency using bi publisher.
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level the Siebel Application level.
• Involved in setting up Ibots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.
• Created corporate dashboards using Oracle OBIEE for automatic running, html output and menu linking for managers / VPs to access multiple reports output on a daily, weekly and monthly basis.

• Involved in Query Tuning to maximize the performance of reports and Dashboards.

Environment: OBIEE 10.1.3.4.1, Oracle10g, Informatica 8.1, TOAD, SQL Developer, Oracle BI Publisher 10.1.3.4.0 ,Windows NT.

Confidential

Role: OBIEE/ODI Developer

Responsibilities:

• Understanding the existing application architecture, designing and identifying the reporting requirements and prepare the requirements specifications document. This involved interacting with the business users and understanding the requirements.
• Extensively used the ODI for Replicating the Data from Sales force to local Database.
• Extensively worked on various transformations like Aggregator, lookup, Sequence generator, filter, Normalizer, Router, Source Qualifier, Rank, Update strategy.
• Created custom Mappings, Mapplets to load the new tables and the new information into the warehouse.
• Involved In building the Custom RPD and Created Facts like Opportunity, Projects, Demand Supply and dimensions like Opportunity, Projects, Opportunity Details, and Organization.
• Created Dimensional hierarchies to achieve the drill down functionality, navigation, time series measures and required metrics in the repository.

• Created Repository, system and non-system session variable and initialization blocks for various reporting needs.
• Involved in implementing write back feature to support the Goals and weights incurred at different levels for budget planning.
• Designed Interactive Dashboards and created dashboard prompts with multiple selections.
• Performed administrative tasks like creating users and assigning those privileges to groups and the security management.
• Constructed data visibility and security rules and implemented them within OBIEE to provide record-level team-based and group-based security into the Data warehouse.
• Developed Ad-hoc and standard Reports/dashboards with different Analytics Views Drill Down, Cascading Style sheets, Pivot Table, Chart, Column Selector and Tabular With Prompts, Global and local Filters, Contextual Navigation,Business rules with user identity and role within the OBIEE suite.
• Worked in Performance tuning of reports/dashboards as well as metadata repository using optimization efforts such as re-organizing the data, cache management, indexes.
• Implemented Data Level Security and Object level Security using LDAP and External Tables.
• Migrated BI RPD/Webcat to DEV/QA/PROD environments.

Environment: OBIEE 11.1.1.6/10.1.3.4.1, Oracle11g, UNIX, Sales Force, Flat Files, SQL Developer, ODI 11.1.1,TOAD.

Confidential

Role: OBIEE Developer

Responsibilities:

• Business Requirements were gathered and documented using Oracle's process Templates like MD50's etc.
• Customized the out of the box mappings in informatica like sales invoice line fact, Purchase cycle line fact according to the business requirements.
• Customized tasks, tables, table groups and indexes as per requirements.
• Performed nightly incremental loads using ODI.
• Customized and developed the Physical layer, Business Model and Mapping layer and Presentation layer, implemented logical column like Linetxt and SalesChannel and create the reports as per the requirements.
• Developed and customized OOTB reports and new Reports, performed look-good changes to OTB Dashboards with different subject matter Views Drill-Down/Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters .
• Identified the aggregate levels for measures and created dimension hierarchy sources for each level of aggregates for performance enhancement.
• Developed custom reports/Ad-hoc queries using Answers and assigned them to application specific dashboards.
• Managed security privileges for each subject area in Repository and Web Catalog according to user requirements.
• Implemented and Maintained OrderManagement Analytics and Supply chain Analytics.
• Created and scheduled iBots to deliver Analytics content for subscribed users.
• Customized/Developed reports request using Oracle BI Answers and configured all Dashboards.
• Also implemented guided navigation within reports.
• Involved in Performance tuning of reports/dashboards as well as metadata repository using optimization efforts such as re-organizing the data, cache management, indexes.
• Migrated BI RPD/Webcat to DEV/QA/PROD environments.

Environment: OBIEE 10.1.3.x, Informatica 8.6.x, OBIA 7.9.5, SQL Developer, UNIX, Oracle EBS R12, Flat files, Windows XP, Oracle 10g.

Confidential

Role : PL/SQL Developer

Key Responsibilities:

• Study and analyze the business requirements.
• Build models of the system, Confirm and refine the model with the analysts and experts.
• Design the database based on the model developed in the strategy and analysis phase.
• Build the prototype system, Write and execute the commands to create the tables and supporting Objects for the database.
• Development of Stored Procedures to encapsulate Business processes, triggers, procedures,
• Functions and package Using PL/SQL
• Refine the prototype. Move the application into production, user acceptance testing, conversion of existing data, parallel operations.
• Perform Integration and Unit testing of all the modules.
• Monitor its performance, and enhance and refine the system.
• Training internal people.