• 7 years of experience in End-to-End Business Intelligence project delivery using several enterprise level reporting tool, data warehousing and building software applications.
• Excellent experience in Answers, Delivers, iBots, Oracle BI Publisher, Extraction, Load and Transformation ELT using Oracle Data Integrator ODI .
• Experience as Oracle BIEE Developer and design and Implementation of Data Warehouse/Data Mart, experience in gathering Business Requirements, performing Analysis, Design / Data Modeling, Development, Testing using agile development techniques.
• Hands on experience in designing and implementing the E-LT architecture that is required to build data warehouse, including source-to-staging area, staging-to-target area, data transformations, and EL-T process flows.
• Implementing the extraction, loading, and transformation EL-T of data using Oracle Data Integrator configuring the ODI master and work repositories, ODI models, defining and organizing the ODI project including interfaces, packages, procedures, variables, user defined-functions, and knowledge modules.
• Experience in creating and customizing sophisticated reports, filters and rtf templates in BI Publisher using Table Wizard, charts, pivot tables
• Worked on developing BI Publisher reports using many data sources like Oracle, SQL Server, Sybase and MS-Access.
• Extensively used Administration Tool for customizing and modifying the physical, business and presentation layers of the metadata repository.
• Worked Extensively on OBIEE/Siebel Analytics Administration Tool, Siebel Analytics Web/Presentation Services, Answers, Interactive Dashboards and Security Implementation.
• Experience in implementing a fact less fact table for global prompt in the OBIEE dashboard as part of improving performance of global prompt.
• Proficient in using the time-series functions to support historical time comparison analysis and creating requests, adding filters, creating prompts, and creating pivot tables using OBIEE
• Experience with repository development, configured metadata objects and web catalog objects Added Metadata changes to the OBIEE/Siebel Analytics RPD
• Extensive experience in building Interactive Dashboards with drill-down drill-across capabilities using global local Filters, Contextual Navigation, Guided Analytics, Business Rules with User Identity Roles, Profiles Personalization.
• Experience in Developing and customizing PL/SQL packages, procedures, functions, triggers and reports using Oracle SQL Developer.
• Experienced with different RDBMS such as Teradata, Oracle 9i/10g, MS SQL Server 2008 and MySQL.
• Experience interacting with Business users and Architecting high level requirements, high level design and detailed level design documents.
• 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.
• Expertise in configuration and integration of BI Publisher with BI server and BI Answers.
• Experience in Toad, Sql Loader, Export/Import and writing control file scripts for loading large loads of data into tables.
• Highly motivated, detail oriented, has ability to work independently and as a part of the team with Excellent Technical, Analytical and Communication skills.

TECHNICAL SKILLS:

• BI tools : OBIEE platform 10.1.3.2, 10.1.3.3, 11.1.1.5, 11.1.1.6.2
• ETL tool : ODI 11g, 10.1.3 x
• Data Modeling : Dimensional modeling, Star, Snowflake
• Database : MS SQL Server 2005/2008, MySQL, Oracle 8i/9i/10g/11g, DB2, Teradata
• Languages : SQL, PL/SQL, C, C , HTML, DDL Scripting, UNIX Shell Scripting
• Tools : TOAD, SQL Developer, SQL Plus, Microsoft Visio
• Reports : BI/XML Publisher

EXPERIENCE:

Confidential

Sr. OBIEE/ODI Developer

Roles and Responsibilities:

• Worked closely with Business Analyst in understanding the Analytics requirements and generated reports as per the user requirements
• Worked closely with the ETL and Database Team to coordinate the Necessary Data movement
• Involved in gathering the requirements of source and target systems
• Involved in extensive data cleansing and profiling
• Extensively used knowledge modules in achieving the client requirements
• Used ODI designer to create projects and release scenarios
• Created master and work repositories for ODI by coordinating with Oracle DBAs
• Used RKM to reverse the metadata of the system database
• Involved in creating database connections, physical and logical schema using the Topology Manager
• Extensively worked on creation of packages, construction of data warehouse and data marts, and synchronization using ODI
• Applied DDL changes to each environment as required
• Worked extensively on tuning various OBIEE system components settings to meet some of the user requirements
• Created cross-functional reporting against various data sources
• Designed and developed various Interactive Dashboards and reports with drilldowns, guided navigation, switching reports out of variable prompts and dashboard section conditions
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to the OBIEE Repository
• Designed and developed Dashboards/Reports mockup as per user requirements
• Developed RPD in line with OBIEE best practices and extensively utilized concepts such as query federation and fragmentation to improve query performance
• Implemented Write back functionality with in OBIEE to allow users to input data into Data Warehouse
• Migrated RPD, Catalog, Security from Development to Test to Production
• Worked extensively on Performance Tuning at various levels such as Dashboards, Reports, logical query and physical query
• Created auto purge for repository projects and scheduled as per the demand
• Conducted various workshop sessions with super users to bring then up to speed on subject areas, reports, dashboards and also helped them to understand the limitations of the System

