SUMMARY

• Around 7+ years of experience in Business Requirement Analysis, Application Design, Data Modeling, Development, Reporting, Testing of Data Warehousing and Database business systems and Implementations.
• Around 3+ years of ODI experience in all phases of project development.
• Experience in Data Modeling using Dimensional Data Modeling, Star Schema Modeling, Fact and Dimension tables, Physical and Logical Data Modeling in the OBI Administration tool.
• Hands - on professional experience in Oracle Business Intelligence Enterprise Edition.
• Customized and configured OBIEE application using OBIEE Answers, OBIEE Dashboards, BI Publisher and Administration Tool.
• Developed the business model and mapping layer, Presentation layer and RPD using OBIEE administration tool set.
• Involved in Application maintenance activities and Implementation.
• Experience in configuring Interactive Dashboards with Drill-drown capabilities using global and local filters, OBIEE Security setup (Roles, groups, and access/query privileges), metadata objects and web catalog objects
• (Dashboard, Pages, Folders, Reports)
• Extensively worked on creating the aggregate tables at year and month levels.
• Created various analytic reports using global and local filters.
• Strong experience in modeling and building the OBIEE repository, deployment and migration of OBIEE components like RPD and Catalog from 10g to 11g.
• Experienced in Installation, Configuration, Upgrade, Migration and Administration of OBIEE 10g and 11g.
• Experience in modeling aggregate tables to speed up processing and building calculated measures for the Fact tables.
• Extensively used ODI for ETL purposes.
• Involved in Installation, Configuration and Security setup for Oracle Data Integrator on windows platform across all environments.
• Hands on experience in Design, Construction and Administration of Enterprise Data Warehouses, Data Marts and Data Integration using ODI.
• Designed and Tested Oracle Data Integrator Projects including Data Servers, Schemas and Scheduler agents.
• Expertise in Oracle Data Integration to Extract Load and Transform (ELT) for high performance and faster responsiveness.
• Proficient in Oracle Tools and Utilities such as SQL Developer, SQL Loader, SQL Plus and TOAD.
• Functional experience includes identifying the sources and mapping them with data marts.
• Ability to discuss and utilize various architectural components of the tool (Security, aggregation, logical columns, etc.)
• Hands on experience in ETL process using Oracle Data Integrator for various transactions and loading data from the separate data sources.
• Experience in creating and modifying Business Intelligence requests using Oracle Business Intelligence Answers.
• Hands on experience on development and implementation of Data Warehouses & Data marts with OLAP Tools.
• Knowledge in Data Mapping, Data Conversion, and Data Cleansing.
• Experience in setting up security and architecture with OBIEE 11g by using web logic admin Console and Enterprise Manager.
• Ability to discuss and utilize various architectural components of the tool (Security, aggregation, logical columns, Hierarchies, Prompts and Dynamic Dashboards)
• Created mappings to extract data from Flat Files, Excel and Access databases to be loaded into the Pre-Stage Schema.
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Expertise in E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Extensive experience with Fact and dimensional tables, and slowly changing dimensions.
• Hands on experience on admin tasks of OBIEE such as Security and Monitoring.
• Proven ability to work well with and lead others and quickly grasping new information and technologies.
• Highly reliable and productive, possess good interpersonal communication skills and leadership qualities.

TECHNICAL SKILLS

ETL Tools/Packages: Sunopsis v3/Oracle Data Integrator (10g, 11g)

Reporting Tools: OBIEE

Data Modeling Tools: ER Studio, Erwin

Querying Tools: Toad, SQL *Plus, SQL Query Analyzer 2000, Microsoft Query, Quest Central, SQL Navigator, SQL Advantage

Database: Oracle 10g/9i/8i, SQL Server 2008, IMS, DB2 UDB 8.1(EEE), Sybase, MS Access

Scheduling Tools: WorkFlow Manager, Sunopsis Operator

Languages: SQL, PL/SQL, UNIX, C, C++, VB Script, Java Script

Operating System: Windows NT/2000/XP, UNIX-AIX, Sun Solaris

Miscellaneous: MS Visio, MS-Office (Excel, Ppoint, Word), Ultra Edit, Share Point, Siebel Tools

PROFESSIONAL EXPERIENCE

Sr. OBIEE/ODI Consultant

Confidential, Denver, CO

Responsibilities:

