SUMMARY

• Over 6 years of experience in all phases of Business Intelligence, Data Warehousing and Database Applications which include Analysis, Design, and Development using ODI, OBIEE and BI Apps
• Designed, developed and administered ETL processes utilizing Oracle Data Integrator (ODI) to develop a consolidated Warehouse to support business requirements
• Extensively worked with ODI Designer in Creating Projects, Creating Models, Reverse engineering the data - stores (metadata) from Database, developing ODI Interfaces and Procedures, defining Project specific Variables/Global variables (Declare, Set, Refresh, evaluate types), Defining the flow of execution in ODI Packages and generation ODI Scenarios once the execution flow is defined in Package
• Solid Experience in using ODI Knowledge Modules (LKM, IKM, CKM, JKM), Creating ODI load Plan, setting up User parameters and Start/Stop the ODI Agent in Regular/ Scheduling mode
• Worked with multiple sources such as Relational database, Flat files, XML files for extraction transforming and loading data into target tables and thorough understanding of CDC Change data capture, SCD slowly changing dimensions and implementing them using ODI
• Designed and developed complex mappings and varied transformation logics using transformations like connected and unconnected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more
• Experience in Integrating ODI with Hyperion and OBIEE BI Tools
• Expertise in OBIEE10g/11g features like installation, security setup and Integration with Siebel and Oracle EBS Applications
• Experience with Oracle BI Server, Oracle BI Analysis/ Dashboards, BI Publisher, Weblogic console and Enterprise manager
• Extensive experience in creating and modifying OBIEE at multiple layers to handle complex joins, hierarchy setup, time series modeling, multiple logical tables sources, level based measures, variables, incorporating data level security using the OBIEE Administration tool
• Strong exposure in the administration tasks like installing OBIEE on windows environment and applying patches to upgrade from one version to next version
• Experience in implementing different authentication and authorization methods, creation of roles/groups in weblogic and assigning permissions at catalog level in OBIEE
• Good experience in troubleshooting administration tasks related to the Oracle BI Server, Oracle Presentation Server and weblogic
• Strictly adheres to OBI best practices throughout the implementation life cycle in all the areas and conducted various workshops in providing training and explaining the new features to the business and power users
• Worked extensively on features like OBIEE GoUrl for navigating from one subject area to another in a report and creation of complex reports combining different subject areas
• Good knowledge in generating reports using BI publisher to handle business templates, scheduling the reports and for reporting against transactional system
• Used languages like HTML/CSS code in formatting the report layout as per the requirement.
• Experience in creating new visualizations using Tableau desktop and publishing Dashboards to Tableau Server
• Worked closely with ETL Developers in populating the right data based on the data model and for production support data issues
• Identified the Data Sources (Relational, Excel etc) and designed Facts & Dimensions with the ETL developers by looking at the data
• Interacting with customers, analyzing their needs and providing recommendations on capacity planning, upgrades, migration of database, application architecture

TECHNICAL SKILLS

• ODI 11g
• OBIEE 10g/11g
• Oracle BI Applications (OBIA) 11.1.1.9.1
• Oracle Web Logic 10.3.5 10.3.6
• Oracle Database 10g/11g
• SQL Server
• Windows 2003/2008
• Unix
• MS Excel
• PowerPoint and VBA

PROFESSIONAL EXPERIENCE

Confidential, Chicago

ODI and OBIEE DEVELOPER

Responsibilities:

• Responsible for designing, developing, and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems (Flat files, Excel files, Oracle) using ODI
• Created new models and work flows for different data sources Oracle DB, MS SQL Server and flat files using ODI
• Used ODITopology Manager graphical tool to manage the data describing the information systems physical and logical architecture
• Worked on ODI Designer for designing the interfaces, defining the data stores, interfaces and packages, modify the ODI Knowledge Modules (Reverse Engineering, Journalizing, Loading, Check, Integration) to create interfaces to Load and transform the Data from Sources to Target databases, created mappings and configured multiple agents as per specific project requirements
• Implemented SCD Type 1 and Type 2 using ODI
• Performance tuned the interfaces, queries through use of indexes, ranks, Oracle hints, exchange partitions
• Configured BI Apps financial analytics module
• Worked in all phases of implementation life cycle of the project from requirements gathering to deployment to generate reposts using OBIEE Admin tool and OBI Answers
• Worked on installation of OBIEE 11g and also on patches while migrating from 11.1.1.6 to 11.1.1.7 with the help of Certification Matrix
• Gathered requirements and performed the GAP Analysis, translated them into technical design documents and worked in making recommendations to close the GAP
• Worked with ETL developers in extracting the data from Oracle EBS, OLTP flat files and loading into DWH
• Developed automated file retrieval from shared folders and other data sources into warehouse and uploaded the tables in to OBI Admin tool
• Created Time Series Measures like Year ago, Month Ago, Year-to-date measures using AGO and to Date functions to in corporate into reports in OBI Answers
• Created Session Variables used for Data Visibility, configured security at the repository level, Catalog level & at the Application level of the OBI Admin tool
• Created and customized Dimension Hierarchies in the OBI Admin tool to achieve the drill down functionality and for creating level based measures as per Business Requirements.
• Used new version features at the BI Answers page like Master-Detail reports, Bread Crumbs, Freeze header column on multiple dashboards
• Worked on creation of groups and roles and assigning them required permissions at RPD/Catalog level
• Involved in setting up iBots at OBI Answers page to run reports at scheduled time for Cache Seeding and mailing out report outputs to users
• Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), and used features like conditional navigation in reports
• At the front end report level of the OBI Answers, worked on selection group, calculated items, master-detail column selector, view selector, action links and various kind of variables
• Experience in performance tuning at the Database level by creating aggregate tables, Bitmap indexes and tuning the Reports at BI level
• Used Catalog Manager to migrate reports in Web Catalog from Instance to Instances.
• Integrated Oracle BI Presentation Services with BI Publisher and in merging BI catalog with the BI publisher catalog
• Experienced in configuring Usage Tracking and Multiuser Development Environment
• Have good experience on SQL, creating indexes, views and materialized views
• Good knowledge on the Oracle packages, procedures, functions and in writing complex SQL queries
• Experienced in designing and development of various dashboards, reports utilizing various Tableau Visualizations at the Desktop