Confidential

OBIEE/ODI Developer

Roles and Responsibilities:

• Used different ODI Interfaces for Extraction/Loading/Transformation, data consolidation, data Integration and data cleansing
• Worked on Loading and Integration KM in Flow tab in ODI Interfaces by applying joins with execution location as Target
• Used ODI Topology Manager to create connections to various technologies such as Oracle, SQL Server, Flat files, XML, etc.,
• Worked on various technologies such as Oracle, Access DB, Excel/Flat files, using them as sources and targets in ODI
• Assisted in Installation configuration of Oracle Data integrator ODI in the Windows environment
• Used Analytics Web Catalog to set up groups, access privileges, migrating reports from dev to production and query privileges
• Responsible for creating users and maintaining visibility privileges using Analytics administration on the repository side
• Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance
• Expert in cache management, Repository migration, data level and object level security in OBIEE Analytics
• Created Dimensional Hierarchies for the Drill Down functionality and implemented Business Logics for Facts
• Modeling activities which included building star schema as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns in Business and Mapping model layer. Established the logical joins/keys required to support drill-down aggregation
• Designed and Configured Dashboards in Analytics for different groups of users to view figures across regions, products with the facility to drill down to individual customer relationship manager
• Implemented the delivery of iBots using OBI Delivers to alert the associated teams
• Developed custom reports/Ad-hoc queries using OBIEE Answers and Filters
• Responsible for Unit and System Testing and Performed Data Validation for all the reports that are generated from OBIEE

Confidential

Sr. ODI/OBIEE Developer

Roles and Responsibilities:

• Identified and mapped required database fields and tables
• Implemented a variety of ODI interfaces, packages, procedures, scenarios for extracting and loading data into target sources
• Scheduled and administered database queries for off hours processing
• Participated in planning, reporting and database needs
• Worked with staff to verify and trouble shoot data validity issues
• Designed and developed database SQL programs necessary to extract, transform and/or load data
• Executed data definition language DDL scripts, created by the data modeler, and created the data base schemas
• Worked on date related issues in reports and fixed them
• Installed and configured OBIEE and ODI tools.
• Worked on cleansing of data at the Staging area to remove redundancies and erroneous content
• Prioritized the urgency of multiple demands and assume responsibility to make things happen
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables
• Responsible for managing the connection pool entries associated with Physical Data Sources
• Customized and developed repository configured metadata objects Subject Area Table Column and Web Catalog Objects Dashboard Pages Folders Reports .
• Created different types of customized reports Drill-down, aggregation to meet the client requirements.
• Developed custom reports/ Ad-hoc queries using OBIEE answers and assigned them to application specific dashboards.
• Created reports according to user requirements and also created corresponding dashboards for the reports and actively involved in deployment and post release support.
• Migrated Analytics RPD and Webcat from one environment to another
• Implemented Object level security as well as Data level security, identifying the groups and their permissions and privileges as per business needs.
• Assisted in creation of pivot table request allowing the manager to analyze the business from different perspectives provided optimized Analytics using Column selector.
• Implemented and Administered OBIEE Security using an External Security database table.

Environment: ODI 11g, OBIEE 11.1.1.6, Oracle 11g, DDL Scripting, BI Publisher, SQL, PL/SQL, Stored procedures, Windows XP, Toad.

Confidential

Sr. OBIEE/ODI Developer

Roles and Responsibilities:

• Worked closely with Business Analyst in understanding the Analytics requirements and generated reports as per the user requirements
• Worked closely with the ETL and Database Team to coordinate the Necessary Data movement
• Involved in gathering the requirements of source and target systems
• Involved in extensive data cleansing and profiling
• Extensively used knowledge modules in achieving the client requirements
• Used ODI designer to create projects and release scenarios
• Created master and work repositories for ODI by coordinating with Oracle DBAs
• Used RKM to reverse the metadata of the system database
• Involved in creating database connections, physical and logical schema using the Topology Manager
• Extensively worked on creation of packages, construction of data warehouse and data marts, and synchronization using ODI
• Applied DDL changes to each environment as required
• Involved in loading the data from flat files into staging area
• Extensively used Oracle Business Intelligence Administration Tool for customizing and modifying the physical, business and presentation layers of the metadata repository
• Involved in installation and configuration of OBIEE on Linux enviroment.
• Involved in RPD Modeling which includes building star schema as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns in Business Model and Mapping layer. Established the logical joins/keys required to support drill-down aggregation
• Created scorecards to establish individual budget targets
• Implemented usage tracking to monitor system and ad hoc query performance on usage details
• Configured and Created repository using Oracle BI Admin tool
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository
• Configured metadata objects Subject Area, Table and Column and Web Catalog Objects Dashboard, Pages, Folders and Reports .
• Created Logical Tables, Dimensions, Facts and additional Metadata in the Business Layer
• Worked extensively on BMM Business Model and Mapping layer to develop various business models like revenue-opportunity and inventory management models using Star Schema and Snowflake Schema
• Created Session and Repository variables
• Built Interactive Dashboards and Reports using Tabular and Pie Chart Reports with Drill down and drill up capabilities to enhance granularity in the Data
• Implemented Time Comparison and Calculation measures in the business model using Time series Wizard
• 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
• Experienced in migrating the Web catalog developments by using the Catalog manager and Repository developments to Production from the Test environment.
• Worked extensively with BI Publisher 11g.
• Migrated the project from 10.1.3.4 to 11.1.1.5 and did rpd merging
• Modified the dashboard using 11g and repository patching
• Involved in Reconciliation Process while testing loaded data with user reports

Environment: OBIEE 10.1.3.4, OBIEE 11.1.1.5, OBIEE 11.1.1.6, DDL Scripting, Oracle 11g, BI Publisher, ODI, SQL, PL/SQL, Windows XP, Linux, Toad.

Confidential

OBIEE Developer

Roles and Responsibilities:

• Involved in gathering the requirements, performing scope analysis and identifying gaps
• Built the Oracle BI repository Physical Layer, Business Model and Mapping Layer and Presentation Layer
• Created logical tables and defined the complex joins for a business model
• Developed Calculated Measures, Level based measures and Dimension hierarchies in the Business Model and Mapping Layer
• Developed and debugged many Dashboards using different Analytics Views Pivot Table, Chart, Graph and Column Selector , Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters
• Generated different kinds of reports using Answers and assigning them to application specific dashboards
• Created DDL scripts required to generate or modify the database
• Worked on Answers to build Interactive Dashboards with drill-down capabilities based on period and class hierarchies
• Performed Pre and post implementation testing of Dashboard, Answers and validating Repository.
• Created Users, Groups and giving the permissions in Oracle BI Administration Tool and verified the Permissions of the users in Oracle BI web
• Responsible in creating Alias and configured repository with logical dimensional modeling using star schema
• Involved in user trainings on the generated reports for this project
• Participated in Post implementation reviews with the Project teams

Environment: OBIEE 10.1.3.3, SQL Server 2003, SQL, DDL Scripting, SQL Plus.

Confidential

Oracle Developer

Roles and Responsibilities:

• Wrote Event Triggers, PL/SQL Program Units for Reports for Client Validations
• Wrote generic PL/SQL code modules PL/SQL Libraries for Reports to handle data manipulations on client
• Developed Database Objects - Triggers, Packages, Procedures and functions
• Wrote Database procedures, Packages, functions to handle data manipulations and Computations on Server
• Developed Mappings using various transformations like connected/unconnected Lookups, Filter, Router, Aggregator, Expression, Stored procedure, Sequence Generator, Update strategy and Joiners etc. depending upon requirement
• Scheduling Execution of PL/SQL Procedures using Unix Shell scripts for updating of Base tables from Transaction Tables
• Created Materialized views to calculate aggregated data, such as a sum of monthly revenue
• Designed and developed Oracle Monthly Reports

Environment: Oracle 9i, SQL PLUS, PL/SQL, Reports 6i, Toad, FTP. Oracle 8i / 8 Developer / 2000 Forms 6.0 / 5.0 / 4.5 / 4.0, SQL Loader, UNIX IBM AIX 4.0 , Windows NT / 2000 / 95.