• Participated in the Requirements Gathering of the various work streams by meeting with the business user and base lining the details. Installed configured and administrated OBIEE 11G.
• Installation of Siebel Analytics/OBIEE and related components for development, QA and production environments.
• Worked on Key Performance Indicators (KPI) within the BI environment which can be used as the catalyst toward driving more responsive interaction between users and data.
• Worked on Configuration & Application Deployment Management.
• Designed and developed Performance Measurement Dashboards/ Reports that are Dynamic & Interactive with drilldown, drill across capabilities split reports for summary & details information, and local & global filters using Oracle BI Presentation Services.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Enhance performance of Reports/ Dashboards by implementing the Aggregate tables, Materialized Views, Table partitions and managing Cache.
• Worked on Metadata Repository objects and also Web catalog Objects which include Dashboards, Reports, Pages and Folders.
• Customized Purchase Orders, GL, Account Receivables, Account Payables, Procurement and Spend Analytics, Order Management, Inventory reports using OBIEE 11g.
• Implemented data level security (Location Managers, Sales Executives etc.) using Session.
• Variables by creating content filter in dimension table in rpd.
• Installed ODI. Set up the ODI connection with Oracle, oracle SQL Server and flat files.
• Troubleshoot the ODI connection with oracle by fixing the tnsnames.ora file.
• Implemented object level security for both repository objects and web objects by creating users and groups in repository and web catalog groups in the Presentation Services.
• Created Dimensional Hierarchies and Level Based measures, worked on Expression Builders and Calculation Wizards to generate certain expressions.
• Created ODI packages, scenarios using interfaces, variables, procedure
• Performance tuned the OBIEE11.1.1.9interfaces.
• Extensively worked on developing Data model based on STAR schema concept using OBIEE 11g Administration Tool for current and future reporting requirement.
• Customized Oracle BIEEMetadata Repository using Siebel Analytics/OBIEE Admin Tool by importing some of the required objects with integrity constraints into Physical Layer.
• Performed implementation from OBIEE11g to OBIEE12C.
• Configured LDAP server to Authenticate users and implemented both object level and data level security based on roles and responsibilities.
• Performed Unit, Integration and Regression testing to validate reports and mappings.

Environment: OBIEE 11.1.1.9,OBIEE 12C, ODI 12.2.1,BI Publisher,BI Admin tools 11.1.1.9.0 , SQL, PL/SQL, Oracle 10g, Windows, Web Logic Server 11gR1 PS3, Financial Analytics, HR ( Human Resources) Analytics.

OBIEE/ODI Consultant

Confidential, Kansas City, MO

Responsibilities:

• Worked closely with Business Analyst in understanding the Analytics requirements and created the Business Model for generating reports as per the user requirements.
• Used Oracle Data Integrator for Extraction, Loading and Transformation of Data.
• Created data servers related to specific technologies and mapped with physical and logical architectures.
• Created various mappings from source to target using Topology and Designer Navigator.
• Extensively used Knowledge Modules such as Loading Knowledge Module, Integration Knowledge Module and Journalizing Knowledge Module for loading data into staging and target areas as well as to maintain data consistency.
• Created ODI Packages to improve inter - application dialog by having interfaces executed asynchronously.
• In most of the cases, scenarios are created using Packages, Procedures, and Interfaces and are imported wherever they are required in the production environment.
• Once the data is loaded into the data marts of target, it is then categorized as Facts and Dimensions to build reports.
• Analyze Design and Development of Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer, Presentation Layer.
• Worked with out of the box reports and customized them to suit the business needs.
• Customized the repository and created new Requests, developed Custom Reports/Ad-hoc queries, charts using Oracle BI Answers Created and configured the Dashboards.
• Modeled the repository which included customizing 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 hierarchies.
• Utilized session variables, repository variables and initialization blocks in the repository for Security and reports.
• Created Reports using different Analytics Views (Pivot Table, Chart, Column Selector, Tables)
• All the work is managed through Work Request Tracking System (WRTS)
• Anything that needs to go in any environment must have a WRTS request and the script must be attached to it.
• Developed custom logical columns and calculated measures using expression builder. Created presentation catalog with restricted access to various business users.
• Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, re-building of indexes, overwriting the SQL execution path by making use of hints etc.
• Troubleshoot various ELT performance issues.
• Worked and coordinated with testing team for bug fixes and production change requests.

Environment: OBIEE 11.1.1.3/10.1.3.4 , Oracle Data Integrator 10g/11g, Oracle10g, Windows Server, SQL.

OBIEE Consultant

Confidential, Columbus, OH

Responsibilities:

• Interacted with Subject Matter Experts and Business Analysts for reporting requirements analysis and to define business and functional specifications.
• Analyzed the Business Requirement Documents (BRD's) and created the technical Specifications for the required Subject areas and corresponding Dashboards.
• Monitored and documented change requests in requirements and ensured modified requirements are met during BI development.
• Designed and developed metadata repository that consisted of Physical layer, Business Model and Mapping layer and presentation Layer using Oracle BI Administration tool.
• Build repository by importing the data, defining keys and joins, creating business model, defining complex joins, mapping columns and sources, creating measures, and developing subject areas.
• Extensively worked on Oracle Business Intelligence Administration Tool.
• Managed Security settings in OBIEE Administration Tool.
• Designed and developed the OBIEE/ Metadata Repository (.rpd) using OBIEE Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer.
• Created the star schemas, dimensional hierarchies, Aggregations, Fragmentation in Business Model layer in OBIEE Admin tool based on the requirements for these Subject Areas.
• Developed various Reports, Interactive Dashboards with drill - down capabilities, with various charts and views, and tables using global and local Filter.
• Developed Reports and Dashboards with different Analytics Views including Pivot Table, Chart, Gauges, Column Selector, and View Selector using Oracle BI Presentation Service.
• To track usage set up Usage tracking subject area and designed few reports in OBIEE.
• In the Enterprise Manager created and set up Application Roles to implement data level security and updated Application policy as per requirement.
• Implemented Object Level Security for the objects like Catalog Folder, Dashboards, Reports and Data Level Security for Unit, Region and Product dimensions using Session Variable.
• Created various session and repository variables and initialized them in the Initialization Blocks to change metadata dynamically as the environment/user changes.
• Migrated Development RPD to the QA and Production environment and used Catalog Manager to migrated catalog files like Dashboard, Reports and other object from one environment to the other environment.
• I have used BI Publisher for reporting direct against the Data source or OBIEE RPD and integrated Publisher reports on BI Dashboard.
• Scheduled reports and bursting as per the requirement in BI Publisher and represented them in OBIEE dashboards.
• Created Shared Directory and projects to work with Multi User Development Environment (MUDE).
• Integrated OBIEE with Essbase, developed RPD and reports against multidimensional database.
• Upgraded from OBIEE 10g to 11g.
• Developed Performance Tuning Strategies for optimized performance, by implementing Aggregate Navigation, Cache Management, re-organizing data, and implementing calculated objects into the RPD.
• Involvement with ETL (Extract-Transform-Load) development team to communicate the specification for the required dimensional, aggregate and indexed data tables.
• Scheduling and Executing Incremental ETL loads by using Data Warehouse Administration Console (DAC)
• Created extensive documentation on the design, development, and implementation and provided Knowledge Transfer to the end users.

Environment: OBIEE 11.1.1.6.X, BI Publisher, BI Admin tools 11.1.1.6.0 (.rpd), SQL, PL/SQL, OBIA 7.9.6.4, Oracle Database 11.1.0.x.

OBIEE Consultant

Confidential, Irving, TX

Responsibilities:

• Involved in full project life cycle implementation of Data Warehouse and participated in designing STAR schema and developed complex Mappings/Mapplets using various Transformation/Re - usable Transformations (Update Strategy, Filter, Router, Expression, Stored Procedures, Lookup and Aggregator) for implementing the Data Warehouse.
• Created reporting metrics and transferred key performance indicators to a process and database design.
• Created/modified Metadata repository suiting the company's data requirements by using OBIEE Administration tool.
• Created connection pools, physical tables, schema folders and catalog folders in the physical layer of the repository.
• Defined Primary-Foreign key relationships, complex joins to bridge tables between dimension tables and Fact tables in the physical layer.
• Created dimension sources for each level of aggregated fact data and specified aggregate levels for each source.
• Defined static and dynamic repository variables to modify metadata content dynamically to adjust to a changing data environment.
• Created Aggregate tables and fragmented fact tables for efficient query performance.
• Created and modified Sales Analytics dashboards and reports.
• Extensively used filter, update, lookup, expression, router and sequence generator transformations.
• Defined the refresh extraction logic based on the last updated column in the Transactional Tables.
• Created workflows for the Initial load and refresh load.
• Created mappings to populate the aggregate, hierarchy and helper tables.
• Tested and Validated the Repository before making it available for queries.
• Configured query cache to reduce the cost of database processing and reduce the server-processing verhead.
• Defined session variables for users to enhance data level security.
• Implemented BI Publisher and created bursting reports using BI Publisher.
• Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Worked extensively on BI Answers to create the reports as per the client requirements.
• Created and modified the request, modified the result layout and added filters to them according to the need f the end-users.
• Configured reports to deliver analytics content-based alerts as per user requirements.

Environment: Oracle Business Intelligence 10.1.3.2, Oracle 10g, TOAD.

SQL Developer

Confidential

Responsibilities:

• Communicated with business analyst and various end users for gathering the required requirements to setup the environment.
• Installed and configured the OBIEE 10.1.3.2 server.
• Participated in all the meetings for gatherings business requirements with end - users and business people.
• Working closely with Business Analysts and DBAs on physical database design.
• Created/Modified Metadata repository (.RPD) and Configured Metadata Objects using Siebel Analytics Server Admin tool.
• Extensively used OBIEE Admin tool to import the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool.
• Configured measures in the Business Model Layer and mapped to multiple logical source tables.
• Implemented Security by creating role, responsibility, and web groups using LDAP Authentication
• Built Interactive Dashboards with drill-down capabilities, use of global prompts and Presentation variables
• Successfully developed row based calculations in a pivot table for the reports based on RPD.
• Created session variables for users to provide row- level (data level) security and used the session variable in OBIEE answers to build the query.
• Performed Unit, Integration, and Regression testing to validate report and mapping functionality.

Environment: Oracle 10g, oracle 9i, SQL Server 2000, Toad, SQL, PL/SQL, HTML.