Environment: Oracle DB 11g, OBIEE 11.1.1.7, BiApps 11.1.1.9.1 , Oracle EBS 12, Windows, UNIX, ODI 11g, Tableau, SQL

Confidential, San Jose, CA

OBIEE DEVELOPER

Responsibilities:

• Integrated OBIEE with EBS for Single Sign On (SSO) so that users can log into BI directly from the EBS without providing any credentials
• At the OBIEE RPD level, dealt with various scenarios on connection pool like setting the connections and making use of connection scripts
• Worked on Aliases tables, select statement based physical tables, dimensional hierarchies, level based measures, multiple logical table sources, various ways of giving business calculations at the OBIEE RPD level
• Ensured best practices at the RPD and database level like naming the tables, using aliases, using the keys and using implicit fact joins
• Created Dimension hierarchies to achieve the drill down functionality at the OBI Admin tool
• Implemented writeback functionality at the report level so that users can modify the backend data at the RPD level
• Customized the Repository by importing new facts and Dimensions and adding some extra columns to the existing Facts and Dimensions
• Worked on the logical content level at the BMM layer in designing subjects areas having detail and aggregate tables
• Implemented the AD authentication at the weblogic console level and external table authorization for user security
• Worked on security, at column and table level from the presentation layer
• Designed, implemented and tested security privileges on subject areas, dashboards and reports
• Good experience working on cache management and event polling concept
• Used Direct database request feature to create ad-hoc reports based on the Discoverer SQL and then placing them on dashboard for quick turnaround
• Created complex reports using saved analysis concept and then navigating from one report to another using conditional navigation
• Implemented GoUrl feature in embedding the dashboards on a different webpage by using generic username and password
• Worked on integrating and configuring BI Publisher with OBIEE
• Created complex templates and performed calculations within rtf templates using BI Publisher
• Worked On the installation and configuration of OBIEE in Windows/Linux environment
• Involved in migrating Discoverer to OBIEE

Environment: OBIEE 11.1.1.6.2 , BiApps 7963, Oracle DB 11g, PeopleSoft, Unix, Informatica, DAC, SQL

Confidential, Libertyville, IL

OBIEE DEVELOPER

Responsibilities:

• Participated in requirements gathering by meeting with the business user and base lining the details
• Identified the Data Sources (Relational, Excel etc) and designed Facts & Dimensions with the ETL developers by looking at the data
• Designed and BuiltOBIEERPD at 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model / data mapping (create Logical tables & data source mapping) and Presentation Layer level (create subject areas)
• Developed the Dimensions and Time Series Objects in the BMM Layer
• Worked on Security settings using Basic RPD Authentication and External Table Authentication to setup groups, access and query privileges
• Created Week Ago and Month Ago and Year Ago Fact Measures and Dimension attributes
• Extensively usedOBIEEDelivers and iBots
• Debugged reports and Dashboards visibility with respect to user's role privileges and web groups in an integrated environment
• Prepared the Test Plans and Test cases for validating the reports/dashboards
• Written many SQL statements for validating the reports and used the same in Test documents
• Performed Tuning of Dashboards/Reports by aggregate navigation, and cache management

Environment: OBIEE 11.1.1.5, Oracle DB 11g, Linux, Informatica, DAC, SQL

Confidential, PROVIDENCE, RI

OBIEE CONSULTANT

Responsibilities:

• Experience in providing end-to-end business intelligence solution by configuring metadata and building BI Repository consisting of three layers (Physical, BMM Layer &Presentation Layers)
• Experience in Dimensional Hierarchies, Level Based Measures, Drilldown Analysis and Time Series Functions in BMM Layer of Administration Tool
• Implementing in repository variables and session variables and Cache management
• Usage tracking integration with OBIEE and Metrics Automation and scheduling
• Creating users, Groups & Roles based on the business requirements
• Experience in Implementing Aggregation tables, Partitioning and Fragmentation methods.
• Created Data Sets and Data Models using SQL Developer and XMLPublisher
• Extensively involved in developing Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL, Database designs Methodologies
• Familiar with database performance tuning by implementing materialized views with query rewriting, creating appropriate indexes, usage of hints, rebuilding indexes and analyzing query execution using the explain plan
• Worked closely with users, developers and administrators to resolve ongoing production problems by reviewing design changes made in production and made corresponding changes to OBIEE repository

Environment: OBIEE 10.1.3.4, BiApps 7961, Informatica, DAC, Oracle DB 10g, Windows, Linux